DBA Data[Home] [Help]

APPS.PN_DEBUG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 237

    SELECT DECODE(x_Process,'PLSQL','PLSQL','SQL','SQL','REPORT',
                'REPORT','FORM','FORM','PLSQL'),
        DECODE(x_Write_File,'LOG','LOG','OUT','OUT','LOG')
    INTO G_Process, G_WriteFile
    FROM dual;
Line: 250

       SELECT DECODE(G_WriteFile,'LOG',Fnd_File.LOG,Fnd_File.OUTPUT )
       INTO   G_WriteFileID
       FROM dual;
Line: 621

    G_Function_Stack.DELETE(G_Function_Counter);