APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_SUB_OPERATION_RESOURCES

Line 1864: from wip_sub_operation_resources wsor

1860: if l_xst =1 then
1861: begin
1862: select resource_id
1863: into v_wljdi_resource_id_new(l_d)
1864: from wip_sub_operation_resources wsor
1865: where wsor.wip_entity_id = p_wip_entity_id
1866: and wsor.operation_seq_num = l_job_op_seq_num
1867: and wsor.resource_seq_num = v_wljdi_resource_seq_num(l_d);
1868: exception

Line 3207: from wip_sub_operation_resources

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

Line 3280: from wip_sub_operation_resources wsor

3276: and NVL(wor.substitute_group_num, -1) = NVL(l_sub_grp_num, -1)
3277: and NVL(wor.replacement_group_num, 0) = NVL(l_rpl_grp_num, 0)
3278: ) or exists (
3279: select resource_id
3280: from wip_sub_operation_resources wsor
3281: where wsor.wip_entity_id = p_wip_entity_id
3282: and wsor.operation_seq_num = l_job_op_seq_num
3283: and wsor.resource_id = l_resource_id
3284: and NVL(wsor.substitute_group_num, -1) = NVL(l_sub_grp_num, -1)

Line 3697: from wip_sub_operation_resources wsor

3693:
3694: if (l_xst=0) then
3695: select 1,applied_resource_units
3696: into l_xst,l_app_res_units
3697: from wip_sub_operation_resources wsor
3698: where wsor.wip_entity_id = p_wip_entity_id
3699: and wsor.operation_seq_num = l_job_op_seq_num
3700: and wsor.resource_seq_num = l_res_seq_num;
3701: end if;

Line 3964: wip_sub_operation_resources wsor

3960: if l_res_seq_num is null then
3961: select greatest(nvl(max(wor.resource_seq_num),0),nvl(max(wsor.resource_seq_num),0))+10
3962: into l_res_seq_num
3963: from wip_operation_resources wor,
3964: wip_sub_operation_resources wsor
3965: where wor.organization_id = p_org_id
3966: and wor.wip_entity_id = p_wip_entity_id
3967: and wor.operation_seq_num = l_job_op_seq_num
3968: and wor.organization_id = wsor.organization_id

Line 3999: from wip_sub_operation_resources wsor

3995: select 'N'
3996: into p_v_res(l_i).reco_flag
3997: from dual
3998: where exists( select 1
3999: from wip_sub_operation_resources wsor
4000: where wsor.organization_id = p_org_id
4001: and wsor.wip_entity_id = p_wip_entity_id
4002: and wsor.operation_seq_num = l_job_op_seq_num
4003: and nvl(wsor.substitute_group_num,-1) = nvl(p_v_res(l_i).sub_grp_num,-1)

Line 10401: delete from wip_sub_operation_resources

10397: delete from wip_operation_resources
10398: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10399: delete from wip_requirement_operations
10400: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10401: delete from wip_sub_operation_resources
10402: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10403: delete from wip_operation_resource_usage
10404: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10405: delete from wip_op_resource_instances

Line 13364: from wip_sub_operation_resources wsor

13360: l_stmt_num := 75;
13361: begin
13362: select max(resource_seq_num)
13363: into l_res_num2
13364: from wip_sub_operation_resources wsor
13365: where wsor.organization_id = p_org_id
13366: and wsor.wip_entity_id = p_wip_entity_id
13367: and wsor.operation_seq_num = p_job_op_seq_num;
13368:

Line 13655: from wip_sub_operation_resources wsor

13651:
13652: begin
13653: select 1
13654: into l_dummy
13655: from wip_sub_operation_resources wsor
13656: where wsor.organization_id = p_org_id
13657: and wsor.wip_entity_id = p_wip_entity_id
13658: and wsor.operation_seq_num = p_job_op_seq_num
13659: and wsor.resource_seq_num = p_new_res_tbl(l_index).res_seq_num;

Line 17188: delete from wip_sub_operation_resources wsor

17184: and wor.operation_seq_num = l_job_op_seq_num
17185: and wor.resource_seq_num = l_resource_seq_num
17186: and wor.organization_id = p_org_id;
17187:
17188: delete from wip_sub_operation_resources wsor
17189: where wsor.wip_entity_id = p_wip_entity_id
17190: and wsor.operation_seq_num = l_job_op_seq_num
17191: and wsor.resource_seq_num = l_resource_seq_num
17192: and wsor.organization_id = p_org_id;

Line 17472: insert into wip_sub_operation_resources

17468: g_num_of_osp_exists := nvl(g_num_of_osp_exists,0) + 1;
17469:
17470: end if;
17471: ELSE
17472: insert into wip_sub_operation_resources
17473: (wip_entity_id,
17474: operation_seq_num,
17475: resource_seq_num,
17476: organization_id,

Line 18121: UPDATE WIP_SUB_OPERATION_RESOURCES

18117: l_resource_id := l_v_res.first;
18118: while(l_resource_id IS NOT NULL) -- bug 3736602 added loop
18119: loop
18120:
18121: UPDATE WIP_SUB_OPERATION_RESOURCES
18122: set start_date = NVL(l_v_res(l_resource_id).start_date,
18123: start_date),
18124: completion_date = NVL(l_v_res(l_resource_id).completion_date,
18125: completion_date),