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 XMLTYPE

Line 18: , x_canonical_cic_payload OUT NOCOPY XMLTYPE

14: , p_language_code IN VARCHAR2
15: , p_start_index IN NUMBER
16: , p_bundles_window_size IN NUMBER
17: , p_last_update_date IN VARCHAR2
18: , x_canonical_cic_payload OUT NOCOPY XMLTYPE
19: , x_bundles_processed_count OUT NOCOPY NUMBER
20: , x_remaining_bundles_count OUT NOCOPY NUMBER
21: , x_return_status OUT NOCOPY VARCHAR2
22: , x_msg_data OUT NOCOPY VARCHAR2

Line 26: l_header_tag XMLTYPE;

22: , x_msg_data OUT NOCOPY VARCHAR2
23: )
24: IS
25:
26: l_header_tag XMLTYPE;
27: l_item_response_tags XMLTYPE;
28: l_item_line_response_tag XMLTYPE;
29: l_item_line_response_tags XMLTYPE;
30: l_data_area_tags XMLTYPE;

Line 27: l_item_response_tags XMLTYPE;

23: )
24: IS
25:
26: l_header_tag XMLTYPE;
27: l_item_response_tags XMLTYPE;
28: l_item_line_response_tag XMLTYPE;
29: l_item_line_response_tags XMLTYPE;
30: l_data_area_tags XMLTYPE;
31: l_confirmation_message_tag XMLTYPE;

Line 28: l_item_line_response_tag XMLTYPE;

24: IS
25:
26: l_header_tag XMLTYPE;
27: l_item_response_tags XMLTYPE;
28: l_item_line_response_tag XMLTYPE;
29: l_item_line_response_tags XMLTYPE;
30: l_data_area_tags XMLTYPE;
31: l_confirmation_message_tag XMLTYPE;
32: l_language_code VARCHAR2(2);

Line 29: l_item_line_response_tags XMLTYPE;

25:
26: l_header_tag XMLTYPE;
27: l_item_response_tags XMLTYPE;
28: l_item_line_response_tag XMLTYPE;
29: l_item_line_response_tags XMLTYPE;
30: l_data_area_tags XMLTYPE;
31: l_confirmation_message_tag XMLTYPE;
32: l_language_code VARCHAR2(2);
33: l_bundles_processed_count NUMBER;

Line 30: l_data_area_tags XMLTYPE;

26: l_header_tag XMLTYPE;
27: l_item_response_tags XMLTYPE;
28: l_item_line_response_tag XMLTYPE;
29: l_item_line_response_tags XMLTYPE;
30: l_data_area_tags XMLTYPE;
31: l_confirmation_message_tag XMLTYPE;
32: l_language_code VARCHAR2(2);
33: l_bundles_processed_count NUMBER;
34: l_remaining_bundles_count NUMBER;

Line 31: l_confirmation_message_tag XMLTYPE;

27: l_item_response_tags XMLTYPE;
28: l_item_line_response_tag XMLTYPE;
29: l_item_line_response_tags XMLTYPE;
30: l_data_area_tags XMLTYPE;
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;

Line 109: c_item_response_tags XMLTYPE )

105: AND mibr.BUNDLE_COLLECTION_ID = c_bundle_collection_id;
106:
107: CURSOR get_item_line_response_tag ( c_bundle_id NUMBER,
108: c_message_status VARCHAR2,
109: c_item_response_tags XMLTYPE )
110: IS
111: SELECT
112: XMLELEMENT( "ItemPublicationLineConfirmation",
113: XMLELEMENT( "ItemPublicationLineIdentification",

Line 671: l_item_bundle_tags XMLTYPE;

667:
668: l_bundle_id_tbl EGO_VARCHAR_TBL_TYPE;
669: l_source_system_id_tbl EGO_VARCHAR_TBL_TYPE;
670: l_source_system_ref_tbl EGO_VARCHAR_TBL_TYPE;
671: l_item_bundle_tags XMLTYPE;
672: l_item_bundles_tag XMLTYPE;
673: l_return_status VARCHAR2(100);
674: l_msg_data VARCHAR2(4000);
675: l_last_update_date VARCHAR2(50);

Line 672: l_item_bundles_tag XMLTYPE;

668: l_bundle_id_tbl EGO_VARCHAR_TBL_TYPE;
669: l_source_system_id_tbl EGO_VARCHAR_TBL_TYPE;
670: l_source_system_ref_tbl EGO_VARCHAR_TBL_TYPE;
671: l_item_bundle_tags XMLTYPE;
672: l_item_bundles_tag XMLTYPE;
673: l_return_status VARCHAR2(100);
674: l_msg_data VARCHAR2(4000);
675: l_last_update_date VARCHAR2(50);
676: l_bundle_collection_id NUMBER;