APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_SUB_OPERATION_RESOURCES

Line 1869: from wip_sub_operation_resources wsor

1865: if l_xst =1 then
1866: begin
1867: select resource_id
1868: into v_wljdi_resource_id_new(l_d)
1869: from wip_sub_operation_resources wsor
1870: where wsor.wip_entity_id = p_wip_entity_id
1871: and wsor.operation_seq_num = l_job_op_seq_num
1872: and wsor.resource_seq_num = v_wljdi_resource_seq_num(l_d);
1873: exception

Line 3212: from wip_sub_operation_resources

3208: and NVL(replacement_group_num, 0) = NVL(l_rpl_grp_num, 0)
3209: and parent_resource_seq IS NULL -- -- ST : Detailed Scheduling.. Consider only the runtime resources
3210: union
3211: select resource_id
3212: from wip_sub_operation_resources
3213: where wip_entity_id = p_wip_entity_id
3214: and operation_seq_num = l_job_op_seq_num
3215: and NVL(substitute_group_num, -1) = NVL(l_sub_grp_num, -1)
3216: and NVL(replacement_group_num, 0) = NVL(l_rpl_grp_num, 0);

Line 3285: from wip_sub_operation_resources wsor

3281: and NVL(wor.substitute_group_num, -1) = NVL(l_sub_grp_num, -1)
3282: and NVL(wor.replacement_group_num, 0) = NVL(l_rpl_grp_num, 0)
3283: ) or exists (
3284: select resource_id
3285: from wip_sub_operation_resources wsor
3286: where wsor.wip_entity_id = p_wip_entity_id
3287: and wsor.operation_seq_num = l_job_op_seq_num
3288: and wsor.resource_id = l_resource_id
3289: and NVL(wsor.substitute_group_num, -1) = NVL(l_sub_grp_num, -1)

Line 3702: from wip_sub_operation_resources wsor

3698:
3699: if (l_xst=0) then
3700: select 1,applied_resource_units
3701: into l_xst,l_app_res_units
3702: from wip_sub_operation_resources wsor
3703: where wsor.wip_entity_id = p_wip_entity_id
3704: and wsor.operation_seq_num = l_job_op_seq_num
3705: and wsor.resource_seq_num = l_res_seq_num;
3706: end if;

Line 3969: wip_sub_operation_resources wsor

3965: if l_res_seq_num is null then
3966: select greatest(nvl(max(wor.resource_seq_num),0),nvl(max(wsor.resource_seq_num),0))+10
3967: into l_res_seq_num
3968: from wip_operation_resources wor,
3969: wip_sub_operation_resources wsor
3970: where wor.organization_id = p_org_id
3971: and wor.wip_entity_id = p_wip_entity_id
3972: and wor.operation_seq_num = l_job_op_seq_num
3973: and wor.organization_id = wsor.organization_id

Line 4004: from wip_sub_operation_resources wsor

4000: select 'N'
4001: into p_v_res(l_i).reco_flag
4002: from dual
4003: where exists( select 1
4004: from wip_sub_operation_resources wsor
4005: where wsor.organization_id = p_org_id
4006: and wsor.wip_entity_id = p_wip_entity_id
4007: and wsor.operation_seq_num = l_job_op_seq_num
4008: and nvl(wsor.substitute_group_num,-1) = nvl(p_v_res(l_i).sub_grp_num,-1)

Line 10499: delete from wip_sub_operation_resources

10495: delete from wip_operation_resources
10496: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10497: delete from wip_requirement_operations
10498: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10499: delete from wip_sub_operation_resources
10500: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10501: delete from wip_operation_resource_usage
10502: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10503: delete from wip_op_resource_instances

Line 13468: from wip_sub_operation_resources wsor

13464: l_stmt_num := 75;
13465: begin
13466: select max(resource_seq_num)
13467: into l_res_num2
13468: from wip_sub_operation_resources wsor
13469: where wsor.organization_id = p_org_id
13470: and wsor.wip_entity_id = p_wip_entity_id
13471: and wsor.operation_seq_num = p_job_op_seq_num;
13472:

Line 13759: from wip_sub_operation_resources wsor

13755:
13756: begin
13757: select 1
13758: into l_dummy
13759: from wip_sub_operation_resources wsor
13760: where wsor.organization_id = p_org_id
13761: and wsor.wip_entity_id = p_wip_entity_id
13762: and wsor.operation_seq_num = p_job_op_seq_num
13763: and wsor.resource_seq_num = p_new_res_tbl(l_index).res_seq_num;

Line 17667: delete from wip_sub_operation_resources wsor

17663: and wor.operation_seq_num = l_job_op_seq_num
17664: and wor.resource_seq_num = l_resource_seq_num
17665: and wor.organization_id = p_org_id;
17666:
17667: delete from wip_sub_operation_resources wsor
17668: where wsor.wip_entity_id = p_wip_entity_id
17669: and wsor.operation_seq_num = l_job_op_seq_num
17670: and wsor.resource_seq_num = l_resource_seq_num
17671: and wsor.organization_id = p_org_id;

Line 17951: insert into wip_sub_operation_resources

17947: g_num_of_osp_exists := nvl(g_num_of_osp_exists,0) + 1;
17948:
17949: end if;
17950: ELSE
17951: insert into wip_sub_operation_resources
17952: (wip_entity_id,
17953: operation_seq_num,
17954: resource_seq_num,
17955: organization_id,

Line 18616: UPDATE WIP_SUB_OPERATION_RESOURCES

18612: l_resource_id := l_v_res.first;
18613: while(l_resource_id IS NOT NULL) -- bug 3736602 added loop
18614: loop
18615:
18616: UPDATE WIP_SUB_OPERATION_RESOURCES
18617: set start_date = NVL(l_v_res(l_resource_id).start_date,
18618: start_date),
18619: completion_date = NVL(l_v_res(l_resource_id).completion_date,
18620: completion_date),