APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_OP_RESOURCE_INSTANCES

Line 4560: from wip_op_resource_instances

4556: BEGIN
4557: l_stmt_num := 20.2;
4558: select 1
4559: into l_exists
4560: from wip_op_resource_instances
4561: where wip_entity_id = p_wip_entity_id
4562: and organization_id = p_org_id
4563: and operation_seq_num = l_job_op_seq_num
4564: and resource_seq_num = l_res_seq_num;

Line 5127: from wip_op_resource_instances wori

5123: BEGIN
5124: l_stmt_num := 40.1;
5125: select 1
5126: into l_exists
5127: from wip_op_resource_instances wori
5128: where wori.wip_entity_id = p_wip_entity_id
5129: and wori.organization_id = p_org_id
5130: and wori.operation_seq_num = l_job_op_seq_num /* l_rtg_op_seq_num : ST : This has to be job op seq num */
5131: and wori.resource_seq_num = l_res_seq_num;

Line 5161: from wip_op_resource_instances

5157: select start_date,
5158: completion_date
5159: into l_the_sdate,
5160: l_the_edate
5161: from wip_op_resource_instances
5162: where wip_entity_id = p_wip_entity_id
5163: and organization_id = p_org_id
5164: and operation_seq_num = l_job_op_seq_num
5165: and resource_seq_num = l_res_seq_num

Line 10405: delete from wip_op_resource_instances

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
10406: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10407: v_new_job := 2;
10408: end if;
10409: l_stmt_num := 820;

Line 13061: delete from wip_op_resource_instances wori

13057: if l_res_costed = 0 and l_setup_exists <> 0 then
13058:
13059: l_stmt_num := 55;
13060: /* delete the instance information ... */
13061: delete from wip_op_resource_instances wori
13062: where wori.organization_id = p_org_id
13063: and wori.wip_entity_id = p_wip_entity_id
13064: and wori.operation_seq_num = p_op_seq_num
13065: and wori.RESOURCE_SEQ_NUM in (select resource_seq_num

Line 17194: delete from wip_op_resource_instances wori

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;
17193:
17194: delete from wip_op_resource_instances wori
17195: where wori.wip_entity_id = p_wip_entity_id
17196: and wori.operation_seq_num = l_job_op_seq_num
17197: and wori.resource_seq_num = l_resource_seq_num
17198: and wori.organization_id = p_org_id;

Line 18624: delete from wip_op_resource_instances

18620:
18621: l_stmt_num := 310.4;
18622: -- delete all existing records for that resource_seq_num
18623: -- CZHDBG: do we need to check if resource is charged ???
18624: delete from wip_op_resource_instances
18625: where wip_entity_id = p_wip_entity_id
18626: and organization_id = p_org_id
18627: and operation_seq_num = l_job_op_seq_num
18628: and resource_seq_num = l_res_seq_num;

Line 18643: insert into wip_op_resource_instances(

18639:
18640: while (l_in IS NOT NULL)
18641: loop
18642: l_stmt_num := 310.6;
18643: insert into wip_op_resource_instances(
18644: wip_entity_id ,
18645: organization_id,
18646: operation_seq_num,
18647: resource_seq_num,