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 9309: insert into WIP_RESOURCE_ACTUAL_TIMES values p_jobop_resource_usages_tbls(l_header_id)(i);

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

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

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

Line 9365: FROM WIP_RESOURCE_ACTUAL_TIMES wrat

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

Line 9371: FROM WIP_RESOURCE_ACTUAL_TIMES wrat

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

Line 9429: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES

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

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

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

Line 9507: FROM WIP_RESOURCE_ACTUAL_TIMES wrat

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

Line 9513: FROM WIP_RESOURCE_ACTUAL_TIMES wrat

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

Line 9690: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES

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

Line 9724: UPDATE WIP_RESOURCE_ACTUAL_TIMES

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

Line 9735: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES

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

Line 9745: DELETE FROM WIP_RESOURCE_ACTUAL_TIMES

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