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.6.12020000.2 2013/02/27 04:34:41 lsindhur ship $ */
3:
4: -- Global constant for package name
5: g_om_installed VARCHAR2(3) := NULL;

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

2114:
2115: UPDATE mrp_schedule_dates dates
2116: SET (project_id, task_id, end_item_unit_number)
2117: = (SELECT DECODE(mtl.project_reference_enabled,
2118: 1, mrp_manager_pk.get_project_id(dates.reservation_id),
2119: NULL),
2120: DECODE(mtl.project_reference_enabled,
2121: 1, DECODE(mtl.project_control_level,
2122: 2, mrp_manager_pk.get_task_id(dates.reservation_id),

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

2118: 1, mrp_manager_pk.get_project_id(dates.reservation_id),
2119: NULL),
2120: DECODE(mtl.project_reference_enabled,
2121: 1, DECODE(mtl.project_control_level,
2122: 2, mrp_manager_pk.get_task_id(dates.reservation_id),
2123: NULL),
2124: NULL),
2125: mrp_manager_pk.get_unit_number(dates.reservation_id)
2126: FROM mtl_parameters mtl

Line 2125: mrp_manager_pk.get_unit_number(dates.reservation_id)

2121: 1, DECODE(mtl.project_control_level,
2122: 2, mrp_manager_pk.get_task_id(dates.reservation_id),
2123: NULL),
2124: NULL),
2125: mrp_manager_pk.get_unit_number(dates.reservation_id)
2126: FROM mtl_parameters mtl
2127: WHERE dates.organization_id = mtl.organization_id)
2128: WHERE dates.old_transaction_id >= 0
2129: AND (dates.schedule_origination_type = 3