DBA Data[Home] [Help]

APPS.GR_WF_UTIL_PVT dependencies on GR_ITEM_INFORMATION_SEQ

Line 844: SELECT gr_item_information_seq.nextval

840: p_value=>l_ws_service_namespace_profile,
841: --p_value=>'http://ap6192rt.us.oracle.com/oracle/apps/fnd/XMLGateway',
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 ');

Line 1048: SELECT gr_item_information_seq.nextval

1044: l_item VARCHAR2(32) := NULL;
1045:
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