APPS.WIP_OPERATIONS_UTILITIES dependencies on WIP_REPETITIVE_SCHEDULES

Line 858: UPDATE wip_repetitive_schedules

854: WHERE
855: wip_entity_id = X_Wip_Entity_Id
856: AND organization_id = X_Organization_Id;
857: ELSE
858: UPDATE wip_repetitive_schedules
859: SET first_unit_start_date = X_First_Unit_Start_Date,
860: last_unit_completion_date = X_Last_Unit_Completion_Date
861: WHERE wip_entity_id = X_Wip_Entity_Id
862: AND organization_id = X_Organization_Id

Line 1032: FROM WIP_REPETITIVE_SCHEDULES

1028: X_Line_Id NUMBER) RETURN VARCHAR IS
1029: X_Count NUMBER;
1030: cursor get_schedules is
1031: SELECT COUNT(*)
1032: FROM WIP_REPETITIVE_SCHEDULES
1033: WHERE WIP_ENTITY_ID = X_Wip_Entity_Id
1034: AND ORGANIZATION_ID = X_Org_Id
1035: AND LINE_ID = X_Line_Id
1036: AND STATUS_TYPE in (3,4,6);