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_UTIL dependencies on GML_BATCH_OM_UTIL

Line 1: PACKAGE body GML_BATCH_OM_UTIL AS

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

Line 19: API Name : GML_BATCH_OM_UTIL

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

Line 29: G_PKG_NAME CONSTANT VARCHAR2(30):='GML_BATCH_OM_UTIL';

25:
26: Current Vers : 1.0
27:
28: */
29: G_PKG_NAME CONSTANT VARCHAR2(30):='GML_BATCH_OM_UTIL';
30:
31: PROCEDURE query_reservation
32: (
33: P_So_line_rec IN GML_BATCH_OM_UTIL.so_line_rec

Line 33: P_So_line_rec IN GML_BATCH_OM_UTIL.so_line_rec

29: G_PKG_NAME CONSTANT VARCHAR2(30):='GML_BATCH_OM_UTIL';
30:
31: PROCEDURE query_reservation
32: (
33: P_So_line_rec IN GML_BATCH_OM_UTIL.so_line_rec
34: , P_Batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec
35: , P_Gme_om_reservation_rec IN OUT NOCOPY GML_BATCH_OM_UTIL.gme_om_reservation_rec
36: , X_return_status OUT NOCOPY VARCHAR2
37: , X_msg_cont OUT NOCOPY NUMBER

Line 34: , P_Batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec

30:
31: PROCEDURE query_reservation
32: (
33: P_So_line_rec IN GML_BATCH_OM_UTIL.so_line_rec
34: , P_Batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec
35: , P_Gme_om_reservation_rec IN OUT NOCOPY GML_BATCH_OM_UTIL.gme_om_reservation_rec
36: , X_return_status OUT NOCOPY VARCHAR2
37: , X_msg_cont OUT NOCOPY NUMBER
38: , X_msg_data OUT NOCOPY VARCHAR2

Line 35: , P_Gme_om_reservation_rec IN OUT NOCOPY GML_BATCH_OM_UTIL.gme_om_reservation_rec

31: PROCEDURE query_reservation
32: (
33: P_So_line_rec IN GML_BATCH_OM_UTIL.so_line_rec
34: , P_Batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec
35: , P_Gme_om_reservation_rec IN OUT NOCOPY GML_BATCH_OM_UTIL.gme_om_reservation_rec
36: , X_return_status OUT NOCOPY VARCHAR2
37: , X_msg_cont OUT NOCOPY NUMBER
38: , X_msg_data OUT NOCOPY VARCHAR2
39: ) IS

Line 90: P_Gme_om_reservation_rec IN GML_BATCH_OM_UTIL.gme_om_reservation_rec

86: END query_reservation;
87:
88: PROCEDURE insert_reservation
89: (
90: P_Gme_om_reservation_rec IN GML_BATCH_OM_UTIL.gme_om_reservation_rec
91: , X_return_status OUT NOCOPY VARCHAR2
92: , X_msg_cont OUT NOCOPY NUMBER
93: , X_msg_data OUT NOCOPY VARCHAR2
94: ) IS

Line 177: P_Gme_om_reservation_rec IN GML_BATCH_OM_UTIL.gme_om_reservation_rec

173: END insert_reservation;
174:
175: PROCEDURE update_reservation
176: (
177: P_Gme_om_reservation_rec IN GML_BATCH_OM_UTIL.gme_om_reservation_rec
178: , X_return_status OUT NOCOPY VARCHAR2
179: , X_msg_cont OUT NOCOPY NUMBER
180: , X_msg_data OUT NOCOPY VARCHAR2
181: ) IS

Line 235: P_alloc_history_rec IN OUT NOCOPY GML_BATCH_OM_UTIL.alloc_history_rec

231: END delete_reservation;
232:
233: PROCEDURE query_alloc_history
234: (
235: P_alloc_history_rec IN OUT NOCOPY GML_BATCH_OM_UTIL.alloc_history_rec
236: , X_return_status OUT NOCOPY VARCHAR2
237: , X_msg_cont OUT NOCOPY NUMBER
238: , X_msg_data OUT NOCOPY VARCHAR2
239: ) IS

Line 242: l_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;

238: , X_msg_data OUT NOCOPY VARCHAR2
239: ) IS
240: l_alloc_rec_id NUMBER;
241: l_history_row gml_batch_so_alloc_history%rowtype;
242: l_history_rec GML_BATCH_OM_UTIL.alloc_history_rec;
243: BEGIN
244: x_return_status := FND_API.G_RET_STS_SUCCESS;
245: IF p_alloc_history_rec.alloc_rec_id is not null THEN
246: Select *

Line 273: P_alloc_history_rec IN GML_BATCH_OM_UTIL.alloc_history_rec

269: END query_alloc_history;
270:
271: PROCEDURE insert_alloc_history
272: (
273: P_alloc_history_rec IN GML_BATCH_OM_UTIL.alloc_history_rec
274: , X_return_status OUT NOCOPY VARCHAR2
275: , X_msg_cont OUT NOCOPY NUMBER
276: , X_msg_data OUT NOCOPY VARCHAR2
277: ) IS

Line 432: P_Gme_om_config_assign IN GML_BATCH_OM_UTIL.gme_om_config_assign

428: END check_reservation;
429:
430: PROCEDURE check_rules
431: (
432: P_Gme_om_config_assign IN GML_BATCH_OM_UTIL.gme_om_config_assign
433: , X_count OUT NOCOPY NUMBER
434: , X_rule_id OUT NOCOPY NUMBER
435: , X_return_status OUT NOCOPY VARCHAR2
436: , X_msg_cont OUT NOCOPY NUMBER

Line 585: P_so_line_rec IN GML_BATCH_OM_UTIL.so_line_rec

581: END check_rules;
582:
583: PROCEDURE get_rule
584: (
585: P_so_line_rec IN GML_BATCH_OM_UTIL.so_line_rec
586: , P_batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec
587: , X_gme_om_rule_rec OUT NOCOPY GML_BATCH_OM_UTIL.gme_om_rule_rec
588: , X_return_status OUT NOCOPY VARCHAR2
589: , X_msg_cont OUT NOCOPY NUMBER

Line 586: , P_batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec

582:
583: PROCEDURE get_rule
584: (
585: P_so_line_rec IN GML_BATCH_OM_UTIL.so_line_rec
586: , P_batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec
587: , X_gme_om_rule_rec OUT NOCOPY GML_BATCH_OM_UTIL.gme_om_rule_rec
588: , X_return_status OUT NOCOPY VARCHAR2
589: , X_msg_cont OUT NOCOPY NUMBER
590: , X_msg_data OUT NOCOPY VARCHAR2

Line 587: , X_gme_om_rule_rec OUT NOCOPY GML_BATCH_OM_UTIL.gme_om_rule_rec

583: PROCEDURE get_rule
584: (
585: P_so_line_rec IN GML_BATCH_OM_UTIL.so_line_rec
586: , P_batch_line_rec IN GML_BATCH_OM_UTIL.batch_line_rec
587: , X_gme_om_rule_rec OUT NOCOPY GML_BATCH_OM_UTIL.gme_om_rule_rec
588: , X_return_status OUT NOCOPY VARCHAR2
589: , X_msg_cont OUT NOCOPY NUMBER
590: , X_msg_data OUT NOCOPY VARCHAR2
591: ) IS

Line 600: l_Gme_om_config_assign GML_BATCH_OM_UTIL.gme_om_config_assign;

596: l_so_line_id NUMBER ;
597: i NUMBER ;
598: j NUMBER ;
599: l_rule_rec gml_batch_so_rules%rowtype;
600: l_Gme_om_config_assign GML_BATCH_OM_UTIL.gme_om_config_assign;
601: l_cust_site so_lineTabTyp ;
602: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec;
603: l_cust_diff NUMBER ;
604: l_site_diff NUMBER ;

Line 602: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec;

598: j NUMBER ;
599: l_rule_rec gml_batch_so_rules%rowtype;
600: l_Gme_om_config_assign GML_BATCH_OM_UTIL.gme_om_config_assign;
601: l_cust_site so_lineTabTyp ;
602: l_so_line_rec GML_BATCH_OM_UTIL.so_line_rec;
603: l_cust_diff NUMBER ;
604: l_site_diff NUMBER ;
605: l_org_diff NUMBER ;
606:

Line 752: GML_BATCH_OM_UTIL.check_rules

748: GMI_reservation_Util.PrintLn('get_rule: item_id '||l_gme_om_config_assign.item_id);
749: GMI_reservation_Util.PrintLn('get_rule: whse_code '||l_gme_om_config_assign.whse_code);
750:
751: /* check rules first to see the uniqueness, if not, error */
752: GML_BATCH_OM_UTIL.check_rules
753: (
754: P_Gme_om_config_assign => l_gme_om_config_assign
755: , X_count => l_rule_count
756: , X_rule_id => l_rule_id

Line 840: END GML_BATCH_OM_UTIL;

836: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
837:
838: END get_Rule;
839:
840: END GML_BATCH_OM_UTIL;