APPS.PO_APPROVED_SUPPLIER_LIST_SV dependencies on PO_APPROVED_SUPPLIER_LIST

Line 1: PACKAGE BODY PO_APPROVED_SUPPLIER_LIST_SV AS

1: PACKAGE BODY PO_APPROVED_SUPPLIER_LIST_SV AS
2: /* $Header: POXVASLB.pls 120.8.12020000.2 2013/02/10 17:35:12 vegajula ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_pdoi_write_to_file VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_PDOI_WRITE_TO_FILE'),'N');

Line 8: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_APPROVED_SUPPLIER_LIST_SV';

4: -- Read the profile option that enables/disables the debug log
5: g_po_pdoi_write_to_file VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_PDOI_WRITE_TO_FILE'),'N');
6:
7: --
8: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_APPROVED_SUPPLIER_LIST_SV';
9: c_log_head CONSTANT VARCHAR2(50) := 'po.plsql.'|| g_pkg_name || '.';
10: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
11: --
12:

Line 16: DESCRIPTION: This API inserts row into po_approved_supplier_list,

12:
13: /*==================================================================
14: PROCEDURE NAME: create_po_asl_entries()
15:
16: DESCRIPTION: This API inserts row into po_approved_supplier_list,
17: po_asl_attributes,po_asl_documents
18:
19: PARAMETERS: X_interface_header_id, X_interface_line_id -
20: Sequence number generated from po_headers_interface_s

Line 361: SELECT PO_APPROVED_SUPPLIER_LIST_S.NEXTVAL

357: --
358: --
359: IF x_record_unique THEN
360:
361: SELECT PO_APPROVED_SUPPLIER_LIST_S.NEXTVAL
362: INTO x_asl_id
363: FROM SYS.DUAL;
364:
365: IF (g_po_pdoi_write_to_file = 'Y') THEN

Line 366: PO_DEBUG.put_line('Creating Record in Po approved Supplier List');

362: INTO x_asl_id
363: FROM SYS.DUAL;
364:
365: IF (g_po_pdoi_write_to_file = 'Y') THEN
366: PO_DEBUG.put_line('Creating Record in Po approved Supplier List');
367: END IF;
368: --
369: INSERT INTO PO_APPROVED_SUPPLIER_LIST (
370: asl_id ,

Line 369: INSERT INTO PO_APPROVED_SUPPLIER_LIST (

365: IF (g_po_pdoi_write_to_file = 'Y') THEN
366: PO_DEBUG.put_line('Creating Record in Po approved Supplier List');
367: END IF;
368: --
369: INSERT INTO PO_APPROVED_SUPPLIER_LIST (
370: asl_id ,
371: using_organization_id ,
372: owning_organization_id ,
373: vendor_business_type ,

Line 507: p_calling_from => 'PO_APPROVED_SUPPLIER_LIST_SV.create_po_asl_entries',

503: PO_ASL_SV.raise_asl_eres_event
504: ( x_return_status => l_return_status,
505: p_asl_id => x_asl_id,
506: p_action => PO_ASL_SV.G_EVENT_INSERT,
507: p_calling_from => 'PO_APPROVED_SUPPLIER_LIST_SV.create_po_asl_entries',
508: p_ackn_note => NULL,
509: p_autonomous_commit => FND_API.G_FALSE
510: );
511:

Line 538: FROM po_approved_supplier_list pasl

534:
535:
536: SELECT asl_id
537: INTO x_asl_id
538: FROM po_approved_supplier_list pasl
539: WHERE pasl.vendor_id = x_vendor_id
540: AND ( pasl.vendor_site_id = x_vendor_site_id
541: OR ( pasl.vendor_site_id is NULL
542: AND x_vendor_site_id is NULL))

Line 701: END PO_APPROVED_SUPPLIER_LIST_SV;

697: po_message_s.sql_error('create_po_asl_entries', x_progress, sqlcode);
698: raise;
699: END create_po_asl_entries;
700:
701: END PO_APPROVED_SUPPLIER_LIST_SV;