DBA Data[Home] [Help]

APPS.INV_RCV_COMMON_APIS dependencies on INV_PROJECT

Line 4047: /* Bug 2323718: Returning INV_PROJECT.get_locsegs rather than conc. segments */

4043: END IF;
4044:
4045: l_progress := '100';
4046:
4047: /* Bug 2323718: Returning INV_PROJECT.get_locsegs rather than conc. segments */
4048: IF l_locator_id <> -1 THEN
4049: l_progress := '110';
4050:
4051: BEGIN

Line 4052: SELECT inv_project.get_locsegs(inventory_location_id, organization_id)

4048: IF l_locator_id <> -1 THEN
4049: l_progress := '110';
4050:
4051: BEGIN
4052: SELECT inv_project.get_locsegs(inventory_location_id, organization_id)
4053: INTO x_locator_segs
4054: FROM mtl_item_locations
4055: WHERE organization_id = p_organization_id
4056: AND inventory_location_id = l_locator_id;

Line 6856: x_task_number := inv_projectlocator_pub.get_task_number(l_task_id);

6852: END IF;
6853:
6854: BEGIN
6855: IF (l_task_id IS NOT NULL) THEN
6856: x_task_number := inv_projectlocator_pub.get_task_number(l_task_id);
6857: print_debug('error ' || SQLERRM, 4);
6858: --dbms_output.put_line('task '||x_task_number);
6859: END IF;
6860: EXCEPTION

Line 7159: SELECT inv_project.get_locsegs(inventory_location_id, organization_id)

7155: --Get the locator segments only if sub and locator_id are set
7156: IF (l_sub_code IS NOT NULL AND l_locator_id IS NOT NULL) THEN
7157: l_progress := '70';
7158: BEGIN
7159: SELECT inv_project.get_locsegs(inventory_location_id, organization_id)
7160: INTO x_locator_segs
7161: FROM mtl_item_locations
7162: WHERE organization_id = p_organization_id
7163: AND inventory_location_id = l_locator_id;