APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_OPERATION_RESOURCE_USAGE

Line 5011: from wip_operation_resource_usage

5007: BEGIN
5008: l_stmt_num := 20.2;
5009: select 1
5010: into l_exists
5011: from wip_operation_resource_usage
5012: where wip_entity_id = p_wip_entity_id
5013: and organization_id = p_org_id
5014: and operation_seq_num = l_job_op_seq_num
5015: and resource_seq_num = l_res_seq_num

Line 6219: from wip_operation_resource_usage

6215: p_resource_seq_num number) is
6216: select start_date,
6217: completion_date,
6218: cumulative_processing_time
6219: from wip_operation_resource_usage
6220: where wip_entity_id = p_wip_entity_id
6221: and operation_seq_num = p_operation_seq_num
6222: and resource_seq_num = p_resource_seq_num
6223: and NVL(instance_id, -1) = NVL(p_instance_id, -1)

Line 6253: update wip_operation_resource_usage

6249: loop
6250: current_cpt := current_cpt + wip_datetimes.datetime_diff_to_mins(
6251: wip_row.completion_date,
6252: wip_row.start_date);
6253: update wip_operation_resource_usage
6254: set cumulative_processing_time = current_cpt
6255: where current of wip_res_usage;
6256: end loop;
6257: else

Line 10501: delete from wip_operation_resource_usage

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
10504: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10505: v_new_job := 2;

Line 13180: delete from wip_operation_resource_usage woru

13176:
13177: l_stmt_num := 60;
13178:
13179: /* delete the usage information .... */
13180: delete from wip_operation_resource_usage woru
13181: where woru.organization_id = p_org_id
13182: and woru.wip_entity_id = p_wip_entity_id
13183: and woru.operation_seq_num = p_op_seq_num
13184: and woru.resource_seq_num in (select resource_seq_num

Line 17679: delete from wip_operation_resource_usage woru

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;
17678:
17679: delete from wip_operation_resource_usage woru
17680: where woru.wip_entity_id = p_wip_entity_id
17681: and woru.operation_seq_num = l_job_op_seq_num
17682: and woru.resource_seq_num = l_resource_seq_num
17683: and woru.organization_id = p_org_id;

Line 18055: insert into wip_operation_resource_usage

18051:
18052: if l_v_res(l_resource_id).scheduled_flag <> WIP_CONSTANTS.SCHED_NO and
18053: l_v_res(l_resource_id).reco_flag = 'Y' then
18054:
18055: insert into wip_operation_resource_usage
18056: (wip_entity_id,
18057: operation_seq_num,
18058: resource_seq_num,
18059: organization_id,

Line 19208: delete from wip_operation_resource_usage

19204: and operation_seq_num = l_job_op_seq_num
19205: and resource_seq_num = l_res_seq_num;
19206:
19207: l_stmt_num := 310.5;
19208: delete from wip_operation_resource_usage
19209: where wip_entity_id = p_wip_entity_id
19210: and organization_id = p_org_id
19211: and operation_seq_num = l_job_op_seq_num
19212: and resource_seq_num = l_res_seq_num;

Line 19590: delete from wip_operation_resource_usage

19586: -- ST : Bug fix 4240165 : Detailed Scheduling changes end
19587:
19588: l_stmt_num := 410.4;
19589: -- delete all existing records for that resource_seq_num
19590: delete from wip_operation_resource_usage
19591: where wip_entity_id = p_wip_entity_id
19592: and organization_id = p_org_id
19593: and operation_seq_num = l_job_op_seq_num
19594: and resource_seq_num = l_res_seq_num

Line 19603: insert into wip_operation_resource_usage(

19599: l_in := l_v_res_use.first;
19600: while (l_in IS NOT NULL)
19601: loop
19602: l_stmt_num := 410.5;
19603: insert into wip_operation_resource_usage(
19604: wip_entity_id ,
19605: organization_id,
19606: operation_seq_num,
19607: resource_seq_num,