[Home] [Help]
PACKAGE: APPS.PO_VAL_DISTRIBUTIONS
Source
1 PACKAGE PO_VAL_DISTRIBUTIONS AUTHID CURRENT_USER AS
2 -- $Header: PO_VAL_DISTRIBUTIONS.pls 120.18.12020000.8 2013/04/03 22:27:54 rarajar ship $
3
4 PROCEDURE dist_num_unique(
5 p_dist_id_tbl IN PO_TBL_NUMBER
6 , p_line_loc_id_tbl IN PO_TBL_NUMBER
7 , p_dist_num_tbl IN PO_TBL_NUMBER
8 , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --<PAR Project>
9 , p_draft_id_tbl IN PO_TBL_NUMBER
10 , x_result_set_id IN OUT NOCOPY NUMBER
11 , x_result_type OUT NOCOPY VARCHAR2
12 );
13
14 PROCEDURE dist_num_gt_zero(
15 p_dist_id_tbl IN PO_TBL_NUMBER
16 , p_dist_num_tbl IN PO_TBL_NUMBER
17 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
18 , x_result_type OUT NOCOPY VARCHAR2
19 );
20
21 PROCEDURE quantity_gt_zero(
22 p_dist_id_tbl IN PO_TBL_NUMBER
23 , p_qty_ordered_tbl IN PO_TBL_NUMBER
24 , p_value_basis_tbl IN PO_TBL_VARCHAR30 -- <Complex Work R12>
25 , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
26 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
27 , x_result_type OUT NOCOPY VARCHAR2
28 , p_header_id_tbl IN PO_TBL_NUMBER --<Bug 15871378>
29 );
30
31 -- <Complex Work R12 Start>:
32 -- Combined quantity billed/del into quantity exec
33
34 PROCEDURE quantity_ge_quantity_exec(
35 p_dist_id_tbl IN PO_TBL_NUMBER
36 , p_dist_type_tbl IN PO_TBL_VARCHAR30
37 , p_qty_ordered_tbl IN PO_TBL_NUMBER
38 , x_result_set_id IN OUT NOCOPY NUMBER
39 , x_result_type OUT NOCOPY VARCHAR2
40 );
41
42 -- <Complex Work R12 End>
43
44 PROCEDURE amount_gt_zero(
45 p_dist_id_tbl IN PO_TBL_NUMBER
46 , p_amt_ordered_tbl IN PO_TBL_NUMBER
47 , p_value_basis_tbl IN PO_TBL_VARCHAR30 -- <Complex Work R12>
48 , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
49 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
50 , x_result_type OUT NOCOPY VARCHAR2
51 , p_header_id_tbl IN PO_TBL_NUMBER --<Bug 15871378>
52 );
53
54 -- <Complex Work R12 Start>:
55 -- Combined amount billed/del into amount exec
56
57 PROCEDURE amount_ge_amount_exec(
58 p_dist_id_tbl IN PO_TBL_NUMBER
59 , p_dist_type_tbl IN PO_TBL_VARCHAR30
60 , p_amt_ordered_tbl IN PO_TBL_NUMBER
61 , x_result_set_id IN OUT NOCOPY NUMBER
62 , x_result_type OUT NOCOPY VARCHAR2
63 );
64
65 -- <Complex Work R12 End>
66
67 PROCEDURE pjm_unit_number_effective(
68 p_dist_id_tbl IN PO_TBL_NUMBER
69 , p_end_item_unit_number_tbl IN PO_TBL_VARCHAR30
70 , p_item_id_tbl IN PO_TBL_NUMBER
71 , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
72 -- Bug# 4338241: Checking if it is inventory and PJM is installed
73 , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
74 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
75 , x_result_type OUT NOCOPY VARCHAR2
76 );
77
78 PROCEDURE oop_enter_all_fields(
79 p_dist_id_tbl IN PO_TBL_NUMBER
80 , p_line_line_type_id_tbl IN PO_TBL_NUMBER
81 , p_wip_entity_id_tbl IN PO_TBL_NUMBER
82 , p_wip_line_id_tbl IN PO_TBL_NUMBER
83 , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER
84 , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
85 , p_wip_resource_seq_num_tbl IN PO_TBL_NUMBER
86 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
87 , x_result_type OUT NOCOPY VARCHAR2
88 );
89
90 PROCEDURE amount_to_encumber_ge_zero(
91 p_dist_id_tbl IN PO_TBL_NUMBER
92 , p_amount_to_encumber_tbl IN PO_TBL_NUMBER
93 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
94 , x_result_type OUT NOCOPY VARCHAR2
95 );
96
97 PROCEDURE budget_account_id_not_null(
98 p_dist_id_tbl IN PO_TBL_NUMBER
99 , p_budget_account_id_tbl IN PO_TBL_NUMBER
100 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
101 , x_result_type OUT NOCOPY VARCHAR2
102 );
103
104 PROCEDURE gl_encumbered_date_not_null(
105 p_dist_id_tbl IN PO_TBL_NUMBER
106 , p_gl_encumbered_date_tbl IN PO_TBL_DATE
107 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
108 , x_result_type OUT NOCOPY VARCHAR2
109 );
110
111 PROCEDURE gl_enc_date_not_null_open(
112 p_dist_id_tbl IN PO_TBL_NUMBER
113 , p_org_id_tbl IN PO_TBL_NUMBER
114 , p_gl_encumbered_date_tbl IN PO_TBL_DATE
115 , p_dist_type_tbl IN PO_TBL_VARCHAR30 --Bug 14664343
116 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
117 , x_result_type OUT NOCOPY VARCHAR2
118 );
119
120 PROCEDURE gms_data_valid(
121 p_dist_id_tbl IN PO_TBL_NUMBER
122 , p_project_id_tbl IN PO_TBL_NUMBER
123 , p_task_id_tbl IN PO_TBL_NUMBER
124 , p_award_number_tbl IN PO_TBL_VARCHAR2000
125 , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
126 , p_expenditure_item_date_tbl IN PO_TBL_DATE
127 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
128 , x_result_type OUT NOCOPY VARCHAR2
129 );
130
131 PROCEDURE check_fv_validations(
132 p_dist_id_tbl IN PO_TBL_NUMBER
133 , p_ccid_tbl IN PO_TBL_NUMBER
134 , p_org_id_tbl IN PO_TBL_NUMBER
135 , p_attribute1_tbl IN PO_TBL_VARCHAR2000
136 , p_attribute2_tbl IN PO_TBL_VARCHAR2000
137 , p_attribute3_tbl IN PO_TBL_VARCHAR2000
138 , p_attribute4_tbl IN PO_TBL_VARCHAR2000
139 , p_attribute5_tbl IN PO_TBL_VARCHAR2000
140 , p_attribute6_tbl IN PO_TBL_VARCHAR2000
141 , p_attribute7_tbl IN PO_TBL_VARCHAR2000
142 , p_attribute8_tbl IN PO_TBL_VARCHAR2000
143 , p_attribute9_tbl IN PO_TBL_VARCHAR2000
144 , p_attribute10_tbl IN PO_TBL_VARCHAR2000
145 , p_attribute11_tbl IN PO_TBL_VARCHAR2000
146 , p_attribute12_tbl IN PO_TBL_VARCHAR2000
147 , p_attribute13_tbl IN PO_TBL_VARCHAR2000
148 , p_attribute14_tbl IN PO_TBL_VARCHAR2000
149 , p_attribute15_tbl IN PO_TBL_VARCHAR2000
150 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
151 , x_result_type OUT NOCOPY VARCHAR2
152 );
153
154 /* CLM Partial Funding Changes -- START */
155 PROCEDURE funded_value_ge_zero(
156 p_dist_id_tbl IN PO_TBL_NUMBER
157 , p_org_id_tbl IN PO_TBL_NUMBER
158 , p_style_id_tbl IN PO_TBL_NUMBER
159 , p_partial_funded_flag_tbl IN PO_TBL_VARCHAR1
160 , p_funded_value_tbl IN PO_TBL_NUMBER
161 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
162 , x_result_type OUT NOCOPY VARCHAR2
163 );
164
165 PROCEDURE funded_val_le_tot_order_val(
166 p_dist_id_tbl IN PO_TBL_NUMBER
167 , p_org_id_tbl IN PO_TBL_NUMBER
168 , p_style_id_tbl IN PO_TBL_NUMBER
169 , p_partial_funded_flag_tbl IN PO_TBL_VARCHAR1
170 , p_funded_value_tbl IN PO_TBL_NUMBER
171 , p_quantity_ordered_tbl IN PO_TBL_NUMBER
172 , p_amount_ordered_tbl IN PO_TBL_NUMBER
173 , p_price_override_tbl IN PO_TBL_NUMBER
174 , p_nonrecoverable_tax_tbl IN PO_TBL_NUMBER
175 , p_rate_tbl IN PO_TBL_NUMBER
176 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
177 , x_result_type OUT NOCOPY VARCHAR2
178 );
179
180 PROCEDURE qty_funded_ge_exc_qty(
181 p_dist_id_tbl IN PO_TBL_NUMBER
182 , p_org_id_tbl IN PO_TBL_NUMBER
183 , p_style_id_tbl IN PO_TBL_NUMBER
184 , p_quantity_funded_tbl IN PO_TBL_NUMBER
185 , p_quantity_billed_tbl IN PO_TBL_NUMBER
186 , p_quantity_delivered_tbl IN PO_TBL_NUMBER
187 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
188 , x_result_type OUT NOCOPY VARCHAR2
189 );
190
191 PROCEDURE amount_funded_ge_exc_amount(
192 p_dist_id_tbl IN PO_TBL_NUMBER
193 , p_org_id_tbl IN PO_TBL_NUMBER
194 , p_style_id_tbl IN PO_TBL_NUMBER
195 , p_amount_funded_tbl IN PO_TBL_NUMBER
196 , p_amount_billed_tbl IN PO_TBL_NUMBER
197 , p_amount_delivered_tbl IN PO_TBL_NUMBER
198 , p_line_matching_basis_tbl IN PO_TBL_VARCHAR30 --Bug 13773450
199 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
200 , x_result_type OUT NOCOPY VARCHAR2
201 );
202
203 PROCEDURE funded_value_gt_backing_req(
204 p_dist_id_tbl IN PO_TBL_NUMBER
205 , p_org_id_tbl IN PO_TBL_NUMBER
206 , p_style_id_tbl IN PO_TBL_NUMBER
207 , p_funded_value_tbl IN PO_TBL_NUMBER
208 , p_req_distribution_id_tbl IN PO_TBL_NUMBER
209 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
210 , x_result_type OUT NOCOPY VARCHAR2
211 );
212 /* CLM Partial Funding Changes -- END */
213
214 PROCEDURE unencum_amt_le_amt_to_encum(
215 p_dist_id_tbl IN PO_TBL_NUMBER
216 , p_amount_to_encumber_tbl IN PO_TBL_NUMBER
217 , p_unencumbered_amount_tbl IN PO_TBL_NUMBER
218 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
219 , x_result_type OUT NOCOPY VARCHAR2
220 );
221
222 -- Bug 7558385
223 -- Need to check for PJM Parameters before making Task as mandatory.
224 -- For fetching the PJM paramters passing ship to org id.
225 PROCEDURE check_proj_related_validations(
226 p_dist_id_tbl IN PO_TBL_NUMBER
227 , p_dest_type_code_tbl IN PO_TBL_VARCHAR30
228 , p_project_id_tbl IN PO_TBL_NUMBER
229 , p_task_id_tbl IN PO_TBL_NUMBER
230 , p_award_id_tbl IN PO_TBL_NUMBER
231 , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
232 , p_expenditure_org_id_tbl IN PO_TBL_NUMBER
233 , p_expenditure_item_date_tbl IN PO_TBL_DATE
234 , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
235 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
236 , x_result_type OUT NOCOPY VARCHAR2
237 );
238
239 -- CLM-LnSc
240 PROCEDURE funded_val_gt_req_funds_rmn(
241 p_dist_id_tbl IN PO_TBL_NUMBER,
242 p_dist_type_tbl IN PO_TBL_VARCHAR30,
243 p_org_id_tbl IN PO_TBL_NUMBER,
244 p_style_id_tbl IN PO_TBL_NUMBER,
245 p_draft_id_tbl IN PO_TBL_NUMBER,
246 p_funded_value_tbl IN PO_TBL_NUMBER,
247 p_enc_amount_tbl IN PO_TBL_NUMBER,
248 p_req_dist_id_tbl IN PO_TBL_NUMBER,
249 x_result_set_id IN OUT NOCOPY NUMBER,
250 x_result_type OUT NOCOPY VARCHAR2
251 );
252
253 --PAR Project
254 PROCEDURE check_dist_values_inc_for_par(
255 p_dist_id_tbl IN PO_TBL_NUMBER,
256 p_draft_id_tbl IN PO_TBL_NUMBER,
257 p_draft_type_tbl IN PO_TBL_VARCHAR30,
258 p_quantity_ordered_tbl IN PO_TBL_NUMBER,
259 p_amt_ordered_tbl IN PO_TBL_NUMBER,
260 p_old_qty_ordered_tbl IN PO_TBL_NUMBER,
261 p_change_status_tbl IN PO_TBL_VARCHAR30,
262 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE ,
263 x_result_type OUT NOCOPY VARCHAR2);
264
265 --CLM PDOI Integration Starts
266 PROCEDURE check_clin_slin_funding(
267 p_intf_dist_id_tbl IN PO_TBL_NUMBER,
268 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
269 x_result_type OUT NOCOPY VARCHAR2);
270
271 PROCEDURE validate_defence_funding(
272 p_intf_dist_id_tbl IN PO_TBL_NUMBER,
273 p_clm_defence_funding_tbl IN PO_TBL_VARCHAR30,
274 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
275 x_result_type OUT NOCOPY VARCHAR2);
276
277 PROCEDURE validate_option_distribution(
278 p_intf_dist_id_tbl IN PO_TBL_NUMBER,
279 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
280 x_result_type OUT NOCOPY VARCHAR2);
281 --CLM PDOI Integration Ends
282
283 END PO_VAL_DISTRIBUTIONS;