DBA Data[Home] [Help]

APPS.WIP_INFINITE_SCHEDULER_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 477: from wip_requirement_operations

473: for update nowait;
474:
475: cursor c_mtlReqs is
476: select 1
477: from wip_requirement_operations
478: where wip_entity_id = p_wipEntityID
479: and organization_id = p_orgID
480: and operation_seq_num between p_minOpSeqNum and p_maxOpSeqNum
481: for update nowait;

Line 1088: update wip_requirement_operations

1084: end if;
1085:
1086: --update mtl requirement dates if job has routing
1087: forall i in l_startOpIdx..l_endOpIdx
1088: update wip_requirement_operations
1089: set date_required = l_opTbls.startDate(i),
1090: last_update_date = l_sysdate,
1091: last_updated_by = l_userID,
1092: last_update_login = l_loginID,

Line 1102: update wip_requirement_operations

1098: and organization_id = p_orgID
1099: and operation_seq_num = l_opTbls.opSeqNum(i);
1100: else
1101: --update mtl requirement dates if job doesn't have a routing
1102: update wip_requirement_operations
1103: set date_required = p_anchorDate,
1104: last_update_date = l_sysdate,
1105: last_updated_by = l_userID,
1106: last_update_login = l_loginID,