[Home] [Help]
4989: BEGIN
4990: l_stmt_num := 20.1;
4991: select 1
4992: into l_exists
4993: from wsm_copy_op_resource_usage
4994: where wip_entity_id = p_wip_entity_id
4995: and organization_id = p_org_id
4996: and operation_seq_num = l_rtg_op_seq_num
4997: and resource_seq_num = l_res_seq_num
6229: p_resource_seq_num number) is
6230: select start_date,
6231: completion_date,
6232: cumulative_processing_time
6233: from wsm_copy_op_resource_usage
6234: where wip_entity_id = p_wip_entity_id
6235: and operation_seq_num = p_operation_seq_num
6236: and resource_seq_num = p_resource_seq_num
6237: and NVL(instance_id, -1) = NVL(p_instance_id, -1)
6261: loop
6262: current_cpt := current_cpt + wip_datetimes.datetime_diff_to_mins(
6263: wsm_row.completion_date,
6264: wsm_row.start_date);
6265: update wsm_copy_op_resource_usage
6266: set cumulative_processing_time = current_cpt
6267: where current of wsm_res_usage;
6268: end loop;
6269: end if;
13232: and wcor.parent_resource_seq_num = p_par_res_seq_num
13233: );
13234: /* delete the usage information .... */
13235: l_stmt_num := 100;
13236: delete from wsm_copy_op_resource_usage wcoru
13237: where wcoru.organization_id = p_org_id
13238: and wcoru.wip_entity_id = p_wip_entity_id
13239: and wcoru.operation_seq_num = p_op_seq_num
13240: and wcoru.resource_seq_num in (select resource_seq_num
16586: where wip_entity_id = wco.wip_entity_id
16587: and operation_seq_num = wco.operation_seq_num);
16588:
16589: -- Create default Usages for the added primary resources having schedule flag other than 'No'.
16590: insert into wsm_copy_op_resource_usage
16591: (wip_entity_id,
16592: operation_seq_num,
16593: resource_seq_num,
16594: organization_id,
17465: delete from wsm_copy_op_resource_instances
17466: where wip_entity_id = p_wip_entity_id
17467: and operation_seq_num = l_rtg_op_seq_num;
17468:
17469: delete from wsm_copy_op_resource_usage
17470: where wip_entity_id = p_wip_entity_id
17471: and operation_seq_num = l_rtg_op_seq_num;
17472:
17473: delete from wsm_copy_requirement_ops
17739: if p_error_code <> 0 then
17740: raise e_wljdi_common_error;
17741: end if;
17742:
17743: delete from wsm_copy_op_resource_usage wcoru
17744: where wcoru.wip_entity_id = p_wip_entity_id
17745: and wcoru.operation_seq_num = l_rtg_op_seq_num
17746: and wcoru.resource_seq_num = l_resource_seq_num
17747: and wcoru.organization_id = p_org_id ;
18259:
18260: if l_v_res(l_resource_id).reco_flag='Y' and
18261: l_v_res(l_resource_id).scheduled_flag <> WIP_CONSTANTS.SCHED_NO then
18262:
18263: insert into wsm_copy_op_resource_usage
18264: (wip_entity_id,
18265: operation_seq_num,
18266: resource_seq_num,
18267: organization_id,
19061: -- path
19062:
19063: l_stmt_num := 270.2;
19064: -- delete resource usage/instance records
19065: --delete WSM_COPY_OP_RESOURCE_USAGE
19066: --where wip_entity_id = p_wip_entity_id
19067: --and (operation_seq_num,
19068: -- resource_seq_num) in (
19069: -- select operation_seq_num,
19345: and organization_id = p_org_id
19346: and operation_seq_num = l_rtg_op_seq_num
19347: and resource_seq_num = l_res_seq_num;
19348: l_stmt_num := 320.5;
19349: delete from wsm_copy_op_resource_usage
19350: where wip_entity_id = p_wip_entity_id
19351: and organization_id = p_org_id
19352: and operation_seq_num = l_rtg_op_seq_num
19353: and resource_seq_num = l_res_seq_num;
19772: -- ST : Bug fix 4240165 : Detailed Scheduling changes end
19773:
19774: l_stmt_num := 420.4;
19775: -- delete all existing records for that resource_seq_num
19776: delete from wsm_copy_op_resource_usage
19777: where wip_entity_id = p_wip_entity_id
19778: and organization_id = p_org_id
19779: and operation_seq_num = l_rtg_op_seq_num
19780: and resource_seq_num = l_res_seq_num;
19810: -- creating WCORU records
19811: if(l_v_rtg_op_seq.first IS NOT NULL) then
19812: l_stmt_num := 430;
19813: forall i in l_v_rtg_op_seq.first..l_v_rtg_op_seq.last
19814: insert into wsm_copy_op_resource_usage(
19815: wip_entity_id ,
19816: organization_id,
19817: operation_seq_num,
19818: resource_seq_num,