DBA Data[Home] [Help]

APPS.EAM_WORKORDERS_JSP dependencies on WIP_OPERATIONS

Line 1016: l_op wip_operations%ROWTYPE;

1012: l_auto_firm VARCHAR2(10);
1013:
1014: l_row wip_discrete_jobs%ROWTYPE;
1015: l_entity wip_entities%ROWTYPE;
1016: l_op wip_operations%ROWTYPE;
1017:
1018: l_rowid VARCHAR2(250);
1019: l_we_rowid VARCHAR2(250);
1020: l_routing_exists VARCHAR2(250);

Line 2681: update wip_operations op

2677: , j.scheduled_completion_date = j.scheduled_completion_date + l_shift
2678: where j.wip_entity_id = p_wip_entity_id;
2679:
2680: -- shift operation dates
2681: update wip_operations op
2682: set op.first_unit_start_date = op.first_unit_start_date + l_shift
2683: , op.last_unit_start_date = op.last_unit_start_date + l_shift
2684: , op.first_unit_completion_date = op.first_unit_completion_date + l_shift
2685: , op.last_unit_completion_date = op.last_unit_completion_date + l_shift