APPS.GML_BATCH_OM_UTIL dependencies on GML_BATCH_SO_RESERVATIONS

Line 40: l_res_rec gml_batch_so_reservations%rowtype;

36: , X_return_status OUT NOCOPY VARCHAR2
37: , X_msg_cont OUT NOCOPY NUMBER
38: , X_msg_data OUT NOCOPY VARCHAR2
39: ) IS
40: l_res_rec gml_batch_so_reservations%rowtype;
41: BEGIN
42: x_return_status := FND_API.G_RET_STS_SUCCESS;
43: GMI_RESERVATION_UTIL.Println(' In query reservation');
44: GMI_RESERVATION_UTIL.Println(' In query reservation, so_line_id '|| p_so_line_rec.so_line_id);

Line 50: From gml_batch_so_reservations

46: GMI_RESERVATION_UTIL.Println(' In query reservation, batch_res '|| p_gme_om_reservation_rec.batch_res_id);
47: IF p_so_line_rec.so_line_id is not null AND p_batch_line_rec.batch_line_id is not null THEN
48: Select *
49: Into l_res_rec
50: From gml_batch_so_reservations
51: Where so_line_id = p_so_line_rec.so_line_id
52: and batch_line_id = p_batch_line_rec.batch_line_id;
53: END IF;
54: IF p_so_line_rec.so_line_id is not null AND p_batch_line_rec.batch_line_id is null THEN

Line 57: From gml_batch_so_reservations

53: END IF;
54: IF p_so_line_rec.so_line_id is not null AND p_batch_line_rec.batch_line_id is null THEN
55: Select *
56: Into l_res_rec
57: From gml_batch_so_reservations
58: Where so_line_id = p_so_line_rec.so_line_id;
59: END IF;
60: IF p_so_line_rec.so_line_id is null AND p_batch_line_rec.batch_line_id is not null THEN
61: Select *

Line 63: From gml_batch_so_reservations

59: END IF;
60: IF p_so_line_rec.so_line_id is null AND p_batch_line_rec.batch_line_id is not null THEN
61: Select *
62: Into l_res_rec
63: From gml_batch_so_reservations
64: Where batch_line_id = p_batch_line_rec.batch_line_id;
65: END IF;
66: IF p_gme_om_reservation_rec.batch_res_id is not null THEN
67: Select *

Line 69: From gml_batch_so_reservations

65: END IF;
66: IF p_gme_om_reservation_rec.batch_res_id is not null THEN
67: Select *
68: Into l_res_rec
69: From gml_batch_so_reservations
70: Where batch_res_id = p_gme_om_reservation_rec.batch_res_id;
71: END IF;
72: p_gme_om_reservation_rec.batch_id := l_res_rec.batch_id;
73: p_gme_om_reservation_rec.batch_line_id := l_res_rec.batch_line_id;

Line 99: /* insert gme_om_reservation_rec into gml_batch_so_reservations table */

95: l_batch_res_id NUMBER;
96: BEGIN
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98: GMI_RESERVATION_UTIL.Println(' In insert reservations');
99: /* insert gme_om_reservation_rec into gml_batch_so_reservations table */
100: select gml_so_reservation_s.nextval
101: into l_batch_res_id
102: from dual;
103: Insert Into gml_batch_so_reservations

Line 103: Insert Into gml_batch_so_reservations

99: /* insert gme_om_reservation_rec into gml_batch_so_reservations table */
100: select gml_so_reservation_s.nextval
101: into l_batch_res_id
102: from dual;
103: Insert Into gml_batch_so_reservations
104: (
105: batch_res_id
106: , batch_id
107: , batch_line_id

Line 184: update gml_batch_so_reservations

180: , X_msg_data OUT NOCOPY VARCHAR2
181: ) IS
182: BEGIN
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184: update gml_batch_so_reservations
185: Set
186: batch_id = p_gme_om_reservation_rec.batch_id
187: , batch_line_id = p_gme_om_reservation_rec.batch_line_id
188: , so_line_id = p_gme_om_reservation_rec.so_line_id

Line 217: update gml_batch_so_reservations

213: ) IS
214: BEGIN
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216: IF p_batch_res_id is not null Then
217: update gml_batch_so_reservations
218: set delete_mark = 1
219: Where batch_res_id = p_batch_res_id;
220: END IF;
221: IF p_batch_line_id is not null Then

Line 222: update gml_batch_so_reservations

218: set delete_mark = 1
219: Where batch_res_id = p_batch_res_id;
220: END IF;
221: IF p_batch_line_id is not null Then
222: update gml_batch_so_reservations
223: set delete_mark = 1
224: Where batch_line_id = p_batch_line_id;
225: END IF;
226: IF p_batch_id is not null Then

Line 227: update gml_batch_so_reservations

223: set delete_mark = 1
224: Where batch_line_id = p_batch_line_id;
225: END IF;
226: IF p_batch_id is not null Then
227: update gml_batch_so_reservations
228: set delete_mark = 1
229: Where batch_id = p_batch_id;
230: END IF;
231: END delete_reservation;

Line 281: /* insert gme_om_reservation_rec into gml_batch_so_reservations table */

277: ) IS
278: l_alloc_rec_id NUMBER;
279: BEGIN
280: x_return_status := FND_API.G_RET_STS_SUCCESS;
281: /* insert gme_om_reservation_rec into gml_batch_so_reservations table */
282: GMI_RESERVATION_UTIL.println('inserting alloc history');
283: select gml_so_alloc_history_s.nextval
284: into l_alloc_rec_id
285: from dual;

Line 359: From gml_batch_so_reservations

355: l_exist := 0;
356: IF p_batch_id is not null then
357: Select count(*)
358: Into l_exist
359: From gml_batch_so_reservations
360: Where batch_id = p_batch_id
361: and delete_mark = 0
362: and (reserved_qty > 0 or allocated_ind = 1)
363: ;

Line 372: From gml_batch_so_reservations

368: End if;
369: IF p_batch_line_id is not null then
370: Select count(*)
371: Into l_exist
372: From gml_batch_so_reservations
373: Where batch_line_id = p_batch_line_id
374: and delete_mark = 0
375: and (reserved_qty > 0 or allocated_ind = 1)
376: ;

Line 385: From gml_batch_so_reservations

381: End if;
382: IF p_so_line_id is not null then
383: Select count(*)
384: Into l_exist
385: From gml_batch_so_reservations
386: Where so_line_id = p_so_line_id
387: and delete_mark = 0
388: and (reserved_qty > 0 or allocated_ind = 1)
389: ;

Line 397: From gml_batch_so_reservations

393: End if;
394: IF p_delivery_detail_id is not null then
395: Select count(*)
396: Into l_exist
397: From gml_batch_so_reservations
398: Where delivery_detail_id = p_delivery_detail_id
399: and delete_mark = 0
400: and (reserved_qty > 0 or allocated_ind = 1)
401: ;

Line 609: From gml_batch_so_reservations

605: l_org_diff NUMBER ;
606:
607: Cursor get_so_line_ids (p_batch_line_id in NUMBER) is
608: Select distinct so_line_id
609: From gml_batch_so_reservations
610: Where batch_line_id = p_batch_line_id;
611:
612: Cursor get_line_info (p_so_line_id IN NUMBER) is
613: Select sold_to_org_id