[Home] [Help]
PACKAGE: APPS.BOMPVALB
Source
1 package BOMPVALB AUTHID CURRENT_USER as
2 /* $Header: BOMVALBS.pls 115.2 99/07/16 05:16:46 porting ship $
3 +===========================================================================+
4 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 +===========================================================================+
7 | |
8 | File Name : BOMPVALB.pls |
9 | DESCRIPTION : This package contains functions used to validate bill |
10 | data in the interface tables |
11 | Parameters: org_id organization_id |
12 | all_org process all orgs or just current org |
13 | 1 - all orgs |
14 | 2 - only org_id |
15 | prog_appid program application_id |
16 | prog_id program id |
17 | request_id request_id |
18 | user_id user id |
19 | login_id login id |
20 | History: |
21 | 11/22/93 Shreyas Shah creation date |
22 | 04/24/94 Julie Maeyama modified code |
23 +==========================================================================*/
24 FUNCTION bmvbomh_validate_bom_header (
25 org_id NUMBER,
26 all_org NUMBER := 2,
27 user_id NUMBER,
28 login_id NUMBER,
29 prog_appid NUMBER,
30 prog_id NUMBER,
31 request_id NUMBER,
32 err_text IN OUT VARCHAR2
33 )
34 return INTEGER;
35
36 FUNCTION bmvassyid_verify_assembly_id(
37 org_id NUMBER,
38 assy_id NUMBER,
39 err_text OUT VARCHAR2
40 )
41 return INTEGER;
42
43 FUNCTION bmvrbom_verify_bom(
44 bom_seq_id NUMBER,
45 mode_type NUMBER,
46 err_text OUT VARCHAR2
47 )
48 return INTEGER;
49
50 FUNCTION bmvdupbom_verify_duplicate_bom(
51 org_id NUMBER,
52 assy_id NUMBER,
53 alt_desg VARCHAR2,
54 assy_type NUMBER,
55 err_text OUT VARCHAR2
56 )
57 return INTEGER;
58
59 FUNCTION bmvbitm_verify_assembly_type(
60 org_id NUMBER,
61 assy_id NUMBER,
62 assy_type NUMBER,
63 err_text OUT VARCHAR2
64 )
65 return INTEGER;
66
67 FUNCTION bmvcmbom_verify_common_bom(
68 bom_id NUMBER,
69 cmn_bom_id NUMBER,
70 bom_type NUMBER,
71 item_id NUMBER,
72 cmn_item_id NUMBER,
73 org_id NUMBER,
74 cmn_org_id NUMBER,
75 alt_desg VARCHAR2,
76 err_text OUT VARCHAR2
77 )
78 return INTEGER;
79
80 FUNCTION bmvcomp_validate_components (
81 org_id NUMBER,
82 all_org NUMBER := 2,
83 user_id NUMBER,
84 login_id NUMBER,
85 prog_appid NUMBER,
86 prog_id NUMBER,
87 request_id NUMBER,
88 err_text IN OUT VARCHAR2
89 )
90 return INTEGER;
91
92 FUNCTION bmvitmatt_verify_item_attr (
93 org_id NUMBER,
94 cmp_id NUMBER,
95 assy_id NUMBER,
96 eng_bill NUMBER,
97 err_text OUT VARCHAR2
98 )
99 return INTEGER;
100
101 FUNCTION bmvopseqs_valid_op_seqs (
102 org_id NUMBER,
103 assy_id NUMBER,
104 alt_desg VARCHAR2,
105 op_seq NUMBER,
106 err_text OUT VARCHAR2
107 )
108 return INTEGER;
109
110 FUNCTION bmvovlap_verify_overlaps (
111 bom_id NUMBER,
112 op_num NUMBER,
113 cmp_id NUMBER,
114 eff_date VARCHAR2,
115 dis_date VARCHAR2,
116 err_text OUT VARCHAR2
117 )
118 return INTEGER;
119
120 FUNCTION bmvuncmp_verify_unique_comp (
121 cmp_seq_id NUMBER,
122 exist_flag NUMBER,
123 err_text OUT VARCHAR2
124 )
125 return INTEGER;
126
127 FUNCTION bmvdupcmp_verify_duplicate_cmp (
128 bill_seq_id NUMBER,
129 eff_date VARCHAR2,
130 cmp_item_id NUMBER,
131 op_seq NUMBER,
132 err_text OUT VARCHAR2
133 )
134 return INTEGER;
135
136 FUNCTION bmvref_validate_ref_desgs (
137 org_id NUMBER,
138 all_org NUMBER := 2,
139 user_id NUMBER,
140 login_id NUMBER,
141 prog_appid NUMBER,
142 prog_id NUMBER,
143 request_id NUMBER,
144 err_text IN OUT VARCHAR2
145 )
146 return INTEGER;
147
148 FUNCTION bmvundesg_verify_unique_desg (
149 trans_id NUMBER,
150 err_text OUT VARCHAR2
151 )
152 return INTEGER;
153
154 FUNCTION bmvcdesg_cnt_ref_desgs (
155 trans_id NUMBER,
156 cmp_seq_id NUMBER,
157 err_text OUT VARCHAR2
158 )
159 return INTEGER;
160
161 FUNCTION bmvsubs_validate_sub_comps (
162 org_id NUMBER,
163 all_org NUMBER := 2,
164 user_id NUMBER,
165 login_id NUMBER,
166 prog_appid NUMBER,
167 prog_id NUMBER,
168 request_id NUMBER,
169 err_text IN OUT VARCHAR2
170 )
171 return INTEGER;
172
173 FUNCTION bmvunsub_verify_unique_sub (
174 trans_id NUMBER,
175 err_text OUT VARCHAR2
176 )
177 return INTEGER;
178
179 FUNCTION bmvitmrev_validate_itm_rev (
180 org_id NUMBER,
181 all_org NUMBER,
182 user_id NUMBER,
183 login_id NUMBER,
184 prog_appid NUMBER,
185 prog_id NUMBER,
186 req_id NUMBER,
187 err_text IN OUT VARCHAR2
188 )
189 return INTEGER;
190
191 FUNCTION bmvalrev_validate_rev (
192 org_id NUMBER,
193 assy_id NUMBER,
194 user_id NUMBER,
195 login_id NUMBER,
196 prog_appid NUMBER,
197 prog_id NUMBER,
198 req_id NUMBER,
199 err_text IN OUT VARCHAR2
200 )
201 return INTEGER;
202
203 END BOMPVALB;