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.6 2006/01/18 10:42:55 pthapliy noship $ */
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 350: SELECT PO_APPROVED_SUPPLIER_LIST_S.NEXTVAL

346: --
347: --
348: IF x_record_unique THEN
349:
350: SELECT PO_APPROVED_SUPPLIER_LIST_S.NEXTVAL
351: INTO x_asl_id
352: FROM SYS.DUAL;
353:
354: IF (g_po_pdoi_write_to_file = 'Y') THEN

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

351: INTO x_asl_id
352: FROM SYS.DUAL;
353:
354: IF (g_po_pdoi_write_to_file = 'Y') THEN
355: PO_DEBUG.put_line('Creating Record in Po approved Supplier List');
356: END IF;
357: --
358: INSERT INTO PO_APPROVED_SUPPLIER_LIST (
359: asl_id ,

Line 358: INSERT INTO PO_APPROVED_SUPPLIER_LIST (

354: IF (g_po_pdoi_write_to_file = 'Y') THEN
355: PO_DEBUG.put_line('Creating Record in Po approved Supplier List');
356: END IF;
357: --
358: INSERT INTO PO_APPROVED_SUPPLIER_LIST (
359: asl_id ,
360: using_organization_id ,
361: owning_organization_id ,
362: vendor_business_type ,

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

492: PO_ASL_SV.raise_asl_eres_event
493: ( x_return_status => l_return_status,
494: p_asl_id => x_asl_id,
495: p_action => PO_ASL_SV.G_EVENT_INSERT,
496: p_calling_from => 'PO_APPROVED_SUPPLIER_LIST_SV.create_po_asl_entries',
497: p_ackn_note => NULL,
498: p_autonomous_commit => FND_API.G_FALSE
499: );
500:

Line 527: FROM po_approved_supplier_list pasl

523:
524:
525: SELECT asl_id
526: INTO x_asl_id
527: FROM po_approved_supplier_list pasl
528: WHERE pasl.vendor_id = x_vendor_id
529: AND ( pasl.vendor_site_id = x_vendor_site_id
530: OR ( pasl.vendor_site_id is NULL
531: AND x_vendor_site_id is NULL))

Line 652: END PO_APPROVED_SUPPLIER_LIST_SV;

648: po_message_s.sql_error('create_po_asl_entries', x_progress, sqlcode);
649: raise;
650: END create_po_asl_entries;
651:
652: END PO_APPROVED_SUPPLIER_LIST_SV;