APPS.PO_ASL_UPGRADE_SV2 dependencies on PO_ASL_DOCUMENTS

Line 610: FROM po_asl_documents

606:
607: x_progress := '020';
608: SELECT count(*)
609: INTO x_dummy_count
610: FROM po_asl_documents
611: WHERE asl_id = x_asl_id
612: AND using_organization_id = -1
613: AND document_header_id = x_document_header_id
614: AND document_type_code = x_document_type_code;

Line 628: FROM po_asl_documents

624:
625: x_progress := '030';
626: SELECT nvl(max(sequence_num)+1, 1)
627: INTO x_sequence_num
628: FROM po_asl_documents
629: WHERE asl_id = x_asl_id
630: AND using_organization_id = -1;
631:
632:

Line 638: INSERT INTO PO_ASL_DOCUMENTS(

634: fnd_file.put_line(fnd_file.log, 'Upgrading source document.');
635: fnd_file.put_line(fnd_file.log, 'DOCUMENT_TYPE_CODE = '||x_document_type_code);
636: fnd_file.put_line(fnd_file.log, 'DOCUMENT_ID = '||x_document_header_id);
637:
638: INSERT INTO PO_ASL_DOCUMENTS(
639: asl_id,
640: using_organization_id,
641: sequence_num,
642: document_type_code,