[Home] [Help]
2527: x_err_msg out NOCOPY varchar2) IS
2528:
2529: BEGIN
2530:
2531: DELETE FROM WIP_OPERATION_RESOURCE_USAGE
2532: WHERE wip_entity_id = p_wip_entity_id
2533: AND organization_id = p_organization_id
2534: AND operation_seq_num = p_operation_seq_num
2535: AND resource_seq_num = p_resource_seq_num;
2626: OPERATION_SEQ_NUM AND RESOURCE_SEQ_NUM IS NULL
2627: **********************************************************************/
2628:
2629: /* delete all existing resource and resource instance usages.*/
2630: DELETE FROM WIP_OPERATION_RESOURCE_USAGE
2631: WHERE wip_entity_id = p_wip_entity_id
2632: AND organization_id = p_organization_id
2633: AND operation_seq_num = p_operation_seq_num
2634: AND resource_seq_num = p_resource_seq_num;
2640: p_resource_seq_num) LOOP
2641:
2642: IF cur_update.substitution_type = WIP_JOB_DETAILS.WIP_ADD THEN
2643:
2644: INSERT INTO WIP_OPERATION_RESOURCE_USAGE
2645: ( WIP_ENTITY_ID ,
2646: ORGANIZATION_ID,
2647: OPERATION_SEQ_NUM,
2648: RESOURCE_SEQ_NUM,
2734: p_resource_seq_num number) IS
2735:
2736: BEGIN
2737:
2738: INSERT INTO WIP_OPERATION_RESOURCE_USAGE
2739: (WIP_ENTITY_ID,
2740: OPERATION_SEQ_NUM,
2741: RESOURCE_SEQ_NUM,
2742: ORGANIZATION_ID,
3197: p_resource_seq_num number) is
3198: select start_date,
3199: completion_date,
3200: cumulative_processing_time
3201: from wip_operation_resource_usage
3202: where wip_entity_id = p_wip_entity_id
3203: and operation_seq_num = p_operation_seq_num
3204: and resource_seq_num = p_resource_seq_num
3205: and instance_id is null
3209: current_cpt NUMBER := 0;
3210: begin
3211: for cur_row in res_usage(p_wip_entity_id, p_operation_seq_num, p_resource_seq_num) loop
3212: current_cpt := current_cpt + wip_datetimes.datetime_diff_to_mins(cur_row.completion_date, cur_row.start_date);
3213: update wip_operation_resource_usage
3214: set cumulative_processing_time = current_cpt
3215: where current of res_usage;
3216: end loop;
3217: end update_cumulative_time;