93: WHERE BOM_OPERATIONAL_ROUTINGS.ALTERNATE_ROUTING_DESIGNATOR =
94: X_Alt_Desig_Code
95: UNION
96: SELECT 1
97: FROM CST_COST_TYPES
98: WHERE CST_COST_TYPES.ALTERNATE_BOM_DESIGNATOR =
99: X_Alt_Desig_Code;
100: cur_bom_rtg_cost c_check_bom_rtg_cost%ROWTYPE;
101: BEGIN
94: X_Alt_Desig_Code
95: UNION
96: SELECT 1
97: FROM CST_COST_TYPES
98: WHERE CST_COST_TYPES.ALTERNATE_BOM_DESIGNATOR =
99: X_Alt_Desig_Code;
100: cur_bom_rtg_cost c_check_bom_rtg_cost%ROWTYPE;
101: BEGIN
102: IF X_Organization_Id IS NOT NULL THEN
158: X_Alternate_Designator_Code
159: );
160:
161: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
162: (SELECT 1 FROM CST_COST_TYPES
163: WHERE CST_COST_TYPES.Organization_Id = X_Organization_Id
164: AND CST_COST_TYPES.ALTERNATE_BOM_DESIGNATOR =
165: X_Alternate_Designator_Code
166: );
159: );
160:
161: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
162: (SELECT 1 FROM CST_COST_TYPES
163: WHERE CST_COST_TYPES.Organization_Id = X_Organization_Id
164: AND CST_COST_TYPES.ALTERNATE_BOM_DESIGNATOR =
165: X_Alternate_Designator_Code
166: );
167:
160:
161: SELECT 1 INTO DUMMY FROM DUAL WHERE NOT EXISTS
162: (SELECT 1 FROM CST_COST_TYPES
163: WHERE CST_COST_TYPES.Organization_Id = X_Organization_Id
164: AND CST_COST_TYPES.ALTERNATE_BOM_DESIGNATOR =
165: X_Alternate_Designator_Code
166: );
167:
168: EXCEPTION