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 1980: delete wsm_copy_op_resource_usage

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

Line 1988: delete wsm_copy_op_resource_usage

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

Line 2000: insert into wsm_copy_op_resource_usage(

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

Line 2048: insert into wsm_copy_op_resource_usage(

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

Line 2095: insert into wsm_copy_op_resource_usage(

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

Line 2135: from wsm_copy_op_resource_usage wcoru,

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

Line 2152: insert into wsm_copy_op_resource_usage(

2148:
2149: --bug 6345672: begin
2150: l_stat_num := 205;
2151: if g_update_current_op and l_cnt_wor > 0 and l_cnt_wor is not NULL then --bug 6345672 -- bug 7248484
2152: insert into wsm_copy_op_resource_usage(
2153: wip_entity_id,
2154: operation_seq_num,
2155: resource_seq_num,
2156: organization_id,

Line 2192: from wsm_copy_op_resource_usage wcoru,

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