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_SUPPLIER_ITEM_CAPACITY

Line 572: INSERT INTO po_supplier_item_capacity

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
573: ( capacity_id ,
574: asl_id ,
575: using_organization_id ,
576: from_date ,

Line 637: FROM po_supplier_item_capacity_gt PSIC

633: request_id ,
634: program_application_id ,
635: program_id ,
636: program_update_date
637: FROM po_supplier_item_capacity_gt PSIC
638: WHERE user_key IN
639: (SELECT user_key
640: FROM po_approved_supplier_list_gt
641: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)

Line 644: po_asl_api_pvt.log('number of rows inserted into po_supplier_item_capacity:'

640: FROM po_approved_supplier_list_gt
641: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
642: AND process_action = PO_ASL_API_PUB.g_ACTION_ADD
643: );
644: po_asl_api_pvt.log('number of rows inserted into po_supplier_item_capacity:'
645: || SQL%ROWCOUNT);
646: l_progress := 30;
647:
648: INSERT INTO po_supplier_item_tolerance

Line 1086: UPDATE po_supplier_item_capacity PSIC

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
1087: SET
1088: (PSIC.capacity_per_day ,
1089: PSIC.last_update_date ,
1090: PSIC.last_updated_by ,

Line 1136: FROM po_supplier_item_capacity_gt GT,

1132: GT.request_id ,
1133: GT.program_application_id ,
1134: GT.program_id ,
1135: GT.program_update_date
1136: FROM po_supplier_item_capacity_gt GT,
1137: po_approved_supplier_list_gt ASLGT
1138: WHERE GT.user_key = ASLGT.user_key
1139: AND GT.asl_id = PSIC.asl_id
1140: AND GT.using_organization_id = PSIC.using_organization_id

Line 1152: FROM po_supplier_item_capacity_gt GT,

1148: (SELECT GT.asl_id ,
1149: GT.using_organization_id ,
1150: GT.from_date_dsp ,
1151: GT.to_date_dsp
1152: FROM po_supplier_item_capacity_gt GT,
1153: po_approved_supplier_list_gt ASLGT
1154: WHERE GT.user_key = ASLGT.user_key
1155: AND GT.asl_id = PSIC.asl_id
1156: AND GT.using_organization_id = PSIC.using_organization_id

Line 1163: po_asl_api_pvt.log('number of rows updated in po_supplier_item_capacity:'

1159: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1160: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1161: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1162:
1163: po_asl_api_pvt.log('number of rows updated in po_supplier_item_capacity:'
1164: || SQL%ROWCOUNT);
1165: l_progress := 60;
1166:
1167: UPDATE po_supplier_item_tolerance PSIT

Line 1358: DELETE FROM po_supplier_item_capacity PSIC

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
1359: WHERE (asl_id, using_organization_id, from_date, To_Date) IN
1360: (SELECT GT.asl_id ,
1361: GT.using_organization_id ,
1362: GT.from_date_dsp ,

Line 1364: FROM po_supplier_item_capacity_gt GT,

1360: (SELECT GT.asl_id ,
1361: GT.using_organization_id ,
1362: GT.from_date_dsp ,
1363: GT.to_date_dsp
1364: FROM po_supplier_item_capacity_gt GT,
1365: po_approved_supplier_list_gt ASLGT
1366: WHERE ASLGT.user_key = GT.user_key
1367: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_DELETE
1368: AND GT.asl_id = PSIC.asl_id

Line 1375: po_asl_api_pvt.log('1.number of rows deleted from po_supplier_item_capacity:'

1371: AND GT.capacity_per_day_dsp = PSIC.capacity_per_day
1372: AND GT.using_organization_id = PSIC.using_organization_id
1373: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1374:
1375: po_asl_api_pvt.log('1.number of rows deleted from po_supplier_item_capacity:'
1376: || SQL%ROWCOUNT);
1377: l_progress := 85;
1378:
1379: --Delete capacity, if asl_attributes modified with enable_vmi_flag unchekced

Line 1380: DELETE FROM po_supplier_item_capacity PSIC

1376: || SQL%ROWCOUNT);
1377: l_progress := 85;
1378:
1379: --Delete capacity, if asl_attributes modified with enable_vmi_flag unchekced
1380: DELETE FROM po_supplier_item_capacity PSIC
1381: WHERE (asl_id, using_organization_id) IN
1382: (SELECT PAA.asl_id,
1383: PAA.using_organization_id
1384: FROM po_asl_attributes PAA

Line 1397: po_asl_api_pvt.log('2.number of rows deleted from po_supplier_item_capacity:'

1393: WHERE ASLGT.asl_id = PSIC.asl_id
1394: AND ASLGT.using_organization_id = PSIC.using_organization_id);
1395:
1396: l_progress := 88;
1397: po_asl_api_pvt.log('2.number of rows deleted from po_supplier_item_capacity:'
1398: || SQL%ROWCOUNT);
1399:
1400: --Delete capacities, if asl_attributes doesn't exist
1401: DELETE FROM po_supplier_item_capacity PSIC

Line 1401: DELETE FROM po_supplier_item_capacity PSIC

1397: po_asl_api_pvt.log('2.number of rows deleted from po_supplier_item_capacity:'
1398: || SQL%ROWCOUNT);
1399:
1400: --Delete capacities, if asl_attributes doesn't exist
1401: DELETE FROM po_supplier_item_capacity PSIC
1402: WHERE NOT EXISTS
1403: (SELECT 1
1404: FROM po_asl_attributes PAA
1405: WHERE PAA.asl_id = PSIC.asl_id

Line 1414: po_asl_api_pvt.log('3.number of rows deleted from po_supplier_item_capacity:'

1410: FROM po_approved_supplier_list_gt ASLGT
1411: WHERE ASLGT.asl_id = PSIC.asl_id
1412: AND ASLGT.using_organization_id = PSIC.using_organization_id);
1413:
1414: po_asl_api_pvt.log('3.number of rows deleted from po_supplier_item_capacity:'
1415: || SQL%ROWCOUNT);
1416: l_progress := 90;
1417:
1418: DELETE FROM po_supplier_item_tolerance PSIT

Line 1912: -- For logging po_supplier_item_capacity_rec records

1908:
1909: --Name: log
1910:
1911: --Function:
1912: -- For logging po_supplier_item_capacity_rec records
1913:
1914: --Parameters:
1915:
1916: --IN:

Line 1917: --p_cap_rec po_supplier_item_capacity_rec

1913:
1914: --Parameters:
1915:
1916: --IN:
1917: --p_cap_rec po_supplier_item_capacity_rec
1918:
1919: --End of Comments
1920: --------------------------------------------------------------------------------
1921:

Line 1923: p_cap_rec IN po_supplier_item_capacity_rec

1919: --End of Comments
1920: --------------------------------------------------------------------------------
1921:
1922: PROCEDURE log(
1923: p_cap_rec IN po_supplier_item_capacity_rec
1924: )
1925: AS
1926:
1927: BEGIN