APPS.PO_APPROVED_SUPPLIER_LIST_SV dependencies on PO_ASL_DOCUMENTS

Line 17: po_asl_attributes,po_asl_documents

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
21: and po_lines_interface_s.

Line 447: -- create global ASL in po_asl_documents

443: IF (g_po_pdoi_write_to_file = 'Y') THEN
444: PO_DEBUG.put_line('Creating Record in Po Asl Attribbutes ');
445: END IF;
446:
447: -- create global ASL in po_asl_documents
448:
449:
450: INSERT INTO po_asl_attributes(
451: asl_id,

Line 583: FROM po_asl_documents

579: -- this ASL entry.
580: x_progress := '020';
581: SELECT count(*)
582: INTO x_dummy_count
583: FROM po_asl_documents
584: WHERE asl_id = x_asl_id
585: AND using_organization_id = l_using_organization_id --
586: AND document_header_id = x_po_header_id
587: AND document_type_code = x_type_lookup_code;

Line 598: FROM po_asl_documents

594: ELSE
595: --
596: SELECT nvl(max(sequence_num)+1, 1)
597: INTO x_sequence_num
598: FROM po_asl_documents
599: WHERE asl_id = x_asl_id
600: AND using_organization_id = l_using_organization_id; --
601: --
602: IF (g_po_pdoi_write_to_file = 'Y') THEN

Line 606: -- Insert doc into po_asl_documents

602: IF (g_po_pdoi_write_to_file = 'Y') THEN
603: PO_DEBUG.put_line('Creating record in Po Asl Docs');
604: END IF;
605: --
606: -- Insert doc into po_asl_documents
607: --
608:
609: INSERT INTO PO_ASL_DOCUMENTS(
610: asl_id,

Line 609: INSERT INTO PO_ASL_DOCUMENTS(

605: --
606: -- Insert doc into po_asl_documents
607: --
608:
609: INSERT INTO PO_ASL_DOCUMENTS(
610: asl_id,
611: using_organization_id,
612: sequence_num,
613: document_type_code,