APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_OP_RESOURCE_INSTANCES

Line 4565: from wip_op_resource_instances

4561: BEGIN
4562: l_stmt_num := 20.2;
4563: select 1
4564: into l_exists
4565: from wip_op_resource_instances
4566: where wip_entity_id = p_wip_entity_id
4567: and organization_id = p_org_id
4568: and operation_seq_num = l_job_op_seq_num
4569: and resource_seq_num = l_res_seq_num;

Line 5132: from wip_op_resource_instances wori

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

Line 5166: from wip_op_resource_instances

5162: select start_date,
5163: completion_date
5164: into l_the_sdate,
5165: l_the_edate
5166: from wip_op_resource_instances
5167: where wip_entity_id = p_wip_entity_id
5168: and organization_id = p_org_id
5169: and operation_seq_num = l_job_op_seq_num
5170: and resource_seq_num = l_res_seq_num

Line 10503: delete from wip_op_resource_instances

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
10504: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10505: v_new_job := 2;
10506: end if;
10507: l_stmt_num := 820;

Line 13165: delete from wip_op_resource_instances wori

13161: if l_res_costed = 0 and l_setup_exists <> 0 then
13162:
13163: l_stmt_num := 55;
13164: /* delete the instance information ... */
13165: delete from wip_op_resource_instances wori
13166: where wori.organization_id = p_org_id
13167: and wori.wip_entity_id = p_wip_entity_id
13168: and wori.operation_seq_num = p_op_seq_num
13169: and wori.RESOURCE_SEQ_NUM in (select resource_seq_num

Line 17673: delete from wip_op_resource_instances wori

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;
17672:
17673: delete from wip_op_resource_instances wori
17674: where wori.wip_entity_id = p_wip_entity_id
17675: and wori.operation_seq_num = l_job_op_seq_num
17676: and wori.resource_seq_num = l_resource_seq_num
17677: and wori.organization_id = p_org_id;

Line 19201: delete from wip_op_resource_instances

19197:
19198: l_stmt_num := 310.4;
19199: -- delete all existing records for that resource_seq_num
19200: -- CZHDBG: do we need to check if resource is charged ???
19201: delete from wip_op_resource_instances
19202: where wip_entity_id = p_wip_entity_id
19203: and organization_id = p_org_id
19204: and operation_seq_num = l_job_op_seq_num
19205: and resource_seq_num = l_res_seq_num;

Line 19220: insert into wip_op_resource_instances(

19216:
19217: while (l_in IS NOT NULL)
19218: loop
19219: l_stmt_num := 310.6;
19220: insert into wip_op_resource_instances(
19221: wip_entity_id ,
19222: organization_id,
19223: operation_seq_num,
19224: resource_seq_num,