1 PACKAGE PO_APPROVED_SUPPLIER_LIST_SV AS
2 /* $Header: POXVASLS.pls 120.0 2005/06/02 15:09:29 appldev noship $ */
3
4 G_EXC_ERES_ERROR EXCEPTION; -- <ASL ERECORD FPJ>
5
6 /*==================================================================
7 PROCEDURE NAME: create_asl_entry()
8
9 DESCRIPTION: This API inserts row into po_approved_supplier_list,
10 po_asl_attributes,po_asl_documents
11
12 PARAMETERS: X_interface_header_id, X_interface_line_id - Values from the
13 po_headers_interface and po_lines_interface tables.
14 X_item_id, X_vendor_id, X_po_header_id,
15 X_po_line_id,X_document_type
16 Values of the document that needs to be created from
17 the PDOI interface tables.
18 X_category_id - Creatgory_id for the Category
19 X_header_processable_flag - Value is N if there was any
20 error encountered. Set in the procedure
21 PO_INTERFACE_ERRORS_SV1.handle_interface_errors
22 X_po_interface_error_code - This is the code used to populate interface_type
23 field in po_interface_errors table.
24
25
26 =======================================================================*/
27
28 PROCEDURE create_po_asl_entries
29 ( x_interface_header_id IN NUMBER,
30 X_interface_line_id IN NUMBER,
31 X_item_id IN NUMBER,
32 X_category_id IN NUMBER,
33 X_po_header_id IN NUMBER,
34 X_po_line_id IN NUMBER,
35 X_document_type IN VARCHAR2,
36 x_vendor_site_id IN NUMBER, -- GA FPI
37 X_rel_gen_method IN VARCHAR2,
38 X_asl_org_id IN NUMBER,
39 X_header_processable_flag OUT NOCOPY VARCHAR2,
40 X_po_interface_error_code IN VARCHAR2,
41 ----<LOCAL SR/ASL PROJECT 11i11 START>
42 p_sourcing_level IN VARCHAR2 DEFAULT NULL
43 ----<LOCAL SR/ASL PROJECT 11i11 END>
44 );
45 --
46 end PO_APPROVED_SUPPLIER_LIST_SV;