DBA Data[Home] [Help]

APPS.JTF_DIAG_REPORT_FACTORY SQL Statements

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

Line: 24

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

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

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

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

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

                      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: 140

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

		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 form_ui_node_id from dual;
Line: 199

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

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

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

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

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

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

		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: 441

		select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;