APPS.CLN_SYNC_INVENTORY_PKG dependencies on DUAL

Line 99: SELECT cln_generic_s.nextval INTO l_event_key FROM Dual;

95: IF (l_Debug_Level <= 1) THEN
96: cln_debug_pub.Add('Setting Event Key....',1);
97: END IF;
98:
99: SELECT cln_generic_s.nextval INTO l_event_key FROM Dual;
100: IF (l_Debug_Level <= 1) THEN
101: cln_debug_pub.Add('Event Key set as - '||l_event_key,1);
102:
103: cln_debug_pub.Add('Getting Trading Partner Details Using Tp_Header_Id',1);

Line 142: SELECT cln_generic_s.nextval INTO l_xmlg_document_id FROM Dual;

138: IF (l_Debug_Level <= 1) THEN
139: cln_debug_pub.Add('Defaulting XMLG Document ID with a running sequence',1);
140: END IF;
141:
142: SELECT cln_generic_s.nextval INTO l_xmlg_document_id FROM Dual;
143:
144: IF (l_Debug_Level <= 1) THEN
145: cln_debug_pub.Add('Defaulting Documnet No with sysdate',1);
146: END IF;

Line 149: SELECT TO_CHAR(cln_sync_inv_doc_s.nextval) INTO l_doc_number FROM Dual;

145: cln_debug_pub.Add('Defaulting Documnet No with sysdate',1);
146: END IF;
147:
148:
149: SELECT TO_CHAR(cln_sync_inv_doc_s.nextval) INTO l_doc_number FROM Dual;
150:
151: IF (l_Debug_Level <= 1) THEN
152: cln_debug_pub.Add('Checking for user input.....',1);
153: END IF;

Line 157: SELECT 'x' INTO l_dummy_check FROM DUAL

153: END IF;
154:
155: BEGIN
156: --SELECT inventory_item_id
157: SELECT 'x' INTO l_dummy_check FROM DUAL
158: WHERE EXISTS(
159: SELECT 'x'
160: FROM CLN_INVENTORY_REPORT_V
161: WHERE organization_id = p_inv_org