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.WIP_JOB_DTLS_SUBSTITUTIONS dependencies on WIP_OPERATION_RESOURCE_USAGE

Line 2405: DELETE FROM WIP_OPERATION_RESOURCE_USAGE

2401: x_err_msg out NOCOPY varchar2) IS
2402:
2403: BEGIN
2404:
2405: DELETE FROM WIP_OPERATION_RESOURCE_USAGE
2406: WHERE wip_entity_id = p_wip_entity_id
2407: AND organization_id = p_organization_id
2408: AND operation_seq_num = p_operation_seq_num
2409: AND resource_seq_num = p_resource_seq_num;

Line 2504: DELETE FROM WIP_OPERATION_RESOURCE_USAGE

2500: OPERATION_SEQ_NUM AND RESOURCE_SEQ_NUM IS NULL
2501: **********************************************************************/
2502:
2503: /* delete all existing resource and resource instance usages.*/
2504: DELETE FROM WIP_OPERATION_RESOURCE_USAGE
2505: WHERE wip_entity_id = p_wip_entity_id
2506: AND organization_id = p_organization_id
2507: AND operation_seq_num = p_operation_seq_num
2508: AND resource_seq_num = p_resource_seq_num;

Line 2518: INSERT INTO WIP_OPERATION_RESOURCE_USAGE

2514: p_resource_seq_num) LOOP
2515:
2516: IF cur_update.substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN
2517:
2518: INSERT INTO WIP_OPERATION_RESOURCE_USAGE
2519: ( WIP_ENTITY_ID ,
2520: ORGANIZATION_ID,
2521: OPERATION_SEQ_NUM,
2522: RESOURCE_SEQ_NUM,

Line 2612: INSERT INTO WIP_OPERATION_RESOURCE_USAGE

2608: p_resource_seq_num number) IS
2609:
2610: BEGIN
2611:
2612: INSERT INTO WIP_OPERATION_RESOURCE_USAGE
2613: (WIP_ENTITY_ID,
2614: OPERATION_SEQ_NUM,
2615: RESOURCE_SEQ_NUM,
2616: ORGANIZATION_ID,

Line 3074: from wip_operation_resource_usage

3070: p_resource_seq_num number) is
3071: select start_date,
3072: completion_date,
3073: cumulative_processing_time
3074: from wip_operation_resource_usage
3075: where wip_entity_id = p_wip_entity_id
3076: and operation_seq_num = p_operation_seq_num
3077: and resource_seq_num = p_resource_seq_num
3078: and instance_id is null

Line 3086: update wip_operation_resource_usage

3082: current_cpt NUMBER := 0;
3083: begin
3084: for cur_row in res_usage(p_wip_entity_id, p_operation_seq_num, p_resource_seq_num) loop
3085: current_cpt := current_cpt + wip_datetimes.datetime_diff_to_mins(cur_row.completion_date, cur_row.start_date);
3086: update wip_operation_resource_usage
3087: set cumulative_processing_time = current_cpt
3088: where current of res_usage;
3089: end loop;
3090: end update_cumulative_time;