[Home] [Help]
4984: BEGIN
4985: l_stmt_num := 20.1;
4986: select 1
4987: into l_exists
4988: from wsm_copy_op_resource_usage
4989: where wip_entity_id = p_wip_entity_id
4990: and organization_id = p_org_id
4991: and operation_seq_num = l_rtg_op_seq_num
4992: and resource_seq_num = l_res_seq_num
6213: p_resource_seq_num number) is
6214: select start_date,
6215: completion_date,
6216: cumulative_processing_time
6217: from wsm_copy_op_resource_usage
6218: where wip_entity_id = p_wip_entity_id
6219: and operation_seq_num = p_operation_seq_num
6220: and resource_seq_num = p_resource_seq_num
6221: and NVL(instance_id, -1) = NVL(p_instance_id, -1)
6245: loop
6246: current_cpt := current_cpt + wip_datetimes.datetime_diff_to_mins(
6247: wsm_row.completion_date,
6248: wsm_row.start_date);
6249: update wsm_copy_op_resource_usage
6250: set cumulative_processing_time = current_cpt
6251: where current of wsm_res_usage;
6252: end loop;
6253: end if;
13128: and wcor.parent_resource_seq_num = p_par_res_seq_num
13129: );
13130: /* delete the usage information .... */
13131: l_stmt_num := 100;
13132: delete from wsm_copy_op_resource_usage wcoru
13133: where wcoru.organization_id = p_org_id
13134: and wcoru.wip_entity_id = p_wip_entity_id
13135: and wcoru.operation_seq_num = p_op_seq_num
13136: and wcoru.resource_seq_num in (select resource_seq_num
16210: where wip_entity_id = wco.wip_entity_id
16211: and operation_seq_num = wco.operation_seq_num);
16212:
16213: -- Create default Usages for the added primary resources having schedule flag other than 'No'.
16214: insert into wsm_copy_op_resource_usage
16215: (wip_entity_id,
16216: operation_seq_num,
16217: resource_seq_num,
16218: organization_id,
17023: delete from wsm_copy_op_resource_instances
17024: where wip_entity_id = p_wip_entity_id
17025: and operation_seq_num = l_rtg_op_seq_num;
17026:
17027: delete from wsm_copy_op_resource_usage
17028: where wip_entity_id = p_wip_entity_id
17029: and operation_seq_num = l_rtg_op_seq_num;
17030:
17031: delete from wsm_copy_requirement_ops
17260: if p_error_code <> 0 then
17261: raise e_wljdi_common_error;
17262: end if;
17263:
17264: delete from wsm_copy_op_resource_usage wcoru
17265: where wcoru.wip_entity_id = p_wip_entity_id
17266: and wcoru.operation_seq_num = l_rtg_op_seq_num
17267: and wcoru.resource_seq_num = l_resource_seq_num
17268: and wcoru.organization_id = p_org_id ;
17780:
17781: if l_v_res(l_resource_id).reco_flag='Y' and
17782: l_v_res(l_resource_id).scheduled_flag <> WIP_CONSTANTS.SCHED_NO then
17783:
17784: insert into wsm_copy_op_resource_usage
17785: (wip_entity_id,
17786: operation_seq_num,
17787: resource_seq_num,
17788: organization_id,
18484: -- path
18485:
18486: l_stmt_num := 270.2;
18487: -- delete resource usage/instance records
18488: --delete WSM_COPY_OP_RESOURCE_USAGE
18489: --where wip_entity_id = p_wip_entity_id
18490: --and (operation_seq_num,
18491: -- resource_seq_num) in (
18492: -- select operation_seq_num,
18768: and organization_id = p_org_id
18769: and operation_seq_num = l_rtg_op_seq_num
18770: and resource_seq_num = l_res_seq_num;
18771: l_stmt_num := 320.5;
18772: delete from wsm_copy_op_resource_usage
18773: where wip_entity_id = p_wip_entity_id
18774: and organization_id = p_org_id
18775: and operation_seq_num = l_rtg_op_seq_num
18776: and resource_seq_num = l_res_seq_num;
19195: -- ST : Bug fix 4240165 : Detailed Scheduling changes end
19196:
19197: l_stmt_num := 420.4;
19198: -- delete all existing records for that resource_seq_num
19199: delete from wsm_copy_op_resource_usage
19200: where wip_entity_id = p_wip_entity_id
19201: and organization_id = p_org_id
19202: and operation_seq_num = l_rtg_op_seq_num
19203: and resource_seq_num = l_res_seq_num;
19233: -- creating WCORU records
19234: if(l_v_rtg_op_seq.first IS NOT NULL) then
19235: l_stmt_num := 430;
19236: forall i in l_v_rtg_op_seq.first..l_v_rtg_op_seq.last
19237: insert into wsm_copy_op_resource_usage(
19238: wip_entity_id ,
19239: organization_id,
19240: operation_seq_num,
19241: resource_seq_num,