DBA Data[Home] [Help]

APPS.MSC_ATP_FUNC dependencies on MSC_DESIGNATORS

Line 716: FROM MSC_DESIGNATORS

712:
713: BEGIN
714: SELECT '1'
715: INTO l_valid
716: FROM MSC_DESIGNATORS
717: WHERE INVENTORY_ATP_FLAG = 1
718: AND DESIGNATOR_TYPE = 2
719: AND DESIGNATOR_ID = p_desig_id;
720: EXCEPTION

Line 740: FROM MSC_DESIGNATORS

736:
737: BEGIN
738: SELECT designator
739: INTO l_designator
740: FROM MSC_DESIGNATORS
741: WHERE DESIGNATOR_ID = p_desig_id;
742: EXCEPTION
743: WHEN NO_DATA_FOUND THEN
744: l_designator := NULL;

Line 761: FROM MSC_DESIGNATORS

757: BEGIN
758: BEGIN
759: SELECT demand_class
760: INTO l_demand_class
761: FROM MSC_DESIGNATORS
762: WHERE DESIGNATOR_ID = p_desig_id;
763: EXCEPTION
764: WHEN NO_DATA_FOUND THEN
765: l_demand_class := NULL;