DBA Data[Home] [Help]

APPS.GML_GME_API_PVT dependencies on GML_BATCH_OM_UTIL

Line 37: , P_batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec

33:
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

Line 42: l_so_line_rec GML_BATCH_OM_UTIL.so_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 ;
43: l_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec ;
44: l_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;
45: ll_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;
46: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec ;

Line 43: l_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec ;

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 ;
43: l_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec ;
44: l_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;
45: ll_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;
46: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec ;
47: l_batch_id NUMBER;

Line 44: l_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;

40: , x_return_status OUT NOCOPY VARCHAR2
41: ) IS
42: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec ;
43: l_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec ;
44: l_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;
45: ll_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;
46: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec ;
47: l_batch_id NUMBER;
48: l_batch_line_id NUMBER;

Line 45: ll_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;

41: ) IS
42: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec ;
43: l_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec ;
44: l_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;
45: ll_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;
46: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec ;
47: l_batch_id NUMBER;
48: l_batch_line_id NUMBER;
49: l_batch_trans_id NUMBER;

Line 46: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec ;

42: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec ;
43: l_rule_rec GML_BATCH_OM_UTIL.gme_om_rule_rec ;
44: l_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;
45: ll_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;
46: l_batch_line_rec GML_BATCH_OM_UTIL.batch_line_rec ;
47: l_batch_id NUMBER;
48: l_batch_line_id NUMBER;
49: l_batch_trans_id NUMBER;
50: l_msg_cont NUMBER;

Line 184: IF NOT GML_BATCH_OM_UTIL.check_reservation

180: END IF;
181:
182: /* check the reservations, if non exists, exit */
183: IF l_batch_line_id is not null THEN
184: IF NOT GML_BATCH_OM_UTIL.check_reservation
185: (
186: P_Batch_line_id => p_batch_line_rec.batch_line_id
187: , X_return_status => x_return_status
188: , X_msg_cont => l_msg_cont

Line 196: IF NOT GML_BATCH_OM_UTIL.check_reservation

192: return;
193: END IF;
194: END IF;
195: IF l_batch_id is not null THEN
196: IF NOT GML_BATCH_OM_UTIL.check_reservation
197: (
198: P_Batch_id => l_batch_id
199: , X_return_status => x_return_status
200: , X_msg_cont => l_msg_cont

Line 240: GML_BATCH_OM_UTIL.get_rule

236: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....Calling GML_BATCH_OM_RES_PVT.cancel_batch');
237: For res in get_lnid_for_batch(p_batch_line_rec.batch_id) Loop
238: l_batch_line_rec.batch_line_id := res.batch_line_id;
239: /* get the rule for the batch line */
240: GML_BATCH_OM_UTIL.get_rule
241: (
242: P_so_line_rec => l_so_line_rec
243: , P_batch_line_rec => l_batch_line_rec
244: , X_gme_om_rule_rec => l_rule_rec

Line 282: GML_BATCH_OM_UTIL.get_rule

278: /* check to see the planned complt date */
279: For res in get_lnid_for_batch(p_batch_line_rec.batch_id) Loop
280: l_batch_line_rec.batch_line_id := res.batch_line_id;
281: /* get the rule for the batch line */
282: GML_BATCH_OM_UTIL.get_rule
283: (
284: P_so_line_rec => l_so_line_rec
285: , P_batch_line_rec => l_batch_line_rec
286: , X_gme_om_rule_rec => l_rule_rec

Line 315: GML_BATCH_OM_UTIL.get_rule

311: /* get the rule for this batch line */
312: l_so_line_rec.so_line_id := null;
313: /* always use the whse from the gme trans */
314: l_so_line_rec.whse_code := p_gme_trans_row.whse_code;
315: GML_BATCH_OM_UTIL.get_rule
316: (
317: P_so_line_rec => l_so_line_rec
318: , P_batch_line_rec => p_batch_line_rec
319: , X_gme_om_rule_rec => l_rule_rec

Line 696: GML_BATCH_OM_UTIL.query_alloc_history

692: ;
693: GMI_RESERVATION_UTIL.println(' delete history.alloc_rec_id '||his_rec.alloc_rec_id);
694: GMI_RESERVATION_UTIL.println(' old batch_trans_id '||l_old_gme_trans_row.trans_id);
695: l_history_rec.alloc_rec_id := his_rec.alloc_rec_id;
696: GML_BATCH_OM_UTIL.query_alloc_history
697: (
698: P_alloc_history_rec => l_history_rec
699: , X_return_status => x_return_status
700: , X_msg_cont => l_msg_cont

Line 709: GML_BATCH_OM_UTIL.insert_alloc_history

705: l_history_rec.batch_trans_id := l_new_gme_trans_row.trans_id;
706: l_history_rec.location := l_new_gme_trans_row.location;
707: l_history_rec.lot_id := l_new_gme_trans_row.lot_id;
708: GMI_RESERVATION_UTIL.println(' for batch_res_id '||l_history_rec.batch_res_id);
709: GML_BATCH_OM_UTIL.insert_alloc_history
710: (
711: P_alloc_history_rec => l_history_rec
712: , X_return_status => x_return_status
713: , X_msg_cont => l_msg_cont