[Home] [Help]
PACKAGE: APPS.EGO_POST_PROCESS_MESSAGE_PVT
Source
1 PACKAGE EGO_POST_PROCESS_MESSAGE_PVT AUTHID CURRENT_USER AS
2 /* $Header: EGOVPPMS.pls 120.3 2007/06/20 13:08:16 bbpatel noship $ */
3
4 -- Message type constants
5 G_CIC_REVIEW_MESSAGE_TYPE CONSTANT VARCHAR2(240) := 'REVIEW';
6 G_CIC_SYNC_MESSAGE_TYPE CONSTANT VARCHAR2(240) := 'SYNCHRONISED';
7 G_CIC_REJECTED_MESSAGE_TYPE CONSTANT VARCHAR2(240) := 'REJECTED';
8 G_CIC_ACCEPTED_MESSAGE_TYPE CONSTANT VARCHAR2(240) := 'ACCEPTED';
9 G_DATE_FORMAT CONSTANT VARCHAR2(50) := 'DD-MON-YYYY HH24:MI:SS';
10
11 PROCEDURE Get_Canonical_CIC_Multi
12 (
13 p_version IN VARCHAR2
14 ,p_entity_name IN VARCHAR2
15 ,p_pk1_value IN VARCHAR2
16 ,p_pk2_value IN VARCHAR2
17 ,p_pk3_value IN VARCHAR2
18 ,p_pk4_value IN VARCHAR2
19 ,p_pk5_value IN VARCHAR2
20 , p_message_status IN VARCHAR2
21 , p_language_code IN VARCHAR2
22 , p_start_index IN NUMBER
23 , p_bundles_window_size IN NUMBER
24 , p_last_update_date IN VARCHAR2
25 , x_canonical_cic_payload OUT NOCOPY XMLTYPE
26 , x_bundles_processed_count OUT NOCOPY NUMBER
27 , x_remaining_bundles_count OUT NOCOPY NUMBER
28 , x_return_status OUT NOCOPY VARCHAR2
29 , x_msg_data OUT NOCOPY VARCHAR2
30 );
31
32 PROCEDURE Update_Message_Sent_Info_Multi
33 (
34 p_version IN VARCHAR2
35 ,p_entity_name IN VARCHAR2
36 ,p_pk1_value IN VARCHAR2
37 ,p_pk2_value IN VARCHAR2
38 ,p_pk3_value IN VARCHAR2
39 ,p_pk4_value IN VARCHAR2
40 ,p_pk5_value IN VARCHAR2
41 , p_message_status IN VARCHAR2
42 , p_start_index IN NUMBER
43 , p_bundles_window_size IN NUMBER
44 , p_commit_flag IN VARCHAR2
45 , p_last_update_date IN VARCHAR2
46 , x_return_status OUT NOCOPY VARCHAR2
47 , x_msg_data OUT NOCOPY VARCHAR2
48 );
49
50 PROCEDURE Update_Corrective_Info
51 (
52 p_bundle_id_tbl IN EGO_VARCHAR_TBL_TYPE
53 , p_source_system_id_tbl IN EGO_VARCHAR_TBL_TYPE
54 , p_source_system_ref_tbl IN EGO_VARCHAR_TBL_TYPE
55 , p_message_type_code IN VARCHAR2
56 , p_status_code IN VARCHAR2
57 , p_corrective_action_code IN VARCHAR2
58 , p_additional_info IN VARCHAR2
59 , p_last_update_date IN VARCHAR2
60 , x_last_update_date OUT NOCOPY VARCHAR2
61 , x_return_status OUT NOCOPY VARCHAR2
62 , x_msg_data OUT NOCOPY VARCHAR2
63 );
64
65 PROCEDURE Send_Sync_Msg_On_Batch_Import
66 (
67 p_batch_id IN NUMBER
68 , p_request_id IN NUMBER
69 , p_commit_flag IN VARCHAR2
70 , x_return_status OUT NOCOPY VARCHAR2
71 , x_msg_data OUT NOCOPY VARCHAR2
72 );
73
74 END EGO_POST_PROCESS_MESSAGE_PVT;