APPS.PO_VAL_DISTRIBUTIONS dependencies on PO_TBL_NUMBER

Line 5: p_dist_id_tbl IN PO_TBL_NUMBER

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 --
9: , p_draft_id_tbl IN PO_TBL_NUMBER

Line 6: , p_line_loc_id_tbl IN PO_TBL_NUMBER

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 --
9: , p_draft_id_tbl IN PO_TBL_NUMBER
10: , x_result_set_id IN OUT NOCOPY NUMBER

Line 7: , p_dist_num_tbl IN PO_TBL_NUMBER

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 --
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

Line 9: , p_draft_id_tbl IN PO_TBL_NUMBER

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 --
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:

Line 15: p_dist_id_tbl IN PO_TBL_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: );

Line 16: , p_dist_num_tbl IN PO_TBL_NUMBER

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:

Line 22: p_dist_id_tbl IN PO_TBL_NUMBER

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 --
25: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
26: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 23: , p_qty_ordered_tbl IN PO_TBL_NUMBER

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 --
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

Line 28: , p_header_id_tbl IN PO_TBL_NUMBER --

24: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
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 --
29: );
30:
31: -- :
32: -- Combined quantity billed/del into quantity exec

Line 35: p_dist_id_tbl IN PO_TBL_NUMBER

31: -- :
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

Line 37: , p_qty_ordered_tbl IN PO_TBL_NUMBER

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:

Line 45: p_dist_id_tbl IN PO_TBL_NUMBER

41:
42: --
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 --
48: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
49: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 46: , p_amt_ordered_tbl IN PO_TBL_NUMBER

42: --
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 --
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

Line 51: , p_header_id_tbl IN PO_TBL_NUMBER --

47: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
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 --
52: );
53:
54: -- :
55: -- Combined amount billed/del into amount exec

Line 58: p_dist_id_tbl IN PO_TBL_NUMBER

54: -- :
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

Line 60: , p_amt_ordered_tbl IN PO_TBL_NUMBER

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:

Line 68: p_dist_id_tbl IN PO_TBL_NUMBER

64:
65: --
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

Line 70: , p_item_id_tbl IN PO_TBL_NUMBER

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

Line 71: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER

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

Line 79: p_dist_id_tbl IN PO_TBL_NUMBER

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

Line 80: , p_line_line_type_id_tbl IN PO_TBL_NUMBER

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

Line 81: , p_wip_entity_id_tbl IN PO_TBL_NUMBER

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

Line 82: , p_wip_line_id_tbl IN PO_TBL_NUMBER

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

Line 83: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER

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

Line 85: , p_wip_resource_seq_num_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:

Line 91: p_dist_id_tbl IN PO_TBL_NUMBER

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: );

Line 92: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER

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:

Line 98: p_dist_id_tbl IN PO_TBL_NUMBER

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: );

Line 99: , p_budget_account_id_tbl IN PO_TBL_NUMBER

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:

Line 105: p_dist_id_tbl IN PO_TBL_NUMBER

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: );

Line 112: p_dist_id_tbl IN PO_TBL_NUMBER

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

Line 113: , p_org_id_tbl IN PO_TBL_NUMBER

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

Line 121: p_dist_id_tbl IN PO_TBL_NUMBER

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

Line 122: , p_project_id_tbl IN PO_TBL_NUMBER

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

Line 123: , p_task_id_tbl IN PO_TBL_NUMBER

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

Line 132: p_dist_id_tbl IN PO_TBL_NUMBER

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

Line 133: , p_ccid_tbl IN PO_TBL_NUMBER

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

Line 134: , p_org_id_tbl IN PO_TBL_NUMBER

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

Line 156: p_dist_id_tbl IN PO_TBL_NUMBER

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

Line 157: , p_org_id_tbl IN PO_TBL_NUMBER

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

Line 158: , p_style_id_tbl IN PO_TBL_NUMBER

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

Line 160: , p_funded_value_tbl IN PO_TBL_NUMBER

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:

Line 166: p_dist_id_tbl IN PO_TBL_NUMBER

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

Line 167: , p_org_id_tbl IN PO_TBL_NUMBER

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

Line 168: , p_style_id_tbl IN PO_TBL_NUMBER

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

Line 170: , p_funded_value_tbl IN PO_TBL_NUMBER

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

Line 171: , p_quantity_ordered_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

Line 172: , p_amount_ordered_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

Line 173: , p_price_override_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

Line 174: , p_nonrecoverable_tax_tbl IN PO_TBL_NUMBER

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: );

Line 175: , p_rate_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:

Line 181: p_dist_id_tbl IN PO_TBL_NUMBER

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

Line 182: , p_org_id_tbl IN PO_TBL_NUMBER

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

Line 183: , p_style_id_tbl IN PO_TBL_NUMBER

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

Line 184: , p_quantity_funded_tbl IN PO_TBL_NUMBER

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

Line 185: , p_quantity_billed_tbl IN PO_TBL_NUMBER

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: );

Line 186: , p_quantity_delivered_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:

Line 192: p_dist_id_tbl IN PO_TBL_NUMBER

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

Line 193: , p_org_id_tbl IN PO_TBL_NUMBER

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

Line 194: , p_style_id_tbl IN PO_TBL_NUMBER

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

Line 195: , p_amount_funded_tbl IN PO_TBL_NUMBER

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

Line 196: , p_amount_billed_tbl IN PO_TBL_NUMBER

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

Line 197: , p_amount_delivered_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: );

Line 204: p_dist_id_tbl IN PO_TBL_NUMBER

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

Line 205: , p_org_id_tbl IN PO_TBL_NUMBER

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

Line 206: , p_style_id_tbl IN PO_TBL_NUMBER

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

Line 207: , p_funded_value_tbl IN PO_TBL_NUMBER

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: );

Line 208: , p_req_distribution_id_tbl IN PO_TBL_NUMBER

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 */

Line 215: p_dist_id_tbl IN PO_TBL_NUMBER

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

Line 216: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER

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: );

Line 217: , p_unencumbered_amount_tbl IN PO_TBL_NUMBER

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:

Line 226: p_dist_id_tbl IN PO_TBL_NUMBER

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

Line 228: , p_project_id_tbl IN PO_TBL_NUMBER

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

Line 229: , p_task_id_tbl IN PO_TBL_NUMBER

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

Line 230: , p_award_id_tbl IN PO_TBL_NUMBER

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

Line 232: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER

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

Line 234: , p_ship_to_org_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:

Line 241: p_dist_id_tbl IN PO_TBL_NUMBER,

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,

Line 243: p_org_id_tbl IN PO_TBL_NUMBER,

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,

Line 244: p_style_id_tbl IN PO_TBL_NUMBER,

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,

Line 245: p_draft_id_tbl IN PO_TBL_NUMBER,

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,

Line 246: p_funded_value_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

Line 247: p_enc_amount_tbl IN PO_TBL_NUMBER,

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: );

Line 248: p_req_dist_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:

Line 255: p_dist_id_tbl IN PO_TBL_NUMBER,

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,

Line 256: p_draft_id_tbl IN PO_TBL_NUMBER,

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,

Line 258: p_quantity_ordered_tbl IN PO_TBL_NUMBER,

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 ,

Line 259: p_amt_ordered_tbl IN PO_TBL_NUMBER,

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);

Line 260: p_old_qty_ordered_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:

Line 267: p_intf_dist_id_tbl IN PO_TBL_NUMBER,

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(

Line 272: 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:

Line 278: p_intf_dist_id_tbl IN PO_TBL_NUMBER,

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: