DBA Data[Home] [Help]

APPS.INV_RCV_COMMON_APIS dependencies on INV_PROJECT

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

4526: END IF;
4527:
4528: l_progress := '100';
4529:
4530: /* Bug 2323718: Returning INV_PROJECT.get_locsegs rather than conc. segments */
4531: IF l_locator_id <> -1 THEN
4532: l_progress := '110';
4533:
4534: BEGIN

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

4531: IF l_locator_id <> -1 THEN
4532: l_progress := '110';
4533:
4534: BEGIN
4535: SELECT inv_project.get_locsegs(inventory_location_id, organization_id)
4536: INTO x_locator_segs
4537: FROM mtl_item_locations
4538: WHERE organization_id = p_organization_id
4539: AND inventory_location_id = l_locator_id;

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

7384: END IF;
7385:
7386: BEGIN
7387: IF (l_task_id IS NOT NULL) THEN
7388: x_task_number := inv_projectlocator_pub.get_task_number(l_task_id);
7389: print_debug('error ' || SQLERRM, 4);
7390: --dbms_output.put_line('task '||x_task_number);
7391: END IF;
7392: EXCEPTION

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

7687: --Get the locator segments only if sub and locator_id are set
7688: IF (l_sub_code IS NOT NULL AND l_locator_id IS NOT NULL) THEN
7689: l_progress := '70';
7690: BEGIN
7691: SELECT inv_project.get_locsegs(inventory_location_id, organization_id)
7692: INTO x_locator_segs
7693: FROM mtl_item_locations
7694: WHERE organization_id = p_organization_id
7695: AND inventory_location_id = l_locator_id;