eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_POST_PROCESS_MESSAGE_PVT dependencies on EGO_UCCNET_EVENTS

Line 35: l_current_message_id EGO_UCCNET_EVENTS.MESSAGE_ID%TYPE;

31: l_confirmation_message_tag XMLTYPE;
32: l_language_code VARCHAR2(2);
33: l_bundles_processed_count NUMBER;
34: l_remaining_bundles_count NUMBER;
35: l_current_message_id EGO_UCCNET_EVENTS.MESSAGE_ID%TYPE;
36: l_previous_message_id EGO_UCCNET_EVENTS.MESSAGE_ID%TYPE;
37: l_current_bundle_id MTL_ITEM_BULKLOAD_RECS.BUNDLE_ID%TYPE;
38:
39: EGO_NO_BUNDLES_IN_COLLECTION EXCEPTION;

Line 36: l_previous_message_id EGO_UCCNET_EVENTS.MESSAGE_ID%TYPE;

32: l_language_code VARCHAR2(2);
33: l_bundles_processed_count NUMBER;
34: l_remaining_bundles_count NUMBER;
35: l_current_message_id EGO_UCCNET_EVENTS.MESSAGE_ID%TYPE;
36: l_previous_message_id EGO_UCCNET_EVENTS.MESSAGE_ID%TYPE;
37: l_current_bundle_id MTL_ITEM_BULKLOAD_RECS.BUNDLE_ID%TYPE;
38:
39: EGO_NO_BUNDLES_IN_COLLECTION EXCEPTION;
40: PRAGMA EXCEPTION_INIT( EGO_NO_BUNDLES_IN_COLLECTION, -20000 );

Line 52: FROM EGO_UCCNET_EVENTS eue

48: XMLELEMENT( "ItemIdentification",
49: XMLELEMENT( "EBOID" ),
50: XMLELEMENT( "GTIN",
51: ( SELECT eue.GTIN
52: FROM EGO_UCCNET_EVENTS eue
53: WHERE eue.CLN_ID = euaci.CLN_ID
54: AND eue.SOURCE_SYSTEM_ID = euaci.SOURCE_SYSTEM_ID
55: AND eue.SOURCE_SYSTEM_REFERENCE = euaci.SOURCE_SYSTEM_REFERENCE )
56: )

Line 124: FROM EGO_UCCNET_EVENTS eue

120: XMLELEMENT( "Code", c_message_status )
121: ),
122: c_item_response_tags
123: ) AS ITEM_LINE_RESPONSE_TAG
124: FROM EGO_UCCNET_EVENTS eue
125: WHERE
126: eue.CLN_ID = c_bundle_id
127: AND ROWNUM = 1;
128:

Line 141: FROM EGO_UCCNET_EVENTS eue,

137: BUNDLE_ID
138: FROM
139: ( SELECT eue.MESSAGE_ID MESSAGE_ID,
140: mibr.BUNDLE_ID BUNDLE_ID
141: FROM EGO_UCCNET_EVENTS eue,
142: MTL_ITEM_BULKLOAD_RECS mibr
143: WHERE
144: eue.CLN_ID = mibr.BUNDLE_ID
145: AND mibr.BUNDLE_COLLECTION_ID = c_bundle_collection_id

Line 300: FROM EGO_UCCNET_EVENTS eue,

296: BUNDLE_ID
297: FROM
298: ( SELECT eue.MESSAGE_ID MESSAGE_ID,
299: mibr.BUNDLE_ID BUNDLE_ID
300: FROM EGO_UCCNET_EVENTS eue,
301: MTL_ITEM_BULKLOAD_RECS mibr
302: WHERE
303: eue.CLN_ID = mibr.BUNDLE_ID
304: AND mibr.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value )

Line 374: UPDATE EGO_UCCNET_EVENTS

370: IF ( p_message_status IN ( EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_SYNC_MESSAGE_TYPE
371: , EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_REJECTED_MESSAGE_TYPE ) )
372: THEN
373:
374: UPDATE EGO_UCCNET_EVENTS
375: SET DISPOSITION_DATE = l_sysdate
376: WHERE ( CLN_ID ) IN
377: ( SELECT mibr.BUNDLE_ID
378: FROM

Line 385: FROM EGO_UCCNET_EVENTS eue,

381: BUNDLE_ID
382: FROM
383: ( SELECT eue.MESSAGE_ID MESSAGE_ID,
384: mibr.BUNDLE_ID BUNDLE_ID
385: FROM EGO_UCCNET_EVENTS eue,
386: MTL_ITEM_BULKLOAD_RECS mibr
387: WHERE
388: eue.CLN_ID = mibr.BUNDLE_ID
389: AND mibr.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value )

Line 412: FROM EGO_UCCNET_EVENTS eue,

408: BUNDLE_ID
409: FROM
410: ( SELECT eue.MESSAGE_ID MESSAGE_ID,
411: mibr.BUNDLE_ID BUNDLE_ID
412: FROM EGO_UCCNET_EVENTS eue,
413: MTL_ITEM_BULKLOAD_RECS mibr
414: WHERE
415: eue.CLN_ID = mibr.BUNDLE_ID
416: AND mibr.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value )

Line 429: UPDATE EGO_UCCNET_EVENTS

425:
426: ELSIF ( p_message_status = EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_REVIEW_MESSAGE_TYPE )
427: THEN
428:
429: UPDATE EGO_UCCNET_EVENTS
430: SET DISPOSITION_DATE = l_sysdate
431: WHERE ( CLN_ID, SOURCE_SYSTEM_ID, SOURCE_SYSTEM_REFERENCE ) IN
432: ( SELECT mibr.BUNDLE_ID, mibr.SOURCE_SYSTEM_ID, mibr.SOURCE_SYSTEM_REFERENCE
433: FROM

Line 440: FROM EGO_UCCNET_EVENTS eue,

436: BUNDLE_ID
437: FROM
438: ( SELECT eue.MESSAGE_ID MESSAGE_ID,
439: mibr.BUNDLE_ID BUNDLE_ID
440: FROM EGO_UCCNET_EVENTS eue,
441: MTL_ITEM_BULKLOAD_RECS mibr
442: WHERE
443: eue.CLN_ID = mibr.BUNDLE_ID
444: AND mibr.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value )

Line 467: FROM EGO_UCCNET_EVENTS eue,

463: BUNDLE_ID
464: FROM
465: ( SELECT eue.MESSAGE_ID MESSAGE_ID,
466: mibr.BUNDLE_ID BUNDLE_ID
467: FROM EGO_UCCNET_EVENTS eue,
468: MTL_ITEM_BULKLOAD_RECS mibr
469: WHERE
470: eue.CLN_ID = mibr.BUNDLE_ID
471: AND mibr.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value )

Line 551: UPDATE EGO_UCCNET_EVENTS

547: FOR i IN p_bundle_id_tbl.FIRST .. p_bundle_id_tbl.LAST
548: LOOP
549:
550: -- Update all the items in the bundle
551: UPDATE EGO_UCCNET_EVENTS
552: SET DISPOSITION_CODE = p_message_type_code
553: , LAST_UPDATED_BY = l_last_updated_by
554: , LAST_UPDATE_DATE = l_sysdate
555: , LAST_UPDATE_LOGIN = l_last_update_login

Line 588: FROM EGO_UCCNET_EVENTS

584: , l_sysdate
585: , l_last_updated_by
586: , l_sysdate
587: , l_last_update_login
588: FROM EGO_UCCNET_EVENTS
589: WHERE
590: CLN_ID = TO_NUMBER( p_bundle_id_tbl(i) ) ;
591:
592: END LOOP;

Line 600: UPDATE EGO_UCCNET_EVENTS

596:
597: FOR i IN p_bundle_id_tbl.FIRST .. p_bundle_id_tbl.LAST
598: LOOP
599:
600: UPDATE EGO_UCCNET_EVENTS
601: SET DISPOSITION_CODE = p_message_type_code
602: , LAST_UPDATED_BY = l_last_updated_by
603: , LAST_UPDATE_DATE = l_sysdate
604: , LAST_UPDATE_LOGIN = l_last_update_login