APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_OPERATION_RESOURCE_USAGE

Line 5006: from wip_operation_resource_usage

5002: BEGIN
5003: l_stmt_num := 20.2;
5004: select 1
5005: into l_exists
5006: from wip_operation_resource_usage
5007: where wip_entity_id = p_wip_entity_id
5008: and organization_id = p_org_id
5009: and operation_seq_num = l_job_op_seq_num
5010: and resource_seq_num = l_res_seq_num

Line 6203: from wip_operation_resource_usage

6199: p_resource_seq_num number) is
6200: select start_date,
6201: completion_date,
6202: cumulative_processing_time
6203: from wip_operation_resource_usage
6204: where wip_entity_id = p_wip_entity_id
6205: and operation_seq_num = p_operation_seq_num
6206: and resource_seq_num = p_resource_seq_num
6207: and NVL(instance_id, -1) = NVL(p_instance_id, -1)

Line 6237: update wip_operation_resource_usage

6233: loop
6234: current_cpt := current_cpt + wip_datetimes.datetime_diff_to_mins(
6235: wip_row.completion_date,
6236: wip_row.start_date);
6237: update wip_operation_resource_usage
6238: set cumulative_processing_time = current_cpt
6239: where current of wip_res_usage;
6240: end loop;
6241: else

Line 10403: delete from wip_operation_resource_usage

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

Line 13076: delete from wip_operation_resource_usage woru

13072:
13073: l_stmt_num := 60;
13074:
13075: /* delete the usage information .... */
13076: delete from wip_operation_resource_usage woru
13077: where woru.organization_id = p_org_id
13078: and woru.wip_entity_id = p_wip_entity_id
13079: and woru.operation_seq_num = p_op_seq_num
13080: and woru.resource_seq_num in (select resource_seq_num

Line 17200: delete from wip_operation_resource_usage woru

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;
17199:
17200: delete from wip_operation_resource_usage woru
17201: where woru.wip_entity_id = p_wip_entity_id
17202: and woru.operation_seq_num = l_job_op_seq_num
17203: and woru.resource_seq_num = l_resource_seq_num
17204: and woru.organization_id = p_org_id;

Line 17576: insert into wip_operation_resource_usage

17572:
17573: if l_v_res(l_resource_id).scheduled_flag <> WIP_CONSTANTS.SCHED_NO and
17574: l_v_res(l_resource_id).reco_flag = 'Y' then
17575:
17576: insert into wip_operation_resource_usage
17577: (wip_entity_id,
17578: operation_seq_num,
17579: resource_seq_num,
17580: organization_id,

Line 18631: delete from wip_operation_resource_usage

18627: and operation_seq_num = l_job_op_seq_num
18628: and resource_seq_num = l_res_seq_num;
18629:
18630: l_stmt_num := 310.5;
18631: delete from wip_operation_resource_usage
18632: where wip_entity_id = p_wip_entity_id
18633: and organization_id = p_org_id
18634: and operation_seq_num = l_job_op_seq_num
18635: and resource_seq_num = l_res_seq_num;

Line 19013: delete from wip_operation_resource_usage

19009: -- ST : Bug fix 4240165 : Detailed Scheduling changes end
19010:
19011: l_stmt_num := 410.4;
19012: -- delete all existing records for that resource_seq_num
19013: delete from wip_operation_resource_usage
19014: where wip_entity_id = p_wip_entity_id
19015: and organization_id = p_org_id
19016: and operation_seq_num = l_job_op_seq_num
19017: and resource_seq_num = l_res_seq_num

Line 19026: insert into wip_operation_resource_usage(

19022: l_in := l_v_res_use.first;
19023: while (l_in IS NOT NULL)
19024: loop
19025: l_stmt_num := 410.5;
19026: insert into wip_operation_resource_usage(
19027: wip_entity_id ,
19028: organization_id,
19029: operation_seq_num,
19030: resource_seq_num,