DBA Data[Home] [Help]

APPS.GML_GME_API_PVT dependencies on GML_GME_API_PVT

Line 1: PACKAGE body GML_GME_API_PVT AS

1: PACKAGE body GML_GME_API_PVT AS
2: /* $Header: GMLFGMEB.pls 120.0 2005/05/25 16:37:22 appldev noship $
3: +=========================================================================+
4: | Copyright (c) 2000 Oracle Corporation |
5: | TVP, Reading, England |

Line 19: API Name : GML_GME_API_PVT

15: | |
16: | HISTORY |
17: | Aug-18-2003 Liping Gao Created |
18: +=========================================================================+
19: API Name : GML_GME_API_PVT
20: Type : Private
21: Function : This package contains Private API procedures used to
22: OPM reservation for a batch.
23: Pre-reqs : N/A

Line 175: GML_GME_API_PVT.g_not_to_delete := 0; -- always delete reservation when availability is 0

171: GMI_RESERVATION_UTIL.println('reset global ');
172: g_batch_id := l_batch_id;
173: g_batch_line_id := l_batch_line_id;
174: g_prod_yielded := 0; -- Batch initiation
175: GML_GME_API_PVT.g_not_to_delete := 0; -- always delete reservation when availability is 0
176: END IF;
177:
178: IF p_from_batch_id is not null THEN
179: l_batch_id := p_from_batch_id;

Line 414: GMI_RESERVATION_UTIL.println(' global g_not_to_notify '||GML_GME_API_PVT.g_not_to_notify);

410: Into l_planned_qty, l_planned_qty2;
411: Close get_planned_qty;
412:
413: GMI_RESERVATION_UTIL.println('UPDP, total planned qty '|| nvl(l_planned_qty,0));
414: GMI_RESERVATION_UTIL.println(' global g_not_to_notify '||GML_GME_API_PVT.g_not_to_notify);
415: IF (l_res_qty > nvl(l_planned_qty,0) * (1+ l_rule_rec.allocation_tolerance/100))
416: and l_notify = 1
417: and GML_GME_API_PVT.g_not_to_notify <> 1
418: THEN

Line 417: and GML_GME_API_PVT.g_not_to_notify <> 1

413: GMI_RESERVATION_UTIL.println('UPDP, total planned qty '|| nvl(l_planned_qty,0));
414: GMI_RESERVATION_UTIL.println(' global g_not_to_notify '||GML_GME_API_PVT.g_not_to_notify);
415: IF (l_res_qty > nvl(l_planned_qty,0) * (1+ l_rule_rec.allocation_tolerance/100))
416: and l_notify = 1
417: and GML_GME_API_PVT.g_not_to_notify <> 1
418: THEN
419: /* pending qty has been reduced
420: * check the tolerance
421: */

Line 435: GMI_RESERVATION_UTIL.println(' global g_not_to_delete '||GML_GME_API_PVT.g_not_to_delete);

431: , X_msg_cont => l_msg_cont
432: , X_msg_data => l_msg_data
433: );
434: /* if planned qty becomes 0, delete all the res for this whse */
435: GMI_RESERVATION_UTIL.println(' global g_not_to_delete '||GML_GME_API_PVT.g_not_to_delete);
436: IF (nvl(l_planned_qty,0) <= 0 AND GML_GME_API_PVT.g_not_to_delete = 0) THEN
437: GML_BATCH_OM_RES_PVT.cancel_res_for_batch_line
438: (
439: P_Batch_line_id => p_batch_line_rec.batch_line_id

Line 436: IF (nvl(l_planned_qty,0) <= 0 AND GML_GME_API_PVT.g_not_to_delete = 0) THEN

432: , X_msg_data => l_msg_data
433: );
434: /* if planned qty becomes 0, delete all the res for this whse */
435: GMI_RESERVATION_UTIL.println(' global g_not_to_delete '||GML_GME_API_PVT.g_not_to_delete);
436: IF (nvl(l_planned_qty,0) <= 0 AND GML_GME_API_PVT.g_not_to_delete = 0) THEN
437: GML_BATCH_OM_RES_PVT.cancel_res_for_batch_line
438: (
439: P_Batch_line_id => p_batch_line_rec.batch_line_id
440: , P_whse_code => l_whse_code

Line 748: END GML_GME_API_PVT;

744: END IF;
745:
746: END process_om_reservations;
747:
748: END GML_GME_API_PVT;