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);
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);
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,
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,
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,
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
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);
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,
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 */
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);
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,
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,
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,
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,
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,
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,
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);
136
137 -- <<ACRN proj start>>
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 -- <<ACRN proj start>>
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,
154 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
155 x_result_type OUT NOCOPY VARCHAR2);
156 END PO_VAL_DISTRIBUTIONS2;