DBA Data[Home] [Help]

APPS.CLN_PO_CHANGE_RESPONSE_PKG dependencies on DUAL

Line 158: SELECT cln_generic_s.nextval INTO l_xmlg_document_id FROM dual;

154: IF (l_Debug_Level <= 1) THEN
155: cln_debug_pub.Add('Defaulting XMLG Document ID with a running sequence',1);
156: END IF;
157:
158: SELECT cln_generic_s.nextval INTO l_xmlg_document_id FROM dual;
159:
160:
161: IF (l_Debug_Level <= 1) THEN
162: cln_debug_pub.Add('Setting the value for ACKCODE at header level - ',1);

Line 185: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

181: IF (l_Debug_Level <= 1) THEN
182: cln_debug_pub.Add('Setting Event Key....',1);
183: END IF;
184:
185: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
186: IF (l_Debug_Level <= 1) THEN
187: cln_debug_pub.Add('Event Key set as - '||l_event_key,1);
188: END IF;
189: