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_ATTRIBUTES

Line 132: INSERT INTO po_asl_attributes

128: po_asl_api_pvt.log('number of rows inserted into po_approved_supplier_list:'
129: || SQL%ROWCOUNT);
130: l_progress := 10;
131:
132: INSERT INTO po_asl_attributes
133: ( asl_id ,
134: using_organization_id ,
135: last_update_date ,
136: last_updated_by ,

Line 263: FROM po_asl_attributes_gt

259: vmi_min_days_dsp ,
260: vmi_max_days_dsp ,
261: fixed_order_quantity_dsp ,
262: forecast_horizon_dsp
263: FROM po_asl_attributes_gt
264: WHERE user_key IN
265: (SELECT user_key
266: FROM po_approved_supplier_list_gt
267: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED) AND

Line 270: po_asl_api_pvt.log('number of rows inserted into po_asl_attributes:'

266: FROM po_approved_supplier_list_gt
267: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED) AND
268: process_action = PO_ASL_API_PUB.g_ACTION_ADD
269: );
270: po_asl_api_pvt.log('number of rows inserted into po_asl_attributes:'
271: || SQL%ROWCOUNT);
272: l_progress := 15;
273:
274: INSERT INTO po_asl_attributes

Line 274: INSERT INTO po_asl_attributes

270: po_asl_api_pvt.log('number of rows inserted into po_asl_attributes:'
271: || SQL%ROWCOUNT);
272: l_progress := 15;
273:
274: INSERT INTO po_asl_attributes
275: ( asl_id ,
276: using_organization_id ,
277: last_update_date ,
278: last_updated_by ,

Line 411: FROM po_asl_attributes_gt PAA

407: PASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE AND
408: (Upper(PASL.vendor_business_type) = 'MANUFACTURER' OR
409: NOT EXISTS
410: (SELECT PAA.user_key
411: FROM po_asl_attributes_gt PAA
412: WHERE PAA.user_key = PASL.user_key))
413: );
414: po_asl_api_pvt.log('number of DEFAULT rows inserted into po_asl_attributes:'
415: || SQL%ROWCOUNT);

Line 414: po_asl_api_pvt.log('number of DEFAULT rows inserted into po_asl_attributes:'

410: (SELECT PAA.user_key
411: FROM po_asl_attributes_gt PAA
412: WHERE PAA.user_key = PASL.user_key))
413: );
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

Line 797: UPDATE po_asl_attributes PAA

793: po_asl_api_pvt.log('number of rows updated in po_approved_supplier_list:'
794: || SQL%ROWCOUNT);
795: l_progress := 40;
796:
797: UPDATE po_asl_attributes PAA
798: SET
799: (PAA.last_update_date ,
800: PAA.last_updated_by ,
801: PAA.purchasing_unit_of_measure ,

Line 907: FROM po_asl_attributes_gt PAAGT ,

903: PAAGT.vmi_min_days_dsp ,
904: PAAGT.vmi_max_days_dsp ,
905: PAAGT.fixed_order_quantity_dsp ,
906: PAAGT.forecast_horizon_dsp
907: FROM po_asl_attributes_gt PAAGT ,
908: po_approved_supplier_list_gt ASLGT
909: WHERE PAAGT.user_key = ASLGT.user_key
910: AND PAAGT.asl_id = PAA.asl_id
911: AND PAAGT.using_organization_id = PAA.using_organization_id

Line 917: FROM po_asl_attributes_gt PAAGT,

913: AND PAAGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
914: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
915: WHERE (PAA.asl_id, PAA.using_organization_id) IN
916: (SELECT PAAGT.asl_id, PAAGT.using_organization_id
917: FROM po_asl_attributes_gt PAAGT,
918: po_approved_supplier_list_gt ASLGT
919: WHERE ASLGT.user_key = PAAGT.user_key
920: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
921: AND PAAGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

Line 926: po_asl_api_pvt.log('number of rows updated in po_asl_attributes:'

922: AND PAAGT.asl_id = PAA.asl_id
923: AND PAAGT.using_organization_id = PAA.using_organization_id
924: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
925:
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

Line 1248: DELETE FROM po_asl_attributes PAA

1244: l_progress := 65;
1245: ------------------------------UPDATE MODE ENDS--------------------------------
1246:
1247: ------------------------------DELETE MODE START-------------------------------
1248: DELETE FROM po_asl_attributes PAA
1249: WHERE (asl_id, using_organization_id) IN
1250: (SELECT PAAGT.asl_id,
1251: PAAGT.using_organization_id
1252: FROM po_asl_attributes_gt PAAGT,

Line 1252: FROM po_asl_attributes_gt PAAGT,

1248: DELETE FROM po_asl_attributes PAA
1249: WHERE (asl_id, using_organization_id) IN
1250: (SELECT PAAGT.asl_id,
1251: PAAGT.using_organization_id
1252: FROM po_asl_attributes_gt PAAGT,
1253: po_approved_supplier_list_gt ASLGT
1254: WHERE ASLGT.user_key = PAAGT.user_key
1255: AND PAAGT.process_action = PO_ASL_API_PUB.g_ACTION_DELETE
1256: AND PAAGT.asl_id = PAA.asl_id

Line 1260: po_asl_api_pvt.log('number of rows deleted from po_asl_attributes:'

1256: AND PAAGT.asl_id = PAA.asl_id
1257: AND PAAGT.using_organization_id = PAA.using_organization_id
1258: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1259:
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

Line 1285: FROM po_asl_attributes PAA

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
1287: AND PAA.using_organization_id = PAD.using_organization_id)
1288: AND EXISTS
1289: (SELECT 1,

Line 1324: FROM po_asl_attributes PAA

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
1325: WHERE PAA.asl_id = CHV.reference_id
1326: AND PAA.using_organization_id = CHV.using_organization_id
1327: AND (Nvl(PAA.enable_authorizations_flag, 'N') <> 'Y'
1328: OR Nvl(PAA.enable_plan_schedule_flag , 'N') <> 'Y'))

Line 1344: FROM po_asl_attributes PAA

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
1346: AND PAA.using_organization_id = CHV.using_organization_id)
1347: AND EXISTS
1348: (SELECT 1,

Line 1384: FROM po_asl_attributes PAA

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
1385: WHERE PAA.asl_id = PSIC.asl_id
1386: AND PAA.using_organization_id = PSIC.using_organization_id
1387: AND PAA.using_organization_id <> -1
1388: AND Nvl(PAA.enable_vmi_flag , 'N') <> 'Y')

Line 1404: FROM po_asl_attributes PAA

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
1406: AND PAA.using_organization_id = PSIC.using_organization_id)
1407: AND EXISTS
1408: (SELECT 1,

Line 1443: FROM po_asl_attributes PAA

1439: DELETE FROM po_supplier_item_tolerance PSIT
1440: WHERE (asl_id, using_organization_id) IN
1441: (SELECT PAA.asl_id,
1442: PAA.using_organization_id
1443: FROM po_asl_attributes PAA
1444: WHERE PAA.asl_id = PSIT.asl_id
1445: AND PAA.using_organization_id = PSIT.using_organization_id
1446: AND PAA.using_organization_id <> -1
1447: AND Nvl(PAA.enable_vmi_flag , 'N') <> 'Y')

Line 1463: FROM po_asl_attributes PAA

1459: --Delete tolerance, if asl_attributes doesn't exist
1460: DELETE FROM po_supplier_item_tolerance PSIT
1461: WHERE NOT EXISTS
1462: (SELECT 1
1463: FROM po_asl_attributes PAA
1464: WHERE PAA.asl_id = PSIT.asl_id
1465: AND PAA.using_organization_id = PSIT.using_organization_id)
1466: AND EXISTS
1467: (SELECT 1,

Line 1693: -- For logging po_asl_attributes_rec records

1689:
1690: --Name: log
1691:
1692: --Function:
1693: -- For logging po_asl_attributes_rec records
1694:
1695: --Parameters:
1696:
1697: --IN:

Line 1698: --p_attr_rec po_asl_attributes_rec

1694:
1695: --Parameters:
1696:
1697: --IN:
1698: --p_attr_rec po_asl_attributes_rec
1699:
1700: --End of Comments
1701: --------------------------------------------------------------------------------
1702:

Line 1704: p_attr_rec IN po_asl_attributes_rec

1700: --End of Comments
1701: --------------------------------------------------------------------------------
1702:
1703: PROCEDURE log(
1704: p_attr_rec IN po_asl_attributes_rec
1705: )
1706: AS
1707:
1708: BEGIN