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 1871: delete wip_operation_resource_usage

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

Line 1880: insert into wip_operation_resource_usage (

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

Line 1925: insert into wip_operation_resource_usage(

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

Line 1965: from wip_operation_resource_usage woru,

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