[Home] [Help]
PACKAGE: APPS.PO_WF_BUILD_ACCOUNT_INIT
Source
1 PACKAGE PO_WF_BUILD_ACCOUNT_INIT AUTHID CURRENT_USER AS
2 /* $Header: POXWPOSS.pls 120.4 2010/02/28 13:54:10 ssreekum ship $ */
3
4 /*=======================================================================+
5 | FILENAME
6 | POXWPOSS.pls
7 |
8 | DESCRIPTION
9 | PL/SQL specifications for package: PO_WF_BUILD_ACCOUNT_INIT
10 |
11 | NOTES Imran Ali Created 08/11/97
12 | MODIFIED (MM/DD/YY)
13 *=======================================================================*/
14
15 --
16 -- FUNCTION Start_Workflow
17 --
18
19
20 FUNCTION all_returned_segments_null_sv(x_charge_account_flex VARCHAR2,
21 x_coa_id NUMBER)
22 RETURN BOOLEAN;
23
24
25 FUNCTION Start_Workflow(
26
27 --< Shared Proc FPJ Start >
28 x_purchasing_ou_id IN NUMBER, -- POU's org ID
29 x_transaction_flow_header_id IN NUMBER,
30 x_dest_charge_success IN OUT NOCOPY BOOLEAN,
31 x_dest_variance_success IN OUT NOCOPY BOOLEAN,
32 x_dest_charge_account_id IN OUT NOCOPY NUMBER,
33 x_dest_variance_account_id IN OUT NOCOPY NUMBER,
34 x_dest_charge_account_desc IN OUT NOCOPY VARCHAR2,
35 x_dest_variance_account_desc IN OUT NOCOPY VARCHAR2,
36 x_dest_charge_account_flex IN OUT NOCOPY VARCHAR2,
37 x_dest_variance_account_flex IN OUT NOCOPY VARCHAR2,
38 --< Shared Proc FPJ End >
39
40 x_charge_success IN OUT NOCOPY BOOLEAN,
41 x_budget_success IN OUT NOCOPY BOOLEAN,
42 x_accrual_success IN OUT NOCOPY BOOLEAN,
43 x_variance_success IN OUT NOCOPY BOOLEAN,
44 x_code_combination_id IN OUT NOCOPY NUMBER,
45 x_budget_account_id IN OUT NOCOPY NUMBER,
46 x_accrual_account_id IN OUT NOCOPY NUMBER,
47 x_variance_account_id IN OUT NOCOPY NUMBER,
48 x_charge_account_flex IN OUT NOCOPY VARCHAR2,
49 x_budget_account_flex IN OUT NOCOPY VARCHAR2,
50 x_accrual_account_flex IN OUT NOCOPY VARCHAR2,
51 x_variance_account_flex IN OUT NOCOPY VARCHAR2,
52 x_charge_account_desc IN OUT NOCOPY VARCHAR2,
53 x_budget_account_desc IN OUT NOCOPY VARCHAR2,
54 x_accrual_account_desc IN OUT NOCOPY VARCHAR2,
55 x_variance_account_desc IN OUT NOCOPY VARCHAR2,
56 x_coa_id NUMBER,
57 x_bom_resource_id NUMBER,
58 x_bom_cost_element_id NUMBER,
59 x_category_id NUMBER,
60 x_destination_type_code VARCHAR2,
61 x_deliver_to_location_id NUMBER,
62 x_destination_organization_id NUMBER,
63 x_destination_subinventory VARCHAR2,
64 x_expenditure_type VARCHAR2,
65 x_expenditure_organization_id NUMBER,
66 x_expenditure_item_date DATE,
67 x_item_id NUMBER,
68 x_line_type_id NUMBER,
69 x_result_billable_flag VARCHAR2,
70 x_agent_id NUMBER,
71 x_project_id NUMBER,
72 x_from_type_lookup_code VARCHAR2,
73 x_from_header_id NUMBER,
74 x_from_line_id NUMBER,
75 x_task_id NUMBER,
76 x_deliver_to_person_id NUMBER,
77 x_type_lookup_code VARCHAR2,
78 x_vendor_id NUMBER,
79 x_wip_entity_id NUMBER,
80 x_wip_entity_type VARCHAR2,
81 x_wip_line_id NUMBER,
82 x_wip_repetitive_schedule_id NUMBER,
83 x_wip_operation_seq_num NUMBER,
84 x_wip_resource_seq_num NUMBER,
85 x_po_encumberance_flag VARCHAR2,
86 x_gl_encumbered_date DATE,
87
88 -- because of changes due to WF synch mode this input parameter is not used.
89 wf_itemkey IN OUT NOCOPY VARCHAR2,
90 x_new_combination IN OUT NOCOPY BOOLEAN,
91
92 header_att1 VARCHAR2, header_att2 VARCHAR2, header_att3 VARCHAR2,
93 header_att4 VARCHAR2, header_att5 VARCHAR2, header_att6 VARCHAR2,
94 header_att7 VARCHAR2, header_att8 VARCHAR2, header_att9 VARCHAR2,
95 header_att10 VARCHAR2, header_att11 VARCHAR2, header_att12 VARCHAR2,
96 header_att13 VARCHAR2, header_att14 VARCHAR2, header_att15 VARCHAR2,
97
98 line_att1 VARCHAR2, line_att2 VARCHAR2, line_att3 VARCHAR2,
99 line_att4 VARCHAR2, line_att5 VARCHAR2, line_att6 VARCHAR2,
100 line_att7 VARCHAR2, line_att8 VARCHAR2, line_att9 VARCHAR2,
101 line_att10 VARCHAR2, line_att11 VARCHAR2, line_att12 VARCHAR2,
102 line_att13 VARCHAR2, line_att14 VARCHAR2, line_att15 VARCHAR2,
103
104 shipment_att1 VARCHAR2, shipment_att2 VARCHAR2, shipment_att3 VARCHAR2,
105 shipment_att4 VARCHAR2, shipment_att5 VARCHAR2, shipment_att6 VARCHAR2,
106 shipment_att7 VARCHAR2, shipment_att8 VARCHAR2, shipment_att9 VARCHAR2,
107 shipment_att10 VARCHAR2, shipment_att11 VARCHAR2, shipment_att12 VARCHAR2,
108 shipment_att13 VARCHAR2, shipment_att14 VARCHAR2, shipment_att15 VARCHAR2,
109
110 distribution_att1 VARCHAR2, distribution_att2 VARCHAR2,
111 distribution_att3 VARCHAR2, distribution_att4 VARCHAR2,
112 distribution_att5 VARCHAR2, distribution_att6 VARCHAR2,
113 distribution_att7 VARCHAR2, distribution_att8 VARCHAR2,
114 distribution_att9 VARCHAR2, distribution_att10 VARCHAR2,
115 distribution_att11 VARCHAR2, distribution_att12 VARCHAR2,
116 distribution_att13 VARCHAR2, distribution_att14 VARCHAR2,
117 distribution_att15 VARCHAR2,
118
119 FB_ERROR_MSG IN OUT NOCOPY VARCHAR2,
120 p_distribution_type IN VARCHAR2 DEFAULT NULL, --<Complex Work R12>
121 p_payment_type IN VARCHAR2 DEFAULT NULL, --<Complex Work R12>
122 x_award_id NUMBER DEFAULT NULL, --OGM_0.0 changes added award_id
123 x_vendor_site_id NUMBER DEFAULT NULL, -- B1548597 RVK Common Receiving
124 p_func_unit_price IN NUMBER DEFAULT NULL, --<BUG 3407630>, Bug 3463242
125 p_clm_misc_loa IN VARCHAR2 DEFAULT NULL --<Clm Fed Fields>
126 ) RETURN BOOLEAN;
127
128 -- Bug# 3222499 : Overload the function to maintain the old signature
129 FUNCTION Start_Workflow(
130 x_charge_success IN OUT NOCOPY BOOLEAN,
131 x_budget_success IN OUT NOCOPY BOOLEAN,
132 x_accrual_success IN OUT NOCOPY BOOLEAN,
133 x_variance_success IN OUT NOCOPY BOOLEAN,
134 x_code_combination_id IN OUT NOCOPY NUMBER,
135 x_budget_account_id IN OUT NOCOPY NUMBER,
136 x_accrual_account_id IN OUT NOCOPY NUMBER,
137 x_variance_account_id IN OUT NOCOPY NUMBER,
138 x_charge_account_flex IN OUT NOCOPY VARCHAR2,
139 x_budget_account_flex IN OUT NOCOPY VARCHAR2,
140 x_accrual_account_flex IN OUT NOCOPY VARCHAR2,
141 x_variance_account_flex IN OUT NOCOPY VARCHAR2,
142 x_charge_account_desc IN OUT NOCOPY VARCHAR2,
143 x_budget_account_desc IN OUT NOCOPY VARCHAR2,
144 x_accrual_account_desc IN OUT NOCOPY VARCHAR2,
145 x_variance_account_desc IN OUT NOCOPY VARCHAR2,
146 x_coa_id NUMBER,
147 x_bom_resource_id NUMBER,
148 x_bom_cost_element_id NUMBER,
149 x_category_id NUMBER,
150 x_destination_type_code VARCHAR2,
151 x_deliver_to_location_id NUMBER,
152 x_destination_organization_id NUMBER,
153 x_destination_subinventory VARCHAR2,
154 x_expenditure_type VARCHAR2,
155 x_expenditure_organization_id NUMBER,
156 x_expenditure_item_date DATE,
157 x_item_id NUMBER,
158 x_line_type_id NUMBER,
159 x_result_billable_flag VARCHAR2,
160 x_agent_id NUMBER,
161 x_project_id NUMBER,
162 x_from_type_lookup_code VARCHAR2,
163 x_from_header_id NUMBER,
164 x_from_line_id NUMBER,
165 x_task_id NUMBER,
166 x_deliver_to_person_id NUMBER,
167 x_type_lookup_code VARCHAR2,
168 x_vendor_id NUMBER,
169 x_wip_entity_id NUMBER,
170 x_wip_entity_type VARCHAR2,
171 x_wip_line_id NUMBER,
172 x_wip_repetitive_schedule_id NUMBER,
173 x_wip_operation_seq_num NUMBER,
174 x_wip_resource_seq_num NUMBER,
175 x_po_encumberance_flag VARCHAR2,
176 x_gl_encumbered_date DATE,
177
178 -- because of changes due to WF synch mode this input parameter is not used.
179 wf_itemkey IN OUT NOCOPY VARCHAR2,
180 x_new_combination IN OUT NOCOPY BOOLEAN,
181
182 header_att1 VARCHAR2, header_att2 VARCHAR2, header_att3 VARCHAR2,
183 header_att4 VARCHAR2, header_att5 VARCHAR2, header_att6 VARCHAR2,
184 header_att7 VARCHAR2, header_att8 VARCHAR2, header_att9 VARCHAR2,
185 header_att10 VARCHAR2, header_att11 VARCHAR2, header_att12 VARCHAR2,
186 header_att13 VARCHAR2, header_att14 VARCHAR2, header_att15 VARCHAR2,
187
188 line_att1 VARCHAR2, line_att2 VARCHAR2, line_att3 VARCHAR2,
189 line_att4 VARCHAR2, line_att5 VARCHAR2, line_att6 VARCHAR2,
190 line_att7 VARCHAR2, line_att8 VARCHAR2, line_att9 VARCHAR2,
191 line_att10 VARCHAR2, line_att11 VARCHAR2, line_att12 VARCHAR2,
192 line_att13 VARCHAR2, line_att14 VARCHAR2, line_att15 VARCHAR2,
193
194 shipment_att1 VARCHAR2, shipment_att2 VARCHAR2, shipment_att3 VARCHAR2,
195 shipment_att4 VARCHAR2, shipment_att5 VARCHAR2, shipment_att6 VARCHAR2,
196 shipment_att7 VARCHAR2, shipment_att8 VARCHAR2, shipment_att9 VARCHAR2,
197 shipment_att10 VARCHAR2, shipment_att11 VARCHAR2, shipment_att12 VARCHAR2,
198 shipment_att13 VARCHAR2, shipment_att14 VARCHAR2, shipment_att15 VARCHAR2,
199
200 distribution_att1 VARCHAR2, distribution_att2 VARCHAR2,
201 distribution_att3 VARCHAR2, distribution_att4 VARCHAR2,
202 distribution_att5 VARCHAR2, distribution_att6 VARCHAR2,
203 distribution_att7 VARCHAR2, distribution_att8 VARCHAR2,
204 distribution_att9 VARCHAR2, distribution_att10 VARCHAR2,
205 distribution_att11 VARCHAR2, distribution_att12 VARCHAR2,
206 distribution_att13 VARCHAR2, distribution_att14 VARCHAR2,
207 distribution_att15 VARCHAR2,
208
209 FB_ERROR_MSG IN OUT NOCOPY VARCHAR2,
210 p_distribution_type IN VARCHAR2 DEFAULT NULL, --<Complex Work R12>
211 p_payment_type IN VARCHAR2 DEFAULT NULL, --<Complex Work R12>
212 x_award_id NUMBER DEFAULT NULL, --OGM_0.0 changes added award_id
213 x_vendor_site_id NUMBER DEFAULT NULL, -- B1548597 RVK Common Receiving
214 p_func_unit_price IN NUMBER DEFAULT NULL, --<BUG 3407630>, Bug 3463242
215 p_clm_misc_loa IN VARCHAR2 DEFAULT NULL --<Clm Fed Fields>
216 ) RETURN BOOLEAN;
217
218 PROCEDURE debug_on;
219
220 PROCEDURE debug_off;
221
222 --< Shared Proc FPJ Start >
223
224 -- The following 2 global constants are used to define the flow type
225 -- for the PO AG workflow.
226 g_po_accounts CONSTANT VARCHAR2(25) := 'PO_ACCOUNTS';
227 g_destination_accounts CONSTANT VARCHAR2(25) := 'DESTINATION_ACCOUNTS';
228
229 --< Shared Proc FPJ End >
230
231 END PO_WF_BUILD_ACCOUNT_INIT;