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_OPERATION_RESOURCES

Line 9352: from wip_operation_resources wor

9348: */
9349: DECLARE
9350: cursor C_WOR is
9351: select resource_id
9352: from wip_operation_resources wor
9353: where wor.wip_entity_id = l_wip_entity_id
9354: and wor.operation_seq_num = l_fm_op_seq_num;
9355:
9356: Type t_wor_resource_id is table of wip_operation_resources.resource_id%TYPE index by binary_integer;

Line 9356: Type t_wor_resource_id is table of wip_operation_resources.resource_id%TYPE index by binary_integer;

9352: from wip_operation_resources wor
9353: where wor.wip_entity_id = l_wip_entity_id
9354: and wor.operation_seq_num = l_fm_op_seq_num;
9355:
9356: Type t_wor_resource_id is table of wip_operation_resources.resource_id%TYPE index by binary_integer;
9357: l_wor_resource_id t_wor_resource_id;
9358: BEGIN
9359: OPEN C_WOR;
9360: FETCH C_WOR BULK COLLECT INTO l_wor_resource_id;

Line 9364: UPDATE WIP_OPERATION_RESOURCES

9360: FETCH C_WOR BULK COLLECT INTO l_wor_resource_id;
9361: CLOSE C_WOR;
9362:
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

Line 9501: from wip_operation_resources wor

9497:
9498: DECLARE
9499: cursor C_WOR is
9500: select resource_id
9501: from wip_operation_resources wor
9502: where wor.wip_entity_id = l_wip_entity_id
9503: and wor.operation_seq_num = l_fm_op_seq_num;
9504: BEGIN
9505: FOR rec in C_WOR LOOP

Line 9506: UPDATE WIP_OPERATION_RESOURCES

9502: where wor.wip_entity_id = l_wip_entity_id
9503: and wor.operation_seq_num = l_fm_op_seq_num;
9504: BEGIN
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

Line 9706: UPDATE WIP_OPERATION_RESOURCES

9702: WHERE wip_entity_id = l_wip_entity_id
9703: AND operation_seq_num = l_job_to_op_seq_num;
9704:
9705: --bug 5158378
9706: UPDATE WIP_OPERATION_RESOURCES
9707: SET actual_start_date = null,
9708: actual_completion_date = null
9709: WHERE wip_entity_id = l_wip_entity_id
9710: AND operation_seq_num = l_job_to_op_seq_num;

Line 9731: UPDATE WIP_OPERATION_RESOURCES

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:
9731: UPDATE WIP_OPERATION_RESOURCES
9732: SET actual_completion_date = null
9733: WHERE wip_entity_id = l_wip_entity_id
9734: AND operation_seq_num = l_job_to_op_seq_num;
9735:

Line 9761: UPDATE WIP_OPERATION_RESOURCES

9757: WHERE wip_entity_id = l_wip_entity_id
9758: AND operation_seq_num = l_fm_op_seq_num;
9759:
9760: --bug 5158378
9761: UPDATE WIP_OPERATION_RESOURCES
9762: SET actual_start_date = null
9763: WHERE wip_entity_id = l_wip_entity_id
9764: AND operation_seq_num = l_job_to_op_seq_num;
9765: --end bug 5158378