eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSM_INFINITE_SCHEDULER_PVT dependencies on WSM_COPY_OP_RESOURCE_USAGE

Line 660: from wsm_copy_op_resource_usage

656: for update nowait;
657:
658: cursor c_WCORU is
659: select 1
660: from wsm_copy_op_resource_usage
661: where wip_entity_id = p_wipEntityID
662: and organization_id = p_orgID
663: for update nowait;
664:

Line 1983: delete wsm_copy_op_resource_usage

1979:
1980: l_stat_num := 180;
1981: --update resources usage (WCORU)
1982: forall i in l_cnt_wor+1..x_resTbls.resID.count
1983: delete wsm_copy_op_resource_usage
1984: where wip_entity_id = p_wipEntityID
1985: and operation_seq_num = x_resTbls.opSeqNum(i)
1986: and resource_seq_num = x_resTbls.resSeqNum(i);
1987:

Line 1991: delete wsm_copy_op_resource_usage

1987:
1988: --bug 6345672: begin
1989: l_stat_num := 185;
1990: if g_update_current_op and l_cnt_wor > 0 and l_cnt_wor is not NULL then --bug 6345672/bug 7163667
1991: delete wsm_copy_op_resource_usage
1992: where wip_entity_id = p_wipEntityID
1993: and operation_seq_num = -x_resTbls.opSeqNum(l_cnt_wor)
1994: and resource_seq_num = x_resTbls.resSeqNum(l_cnt_wor);
1995: end if;

Line 2003: insert into wsm_copy_op_resource_usage(

1999: l_stat_num := 190;
2000: for i in l_cnt_wor+1..x_resTbls.resID.count loop
2001: if(x_resTbls.usgStartIdx(i) is not null) then
2002: forall j in x_resTbls.usgStartIdx(i)..x_resTbls.usgEndIdx(i)
2003: insert into wsm_copy_op_resource_usage(
2004: wip_entity_id,
2005: operation_seq_num,
2006: resource_seq_num,
2007: organization_id,

Line 2051: insert into wsm_copy_op_resource_usage(

2047: l_stat_num := 195;
2048: if g_update_current_op and l_cnt_wor > 0 and l_cnt_wor is not NULL then --bug 6345672/bug 7163667
2049: if(x_resTbls.usgStartIdx(l_cnt_wor) is not null) then
2050: forall j in x_resTbls.usgStartIdx(l_cnt_wor)..x_resTbls.usgEndIdx(l_cnt_wor)
2051: insert into wsm_copy_op_resource_usage(
2052: wip_entity_id,
2053: operation_seq_num,
2054: resource_seq_num,
2055: organization_id,

Line 2098: insert into wsm_copy_op_resource_usage(

2094: --bug 6345672: end
2095:
2096: l_stat_num := 200;
2097: forall i in l_cnt_wor+1..x_resTbls.resID.count
2098: insert into wsm_copy_op_resource_usage(
2099: wip_entity_id,
2100: operation_seq_num,
2101: resource_seq_num,
2102: organization_id,

Line 2138: from wsm_copy_op_resource_usage wcoru,

2134: l_reqID,
2135: l_progApplID,
2136: l_progID,
2137: l_sysdate
2138: from wsm_copy_op_resource_usage wcoru,
2139: wsm_copy_op_resource_instances wcori
2140: where wcoru.wip_entity_id = wcori.wip_entity_id
2141: and wcoru.operation_seq_num = wcori.operation_seq_num
2142: and wcoru.resource_seq_num = wcori.resource_seq_num

Line 2155: insert into wsm_copy_op_resource_usage(

2151:
2152: --bug 6345672: begin
2153: l_stat_num := 205;
2154: if g_update_current_op and l_cnt_wor > 0 and l_cnt_wor is not NULL then --bug 6345672/bug 7163667
2155: insert into wsm_copy_op_resource_usage(
2156: wip_entity_id,
2157: operation_seq_num,
2158: resource_seq_num,
2159: organization_id,

Line 2195: from wsm_copy_op_resource_usage wcoru,

2191: l_reqID,
2192: l_progApplID,
2193: l_progID,
2194: l_sysdate
2195: from wsm_copy_op_resource_usage wcoru,
2196: wsm_copy_op_resource_instances wcori
2197: where wcoru.wip_entity_id = wcori.wip_entity_id
2198: and wcoru.operation_seq_num = wcori.operation_seq_num
2199: and wcoru.resource_seq_num = wcori.resource_seq_num