APPS.GR_WF_UTIL_PVT dependencies on DUAL

Line 89: from dual;

85: errbuf varchar2(2000);
86:
87: cursor c1 is
88: select ecx_trigger_id_s.NEXTVAL
89: from dual;
90:
91: BEGIN
92: -- gmi_reservation_util.println('PAL inside OUR GetXMLTP ');
93: -- gmd_pl_log('PAL inside OUR GetXMLTP ');

Line 846: FROM DUAL;

842: p_parameterlist=>l_parameter_list);
843: --gmi_reservation_util.println('PAL l_ws_service_namespace_profile = ' || l_ws_service_namespace_profile);
844: SELECT gr_item_information_seq.nextval
845: INTO l_event_key
846: FROM DUAL;
847: IF SQL%NOTFOUND THEN
848: gmi_reservation_util.println('PAL DUAL - SQL%NOTFOUND ');
849: END IF;
850:

Line 848: gmi_reservation_util.println('PAL DUAL - SQL%NOTFOUND ');

844: SELECT gr_item_information_seq.nextval
845: INTO l_event_key
846: FROM DUAL;
847: IF SQL%NOTFOUND THEN
848: gmi_reservation_util.println('PAL DUAL - SQL%NOTFOUND ');
849: END IF;
850:
851: l_event_name := 'oracle.apps.gr.message.send';
852:

Line 1050: FROM DUAL;

1046: BEGIN
1047: l_itemtype := 'GRTPDCWF';
1048: SELECT gr_item_information_seq.nextval
1049: INTO l_item_code_seq
1050: FROM DUAL;
1051:
1052: l_itemkey := l_item_code_seq ||'-'||to_char(sysdate,'dd-MON-yyyy
1053: HH24:mi:ss');
1054: l_WorkflowProcess := 'GRTPDCHNG_PROCESS';