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_API_PUB

Line 125: WHERE process_action = PO_ASL_API_PUB.g_ACTION_CREATE AND

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:'
129: || SQL%ROWCOUNT);

Line 268: process_action = PO_ASL_API_PUB.g_ACTION_ADD

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:'
271: || SQL%ROWCOUNT);
272: l_progress := 15;

Line 407: PASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE AND

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
410: (SELECT PAA.user_key
411: FROM po_asl_attributes_gt PAA

Line 490: AND process_action = PO_ASL_API_PUB.g_ACTION_ADD

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:'
493: || SQL%ROWCOUNT);
494: l_progress := 20;

Line 566: AND process_action = PO_ASL_API_PUB.g_ACTION_ADD

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:'
569: || SQL%ROWCOUNT);
570: l_progress := 25;

Line 642: AND process_action = PO_ASL_API_PUB.g_ACTION_ADD

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:'
645: || SQL%ROWCOUNT);
646: l_progress := 30;

Line 714: AND process_action = PO_ASL_API_PUB.g_ACTION_ADD

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:'
717: || SQL%ROWCOUNT);
718: l_progress := 35;

Line 784: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

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
787: (SELECT ASLGT.asl_id
788: FROM po_approved_supplier_list_gt ASLGT

Line 790: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

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:
793: po_asl_api_pvt.log('number of rows updated in po_approved_supplier_list:'
794: || SQL%ROWCOUNT);

Line 912: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

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

Line 913: AND PAAGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

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
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,

Line 920: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

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

Line 921: AND PAAGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

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

Line 986: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

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

Line 987: AND PADGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

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

Line 997: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

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

Line 998: AND PADGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

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
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);

Line 1062: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

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
1061: AND CHVGT.authorization_sequence_dsp = CHV.authorization_sequence
1062: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1063: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1064: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
1065: WHERE (CHV.reference_id, CHV.using_organization_id,
1066: CHV.authorization_code, CHV.authorization_sequence) IN

Line 1063: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

1059: AND CHVGT.using_organization_id = CHV.using_organization_id
1060: AND CHVGT.authorization_code = CHV.authorization_code
1061: AND CHVGT.authorization_sequence_dsp = CHV.authorization_sequence
1062: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1063: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1064: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
1065: WHERE (CHV.reference_id, CHV.using_organization_id,
1066: CHV.authorization_code, CHV.authorization_sequence) IN
1067: (SELECT CHVGT.reference_id ,

Line 1078: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

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
1077: AND CHVGT.authorization_sequence_dsp = CHV.authorization_sequence
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:'

Line 1079: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

1075: AND CHVGT.using_organization_id = CHV.using_organization_id
1076: AND CHVGT.authorization_code = CHV.authorization_code
1077: AND CHVGT.authorization_sequence_dsp = CHV.authorization_sequence
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);

Line 1143: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

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
1142: AND Nvl(GT.to_date_dsp, SYSDATE) = Nvl(PSIC.To_Date, SYSDATE)
1143: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1144: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1145: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
1146: WHERE (PSIC.asl_id, PSIC.using_organization_id,
1147: PSIC.from_date, PSIC.To_Date) IN

Line 1144: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

1140: AND GT.using_organization_id = PSIC.using_organization_id
1141: AND GT.from_date_dsp = PSIC.from_date
1142: AND Nvl(GT.to_date_dsp, SYSDATE) = Nvl(PSIC.To_Date, SYSDATE)
1143: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1144: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1145: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
1146: WHERE (PSIC.asl_id, PSIC.using_organization_id,
1147: PSIC.from_date, PSIC.To_Date) IN
1148: (SELECT GT.asl_id ,

Line 1159: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

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
1158: AND Nvl(GT.to_date_dsp, SYSDATE) = Nvl(PSIC.To_Date, SYSDATE)
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:'

Line 1160: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

1156: AND GT.using_organization_id = PSIC.using_organization_id
1157: AND GT.from_date_dsp = PSIC.from_date
1158: AND Nvl(GT.to_date_dsp, SYSDATE) = Nvl(PSIC.To_Date, SYSDATE)
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);

Line 1222: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

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
1221: AND GT.number_of_days_dsp = PSIT.number_of_days
1222: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1223: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1224: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
1225: WHERE (PSIT.asl_id, PSIT.using_organization_id,
1226: PSIT.tolerance, PSIT.number_of_days) IN

Line 1223: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

1219: AND GT.using_organization_id = PSIT.using_organization_id
1220: AND GT.tolerance_dsp = PSIT.tolerance
1221: AND GT.number_of_days_dsp = PSIT.number_of_days
1222: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1223: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1224: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED)
1225: WHERE (PSIT.asl_id, PSIT.using_organization_id,
1226: PSIT.tolerance, PSIT.number_of_days) IN
1227: (SELECT GT.asl_id ,

Line 1238: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

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
1237: AND GT.number_of_days_dsp = PSIT.number_of_days
1238: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1239: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1240: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1241:
1242: po_asl_api_pvt.log('number of rows updated in po_supplier_item_tolerance:'

Line 1239: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

1235: AND GT.using_organization_id = PSIT.using_organization_id
1236: AND GT.tolerance_dsp = PSIT.tolerance
1237: AND GT.number_of_days_dsp = PSIT.number_of_days
1238: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1239: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE
1240: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1241:
1242: po_asl_api_pvt.log('number of rows updated in po_supplier_item_tolerance:'
1243: || SQL%ROWCOUNT);

Line 1255: AND PAAGT.process_action = PO_ASL_API_PUB.g_ACTION_DELETE

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
1258: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);
1259:

Line 1272: AND PADGT.process_action = PO_ASL_API_PUB.g_ACTION_DELETE

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
1275: AND PADGT.document_header_id = PAD.document_header_id
1276: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);

Line 1308: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_DELETE

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
1311: AND CHVGT.authorization_code = CHV.authorization_code
1312: AND ASLGT.process_status <> PO_ASL_API_PVT.g_STATUS_REJECTED);

Line 1367: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_DELETE

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
1370: AND Nvl(GT.to_date_dsp, SYSDATE)= Nvl(PSIC.To_Date, SYSDATE)
1371: AND GT.capacity_per_day_dsp = PSIC.capacity_per_day

Line 1427: AND GT.process_action = PO_ASL_API_PUB.g_ACTION_DELETE

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
1430: AND GT.number_of_days_dsp = PSIT.number_of_days
1431: AND GT.tolerance_dsp = PSIT.tolerance