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_RESERVATIONS_PVT dependencies on WSM_RESERVATIONS_V

Line 7: type t_wsm_rsv_v_tbl_type is table of wsm_reservations_v%rowtype index by binary_integer;

3:
4: /* Package name */
5: g_pkg_name VARCHAR2(20) := 'WSM_RESERVATIONS_PVT';
6:
7: type t_wsm_rsv_v_tbl_type is table of wsm_reservations_v%rowtype index by binary_integer;
8: type t_wsm_reservations is table of wsm_reservations%rowtype index by binary_integer;
9: --type r_mtl_rsv_rec_type is record of mtl_reservations%rowtype;
10: --MP: Sale order changes
11: l_mtl_rsv_rec inv_reservation_global.mtl_maintain_rsv_rec_type;

Line 106: from wsm_reservations_v

102: --MP Delete Changes Start
103: BEGIN
104: select *
105: bulk collect into l_wsm_rsv_v_tbl
106: from wsm_reservations_v
107: where wip_entity_id = p_starting_jobs_tbl(p_rep_job_index).wip_entity_id;
108: EXCEPTION
109: when no_data_found then
110: return;

Line 183: from wsm_reservations_v

179: --MP Delete Changes Start
180: BEGIN
181: select *
182: bulk collect into l_wsm_rsv_v_tbl
183: from wsm_reservations_v
184: where wip_entity_id = p_starting_jobs_tbl(p_rep_job_index).wip_entity_id;
185: EXCEPTION
186: when no_data_found then
187: return;

Line 315: from wsm_reservations_v

311: --MP Delete Changes Start
312: BEGIN
313: select *
314: bulk collect into l_wsm_rsv_v_tbl
315: from wsm_reservations_v
316: where wip_entity_id = p_starting_jobs_tbl(p_rep_job_index).wip_entity_id;
317: EXCEPTION
318: when no_data_found then
319: return;

Line 395: from wsm_reservations_v

391: --collect the SO rsv for the SJ from wsm_rsv_v
392: BEGIN
393: select *
394: bulk collect into l_wsm_rsv_v_tbl
395: from wsm_reservations_v
396: where wip_entity_id = p_starting_jobs_tbl(l_counter).wip_entity_id;
397: EXCEPTION
398: when no_data_found then
399: null;

Line 403: --For each SO rsvn in wsm_reservations_v for p_starting_jobs_tbl (l_counter) loop

399: null;
400: END;
401:
402: if l_wsm_rsv_v_tbl.count>0 then
403: --For each SO rsvn in wsm_reservations_v for p_starting_jobs_tbl (l_counter) loop
404: For i in l_wsm_rsv_v_tbl.first .. l_wsm_rsv_v_tbl.last loop
405:
406: --old reservation info populated
407: l_rsv_old.reservation_id := l_wsm_rsv_v_tbl(i).reservation_id;

Line 485: from wsm_reservations_v

481: --MP Delete Changes Start
482: BEGIN
483: select *
484: bulk collect into l_wsm_rsv_v_tbl
485: from wsm_reservations_v
486: where wip_entity_id = p_starting_jobs_tbl(l_counter).wip_entity_id;
487: EXCEPTION
488: when no_data_found then
489: return;

Line 679: /have this call wherever wsm_reservations_v is used/

675: l_stmt_num := 10;
676: /* Initialize API return status to success */
677: x_return_status := FND_API.G_RET_STS_SUCCESS;
678:
679: /*have this call wherever wsm_reservations_v is used*/
680: --MO_GLOBAL.SET_POLICY_CONTEXT ('S', p_org_id);
681:
682: l_rsv_new.supply_source_header_id := p_wip_entity_id;
683: --l_rsv_new.inventory_item_id :=p_inventory_item_id;

Line 777: from wsm_reservations_v

773: reservation_id,
774: demand_source_header_id,
775: demand_source_line_id,
776: primary_quantity
777: from wsm_reservations_v
778: where wip_entity_id= p_wip_entity_id
779: and organization_id = p_org_id
780: and inventory_item_id = p_inventory_item_id
781: );

Line 1004: /have this call wherever wsm_reservations_v is used/

1000: l_stmt_num := 10;
1001: /* Initialize API return status to success */
1002: x_return_status := FND_API.G_RET_STS_SUCCESS;
1003:
1004: /*have this call wherever wsm_reservations_v is used*/
1005: --MO_GLOBAL.SET_POLICY_CONTEXT ('S', p_org_id);
1006:
1007: l_rsv.supply_source_header_id := p_wip_entity_id;
1008: l_rsv.inventory_item_id :=p_inventory_item_id;

Line 1296: /have this call wherever wsm_reservations_v is used/

1292: is
1293: L_rsvd_qty number :=0;
1294:
1295: BEGIN
1296: /*have this call wherever wsm_reservations_v is used*/
1297: --MO_GLOBAL.SET_POLICY_CONTEXT ('S', p_org_id);
1298: BEGIN
1299:
1300: -- modified the SQL to have primary quantity instead of reservation qty.

Line 1303: from wsm_reservations_v

1299:
1300: -- modified the SQL to have primary quantity instead of reservation qty.
1301: Select sum (primary_quantity)
1302: into l_rsvd_qty
1303: from wsm_reservations_v
1304: where wip_entity_id = p_wip_entity_id
1305: and organization_id = p_org_id
1306: and inventory_item_id = p_inventory_item_id;
1307: EXCEPTION

Line 1326: /have this call wherever wsm_reservations_v is used/

1322:
1323: l_rsv_exists number := 0 ;
1324:
1325: BEGIN
1326: /*have this call wherever wsm_reservations_v is used*/
1327: --MO_GLOBAL.SET_POLICY_CONTEXT ('S', p_org_id);
1328: BEGIN
1329: select 1 into l_rsv_exists
1330: from wsm_reservations_v

Line 1330: from wsm_reservations_v

1326: /*have this call wherever wsm_reservations_v is used*/
1327: --MO_GLOBAL.SET_POLICY_CONTEXT ('S', p_org_id);
1328: BEGIN
1329: select 1 into l_rsv_exists
1330: from wsm_reservations_v
1331: where wip_entity_id = p_wip_entity_id
1332: and organization_id = p_org_id
1333: and inventory_item_id = p_inventory_item_id
1334: and rownum = 1;