DBA Data[Home] [Help]

APPS.ENG_VALIDATE dependencies on MRP_PLANS

Line 892: * Purpose : Function will validate the plan name against mrp_plans and

888: * Parameters IN : Plan Name
889: * Organization Id
890: * Parameters OUT: Error_Text
891: * Returns : True if plan is valid, otherwise False.
892: * Purpose : Function will validate the plan name against mrp_plans and
893: * verify if it exists. If it does then the function will check
894: * 1. If Data_completion date < Explosion_completion_date
895: * 2. If Plan completion_date < Data_completion_date
896: * If any of these conditions are violated, then the function

Line 921: FROM mrp_plans

917: plan_completion_date
918: INTO l_explosion_completion_date,
919: l_data_completion_date,
920: l_plan_completion_date
921: FROM mrp_plans
922: WHERE compile_designator = p_use_up_plan_name
923: AND organization_id = p_organization_id;
924:
925: IF l_data_completion_date < l_explosion_completion_date