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.GME_PENDING_PRODUCT_LOTS_DBL dependencies on GME_PENDING_PRODUCT_LOTS

Line 1: PACKAGE BODY gme_pending_product_lots_dbl AS

1: PACKAGE BODY gme_pending_product_lots_dbl AS
2: /* $Header: GMEVGPLB.pls 120.1 2006/05/03 12:00:07 creddy noship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_PENDING_PRODUCT_LOTS';

Line 5: g_table_name VARCHAR2 (80) DEFAULT 'GME_PENDING_PRODUCT_LOTS';

1: PACKAGE BODY gme_pending_product_lots_dbl AS
2: /* $Header: GMEVGPLB.pls 120.1 2006/05/03 12:00:07 creddy noship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_PENDING_PRODUCT_LOTS';
6: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
7: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_PENDING_PRODUCT_LOTS_DBL';
8:
9: /*=========================================================================

Line 7: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_PENDING_PRODUCT_LOTS_DBL';

3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_PENDING_PRODUCT_LOTS';
6: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
7: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_PENDING_PRODUCT_LOTS_DBL';
8:
9: /*=========================================================================
10: | Copyright (c) 2001 Oracle Corporation |
11: | TVP, Reading, England |

Line 19: | Body of package gme_pending_product_lots_dbl |

15: | GMEVGPLB.pls |
16: | |
17: | DESCRIPTION |
18: | |
19: | Body of package gme_pending_product_lots_dbl |
20: | |
21: | NOTES |
22: | |
23: | HISTORY |

Line 43: | insert_row will insert a row in gme_pending_product_lots |

39: | TYPE |
40: | Private |
41: | |
42: | USAGE |
43: | insert_row will insert a row in gme_pending_product_lots |
44: | |
45: | DESCRIPTION |
46: | insert_row will insert a row in gme_pending_product_lots |
47: | |

Line 46: | insert_row will insert a row in gme_pending_product_lots |

42: | USAGE |
43: | insert_row will insert a row in gme_pending_product_lots |
44: | |
45: | DESCRIPTION |
46: | insert_row will insert a row in gme_pending_product_lots |
47: | |
48: | PARAMETERS |
49: | p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |
50: | x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE |

Line 49: | p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |

45: | DESCRIPTION |
46: | insert_row will insert a row in gme_pending_product_lots |
47: | |
48: | PARAMETERS |
49: | p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |
50: | x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE |
51: | |
52: | RETURNS |
53: | BOOLEAN |

Line 50: | x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE |

46: | insert_row will insert a row in gme_pending_product_lots |
47: | |
48: | PARAMETERS |
49: | p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |
50: | x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE |
51: | |
52: | RETURNS |
53: | BOOLEAN |
54: | |

Line 59: (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

55: | HISTORY |
56: | |
57: ==========================================================================*/
58: FUNCTION insert_row
59: (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
60: ,x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE) RETURN BOOLEAN IS
61:
62: l_api_name CONSTANT VARCHAR2 (30) := 'insert_row';
63:

Line 60: ,x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE) RETURN BOOLEAN IS

56: | |
57: ==========================================================================*/
58: FUNCTION insert_row
59: (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
60: ,x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE) RETURN BOOLEAN IS
61:
62: l_api_name CONSTANT VARCHAR2 (30) := 'insert_row';
63:
64: BEGIN

Line 79: SELECT apps.gme_pending_product_lots_s.nextval

75:
76: x_pending_product_lots_rec.creation_date := gme_common_pvt.g_timestamp;
77: x_pending_product_lots_rec.created_by := gme_common_pvt.g_user_ident;
78:
79: SELECT apps.gme_pending_product_lots_s.nextval
80: INTO x_pending_product_lots_rec.PENDING_PRODUCT_LOT_ID
81: FROM sys.dual;
82:
83: INSERT INTO gme_pending_product_lots

Line 83: INSERT INTO gme_pending_product_lots

79: SELECT apps.gme_pending_product_lots_s.nextval
80: INTO x_pending_product_lots_rec.PENDING_PRODUCT_LOT_ID
81: FROM sys.dual;
82:
83: INSERT INTO gme_pending_product_lots
84: (PENDING_PRODUCT_LOT_ID
85: ,SEQUENCE
86: ,BATCH_ID
87: ,MATERIAL_DETAIL_ID

Line 144: | fetch_row will fetch a row in gme_pending_product_lots |

140: | TYPE |
141: | Private |
142: | |
143: | USAGE |
144: | fetch_row will fetch a row in gme_pending_product_lots |
145: | |
146: | DESCRIPTION |
147: | fetch_row will fetch a row in gme_pending_product_lots |
148: | |

Line 147: | fetch_row will fetch a row in gme_pending_product_lots |

143: | USAGE |
144: | fetch_row will fetch a row in gme_pending_product_lots |
145: | |
146: | DESCRIPTION |
147: | fetch_row will fetch a row in gme_pending_product_lots |
148: | |
149: | PARAMETERS |
150: | p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |
151: | x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE |

Line 150: | p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |

146: | DESCRIPTION |
147: | fetch_row will fetch a row in gme_pending_product_lots |
148: | |
149: | PARAMETERS |
150: | p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |
151: | x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE |
152: | |
153: | RETURNS |
154: | BOOLEAN |

Line 151: | x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE |

147: | fetch_row will fetch a row in gme_pending_product_lots |
148: | |
149: | PARAMETERS |
150: | p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |
151: | x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE |
152: | |
153: | RETURNS |
154: | BOOLEAN |
155: | |

Line 161: (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

157: | |
158: ==========================================================================*/
159:
160: FUNCTION fetch_row
161: (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
162: ,x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE) RETURN BOOLEAN IS
163:
164: l_pp_lot_id NUMBER;
165: l_matl_dtl_id NUMBER;

Line 162: ,x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE) RETURN BOOLEAN IS

158: ==========================================================================*/
159:
160: FUNCTION fetch_row
161: (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
162: ,x_pending_product_lots_rec IN OUT NOCOPY gme_pending_product_lots%ROWTYPE) RETURN BOOLEAN IS
163:
164: l_pp_lot_id NUMBER;
165: l_matl_dtl_id NUMBER;
166: l_sequ NUMBER;

Line 182: FROM gme_pending_product_lots

178:
179: IF (l_pp_lot_id IS NOT NULL) THEN
180: SELECT *
181: INTO x_pending_product_lots_rec
182: FROM gme_pending_product_lots
183: WHERE pending_product_lot_id = l_pp_lot_id;
184: ELSIF (l_matl_dtl_id IS NOT NULL) AND
185: (l_sequ IS NOT NULL) THEN
186: SELECT *

Line 188: FROM gme_pending_product_lots

184: ELSIF (l_matl_dtl_id IS NOT NULL) AND
185: (l_sequ IS NOT NULL) THEN
186: SELECT *
187: INTO x_pending_product_lots_rec
188: FROM gme_pending_product_lots
189: WHERE material_detail_id = l_matl_dtl_id
190: AND sequence = l_sequ;
191: ELSE
192: gme_common_pvt.log_message ('GME_NO_KEYS'

Line 231: | delete_row will delete a row in gme_pending_product_lots |

227: | TYPE |
228: | Private |
229: | |
230: | USAGE |
231: | delete_row will delete a row in gme_pending_product_lots |
232: | |
233: | DESCRIPTION |
234: | delete_row will delete a row in gme_pending_product_lots |
235: | |

Line 234: | delete_row will delete a row in gme_pending_product_lots |

230: | USAGE |
231: | delete_row will delete a row in gme_pending_product_lots |
232: | |
233: | DESCRIPTION |
234: | delete_row will delete a row in gme_pending_product_lots |
235: | |
236: | PARAMETERS |
237: | p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |
238: | |

Line 237: | p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |

233: | DESCRIPTION |
234: | delete_row will delete a row in gme_pending_product_lots |
235: | |
236: | PARAMETERS |
237: | p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |
238: | |
239: | RETURNS |
240: | BOOLEAN |
241: | |

Line 246: FUNCTION delete_row (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE) RETURN BOOLEAN IS

242: | HISTORY |
243: | |
244: ==========================================================================*/
245:
246: FUNCTION delete_row (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE) RETURN BOOLEAN IS
247:
248: l_api_name CONSTANT VARCHAR2 (30) := 'delete_row';
249:
250: locked_by_other_user EXCEPTION;

Line 271: FROM gme_pending_product_lots

267:
268: IF (l_pp_lot_id IS NOT NULL) THEN
269: SELECT 1
270: INTO l_dummy
271: FROM gme_pending_product_lots
272: WHERE pending_product_lot_id = l_pp_lot_id
273: FOR UPDATE NOWAIT;
274:
275: DELETE

Line 276: FROM gme_pending_product_lots

272: WHERE pending_product_lot_id = l_pp_lot_id
273: FOR UPDATE NOWAIT;
274:
275: DELETE
276: FROM gme_pending_product_lots
277: WHERE pending_product_lot_id = l_pp_lot_id;
278:
279: ELSIF (l_matl_dtl_id IS NOT NULL) AND
280: (l_sequ IS NOT NULL) THEN

Line 283: FROM gme_pending_product_lots

279: ELSIF (l_matl_dtl_id IS NOT NULL) AND
280: (l_sequ IS NOT NULL) THEN
281: SELECT 1
282: INTO l_dummy
283: FROM gme_pending_product_lots
284: WHERE material_detail_id = l_matl_dtl_id
285: AND sequence = l_sequ
286: FOR UPDATE NOWAIT;
287:

Line 289: FROM gme_pending_product_lots

285: AND sequence = l_sequ
286: FOR UPDATE NOWAIT;
287:
288: DELETE
289: FROM gme_pending_product_lots
290: WHERE material_detail_id = l_matl_dtl_id
291: AND sequence = l_sequ;
292: ELSE
293: gme_common_pvt.log_message ('GME_NO_KEYS'

Line 351: | update_row will update a row in gme_pending_product_lots |

347: | TYPE |
348: | Private |
349: | |
350: | USAGE |
351: | update_row will update a row in gme_pending_product_lots |
352: | |
353: | DESCRIPTION |
354: | update_row will update a row in gme_pending_product_lots |
355: | |

Line 354: | update_row will update a row in gme_pending_product_lots |

350: | USAGE |
351: | update_row will update a row in gme_pending_product_lots |
352: | |
353: | DESCRIPTION |
354: | update_row will update a row in gme_pending_product_lots |
355: | |
356: | PARAMETERS |
357: | p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |
358: | |

Line 357: | p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |

353: | DESCRIPTION |
354: | update_row will update a row in gme_pending_product_lots |
355: | |
356: | PARAMETERS |
357: | p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |
358: | |
359: | RETURNS |
360: | BOOLEAN |
361: | |

Line 365: FUNCTION update_row (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE) RETURN BOOLEAN IS

361: | |
362: | HISTORY |
363: | |
364: ==========================================================================*/
365: FUNCTION update_row (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE) RETURN BOOLEAN IS
366: l_dummy NUMBER := 0;
367:
368: locked_by_other_user EXCEPTION;
369: PRAGMA EXCEPTION_INIT (locked_by_other_user, -54);

Line 375: l_pp_lot_rec gme_pending_product_lots%ROWTYPE;

371:
372: l_pp_lot_id NUMBER;
373: l_matl_dtl_id NUMBER;
374: l_sequ NUMBER;
375: l_pp_lot_rec gme_pending_product_lots%ROWTYPE;
376:
377: BEGIN
378:
379: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

Line 396: FROM gme_pending_product_lots

392:
393: IF (l_pp_lot_id IS NOT NULL) THEN
394: SELECT 1
395: INTO l_dummy
396: FROM gme_pending_product_lots
397: WHERE pending_product_lot_id = l_pp_lot_id
398: FOR UPDATE NOWAIT;
399: /* Bug 5193154 added lot number*/
400: UPDATE gme_pending_product_lots

Line 400: UPDATE gme_pending_product_lots

396: FROM gme_pending_product_lots
397: WHERE pending_product_lot_id = l_pp_lot_id
398: FOR UPDATE NOWAIT;
399: /* Bug 5193154 added lot number*/
400: UPDATE gme_pending_product_lots
401: SET SEQUENCE = l_pp_lot_rec.SEQUENCE
402: ,LOT_NUMBER = l_pp_lot_rec.LOT_NUMBER
403: ,REVISION = l_pp_lot_rec.REVISION
404: ,QUANTITY = l_pp_lot_rec.QUANTITY

Line 417: FROM gme_pending_product_lots

413: ELSIF (l_matl_dtl_id IS NOT NULL) AND
414: (l_sequ IS NOT NULL) THEN
415: SELECT 1
416: INTO l_dummy
417: FROM gme_pending_product_lots
418: WHERE material_detail_id = l_matl_dtl_id
419: AND sequence = l_sequ
420: FOR UPDATE NOWAIT;
421:

Line 422: UPDATE gme_pending_product_lots

418: WHERE material_detail_id = l_matl_dtl_id
419: AND sequence = l_sequ
420: FOR UPDATE NOWAIT;
421:
422: UPDATE gme_pending_product_lots
423: SET SEQUENCE = l_pp_lot_rec.SEQUENCE
424: ,REVISION = l_pp_lot_rec.REVISION
425: ,QUANTITY = l_pp_lot_rec.QUANTITY
426: ,SECONDARY_QUANTITY = l_pp_lot_rec.SECONDARY_QUANTITY

Line 490: | lock_row will lock a row in gme_pending_product_lots |

486: | TYPE |
487: | Private |
488: | |
489: | USAGE |
490: | lock_row will lock a row in gme_pending_product_lots |
491: | |
492: | DESCRIPTION |
493: | lock_row will lock a row in gme_pending_product_lots |
494: | |

Line 493: | lock_row will lock a row in gme_pending_product_lots |

489: | USAGE |
490: | lock_row will lock a row in gme_pending_product_lots |
491: | |
492: | DESCRIPTION |
493: | lock_row will lock a row in gme_pending_product_lots |
494: | |
495: | PARAMETERS |
496: | p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |
497: | |

Line 496: | p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |

492: | DESCRIPTION |
493: | lock_row will lock a row in gme_pending_product_lots |
494: | |
495: | PARAMETERS |
496: | p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE |
497: | |
498: | RETURNS |
499: | BOOLEAN |
500: | |

Line 504: FUNCTION lock_row (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE) RETURN BOOLEAN IS

500: | |
501: | HISTORY |
502: | |
503: ==========================================================================*/
504: FUNCTION lock_row (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE) RETURN BOOLEAN IS
505: l_dummy NUMBER := 0;
506:
507: locked_by_other_user EXCEPTION;
508: PRAGMA EXCEPTION_INIT (locked_by_other_user, -54);

Line 528: FROM gme_pending_product_lots

524:
525: IF (l_pp_lot_id IS NOT NULL) THEN
526: SELECT 1
527: INTO l_dummy
528: FROM gme_pending_product_lots
529: WHERE pending_product_lot_id = l_pp_lot_id
530: FOR UPDATE NOWAIT;
531:
532: ELSIF (l_matl_dtl_id IS NOT NULL) AND

Line 536: FROM gme_pending_product_lots

532: ELSIF (l_matl_dtl_id IS NOT NULL) AND
533: (l_sequ IS NOT NULL) THEN
534: SELECT 1
535: INTO l_dummy
536: FROM gme_pending_product_lots
537: WHERE material_detail_id = l_matl_dtl_id
538: AND sequence = l_sequ
539: FOR UPDATE NOWAIT;
540: ELSE

Line 570: END gme_pending_product_lots_dbl;

566: END IF;
567:
568: RETURN FALSE;
569: END lock_row;
570: END gme_pending_product_lots_dbl;