DBA Data[Home] [Help]

APPS.OE_CNCL_VALIDATE_LINE dependencies on MTL_PARAMETERS

Line 559: -- If project control level in MTL_PARAMETERS for the warehouse

555: l_project_control_level NUMBER;
556: BEGIN
557: oe_debug_pub.add('Entering Validate_task_reqd',1);
558:
559: -- If project control level in MTL_PARAMETERS for the warehouse
560: -- is set to 'Task', then project references on the order must
561: -- consist of both Project and Task.
562:
563: SELECT NVL(PROJECT_CONTROL_LEVEL,0)

Line 565: FROM MTL_PARAMETERS

561: -- consist of both Project and Task.
562:
563: SELECT NVL(PROJECT_CONTROL_LEVEL,0)
564: INTO l_project_control_level
565: FROM MTL_PARAMETERS
566: WHERE ORGANIZATION_ID = p_ship_from_org_id;
567:
568: IF l_project_control_level = 2 -- control level is 'Task'
569: THEN