1 PACKAGE INV_THIRD_PARTY_STOCK_PO_MDTR AUTHID CURRENT_USER AS
2 -- $Header: INVCPODS.pls 115.4 2002/12/07 00:34:53 dherring noship $ --
3 --+=======================================================================+
4 --| Copyright (c) 2002 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVCPODS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Consiged Inventory INV/PO dependency wrapper API |
13 --| HISTORY |
14 --| 09/30/2002 pseshadr Created |
15 --+========================================================================
16
17
18 --===================
19 -- PROCEDURES AND FUNCTIONS
20 --===================
21
22 --========================================================================
23 -- PROCEDURE : Get_Blanket_Number PUBLIC
24 -- PARAMETERS: p_inventory_item_id Item
25 -- p_vendor_site_id Vendor Site
26 -- p_organization_id Inventory Organization
27 -- x_document_header_id PO Header id
28 -- x_document_line_id PO line id
29 -- COMMENT : Return document_id if a valid blanket exists for item,
30 -- supplier site,organization combination.
31 -- This procedure is invoked to get the most recent blanket when
32 -- performing a Transfer to regular stock transaction.
33 --========================================================================
34 PROCEDURE Get_Blanket_Number
35 ( p_inventory_item_id IN NUMBER
36 , p_vendor_site_id IN NUMBER
37 , p_organization_id IN NUMBER
38 , x_document_header_id OUT NOCOPY NUMBER
39 , x_document_line_id OUT NOCOPY NUMBER
40 );
41
42
43 --========================================================================
44 -- PROCEDURE : Get_Asl_Info PUBLIC
45 -- PARAMETERS: p_item_id Item
46 -- p_vendor_id Vendor Id
47 -- p_vendor_site_id Vendor Site Id
48 -- p_using_organization_id organization
49 -- x_asl_id asl id
50 -- x_vendor_product_num vendor product num
51 -- x_purchasing_uom Purchasing UOM
52 -- COMMENT: Wrapper for get asl info procedure in purchasing
53 --========================================================================
54 PROCEDURE Get_Asl_Info
55 ( p_item_id IN NUMBER
56 , p_vendor_id IN NUMBER
57 , p_vendor_site_id IN NUMBER
58 , p_using_organization_id IN NUMBER
59 , x_asl_id OUT NOCOPY NUMBER
60 , x_vendor_product_num OUT NOCOPY VARCHAR2
61 , x_purchasing_uom OUT NOCOPY VARCHAR2
62 );
63
64 --========================================================================
65 -- PROCEDURE : Start_Workflow PUBLIC
66 -- PARAMETERS : p_coa_id Chart of Accounts Id
67 -- p_destination_type_code INVENTORY
68 -- p_type_lookup_code Document type
69 -- p_item_id Item
70 -- p_vendor_id Vendor
71 -- p_vendor_site_id Vendor Site
72 -- p_destination_organization_id Inventory Organization
73 -- p_po_encumberance_flag PO encumberance
74 -- p_accrual_account_id Accrual account
75 -- p_charge_account_id Charge Account
76 -- p_variance_account_id Variance Account
77 -- COMMENT : The above inputs are the only relevent parameters for
78 -- generation of accounts for consigned transaction. All
79 -- the other parameters that are required for the
80 -- procedure are passed in as NULL . This is a wrapper
81 -- to the PO Account generator.
82 --========================================================================
83
84 PROCEDURE Start_Workflow
85 ( p_charge_success IN OUT NOCOPY BOOLEAN
86 , p_budget_success IN OUT NOCOPY BOOLEAN
87 , p_accrual_success IN OUT NOCOPY BOOLEAN
88 , p_variance_success IN OUT NOCOPY BOOLEAN
89 , p_code_combination_id IN OUT NOCOPY NUMBER
90 , p_charge_account_id IN OUT NOCOPY NUMBER
91 , p_budget_account_id IN OUT NOCOPY NUMBER
92 , p_accrual_account_id IN OUT NOCOPY NUMBER
93 , p_variance_account_id IN OUT NOCOPY NUMBER
94 , p_charge_account_flex IN OUT NOCOPY VARCHAR2
95 , p_budget_account_flex IN OUT NOCOPY VARCHAR2
96 , p_accrual_account_flex IN OUT NOCOPY VARCHAR2
97 , p_variance_account_flex IN OUT NOCOPY VARCHAR2
98 , p_charge_account_desc IN OUT NOCOPY VARCHAR2
99 , p_budget_account_desc IN OUT NOCOPY VARCHAR2
100 , p_accrual_account_desc IN OUT NOCOPY VARCHAR2
101 , p_variance_account_desc IN OUT NOCOPY VARCHAR2
102 , p_coa_id IN NUMBER
103 , p_bom_resource_id IN NUMBER
104 , p_bom_cost_element_id IN NUMBER
105 , p_category_id IN NUMBER
106 , p_destination_type_code IN VARCHAR2
107 , p_deliver_to_location_id IN NUMBER
108 , p_destination_organization_id IN NUMBER
109 , p_destination_subinventory IN VARCHAR2
110 , p_expenditure_type IN VARCHAR2
111 , p_expenditure_organization_id IN NUMBER
112 , p_expenditure_item_date IN DATE
113 , p_item_id IN NUMBER
114 , p_line_type_id IN NUMBER
115 , p_result_billable_flag IN VARCHAR2
116 , p_agent_id IN NUMBER
117 , p_project_id IN NUMBER
118 , p_from_type_lookup_code IN VARCHAR2
119 , p_from_header_id IN NUMBER
120 , p_from_line_id IN NUMBER
121 , p_task_id IN NUMBER
122 , p_deliver_to_person_id IN NUMBER
123 , p_type_lookup_code IN VARCHAR2
124 , p_vendor_id IN NUMBER
125 , p_wip_entity_id IN NUMBER
126 , p_wip_entity_type IN VARCHAR2
127 , p_wip_line_id IN NUMBER
128 , p_wip_repetitive_schedule_id IN NUMBER
129 , p_wip_operation_seq_num IN NUMBER
130 , p_wip_resource_seq_num IN NUMBER
131 , p_po_encumberance_flag IN VARCHAR2
132 , p_gl_encumbered_date IN DATE
133 , p_wf_itemkey IN OUT NOCOPY VARCHAR2
134 , p_new_combination IN OUT NOCOPY BOOLEAN
135 , p_header_att1 IN VARCHAR2
136 , p_header_att2 IN VARCHAR2
137 , p_header_att3 IN VARCHAR2
138 , p_header_att4 IN VARCHAR2
139 , p_header_att5 IN VARCHAR2
140 , p_header_att6 IN VARCHAR2
141 , p_header_att7 IN VARCHAR2
142 , p_header_att8 IN VARCHAR2
143 , p_header_att9 IN VARCHAR2
144 , p_header_att10 IN VARCHAR2
145 , p_header_att11 IN VARCHAR2
146 , p_header_att12 IN VARCHAR2
147 , p_header_att13 IN VARCHAR2
148 , p_header_att14 IN VARCHAR2
149 , p_header_att15 IN VARCHAR2
150 , p_line_att1 IN VARCHAR2
151 , p_line_att2 IN VARCHAR2
152 , p_line_att3 IN VARCHAR2
153 , p_line_att4 IN VARCHAR2
154 , p_line_att5 IN VARCHAR2
155 , p_line_att6 IN VARCHAR2
156 , p_line_att7 IN VARCHAR2
157 , p_line_att8 IN VARCHAR2
158 , p_line_att9 IN VARCHAR2
159 , p_line_att10 IN VARCHAR2
160 , p_line_att11 IN VARCHAR2
161 , p_line_att12 IN VARCHAR2
162 , p_line_att13 IN VARCHAR2
163 , p_line_att14 IN VARCHAR2
164 , p_line_att15 IN VARCHAR2
165 , p_shipment_att1 IN VARCHAR2
166 , p_shipment_att2 IN VARCHAR2
167 , p_shipment_att3 IN VARCHAR2
168 , p_shipment_att4 IN VARCHAR2
169 , p_shipment_att5 IN VARCHAR2
170 , p_shipment_att6 IN VARCHAR2
171 , p_shipment_att7 IN VARCHAR2
172 , p_shipment_att8 IN VARCHAR2
173 , p_shipment_att9 IN VARCHAR2
174 , p_shipment_att10 IN VARCHAR2
175 , p_shipment_att11 IN VARCHAR2
176 , p_shipment_att12 IN VARCHAR2
177 , p_shipment_att13 IN VARCHAR2
178 , p_shipment_att14 IN VARCHAR2
179 , p_shipment_att15 IN VARCHAR2
180 , p_distribution_att1 IN VARCHAR2
181 , p_distribution_att2 IN VARCHAR2
182 , p_distribution_att3 IN VARCHAR2
183 , p_distribution_att4 IN VARCHAR2
184 , p_distribution_att5 IN VARCHAR2
185 , p_distribution_att6 IN VARCHAR2
186 , p_distribution_att7 IN VARCHAR2
187 , p_distribution_att8 IN VARCHAR2
188 , p_distribution_att9 IN VARCHAR2
189 , p_distribution_att10 IN VARCHAR2
190 , p_distribution_att11 IN VARCHAR2
191 , p_distribution_att12 IN VARCHAR2
192 , p_distribution_att13 IN VARCHAR2
193 , p_distribution_att14 IN VARCHAR2
194 , p_distribution_att15 IN VARCHAR2
195 , FB_ERROR_MSG IN OUT NOCOPY VARCHAR2
196 , p_Award_id IN NUMBER
197 , p_vendor_site_id IN NUMBER
198 );
199
200 --========================================================================
201 -- PROCEDURE : Create_Documents PUBLIC
202 -- PARAMETERS : p_batch_id Batch Id
203 -- p_document_id Document Id that was created
204 -- p_document_number Document number
205 -- p_line Number of lines created
206 -- x_error_code Return status
207 -- COMMENT : Wrapper to the PO autocreate to create document
208 --========================================================================
209 PROCEDURE create_documents
210 ( p_batch_id IN NUMBER
211 , p_document_id IN OUT NOCOPY NUMBER
212 , p_document_number IN OUT NOCOPY VARCHAR2
213 , p_line IN OUT NOCOPY NUMBER
214 , x_error_code OUT NOCOPY NUMBER
215 );
216
217 --========================================================================
218 -- PROCEDURE : Get_Break_Price PUBLIC
219 -- PARAMETERS: p_order_quantity Quantity
220 -- p_ship_to_org Ship to Org
221 -- p_ship_to_loc Ship to location
222 -- p_po_line_id PO Line Id
223 -- p_cum_flag Cumulative flag
224 -- p_need_by_date Need by Date
225 -- p_line_location_id Line location
226 -- x_po_price PO price without tax
227 -- COMMENT : Wrapper to the PO API to get price breaks
228 --========================================================================
229 PROCEDURE get_break_price
230 ( p_order_quantity IN NUMBER
231 , p_ship_to_org IN NUMBER
232 , p_ship_to_loc IN NUMBER
233 , p_po_line_id IN NUMBER
234 , p_cum_flag IN BOOLEAN
235 , p_need_by_date IN DATE
236 , p_line_location_id IN NUMBER
237 , x_po_price OUT NOCOPY NUMBER
238 );
239
240 --========================================================================
241 -- FUNCTION : Is_Global PUBLIC
242 -- PARAMETERS: p_header_id Blanket header Id
243 -- COMMENT : Wrapper to the PO API to check for Global Agreement
244 --========================================================================
245 FUNCTION is_global
246 ( p_header_id IN NUMBER
247 ) RETURN BOOLEAN;
248
249 END INV_THIRD_PARTY_STOCK_PO_MDTR;