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 IC_TRAN_PND

Line 34: p_trans_row IN ic_tran_pnd%rowtype

30: G_PKG_NAME CONSTANT VARCHAR2(30):='GML_BATCH_OM_RES_PVT';
31:
32: PROCEDURE build_trans_rec
33: (
34: p_trans_row IN ic_tran_pnd%rowtype
35: , x_trans_rec IN OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec
36: );
37: PROCEDURE build_res_rec
38: (

Line 103: From ic_tran_pnd

99:
100: Cursor get_planned_qty (p_batch_line_id IN NUMBER
101: , p_whse_code IN VARCHAR2) is
102: Select abs(sum(trans_qty)), abs(sum(trans_qty2))
103: From ic_tran_pnd
104: Where line_id = p_batch_line_id
105: and whse_code = p_whse_code
106: and doc_type = 'PROD'
107: and delete_mark = 0

Line 281: , P_Gme_trans_row IN ic_tran_pnd%rowtype

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
285: ) IS

Line 290: l_gme_trans_row ic_tran_pnd%rowtype;

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;
294: l_res_count NUMBER;

Line 293: l_tran_row IC_TRAN_PND%ROWTYPE;

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;
294: l_res_count NUMBER;
295: l_avg_qty NUMBER;
296: l_avg_qty2 NUMBER;
297: l_remaining_alloc_qty NUMBER;

Line 359: From ic_Tran_pnd

355: Where item_id = p_item_id;
356:
357: Cursor check_alloc_qty (p_so_line_id IN NUMBER) is
358: Select abs(sum(trans_qty)), abs(sum(trans_qty2))
359: From ic_Tran_pnd
360: Where line_id = p_so_line_id
361: and doc_type = 'OMSO'
362: and delete_mark = 0
363: and (lot_id <> 0 or location <> GMI_Reservation_Util.G_DEFAULT_LOCT)

Line 444: IF NOT GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_dft_tran_rec, l_dft_tran_rec ) THEN

440: l_history_rec.failure_reason := FND_MESSAGE.GET;
441: l_go_ahead := 0;
442: END IF;
443: l_dft_tran_rec.trans_id := l_dft_trans_id ;
444: IF NOT GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_dft_tran_rec, l_dft_tran_rec ) THEN
445: GMI_RESERVATION_UTIL.println('Error returned by find default lot');
446: FND_MESSAGE.SET_NAME('GML', 'GML_NO_DFLT_TRAN');
447: l_history_rec.failure_reason := FND_MESSAGE.GET;
448: l_go_ahead := 0;

Line 665: l_tran_row IC_TRAN_PND%ROWTYPE;

661: ) IS
662:
663: l_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
664: l_dft_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
665: l_tran_row IC_TRAN_PND%ROWTYPE;
666: l_trans_id NUMBER;
667:
668: Cursor find_nonstgd_alloc_for_trans (P_batch_trans_id IN NUMBER) IS
669: Select ic.trans_id

Line 670: From ic_tran_pnd ic

666: l_trans_id NUMBER;
667:
668: Cursor find_nonstgd_alloc_for_trans (P_batch_trans_id IN NUMBER) IS
669: Select ic.trans_id
670: From ic_tran_pnd ic
671: , gml_batch_so_alloc_history his
672: Where his.batch_trans_id = p_batch_trans_id
673: and his.trans_id = ic.trans_id
674: and ic.line_id = his.line_id

Line 692: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_tran_rec, l_tran_rec ) THEN

688: /* call gmi api to delete this trans */
689: l_trans_id := alloc_rec.trans_id;
690: l_tran_rec.trans_id := l_trans_id;
691: GMI_RESERVATION_UTIL.PrintLn(' Deleting trans_id '||l_trans_id);
692: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_tran_rec, l_tran_rec ) THEN
693: GMI_TRANS_ENGINE_PUB.delete_pending_transaction
694: (p_api_version => 1.0,
695: p_init_msg_list => FND_API.G_TRUE,
696: p_commit => FND_API.G_FALSE,

Line 721: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_dft_tran_rec, l_dft_tran_rec ) THEN

717: x_reservation_id => l_dft_tran_rec.trans_id,
718: p_line_id => l_tran_rec.line_id
719: );
720:
721: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_dft_tran_rec, l_dft_tran_rec ) THEN
722: GMI_RESERVATION_UTIL.balance_default_lot
723: ( p_ic_default_rec => l_dft_tran_rec
724: , p_opm_item_id => l_dft_tran_rec.item_id
725: , x_return_status => x_return_status

Line 748: l_tran_row IC_TRAN_PND%ROWTYPE;

744: ) IS
745:
746: l_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
747: l_dft_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
748: l_tran_row IC_TRAN_PND%ROWTYPE;
749: l_batch_trans_id NUMBER;
750:
751: Cursor find_nonstgd_alloc_for_batch (P_batch_id IN NUMBER) IS
752: Select ic.trans_id

Line 753: From ic_tran_pnd ic

749: l_batch_trans_id NUMBER;
750:
751: Cursor find_nonstgd_alloc_for_batch (P_batch_id IN NUMBER) IS
752: Select ic.trans_id
753: From ic_tran_pnd ic
754: , gml_batch_so_alloc_history his
755: Where his.batch_id = p_batch_id
756: and his.trans_id = ic.trans_id
757: and ic.line_id = his.line_id

Line 817: From ic_tran_pnd ic

813: l_batch_trans_id NUMBER;
814:
815: Cursor find_nonstgd_alloc_for_batch (P_batch_line_id IN NUMBER) IS
816: Select ic.trans_id
817: From ic_tran_pnd ic
818: , gml_batch_so_alloc_history his
819: Where his.batch_line_id = p_batch_line_id
820: and his.trans_id = ic.trans_id
821: and ic.line_id = his.line_id

Line 1023: From ic_tran_pnd ictran

1019:
1020:
1021: Cursor so_line_id_for_batch_trans (p_batch_trans_id IN NUMBER) IS
1022: Select distinct ictran.line_id
1023: From ic_tran_pnd ictran
1024: , gml_batch_so_alloc_history his
1025: Where his.batch_trans_id = p_batch_trans_id
1026: and his.trans_id = ictran.trans_id
1027: and ictran.doc_type = 'OMSO'

Line 1048: From ic_tran_pnd ic

1044: WHERE line_id = p_so_line_id;
1045:
1046: Cursor find_nonstgd_alloc_for_trans (P_batch_trans_id IN NUMBER) IS
1047: Select count(*)
1048: From ic_tran_pnd ic
1049: , gml_batch_so_alloc_history his
1050: Where his.batch_trans_id = p_batch_trans_id
1051: and his.trans_id = ic.trans_id
1052: and ic.line_id = his.line_id

Line 1060: From ic_tran_pnd ic

1056: ;
1057:
1058: Cursor find_staged_alloc_for_trans (P_batch_trans_id IN NUMBER) IS
1059: Select count(*)
1060: From ic_tran_pnd ic
1061: , gml_batch_so_alloc_history his
1062: Where his.batch_trans_id = p_batch_trans_id
1063: and his.trans_id = ic.trans_id
1064: and ic.line_id = his.line_id

Line 1361: l_Gme_trans_row ic_tran_pnd%rowtype;

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);
1365: BEGIN

Line 1371: From ic_tran_pnd

1367: l_batch_line_rec.batch_line_id := p_alloc_history_rec.batch_line_id;
1368: l_gme_om_rule_rec.rule_id := null;
1369: Select *
1370: Into l_gme_trans_row
1371: From ic_tran_pnd
1372: Where trans_id = p_alloc_history_rec.batch_trans_id;
1373: IF SQL%NOTFOUND THEN
1374: GMI_reservation_Util.PrintLn('regenerate_alloc: no gme_trans');
1375: END IF;

Line 1430: , P_Gme_trans_row IN ic_tran_pnd%rowtype

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
1434: BEGIN

Line 1709: , P_Gme_trans_row IN ic_tran_pnd%rowtype

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
1713: ) IS

Line 1724: From ic_tran_pnd

1720: l_qty_um2 VARCHAR2(5);
1721:
1722: Cursor get_wdd_id (p_batch_trans_id IN NUMBER) IS
1723: Select line_detail_id
1724: From ic_tran_pnd
1725: Where delete_mark = 0
1726: and trans_id in
1727: (Select trans_id
1728: From gml_batch_so_alloc_history

Line 1737: , ic_tran_pnd ictran

1733:
1734: Cursor get_mo_line_id (p_batch_line_id IN NUMBER ) IS
1735: Select distinct wdd.move_order_line_id
1736: From wsh_delivery_details wdd
1737: , ic_tran_pnd ictran
1738: Where wdd.delivery_detail_id = ictran.line_detail_id
1739: and ictran.delete_mark = 0
1740: and ictran.trans_id in
1741: (Select trans_id

Line 1780: p_trans_row IN ic_tran_pnd%rowtype

1776: END pick_confirm ;
1777:
1778: PROCEDURE build_trans_rec
1779: (
1780: p_trans_row IN ic_tran_pnd%rowtype
1781: , x_trans_rec IN OUT NOCOPY GMI_TRANS_ENGINE_PUB.ictran_rec
1782: ) IS
1783: BEGIN
1784: x_trans_rec.trans_id := null;