DBA Data[Home] [Help]

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 1021: FROM WIP_REPETITIVE_SCHEDULES

1017: X_Line_Id NUMBER) RETURN VARCHAR IS
1018: X_Count NUMBER;
1019: cursor get_schedules is
1020: SELECT COUNT(*)
1021: FROM WIP_REPETITIVE_SCHEDULES
1022: WHERE WIP_ENTITY_ID = X_Wip_Entity_Id
1023: AND ORGANIZATION_ID = X_Org_Id
1024: AND LINE_ID = X_Line_Id
1025: AND STATUS_TYPE in (3,4,6);