DBA Data[Home] [Help]

APPS.MSC_ATP_FUNC dependencies on MSC_DESIGNATORS

Line 708: FROM MSC_DESIGNATORS

704:
705: BEGIN
706: SELECT '1'
707: INTO l_valid
708: FROM MSC_DESIGNATORS
709: WHERE INVENTORY_ATP_FLAG = 1
710: AND DESIGNATOR_TYPE = 2
711: AND DESIGNATOR_ID = p_desig_id;
712: EXCEPTION

Line 732: FROM MSC_DESIGNATORS

728:
729: BEGIN
730: SELECT designator
731: INTO l_designator
732: FROM MSC_DESIGNATORS
733: WHERE DESIGNATOR_ID = p_desig_id;
734: EXCEPTION
735: WHEN NO_DATA_FOUND THEN
736: l_designator := NULL;

Line 753: FROM MSC_DESIGNATORS

749: BEGIN
750: BEGIN
751: SELECT demand_class
752: INTO l_demand_class
753: FROM MSC_DESIGNATORS
754: WHERE DESIGNATOR_ID = p_desig_id;
755: EXCEPTION
756: WHEN NO_DATA_FOUND THEN
757: l_demand_class := NULL;