eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PO_CREATE_REQUISITION_SV

Source


1 Package PO_CREATE_REQUISITION_SV AUTHID CURRENT_USER AS
2 /* $Header: POXCARQS.pls 120.1 2005/06/10 01:46:43 kpsingh noship $ */
3 --
4 -- Purpose: To create approved internal / purchase requisition
5 --
6 -- MODIFICATION HISTORY
7 -- Person      Date     Comments
8 -- ---------   ------   ------------------------------------------
9 -- kperiasa    08/01/01 Created Package
10 -- davidng     05/24/02 Changed p_Init_Msg_List to be assigned the value FND_API.G_TRUE instead of FND_API.G_FALSE
11 -- davidng     10/08/03 <SERVICES FPJ> Added order_type_lookup_code, purchase_basis
12 --                      and matching_basis record type line_rec_type
13 
14 TYPE Header_Rec_Type IS RECORD
15 (requisition_header_id		po_requisition_headers_all.requisition_header_id%TYPE
16 ,preparer_id			po_requisition_headers_all.preparer_id%TYPE
17 ,last_update_date		po_requisition_headers_all. last_update_date%TYPE
18 ,last_updated_by		po_requisition_headers_all.last_updated_by%TYPE
19 ,segment1			po_requisition_headers_all.segment1%TYPE
20 ,summary_flag			po_requisition_headers_all.summary_flag%TYPE
21 ,enabled_flag			po_requisition_headers_all.enabled_flag%TYPE
22 ,segment2			po_requisition_headers_all.segment2%TYPE
23 ,segment3			po_requisition_headers_all.segment3%TYPE
24 ,segment4			po_requisition_headers_all.segment4%TYPE
25 ,segment5			po_requisition_headers_all.segment5%TYPE
26 ,start_date_active		po_requisition_headers_all.start_date_active%TYPE
27 ,end_date_active		po_requisition_headers_all.end_date_active%TYPE
28 ,last_update_login		po_requisition_headers_all.last_update_login%TYPE
29 ,creation_date			po_requisition_headers_all.creation_date%TYPE
30 ,created_by			po_requisition_headers_all.created_by%TYPE
31 ,description			po_requisition_headers_all.description%TYPE
32 ,authorization_status		po_requisition_headers_all.authorization_status%TYPE
33 ,note_to_authorizer		po_requisition_headers_all.note_to_authorizer%TYPE
34 ,type_lookup_code		po_requisition_headers_all.type_lookup_code%TYPE
35 ,transferred_to_oe_flag		po_requisition_headers_all.transferred_to_oe_flag%TYPE
36 ,attribute_category		po_requisition_headers_all.attribute_category%TYPE
37 ,attribute1			po_requisition_headers_all.attribute1%TYPE
38 ,attribute2			po_requisition_headers_all.attribute2%TYPE
39 ,attribute3			po_requisition_headers_all.attribute3%TYPE
40 ,attribute4			po_requisition_headers_all.attribute4%TYPE
41 ,attribute5			po_requisition_headers_all.attribute5%TYPE
42 ,on_line_flag			po_requisition_headers_all.on_line_flag%TYPE
43 ,attribute6			po_requisition_headers_all.attribute6%TYPE
44 ,attribute7			po_requisition_headers_all.attribute7%TYPE
45 ,attribute8			po_requisition_headers_all.attribute8%TYPE
46 ,attribute9			po_requisition_headers_all.attribute9%TYPE
47 ,attribute10			po_requisition_headers_all.attribute10%TYPE
48 ,attribute11			po_requisition_headers_all.attribute11%TYPE
49 ,attribute12			po_requisition_headers_all.attribute12%TYPE
50 ,attribute13			po_requisition_headers_all.attribute13%TYPE
51 ,attribute14			po_requisition_headers_all.attribute14%TYPE
52 ,attribute15			po_requisition_headers_all.attribute15%TYPE
53 ,government_context		po_requisition_headers_all.government_context%TYPE
54 ,closed_code			po_requisition_headers_all.closed_code%TYPE
55 ,org_id				org_organization_definitions.organization_id%TYPE
56 ,emergency_po_num		po_requisition_headers_all.emergency_po_num%TYPE
57 );
58 
59 TYPE Line_Rec_type IS RECORD
60 (requisition_line_id 		po_requisition_lines_all.requisition_line_id%TYPE
61 ,requisition_header_id		po_requisition_headers_all.requisition_header_id%TYPE
62 ,line_num	 		po_requisition_lines_all.line_num%TYPE
63 ,line_type_id	 		po_requisition_lines_all.line_type_id%TYPE
64 ,category_id	 		mtl_categories.category_id%TYPE
65 ,item_description	 	mtl_system_items.description%TYPE
66 ,unit_meas_lookup_code		po_requisition_lines_all.unit_meas_lookup_code%TYPE
67 ,unit_price	 		po_requisition_lines_all.unit_price%TYPE
68 ,quantity	 		po_requisition_lines_all.quantity%TYPE
69 ,deliver_to_location_id	 	po_requisition_lines_all.deliver_to_location_id%TYPE
70 ,to_person_id	 		po_requisition_lines_all.to_person_id%TYPE
71 ,last_update_date	 	po_requisition_lines_all.last_update_date%TYPE
72 ,last_updated_by	 	po_requisition_lines_all.last_updated_by%TYPE
73 ,source_type_code	 	po_requisition_lines_all.source_type_code%TYPE
74 ,last_update_login	 	po_requisition_lines_all.last_update_login%TYPE
75 ,creation_date	 		po_requisition_lines_all.creation_date%TYPE
76 ,created_by	 		po_requisition_lines_all.created_by%TYPE
77 ,item_id		 	po_requisition_lines_all.item_id%TYPE
78 ,item_revision	 		po_requisition_lines_all.item_revision%TYPE
79 ,quantity_delivered	 	po_requisition_lines_all.quantity_delivered%TYPE
80 ,suggested_buyer_id	 	po_requisition_lines_all.suggested_buyer_id%TYPE
81 ,encumbered_flag	 	po_requisition_lines_all.encumbered_flag%TYPE
82 ,rfq_required_flag	 	po_requisition_lines_all.rfq_required_flag%TYPE
83 ,need_by_date	 		po_requisition_lines_all.need_by_date%TYPE
84 ,line_location_id	 	po_requisition_lines_all.line_location_id%TYPE
85 ,modified_by_agent_flag	 	po_requisition_lines_all.modified_by_agent_flag%TYPE
86 ,parent_req_line_id	 	po_requisition_lines_all.parent_req_line_id%TYPE
87 ,justification	 		po_requisition_lines_all.justification%TYPE
88 ,note_to_agent	 		po_requisition_lines_all.note_to_agent%TYPE
89 ,note_to_receiver	 	po_requisition_lines_all.note_to_receiver%TYPE
90 ,purchasing_agent_id	 	po_requisition_lines_all.purchasing_agent_id%TYPE
91 ,document_type_code	 	po_requisition_lines_all.document_type_code%TYPE
92 ,blanket_po_header_id	 	po_requisition_lines_all.blanket_po_header_id%TYPE
93 ,blanket_po_line_num	 	po_requisition_lines_all.blanket_po_line_num%TYPE
94 ,currency_code	 		po_requisition_lines_all.currency_code%TYPE
95 ,rate_type	 		po_requisition_lines_all.rate_type%TYPE
96 ,rate_date	 		po_requisition_lines_all.rate_date%TYPE
97 ,rate	 			po_requisition_lines_all.rate%TYPE
98 ,currency_unit_price		po_requisition_lines_all.currency_unit_price%TYPE
99 ,suggested_vendor_name	 	po_requisition_lines_all.suggested_vendor_name%TYPE
100 ,suggested_vendor_location	po_requisition_lines_all.suggested_vendor_location%TYPE
101 ,suggested_vendor_contact	po_requisition_lines_all.suggested_vendor_contact%TYPE
102 ,suggested_vendor_phone	 	po_requisition_lines_all.suggested_vendor_phone%TYPE
103 ,suggested_vendor_product_code	po_requisition_lines_all.suggested_vendor_product_code%TYPE
104 ,un_number_id	 		po_requisition_lines_all.un_number_id%TYPE
105 ,hazard_class_id	 	po_requisition_lines_all.hazard_class_id%TYPE
106 ,must_use_sugg_vendor_flag	po_requisition_lines_all.must_use_sugg_vendor_flag%TYPE
107 ,reference_num	 		po_requisition_lines_all.reference_num%TYPE
108 ,on_rfq_flag	 		po_requisition_lines_all.on_rfq_flag%TYPE
109 ,urgent_flag	 		po_requisition_lines_all.urgent_flag%TYPE
110 ,cancel_flag	 		po_requisition_lines_all.cancel_flag%TYPE
111 ,source_organization_id	 	org_organization_definitions.organization_id%TYPE
112 ,source_subinventory	 	po_requisition_lines_all.source_subinventory%TYPE
113 ,destination_type_code	 	po_requisition_lines_all.destination_type_code%TYPE
114 ,destination_organization_id	org_organization_definitions.organization_id%TYPE
115 ,destination_subinventory	po_requisition_lines_all.destination_subinventory%TYPE
116 ,quantity_cancelled	 	po_requisition_lines_all.quantity_cancelled%TYPE
117 ,cancel_date	 		po_requisition_lines_all.cancel_date%TYPE
118 ,cancel_reason			po_requisition_lines_all.cancel_reason%TYPE
119 ,closed_code	 		po_requisition_lines_all.closed_code%TYPE
120 ,agent_return_note	 	po_requisition_lines_all.agent_return_note%TYPE
121 ,changed_after_research_flag	po_requisition_lines_all.changed_after_research_flag%TYPE
122 ,vendor_id	 		po_vendors.vendor_id%TYPE
123 ,vendor_site_id	 		po_requisition_lines_all.vendor_site_id%TYPE
124 ,vendor_contact_id	 	po_requisition_lines_all.vendor_contact_id%TYPE
125 ,research_agent_id	 	po_requisition_lines_all.research_agent_id%TYPE
126 ,wip_entity_id	 		po_requisition_lines_all.wip_entity_id%TYPE
127 ,wip_line_id	 		po_requisition_lines_all.wip_line_id%TYPE
128 ,wip_repetitive_schedule_id	po_requisition_lines_all.wip_repetitive_schedule_id%TYPE
129 ,wip_operation_seq_num	 	po_requisition_lines_all.wip_operation_seq_num%TYPE
130 ,wip_resource_seq_num	 	po_requisition_lines_all.wip_resource_seq_num%TYPE
131 ,attribute_category	 	po_requisition_lines_all.attribute_category%TYPE
132 ,destination_context	 	po_requisition_lines_all.destination_context%TYPE
133 ,inventory_source_context	po_requisition_lines_all.inventory_source_context%TYPE
134 ,vendor_source_context	 	po_requisition_lines_all.vendor_source_context%TYPE
135 ,attribute1	 		po_requisition_lines_all.attribute1%TYPE
136 ,attribute2	 		po_requisition_lines_all.attribute2%TYPE
137 ,attribute3	 		po_requisition_lines_all.attribute3%TYPE
138 ,attribute4	 		po_requisition_lines_all.attribute4%TYPE
139 ,attribute5	 		po_requisition_lines_all.attribute5%TYPE
140 ,attribute6	 		po_requisition_lines_all.attribute6%TYPE
141 ,attribute7	 		po_requisition_lines_all.attribute7%TYPE
142 ,attribute8	 		po_requisition_lines_all.attribute8%TYPE
143 ,attribute9	 		po_requisition_lines_all.attribute9%TYPE
144 ,attribute10	 		po_requisition_lines_all.attribute10%TYPE
145 ,attribute11	 		po_requisition_lines_all.attribute11%TYPE
146 ,attribute12	 		po_requisition_lines_all.attribute12%TYPE
147 ,attribute13	 		po_requisition_lines_all.attribute13%TYPE
148 ,attribute14	 		po_requisition_lines_all.attribute14%TYPE
149 ,attribute15	 		po_requisition_lines_all.attribute15%TYPE
150 ,bom_resource_id	 	po_requisition_lines_all.bom_resource_id%TYPE
151 ,government_context	 	po_requisition_lines_all.government_context%TYPE
152 ,closed_reason	 		po_requisition_lines_all.closed_reason%TYPE
153 ,closed_date	 		po_requisition_lines_all.closed_date%TYPE
154 ,transaction_reason_code 	po_requisition_lines_all.transaction_reason_code%TYPE
155 ,quantity_received	 	po_requisition_lines_all.quantity_received%TYPE
156 ,source_req_line_id	 	po_requisition_lines_all.source_req_line_id%TYPE
157 ,org_id	 			po_requisition_lines_all.org_id%TYPE
158 ,kanban_card_id	 		po_requisition_lines_all.kanban_card_id%TYPE
159 ,catalog_type	 		po_requisition_lines_all.catalog_type%TYPE
160 ,catalog_source	 		po_requisition_lines_all.catalog_source%TYPE
161 ,manufacturer_id		po_requisition_lines_all.manufacturer_id%TYPE
162 ,manufacturer_name	 	po_requisition_lines_all.manufacturer_name%TYPE
163 ,manufacturer_part_number	po_requisition_lines_all.manufacturer_part_number%TYPE
164 ,requester_email	 	po_requisition_lines_all.requester_email%TYPE
165 ,requester_fax	 		po_requisition_lines_all.requester_fax%TYPE
166 ,requester_phone	 	po_requisition_lines_all.requester_phone%TYPE
167 ,unspsc_code	 		po_requisition_lines_all.unspsc_code%TYPE
168 ,other_category_code	 	po_requisition_lines_all.other_category_code%TYPE
169 ,supplier_duns	 		po_requisition_lines_all.supplier_duns%TYPE
170 ,tax_status_indicator	 	po_requisition_lines_all.tax_status_indicator%TYPE
171 ,pcard_flag	 		po_requisition_lines_all.pcard_flag%TYPE
172 ,new_supplier_flag	 	po_requisition_lines_all.new_supplier_flag%TYPE
173 ,auto_receive_flag	 	po_requisition_lines_all.auto_receive_flag%TYPE
174 ,tax_user_override_flag	 	po_requisition_lines_all.tax_user_override_flag%TYPE
175 ,tax_code_id	 		po_requisition_lines_all.tax_code_id%TYPE
176 ,note_to_vendor	 		po_requisition_lines_all.note_to_vendor%TYPE
177 ,oke_contract_version_id 	po_requisition_lines_all.oke_contract_version_id%TYPE
178 ,oke_contract_header_id	 	po_requisition_lines_all.oke_contract_header_id%TYPE
179 ,item_source_id	 		po_requisition_lines_all.item_source_id%TYPE
180 ,supplier_ref_number	 	po_requisition_lines_all.supplier_ref_number%TYPE
181 ,source_doc_line_reference	number
182 ,uom_code		 	VARCHAR2(3)
183 ,order_type_lookup_code         po_requisition_lines_all.order_type_lookup_code%TYPE
184 ,purchase_basis                 po_requisition_lines_all.purchase_basis%TYPE
185 ,matching_basis                 po_requisition_lines_all.matching_basis%TYPE
186 );
187 
188  TYPE Line_Tbl_Type IS TABLE OF Line_Rec_Type
189     INDEX BY BINARY_INTEGER;
190 
191 TYPE Dist_Rec_type IS RECORD
192 (distribution_id 		po_req_distributions_all.distribution_id%TYPE
193 ,last_update_date		po_req_distributions_all.last_update_date%TYPE
194 ,last_updated_by 		po_req_distributions_all.last_updated_by%TYPE
195 ,requisition_line_id		po_req_distributions_all.requisition_line_id%TYPE
196 ,set_of_books_id		po_req_distributions_all.set_of_books_id%TYPE
197 ,code_combination_id		po_req_distributions_all.code_combination_id%TYPE
198 ,req_line_quantity		po_req_distributions_all.req_line_quantity%TYPE
199 ,last_update_login		po_req_distributions_all.last_update_login%TYPE
200 ,creation_date			po_req_distributions_all.creation_date%TYPE
201 ,created_by			po_req_distributions_all.created_by%TYPE
202 ,encumbered_flag		po_req_distributions_all.encumbered_flag%TYPE
203 ,gl_encumbered_date		po_req_distributions_all.gl_encumbered_date%TYPE
204 ,gl_encumbered_period_name	po_req_distributions_all.gl_encumbered_period_name%TYPE
205 ,gl_cancelled_date		po_req_distributions_all.gl_cancelled_date%TYPE
206 ,failed_funds_lookup_code	po_req_distributions_all.failed_funds_lookup_code%TYPE
207 ,encumbered_amount		po_req_distributions_all.encumbered_amount%TYPE
208 ,budget_account_id		po_req_distributions_all.budget_account_id%TYPE
209 ,accrual_account_id		po_req_distributions_all.accrual_account_id%TYPE
210 ,variance_account_id		po_req_distributions_all.variance_account_id%TYPE
211 ,prevent_encumbrance_flag	po_req_distributions_all.prevent_encumbrance_flag%TYPE
212 ,attribute_category		po_req_distributions_all.attribute_category%TYPE
213 ,attribute1			po_req_distributions_all.attribute1%TYPE
214 ,attribute2			po_req_distributions_all.attribute2%TYPE
215 ,attribute3			po_req_distributions_all.attribute3%TYPE
216 ,attribute4			po_req_distributions_all.attribute4%TYPE
217 ,attribute5			po_req_distributions_all.attribute5%TYPE
218 ,attribute6			po_req_distributions_all.attribute6%TYPE
219 ,attribute7			po_req_distributions_all.attribute7%TYPE
220 ,attribute8			po_req_distributions_all.attribute8%TYPE
221 ,attribute9			po_req_distributions_all.attribute9%TYPE
222 ,attribute10			po_req_distributions_all.attribute10%TYPE
223 ,attribute11			po_req_distributions_all.attribute11%TYPE
224 ,attribute12	 		po_req_distributions_all.attribute12%TYPE
225 ,attribute13	 		po_req_distributions_all.attribute13%TYPE
226 ,attribute14	 		po_req_distributions_all.attribute14%TYPE
227 ,attribute15	 		po_req_distributions_all.attribute15%TYPE
228 ,government_context		po_req_distributions_all.government_context%TYPE
229 ,project_id	 		po_req_distributions_all.project_id%TYPE
230 ,task_id	  		po_req_distributions_all.task_id%TYPE
231 ,expenditure_type		po_req_distributions_all.expenditure_type%TYPE
232 ,project_accounting_context	po_req_distributions_all.project_accounting_context%TYPE
233 ,expenditure_organization_id	po_req_distributions_all.expenditure_organization_id%TYPE
234 ,gl_closed_date	 		po_req_distributions_all.gl_closed_date%TYPE
235 ,source_req_distribution_id	po_req_distributions_all.source_req_distribution_id%TYPE
236 ,distribution_num		po_req_distributions_all.distribution_num%TYPE
237 ,project_related_flag		po_req_distributions_all.project_related_flag%TYPE
238 ,expenditure_item_date		po_req_distributions_all.expenditure_item_date%TYPE
239 ,org_id	 	 		po_req_distributions_all.org_id%TYPE
240 ,allocation_type	 	po_req_distributions_all.allocation_type%TYPE
241 ,allocation_value		po_req_distributions_all.allocation_value%TYPE
242 ,award_id	 		po_req_distributions_all.award_id%TYPE
243 ,end_item_unit_number		po_req_distributions_all.end_item_unit_number%TYPE
244 ,recoverable_tax	 	po_req_distributions_all.recoverable_tax%TYPE
245 ,nonrecoverable_tax		po_req_distributions_all.nonrecoverable_tax%TYPE
246 ,recovery_rate	 		po_req_distributions_all.recovery_rate%TYPE
247 ,tax_recovery_override_flag	po_req_distributions_all.tax_recovery_override_flag%TYPE
248 ,oke_contract_line_id		po_req_distributions_all.oke_contract_line_id%TYPE
249 ,oke_contract_deliverable_id	po_req_distributions_all.oke_contract_deliverable_id%TYPE
250 );
251 
252 
253   PROCEDURE process_requisition(
254           p_api_version             IN NUMBER       := 1.0
255          ,p_Init_Msg_List           IN VARCHAR2     := FND_API.G_TRUE
256          ,p_commit                  IN VARCHAR2     := FND_API.G_FALSE
257          ,px_header_rec             IN OUT NOCOPY po_create_requisition_sv.Header_rec_type
258          ,px_line_table             IN OUT NOCOPY po_create_requisition_sv.Line_Tbl_type
259          ,x_return_status           OUT NOCOPY VARCHAR2
260          ,x_msg_count               OUT NOCOPY NUMBER
261          ,x_msg_data                OUT NOCOPY VARCHAR2
262         );
263 
264  END; -- Package spec