APPS.AP_APXVDMVD_PKG dependencies on PO_SYSTEM_PARAMETERS

Line 346: -- installed the table po_system_parameters exists and if it has been setup

342: --
343: -- Bug 457417 - Just checking if PO has been installed or not is no longer
344: -- sufficient in a multi-org environment, we need to know not only if PO has
345: -- been installed but if it has been setup. We assume that if PO has been
346: -- installed the table po_system_parameters exists and if it has been setup
347: -- it contains a record. (mhtaylor 30/Jan/98)
348: --
349: debug_info := 'Check to see if PO has been setup';
350: --

Line 355: FROM po_system_parameters

351: l_po_setup := 0;
352: --
353: SELECT count(*)
354: INTO l_po_setup
355: FROM po_system_parameters
356: WHERE nvl(org_id,-99) = nvl(x_org_id,-99);
357: --
358: IF l_po_setup > 0 THEN
359: --

Line 360: debug_info := 'Select from rcv_parameters, po_lookup_codes, po_system_parameters';

356: WHERE nvl(org_id,-99) = nvl(x_org_id,-99);
357: --
358: IF l_po_setup > 0 THEN
359: --
360: debug_info := 'Select from rcv_parameters, po_lookup_codes, po_system_parameters';
361:
362: SELECT rp.enforce_ship_to_location_code,
363: rp.receiving_routing_id,
364: rp.qty_rcv_tolerance,

Line 396: po_system_parameters po

392: FROM rcv_parameters rp,
393: po_lookup_codes pc1,
394: po_lookup_codes pc2,
395: po_lookup_codes pc3,
396: po_system_parameters po
397: WHERE rp.organization_id = x_inventory_organization_id
398: AND pc1.lookup_type(+) = 'RECEIVING CONTROL LEVEL'
399: AND pc1.lookup_code(+) = rp.enforce_ship_to_location_code
400: AND pc2.lookup_type(+) = 'RECEIVING CONTROL LEVEL'