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.GML_BATCH_OM_RES_PVT dependencies on GML_BATCH_OM_UTIL

Line 40: , x_res_rec OUT NOCOPY GML_BATCH_OM_UTIL.gme_om_reservation_rec

36: );
37: PROCEDURE build_res_rec
38: (
39: p_res_row IN gml_batch_so_reservations%rowtype
40: , x_res_rec OUT NOCOPY GML_BATCH_OM_UTIL.gme_om_reservation_rec
41: ) ;
42: PROCEDURE PRINT_DEBUG
43: (
44: p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec

Line 57: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec;

53: , X_msg_cont OUT NOCOPY NUMBER
54: , X_msg_data OUT NOCOPY VARCHAR2
55: ) IS
56:
57: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec;
58: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec;
59: l_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec;
60: l_reservation_rec GML_BATCH_OM_UTIL.gme_om_reservation_rec;
61: l_batch_line_id NUMBER;

Line 58: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec;

54: , X_msg_data OUT NOCOPY VARCHAR2
55: ) IS
56:
57: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec;
58: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec;
59: l_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec;
60: l_reservation_rec GML_BATCH_OM_UTIL.gme_om_reservation_rec;
61: l_batch_line_id NUMBER;
62: l_fpo_batch_line_id NUMBER;

Line 59: l_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec;

55: ) IS
56:
57: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec;
58: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec;
59: l_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec;
60: l_reservation_rec GML_BATCH_OM_UTIL.gme_om_reservation_rec;
61: l_batch_line_id NUMBER;
62: l_fpo_batch_line_id NUMBER;
63: l_whse_code VARCHAR2(5);

Line 60: l_reservation_rec GML_BATCH_OM_UTIL.gme_om_reservation_rec;

56:
57: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec;
58: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec;
59: l_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec;
60: l_reservation_rec GML_BATCH_OM_UTIL.gme_om_reservation_rec;
61: l_batch_line_id NUMBER;
62: l_fpo_batch_line_id NUMBER;
63: l_whse_code VARCHAR2(5);
64: l_planned_qty NUMBER;

Line 142: IF NOT GML_BATCH_OM_UTIL.check_reservation

138: l_fpo_batch_line_id := batch_line.material_detail_id ;
139: l_item_id := batch_line.item_id ;
140: GMI_reservation_Util.PrintLn(' FPO batch_line_id '||l_fpo_batch_line_id);
141: /* check reservation exist or not */
142: IF NOT GML_BATCH_OM_UTIL.check_reservation
143: (
144: P_Batch_line_id => l_fpo_batch_line_id
145: , X_return_status => x_return_status
146: , X_msg_cont => x_msg_cont

Line 166: GML_BATCH_OM_UTIL.get_rule

162: l_so_line_rec.whse_code := each_whse.whse_code;
163: l_batch_line_rec.batch_line_id := l_fpo_batch_line_id;
164: GMI_reservation_Util.PrintLn(' reservation whse '||l_whse_code);
165:
166: GML_BATCH_OM_UTIL.get_rule
167: (
168: P_so_line_rec => l_so_line_rec
169: , P_batch_line_rec => l_batch_line_rec
170: , X_gme_om_rule_rec => l_rule_rec

Line 233: GML_BATCH_OM_UTIL.insert_reservation

229: l_reservation_rec.reserved_qty := l_reserved_qty;
230: l_reservation_rec.reserved_qty2 := l_reserved_qty2;
231: GMI_reservation_Util.PrintLn(' new reserved qty '||l_reserved_qty);
232:
233: GML_BATCH_OM_UTIL.insert_reservation
234: (
235: P_Gme_om_reservation_rec => l_reservation_rec
236: , X_return_status => x_return_status
237: , X_msg_cont => x_msg_cont

Line 279: P_batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec

275: END create_reservation_from_FPO;
276:
277: PROCEDURE create_allocations
278: (
279: P_batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec
280: , P_gme_om_rule_rec IN GML_BATCH_OM_UTIL.gme_om_rule_rec
281: , P_Gme_trans_row IN ic_tran_pnd%rowtype
282: , X_return_status OUT NOCOPY VARCHAR2
283: , X_msg_cont OUT NOCOPY NUMBER

Line 280: , P_gme_om_rule_rec IN GML_BATCH_OM_UTIL.gme_om_rule_rec

276:
277: PROCEDURE create_allocations
278: (
279: P_batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec
280: , P_gme_om_rule_rec IN GML_BATCH_OM_UTIL.gme_om_rule_rec
281: , P_Gme_trans_row IN ic_tran_pnd%rowtype
282: , X_return_status OUT NOCOPY VARCHAR2
283: , X_msg_cont OUT NOCOPY NUMBER
284: , X_msg_data OUT NOCOPY VARCHAR2

Line 287: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec;

283: , X_msg_cont OUT NOCOPY NUMBER
284: , X_msg_data OUT NOCOPY VARCHAR2
285: ) IS
286:
287: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec;
288: l_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec;
289: l_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;
290: l_gme_trans_row ic_tran_pnd%rowtype;
291: l_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

Line 288: l_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec;

284: , X_msg_data OUT NOCOPY VARCHAR2
285: ) IS
286:
287: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec;
288: l_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec;
289: l_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;
290: l_gme_trans_row ic_tran_pnd%rowtype;
291: l_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
292: l_dft_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

Line 289: l_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;

285: ) IS
286:
287: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec;
288: l_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec;
289: l_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;
290: l_gme_trans_row ic_tran_pnd%rowtype;
291: l_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
292: l_dft_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
293: l_tran_row IC_TRAN_PND%ROWTYPE;

Line 377: GML_BATCH_OM_UTIL.get_rule

373: GMI_RESERVATION_UTIL.println(' Production whse code is '|| l_prod_whse);
374:
375: IF l_rule_rec.rule_id is null THEN
376: l_so_line_rec.whse_code := p_gme_trans_row.whse_code;
377: GML_BATCH_OM_UTIL.get_rule
378: (
379: P_so_line_rec => l_so_line_rec
380: , P_batch_line_rec => p_batch_line_rec
381: , X_gme_om_rule_rec => l_rule_rec

Line 605: GML_BATCH_OM_UTIL.insert_alloc_history

601: And batch_trans_id = l_gme_trans_row.trans_id
602: And failure_reason is not null;
603: END IF;
604: /* insert history record */
605: GML_BATCH_OM_UTIL.insert_alloc_history
606: (
607: P_alloc_history_rec => l_history_rec
608: , X_return_status => x_return_status
609: , X_msg_cont => x_msg_cont

Line 1356: P_alloc_history_rec IN GML_BATCH_OM_UTIL.alloc_history_rec

1352: END notify_CSR;
1353:
1354: PROCEDURE regenerate_alloc
1355: (
1356: P_alloc_history_rec IN GML_BATCH_OM_UTIL.alloc_history_rec
1357: , x_return_status OUT NOCOPY VARCHAR2
1358: ) IS
1359: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec ;
1360: l_gme_om_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec;

Line 1359: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec ;

1355: (
1356: P_alloc_history_rec IN GML_BATCH_OM_UTIL.alloc_history_rec
1357: , x_return_status OUT NOCOPY VARCHAR2
1358: ) IS
1359: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec ;
1360: l_gme_om_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec;
1361: l_Gme_trans_row ic_tran_pnd%rowtype;
1362: l_omso_trans_id NUMBER;
1363: l_msg_cont NUMBER;

Line 1360: l_gme_om_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec;

1356: P_alloc_history_rec IN GML_BATCH_OM_UTIL.alloc_history_rec
1357: , x_return_status OUT NOCOPY VARCHAR2
1358: ) IS
1359: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec ;
1360: l_gme_om_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec;
1361: l_Gme_trans_row ic_tran_pnd%rowtype;
1362: l_omso_trans_id NUMBER;
1363: l_msg_cont NUMBER;
1364: l_msg_data VARCHAR2(300);

Line 1429: , P_batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec

1425:
1426: PROCEDURE process_om_reservations
1427: (
1428: p_from_batch_id IN NUMBER default null
1429: , P_batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec
1430: , P_Gme_trans_row IN ic_tran_pnd%rowtype
1431: , P_batch_action IN VARCHAR2
1432: , x_return_status OUT NOCOPY VARCHAR2
1433: ) IS

Line 1456: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec;

1452: ) IS
1453: l_fulfilled_qty NUMBER;
1454: l_qty_to_fulfil NUMBER;
1455: l_qty2_to_fulfil NUMBER;
1456: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec;
1457: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec;
1458: l_reservation_rec GML_BATCH_OM_UTIL.gme_om_reservation_rec;
1459:
1460: cursor c_reservations IS

Line 1457: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec;

1453: l_fulfilled_qty NUMBER;
1454: l_qty_to_fulfil NUMBER;
1455: l_qty2_to_fulfil NUMBER;
1456: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec;
1457: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec;
1458: l_reservation_rec GML_BATCH_OM_UTIL.gme_om_reservation_rec;
1459:
1460: cursor c_reservations IS
1461: SELECT reserved_qty

Line 1458: l_reservation_rec GML_BATCH_OM_UTIL.gme_om_reservation_rec;

1454: l_qty_to_fulfil NUMBER;
1455: l_qty2_to_fulfil NUMBER;
1456: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec;
1457: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec;
1458: l_reservation_rec GML_BATCH_OM_UTIL.gme_om_reservation_rec;
1459:
1460: cursor c_reservations IS
1461: SELECT reserved_qty
1462: , reserved_qty2

Line 1488: IF NOT GML_BATCH_OM_UTIL.check_reservation

1484: x_return_status := FND_API.G_RET_STS_SUCCESS;
1485: GMI_reservation_Util.PrintLn('Split Reservations for GME');
1486: /* check the reservations, if non exists, exit */
1487: IF p_old_source_line_id is not null THEN
1488: IF NOT GML_BATCH_OM_UTIL.check_reservation
1489: (
1490: P_so_line_id => p_old_source_line_id
1491: , X_return_status => x_return_status
1492: , X_msg_cont => x_msg_count

Line 1501: IF NOT GML_BATCH_OM_UTIL.check_reservation

1497: return;
1498: END IF;
1499: END IF;
1500: IF p_old_delivery_detail_id is not null THEN
1501: IF NOT GML_BATCH_OM_UTIL.check_reservation
1502: (
1503: P_delivery_detail_id => p_old_delivery_detail_id
1504: , X_return_status => x_return_status
1505: , X_msg_cont => x_msg_count

Line 1584: GML_BATCH_OM_UTIL.query_reservation

1580: l_so_line_rec.so_line_id := null;
1581: l_batch_line_rec.batch_line_id := null;
1582: l_reservation_rec.batch_res_id := res_rec.batch_res_id;
1583: /* create a new res for the new wdd, and new line_id if applicable */
1584: GML_BATCH_OM_UTIL.query_reservation
1585: (
1586: P_So_line_rec => l_so_line_rec
1587: , P_Batch_line_rec => l_batch_line_rec
1588: , P_Gme_om_reservation_rec => l_reservation_rec

Line 1598: GML_BATCH_OM_UTIL.insert_reservation

1594: l_reservation_rec.reserved_qty := res_rec.reserved_qty - l_qty_to_fulfil;
1595: l_reservation_rec.reserved_qty2 := res_rec.reserved_qty2 - l_qty2_to_fulfil;
1596: l_reservation_rec.so_line_id := p_new_source_line_id;
1597: l_reservation_rec.delivery_detail_id := p_new_delivery_detail_id;
1598: GML_BATCH_OM_UTIL.insert_reservation
1599: (
1600: P_Gme_om_reservation_rec => l_reservation_rec
1601: , X_return_status => x_return_status
1602: , X_msg_cont => x_msg_count

Line 1688: IF NOT GML_BATCH_OM_UTIL.check_reservation

1684: ) IS
1685: l_msg_cont NUMBER;
1686: l_msg_data VARCHAR2(300);
1687: BEGIN
1688: IF NOT GML_BATCH_OM_UTIL.check_reservation
1689: (
1690: p_so_line_id => p_so_line_id
1691: , X_return_status => x_return_status
1692: , X_msg_cont => l_msg_cont

Line 1708: P_batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec

1704: END check_gmeres_for_so_line;
1705:
1706: PROCEDURE pick_confirm
1707: (
1708: P_batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec
1709: , P_Gme_trans_row IN ic_tran_pnd%rowtype
1710: , X_return_status OUT NOCOPY VARCHAR2
1711: , X_msg_cont OUT NOCOPY NUMBER
1712: , X_msg_data OUT NOCOPY VARCHAR2

Line 1805: , x_res_rec OUT NOCOPY GML_BATCH_OM_UTIL.gme_om_reservation_rec

1801:
1802: PROCEDURE build_res_rec
1803: (
1804: p_res_row IN gml_batch_so_reservations%rowtype
1805: , x_res_rec OUT NOCOPY GML_BATCH_OM_UTIL.gme_om_reservation_rec
1806: ) IS
1807: BEGIN
1808: x_res_rec.batch_res_id := null;
1809: x_res_rec.item_id := p_res_row.item_id;