1 PACKAGE PO_VAL_DISTRIBUTIONS2 AS
2 -- $Header: PO_VAL_DISTRIBUTIONS2.pls 120.7.12010000.2 2008/12/18 13:21:32 ggandhi 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 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
8 x_result_type OUT NOCOPY VARCHAR2);
9
10 PROCEDURE quantity_ordered(p_id_tbl IN po_tbl_number,
11 p_quantity_ordered_tbl IN po_tbl_number,
12 p_order_type_code_tbl IN po_tbl_varchar30,
13 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
14 x_result_type OUT NOCOPY VARCHAR2);
15
16 PROCEDURE destination_org_id(p_id_tbl IN po_tbl_number,
17 p_dest_org_id_tbl IN po_tbl_number,
18 p_ship_to_org_id_tbl IN po_tbl_number,
19 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
20 x_result_type OUT NOCOPY VARCHAR2);
21
22 PROCEDURE deliver_to_location_id(p_id_tbl IN po_tbl_number,
23 p_deliver_to_location_id_tbl IN po_tbl_number,
24 p_ship_to_org_id_tbl IN po_tbl_number,
25 x_result_set_id IN OUT NOCOPY NUMBER,
26 x_result_type OUT NOCOPY VARCHAR2);
27
28 PROCEDURE deliver_to_person_id(p_id_tbl IN po_tbl_number,
29 p_deliver_to_person_id_tbl IN po_tbl_number,
30 x_result_set_id IN OUT NOCOPY NUMBER,
31 x_result_type OUT NOCOPY VARCHAR2);
32
33 PROCEDURE destination_type_code(p_id_tbl IN po_tbl_number,
34 p_dest_type_code_tbl IN po_tbl_varchar30,
35 p_ship_to_org_id_tbl IN po_tbl_number,
36 p_item_id_tbl IN po_tbl_number,
37 p_txn_flow_header_id_tbl IN po_tbl_number,
38 p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,
39 p_value_basis_tbl IN po_tbl_varchar30,
40 p_purchase_basis_tbl IN po_tbl_varchar30, --bug7644072
41 p_expense_accrual_code IN po_system_parameters.expense_accrual_code%TYPE,
42 p_loc_outsourced_assembly_tbl IN po_tbl_number,
43 x_result_set_id IN OUT NOCOPY NUMBER,
44 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
45 x_result_type OUT NOCOPY VARCHAR2);
46
47 PROCEDURE destination_subinv(p_id_tbl IN po_tbl_number,
48 p_destination_subinv_tbl IN po_tbl_varchar30,
49 p_dest_type_code_tbl IN po_tbl_varchar30,
50 p_item_id_tbl IN po_tbl_number,
51 p_ship_to_org_id_tbl IN po_tbl_number,
52 p_loc_outsourced_assembly_tbl IN po_tbl_number,
53 x_result_set_id IN OUT NOCOPY NUMBER,
54 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
55 x_result_type OUT NOCOPY VARCHAR2);
56
57 PROCEDURE wip_entity_id(p_id_tbl IN po_tbl_number,
58 p_wip_entity_id_tbl IN po_tbl_number,
59 p_wip_rep_schedule_id_tbl IN po_tbl_number,
60 p_dest_type_code_tbl IN po_tbl_varchar30,
61 p_destination_org_id_tbl IN po_tbl_number,
62 x_result_set_id IN OUT NOCOPY NUMBER,
63 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
64 x_result_type OUT NOCOPY VARCHAR2);
65
66 PROCEDURE prevent_encumbrance_flag(p_id_tbl IN po_tbl_number,
67 p_prevent_encum_flag_tbl IN po_tbl_varchar1,
68 p_dest_type_code_tbl IN po_tbl_varchar30,
69 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
70 x_result_type OUT NOCOPY VARCHAR2);
71
72 PROCEDURE charge_account_id(p_id_tbl IN po_tbl_number,
73 p_charge_account_id_tbl IN po_tbl_number,
74 p_gl_date_tbl IN po_tbl_date,
75 p_chart_of_account_id IN NUMBER,
76 x_result_set_id IN OUT NOCOPY NUMBER,
77 x_result_type OUT NOCOPY VARCHAR2);
78
79 PROCEDURE budget_account_id(p_id_tbl IN po_tbl_number,
80 p_budget_account_id_tbl IN po_tbl_number,
81 p_gl_date_tbl IN po_tbl_date,
82 p_dest_type_code_tbl IN po_tbl_varchar30,
83 p_chart_of_account_id IN NUMBER,
84 p_po_encumberance_flag IN VARCHAR2,
85 x_result_set_id IN OUT NOCOPY NUMBER,
86 x_result_type OUT NOCOPY VARCHAR2);
87
88 PROCEDURE account_id(p_id_tbl IN po_tbl_number,
89 p_account_id_tbl IN po_tbl_number,
90 p_gl_date_tbl IN po_tbl_date,
91 p_chart_of_account_id IN NUMBER,
92 p_message_name IN varchar2,
93 p_column_name IN varchar2,
94 p_token_name IN varchar2,
95 x_result_set_id IN OUT NOCOPY NUMBER,
96 x_result_type OUT NOCOPY VARCHAR2);
97
98 PROCEDURE project_acct_context(p_id_tbl IN po_tbl_number,
99 p_project_acct_ctx_tbl IN po_tbl_varchar30,
100 p_project_id_tbl IN po_tbl_number,
101 p_task_id_tbl IN po_tbl_number,
102 p_exp_type_tbl IN po_tbl_varchar30,
103 p_exp_org_id_tbl IN po_tbl_number,
104 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
105 x_result_type OUT NOCOPY VARCHAR2);
106
107 PROCEDURE project_info(p_id_tbl IN po_tbl_number,
108 p_project_acct_ctx_tbl IN po_tbl_varchar30,
109 p_dest_type_code_tbl IN po_tbl_varchar30,
110 p_project_id_tbl IN po_tbl_number,
111 p_task_id_tbl IN po_tbl_number,
112 p_expenditure_type_tbl IN po_tbl_varchar30,
113 p_expenditure_org_id_tbl IN po_tbl_number,
114 p_ship_to_org_id_tbl IN po_tbl_number,
115 p_need_by_date_tbl IN po_tbl_date,
116 p_promised_date_tbl IN po_tbl_date,
117 p_expenditure_item_date_tbl IN po_tbl_date,
118 p_ship_to_ou_id IN NUMBER,
119 p_deliver_to_person_id_tbl IN po_tbl_number,
120 p_agent_id_tbl IN po_tbl_number,
121 p_txn_flow_header_id_tbl IN po_tbl_number,
122 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
123 x_result_type OUT NOCOPY VARCHAR2);
124
125 PROCEDURE tax_recovery_override_flag(p_id_tbl IN po_tbl_number,
126 p_recovery_override_flag_tbl IN po_tbl_varchar1,
127 p_allow_tax_rate_override IN VARCHAR2,
128 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
129 x_result_type OUT NOCOPY VARCHAR2);
130 END PO_VAL_DISTRIBUTIONS2;