APPS.EGO_POST_PROCESS_MESSAGE_PVT dependencies on DUAL

Line 165: FROM DUAL;

161: XMLELEMENT( "ID" )
162: )
163: )
164: INTO l_header_tag
165: FROM DUAL;
166:
167: l_language_code := p_language_code;
168: l_bundles_processed_count := 0;
169: l_data_area_tags := NULL;

Line 197: FROM DUAL;

193: , l_language_code )
194: LOOP
195: SELECT XMLCONCAT( l_item_response_tags, l_item_response_tag_rec.item_response_tag )
196: INTO l_item_response_tags
197: FROM DUAL;
198: END LOOP;
199:
200: END IF;
201:

Line 217: FROM DUAL;

213:
214: -- Same message id bundle
215: SELECT XMLCONCAT( l_item_line_response_tags, l_item_line_response_tag )
216: INTO l_item_line_response_tags
217: FROM DUAL;
218:
219: ELSE
220:
221: -- Bundle id belonging to different message id

Line 239: FROM DUAL;

235: ),
236: l_data_area_tags
237: )
238: INTO l_data_area_tags
239: FROM DUAL;
240:
241: -- initialize item line response tags for new message that will belong to new data area
242: l_item_line_response_tags := NULL;
243: SELECT XMLCONCAT( l_item_line_response_tags, l_item_line_response_tag )

Line 245: FROM DUAL;

241: -- initialize item line response tags for new message that will belong to new data area
242: l_item_line_response_tags := NULL;
243: SELECT XMLCONCAT( l_item_line_response_tags, l_item_line_response_tag )
244: INTO l_item_line_response_tags
245: FROM DUAL;
246:
247: END IF;
248:
249: l_previous_message_id := l_current_message_id;

Line 278: FROM DUAL;

274: ),
275: l_data_area_tags
276: )
277: INTO l_data_area_tags
278: FROM DUAL;
279:
280: -- Create confirmation message tag
281: SELECT
282: XMLELEMENT( "SyncItemPublicationConfirmationEBM",

Line 288: DUAL;

284: l_data_area_tags
285: )
286: INTO l_confirmation_message_tag
287: FROM
288: DUAL;
289:
290: -- update the remaining bundles in collection count.
291: SELECT COUNT(1)
292: INTO l_remaining_bundles_count

Line 364: FROM DUAL;

360: BEGIN
361:
362: SELECT SYSDATE
363: INTO l_sysdate
364: FROM DUAL;
365:
366: -- For Reject and Synchronized message, update the message sent info for entire hierarchy.
367: -- Not updating the last update date otherwise it can bring inconsistency between message type
368: -- in EVENTS table and max last update date row ADD_CIC_INFO table.

Line 530: FROM DUAL;

526: THEN
527:
528: SELECT SYSDATE, TO_CHAR ( SYSDATE, EGO_POST_PROCESS_MESSAGE_PVT.G_DATE_FORMAT )
529: INTO l_sysdate, l_last_update_date
530: FROM DUAL;
531:
532: ELSE
533:
534: l_sysdate := TO_DATE ( p_last_update_date, EGO_POST_PROCESS_MESSAGE_PVT.G_DATE_FORMAT );

Line 750: FROM DUAL )

746: AND eit.SET_PROCESS_ID = c_batch_id
747: AND ROWNUM = 1 )
748: */
749: ,( SELECT 'S'
750: FROM DUAL )
751: )
752: AND msii.TOP_ITEM_FLAG = 'Y'
753: AND msii.BUNDLE_ID = selected_bundles.BUNDLE_ID
754: AND msii.SET_PROCESS_ID = c_batch_id;

Line 843: FROM DUAL;

839: XMLELEMENT ( "ItemSourceSystemReference", l_source_system_ref_tbl(i) )
840: )
841: )
842: INTO l_item_bundle_tags
843: FROM DUAL;
844:
845: END LOOP; -- end FOR i IN l_bundle_id_tbl
846:
847: ELSE

Line 876: FROM DUAL;

872: SELECT XMLELEMENT ( "ItemBundles",
873: l_item_bundle_tags
874: )
875: INTO l_item_bundles_tag
876: FROM DUAL;
877:
878: /*Fix for Bug 11885567 to deprecate Inbound Sync
879: -- create collection over successful top items
880: EGO_ORCHESTRATION_UTIL_PUB.ADD_BUNDLES_TO_COL(