[Home] [Help]
PACKAGE: APPS.CSI_T_VLDN_ROUTINES_PVT
Source
1 PACKAGE csi_t_vldn_routines_pvt AS
2 /* $Header: csivtvls.pls 120.1 2005/06/17 01:31:51 appldev $ */
3
4 /*-----------------------------------------------------------*/
5 /* Procedure name: Check_Reqd_Param */
6 /* Description : To Check if the reqd parameter is passed */
7 /* Overloading the procedure to handle all the data types */
8 /*-----------------------------------------------------------*/
9
10 PROCEDURE check_reqd_param(
11 p_value IN NUMBER,
12 p_param_name IN VARCHAR2,
13 p_api_name IN VARCHAR2);
14
15 PROCEDURE Check_Reqd_Param(
16 p_value IN VARCHAR2,
17 p_param_name IN VARCHAR2,
18 p_api_name IN VARCHAR2);
19
20 PROCEDURE Check_Reqd_Param(
21 p_value IN DATE,
22 p_param_name IN VARCHAR2,
23 p_api_name IN VARCHAR2);
24
25 PROCEDURE validate_transaction_line_id(
26 p_transaction_line_id IN NUMBER,
27 x_transaction_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
28 x_return_status OUT NOCOPY VARCHAR2);
29
30 PROCEDURE validate_txn_line_detail_id(
31 p_txn_line_detail_id IN NUMBER,
32 x_return_status OUT NOCOPY VARCHAR2);
33
34 -- Added for M-M
35 PROCEDURE validate_txn_line_detail_id(
36 p_txn_line_detail_id IN NUMBER,
37 x_txn_line_detail_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
38 x_return_status OUT NOCOPY VARCHAR2);
39
40 PROCEDURE validate_txn_party_detail_id(
41 p_txn_party_detail_id IN NUMBER,
42 x_return_status OUT NOCOPY VARCHAR2);
43
44 PROCEDURE validate_txn_acct_detail_id(
45 p_txn_acct_detail_id IN NUMBER,
46 x_return_status OUT NOCOPY VARCHAR2);
47
48 PROCEDURE validate_txn_relationship_id(
49 p_txn_relationship_id IN NUMBER,
50 x_return_status OUT NOCOPY VARCHAR2);
51
52 PROCEDURE validate_txn_ou_id(
53 p_txn_operating_unit_id IN NUMBER,
54 x_return_status OUT NOCOPY VARCHAR2);
55
56 PROCEDURE validate_txn_attrib_detail_id(
57 p_txn_attrib_detail_id IN NUMBER,
58 x_return_status OUT NOCOPY VARCHAR2);
59
60 PROCEDURE validate_txn_source_id(
61 p_txn_source_name IN VARCHAR2,
62 p_txn_source_id IN NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2);
64
65 PROCEDURE check_ib_creation(
66 p_transaction_line_id IN NUMBER,
67 x_return_status OUT NOCOPY VARCHAR2);
68
69 PROCEDURE validate_subject_id(
70 p_subject_id IN NUMBER,
71 p_txn_line_dtl_id IN NUMBER,
72 x_return_status OUT NOCOPY VARCHAR2);
73
74 PROCEDURE validate_object_id(
75 p_object_id IN NUMBER,
76 x_return_status OUT NOCOPY VARCHAR2);
77
78 PROCEDURE validate_ii_rltns_type_code(
79 p_rltns_type_code IN VARCHAR2,
80 x_return_status OUT NOCOPY VARCHAR2);
81
82 PROCEDURE validate_instance_party_id(
83 p_instance_id IN number,
84 p_instance_party_id IN number,
85 x_return_status OUT NOCOPY VARCHAR2);
86
87 PROCEDURE check_source_integrity(
88 p_validation_level IN VARCHAR2,
89 p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
90 p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
91 x_return_status OUT NOCOPY VARCHAR2);
92
93 /* used in the main create */
94 PROCEDURE check_party_integrity(
95 p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
96 p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
97 p_party_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
98 x_return_status OUT NOCOPY VARCHAR2);
99
100 PROCEDURE convert_rltns_index_to_ids(
101 p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
102 px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
103 x_return_status OUT NOCOPY varchar2);
104
105 /* used in the standalone party create */
106 PROCEDURE is_valid_owner_for_create(
107 p_txn_line_detail_id IN NUMBER,
108 p_instance_party_id IN NUMBER,
109 x_return_status OUT NOCOPY VARCHAR2);
110
111 -- Added for M-M
112 procedure get_txn_line_dtl_rec(
113 p_index_id IN NUMBER,
114 p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
115 x_txn_line_detail_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
116 x_return_status OUT NOCOPY VARCHAR2);
117
118 PROCEDURE check_rltns_integrity(
119 p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
120 p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
121 x_return_status OUT NOCOPY VARCHAR2);
122
123 PROCEDURE get_processing_status(
124 p_level IN varchar2,
125 p_level_dtl_id IN number,
126 x_processing_status OUT NOCOPY varchar2,
127 x_return_status OUT NOCOPY varchar2);
128
129 PROCEDURE validate_attrib_source_id(
130 p_attrib_source_table IN varchar2,
131 p_attrib_source_id IN number,
132 x_return_status OUT NOCOPY varchar2);
133
134 PROCEDURE validate_party_account_id(
135 p_party_id IN NUMBER,
136 p_party_account_id IN NUMBER,
137 x_return_status OUT NOCOPY VARCHAR2);
138
139 PROCEDURE get_instance_ref_info(
140 p_level IN varchar2,
141 p_level_dtl_id IN number,
142 x_instance_id OUT NOCOPY varchar2,
143 x_instance_exists_flag OUT NOCOPY varchar2,
144 x_return_status OUT NOCOPY varchar2);
145
146 PROCEDURE get_party_detail_rec(
147 p_party_detail_id IN number,
148 x_party_detail_rec OUT NOCOPY csi_t_party_details%rowtype,
149 x_return_status OUT NOCOPY varchar2);
150
151 PROCEDURE validate_instance_id(
152 p_instance_id IN number,
153 x_return_status OUT NOCOPY varchar2);
154
155 procedure validate_instance_reference(
156 p_level IN varchar2,
157 p_level_dtl_id IN number,
158 p_level_inst_ref_id IN number,
159 x_return_status OUT NOCOPY varchar2);
160
161 PROCEDURE validate_account_id(
162 p_account_id IN number,
163 x_return_status OUT NOCOPY varchar2);
164
165 PROCEDURE validate_site_use_id(
166 p_account_id IN number,
167 p_site_use_id IN number,
168 p_site_use_code IN varchar2,
169 x_return_status OUT NOCOPY varchar2);
170
171 PROCEDURE get_txn_system_id(
172 p_txn_systems_index IN number,
173 p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl,
174 x_txn_system_id OUT NOCOPY number,
175 x_return_status OUT NOCOPY varchar2);
176
177 PROCEDURE get_txn_systems_index(
178 p_txn_system_id IN number,
179 p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl,
180 x_txn_systems_index OUT NOCOPY number,
181 x_return_status OUT NOCOPY varchar2);
182
183 PROCEDURE validate_contact_flag(
184 p_contact_flag in varchar2,
185 x_return_status OUT NOCOPY varchar2);
186
187 PROCEDURE validate_ip_account_id(
188 p_ip_account_id IN number,
189 x_return_status OUT NOCOPY varchar2);
190
191 /* validtion routine for sub_type_id */
192 PROCEDURE validate_sub_type_id(
193 p_transaction_line_id IN number,
194 p_sub_type_id IN number,
195 x_return_status OUT NOCOPY varchar2);
196
197 PROCEDURE check_duplicate(
198 p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
199 x_return_status OUT NOCOPY varchar2);
200
201 PROCEDURE validate_lot_number(
202 p_inventory_item_id IN number,
203 p_organization_id IN number,
204 p_lot_number IN varchar2,
205 x_return_status OUT NOCOPY varchar2);
206
207 PROCEDURE validate_serial_number(
208 p_inventory_item_id IN number,
209 p_organization_id IN number,
210 p_serial_number IN varchar2,
211 x_return_status OUT NOCOPY varchar2);
212
213 -- Added for M-M
214 PROCEDURE validate_txn_rltnshp (
215 p_txn_line_detail_rec1 IN csi_t_datastructures_grp.txn_line_detail_rec,
216 p_txn_line_detail_rec2 IN csi_t_datastructures_grp.txn_line_detail_rec,
217 p_iir_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,
218 x_return_status OUT NOCOPY varchar2);
219
220 -- Added for M-M
221 PROCEDURE validate_inst_details (
222 p_iir_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,
223 p_txn_dtl_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
224 x_return_status OUT NOCOPY varchar2);
225
226 -- Added for M-M
227 PROCEDURE validate_src_header (
228 p_txn_line_id1 IN number,
229 p_txn_line_id2 IN number,
230 p_rel_type_code IN varchar2,
231 x_return_status OUT NOCOPY varchar2);
232
233 --Added for CZ
234 PROCEDURE check_exists_in_cz(
235 p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
236 x_return_status OUT NOCOPY VARCHAR2);
237
238 --Added for CZ
239 PROCEDURE get_cz_inst_or_tld_id (
240 p_config_inst_hdr_id IN NUMBER ,
241 p_config_inst_rev_num IN NUMBER ,
242 p_config_inst_item_id IN NUMBER ,
243 x_instance_id OUT NOCOPY NUMBER ,
244 x_txn_line_detail_id OUT NOCOPY NUMBER ,
245 x_return_status OUT NOCOPY VARCHAR2);
246
247 --Added for CZ
248 PROCEDURE get_cz_txn_line_id (
249 p_config_session_hdr_id IN NUMBER ,
250 p_config_session_rev_num IN NUMBER ,
251 p_config_session_item_id IN NUMBER ,
252 x_txn_line_id OUT NOCOPY NUMBER ,
253 x_return_status OUT NOCOPY VARCHAR2) ;
254
255 --Added for CZ
256 PROCEDURE check_cz_session_keys (
257 p_config_session_hdr_id IN NUMBER ,
258 p_config_session_rev_num IN NUMBER ,
259 p_config_session_item_id IN NUMBER ,
260 x_return_status OUT NOCOPY VARCHAR2) ;
261
262 END csi_t_vldn_routines_pvt;