[Home] [Help]
PACKAGE: APPS.PO_ACCOUNT_HELPER
Source
1 PACKAGE PO_ACCOUNT_HELPER AUTHID CURRENT_USER AS
2 -- $Header: PO_ACCOUNT_HELPER.pls 120.4.12020000.5 2013/04/21 13:08:19 akyanama ship $
3
4 -- initial revision uses FPJ/complex work signature
5 FUNCTION build_accounts(
6 x_purchasing_ou_id IN NUMBER -- POU's org ID
7 , x_transaction_flow_header_id IN NUMBER
8 , x_dest_charge_success IN OUT NOCOPY BOOLEAN
9 , x_dest_variance_success IN OUT NOCOPY BOOLEAN
10 , x_dest_charge_account_id IN OUT NOCOPY NUMBER
11 , x_dest_variance_account_id IN OUT NOCOPY NUMBER
12 , x_dest_charge_account_desc IN OUT NOCOPY VARCHAR2
13 , x_dest_variance_account_desc IN OUT NOCOPY VARCHAR2
14 , x_dest_charge_account_flex IN OUT NOCOPY VARCHAR2
15 , x_dest_variance_account_flex IN OUT NOCOPY VARCHAR2
16
17 , x_charge_success IN OUT NOCOPY BOOLEAN
18 , x_budget_success IN OUT NOCOPY BOOLEAN
19 , x_accrual_success IN OUT NOCOPY BOOLEAN
20 , x_variance_success IN OUT NOCOPY BOOLEAN
21 , x_code_combination_id IN OUT NOCOPY NUMBER
22 , x_budget_account_id IN OUT NOCOPY NUMBER
23 , x_accrual_account_id IN OUT NOCOPY NUMBER
24 , x_variance_account_id IN OUT NOCOPY NUMBER
25 , x_charge_account_flex IN OUT NOCOPY VARCHAR2
26 , x_budget_account_flex IN OUT NOCOPY VARCHAR2
27 , x_accrual_account_flex IN OUT NOCOPY VARCHAR2
28 , x_variance_account_flex IN OUT NOCOPY VARCHAR2
29 , x_charge_account_desc IN OUT NOCOPY VARCHAR2
30 , x_budget_account_desc IN OUT NOCOPY VARCHAR2
31 , x_accrual_account_desc IN OUT NOCOPY VARCHAR2
32 , x_variance_account_desc IN OUT NOCOPY VARCHAR2
33 , x_coa_id NUMBER
34 , x_bom_resource_id NUMBER
35 , x_bom_cost_element_id NUMBER
36 , x_category_id NUMBER
37 , x_destination_type_code VARCHAR2
38 , x_deliver_to_location_id NUMBER
39 , x_destination_organization_id NUMBER
40 , x_destination_subinventory VARCHAR2
41 , x_expenditure_type VARCHAR2
42 , x_expenditure_organization_id NUMBER
43 , x_expenditure_item_date DATE
44 , x_item_id NUMBER
45 , x_line_type_id NUMBER
46 , x_result_billable_flag VARCHAR2
47 , x_agent_id NUMBER
48 , x_project_id NUMBER
49 , x_from_type_lookup_code VARCHAR2
50 , x_from_header_id NUMBER
51 , x_from_line_id NUMBER
52 , x_task_id NUMBER
53 , x_deliver_to_person_id NUMBER
54 , x_type_lookup_code VARCHAR2
55 , x_vendor_id NUMBER
56 , x_wip_entity_id NUMBER
57 , x_wip_entity_type VARCHAR2
58 , x_wip_line_id NUMBER
59 , x_wip_repetitive_schedule_id NUMBER
60 , x_wip_operation_seq_num NUMBER
61 , x_wip_resource_seq_num NUMBER
62 , x_po_encumberance_flag VARCHAR2
63 , x_gl_encumbered_date DATE
64
65 , wf_itemkey IN OUT NOCOPY VARCHAR2
66 , x_new_combination IN OUT NOCOPY BOOLEAN
67
68 , header_att1 VARCHAR2
69 , header_att2 VARCHAR2
70 , header_att3 VARCHAR2
71 , header_att4 VARCHAR2
72 , header_att5 VARCHAR2
73 , header_att6 VARCHAR2
74 , header_att7 VARCHAR2
75 , header_att8 VARCHAR2
76 , header_att9 VARCHAR2
77 , header_att10 VARCHAR2
78 , header_att11 VARCHAR2
79 , header_att12 VARCHAR2
80 , header_att13 VARCHAR2
81 , header_att14 VARCHAR2
82 , header_att15 VARCHAR2
83
84 , line_att1 VARCHAR2
85 , line_att2 VARCHAR2
86 , line_att3 VARCHAR2
87 , line_att4 VARCHAR2
88 , line_att5 VARCHAR2
89 , line_att6 VARCHAR2
90 , line_att7 VARCHAR2
91 , line_att8 VARCHAR2
92 , line_att9 VARCHAR2
93 , line_att10 VARCHAR2
94 , line_att11 VARCHAR2
95 , line_att12 VARCHAR2
96 , line_att13 VARCHAR2
97 , line_att14 VARCHAR2
98 , line_att15 VARCHAR2
99
100 , shipment_att1 VARCHAR2
101 , shipment_att2 VARCHAR2
102 , shipment_att3 VARCHAR2
103 , shipment_att4 VARCHAR2
104 , shipment_att5 VARCHAR2
105 , shipment_att6 VARCHAR2
106 , shipment_att7 VARCHAR2
107 , shipment_att8 VARCHAR2
108 , shipment_att9 VARCHAR2
109 , shipment_att10 VARCHAR2
110 , shipment_att11 VARCHAR2
111 , shipment_att12 VARCHAR2
112 , shipment_att13 VARCHAR2
113 , shipment_att14 VARCHAR2
114 , shipment_att15 VARCHAR2
115
116 , distribution_att1 VARCHAR2
117 , distribution_att2 VARCHAR2
118 , distribution_att3 VARCHAR2
119 , distribution_att4 VARCHAR2
120 , distribution_att5 VARCHAR2
121 , distribution_att6 VARCHAR2
122 , distribution_att7 VARCHAR2
123 , distribution_att8 VARCHAR2
124 , distribution_att9 VARCHAR2
125 , distribution_att10 VARCHAR2
126 , distribution_att11 VARCHAR2
127 , distribution_att12 VARCHAR2
128 , distribution_att13 VARCHAR2
129 , distribution_att14 VARCHAR2
130 , distribution_att15 VARCHAR2
131
132 , FB_ERROR_MSG IN OUT NOCOPY VARCHAR2
133 , p_distribution_type IN VARCHAR2 DEFAULT NULL
134 , p_payment_type IN VARCHAR2 DEFAULT NULL
135 , x_award_id NUMBER DEFAULT NULL
136 , x_vendor_site_id NUMBER DEFAULT NULL
137 , p_func_unit_price IN NUMBER DEFAULT NULL
138 , p_distribution_id IN NUMBER --<HTML Orders/Agreements R12>
139 , p_award_number IN VARCHAR2 --<HTML Orders/Agreements R12>
140 , p_clm_misc_loa IN VARCHAR2 DEFAULT NULL --<CLM fed fields>
141 ) RETURN BOOLEAN;
142 /*Changed the procedure spec for ACRN refactoring and Regenerating*/
143 PROCEDURE BUILD_ACRN(p_header_id IN NUMBER,
144 P_DIST_ID_TBL IN PO_TBL_NUMBER,
145 P_CODE_ID_TBL IN PO_TBL_NUMBER,
146 P_ACRN_TBL IN PO_TBL_VARCHAR30,
147 P_LOA_TBL IN PO_TBL_VARCHAR30,
148 P_CHANGE_STAT_TBL IN PO_TBL_VARCHAR30,
149 P_REGEN_Y_N IN VARCHAR2,
150 X_ACRN_TBL OUT NOCOPY PO_TBL_VARCHAR30,
151 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
152 X_RETURN_MESSAGE OUT NOCOPY PO_TBL_VARCHAR2000,
153 X_MESSAGE_TOKEN OUT NOCOPY PO_TBL_VARCHAR2000);
154 /*END Changes the procedure spec for ACRN refactoring and Regenerating*/
155
156 PROCEDURE IS_VALID_ACRN(P_ACRN IN VARCHAR2,
157 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
158 X_RETURN_MESSAGE OUT NOCOPY VARCHAR2);
159
160 --<Bug 15917496>: added procedure online_rebuild_accounts
161 PROCEDURE online_rebuild_accounts
162 (
163 p_document_id IN NUMBER
164 , p_document_type IN VARCHAR2
165 , p_document_subtype IN VARCHAR2
166 , p_draft_id IN NUMBER DEFAULT NULL
167 , x_online_report_id OUT NOCOPY NUMBER
168 , x_return_status OUT NOCOPY VARCHAR2 --E: error, S: success
169 );
170 --Bug 16518955
171 PROCEDURE BUILD_ACRN_WRAP(p_header_id IN NUMBER,
172 p_dist_id_tbl IN PO_TBL_NUMBER,
173 p_code_id_tbl IN PO_TBL_NUMBER,
174 p_acrn_tbl IN PO_TBL_VARCHAR30,
175 p_loa_tbl IN PO_TBL_VARCHAR30,
176 p_change_stat_tbl IN PO_TBL_VARCHAR30,
177 p_regen_y_n IN VARCHAR2,
178 x_acrn_tbl OUT nocopy PO_TBL_VARCHAR30,
179 x_return_status OUT nocopy VARCHAR2,
180 x_return_message OUT nocopy PO_TBL_VARCHAR2000,
181 x_message_token OUT nocopy PO_TBL_VARCHAR2000);
182 --Bug 16518955
183 END PO_ACCOUNT_HELPER;