APPS.GML_GME_API_PVT dependencies on IC_TRAN_PND

Line 38: , P_Gme_trans_row IN ic_tran_pnd%rowtype

34: PROCEDURE process_om_reservations
35: (
36: P_from_batch_id IN NUMBER default null
37: , P_batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec
38: , P_Gme_trans_row IN ic_tran_pnd%rowtype
39: , P_batch_action IN VARCHAR2
40: , x_return_status OUT NOCOPY VARCHAR2
41: ) IS
42: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec ;

Line 52: l_old_gme_trans_row ic_tran_pnd%rowtype;

48: l_batch_line_id NUMBER;
49: l_batch_trans_id NUMBER;
50: l_msg_cont NUMBER;
51: l_msg_data VARCHAR2(300);
52: l_old_gme_trans_row ic_tran_pnd%rowtype;
53: l_new_gme_trans_row ic_tran_pnd%rowtype;
54: l_tran_row ic_tran_pnd%rowtype;
55: l_res_qty NUMBER;
56: l_res_qty2 NUMBER;

Line 53: l_new_gme_trans_row ic_tran_pnd%rowtype;

49: l_batch_trans_id NUMBER;
50: l_msg_cont NUMBER;
51: l_msg_data VARCHAR2(300);
52: l_old_gme_trans_row ic_tran_pnd%rowtype;
53: l_new_gme_trans_row ic_tran_pnd%rowtype;
54: l_tran_row ic_tran_pnd%rowtype;
55: l_res_qty NUMBER;
56: l_res_qty2 NUMBER;
57: l_trans_qty NUMBER;

Line 54: l_tran_row ic_tran_pnd%rowtype;

50: l_msg_cont NUMBER;
51: l_msg_data VARCHAR2(300);
52: l_old_gme_trans_row ic_tran_pnd%rowtype;
53: l_new_gme_trans_row ic_tran_pnd%rowtype;
54: l_tran_row ic_tran_pnd%rowtype;
55: l_res_qty NUMBER;
56: l_res_qty2 NUMBER;
57: l_trans_qty NUMBER;
58: l_trans_qty2 NUMBER;

Line 71: from ic_tran_pnd

67: l_return_status VARCHAR2(30);
68:
69: Cursor get_trans_row (p_trans_id IN NUMBER) is
70: Select *
71: from ic_tran_pnd
72: where trans_id = p_trans_id;
73:
74: Cursor check_res_whse (p_batch_line_id IN NUMBER) is
75: Select distinct whse_code

Line 90: From ic_tran_pnd

86:
87: Cursor get_planned_qty (p_batch_line_id IN NUMBER
88: , p_whse_code IN VARCHAR2) is
89: Select abs(sum(nvl(trans_qty,0))), abs(sum(nvl(trans_qty2,0)))
90: From ic_tran_pnd
91: Where line_id = p_batch_line_id
92: and whse_code = p_whse_code
93: and doc_type in ('PROD', 'FPO')
94: and delete_mark = 0

Line 99: From ic_tran_pnd ic

95: and completed_ind = 0;
96:
97: Cursor get_trans_id (P_batch_trans_id IN NUMBER) IS
98: Select ic.trans_id
99: From ic_tran_pnd ic
100: , gml_batch_so_alloc_history his
101: Where his.batch_trans_id = p_batch_trans_id
102: and his.trans_id = ic.trans_id
103: and ic.line_id = his.line_id

Line 111: From ic_tran_pnd ic

107: ;
108:
109: Cursor get_total_OMSO (p_gme_trans_id IN NUMBER) IS
110: Select abs(sum(trans_qty)),abs(sum(trans_qty2))
111: From ic_tran_pnd ic
112: , gml_batch_so_alloc_history his
113: Where his.batch_trans_id = p_gme_trans_id
114: and his.trans_id = ic.trans_id
115: and his.delete_mark = 0

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

548: GMI_RESERVATION_UTIL.println(' to '|| l_new_gme_trans_row.lot_id);
549: For trans_rec in get_trans_id(l_batch_trans_id) LOOP
550: l_trans_id := trans_rec.trans_id;
551: l_tran_rec.trans_id := l_trans_id;
552: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_tran_rec, l_tran_rec ) THEN
553: l_tran_rec.lot_id := l_new_gme_trans_row.lot_id;
554: GMI_RESERVATION_UTIL.println(' Changing lot_id for trans_id '|| l_trans_id);
555: GMI_TRANS_ENGINE_PUB.update_pending_transaction
556: (p_api_version => 1.0,

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

596: GMI_RESERVATION_UTIL.println(' to '|| l_new_gme_trans_row.location);
597: For trans_rec in get_trans_id(l_batch_trans_id) LOOP
598: l_trans_id := trans_rec.trans_id;
599: l_tran_rec.trans_id := l_trans_id;
600: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_tran_rec, l_tran_rec ) THEN
601: l_tran_rec.location := l_new_gme_trans_row.location;
602: GMI_RESERVATION_UTIL.println(' Changing location for trans_id '|| l_trans_id);
603: GMI_TRANS_ENGINE_PUB.update_pending_transaction
604: (p_api_version => 1.0,