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 9350: from wip_operation_resources wor

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

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

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

Line 9362: UPDATE WIP_OPERATION_RESOURCES

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

Line 9499: from wip_operation_resources wor

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

Line 9504: UPDATE WIP_OPERATION_RESOURCES

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

Line 9704: UPDATE WIP_OPERATION_RESOURCES

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

Line 9729: UPDATE WIP_OPERATION_RESOURCES

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

Line 9759: UPDATE WIP_OPERATION_RESOURCES

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