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_BATCH_STEP_ITEMS_DBL dependencies on GME_BATCH_STEP_ITEMS

Line 1: PACKAGE BODY gme_batch_step_items_dbl AS

1: PACKAGE BODY gme_batch_step_items_dbl AS
2: /* $Header: GMEVGSIB.pls 120.2.12010000.1 2008/07/25 10:30:53 appldev ship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_STEP_ITEMS';

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

1: PACKAGE BODY gme_batch_step_items_dbl AS
2: /* $Header: GMEVGSIB.pls 120.2.12010000.1 2008/07/25 10:30:53 appldev ship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_STEP_ITEMS';
6: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
7: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_BATCH_STEP_ITEMS_DBL';
8:
9: /*============================================================================

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

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

Line 44: | Insert_Row will insert a row in gme_batch_step_items

Line 48: | Insert_Row will insert a row in gme_batch_step_items

44: | Insert_Row will insert a row in gme_batch_step_items
45: |
46: |
47: | DESCRIPTION
48: | Insert_Row will insert a row in gme_batch_step_items
49: |
50: |
51: |
52: | PARAMETERS

Line 53: | p_batch_step_items IN gme_batch_step_items%ROWTYPE

49: |
50: |
51: |
52: | PARAMETERS
53: | p_batch_step_items IN gme_batch_step_items%ROWTYPE
54: | x_batch_step_items IN OUT NOCOPY gme_batch_step_items%ROWTYPE
55: |
56: | RETURNS
57: | BOOLEAN

Line 54: | x_batch_step_items IN OUT NOCOPY gme_batch_step_items%ROWTYPE

Line 70: p_batch_step_items IN gme_batch_step_items%ROWTYPE

66: +=============================================================================
67: Api end of comments
68: */
69: FUNCTION insert_row (
70: p_batch_step_items IN gme_batch_step_items%ROWTYPE
71: ,x_batch_step_items IN OUT NOCOPY gme_batch_step_items%ROWTYPE)
72: RETURN BOOLEAN
73: IS
74: l_api_name CONSTANT VARCHAR2 (30) := 'insert_row';

Line 71: ,x_batch_step_items IN OUT NOCOPY gme_batch_step_items%ROWTYPE)

67: Api end of comments
68: */
69: FUNCTION insert_row (
70: p_batch_step_items IN gme_batch_step_items%ROWTYPE
71: ,x_batch_step_items IN OUT NOCOPY gme_batch_step_items%ROWTYPE)
72: RETURN BOOLEAN
73: IS
74: l_api_name CONSTANT VARCHAR2 (30) := 'insert_row';
75: BEGIN

Line 83: INSERT INTO gme_batch_step_items

79: END IF;
80:
81: x_batch_step_items := p_batch_step_items;
82:
83: INSERT INTO gme_batch_step_items
84: (material_detail_id
85: ,batch_id
86: ,batchstep_id
87: ,text_code

Line 193: | Fetch_Row will fetch a row in gme_batch_step_items

Line 197: | Fetch_Row will fetch a row in gme_batch_step_items

193: | Fetch_Row will fetch a row in gme_batch_step_items
194: |
195: |
196: | DESCRIPTION
197: | Fetch_Row will fetch a row in gme_batch_step_items
198: |
199: |
200: |
201: | PARAMETERS

Line 202: | p_batch_step_items IN gme_batch_step_items%ROWTYPE

198: |
199: |
200: |
201: | PARAMETERS
202: | p_batch_step_items IN gme_batch_step_items%ROWTYPE
203: | x_batch_step_items IN OUT NOCOPY gme_batch_step_items%ROWTYPE
204: |
205: | RETURNS
206: | BOOLEAN

Line 203: | x_batch_step_items IN OUT NOCOPY gme_batch_step_items%ROWTYPE

Line 220: p_batch_step_items IN gme_batch_step_items%ROWTYPE

216: +=============================================================================
217: Api end of comments
218: */
219: FUNCTION fetch_row (
220: p_batch_step_items IN gme_batch_step_items%ROWTYPE
221: ,x_batch_step_items IN OUT NOCOPY gme_batch_step_items%ROWTYPE)
222: RETURN BOOLEAN
223: IS
224: l_api_name CONSTANT VARCHAR2 (30) := 'fetch_row';

Line 221: ,x_batch_step_items IN OUT NOCOPY gme_batch_step_items%ROWTYPE)

217: Api end of comments
218: */
219: FUNCTION fetch_row (
220: p_batch_step_items IN gme_batch_step_items%ROWTYPE
221: ,x_batch_step_items IN OUT NOCOPY gme_batch_step_items%ROWTYPE)
222: RETURN BOOLEAN
223: IS
224: l_api_name CONSTANT VARCHAR2 (30) := 'fetch_row';
225: BEGIN

Line 320: FROM gme_batch_step_items

316: ,x_batch_step_items.last_update_date
317: ,x_batch_step_items.last_updated_by
318: ,x_batch_step_items.creation_date
319: ,x_batch_step_items.created_by
320: FROM gme_batch_step_items
321: WHERE material_detail_id = p_batch_step_items.material_detail_id;
322: ELSE
323: gme_common_pvt.log_message ('GME_NO_KEYS'
324: ,'TABLE_NAME'

Line 358: | Delete_Row will delete a row in gme_batch_step_items

Line 362: | Delete_Row will delete a row in gme_batch_step_items

358: | Delete_Row will delete a row in gme_batch_step_items
359: |
360: |
361: | DESCRIPTION
362: | Delete_Row will delete a row in gme_batch_step_items
363: |
364: |
365: |
366: | PARAMETERS

Line 367: | p_batch_step_items IN gme_batch_step_items%ROWTYPE

363: |
364: |
365: |
366: | PARAMETERS
367: | p_batch_step_items IN gme_batch_step_items%ROWTYPE
368: |
369: | RETURNS
370: | BOOLEAN
371: | HISTORY

Line 380: FUNCTION delete_row (p_batch_step_items IN gme_batch_step_items%ROWTYPE)

376: |
377: +=============================================================================
378: Api end of comments
379: */
380: FUNCTION delete_row (p_batch_step_items IN gme_batch_step_items%ROWTYPE)
381: RETURN BOOLEAN
382: IS
383: l_dummy NUMBER := 0;
384: locked_by_other_user EXCEPTION;

Line 396: FROM gme_batch_step_items

392:
393: IF p_batch_step_items.material_detail_id IS NOT NULL THEN
394: SELECT 1
395: INTO l_dummy
396: FROM gme_batch_step_items
397: WHERE material_detail_id = p_batch_step_items.material_detail_id
398: FOR UPDATE NOWAIT;
399:
400: DELETE FROM gme_batch_step_items

Line 400: DELETE FROM gme_batch_step_items

396: FROM gme_batch_step_items
397: WHERE material_detail_id = p_batch_step_items.material_detail_id
398: FOR UPDATE NOWAIT;
399:
400: DELETE FROM gme_batch_step_items
401: WHERE material_detail_id =
402: p_batch_step_items.material_detail_id;
403: ELSE
404: gme_common_pvt.log_message ('GME_NO_KEYS'

Line 470: | Update_Row will update a row in gme_batch_step_items

Line 474: | Update_Row will update a row in gme_batch_step_items

470: | Update_Row will update a row in gme_batch_step_items
471: |
472: |
473: | DESCRIPTION
474: | Update_Row will update a row in gme_batch_step_items
475: |
476: |
477: |
478: | PARAMETERS

Line 479: | p_batch_step_items IN gme_batch_step_items%ROWTYPE

475: |
476: |
477: |
478: | PARAMETERS
479: | p_batch_step_items IN gme_batch_step_items%ROWTYPE
480: |
481: | RETURNS
482: | BOOLEAN
483: | HISTORY

Line 495: FUNCTION update_row (p_batch_step_items IN gme_batch_step_items%ROWTYPE)

491: |
492: +=============================================================================
493: Api end of comments
494: */
495: FUNCTION update_row (p_batch_step_items IN gme_batch_step_items%ROWTYPE)
496: RETURN BOOLEAN
497: IS
498: l_dummy NUMBER (5) := 0;
499: locked_by_other_user EXCEPTION;

Line 511: FROM gme_batch_step_items

507:
508: IF p_batch_step_items.material_detail_id IS NOT NULL THEN
509: SELECT 1
510: INTO l_dummy
511: FROM gme_batch_step_items
512: WHERE material_detail_id = p_batch_step_items.material_detail_id
513: FOR UPDATE NOWAIT;
514:
515: UPDATE gme_batch_step_items

Line 515: UPDATE gme_batch_step_items

511: FROM gme_batch_step_items
512: WHERE material_detail_id = p_batch_step_items.material_detail_id
513: FOR UPDATE NOWAIT;
514:
515: UPDATE gme_batch_step_items
516: SET batch_id = p_batch_step_items.batch_id
517: ,batchstep_id = p_batch_step_items.batchstep_id
518: ,text_code = p_batch_step_items.text_code
519: ,minimum_transfer_qty = p_batch_step_items.minimum_transfer_qty

Line 626: | Lock_Row will lock a row in gme_batch_step_items

Line 630: | Lock_Row will lock a row in gme_batch_step_items

626: | Lock_Row will lock a row in gme_batch_step_items
627: |
628: |
629: | DESCRIPTION
630: | Lock_Row will lock a row in gme_batch_step_items
631: |
632: |
633: |
634: | PARAMETERS

Line 635: | p_batch_step_items IN gme_batch_step_items%ROWTYPE

631: |
632: |
633: |
634: | PARAMETERS
635: | p_batch_step_items IN gme_batch_step_items%ROWTYPE
636: |
637: | RETURNS
638: | BOOLEAN
639: | HISTORY

Line 647: FUNCTION lock_row (p_batch_step_items IN gme_batch_step_items%ROWTYPE)

643: |
644: +=============================================================================
645: Api end of comments
646: */
647: FUNCTION lock_row (p_batch_step_items IN gme_batch_step_items%ROWTYPE)
648: RETURN BOOLEAN
649: IS
650: l_dummy NUMBER;
651: l_api_name CONSTANT VARCHAR2 (30) := 'lock_row';

Line 661: FROM gme_batch_step_items

657:
658: IF p_batch_step_items.material_detail_id IS NOT NULL THEN
659: SELECT 1
660: INTO l_dummy
661: FROM gme_batch_step_items
662: WHERE material_detail_id = p_batch_step_items.material_detail_id
663: FOR UPDATE NOWAIT;
664: END IF;
665:

Line 690: END gme_batch_step_items_dbl;

686: END IF;
687:
688: RETURN FALSE;
689: END lock_row;
690: END gme_batch_step_items_dbl;