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_POST_PROCESS_MESSAGE_PVT

Line 1: PACKAGE BODY EGO_POST_PROCESS_MESSAGE_PVT AS

1: PACKAGE BODY EGO_POST_PROCESS_MESSAGE_PVT AS
2: /* $Header: EGOVPPMB.pls 120.8 2011/06/15 10:25:05 evwang ship $ */
3:
4: PROCEDURE Get_Canonical_CIC_Multi
5: (

Line 98: AND euaci.LAST_UPDATE_DATE = TO_DATE ( p_last_update_date, EGO_POST_PROCESS_MESSAGE_PVT.G_DATE_FORMAT )

94: AND status_lkup.ENABLED_FLAG = 'Y'
95: AND ( status_lkup.END_DATE_ACTIVE IS NULL OR status_lkup.END_DATE_ACTIVE > SYSDATE )
96: AND status_lkup.LOOKUP_CODE = euaci.CODE
97: AND status_lkup.LOOKUP_TYPE = 'EGO_ORCH_STATUS_CODE'
98: AND euaci.LAST_UPDATE_DATE = TO_DATE ( p_last_update_date, EGO_POST_PROCESS_MESSAGE_PVT.G_DATE_FORMAT )
99: AND ( euaci.CODE IS NOT NULL )
100: AND euaci.MESSAGE_SENT_FLAG = 'N'
101: AND euaci.SOURCE_SYSTEM_REFERENCE = mibr.SOURCE_SYSTEM_REFERENCE
102: AND euaci.SOURCE_SYSTEM_ID = mibr.SOURCE_SYSTEM_ID

Line 187: IF ( p_message_status <> EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_SYNC_MESSAGE_TYPE )

183: l_current_message_id := l_bundle_rec.message_id;
184: l_current_bundle_id := l_bundle_rec.bundle_id;
185:
186: -- Do not append status information for Synchronized message.
187: IF ( p_message_status <> EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_SYNC_MESSAGE_TYPE )
188: THEN
189:
190: -- Create item level response tags.
191: FOR l_item_response_tag_rec IN get_item_response_tags ( TO_NUMBER ( p_pk1_value )

Line 370: IF ( p_message_status IN ( EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_SYNC_MESSAGE_TYPE

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.
369:
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

Line 371: , EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_REJECTED_MESSAGE_TYPE ) )

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.
369:
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

Line 402: AND LAST_UPDATE_DATE = TO_DATE ( p_last_update_date, EGO_POST_PROCESS_MESSAGE_PVT.G_DATE_FORMAT )

398:
399: UPDATE EGO_UCCNET_ADD_CIC_INFO
400: SET MESSAGE_SENT_FLAG = 'Y'
401: WHERE MESSAGE_SENT_FLAG = 'N'
402: AND LAST_UPDATE_DATE = TO_DATE ( p_last_update_date, EGO_POST_PROCESS_MESSAGE_PVT.G_DATE_FORMAT )
403: AND ( CLN_ID ) IN
404: ( SELECT mibr_outer.BUNDLE_ID
405: FROM
406: ( SELECT ROWNUM RN,

Line 426: ELSIF ( p_message_status = EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_REVIEW_MESSAGE_TYPE )

422: mibr_outer.BUNDLE_ID = selected_bundles.BUNDLE_ID
423: AND selected_bundles.RN BETWEEN p_start_index AND ( p_start_index + p_bundles_window_size - 1 )
424: AND mibr_outer.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value ) );
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

Line 457: AND LAST_UPDATE_DATE = TO_DATE ( p_last_update_date, EGO_POST_PROCESS_MESSAGE_PVT.G_DATE_FORMAT )

453:
454: UPDATE EGO_UCCNET_ADD_CIC_INFO
455: SET MESSAGE_SENT_FLAG = 'Y'
456: WHERE MESSAGE_SENT_FLAG = 'N'
457: AND LAST_UPDATE_DATE = TO_DATE ( p_last_update_date, EGO_POST_PROCESS_MESSAGE_PVT.G_DATE_FORMAT )
458: AND ( CLN_ID, SOURCE_SYSTEM_ID, SOURCE_SYSTEM_REFERENCE ) IN
459: ( SELECT mibr_outer.BUNDLE_ID, mibr_outer.SOURCE_SYSTEM_ID, mibr_outer.SOURCE_SYSTEM_REFERENCE
460: FROM
461: ( SELECT ROWNUM RN,

Line 528: SELECT SYSDATE, TO_CHAR ( SYSDATE, EGO_POST_PROCESS_MESSAGE_PVT.G_DATE_FORMAT )

524: -- If null then take the sysdate
525: IF ( p_last_update_date IS NULL )
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

Line 534: l_sysdate := TO_DATE ( p_last_update_date, EGO_POST_PROCESS_MESSAGE_PVT.G_DATE_FORMAT );

530: FROM DUAL;
531:
532: ELSE
533:
534: l_sysdate := TO_DATE ( p_last_update_date, EGO_POST_PROCESS_MESSAGE_PVT.G_DATE_FORMAT );
535: l_last_update_date := p_last_update_date;
536:
537: END IF;
538:

Line 542: IF ( p_message_type_code IN ( EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_SYNC_MESSAGE_TYPE

538:
539: -- For Accepted, Reject and Synchronized message, update the entire hierarchy.
540: -- Also insert the rows for all items in the bundle into cic_info table
541:
542: IF ( p_message_type_code IN ( EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_SYNC_MESSAGE_TYPE
543: , EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_REJECTED_MESSAGE_TYPE
544: , EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_ACCEPTED_MESSAGE_TYPE ) )
545: THEN
546:

Line 543: , EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_REJECTED_MESSAGE_TYPE

539: -- For Accepted, Reject and Synchronized message, update the entire hierarchy.
540: -- Also insert the rows for all items in the bundle into cic_info table
541:
542: IF ( p_message_type_code IN ( EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_SYNC_MESSAGE_TYPE
543: , EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_REJECTED_MESSAGE_TYPE
544: , EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_ACCEPTED_MESSAGE_TYPE ) )
545: THEN
546:
547: FOR i IN p_bundle_id_tbl.FIRST .. p_bundle_id_tbl.LAST

Line 544: , EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_ACCEPTED_MESSAGE_TYPE ) )

540: -- Also insert the rows for all items in the bundle into cic_info table
541:
542: IF ( p_message_type_code IN ( EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_SYNC_MESSAGE_TYPE
543: , EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_REJECTED_MESSAGE_TYPE
544: , EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_ACCEPTED_MESSAGE_TYPE ) )
545: THEN
546:
547: FOR i IN p_bundle_id_tbl.FIRST .. p_bundle_id_tbl.LAST
548: LOOP

Line 594: ELSIF ( p_message_type_code = EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_REVIEW_MESSAGE_TYPE )

590: CLN_ID = TO_NUMBER( p_bundle_id_tbl(i) ) ;
591:
592: END LOOP;
593:
594: ELSIF ( p_message_type_code = EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_REVIEW_MESSAGE_TYPE )
595: THEN
596:
597: FOR i IN p_bundle_id_tbl.FIRST .. p_bundle_id_tbl.LAST
598: LOOP

Line 813: EGO_POST_PROCESS_MESSAGE_PVT.Update_Corrective_Info(

809:
810: l_total_bundles := l_total_bundles + l_bundle_id_tbl.COUNT;
811:
812: -- add the status and corrective info
813: EGO_POST_PROCESS_MESSAGE_PVT.Update_Corrective_Info(
814: p_bundle_id_tbl => l_bundle_id_tbl,
815: p_source_system_id_tbl => l_source_system_id_tbl,
816: p_source_system_ref_tbl => l_source_system_ref_tbl,
817: p_message_type_code => EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_SYNC_MESSAGE_TYPE,

Line 817: p_message_type_code => EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_SYNC_MESSAGE_TYPE,

813: EGO_POST_PROCESS_MESSAGE_PVT.Update_Corrective_Info(
814: p_bundle_id_tbl => l_bundle_id_tbl,
815: p_source_system_id_tbl => l_source_system_id_tbl,
816: p_source_system_ref_tbl => l_source_system_ref_tbl,
817: p_message_type_code => EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_SYNC_MESSAGE_TYPE,
818: p_status_code => NULL,
819: p_corrective_action_code => NULL,
820: p_additional_info => NULL,
821: p_last_update_date => l_last_update_date,

Line 901: p_processing_type => EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_SYNC_MESSAGE_TYPE,

897: p_pk2_value => NULL,
898: p_pk3_value => NULL,
899: p_pk4_value => NULL,
900: p_pk5_value => NULL,
901: p_processing_type => EGO_POST_PROCESS_MESSAGE_PVT.G_CIC_SYNC_MESSAGE_TYPE,
902: p_language_code => USERENV('LANG'),
903: p_last_update_date => l_last_update_date,
904: x_msg_data => l_msg_data,
905: x_return_status => l_return_status

Line 930: END EGO_POST_PROCESS_MESSAGE_PVT;

926: x_msg_data := SQLERRM;
927:
928: END Send_Sync_Msg_On_Batch_Import;
929:
930: END EGO_POST_PROCESS_MESSAGE_PVT;