APPS.WSM_LBJ_INTERFACE_PVT dependencies on WSM_COPY_OP_RESOURCE_INSTANCES

Line 4543: from wsm_copy_op_resource_instances

4539: BEGIN
4540: l_stmt_num := 20.1;
4541: select 1
4542: into l_exists
4543: from wsm_copy_op_resource_instances
4544: where wip_entity_id = p_wip_entity_id
4545: and organization_id = p_org_id
4546: and operation_seq_num = l_rtg_op_seq_num
4547: and resource_seq_num = l_res_seq_num;

Line 5063: from wsm_copy_op_resource_instances wcori

5059: BEGIN
5060: l_stmt_num := 30.3;
5061: select 1
5062: into l_exists
5063: from wsm_copy_op_resource_instances wcori
5064: where wcori.wip_entity_id = p_wip_entity_id
5065: and wcori.organization_id = p_org_id
5066: and wcori.operation_seq_num = l_rtg_op_seq_num
5067: and wcori.resource_seq_num = l_res_seq_num;

Line 5098: from wsm_copy_op_resource_instances wcori

5094: select wcori.start_date,
5095: wcori.completion_date
5096: into l_the_sdate,
5097: l_the_edate
5098: from wsm_copy_op_resource_instances wcori
5099: where wcori.wip_entity_id = p_wip_entity_id
5100: and wcori.organization_id = p_org_id
5101: and wcori.operation_seq_num = l_rtg_op_seq_num
5102: and wcori.resource_seq_num = l_res_seq_num

Line 13119: delete from wsm_copy_op_resource_instances wcori

13115: and wcor.parent_resource_seq_num = p_par_res_seq_num
13116: and rownum = 1;
13117:
13118: IF l_setup_exists <> 0 THEN
13119: delete from wsm_copy_op_resource_instances wcori
13120: where wcori.organization_id = p_org_id
13121: and wcori.wip_entity_id = p_wip_entity_id
13122: and wcori.operation_seq_num = p_op_seq_num
13123: and wcori.resource_seq_num in (select resource_seq_num

Line 17023: delete from wsm_copy_op_resource_instances

17019: delete from wsm_copy_op_resources
17020: where wip_entity_id = p_wip_entity_id
17021: and operation_seq_num = l_rtg_op_seq_num;
17022:
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

Line 17276: delete from wsm_copy_op_resource_instances wcori

17272: and wcor.operation_seq_num = l_rtg_op_seq_num
17273: and wcor.resource_seq_num = l_resource_seq_num
17274: and wcor.organization_id = p_org_id;
17275:
17276: delete from wsm_copy_op_resource_instances wcori
17277: where wcori.wip_entity_id = p_wip_entity_id
17278: and wcori.operation_seq_num = l_rtg_op_seq_num
17279: and wcori.resource_seq_num = l_resource_seq_num
17280: and wcori.organization_id = p_org_id;

Line 18498: --delete WSM_COPY_OP_RESOURCE_INSTANCES

18494: -- from WSM_COPY_OP_RESOURCES
18495: -- where wip_entity_id = p_wip_entity_id
18496: -- and recommended <> 'Y' );
18497: l_stmt_num := 270.3;
18498: --delete WSM_COPY_OP_RESOURCE_INSTANCES
18499: --where wip_entity_id = p_wip_entity_id
18500: --and (operation_seq_num,
18501: -- resource_seq_num) in (
18502: -- select operation_seq_num,

Line 18766: delete from wsm_copy_op_resource_instances

18762: -- ST : Bug fix 4240165 : Detailed Scheduling changes end
18763:
18764: l_stmt_num := 320.4;
18765: -- delete all existing records for that resource_seq_num
18766: delete from wsm_copy_op_resource_instances
18767: where wip_entity_id = p_wip_entity_id
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;

Line 18804: insert into wsm_copy_op_resource_instances(

18800: -- creating WCORI records
18801: if(l_v_rtg_op_seq.first IS NOT NULL) then
18802: l_stmt_num := 330;
18803: forall i in l_v_rtg_op_seq.first..l_v_rtg_op_seq.last
18804: insert into wsm_copy_op_resource_instances(
18805: wip_entity_id ,
18806: organization_id,
18807: operation_seq_num,
18808: resource_seq_num,