eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_ASL_API_PVT dependencies on PO_ASL_DOCUMENTS

Line 418: INSERT INTO po_asl_documents

414: po_asl_api_pvt.log('number of DEFAULT rows inserted into po_asl_attributes:'
415: || SQL%ROWCOUNT);
416: l_progress := 18;
417:
418: INSERT INTO po_asl_documents
419: ( asl_id ,
420: using_organization_id ,
421: sequence_num ,
422: document_type_code ,

Line 485: FROM po_asl_documents_gt

481: program_application_id ,
482: program_id ,
483: program_update_date ,
484: org_id
485: FROM po_asl_documents_gt
486: WHERE user_key IN
487: (SELECT user_key
488: FROM po_approved_supplier_list_gt
489: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)

Line 492: po_asl_api_pvt.log('number of rows inserted into po_asl_documents:'

488: FROM po_approved_supplier_list_gt
489: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
490: AND process_action = PO_ASL_API_PUB.g_ACTION_ADD
491: );
492: po_asl_api_pvt.log('number of rows inserted into po_asl_documents:'
493: || SQL%ROWCOUNT);
494: l_progress := 20;
495:
496: INSERT INTO chv_authorizations

Line 930: UPDATE po_asl_documents PAD

926: po_asl_api_pvt.log('number of rows updated in po_asl_attributes:'
927: || SQL%ROWCOUNT);
928: l_progress := 45;
929:
930: UPDATE po_asl_documents PAD
931: SET
932: (PAD.document_line_id ,
933: PAD.last_update_date ,
934: PAD.last_updated_by ,

Line 980: FROM po_asl_documents_gt PADGT,

976: PADGT.request_id ,
977: PADGT.program_application_id ,
978: PADGT.program_id ,
979: PADGT.program_update_date
980: FROM po_asl_documents_gt PADGT,
981: po_approved_supplier_list_gt ASLGT
982: WHERE PADGT.user_key = ASLGT.user_key
983: AND PADGT.asl_id = PAD.asl_id
984: AND PADGT.using_organization_id = PAD.using_organization_id

Line 991: FROM po_asl_documents_gt PADGT,

987: AND PADGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
988: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
989: WHERE (PAD.asl_id, PAD.using_organization_id, PAD.document_header_id) IN
990: (SELECT PADGT.asl_id, PADGT.using_organization_id, PADGT.document_header_id
991: FROM po_asl_documents_gt PADGT,
992: po_approved_supplier_list_gt ASLGT
993: WHERE PADGT.user_key = ASLGT.user_key
994: AND PADGT.asl_id = PAD.asl_id
995: AND PADGT.using_organization_id = PAD.using_organization_id

Line 1001: po_asl_api_pvt.log('number of rows updated in po_asl_documents:'

997: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
998: AND PADGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
999: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1000:
1001: po_asl_api_pvt.log('number of rows updated in po_asl_documents:'
1002: || SQL%ROWCOUNT);
1003: l_progress := 50;
1004:
1005: UPDATE chv_authorizations CHV

Line 1264: DELETE FROM po_asl_documents PAD

1260: po_asl_api_pvt.log('number of rows deleted from po_asl_attributes:'
1261: || SQL%ROWCOUNT);
1262: l_progress := 70;
1263:
1264: DELETE FROM po_asl_documents PAD
1265: WHERE (asl_id,using_organization_id,document_header_id) IN
1266: (SELECT PADGT.asl_id ,
1267: PADGT.using_organization_id ,
1268: PADGT.document_header_id

Line 1269: FROM po_asl_documents_gt PADGT,

1265: WHERE (asl_id,using_organization_id,document_header_id) IN
1266: (SELECT PADGT.asl_id ,
1267: PADGT.using_organization_id ,
1268: PADGT.document_header_id
1269: FROM po_asl_documents_gt PADGT,
1270: po_approved_supplier_list_gt ASLGT
1271: WHERE ASLGT.user_key = PADGT.user_key
1272: AND PADGT.process_action = PO_ASL_API_PUB.g_ACTION_DELETE
1273: AND PADGT.asl_id = PAD.asl_id

Line 1278: po_asl_api_pvt.log('1.number of rows deleted from po_asl_documents:'

1274: AND PADGT.using_organization_id = PAD.using_organization_id
1275: AND PADGT.document_header_id = PAD.document_header_id
1276: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1277:
1278: po_asl_api_pvt.log('1.number of rows deleted from po_asl_documents:'
1279: || SQL%ROWCOUNT);
1280: l_progress := 73;
1281: --Delete documents, if asl_attributes doesn't exist
1282: DELETE FROM po_asl_documents PAD

Line 1282: DELETE FROM po_asl_documents PAD

1278: po_asl_api_pvt.log('1.number of rows deleted from po_asl_documents:'
1279: || SQL%ROWCOUNT);
1280: l_progress := 73;
1281: --Delete documents, if asl_attributes doesn't exist
1282: DELETE FROM po_asl_documents PAD
1283: WHERE NOT EXISTS
1284: (SELECT 1
1285: FROM po_asl_attributes PAA
1286: WHERE PAA.asl_id = PAD.asl_id

Line 1295: po_asl_api_pvt.log('2.number of rows deleted from po_asl_documents:'

1291: FROM po_approved_supplier_list_gt ASLGT
1292: WHERE ASLGT.asl_id = PAD.asl_id
1293: AND ASLGT.using_organization_id = PAD.using_organization_id);
1294:
1295: po_asl_api_pvt.log('2.number of rows deleted from po_asl_documents:'
1296: || SQL%ROWCOUNT);
1297:
1298: l_progress := 75;
1299:

Line 1793: -- For logging po_asl_documents_rec records

1789:
1790: --Name: log
1791:
1792: --Function:
1793: -- For logging po_asl_documents_rec records
1794:
1795: --Parameters:
1796:
1797: --IN:

Line 1798: --p_doc_rec po_asl_documents_rec

1794:
1795: --Parameters:
1796:
1797: --IN:
1798: --p_doc_rec po_asl_documents_rec
1799:
1800: --End of Comments
1801: --------------------------------------------------------------------------------
1802:

Line 1804: p_doc_rec IN po_asl_documents_rec

1800: --End of Comments
1801: --------------------------------------------------------------------------------
1802:
1803: PROCEDURE log(
1804: p_doc_rec IN po_asl_documents_rec
1805: )
1806: AS
1807:
1808: BEGIN