What is cursor and types of cursor?

The oracle engine uses a work area for its internal processing in order to execute an SQL statement. This work area is private to SQL’s operations and is called a cursor.

Implicit Cursor: Implicit cursor is declared by pl/sql implicitly for all DML statement & for single row.

Explicit Cursor: Explicit cursors are declare explicitly by the user, explicit cursor are for queries only  and allow multiple rows to be processed from the query Defined in the declare section of the plsql block.

You have made it like:

Cursor C1 is select ename from emp;

Ref Cursor: Ref Cursor is object name of the cursor type. It’s mainly used for dynamic purpose.

TYPE ref_type_name IS REF CURSOR [RETURN return_type]
TYPE empcurtype IS REF CURSOR [RETURN emp%type]

Can we call function with return as “BOOLEAN” in select statement?

No, error comes

ORA-06552: PL/SQL: Statement ignored

ORA-06553: PLS-382: expression is of wrong type

What is Interface Trip Stop?

ITS is triggered at the time of shipping if the option ‘defer interface’ is not checked (By Default this check box is uncheck only). When this report is run, it performs two main things:

Update the order management (OE_ORDER_LINES_ALL)

Trigger the inventory interface (TO UPDATE Inventory tables)

In First part it make update on oe_order_lines_all table as well as wsh_delivery_details and once this part executed successfully only then SECOND phase of ITS has triggered. If FIRST part error out for some reason then 2nd part will not be triggered, and even if you try to submit? Inventory Interface?, it will not pick up you data. Reason ? it will validate and check if oe_interfaced_flag in wsh_delivery_details table is Y or not. If it is N or X ?inventory Interface? will not pick that record for processing.

Explain Bill of Lading?

It is a legal document between the shipper of a particular item and the carrier detailing the type, quantity and destination of the good being carried

The bill of lading also serves as a receipt of shipment when the good is delivered to the predetermined destination. This document must accompany the shipped goods, no matter the form of transportation, and must be signed by an authorized representative from the carrier, shipper and receiver.

how to make concurrent program to wait to complete another concurrent program

fnd_concurrent.wait_for_request

how to change the report layout in runtime into excel or pdf

By using the fnd_request.add_layout

   IF p_output_type = 'PDF'

   THEN

      p_call_status1 :=

         fnd_request.add_layout ('ONT',

                                 'ONT_REV_REG_RPT',

                                 'en',

                                 'US',

                                 'PDF'

                                );

   ELSIF p_output_type = 'EXCEL'

   THEN

      p_call_status1 :=

         fnd_request.add_layout ('ONT',

                                 'ONT_REV_REG_RPT_EXL',

                                 'en',

                                 'US',

                                 'EXCEL'

                                );

   END IF;

How many trigger event at Form Personalization level.

WHEN-NEW-FORM-INSTANCE

WHEN-NEW-BLOCK-INSTANCE

WHEN-NEW-RECORD-INSTANCE

WHEN-NEW-ITEM-INSTANCE

WHEN-VALIDATE-RECORD

How to Migrate Form Personalization From one Instance to Another

By using FNDLOAD, you can either Download for a specific form or specfic function of the form. In both the case same affrmcus.lct is used.

Syntax:

Download -specific form

FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <filename.ldt> FND_FORM_CUSTOM_RULES form_name=<form name>

Download -for all personalizations

FNDLOAD <userid>/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <filename.ldt> FND_FORM_CUSTOM_RULES function_name=<function name>

·         Function_name is a required parameter

·         You cann't download lct file without any supplied value.

Upload
FNDLOAD <userid>/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct <filename.ldt>

 

Example:

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct xxoexoeord.lct FND_FORM_CUSTOM_RULES form_name= OEXOEORD

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct xxoexoeord.lct