APPS.WSM_LBJ_INTERFACE_PVT dependencies on WSM_COPY_OP_RESOURCE_INSTANCES

Line 4548: from wsm_copy_op_resource_instances

4544: BEGIN
4545: l_stmt_num := 20.1;
4546: select 1
4547: into l_exists
4548: from wsm_copy_op_resource_instances
4549: where wip_entity_id = p_wip_entity_id
4550: and organization_id = p_org_id
4551: and operation_seq_num = l_rtg_op_seq_num
4552: and resource_seq_num = l_res_seq_num;

Line 5068: from wsm_copy_op_resource_instances wcori

5064: BEGIN
5065: l_stmt_num := 30.3;
5066: select 1
5067: into l_exists
5068: from wsm_copy_op_resource_instances wcori
5069: where wcori.wip_entity_id = p_wip_entity_id
5070: and wcori.organization_id = p_org_id
5071: and wcori.operation_seq_num = l_rtg_op_seq_num
5072: and wcori.resource_seq_num = l_res_seq_num;

Line 5103: from wsm_copy_op_resource_instances wcori

5099: select wcori.start_date,
5100: wcori.completion_date
5101: into l_the_sdate,
5102: l_the_edate
5103: from wsm_copy_op_resource_instances wcori
5104: where wcori.wip_entity_id = p_wip_entity_id
5105: and wcori.organization_id = p_org_id
5106: and wcori.operation_seq_num = l_rtg_op_seq_num
5107: and wcori.resource_seq_num = l_res_seq_num

Line 13223: delete from wsm_copy_op_resource_instances wcori

13219: and wcor.parent_resource_seq_num = p_par_res_seq_num
13220: and rownum = 1;
13221:
13222: IF l_setup_exists <> 0 THEN
13223: delete from wsm_copy_op_resource_instances wcori
13224: where wcori.organization_id = p_org_id
13225: and wcori.wip_entity_id = p_wip_entity_id
13226: and wcori.operation_seq_num = p_op_seq_num
13227: and wcori.resource_seq_num in (select resource_seq_num

Line 17465: delete from wsm_copy_op_resource_instances

17461: delete from wsm_copy_op_resources
17462: where wip_entity_id = p_wip_entity_id
17463: and operation_seq_num = l_rtg_op_seq_num;
17464:
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

Line 17755: delete from wsm_copy_op_resource_instances wcori

17751: and wcor.operation_seq_num = l_rtg_op_seq_num
17752: and wcor.resource_seq_num = l_resource_seq_num
17753: and wcor.organization_id = p_org_id;
17754:
17755: delete from wsm_copy_op_resource_instances wcori
17756: where wcori.wip_entity_id = p_wip_entity_id
17757: and wcori.operation_seq_num = l_rtg_op_seq_num
17758: and wcori.resource_seq_num = l_resource_seq_num
17759: and wcori.organization_id = p_org_id;

Line 19075: --delete WSM_COPY_OP_RESOURCE_INSTANCES

19071: -- from WSM_COPY_OP_RESOURCES
19072: -- where wip_entity_id = p_wip_entity_id
19073: -- and recommended <> 'Y' );
19074: l_stmt_num := 270.3;
19075: --delete WSM_COPY_OP_RESOURCE_INSTANCES
19076: --where wip_entity_id = p_wip_entity_id
19077: --and (operation_seq_num,
19078: -- resource_seq_num) in (
19079: -- select operation_seq_num,

Line 19343: delete from wsm_copy_op_resource_instances

19339: -- ST : Bug fix 4240165 : Detailed Scheduling changes end
19340:
19341: l_stmt_num := 320.4;
19342: -- delete all existing records for that resource_seq_num
19343: delete from wsm_copy_op_resource_instances
19344: where wip_entity_id = p_wip_entity_id
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;

Line 19381: insert into wsm_copy_op_resource_instances(

19377: -- creating WCORI records
19378: if(l_v_rtg_op_seq.first IS NOT NULL) then
19379: l_stmt_num := 330;
19380: forall i in l_v_rtg_op_seq.first..l_v_rtg_op_seq.last
19381: insert into wsm_copy_op_resource_instances(
19382: wip_entity_id ,
19383: organization_id,
19384: operation_seq_num,
19385: resource_seq_num,