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 458: -- create global ASL in po_asl_documents

454: IF (g_po_pdoi_write_to_file = 'Y') THEN
455: PO_DEBUG.put_line('Creating Record in Po Asl Attribbutes ');
456: END IF;
457:
458: -- create global ASL in po_asl_documents
459:
460:
461: INSERT INTO po_asl_attributes(
462: asl_id,

Line 594: FROM po_asl_documents

590: -- this ASL entry.
591: x_progress := '020';
592: SELECT count(*)
593: INTO x_dummy_count
594: FROM po_asl_documents
595: WHERE asl_id = x_asl_id
596: AND using_organization_id = l_using_organization_id --
597: AND document_header_id = x_po_header_id
598: AND document_type_code = x_type_lookup_code;

Line 605: FROM po_asl_documents

601:
602: ---Bug10022351 START
603: SELECT document_line_id
604: INTO x_line_id
605: FROM po_asl_documents
606: WHERE asl_id = x_asl_id
607: AND using_organization_id = l_using_organization_id --
608: AND document_header_id = x_po_header_id
609: AND document_type_code = x_type_lookup_code;

Line 626: UPDATE PO_ASL_DOCUMENTS

622: null;
623:
624: ELSE
625:
626: UPDATE PO_ASL_DOCUMENTS
627: SET document_line_id = x_po_line_id,
628: last_update_date = x_last_update_date,
629: last_updated_by = x_last_updated_by,
630: last_update_login = last_update_login

Line 647: FROM po_asl_documents

643: ELSE
644: --
645: SELECT nvl(max(sequence_num)+1, 1)
646: INTO x_sequence_num
647: FROM po_asl_documents
648: WHERE asl_id = x_asl_id
649: AND using_organization_id = l_using_organization_id; --
650: --
651: IF (g_po_pdoi_write_to_file = 'Y') THEN

Line 655: -- Insert doc into po_asl_documents

651: IF (g_po_pdoi_write_to_file = 'Y') THEN
652: PO_DEBUG.put_line('Creating record in Po Asl Docs');
653: END IF;
654: --
655: -- Insert doc into po_asl_documents
656: --
657:
658: INSERT INTO PO_ASL_DOCUMENTS(
659: asl_id,

Line 658: INSERT INTO PO_ASL_DOCUMENTS(

654: --
655: -- Insert doc into po_asl_documents
656: --
657:
658: INSERT INTO PO_ASL_DOCUMENTS(
659: asl_id,
660: using_organization_id,
661: sequence_num,
662: document_type_code,