[Home] [Help]
PACKAGE: APPS.M4U_DMD_REQUESTS
Source
1 PACKAGE m4u_dmd_requests AS
2 /* $Header: M4UDREQS.pls 120.1 2007/09/12 06:57:59 bsaratna noship $ */
3
4 PROCEDURE create_request
5 (
6 p_type IN VARCHAR2,
7 p_direction IN VARCHAR2,
8 p_status IN VARCHAR2 := NULL,
9 p_ref_msg_id IN VARCHAR2 := NULL,
10 p_orig_msg_id IN VARCHAR2 := NULL,
11 p_msg_timstamp IN DATE := NULL,
12 p_payload_id IN VARCHAR2 := NULL,
13 p_sender_gln IN VARCHAR2 := NULL,
14 p_receiver_gln IN VARCHAR2 := NULL,
15 p_rep_party_gln IN VARCHAR2 := NULL,
16 p_user_gln IN VARCHAR2 := NULL,
17 p_user_id IN VARCHAR2 := NULL,
18 x_msg_id OUT NOCOPY VARCHAR2,
19 x_ret_sts OUT NOCOPY VARCHAR2,
20 x_ret_msg OUT NOCOPY VARCHAR2
21 );
22
23 PROCEDURE create_payload
24 (
25 p_xml IN CLOB,
26 p_type IN VARCHAR2,
27 p_dir IN VARCHAR2,
28 x_payload_id OUT NOCOPY VARCHAR2,
29 x_ret_sts OUT NOCOPY VARCHAR2,
30 x_ret_msg OUT NOCOPY VARCHAR2
31 );
32
33
34 PROCEDURE create_document
35 (
36 p_msg_id IN VARCHAR2,
37 p_type IN VARCHAR2,
38 p_action IN VARCHAR2,
39 p_doc_status IN VARCHAR2,
40 p_func_status IN VARCHAR2,
41 p_timestamp IN DATE := NULL,
42 p_processing_msg IN VARCHAR2 := NULL,
43 p_ref_doc_id IN VARCHAR2 := NULL,
44 p_orig_doc_id IN VARCHAR2 := NULL,
45 p_top_gtin IN VARCHAR2 := NULL,
46 p_info_provider_gln IN VARCHAR2 := NULL,
47 p_data_rcpt_gln IN VARCHAR2 := NULL,
48 p_tgt_mkt_ctry IN VARCHAR2 := NULL,
49 p_tgt_mkt_div IN VARCHAR2 := NULL,
50 p_param1 IN VARCHAR2 := NULL,
51 p_param2 IN VARCHAR2 := NULL,
52 p_param3 IN VARCHAR2 := NULL,
53 p_param4 IN VARCHAR2 := NULL,
54 p_param5 IN VARCHAR2 := NULL,
55 p_lparam1 IN VARCHAR2 := NULL,
56 p_lparam2 IN VARCHAR2 := NULL,
57 p_lparam3 IN VARCHAR2 := NULL,
58 p_lparam4 IN VARCHAR2 := NULL,
59 p_lparam5 IN VARCHAR2 := NULL,
60 p_payload_id IN VARCHAR2 := NULL,
61 p_payload_dir IN VARCHAR2 := NULL,
62 p_payload_type IN VARCHAR2 := NULL,
63 x_doc_id OUT NOCOPY VARCHAR2,
64 x_ret_sts OUT NOCOPY VARCHAR2,
65 x_ret_msg OUT NOCOPY VARCHAR2
66 );
67
68
69 PROCEDURE retry_request
70 (
71 x_errbuf OUT NOCOPY VARCHAR2,
72 x_retcode OUT NOCOPY NUMBER,
73 p_msg_id IN VARCHAR2,
74 p_mode IN VARCHAR2,
75 p_time IN DATE
76 );
77
78
79 PROCEDURE update_request
80 (
81 p_msg_id IN VARCHAR2,
82 p_status IN VARCHAR2,
83 p_update_doc_flag IN VARCHAR2,
84 p_retry_count IN NUMBER,
85 p_ref_msg_id IN VARCHAR2 := NULL,
86 p_orig_msg_id IN VARCHAR2 := NULL,
87 p_msg_timstamp IN DATE := NULL,
88
89 p_sender_gln IN VARCHAR2 := NULL,
90 p_receiver_gln IN VARCHAR2 := NULL,
91 p_rep_party_gln IN VARCHAR2 := NULL,
92 p_user_id IN VARCHAR2 := NULL,
96 p_bpel_process_id IN VARCHAR2 := NULL,
93 p_user_gln IN VARCHAR2 := NULL,
94
95 p_bpel_instance_id IN VARCHAR2 := NULL,
97
98 p_doc_type IN VARCHAR2,
99 p_doc_status IN VARCHAR2 := NULL,
100 p_func_status IN VARCHAR2 := NULL,
101 p_processing_msg IN VARCHAR2 := NULL,
102
103 p_payload IN CLOB := NULL,
104 p_payload_dir IN VARCHAR2 := NULL,
105 p_payload_type IN VARCHAR2 := NULL,
106
107 x_ret_sts OUT NOCOPY VARCHAR2,
108 x_ret_msg OUT NOCOPY VARCHAR2
109 );
110
111 PROCEDURE update_document
112 (
113 p_doc_id IN VARCHAR2,
114 p_doc_status IN VARCHAR2,
115 p_func_status IN VARCHAR2,
116 p_retry_count IN NUMBER,
117 p_processing_msg IN VARCHAR2 := NULL,
118 p_ref_doc_id IN VARCHAR2 := NULL,
119 p_orig_doc_id IN VARCHAR2 := NULL,
120 p_timestamp IN VARCHAR2 := NULL,
121
122 p_top_gtin IN VARCHAR2 := NULL,
123 p_info_provider_gln IN VARCHAR2 := NULL,
124 p_data_recepient_gln IN VARCHAR2 := NULL,
125 p_tgt_mkt_cntry IN VARCHAR2 := NULL,
126 p_tgt_mkt_subdiv IN VARCHAR2 := NULL,
127
128 p_param1 IN VARCHAR2 := NULL,
129 p_param2 IN VARCHAR2 := NULL,
130 p_param3 IN VARCHAR2 := NULL,
131 p_param4 IN VARCHAR2 := NULL,
132 p_param5 IN VARCHAR2 := NULL,
133 p_lparam1 IN VARCHAR2 := NULL,
134 p_lparam2 IN VARCHAR2 := NULL,
135 p_lparam3 IN VARCHAR2 := NULL,
136 p_lparam4 IN VARCHAR2 := NULL,
137 p_lparam5 IN VARCHAR2 := NULL,
138
139 p_payload_id IN VARCHAR2 := NULL,
140 p_payload_dir IN VARCHAR2 := NULL,
141 p_payload_type IN VARCHAR2 := NULL,
142 x_ret_sts OUT NOCOPY VARCHAR2,
143 x_ret_msg OUT NOCOPY VARCHAR2
144 );
145
146
147
148 END m4u_dmd_requests;