1: PACKAGE PO_VAL_DISTRIBUTIONS2 AUTHID CURRENT_USER AS
2: -- $Header: PO_VAL_DISTRIBUTIONS2.pls 120.12 2011/10/16 11:00:10 dtoshniw ship $
3:
4: PROCEDURE amount_ordered(p_id_tbl IN po_tbl_number,
5: p_amount_ordered_tbl IN po_tbl_number,
6: p_order_type_code_tbl IN po_tbl_varchar30,
7: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
8: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
1: PACKAGE PO_VAL_DISTRIBUTIONS2 AUTHID CURRENT_USER AS
2: -- $Header: PO_VAL_DISTRIBUTIONS2.pls 120.12 2011/10/16 11:00:10 dtoshniw ship $
3:
4: PROCEDURE amount_ordered(p_id_tbl IN po_tbl_number,
5: p_amount_ordered_tbl IN po_tbl_number,
6: p_order_type_code_tbl IN po_tbl_varchar30,
7: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
8: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
9: x_result_type OUT NOCOPY VARCHAR2);
7: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
8: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
9: x_result_type OUT NOCOPY VARCHAR2);
10:
11: PROCEDURE quantity_ordered(p_id_tbl IN po_tbl_number,
12: p_quantity_ordered_tbl IN po_tbl_number,
13: p_order_type_code_tbl IN po_tbl_varchar30,
14: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
15: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
8: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
9: x_result_type OUT NOCOPY VARCHAR2);
10:
11: PROCEDURE quantity_ordered(p_id_tbl IN po_tbl_number,
12: p_quantity_ordered_tbl IN po_tbl_number,
13: p_order_type_code_tbl IN po_tbl_varchar30,
14: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
15: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
16: x_result_type OUT NOCOPY VARCHAR2);
14: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
15: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
16: x_result_type OUT NOCOPY VARCHAR2);
17:
18: PROCEDURE destination_org_id(p_id_tbl IN po_tbl_number,
19: p_dest_org_id_tbl IN po_tbl_number,
20: p_ship_to_org_id_tbl IN po_tbl_number,
21: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
22: x_result_type OUT NOCOPY VARCHAR2);
15: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
16: x_result_type OUT NOCOPY VARCHAR2);
17:
18: PROCEDURE destination_org_id(p_id_tbl IN po_tbl_number,
19: p_dest_org_id_tbl IN po_tbl_number,
20: p_ship_to_org_id_tbl IN po_tbl_number,
21: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
22: x_result_type OUT NOCOPY VARCHAR2);
23:
16: x_result_type OUT NOCOPY VARCHAR2);
17:
18: PROCEDURE destination_org_id(p_id_tbl IN po_tbl_number,
19: p_dest_org_id_tbl IN po_tbl_number,
20: p_ship_to_org_id_tbl IN po_tbl_number,
21: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
22: x_result_type OUT NOCOPY VARCHAR2);
23:
24: PROCEDURE deliver_to_location_id(p_id_tbl IN po_tbl_number,
20: p_ship_to_org_id_tbl IN po_tbl_number,
21: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
22: x_result_type OUT NOCOPY VARCHAR2);
23:
24: PROCEDURE deliver_to_location_id(p_id_tbl IN po_tbl_number,
25: p_deliver_to_location_id_tbl IN po_tbl_number,
26: p_ship_to_org_id_tbl IN po_tbl_number,
27: x_result_set_id IN OUT NOCOPY NUMBER,
28: x_result_type OUT NOCOPY VARCHAR2);
21: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
22: x_result_type OUT NOCOPY VARCHAR2);
23:
24: PROCEDURE deliver_to_location_id(p_id_tbl IN po_tbl_number,
25: p_deliver_to_location_id_tbl IN po_tbl_number,
26: p_ship_to_org_id_tbl IN po_tbl_number,
27: x_result_set_id IN OUT NOCOPY NUMBER,
28: x_result_type OUT NOCOPY VARCHAR2);
29:
22: x_result_type OUT NOCOPY VARCHAR2);
23:
24: PROCEDURE deliver_to_location_id(p_id_tbl IN po_tbl_number,
25: p_deliver_to_location_id_tbl IN po_tbl_number,
26: p_ship_to_org_id_tbl IN po_tbl_number,
27: x_result_set_id IN OUT NOCOPY NUMBER,
28: x_result_type OUT NOCOPY VARCHAR2);
29:
30: PROCEDURE deliver_to_person_id(p_id_tbl IN po_tbl_number,
26: p_ship_to_org_id_tbl IN po_tbl_number,
27: x_result_set_id IN OUT NOCOPY NUMBER,
28: x_result_type OUT NOCOPY VARCHAR2);
29:
30: PROCEDURE deliver_to_person_id(p_id_tbl IN po_tbl_number,
31: p_deliver_to_person_id_tbl IN po_tbl_number,
32: x_result_set_id IN OUT NOCOPY NUMBER,
33: x_result_type OUT NOCOPY VARCHAR2);
34:
27: x_result_set_id IN OUT NOCOPY NUMBER,
28: x_result_type OUT NOCOPY VARCHAR2);
29:
30: PROCEDURE deliver_to_person_id(p_id_tbl IN po_tbl_number,
31: p_deliver_to_person_id_tbl IN po_tbl_number,
32: x_result_set_id IN OUT NOCOPY NUMBER,
33: x_result_type OUT NOCOPY VARCHAR2);
34:
35: PROCEDURE destination_type_code(p_id_tbl IN po_tbl_number,
31: p_deliver_to_person_id_tbl IN po_tbl_number,
32: x_result_set_id IN OUT NOCOPY NUMBER,
33: x_result_type OUT NOCOPY VARCHAR2);
34:
35: PROCEDURE destination_type_code(p_id_tbl IN po_tbl_number,
36: p_dest_type_code_tbl IN po_tbl_varchar30,
37: p_ship_to_org_id_tbl IN po_tbl_number,
38: p_item_id_tbl IN po_tbl_number,
39: p_txn_flow_header_id_tbl IN po_tbl_number,
33: x_result_type OUT NOCOPY VARCHAR2);
34:
35: PROCEDURE destination_type_code(p_id_tbl IN po_tbl_number,
36: p_dest_type_code_tbl IN po_tbl_varchar30,
37: p_ship_to_org_id_tbl IN po_tbl_number,
38: p_item_id_tbl IN po_tbl_number,
39: p_txn_flow_header_id_tbl IN po_tbl_number,
40: p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,
41: p_value_basis_tbl IN po_tbl_varchar30,
34:
35: PROCEDURE destination_type_code(p_id_tbl IN po_tbl_number,
36: p_dest_type_code_tbl IN po_tbl_varchar30,
37: p_ship_to_org_id_tbl IN po_tbl_number,
38: p_item_id_tbl IN po_tbl_number,
39: p_txn_flow_header_id_tbl IN po_tbl_number,
40: p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,
41: p_value_basis_tbl IN po_tbl_varchar30,
42: p_purchase_basis_tbl IN po_tbl_varchar30, --bug7644072
35: PROCEDURE destination_type_code(p_id_tbl IN po_tbl_number,
36: p_dest_type_code_tbl IN po_tbl_varchar30,
37: p_ship_to_org_id_tbl IN po_tbl_number,
38: p_item_id_tbl IN po_tbl_number,
39: p_txn_flow_header_id_tbl IN po_tbl_number,
40: p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,
41: p_value_basis_tbl IN po_tbl_varchar30,
42: p_purchase_basis_tbl IN po_tbl_varchar30, --bug7644072
43: p_expense_accrual_code IN po_system_parameters.expense_accrual_code%TYPE,
40: p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,
41: p_value_basis_tbl IN po_tbl_varchar30,
42: p_purchase_basis_tbl IN po_tbl_varchar30, --bug7644072
43: p_expense_accrual_code IN po_system_parameters.expense_accrual_code%TYPE,
44: p_loc_outsourced_assembly_tbl IN po_tbl_number,
45: x_result_set_id IN OUT NOCOPY NUMBER,
46: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
47: x_result_type OUT NOCOPY VARCHAR2);
48:
45: x_result_set_id IN OUT NOCOPY NUMBER,
46: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
47: x_result_type OUT NOCOPY VARCHAR2);
48:
49: PROCEDURE destination_subinv(p_id_tbl IN po_tbl_number,
50: p_destination_subinv_tbl IN po_tbl_varchar30,
51: p_dest_type_code_tbl IN po_tbl_varchar30,
52: p_item_id_tbl IN po_tbl_number,
53: p_ship_to_org_id_tbl IN po_tbl_number,
48:
49: PROCEDURE destination_subinv(p_id_tbl IN po_tbl_number,
50: p_destination_subinv_tbl IN po_tbl_varchar30,
51: p_dest_type_code_tbl IN po_tbl_varchar30,
52: p_item_id_tbl IN po_tbl_number,
53: p_ship_to_org_id_tbl IN po_tbl_number,
54: p_loc_outsourced_assembly_tbl IN po_tbl_number,
55: x_result_set_id IN OUT NOCOPY NUMBER,
56: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
49: PROCEDURE destination_subinv(p_id_tbl IN po_tbl_number,
50: p_destination_subinv_tbl IN po_tbl_varchar30,
51: p_dest_type_code_tbl IN po_tbl_varchar30,
52: p_item_id_tbl IN po_tbl_number,
53: p_ship_to_org_id_tbl IN po_tbl_number,
54: p_loc_outsourced_assembly_tbl IN po_tbl_number,
55: x_result_set_id IN OUT NOCOPY NUMBER,
56: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
57: x_result_type OUT NOCOPY VARCHAR2);
50: p_destination_subinv_tbl IN po_tbl_varchar30,
51: p_dest_type_code_tbl IN po_tbl_varchar30,
52: p_item_id_tbl IN po_tbl_number,
53: p_ship_to_org_id_tbl IN po_tbl_number,
54: p_loc_outsourced_assembly_tbl IN po_tbl_number,
55: x_result_set_id IN OUT NOCOPY NUMBER,
56: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
57: x_result_type OUT NOCOPY VARCHAR2);
58:
55: x_result_set_id IN OUT NOCOPY NUMBER,
56: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
57: x_result_type OUT NOCOPY VARCHAR2);
58:
59: PROCEDURE wip_entity_id(p_id_tbl IN po_tbl_number,
60: p_wip_entity_id_tbl IN po_tbl_number,
61: p_wip_rep_schedule_id_tbl IN po_tbl_number,
62: p_dest_type_code_tbl IN po_tbl_varchar30,
63: p_destination_org_id_tbl IN po_tbl_number,
56: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
57: x_result_type OUT NOCOPY VARCHAR2);
58:
59: PROCEDURE wip_entity_id(p_id_tbl IN po_tbl_number,
60: p_wip_entity_id_tbl IN po_tbl_number,
61: p_wip_rep_schedule_id_tbl IN po_tbl_number,
62: p_dest_type_code_tbl IN po_tbl_varchar30,
63: p_destination_org_id_tbl IN po_tbl_number,
64: x_result_set_id IN OUT NOCOPY NUMBER,
57: x_result_type OUT NOCOPY VARCHAR2);
58:
59: PROCEDURE wip_entity_id(p_id_tbl IN po_tbl_number,
60: p_wip_entity_id_tbl IN po_tbl_number,
61: p_wip_rep_schedule_id_tbl IN po_tbl_number,
62: p_dest_type_code_tbl IN po_tbl_varchar30,
63: p_destination_org_id_tbl IN po_tbl_number,
64: x_result_set_id IN OUT NOCOPY NUMBER,
65: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
59: PROCEDURE wip_entity_id(p_id_tbl IN po_tbl_number,
60: p_wip_entity_id_tbl IN po_tbl_number,
61: p_wip_rep_schedule_id_tbl IN po_tbl_number,
62: p_dest_type_code_tbl IN po_tbl_varchar30,
63: p_destination_org_id_tbl IN po_tbl_number,
64: x_result_set_id IN OUT NOCOPY NUMBER,
65: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
66: x_result_type OUT NOCOPY VARCHAR2);
67:
64: x_result_set_id IN OUT NOCOPY NUMBER,
65: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
66: x_result_type OUT NOCOPY VARCHAR2);
67:
68: PROCEDURE prevent_encumbrance_flag(p_id_tbl IN po_tbl_number,
69: p_prevent_encum_flag_tbl IN po_tbl_varchar1,
70: p_dest_type_code_tbl IN po_tbl_varchar30,
71: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
72: p_wip_entity_id_tbl IN po_tbl_number, /* Encumbrance Project */
68: PROCEDURE prevent_encumbrance_flag(p_id_tbl IN po_tbl_number,
69: p_prevent_encum_flag_tbl IN po_tbl_varchar1,
70: p_dest_type_code_tbl IN po_tbl_varchar30,
71: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
72: p_wip_entity_id_tbl IN po_tbl_number, /* Encumbrance Project */
73: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
74: x_result_type OUT NOCOPY VARCHAR2);
75:
76: PROCEDURE charge_account_id(p_id_tbl IN po_tbl_number,
72: p_wip_entity_id_tbl IN po_tbl_number, /* Encumbrance Project */
73: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
74: x_result_type OUT NOCOPY VARCHAR2);
75:
76: PROCEDURE charge_account_id(p_id_tbl IN po_tbl_number,
77: p_charge_account_id_tbl IN po_tbl_number,
78: p_gl_date_tbl IN po_tbl_date,
79: p_chart_of_account_id IN NUMBER,
80: x_result_set_id IN OUT NOCOPY NUMBER,
73: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
74: x_result_type OUT NOCOPY VARCHAR2);
75:
76: PROCEDURE charge_account_id(p_id_tbl IN po_tbl_number,
77: p_charge_account_id_tbl IN po_tbl_number,
78: p_gl_date_tbl IN po_tbl_date,
79: p_chart_of_account_id IN NUMBER,
80: x_result_set_id IN OUT NOCOPY NUMBER,
81: x_result_type OUT NOCOPY VARCHAR2);
79: p_chart_of_account_id IN NUMBER,
80: x_result_set_id IN OUT NOCOPY NUMBER,
81: x_result_type OUT NOCOPY VARCHAR2);
82:
83: PROCEDURE budget_account_id(p_id_tbl IN po_tbl_number,
84: p_budget_account_id_tbl IN po_tbl_number,
85: p_gl_date_tbl IN po_tbl_date,
86: p_dest_type_code_tbl IN po_tbl_varchar30,
87: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
80: x_result_set_id IN OUT NOCOPY NUMBER,
81: x_result_type OUT NOCOPY VARCHAR2);
82:
83: PROCEDURE budget_account_id(p_id_tbl IN po_tbl_number,
84: p_budget_account_id_tbl IN po_tbl_number,
85: p_gl_date_tbl IN po_tbl_date,
86: p_dest_type_code_tbl IN po_tbl_varchar30,
87: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
88: p_chart_of_account_id IN NUMBER,
86: p_dest_type_code_tbl IN po_tbl_varchar30,
87: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
88: p_chart_of_account_id IN NUMBER,
89: p_po_encumberance_flag IN VARCHAR2,
90: p_wip_entity_id_tbl IN po_tbl_number, /* Encumbrance Project */
91: x_result_set_id IN OUT NOCOPY NUMBER,
92: x_result_type OUT NOCOPY VARCHAR2);
93:
94: PROCEDURE account_id(p_id_tbl IN po_tbl_number,
90: p_wip_entity_id_tbl IN po_tbl_number, /* Encumbrance Project */
91: x_result_set_id IN OUT NOCOPY NUMBER,
92: x_result_type OUT NOCOPY VARCHAR2);
93:
94: PROCEDURE account_id(p_id_tbl IN po_tbl_number,
95: p_account_id_tbl IN po_tbl_number,
96: p_gl_date_tbl IN po_tbl_date,
97: p_chart_of_account_id IN NUMBER,
98: p_message_name IN varchar2,
91: x_result_set_id IN OUT NOCOPY NUMBER,
92: x_result_type OUT NOCOPY VARCHAR2);
93:
94: PROCEDURE account_id(p_id_tbl IN po_tbl_number,
95: p_account_id_tbl IN po_tbl_number,
96: p_gl_date_tbl IN po_tbl_date,
97: p_chart_of_account_id IN NUMBER,
98: p_message_name IN varchar2,
99: p_column_name IN varchar2,
100: p_token_name IN varchar2,
101: x_result_set_id IN OUT NOCOPY NUMBER,
102: x_result_type OUT NOCOPY VARCHAR2);
103:
104: PROCEDURE project_acct_context(p_id_tbl IN po_tbl_number,
105: p_project_acct_ctx_tbl IN po_tbl_varchar30,
106: p_project_id_tbl IN po_tbl_number,
107: p_task_id_tbl IN po_tbl_number,
108: p_exp_type_tbl IN po_tbl_varchar30,
102: x_result_type OUT NOCOPY VARCHAR2);
103:
104: PROCEDURE project_acct_context(p_id_tbl IN po_tbl_number,
105: p_project_acct_ctx_tbl IN po_tbl_varchar30,
106: p_project_id_tbl IN po_tbl_number,
107: p_task_id_tbl IN po_tbl_number,
108: p_exp_type_tbl IN po_tbl_varchar30,
109: p_exp_org_id_tbl IN po_tbl_number,
110: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
103:
104: PROCEDURE project_acct_context(p_id_tbl IN po_tbl_number,
105: p_project_acct_ctx_tbl IN po_tbl_varchar30,
106: p_project_id_tbl IN po_tbl_number,
107: p_task_id_tbl IN po_tbl_number,
108: p_exp_type_tbl IN po_tbl_varchar30,
109: p_exp_org_id_tbl IN po_tbl_number,
110: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
111: x_result_type OUT NOCOPY VARCHAR2);
105: p_project_acct_ctx_tbl IN po_tbl_varchar30,
106: p_project_id_tbl IN po_tbl_number,
107: p_task_id_tbl IN po_tbl_number,
108: p_exp_type_tbl IN po_tbl_varchar30,
109: p_exp_org_id_tbl IN po_tbl_number,
110: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
111: x_result_type OUT NOCOPY VARCHAR2);
112:
113: PROCEDURE project_info(p_id_tbl IN po_tbl_number,
109: p_exp_org_id_tbl IN po_tbl_number,
110: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
111: x_result_type OUT NOCOPY VARCHAR2);
112:
113: PROCEDURE project_info(p_id_tbl IN po_tbl_number,
114: p_project_acct_ctx_tbl IN po_tbl_varchar30,
115: p_dest_type_code_tbl IN po_tbl_varchar30,
116: p_project_id_tbl IN po_tbl_number,
117: p_task_id_tbl IN po_tbl_number,
112:
113: PROCEDURE project_info(p_id_tbl IN po_tbl_number,
114: p_project_acct_ctx_tbl IN po_tbl_varchar30,
115: p_dest_type_code_tbl IN po_tbl_varchar30,
116: p_project_id_tbl IN po_tbl_number,
117: p_task_id_tbl IN po_tbl_number,
118: p_expenditure_type_tbl IN po_tbl_varchar30,
119: p_expenditure_org_id_tbl IN po_tbl_number,
120: p_ship_to_org_id_tbl IN po_tbl_number,
113: PROCEDURE project_info(p_id_tbl IN po_tbl_number,
114: p_project_acct_ctx_tbl IN po_tbl_varchar30,
115: p_dest_type_code_tbl IN po_tbl_varchar30,
116: p_project_id_tbl IN po_tbl_number,
117: p_task_id_tbl IN po_tbl_number,
118: p_expenditure_type_tbl IN po_tbl_varchar30,
119: p_expenditure_org_id_tbl IN po_tbl_number,
120: p_ship_to_org_id_tbl IN po_tbl_number,
121: p_need_by_date_tbl IN po_tbl_date,
115: p_dest_type_code_tbl IN po_tbl_varchar30,
116: p_project_id_tbl IN po_tbl_number,
117: p_task_id_tbl IN po_tbl_number,
118: p_expenditure_type_tbl IN po_tbl_varchar30,
119: p_expenditure_org_id_tbl IN po_tbl_number,
120: p_ship_to_org_id_tbl IN po_tbl_number,
121: p_need_by_date_tbl IN po_tbl_date,
122: p_promised_date_tbl IN po_tbl_date,
123: p_expenditure_item_date_tbl IN po_tbl_date,
116: p_project_id_tbl IN po_tbl_number,
117: p_task_id_tbl IN po_tbl_number,
118: p_expenditure_type_tbl IN po_tbl_varchar30,
119: p_expenditure_org_id_tbl IN po_tbl_number,
120: p_ship_to_org_id_tbl IN po_tbl_number,
121: p_need_by_date_tbl IN po_tbl_date,
122: p_promised_date_tbl IN po_tbl_date,
123: p_expenditure_item_date_tbl IN po_tbl_date,
124: p_ship_to_ou_id IN NUMBER,
121: p_need_by_date_tbl IN po_tbl_date,
122: p_promised_date_tbl IN po_tbl_date,
123: p_expenditure_item_date_tbl IN po_tbl_date,
124: p_ship_to_ou_id IN NUMBER,
125: p_deliver_to_person_id_tbl IN po_tbl_number,
126: p_agent_id_tbl IN po_tbl_number,
127: p_txn_flow_header_id_tbl IN po_tbl_number,
128: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
129: x_result_type OUT NOCOPY VARCHAR2);
122: p_promised_date_tbl IN po_tbl_date,
123: p_expenditure_item_date_tbl IN po_tbl_date,
124: p_ship_to_ou_id IN NUMBER,
125: p_deliver_to_person_id_tbl IN po_tbl_number,
126: p_agent_id_tbl IN po_tbl_number,
127: p_txn_flow_header_id_tbl IN po_tbl_number,
128: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
129: x_result_type OUT NOCOPY VARCHAR2);
130:
123: p_expenditure_item_date_tbl IN po_tbl_date,
124: p_ship_to_ou_id IN NUMBER,
125: p_deliver_to_person_id_tbl IN po_tbl_number,
126: p_agent_id_tbl IN po_tbl_number,
127: p_txn_flow_header_id_tbl IN po_tbl_number,
128: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
129: x_result_type OUT NOCOPY VARCHAR2);
130:
131: PROCEDURE tax_recovery_override_flag(p_id_tbl IN po_tbl_number,
127: p_txn_flow_header_id_tbl IN po_tbl_number,
128: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
129: x_result_type OUT NOCOPY VARCHAR2);
130:
131: PROCEDURE tax_recovery_override_flag(p_id_tbl IN po_tbl_number,
132: p_recovery_override_flag_tbl IN po_tbl_varchar1,
133: p_allow_tax_rate_override IN VARCHAR2,
134: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
135: x_result_type OUT NOCOPY VARCHAR2);
135: x_result_type OUT NOCOPY VARCHAR2);
136:
137: -- <
138: PROCEDURE ACRN_value_valid(
139: p_dist_id_tbl IN PO_TBL_NUMBER
140: , p_style_id_tbl IN PO_TBL_NUMBER
141: , p_ACRN_tbl IN PO_TBL_VARCHAR30
142: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
143: , x_result_type OUT NOCOPY VARCHAR2
136:
137: -- <
138: PROCEDURE ACRN_value_valid(
139: p_dist_id_tbl IN PO_TBL_NUMBER
140: , p_style_id_tbl IN PO_TBL_NUMBER
141: , p_ACRN_tbl IN PO_TBL_VARCHAR30
142: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
143: , x_result_type OUT NOCOPY VARCHAR2
144: );
145: -- <
146:
147:
148: -- CLM Partial Funding Changes
149: PROCEDURE partial_funded_flag(p_id_tbl IN po_tbl_number,
150: p_partial_funded_flag_tbl IN po_tbl_varchar1,
151: p_funded_value_tbl IN po_tbl_number,
152: p_style_id_tbl IN po_tbl_number,
153: p_po_encumberance_flag IN VARCHAR2,
147:
148: -- CLM Partial Funding Changes
149: PROCEDURE partial_funded_flag(p_id_tbl IN po_tbl_number,
150: p_partial_funded_flag_tbl IN po_tbl_varchar1,
151: p_funded_value_tbl IN po_tbl_number,
152: p_style_id_tbl IN po_tbl_number,
153: p_po_encumberance_flag IN VARCHAR2,
154: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
155: x_result_type OUT NOCOPY VARCHAR2);
148: -- CLM Partial Funding Changes
149: PROCEDURE partial_funded_flag(p_id_tbl IN po_tbl_number,
150: p_partial_funded_flag_tbl IN po_tbl_varchar1,
151: p_funded_value_tbl IN po_tbl_number,
152: p_style_id_tbl IN po_tbl_number,
153: p_po_encumberance_flag IN VARCHAR2,
154: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
155: x_result_type OUT NOCOPY VARCHAR2);
156: END PO_VAL_DISTRIBUTIONS2;