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_TRANSFERS_DBL dependencies on GME_BATCH_STEP_TRANSFERS

Line 1: PACKAGE BODY gme_batch_step_transfers_dbl AS

1: PACKAGE BODY gme_batch_step_transfers_dbl AS
2: /* $Header: GMEVGSTB.pls 120.1 2005/06/03 13:47:29 appldev $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_STEP_TRANSFERS';

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

1: PACKAGE BODY gme_batch_step_transfers_dbl AS
2: /* $Header: GMEVGSTB.pls 120.1 2005/06/03 13:47:29 appldev $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_STEP_TRANSFERS';
6:
7: /*============================================================================
8: | Copyright (c) 2001 Oracle Corporation
9: | TVP, Reading

Line 42: | Insert_Row will insert a row in gme_batch_step_transfers

Line 46: | Insert_Row will insert a row in gme_batch_step_transfers

42: | Insert_Row will insert a row in gme_batch_step_transfers
43: |
44: |
45: | DESCRIPTION
46: | Insert_Row will insert a row in gme_batch_step_transfers
47: |
48: |
49: |
50: | PARAMETERS

Line 51: | p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE

47: |
48: |
49: |
50: | PARAMETERS
51: | p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE
52: | x_batch_step_transfers IN OUT NOCOPY gme_batch_step_transfers%ROWTYPE
53: |
54: | RETURNS
55: | BOOLEAN

Line 52: | x_batch_step_transfers IN OUT NOCOPY gme_batch_step_transfers%ROWTYPE

Line 64: p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE

60: +=============================================================================
61: Api end of comments
62: */
63: FUNCTION insert_row (
64: p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE
65: ,x_batch_step_transfers IN OUT NOCOPY gme_batch_step_transfers%ROWTYPE)
66: RETURN BOOLEAN
67: IS
68: BEGIN

Line 65: ,x_batch_step_transfers IN OUT NOCOPY gme_batch_step_transfers%ROWTYPE)

61: Api end of comments
62: */
63: FUNCTION insert_row (
64: p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE
65: ,x_batch_step_transfers IN OUT NOCOPY gme_batch_step_transfers%ROWTYPE)
66: RETURN BOOLEAN
67: IS
68: BEGIN
69: x_batch_step_transfers := p_batch_step_transfers;

Line 71: INSERT INTO gme_batch_step_transfers

67: IS
68: BEGIN
69: x_batch_step_transfers := p_batch_step_transfers;
70:
71: INSERT INTO gme_batch_step_transfers
72: (wip_trans_id
73: ,batch_id
74: ,batchstep_no
75: ,transfer_step_no

Line 183: | Fetch_Row will fetch a row in gme_batch_step_transfers

Line 187: | Fetch_Row will fetch a row in gme_batch_step_transfers

183: | Fetch_Row will fetch a row in gme_batch_step_transfers
184: |
185: |
186: | DESCRIPTION
187: | Fetch_Row will fetch a row in gme_batch_step_transfers
188: |
189: |
190: |
191: | PARAMETERS

Line 192: | p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE

188: |
189: |
190: |
191: | PARAMETERS
192: | p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE
193: | x_batch_step_transfers IN OUT NOCOPY gme_batch_step_transfers%ROWTYPE
194: |
195: | RETURNS
196: | BOOLEAN

Line 193: | x_batch_step_transfers IN OUT NOCOPY gme_batch_step_transfers%ROWTYPE

Line 206: p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE

202: +=============================================================================
203: Api end of comments
204: */
205: FUNCTION fetch_row (
206: p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE
207: ,x_batch_step_transfers IN OUT NOCOPY gme_batch_step_transfers%ROWTYPE)
208: RETURN BOOLEAN
209: IS
210: BEGIN

Line 207: ,x_batch_step_transfers IN OUT NOCOPY gme_batch_step_transfers%ROWTYPE)

203: Api end of comments
204: */
205: FUNCTION fetch_row (
206: p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE
207: ,x_batch_step_transfers IN OUT NOCOPY gme_batch_step_transfers%ROWTYPE)
208: RETURN BOOLEAN
209: IS
210: BEGIN
211: IF p_batch_step_transfers.wip_trans_id IS NOT NULL THEN

Line 304: FROM gme_batch_step_transfers

300: ,x_batch_step_transfers.attribute28
301: ,x_batch_step_transfers.attribute29
302: ,x_batch_step_transfers.attribute30
303: ,x_batch_step_transfers.attribute_category
304: FROM gme_batch_step_transfers
305: WHERE wip_trans_id = p_batch_step_transfers.wip_trans_id;
306: ELSE
307: gme_common_pvt.log_message ('GME_NO_KEYS'
308: ,'TABLE_NAME'

Line 334: | Delete_Row will delete a row in gme_batch_step_transfers

Line 338: | Delete_Row will delete a row in gme_batch_step_transfers

334: | Delete_Row will delete a row in gme_batch_step_transfers
335: |
336: |
337: | DESCRIPTION
338: | Delete_Row will delete a row in gme_batch_step_transfers
339: |
340: |
341: |
342: | PARAMETERS

Line 343: | p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE

339: |
340: |
341: |
342: | PARAMETERS
343: | p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE
344: |
345: | RETURNS
346: | BOOLEAN
347: | HISTORY

Line 356: p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE)

352: +=============================================================================
353: Api end of comments
354: */
355: FUNCTION delete_row (
356: p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE)
357: RETURN BOOLEAN
358: IS
359: l_dummy NUMBER (5) := 0;
360: locked_by_other_user EXCEPTION;

Line 366: FROM gme_batch_step_transfers

362: BEGIN
363: IF p_batch_step_transfers.wip_trans_id IS NOT NULL THEN
364: SELECT 1
365: INTO l_dummy
366: FROM gme_batch_step_transfers
367: WHERE wip_trans_id = p_batch_step_transfers.wip_trans_id
368: FOR UPDATE NOWAIT;
369:
370: UPDATE gme_batch_step_transfers

Line 370: UPDATE gme_batch_step_transfers

366: FROM gme_batch_step_transfers
367: WHERE wip_trans_id = p_batch_step_transfers.wip_trans_id
368: FOR UPDATE NOWAIT;
369:
370: UPDATE gme_batch_step_transfers
371: SET delete_mark = 1
372: WHERE wip_trans_id = p_batch_step_transfers.wip_trans_id;
373: ELSE
374: gme_common_pvt.log_message ('GME_NO_KEYS'

Line 432: | Update_Row will update a row in gme_batch_step_transfers

Line 436: | Update_Row will update a row in gme_batch_step_transfers

432: | Update_Row will update a row in gme_batch_step_transfers
433: |
434: |
435: | DESCRIPTION
436: | Update_Row will update a row in gme_batch_step_transfers
437: |
438: |
439: |
440: | PARAMETERS

Line 441: | p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE

437: |
438: |
439: |
440: | PARAMETERS
441: | p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE
442: |
443: | RETURNS
444: | BOOLEAN
445: | HISTORY

Line 455: p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE)

451: +=============================================================================
452: Api end of comments
453: */
454: FUNCTION update_row (
455: p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE)
456: RETURN BOOLEAN
457: IS
458: l_dummy NUMBER;
459: locked_by_other_user EXCEPTION;

Line 465: FROM gme_batch_step_transfers

461: BEGIN
462: IF p_batch_step_transfers.wip_trans_id IS NOT NULL THEN
463: SELECT 1
464: INTO l_dummy
465: FROM gme_batch_step_transfers
466: WHERE wip_trans_id = p_batch_step_transfers.wip_trans_id
467: FOR UPDATE NOWAIT;
468:
469: UPDATE gme_batch_step_transfers

Line 469: UPDATE gme_batch_step_transfers

465: FROM gme_batch_step_transfers
466: WHERE wip_trans_id = p_batch_step_transfers.wip_trans_id
467: FOR UPDATE NOWAIT;
468:
469: UPDATE gme_batch_step_transfers
470: SET batch_id = p_batch_step_transfers.batch_id
471: ,batchstep_no = p_batch_step_transfers.batchstep_no
472: ,transfer_step_no = p_batch_step_transfers.transfer_step_no
473: ,line_type = p_batch_step_transfers.line_type

Line 574: | Lock_Row will lock a row in gme_batch_step_transfers

Line 578: | Lock_Row will lock a row in gme_batch_step_transfers

574: | Lock_Row will lock a row in gme_batch_step_transfers
575: |
576: |
577: | DESCRIPTION
578: | Lock_Row will lock a row in gme_batch_step_transfers
579: |
580: |
581: |
582: | PARAMETERS

Line 583: | p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE

579: |
580: |
581: |
582: | PARAMETERS
583: | p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE
584: |
585: | RETURNS
586: | BOOLEAN
587: | HISTORY

Line 596: p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE)

592: +=============================================================================
593: Api end of comments
594: */
595: FUNCTION lock_row (
596: p_batch_step_transfers IN gme_batch_step_transfers%ROWTYPE)
597: RETURN BOOLEAN
598: IS
599: l_dummy NUMBER;
600: BEGIN

Line 604: FROM gme_batch_step_transfers

600: BEGIN
601: IF p_batch_step_transfers.wip_trans_id IS NOT NULL THEN
602: SELECT 1
603: INTO l_dummy
604: FROM gme_batch_step_transfers
605: WHERE wip_trans_id = p_batch_step_transfers.wip_trans_id
606: FOR UPDATE NOWAIT;
607: END IF;
608:

Line 624: END gme_batch_step_transfers_dbl;

620: RETURN FALSE;
621: WHEN OTHERS THEN
622: RETURN FALSE;
623: END lock_row;
624: END gme_batch_step_transfers_dbl;