APPS.WSM_INFINITE_SCHEDULER_PVT dependencies on WIP_OPERATION_RESOURCE_USAGE

Line 625: from wip_operation_resource_usage

621: for update nowait;
622:
623: cursor c_WORU is
624: select 1
625: from wip_operation_resource_usage
626: where wip_entity_id = p_wipEntityID
627: and organization_id = p_orgID
628: for update nowait;
629:

Line 1868: delete wip_operation_resource_usage

1864:
1865: l_stat_num := 150;
1866: --update resources usage (WORU)
1867: forall i in 1..l_cnt_wor
1868: delete wip_operation_resource_usage
1869: where wip_entity_id = p_wipEntityID
1870: and operation_seq_num = -x_resTbls.opSeqNum(i)
1871: and resource_seq_num = x_resTbls.resSeqNum(i);
1872:

Line 1877: insert into wip_operation_resource_usage (

1873: l_stat_num := 160;
1874: for i in 1..l_cnt_wor loop
1875: if(x_resTbls.usgStartIdx(i) is not null) then
1876: forall j in x_resTbls.usgStartIdx(i)..x_resTbls.usgEndIdx(i)
1877: insert into wip_operation_resource_usage (
1878: wip_entity_id,
1879: operation_seq_num,
1880: resource_seq_num,
1881: organization_id,

Line 1922: insert into wip_operation_resource_usage(

1918: end if;
1919:
1920: l_stat_num := 170;
1921: forall i in 1..l_cnt_wor
1922: insert into wip_operation_resource_usage(
1923: wip_entity_id,
1924: operation_seq_num,
1925: resource_seq_num,
1926: organization_id,

Line 1962: from wip_operation_resource_usage woru,

1958: l_reqID,
1959: l_progApplID,
1960: l_progID,
1961: l_sysdate
1962: from wip_operation_resource_usage woru,
1963: wip_op_resource_instances wori
1964: where woru.wip_entity_id = wori.wip_entity_id
1965: and woru.operation_seq_num = wori.operation_seq_num
1966: and woru.resource_seq_num = wori.resource_seq_num