DBA Data[Home] [Help]

APPS.JTF_DIAG_REPORT_FACTORY SQL Statements

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

Line: 40

		select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
Line: 62

		select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
Line: 80

		select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
Line: 98

		select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
Line: 123

		select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
Line: 128

                      INSERT INTO JTF_DIAGNOSTIC_REPORT
                      (Execution_ID,UI_Node_ID,type,xmldata,parent_node_id)
                      VALUES(exec_id
                      ,note.UI_Node_ID
                      ,'note'
                      ,xmltype(str)
                      ,ui_node_id);
Line: 160

		select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
Line: 178

		select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
Line: 198

		select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
Line: 218

		select JTF_DIAGNOSTIC_REPORT_S.nextval into form_ui_node_id from dual;
Line: 219

		select JTF_DIAGNOSTIC_REPORT_S.nextval into form_data_ui_node_id from dual;
Line: 243

		select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
Line: 307

	select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
Line: 337

	select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
Line: 375

	select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
Line: 390

		select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
Line: 407

		select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
Line: 427

		select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;
Line: 461

		select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;