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_APPROVED_SUPPLIER_LIST

Line 43: INSERT INTO po_approved_supplier_list

39: --create/update/delete records in the base tables for the non rejected
40: --records in the gt tables.
41:
42: ------------------------------CREATE MODE starts------------------------------
43: INSERT INTO po_approved_supplier_list
44: ( asl_id ,
45: using_organization_id ,
46: owning_organization_id ,
47: vendor_business_type ,

Line 124: FROM po_approved_supplier_list_gt

120: program_application_id ,
121: program_id ,
122: program_update_date ,
123: Decode(disable_flag,'Y','Y','N')
124: FROM po_approved_supplier_list_gt
125: WHERE process_action = PO_ASL_API_PUB.g_ACTION_CREATE AND
126: process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED
127: );
128: po_asl_api_pvt.log('number of rows inserted into po_approved_supplier_list:'

Line 128: po_asl_api_pvt.log('number of rows inserted into po_approved_supplier_list:'

124: FROM po_approved_supplier_list_gt
125: WHERE process_action = PO_ASL_API_PUB.g_ACTION_CREATE AND
126: process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED
127: );
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

Line 266: FROM po_approved_supplier_list_gt

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
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:'

Line 405: FROM po_approved_supplier_list_gt PASL

401: NULL ,
402: NULL ,
403: NULL ,
404: NULL
405: FROM po_approved_supplier_list_gt PASL
406: WHERE PASL.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED AND
407: PASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE AND
408: (Upper(PASL.vendor_business_type) = 'MANUFACTURER' OR
409: NOT EXISTS

Line 488: FROM po_approved_supplier_list_gt

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)
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:'

Line 564: FROM po_approved_supplier_list_gt

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)
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:'

Line 640: FROM po_approved_supplier_list_gt

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)
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:'

Line 712: FROM po_approved_supplier_list_gt

708: program_update_date
709: FROM po_supplier_item_tolerance_gt
710: WHERE user_key IN
711: (SELECT user_key
712: FROM po_approved_supplier_list_gt
713: WHERE process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
714: AND process_action = PO_ASL_API_PUB.g_ACTION_ADD
715: );
716: po_asl_api_pvt.log('Num of rows inserted into po_supplier_item_tolerance:'

Line 722: UPDATE po_approved_supplier_list PASL

718: l_progress := 35;
719: ------------------------------CREATE MODE END---------------------------------
720:
721: ------------------------------UPDATE MODE STARTS------------------------------
722: UPDATE po_approved_supplier_list PASL
723: SET
724: (PASL.vendor_business_type ,
725: PASL.asl_status_id ,
726: PASL.last_update_date ,

Line 782: FROM po_approved_supplier_list_gt ASLGT

778: ASLGT.program_id ,
779: ASLGT.program_update_date ,
780: Decode(ASLGT.disable_flag,'Y','Y','N') ,
781: fnd_global.LOGIN_ID
782: FROM po_approved_supplier_list_gt ASLGT
783: WHERE PASL.asl_id = ASLGT.asl_id
784: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
785: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
786: WHERE PASL.asl_id IN

Line 788: FROM po_approved_supplier_list_gt ASLGT

784: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
785: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
786: WHERE PASL.asl_id IN
787: (SELECT ASLGT.asl_id
788: FROM po_approved_supplier_list_gt ASLGT
789: WHERE PASL.asl_id = ASLGT.asl_id
790: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
791: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
792:

Line 793: po_asl_api_pvt.log('number of rows updated in po_approved_supplier_list:'

789: WHERE PASL.asl_id = ASLGT.asl_id
790: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
791: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
792:
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

Line 908: po_approved_supplier_list_gt ASLGT

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
912: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

Line 918: po_approved_supplier_list_gt ASLGT

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
922: AND PAAGT.asl_id = PAA.asl_id

Line 981: po_approved_supplier_list_gt ASLGT

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
985: AND PADGT.document_header_id = PAD.document_header_id

Line 992: po_approved_supplier_list_gt ASLGT

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
996: AND PADGT.document_header_id = PAD.document_header_id

Line 1056: po_approved_supplier_list_gt ASLGT

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
1060: AND CHVGT.authorization_code = CHV.authorization_code

Line 1072: po_approved_supplier_list_gt ASLGT

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
1076: AND CHVGT.authorization_code = CHV.authorization_code

Line 1137: po_approved_supplier_list_gt ASLGT

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
1141: AND GT.from_date_dsp = PSIC.from_date

Line 1153: po_approved_supplier_list_gt ASLGT

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
1157: AND GT.from_date_dsp = PSIC.from_date

Line 1216: po_approved_supplier_list_gt ASLGT

1212: GT.program_application_id,
1213: GT.program_id ,
1214: GT.program_update_date
1215: FROM po_supplier_item_tolerance_gt GT,
1216: po_approved_supplier_list_gt ASLGT
1217: WHERE GT.user_key = ASLGT.user_key
1218: AND GT.asl_id = PSIT.asl_id
1219: AND GT.using_organization_id = PSIT.using_organization_id
1220: AND GT.tolerance_dsp = PSIT.tolerance

Line 1232: po_approved_supplier_list_gt ASLGT

1228: GT.using_organization_id ,
1229: GT.tolerance_dsp ,
1230: GT.number_of_days_dsp
1231: FROM po_supplier_item_tolerance_gt GT,
1232: po_approved_supplier_list_gt ASLGT
1233: WHERE GT.user_key = ASLGT.user_key
1234: AND GT.asl_id = PSIT.asl_id
1235: AND GT.using_organization_id = PSIT.using_organization_id
1236: AND GT.tolerance_dsp = PSIT.tolerance

Line 1253: po_approved_supplier_list_gt ASLGT

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
1257: AND PAAGT.using_organization_id = PAA.using_organization_id

Line 1270: po_approved_supplier_list_gt ASLGT

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
1274: AND PADGT.using_organization_id = PAD.using_organization_id

Line 1291: FROM po_approved_supplier_list_gt ASLGT

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

Line 1306: po_approved_supplier_list_gt ASLGT

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
1310: AND CHVGT.using_organization_id = CHV.using_organization_id

Line 1332: FROM po_approved_supplier_list_gt ASLGT

1328: OR Nvl(PAA.enable_plan_schedule_flag , 'N') <> 'Y'))
1329: AND EXISTS
1330: (SELECT 1,
1331: ASLGT.using_organization_id
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:'

Line 1350: FROM po_approved_supplier_list_gt ASLGT

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

Line 1365: po_approved_supplier_list_gt ASLGT

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
1369: AND GT.from_date_dsp = PSIC.from_date

Line 1392: FROM po_approved_supplier_list_gt ASLGT

1388: AND Nvl(PAA.enable_vmi_flag , 'N') <> 'Y')
1389: AND EXISTS
1390: (SELECT 1,
1391: ASLGT.using_organization_id
1392: FROM po_approved_supplier_list_gt ASLGT
1393: WHERE ASLGT.asl_id = PSIC.asl_id
1394: AND ASLGT.using_organization_id = PSIC.using_organization_id);
1395:
1396: l_progress := 88;

Line 1410: FROM po_approved_supplier_list_gt ASLGT

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

Line 1425: po_approved_supplier_list_gt ASLGT

1421: GT.using_organization_id ,
1422: GT.number_of_days_dsp ,
1423: GT.tolerance_dsp
1424: FROM po_supplier_item_tolerance_gt GT,
1425: po_approved_supplier_list_gt ASLGT
1426: WHERE ASLGT.user_key = GT.user_key
1427: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_DELETE
1428: AND GT.asl_id = PSIT.asl_id
1429: AND GT.using_organization_id = PSIT.using_organization_id

Line 1451: FROM po_approved_supplier_list_gt ASLGT

1447: AND Nvl(PAA.enable_vmi_flag , 'N') <> 'Y')
1448: AND EXISTS
1449: (SELECT 1,
1450: ASLGT.using_organization_id
1451: FROM po_approved_supplier_list_gt ASLGT
1452: WHERE ASLGT.asl_id = PSIT.asl_id
1453: AND ASLGT.using_organization_id = PSIT.using_organization_id);
1454:
1455: l_progress := 97;

Line 1469: FROM po_approved_supplier_list_gt ASLGT

1465: AND PAA.using_organization_id = PSIT.using_organization_id)
1466: AND EXISTS
1467: (SELECT 1,
1468: ASLGT.using_organization_id
1469: FROM po_approved_supplier_list_gt ASLGT
1470: WHERE ASLGT.asl_id = PSIT.asl_id
1471: AND ASLGT.using_organization_id = PSIT.using_organization_id);
1472:
1473: po_asl_api_pvt.log('3.number of rows deleted from po_supplier_item_tolerance:'

Line 1479: UPDATE po_approved_supplier_list_gt

1475: l_progress := 98;
1476: ------------------------------DELETE MODE END---------------------------------
1477:
1478: --Update process_status column to 'Processed' in GT table
1479: UPDATE po_approved_supplier_list_gt
1480: SET process_status = PO_ASL_API_PVT.g_STATUS_SUCCESS
1481: WHERE process_status = PO_ASL_API_PVT.g_STATUS_PENDING;
1482:
1483: po_asl_api_pvt.log('status count of success from pending:' || SQL%ROWCOUNT);

Line 1540: --Reject the records in po_approved_supplier_list_gt

1536: PO_ASL_API_PVT.Log(p_user_key_tbl);
1537: PO_ASL_API_PVT.Log(p_rejection_reason);
1538: PO_ASL_API_PVT.Log(p_entity_name);
1539:
1540: --Reject the records in po_approved_supplier_list_gt
1541: FORALL l_index IN 1 .. p_user_key_tbl.Count
1542: UPDATE po_approved_supplier_list_gt PAST
1543: SET PAST.process_status = PO_ASL_API_PVT.g_STATUS_REJECTED
1544: WHERE PAST.user_key = p_user_key_tbl(l_index);

Line 1542: UPDATE po_approved_supplier_list_gt PAST

1538: PO_ASL_API_PVT.Log(p_entity_name);
1539:
1540: --Reject the records in po_approved_supplier_list_gt
1541: FORALL l_index IN 1 .. p_user_key_tbl.Count
1542: UPDATE po_approved_supplier_list_gt PAST
1543: SET PAST.process_status = PO_ASL_API_PVT.g_STATUS_REJECTED
1544: WHERE PAST.user_key = p_user_key_tbl(l_index);
1545:
1546: PO_ASL_API_PVT.Log('reject_asl_record update rowcount:' || SQL%ROWCOUNT);

Line 1620: -- For logging po_approved_supplier_list_rec records

1616:
1617: --Name: log
1618:
1619: --Function:
1620: -- For logging po_approved_supplier_list_rec records
1621:
1622: --Parameters:
1623:
1624: --IN:

Line 1625: --p_asl_rec po_approved_supplier_list_rec

1621:
1622: --Parameters:
1623:
1624: --IN:
1625: --p_asl_rec po_approved_supplier_list_rec
1626:
1627: --End of Comments
1628: --------------------------------------------------------------------------------
1629:

Line 1631: p_asl_rec IN po_approved_supplier_list_rec

1627: --End of Comments
1628: --------------------------------------------------------------------------------
1629:
1630: PROCEDURE log(
1631: p_asl_rec IN po_approved_supplier_list_rec
1632: )
1633: AS
1634:
1635: BEGIN