[Home] [Help]
PACKAGE: APPS.PO_VAL_DISTRIBUTIONS
Source
1 PACKAGE PO_VAL_DISTRIBUTIONS AS
2 -- $Header: PO_VAL_DISTRIBUTIONS.pls 120.12.12010000.2 2008/12/08 10:42:35 cvardia 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 , x_result_set_id IN OUT NOCOPY NUMBER
9 , x_result_type OUT NOCOPY VARCHAR2
10 );
11
12 PROCEDURE dist_num_gt_zero(
13 p_dist_id_tbl IN PO_TBL_NUMBER
14 , p_dist_num_tbl IN PO_TBL_NUMBER
15 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
16 , x_result_type OUT NOCOPY VARCHAR2
17 );
18
19 PROCEDURE quantity_gt_zero(
20 p_dist_id_tbl IN PO_TBL_NUMBER
21 , p_qty_ordered_tbl IN PO_TBL_NUMBER
22 , p_value_basis_tbl IN PO_TBL_VARCHAR30 -- <Complex Work R12>
23 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
24 , x_result_type OUT NOCOPY VARCHAR2
25 );
26
27 -- <Complex Work R12 Start>:
28 -- Combined quantity billed/del into quantity exec
29
30 PROCEDURE quantity_ge_quantity_exec(
31 p_dist_id_tbl IN PO_TBL_NUMBER
32 , p_dist_type_tbl IN PO_TBL_VARCHAR30
33 , p_qty_ordered_tbl IN PO_TBL_NUMBER
34 , x_result_set_id IN OUT NOCOPY NUMBER
35 , x_result_type OUT NOCOPY VARCHAR2
36 );
37
38 -- <Complex Work R12 End>
39
40 PROCEDURE amount_gt_zero(
41 p_dist_id_tbl IN PO_TBL_NUMBER
42 , p_amt_ordered_tbl IN PO_TBL_NUMBER
43 , p_value_basis_tbl IN PO_TBL_VARCHAR30 -- <Complex Work R12>
44 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
45 , x_result_type OUT NOCOPY VARCHAR2
46 );
47
48 -- <Complex Work R12 Start>:
49 -- Combined amount billed/del into amount exec
50
51 PROCEDURE amount_ge_amount_exec(
52 p_dist_id_tbl IN PO_TBL_NUMBER
53 , p_dist_type_tbl IN PO_TBL_VARCHAR30
54 , p_amt_ordered_tbl IN PO_TBL_NUMBER
55 , x_result_set_id IN OUT NOCOPY NUMBER
56 , x_result_type OUT NOCOPY VARCHAR2
57 );
58
59 -- <Complex Work R12 End>
60
61 PROCEDURE pjm_unit_number_effective(
62 p_dist_id_tbl IN PO_TBL_NUMBER
63 , p_end_item_unit_number_tbl IN PO_TBL_VARCHAR30
64 , p_item_id_tbl IN PO_TBL_NUMBER
65 , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
66 -- Bug# 4338241: Checking if it is inventory and PJM is installed
67 , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
68 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
69 , x_result_type OUT NOCOPY VARCHAR2
70 );
71
72 PROCEDURE oop_enter_all_fields(
73 p_dist_id_tbl IN PO_TBL_NUMBER
74 , p_line_line_type_id_tbl IN PO_TBL_NUMBER
75 , p_wip_entity_id_tbl IN PO_TBL_NUMBER
76 , p_wip_line_id_tbl IN PO_TBL_NUMBER
77 , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER
78 , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
79 , p_wip_resource_seq_num_tbl IN PO_TBL_NUMBER
80 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
81 , x_result_type OUT NOCOPY VARCHAR2
82 );
83
84 PROCEDURE amount_to_encumber_ge_zero(
85 p_dist_id_tbl IN PO_TBL_NUMBER
86 , p_amount_to_encumber_tbl IN PO_TBL_NUMBER
87 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
88 , x_result_type OUT NOCOPY VARCHAR2
89 );
90
91 PROCEDURE budget_account_id_not_null(
92 p_dist_id_tbl IN PO_TBL_NUMBER
93 , p_budget_account_id_tbl IN PO_TBL_NUMBER
94 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
95 , x_result_type OUT NOCOPY VARCHAR2
96 );
97
98 PROCEDURE gl_encumbered_date_not_null(
99 p_dist_id_tbl IN PO_TBL_NUMBER
100 , p_gl_encumbered_date_tbl IN PO_TBL_DATE
101 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
102 , x_result_type OUT NOCOPY VARCHAR2
103 );
104
105 PROCEDURE gl_enc_date_not_null_open(
106 p_dist_id_tbl IN PO_TBL_NUMBER
107 , p_org_id_tbl IN PO_TBL_NUMBER
108 , p_gl_encumbered_date_tbl IN PO_TBL_DATE
109 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
110 , x_result_type OUT NOCOPY VARCHAR2
111 );
112
113 PROCEDURE gms_data_valid(
114 p_dist_id_tbl IN PO_TBL_NUMBER
115 , p_project_id_tbl IN PO_TBL_NUMBER
116 , p_task_id_tbl IN PO_TBL_NUMBER
117 , p_award_number_tbl IN PO_TBL_VARCHAR2000
118 , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
119 , p_expenditure_item_date_tbl IN PO_TBL_DATE
120 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
121 , x_result_type OUT NOCOPY VARCHAR2
122 );
123
124 PROCEDURE check_fv_validations(
125 p_dist_id_tbl IN PO_TBL_NUMBER
126 , p_ccid_tbl IN PO_TBL_NUMBER
127 , p_org_id_tbl IN PO_TBL_NUMBER
128 , p_attribute1_tbl IN PO_TBL_VARCHAR2000
129 , p_attribute2_tbl IN PO_TBL_VARCHAR2000
130 , p_attribute3_tbl IN PO_TBL_VARCHAR2000
131 , p_attribute4_tbl IN PO_TBL_VARCHAR2000
132 , p_attribute5_tbl IN PO_TBL_VARCHAR2000
133 , p_attribute6_tbl IN PO_TBL_VARCHAR2000
134 , p_attribute7_tbl IN PO_TBL_VARCHAR2000
135 , p_attribute8_tbl IN PO_TBL_VARCHAR2000
136 , p_attribute9_tbl IN PO_TBL_VARCHAR2000
137 , p_attribute10_tbl IN PO_TBL_VARCHAR2000
138 , p_attribute11_tbl IN PO_TBL_VARCHAR2000
139 , p_attribute12_tbl IN PO_TBL_VARCHAR2000
140 , p_attribute13_tbl IN PO_TBL_VARCHAR2000
141 , p_attribute14_tbl IN PO_TBL_VARCHAR2000
142 , p_attribute15_tbl IN PO_TBL_VARCHAR2000
143 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
144 , x_result_type OUT NOCOPY VARCHAR2
145 );
146
147 PROCEDURE unencum_amt_le_amt_to_encum(
148 p_dist_id_tbl IN PO_TBL_NUMBER
149 , p_amount_to_encumber_tbl IN PO_TBL_NUMBER
150 , p_unencumbered_amount_tbl IN PO_TBL_NUMBER
151 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
152 , x_result_type OUT NOCOPY VARCHAR2
153 );
154
155 -- Bug 7558385
156 -- Need to check for PJM Parameters before making Task as mandatory.
157 -- For fetching the PJM paramters passing ship to org id.
158 PROCEDURE check_proj_related_validations(
159 p_dist_id_tbl IN PO_TBL_NUMBER
160 , p_dest_type_code_tbl IN PO_TBL_VARCHAR30
161 , p_project_id_tbl IN PO_TBL_NUMBER
162 , p_task_id_tbl IN PO_TBL_NUMBER
163 , p_award_id_tbl IN PO_TBL_NUMBER
164 , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
165 , p_expenditure_org_id_tbl IN PO_TBL_NUMBER
166 , p_expenditure_item_date_tbl IN PO_TBL_DATE
167 , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
168 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
169 , x_result_type OUT NOCOPY VARCHAR2
170 );
171
172 END PO_VAL_DISTRIBUTIONS;