eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSMPLBMI dependencies on WIP_RESOURCE_ACTUAL_TIMES

Line 9311: insert into WIP_RESOURCE_ACTUAL_TIMES values p_jobop_resource_usages_tbls(l_header_id)(i);

9307: dml_errors EXCEPTION;
9308: PRAGMA EXCEPTION_INIT(dml_errors, -24381);
9309: BEGIN
9310: forall i in p_jobop_resource_usages_tbls(l_header_id).first..p_jobop_resource_usages_tbls(l_header_id).last SAVE EXCEPTIONS
9311: insert into WIP_RESOURCE_ACTUAL_TIMES values p_jobop_resource_usages_tbls(l_header_id)(i);
9312: -- If any errors occurred during the FORALL SAVE EXCEPTIONS,
9313: -- a single exception is raised when the statement completes.
9314:
9315: EXCEPTION

Line 9347: insert into WIP_RESOURCE_ACTUAL_TIMES values p_jobop_resource_usages_tbls(l_header_id)(i);

9343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9344: END;
9345: /*
9346: forall i in p_jobop_resource_usages_tbls(l_header_id).first..p_jobop_resource_usages_tbls(l_header_id).last SAVE EXCEPTIONS
9347: insert into WIP_RESOURCE_ACTUAL_TIMES values p_jobop_resource_usages_tbls(l_header_id)(i);
9348: */
9349: DECLARE
9350: cursor C_WOR is
9351: select resource_id

Line 9367: FROM WIP_RESOURCE_ACTUAL_TIMES wrat

9363: FORALL i in l_wor_resource_id.FIRST..l_wor_resource_id.LAST
9364: UPDATE WIP_OPERATION_RESOURCES
9365: SET actual_start_date =
9366: (SELECT min(start_date)
9367: FROM WIP_RESOURCE_ACTUAL_TIMES wrat
9368: WHERE wrat.wip_entity_id = l_wip_entity_id
9369: AND wrat.operation_seq_num = l_fm_op_seq_num
9370: AND wrat.resource_id = l_wor_resource_id(i)),
9371: projected_completion_date =

Line 9373: FROM WIP_RESOURCE_ACTUAL_TIMES wrat

9369: AND wrat.operation_seq_num = l_fm_op_seq_num
9370: AND wrat.resource_id = l_wor_resource_id(i)),
9371: projected_completion_date =
9372: (SELECT max(projected_completion_date)
9373: FROM WIP_RESOURCE_ACTUAL_TIMES wrat
9374: WHERE wrat.wip_entity_id = l_wip_entity_id
9375: AND wrat.operation_seq_num = l_fm_op_seq_num
9376: AND wrat.resource_id = l_wor_resource_id(i)),
9377: LAST_UPDATE_DATE = sysdate,

Line 9431: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES

9427: );
9428: END IF;
9429:
9430: l_stmt_num := 253.61;
9431: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES
9432: WHERE wip_entity_id = l_wip_entity_id
9433: AND operation_seq_num = l_fm_op_seq_num;
9434:
9435: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 9463: insert into WIP_RESOURCE_ACTUAL_TIMES values p_jobop_resource_usages_tbls(l_header_id)(i);

9459: dml_errors EXCEPTION;
9460: PRAGMA EXCEPTION_INIT(dml_errors, -24381);
9461: BEGIN
9462: forall i in p_jobop_resource_usages_tbls(l_header_id).first..p_jobop_resource_usages_tbls(l_header_id).last SAVE EXCEPTIONS
9463: insert into WIP_RESOURCE_ACTUAL_TIMES values p_jobop_resource_usages_tbls(l_header_id)(i);
9464: -- If any errors occurred during the FORALL SAVE EXCEPTIONS,
9465: -- a single exception is raised when the statement completes.
9466:
9467: EXCEPTION

Line 9509: FROM WIP_RESOURCE_ACTUAL_TIMES wrat

9505: FOR rec in C_WOR LOOP
9506: UPDATE WIP_OPERATION_RESOURCES
9507: SET actual_start_date =
9508: (SELECT min(start_date)
9509: FROM WIP_RESOURCE_ACTUAL_TIMES wrat
9510: WHERE wrat.wip_entity_id = l_wip_entity_id
9511: AND wrat.operation_seq_num = l_fm_op_seq_num
9512: AND wrat.resource_id = rec.resource_id),
9513: actual_completion_date =

Line 9515: FROM WIP_RESOURCE_ACTUAL_TIMES wrat

9511: AND wrat.operation_seq_num = l_fm_op_seq_num
9512: AND wrat.resource_id = rec.resource_id),
9513: actual_completion_date =
9514: (SELECT max(end_date)
9515: FROM WIP_RESOURCE_ACTUAL_TIMES wrat
9516: WHERE wrat.wip_entity_id = l_wip_entity_id
9517: AND wrat.operation_seq_num = l_fm_op_seq_num
9518: AND wrat.resource_id = rec.resource_id),
9519: LAST_UPDATE_DATE = sysdate,

Line 9692: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES

9688: --bug 5446252 added (l_fm_intraoperation_step_type = 5) for the case when undoing complete scrap
9689: IF (((l_fm_intraoperation_step_type = 1) OR (l_fm_intraoperation_step_type = 3) OR (l_fm_intraoperation_step_type = 5))
9690: AND (l_to_intraoperation_step_type = 1)) THEN
9691: --no Move In b4 Move Out
9692: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES
9693: where wip_entity_id = l_wip_entity_id
9694: and operation_seq_num = l_job_to_op_seq_num;
9695:
9696: UPDATE WIP_OPERATIONS

Line 9726: UPDATE WIP_RESOURCE_ACTUAL_TIMES

9722: SET actual_completion_date = null
9723: WHERE wip_entity_id = l_wip_entity_id
9724: AND operation_seq_num = l_job_to_op_seq_num;
9725:
9726: UPDATE WIP_RESOURCE_ACTUAL_TIMES
9727: SET end_date = NULL
9728: where wip_entity_id = l_wip_entity_id
9729: and operation_seq_num = l_job_to_op_seq_num;
9730:

Line 9737: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES

9733: WHERE wip_entity_id = l_wip_entity_id
9734: AND operation_seq_num = l_job_to_op_seq_num;
9735:
9736: /*
9737: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES
9738: where wip_entity_id = l_wip_entity_id
9739: and operation_seq_num = l_job_to_op_seq_num
9740: and projected_completion_date IS NULL;
9741: */

Line 9747: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES

9743: ELSIF ((l_fm_intraoperation_step_type = 2) AND (l_to_intraoperation_step_type = 1))
9744: AND (l_undone_txn_source_code = 'move in oa page')
9745: THEN --Move In
9746:
9747: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES
9748: where wip_entity_id = l_wip_entity_id
9749: and operation_seq_num = l_job_to_op_seq_num;
9750:
9751: UPDATE WIP_OPERATIONS