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_PUB dependencies on PO_APPROVED_SUPPLIER_LIST

Line 7: p_asl_rec IN po_approved_supplier_list_rec

3:
4: g_session_key NUMBER;
5:
6: PROCEDURE dump_to_asl_gtt(
7: p_asl_rec IN po_approved_supplier_list_rec
8: , x_return_status OUT NOCOPY VARCHAR2
9: , x_return_msg OUT NOCOPY VARCHAR2
10: );
11:

Line 99: -- p_asl_rec po_approved_supplier_list_rec

95:
96: --PARAMETERS:
97:
98: --IN:
99: -- p_asl_rec po_approved_supplier_list_rec
100: -- p_asl_attr_rec po_asl_attributes_rec
101: -- p_asl_doc_rec po_asl_documents_rec
102: -- p_chv_auth_rec chv_authorizations_rec
103: -- p_capacity_rec po_supplier_item_capacity_rec

Line 115: p_asl_rec IN po_approved_supplier_list_rec

111:
112: --END of comments
113: --------------------------------------------------------------------------------
114: PROCEDURE create_update_asl(
115: p_asl_rec IN po_approved_supplier_list_rec
116: , p_asl_attr_rec IN po_asl_attributes_rec
117: , p_asl_doc_rec IN po_asl_documents_rec
118: , p_chv_auth_rec IN chv_authorizations_rec
119: , p_capacity_rec IN po_supplier_item_capacity_rec

Line 156: DELETE FROM po_approved_supplier_list_gt;

152: po_asl_api_pvt.Log(p_capacity_rec);
153: po_asl_api_pvt.Log(p_tolerance_rec);
154: po_asl_api_pvt.Log('p_commit:' || p_commit);
155: --Empty GT tables
156: DELETE FROM po_approved_supplier_list_gt;
157: DELETE FROM po_asl_documents_gt ;
158: DELETE FROM chv_authorizations_gt;
159: DELETE FROM po_asl_attributes_gt;
160: DELETE FROM po_supplier_item_capacity_gt;

Line 208: FROM po_approved_supplier_list_gt);

204: INTO invalids
205: FROM po_asl_attributes_gt
206: WHERE user_key NOT IN
207: (SELECT user_key
208: FROM po_approved_supplier_list_gt);
209:
210: IF invalids <> 0
211: THEN
212: RAISE parent_key_not_found;

Line 236: FROM po_approved_supplier_list_gt);

232: INTO invalids
233: FROM po_asl_documents_gt
234: WHERE NOT EXISTS
235: (SELECT user_key
236: FROM po_approved_supplier_list_gt);
237:
238: IF invalids <> 0
239: THEN
240: RAISE parent_key_not_found;

Line 264: FROM po_approved_supplier_list_gt);

260: INTO invalids
261: FROM chv_authorizations_gt
262: WHERE NOT EXISTS
263: (SELECT user_key
264: FROM po_approved_supplier_list_gt);
265:
266: IF invalids <> 0
267: THEN
268: RAISE parent_key_not_found;

Line 292: FROM po_approved_supplier_list_gt);

288: INTO invalids
289: FROM po_supplier_item_capacity_gt
290: WHERE NOT EXISTS
291: (SELECT user_key
292: FROM po_approved_supplier_list_gt);
293:
294: IF invalids <> 0
295: THEN
296: RAISE parent_key_not_found;

Line 320: FROM po_approved_supplier_list_gt);

316: INTO invalids
317: FROM po_supplier_item_tolerance_gt
318: WHERE NOT EXISTS
319: (SELECT user_key
320: FROM po_approved_supplier_list_gt);
321:
322: IF invalids <> 0
323: THEN
324: RAISE parent_key_not_found;

Line 371: po_asl_api_pvt.log('Unexpected while dumping to po_approved_supplier_list_gt');

367: x_return_status := FND_API.G_RET_STS_ERROR;
368: x_return_msg := 'Parent user_key not found';
369:
370: WHEN unexp_err_pasl THEN
371: po_asl_api_pvt.log('Unexpected while dumping to po_approved_supplier_list_gt');
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: x_return_msg := 'Unexpected while dumping to po_approved_supplier_list_gt';
374:
375: WHEN unexp_err_paa THEN

Line 373: x_return_msg := 'Unexpected while dumping to po_approved_supplier_list_gt';

369:
370: WHEN unexp_err_pasl THEN
371: po_asl_api_pvt.log('Unexpected while dumping to po_approved_supplier_list_gt');
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: x_return_msg := 'Unexpected while dumping to po_approved_supplier_list_gt';
374:
375: WHEN unexp_err_paa THEN
376: po_asl_api_pvt.log('Unexpected while dumping to po_asl_attributes_gt');
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 439: --updating po_approved_supplier_list_gt to derive id fields

435: po_asl_api_pvt.log('START ::: po_asl_api_pub.process');
436: x_return_msg := NULL;
437:
438: --derive the id fields based on the display values provided
439: --updating po_approved_supplier_list_gt to derive id fields
440: derive_ids_past(
441: x_return_status => x_return_status,
442: x_return_msg => x_return_msg
443: );

Line 532: -- this will dump all the data from p_asl_rec to po_approved_supplier_list_gt

528:
529: --NAME: dump_to_asl_gtt
530:
531: --FUNCTION:
532: -- this will dump all the data from p_asl_rec to po_approved_supplier_list_gt
533:
534: --PARAMETERS:
535:
536: --IN:

Line 537: -- p_asl_rec po_approved_supplier_list_rec

533:
534: --PARAMETERS:
535:
536: --IN:
537: -- p_asl_rec po_approved_supplier_list_rec
538:
539: --OUT:
540: -- x_return_status VARCHAR2
541: -- x_return_msg VARCHAR2

Line 547: p_asl_rec IN po_approved_supplier_list_rec

543: --END of comments
544: --------------------------------------------------------------------------------
545:
546: PROCEDURE dump_to_asl_gtt(
547: p_asl_rec IN po_approved_supplier_list_rec
548: , x_return_status OUT NOCOPY VARCHAR2
549: , x_return_msg OUT NOCOPY VARCHAR2
550: )
551: IS

Line 559: INSERT INTO po_approved_supplier_list_gt (

555: po_asl_api_pvt.log(p_asl_rec);
556: x_return_msg := NULL;
557:
558: FORALL l_index IN 1 .. p_asl_rec.user_key.Count
559: INSERT INTO po_approved_supplier_list_gt (
560: session_key ,
561: user_key ,
562: process_action ,
563: process_status ,

Line 668: FROM po_approved_supplier_list_gt

664: --Otherwise, it is expected error.
665: SELECT Count(*)
666: INTO counter
667: FROM (SELECT Count(*)
668: FROM po_approved_supplier_list_gt
669: GROUP BY user_key
670: HAVING Count(*) > 1);
671:
672: IF counter > 0

Line 1356: -- po_approved_supplier_list_gt, which ever applicabale

1352: --NAME: derive_ids_past
1353:
1354: --FUNCTION:
1355: -- this will derive ids for the display fields in
1356: -- po_approved_supplier_list_gt, which ever applicabale
1357:
1358: --parameters:
1359:
1360: --OUT:

Line 1377: UPDATE po_approved_supplier_list_gt past

1373:
1374: BEGIN
1375: po_asl_api_pvt.log('START ::: derive_ids_past');
1376:
1377: UPDATE po_approved_supplier_list_gt past
1378: SET past.owning_organization_id =
1379: (SELECT hout.organization_id
1380: FROM hr_all_organization_units_tl hout
1381: WHERE hout.name = past.owning_organization_dsp

Line 1388: UPDATE po_approved_supplier_list_gt past

1384: WHERE past.owning_organization_dsp IS NOT NULL;
1385: l_progress := 10;
1386:
1387: --If Using Org id not global, then owning org will be the using org.
1388: UPDATE po_approved_supplier_list_gt past
1389: SET past.using_organization_id = owning_organization_id
1390: WHERE past.using_organization_id <> -1;
1391: l_progress := 20;
1392:

Line 1393: UPDATE po_approved_supplier_list_gt past

1389: SET past.using_organization_id = owning_organization_id
1390: WHERE past.using_organization_id <> -1;
1391: l_progress := 20;
1392:
1393: UPDATE po_approved_supplier_list_gt past
1394: SET past.asl_status_id =
1395: (SELECT pas.status_id
1396: FROM po_asl_statuses pas
1397: WHERE past.asl_status_dsp = pas.status

Line 1402: UPDATE po_approved_supplier_list_gt past

1398: AND ROWNUM < 2)
1399: WHERE past.asl_status_dsp IS NOT NULL;
1400: l_progress := 30;
1401:
1402: UPDATE po_approved_supplier_list_gt past
1403: SET past.manufacturer_id =
1404: (SELECT mm.manufacturer_id
1405: FROM mtl_manufacturers mm
1406: WHERE mm.manufacturer_name = past.manufacturer_dsp

Line 1411: UPDATE po_approved_supplier_list_gt past

1407: AND ROWNUM < 2)
1408: WHERE past.manufacturer_dsp IS NOT NULL;
1409: l_progress := 40;
1410:
1411: UPDATE po_approved_supplier_list_gt past
1412: SET past.vendor_id =
1413: (SELECT pv.vendor_id
1414: FROM po_vendors pv
1415: WHERE pv.vendor_name = past.vendor_dsp

Line 1420: UPDATE po_approved_supplier_list_gt past

1416: AND ROWNUM < 2)
1417: WHERE past.vendor_dsp IS NOT NULL;
1418: l_progress := 50;
1419:
1420: UPDATE po_approved_supplier_list_gt past
1421: SET past.item_id =
1422: (SELECT msi.inventory_item_id
1423: FROM mtl_system_items_kfv msi
1424: WHERE msi.concatenated_segments = past.item_dsp

Line 1430: UPDATE po_approved_supplier_list_gt past

1426: AND ROWNUM < 2)
1427: WHERE past.item_dsp IS NOT NULL;
1428: l_progress := 60;
1429:
1430: UPDATE po_approved_supplier_list_gt past
1431: SET past.category_id =
1432: (SELECT mc.category_id
1433: FROM mtl_categories_kfv mc
1434: WHERE mc.concatenated_segments = past.category_dsp

Line 1439: UPDATE po_approved_supplier_list_gt past

1435: AND ROWNUM < 2)
1436: WHERE past.category_dsp IS NOT NULL;
1437: l_progress := 70;
1438:
1439: UPDATE po_approved_supplier_list_gt past
1440: SET past.vendor_site_id =
1441: (SELECT pvs.vendor_site_id
1442: FROM po_vendor_sites_all pvs
1443: WHERE pvs.vendor_site_code = past.vendor_site_dsp

Line 1450: UPDATE po_approved_supplier_list_gt asl1

1446: AND ROWNUM < 2)
1447: WHERE past.vendor_site_dsp IS NOT NULL;
1448: l_progress := 80;
1449:
1450: UPDATE po_approved_supplier_list_gt asl1
1451: SET asl1.manufacturer_asl_id =
1452: (SELECT pasl.asl_id
1453: FROM po_approved_supplier_list pasl,
1454: mtl_manufacturers mm,

Line 1453: FROM po_approved_supplier_list pasl,

1449:
1450: UPDATE po_approved_supplier_list_gt asl1
1451: SET asl1.manufacturer_asl_id =
1452: (SELECT pasl.asl_id
1453: FROM po_approved_supplier_list pasl,
1454: mtl_manufacturers mm,
1455: po_asl_statuses past,
1456: po_asl_status_rules psr
1457: WHERE pasl.manufacturer_id = mm.manufacturer_id

Line 1479: po_asl_api_pvt.log('derive_ids_past: po_approved_supplier_list_gt rowcount:'

1475: )
1476: WHERE asl1.manufacturer_asl_dsp IS NOT NULL;
1477: l_progress := 100;
1478:
1479: po_asl_api_pvt.log('derive_ids_past: po_approved_supplier_list_gt rowcount:'
1480: || SQL%ROWCOUNT);
1481: po_asl_api_pvt.log('END ::: derive_ids_past');
1482: EXCEPTION
1483:

Line 1745: FROM po_approved_supplier_list_gt past

1741: WHERE pvs.vendor_site_code = paa.vendor_site_dsp
1742: AND pvs.vendor_id = paa.vendor_id
1743: AND pvs.org_id IN
1744: (SELECT owning_organization_id
1745: FROM po_approved_supplier_list_gt past
1746: WHERE paa.user_key = past.user_key)
1747: AND ROWNUM < 2)
1748: WHERE paa.vendor_site_dsp IS NOT NULL;
1749: l_progress := 60;

Line 1906: -- in po_approved_supplier_list_gt table.

1902: --NAME: collect_invalids_in_asl_gt
1903:
1904: --FUNCTION:
1905: -- This will collect userkeys for which ids not found for the descriptions
1906: -- in po_approved_supplier_list_gt table.
1907:
1908: --PARAMETERS:
1909:
1910: --OUT:

Line 1943: 'po_approved_supplier_list_gt' AS entity ,

1939: l_entity_name ,
1940: l_reject_reason
1941: FROM
1942: (SELECT user_key ,
1943: 'po_approved_supplier_list_gt' AS entity ,
1944: fnd_message.get_string('PO','OWNING_ORG_NOT_FOUND') AS msg
1945: FROM po_approved_supplier_list_gt
1946: WHERE owning_organization_dsp IS NOT NULL
1947: AND owning_organization_id IS NULL

Line 1945: FROM po_approved_supplier_list_gt

1941: FROM
1942: (SELECT user_key ,
1943: 'po_approved_supplier_list_gt' AS entity ,
1944: fnd_message.get_string('PO','OWNING_ORG_NOT_FOUND') AS msg
1945: FROM po_approved_supplier_list_gt
1946: WHERE owning_organization_dsp IS NOT NULL
1947: AND owning_organization_id IS NULL
1948:
1949: UNION ALL

Line 1952: 'po_approved_supplier_list_gt' AS entity ,

1948:
1949: UNION ALL
1950:
1951: SELECT user_key ,
1952: 'po_approved_supplier_list_gt' AS entity ,
1953: fnd_message.get_string('PO','STATUS_NOT_FOUND') AS msg
1954: FROM po_approved_supplier_list_gt
1955: WHERE asl_status_dsp IS NOT NULL
1956: AND asl_status_id IS NULL

Line 1954: FROM po_approved_supplier_list_gt

1950:
1951: SELECT user_key ,
1952: 'po_approved_supplier_list_gt' AS entity ,
1953: fnd_message.get_string('PO','STATUS_NOT_FOUND') AS msg
1954: FROM po_approved_supplier_list_gt
1955: WHERE asl_status_dsp IS NOT NULL
1956: AND asl_status_id IS NULL
1957:
1958: UNION ALL

Line 1961: 'po_approved_supplier_list_gt' AS entity ,

1957:
1958: UNION ALL
1959:
1960: SELECT user_key ,
1961: 'po_approved_supplier_list_gt' AS entity ,
1962: fnd_message.get_string('PO','MANUFACTURER_NOT_FOUND') AS msg
1963: FROM po_approved_supplier_list_gt
1964: WHERE (manufacturer_dsp IS NOT NULL
1965: AND manufacturer_id IS NULL)

Line 1963: FROM po_approved_supplier_list_gt

1959:
1960: SELECT user_key ,
1961: 'po_approved_supplier_list_gt' AS entity ,
1962: fnd_message.get_string('PO','MANUFACTURER_NOT_FOUND') AS msg
1963: FROM po_approved_supplier_list_gt
1964: WHERE (manufacturer_dsp IS NOT NULL
1965: AND manufacturer_id IS NULL)
1966: OR
1967: (manufacturer_asl_dsp IS NOT NULL

Line 1973: 'po_approved_supplier_list_gt' AS entity ,

1969:
1970: UNION ALL
1971:
1972: SELECT user_key ,
1973: 'po_approved_supplier_list_gt' AS entity ,
1974: fnd_message.get_string('PO','VENDOR_NOT_FOUND') AS msg
1975: FROM po_approved_supplier_list_gt
1976: WHERE vendor_dsp IS NOT NULL
1977: AND vendor_id IS NULL

Line 1975: FROM po_approved_supplier_list_gt

1971:
1972: SELECT user_key ,
1973: 'po_approved_supplier_list_gt' AS entity ,
1974: fnd_message.get_string('PO','VENDOR_NOT_FOUND') AS msg
1975: FROM po_approved_supplier_list_gt
1976: WHERE vendor_dsp IS NOT NULL
1977: AND vendor_id IS NULL
1978:
1979: UNION ALL

Line 1982: 'po_approved_supplier_list_gt' AS entity ,

1978:
1979: UNION ALL
1980:
1981: SELECT user_key ,
1982: 'po_approved_supplier_list_gt' AS entity ,
1983: fnd_message.get_string('PO','ITEM_NOT_FOUND') AS msg
1984: FROM po_approved_supplier_list_gt
1985: WHERE item_dsp IS NOT NULL
1986: AND item_id IS NULL);

Line 1984: FROM po_approved_supplier_list_gt

1980:
1981: SELECT user_key ,
1982: 'po_approved_supplier_list_gt' AS entity ,
1983: fnd_message.get_string('PO','ITEM_NOT_FOUND') AS msg
1984: FROM po_approved_supplier_list_gt
1985: WHERE item_dsp IS NOT NULL
1986: AND item_id IS NULL);
1987:
1988: l_progress := 25;

Line 1999: 'po_approved_supplier_list_gt' AS entity ,

1995: l_entity_name1 ,
1996: l_reject_reason1
1997: FROM
1998: (SELECT user_key ,
1999: 'po_approved_supplier_list_gt' AS entity ,
2000: fnd_message.get_string('PO','CATEGORY_NOT_FOUND') AS msg
2001: FROM po_approved_supplier_list_gt
2002: WHERE category_dsp IS NOT NULL
2003: AND category_id IS NULL

Line 2001: FROM po_approved_supplier_list_gt

1997: FROM
1998: (SELECT user_key ,
1999: 'po_approved_supplier_list_gt' AS entity ,
2000: fnd_message.get_string('PO','CATEGORY_NOT_FOUND') AS msg
2001: FROM po_approved_supplier_list_gt
2002: WHERE category_dsp IS NOT NULL
2003: AND category_id IS NULL
2004:
2005: UNION ALL

Line 2008: 'po_approved_supplier_list_gt' AS entity ,

2004:
2005: UNION ALL
2006:
2007: SELECT user_key ,
2008: 'po_approved_supplier_list_gt' AS entity ,
2009: fnd_message.get_string('PO','VENDOR_SITE_NOT_FOUND') AS msg
2010: FROM po_approved_supplier_list_gt
2011: WHERE vendor_site_dsp IS NOT NULL
2012: AND vendor_site_id IS NULL

Line 2010: FROM po_approved_supplier_list_gt

2006:
2007: SELECT user_key ,
2008: 'po_approved_supplier_list_gt' AS entity ,
2009: fnd_message.get_string('PO','VENDOR_SITE_NOT_FOUND') AS msg
2010: FROM po_approved_supplier_list_gt
2011: WHERE vendor_site_dsp IS NOT NULL
2012: AND vendor_site_id IS NULL
2013:
2014: UNION ALL

Line 2017: 'po_approved_supplier_list_gt' AS entity ,

2013:
2014: UNION ALL
2015:
2016: SELECT user_key ,
2017: 'po_approved_supplier_list_gt' AS entity ,
2018: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2019: FROM po_approved_supplier_list_gt
2020: WHERE process_action NOT IN
2021: (PO_ASL_API_PUB.g_ACTION_CREATE,

Line 2019: FROM po_approved_supplier_list_gt

2015:
2016: SELECT user_key ,
2017: 'po_approved_supplier_list_gt' AS entity ,
2018: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2019: FROM po_approved_supplier_list_gt
2020: WHERE process_action NOT IN
2021: (PO_ASL_API_PUB.g_ACTION_CREATE,
2022: PO_ASL_API_PUB.g_ACTION_UPDATE,
2023: PO_ASL_API_PUB.g_ACTION_SYNC)

Line 2253: po_approved_supplier_list_gt ASL

2249: SELECT PAA.user_key ,
2250: 'po_asl_attributes_gt' AS entity ,
2251: fnd_message.get_string('PO','INVALID_PAA_ACTION') AS msg
2252: FROM po_asl_attributes_gt PAA,
2253: po_approved_supplier_list_gt ASL
2254: WHERE ASL.user_key = PAA.user_key
2255: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2256: AND PAA.process_action <> PO_ASL_API_PUB.g_ACTION_ADD
2257: );

Line 2395: po_approved_supplier_list_gt ASL

2391: SELECT PAD.user_key ,
2392: 'po_asl_documents_gt' AS entity ,
2393: fnd_message.get_string('PO','INVALID_PAD_ACTION') AS msg
2394: FROM po_asl_documents_gt PAD,
2395: po_approved_supplier_list_gt ASL
2396: WHERE ASL.user_key = PAD.user_key
2397: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2398: AND PAD.process_action <> PO_ASL_API_PUB.g_ACTION_ADD
2399:

Line 2407: po_approved_supplier_list_gt ASL

2403: SELECT CHV.user_key ,
2404: 'chv_authorizations_gt' AS entity ,
2405: fnd_message.get_string('PO','INVALID_CHV_ACTION') AS msg
2406: FROM chv_authorizations_gt CHV,
2407: po_approved_supplier_list_gt ASL
2408: WHERE ASL.user_key = CHV.user_key
2409: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2410: AND CHV.process_action <> PO_ASL_API_PUB.g_ACTION_ADD
2411:

Line 2419: po_approved_supplier_list_gt ASL

2415: SELECT CAP.user_key ,
2416: 'po_supplier_item_capacity_gt' AS entity ,
2417: fnd_message.get_string('PO','INVALID_CAP_ACTION') AS msg
2418: FROM po_supplier_item_capacity_gt CAP,
2419: po_approved_supplier_list_gt ASL
2420: WHERE ASL.user_key = CAP.user_key
2421: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2422: AND CAP.process_action <> PO_ASL_API_PUB.g_ACTION_ADD
2423:

Line 2431: po_approved_supplier_list_gt ASL

2427: SELECT TOL.user_key ,
2428: 'po_supplier_item_tolerance_gt' AS entity ,
2429: fnd_message.get_string('PO','INVALID_TOL_ACTION') AS msg
2430: FROM po_supplier_item_tolerance_gt TOL,
2431: po_approved_supplier_list_gt ASL
2432: WHERE ASL.user_key = TOL.user_key
2433: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2434: AND TOL.process_action <> PO_ASL_API_PUB.g_ACTION_ADD
2435: );

Line 2635: FROM po_approved_supplier_list_gt ASL

2631: l_category_id ,
2632: l_vendor_id ,
2633: l_vendor_site_id ,
2634: l_owning_org_id
2635: FROM po_approved_supplier_list_gt ASL
2636: WHERE ASL.user_key = p_user_key
2637: AND ROWNUM < 2;
2638:
2639: l_progress := 20;

Line 2907: FROM po_approved_supplier_list_gt ASL

2903: SELECT ASL.item_id ,
2904: ASL.category_id
2905: INTO l_item_id ,
2906: l_category_id
2907: FROM po_approved_supplier_list_gt ASL
2908: WHERE ASL.user_key = p_user_key
2909: AND ROWNUM < 2;
2910:
2911: po_asl_api_pvt.log('l_item_id :' || l_item_id);