DBA Data[Home] [Help]

APPS.POR_AMENDMENT_PKG dependencies on PO_COMPARE_REVISIONS

Line 1389: id:= po_compare_revisions.get_location(p_id);

1385: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
1386: END IF;
1387:
1388: IF label IN ('DELIVER_TO_LOCATION_ID') THEN
1389: id:= po_compare_revisions.get_location(p_id);
1390: ELSIF label IN ('ITEM_ID') THEN
1391:
1392: SELECT msi.concatenated_segments
1393: INTO id

Line 1400: id:= po_compare_revisions.get_buyer(p_id);

1396: WHERE p_id = msi.inventory_item_id (+)
1397: AND fsp.inventory_organization_id = NVL(msi.organization_id,fsp.inventory_organization_id );
1398:
1399: ELSIF label IN ('TO_PERSON_ID','SUGGESTED_BUYER_ID') THEN
1400: id:= po_compare_revisions.get_buyer(p_id);
1401: ELSIF label IN ('HAZARD_CLASS_ID') THEN
1402: id:= po_compare_revisions.get_hazard_class(p_id);
1403: ELSIF label IN ('VENDOR_ID') THEN
1404:

Line 1402: id:= po_compare_revisions.get_hazard_class(p_id);

1398:
1399: ELSIF label IN ('TO_PERSON_ID','SUGGESTED_BUYER_ID') THEN
1400: id:= po_compare_revisions.get_buyer(p_id);
1401: ELSIF label IN ('HAZARD_CLASS_ID') THEN
1402: id:= po_compare_revisions.get_hazard_class(p_id);
1403: ELSIF label IN ('VENDOR_ID') THEN
1404:
1405: SELECT vendor_name
1406: INTO id

Line 1418: id:= po_compare_revisions.get_vendor_contact(p_id);

1414: FROM po_vendor_sites_all
1415: WHERE vendor_site_id = p_id;
1416:
1417: ELSIF label IN ('VENDOR_CONTACT_ID') THEN
1418: id:= po_compare_revisions.get_vendor_contact(p_id);
1419: ELSIF label IN ('DESTINATION_TYPE_CODE') THEN
1420: id:= po_compare_revisions.get_po_lookup('RCV DESTINATION TYPE',p_id);
1421: ELSIF label IN ('CATEGORY_ID') THEN
1422:

Line 1420: id:= po_compare_revisions.get_po_lookup('RCV DESTINATION TYPE',p_id);

1416:
1417: ELSIF label IN ('VENDOR_CONTACT_ID') THEN
1418: id:= po_compare_revisions.get_vendor_contact(p_id);
1419: ELSIF label IN ('DESTINATION_TYPE_CODE') THEN
1420: id:= po_compare_revisions.get_po_lookup('RCV DESTINATION TYPE',p_id);
1421: ELSIF label IN ('CATEGORY_ID') THEN
1422:
1423: SELECT description
1424: INTO id