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 CHV_AUTHORIZATIONS

Line 496: INSERT INTO chv_authorizations

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
497: ( reference_id ,
498: reference_type ,
499: authorization_code ,
500: authorization_sequence ,

Line 561: FROM chv_authorizations_gt

557: program_application_id ,
558: program_id ,
559: program_update_date ,
560: using_organization_id
561: FROM chv_authorizations_gt
562: WHERE user_key IN
563: (SELECT user_key
564: FROM po_approved_supplier_list_gt
565: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)

Line 568: po_asl_api_pvt.log('number of rows inserted into chv_authorizations:'

564: FROM po_approved_supplier_list_gt
565: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
566: AND process_action = PO_ASL_API_PUB.g_ACTION_ADD
567: );
568: po_asl_api_pvt.log('number of rows inserted into chv_authorizations:'
569: || SQL%ROWCOUNT);
570: l_progress := 25;
571:
572: INSERT INTO po_supplier_item_capacity

Line 1005: UPDATE chv_authorizations CHV

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
1006: SET
1007: (CHV.last_update_date ,
1008: CHV.last_updated_by ,
1009: CHV.timefence_days ,

Line 1055: FROM chv_authorizations_gt CHVGT,

1051: CHVGT.request_id ,
1052: CHVGT.program_application_id ,
1053: CHVGT.program_id ,
1054: CHVGT.program_update_date
1055: FROM chv_authorizations_gt CHVGT,
1056: po_approved_supplier_list_gt ASLGT
1057: WHERE CHVGT.user_key = ASLGT.user_key
1058: AND CHVGT.reference_id = CHV.reference_id
1059: AND CHVGT.using_organization_id = CHV.using_organization_id

Line 1071: FROM chv_authorizations_gt CHVGT,

1067: (SELECT CHVGT.reference_id ,
1068: CHVGT.using_organization_id ,
1069: CHVGT.authorization_code ,
1070: CHVGT.authorization_sequence_dsp
1071: FROM chv_authorizations_gt CHVGT,
1072: po_approved_supplier_list_gt ASLGT
1073: WHERE CHVGT.user_key = ASLGT.user_key
1074: AND CHVGT.reference_id = CHV.reference_id
1075: AND CHVGT.using_organization_id = CHV.using_organization_id

Line 1082: po_asl_api_pvt.log('number of rows updated in chv_authorizations:'

1078: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1079: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1080: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1081:
1082: po_asl_api_pvt.log('number of rows updated in chv_authorizations:'
1083: || SQL%ROWCOUNT);
1084: l_progress := 55;
1085:
1086: UPDATE po_supplier_item_capacity PSIC

Line 1300: DELETE FROM chv_authorizations CHV

1296: || SQL%ROWCOUNT);
1297:
1298: l_progress := 75;
1299:
1300: DELETE FROM chv_authorizations CHV
1301: WHERE (reference_id, using_organization_id, authorization_code) IN
1302: (SELECT CHVGT.reference_id ,
1303: CHVGT.using_organization_id ,
1304: CHVGT.authorization_code

Line 1305: FROM chv_authorizations_gt CHVGT,

1301: WHERE (reference_id, using_organization_id, authorization_code) IN
1302: (SELECT CHVGT.reference_id ,
1303: CHVGT.using_organization_id ,
1304: CHVGT.authorization_code
1305: FROM chv_authorizations_gt CHVGT,
1306: po_approved_supplier_list_gt ASLGT
1307: WHERE ASLGT.user_key = CHVGT.user_key
1308: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_DELETE
1309: AND CHVGT.reference_id = CHV.reference_id

Line 1314: po_asl_api_pvt.log('1.number of rows deleted from chv_authorizations:'

1310: AND CHVGT.using_organization_id = CHV.using_organization_id
1311: AND CHVGT.authorization_code = CHV.authorization_code
1312: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1313:
1314: po_asl_api_pvt.log('1.number of rows deleted from chv_authorizations:'
1315: || SQL%ROWCOUNT);
1316: l_progress := 77;
1317:
1318: --Delete authorizations, if asl_attributes modified with

Line 1320: DELETE FROM chv_authorizations CHV

1316: l_progress := 77;
1317:
1318: --Delete authorizations, if asl_attributes modified with
1319: --authorizations_flag unchekced or plan schedule flag unchecked
1320: DELETE FROM chv_authorizations CHV
1321: WHERE (reference_id, using_organization_id) IN
1322: (SELECT PAA.asl_id,
1323: PAA.using_organization_id
1324: FROM po_asl_attributes PAA

Line 1336: po_asl_api_pvt.log('2.number of rows deleted from chv_authorizations:'

1332: FROM po_approved_supplier_list_gt ASLGT
1333: WHERE aslgt.asl_id = CHV.reference_id
1334: AND ASLGT.using_organization_id = CHV.using_organization_id);
1335:
1336: po_asl_api_pvt.log('2.number of rows deleted from chv_authorizations:'
1337: || SQL%ROWCOUNT);
1338: l_progress := 79;
1339:
1340: --Delete authorizations, if asl_attributes doesn't exist

Line 1341: DELETE FROM chv_authorizations CHV

1337: || SQL%ROWCOUNT);
1338: l_progress := 79;
1339:
1340: --Delete authorizations, if asl_attributes doesn't exist
1341: DELETE FROM chv_authorizations CHV
1342: WHERE NOT EXISTS
1343: (SELECT 1
1344: FROM po_asl_attributes PAA
1345: WHERE PAA.asl_id = CHV.reference_id

Line 1354: po_asl_api_pvt.log('3.number of rows deleted from chv_authorizations:'

1350: FROM po_approved_supplier_list_gt ASLGT
1351: WHERE ASLGT.asl_id = CHV.reference_id
1352: AND ASLGT.using_organization_id = CHV.using_organization_id);
1353:
1354: po_asl_api_pvt.log('3.number of rows deleted from chv_authorizations:'
1355: || SQL%ROWCOUNT);
1356: l_progress := 80;
1357:
1358: DELETE FROM po_supplier_item_capacity PSIC

Line 1855: -- For logging chv_authorizations_rec records

1851:
1852: --Name: log
1853:
1854: --Function:
1855: -- For logging chv_authorizations_rec records
1856:
1857: --Parameters:
1858:
1859: --IN:

Line 1860: --p_chv_rec chv_authorizations_rec

1856:
1857: --Parameters:
1858:
1859: --IN:
1860: --p_chv_rec chv_authorizations_rec
1861:
1862: --End of Comments
1863: --------------------------------------------------------------------------------
1864:

Line 1866: p_chv_rec IN chv_authorizations_rec

1862: --End of Comments
1863: --------------------------------------------------------------------------------
1864:
1865: PROCEDURE log(
1866: p_chv_rec IN chv_authorizations_rec
1867: )
1868: AS
1869:
1870: BEGIN