DBA Data[Home] [Help]

APPS.MRP_MANAGER_PK dependencies on MRP_MANAGER_PK

Line 1: PACKAGE BODY mrp_manager_pk AS

1: PACKAGE BODY mrp_manager_pk AS
2: /* $Header: MRPPPMGB.pls 120.3.12000000.4 2007/10/25 19:33:29 schaudha ship $ */
3:
4: -- Global constant for package name
5: g_om_installed VARCHAR2(3) := NULL;

Line 2113: 1, mrp_manager_pk.get_project_id(dates.reservation_id),

2109:
2110: UPDATE mrp_schedule_dates dates
2111: SET (project_id, task_id, end_item_unit_number)
2112: = (SELECT DECODE(mtl.project_reference_enabled,
2113: 1, mrp_manager_pk.get_project_id(dates.reservation_id),
2114: NULL),
2115: DECODE(mtl.project_reference_enabled,
2116: 1, DECODE(mtl.project_control_level,
2117: 2, mrp_manager_pk.get_task_id(dates.reservation_id),

Line 2117: 2, mrp_manager_pk.get_task_id(dates.reservation_id),

2113: 1, mrp_manager_pk.get_project_id(dates.reservation_id),
2114: NULL),
2115: DECODE(mtl.project_reference_enabled,
2116: 1, DECODE(mtl.project_control_level,
2117: 2, mrp_manager_pk.get_task_id(dates.reservation_id),
2118: NULL),
2119: NULL),
2120: mrp_manager_pk.get_unit_number(dates.reservation_id)
2121: FROM mtl_parameters mtl

Line 2120: mrp_manager_pk.get_unit_number(dates.reservation_id)

2116: 1, DECODE(mtl.project_control_level,
2117: 2, mrp_manager_pk.get_task_id(dates.reservation_id),
2118: NULL),
2119: NULL),
2120: mrp_manager_pk.get_unit_number(dates.reservation_id)
2121: FROM mtl_parameters mtl
2122: WHERE dates.organization_id = mtl.organization_id)
2123: WHERE dates.old_transaction_id >= 0
2124: AND (dates.schedule_origination_type = 3