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
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: );
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:
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: );
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:
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 --
23: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
24: , 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 --
23: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
24: , x_result_type OUT NOCOPY VARCHAR2
25: );
27: --
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
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:
37:
38: --
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 --
44: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
45: , x_result_type OUT NOCOPY VARCHAR2
38: --
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 --
44: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
45: , x_result_type OUT NOCOPY VARCHAR2
46: );
48: --
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
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:
58:
59: --
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
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
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
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
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
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
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
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
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:
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: );
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:
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: );
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:
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: );
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
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: );
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
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
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
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
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
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
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: );
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
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
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
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
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
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: