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_ACTIVITIES_DBL dependencies on GME_BATCH_STEP_ACTIVITIES

Line 1: PACKAGE BODY gme_batch_step_activities_dbl AS

1: PACKAGE BODY gme_batch_step_activities_dbl AS
2: /* $Header: GMEVGSAB.pls 120.1 2005/06/03 10:59:59 appldev $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_STEP_ACTIVITIES';

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

1: PACKAGE BODY gme_batch_step_activities_dbl AS
2: /* $Header: GMEVGSAB.pls 120.1 2005/06/03 10:59:59 appldev $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_STEP_ACTIVITIES';
6: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
7: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_BATCH_STEP_ACTIVITIES_DBL';
8:
9: /*============================================================================

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

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

Line 48: | Insert_Row will insert a row in gme_batch_step_activities

Line 52: | Insert_Row will insert a row in gme_batch_step_activities

48: | Insert_Row will insert a row in gme_batch_step_activities
49: |
50: |
51: | DESCRIPTION
52: | Insert_Row will insert a row in gme_batch_step_activities
53: |
54: |
55: |
56: | PARAMETERS

Line 57: | p_batch_step_activities IN gme_batch_step_activities%ROWTYPE

53: |
54: |
55: |
56: | PARAMETERS
57: | p_batch_step_activities IN gme_batch_step_activities%ROWTYPE
58: | x_batch_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE
59: |
60: | RETURNS
61: | BOOLEAN

Line 58: | x_batch_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE

Line 73: p_batch_step_activities IN gme_batch_step_activities%ROWTYPE

69: +=============================================================================
70: Api end of comments
71: */
72: FUNCTION insert_row (
73: p_batch_step_activities IN gme_batch_step_activities%ROWTYPE
74: ,x_batch_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE)
75: RETURN BOOLEAN
76: IS
77: l_api_name CONSTANT VARCHAR2 (30) := 'insert_row';

Line 74: ,x_batch_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE)

70: Api end of comments
71: */
72: FUNCTION insert_row (
73: p_batch_step_activities IN gme_batch_step_activities%ROWTYPE
74: ,x_batch_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE)
75: RETURN BOOLEAN
76: IS
77: l_api_name CONSTANT VARCHAR2 (30) := 'insert_row';
78: BEGIN

Line 86: INSERT INTO gme_batch_step_activities

82: END IF;
83:
84: x_batch_step_activities := p_batch_step_activities;
85:
86: INSERT INTO gme_batch_step_activities
87: (batch_id
88: ,activity
89: ,batchstep_id
90: ,batchstep_activity_id

Line 228: | Fetch_Row will fetch a row in gme_batch_step_activities

Line 232: | Fetch_Row will fetch a row in gme_batch_step_activities

228: | Fetch_Row will fetch a row in gme_batch_step_activities
229: |
230: |
231: | DESCRIPTION
232: | Fetch_Row will fetch a row in gme_batch_step_activities
233: |
234: |
235: |
236: | PARAMETERS

Line 237: | p_batch_step_activities IN gme_batch_step_activities%ROWTYPE

233: |
234: |
235: |
236: | PARAMETERS
237: | p_batch_step_activities IN gme_batch_step_activities%ROWTYPE
238: | x_batch_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE
239: |
240: | RETURNS
241: | BOOLEAN

Line 238: | x_batch_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE

Line 254: p_batch_step_activities IN gme_batch_step_activities%ROWTYPE

250: +=============================================================================
251: Api end of comments
252: */
253: FUNCTION fetch_row (
254: p_batch_step_activities IN gme_batch_step_activities%ROWTYPE
255: ,x_batch_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE)
256: RETURN BOOLEAN
257: IS
258: l_api_name CONSTANT VARCHAR2 (30) := 'fetch_row';

Line 255: ,x_batch_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE)

251: Api end of comments
252: */
253: FUNCTION fetch_row (
254: p_batch_step_activities IN gme_batch_step_activities%ROWTYPE
255: ,x_batch_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE)
256: RETURN BOOLEAN
257: IS
258: l_api_name CONSTANT VARCHAR2 (30) := 'fetch_row';
259: BEGIN

Line 378: FROM gme_batch_step_activities

374: --rishi 3372774 06-FEB-2004 start
375: , x_batch_step_activities.break_ind
376: ,x_batch_step_activities.max_break
377: --rishi 3372774 06-FEB-2004 end
378: FROM gme_batch_step_activities
379: WHERE batchstep_activity_id =
380: p_batch_step_activities.batchstep_activity_id;
381: ELSIF p_batch_step_activities.batch_id IS NOT NULL
382: AND p_batch_step_activities.batchstep_id IS NOT NULL

Line 496: FROM gme_batch_step_activities

492: --rishi 3372774 06-FEB-2004 start
493: , x_batch_step_activities.break_ind
494: ,x_batch_step_activities.max_break
495: --rishi 3372774 06-FEB-2004 end
496: FROM gme_batch_step_activities
497: WHERE batch_id = p_batch_step_activities.batch_id
498: AND batchstep_id = p_batch_step_activities.batchstep_id
499: AND activity = p_batch_step_activities.activity;
500: ELSE

Line 536: | Delete_Row will delete a row in gme_batch_step_activities

Line 540: | Delete_Row will delete a row in gme_batch_step_activities

536: | Delete_Row will delete a row in gme_batch_step_activities
537: |
538: |
539: | DESCRIPTION
540: | Delete_Row will delete a row in gme_batch_step_activities
541: |
542: |
543: |
544: | PARAMETERS

Line 545: | p_batch_step_activities IN gme_batch_step_activities%ROWTYPE

541: |
542: |
543: |
544: | PARAMETERS
545: | p_batch_step_activities IN gme_batch_step_activities%ROWTYPE
546: |
547: | RETURNS
548: | BOOLEAN
549: | HISTORY

Line 558: p_batch_step_activities IN gme_batch_step_activities%ROWTYPE)

554: +=============================================================================
555: Api end of comments
556: */
557: FUNCTION delete_row (
558: p_batch_step_activities IN gme_batch_step_activities%ROWTYPE)
559: RETURN BOOLEAN
560: IS
561: l_dummy NUMBER := 0;
562: locked_by_other_user EXCEPTION;

Line 574: FROM gme_batch_step_activities

570:
571: IF p_batch_step_activities.batchstep_activity_id IS NOT NULL THEN
572: SELECT 1
573: INTO l_dummy
574: FROM gme_batch_step_activities
575: WHERE batchstep_activity_id =
576: p_batch_step_activities.batchstep_activity_id
577: FOR UPDATE NOWAIT;
578:

Line 579: DELETE FROM gme_batch_step_activities

575: WHERE batchstep_activity_id =
576: p_batch_step_activities.batchstep_activity_id
577: FOR UPDATE NOWAIT;
578:
579: DELETE FROM gme_batch_step_activities
580: WHERE batchstep_activity_id =
581: p_batch_step_activities.batchstep_activity_id;
582: ELSIF p_batch_step_activities.batch_id IS NOT NULL
583: AND p_batch_step_activities.batchstep_id IS NOT NULL

Line 587: FROM gme_batch_step_activities

583: AND p_batch_step_activities.batchstep_id IS NOT NULL
584: AND p_batch_step_activities.activity IS NOT NULL THEN
585: SELECT 1
586: INTO l_dummy
587: FROM gme_batch_step_activities
588: WHERE batch_id = p_batch_step_activities.batch_id
589: AND batchstep_id = p_batch_step_activities.batchstep_id
590: AND activity = p_batch_step_activities.activity
591: FOR UPDATE NOWAIT;

Line 593: DELETE FROM gme_batch_step_activities

589: AND batchstep_id = p_batch_step_activities.batchstep_id
590: AND activity = p_batch_step_activities.activity
591: FOR UPDATE NOWAIT;
592:
593: DELETE FROM gme_batch_step_activities
594: WHERE batch_id = p_batch_step_activities.batch_id
595: AND batchstep_id = p_batch_step_activities.batchstep_id
596: AND activity = p_batch_step_activities.activity;
597: ELSE

Line 651: | Update_Row will update a row in gme_batch_step_activities

Line 655: | Update_Row will update a row in gme_batch_step_activities

651: | Update_Row will update a row in gme_batch_step_activities
652: |
653: |
654: | DESCRIPTION
655: | Update_Row will update a row in gme_batch_step_activities
656: |
657: |
658: |
659: | PARAMETERS

Line 660: | p_batch_step_activities IN gme_batch_step_activities%ROWTYPE

656: |
657: |
658: |
659: | PARAMETERS
660: | p_batch_step_activities IN gme_batch_step_activities%ROWTYPE
661: |
662: | RETURNS
663: | BOOLEAN
664: | HISTORY

Line 674: p_batch_step_activities IN gme_batch_step_activities%ROWTYPE)

670: +=============================================================================
671: Api end of comments
672: */
673: FUNCTION update_row (
674: p_batch_step_activities IN gme_batch_step_activities%ROWTYPE)
675: RETURN BOOLEAN
676: IS
677: l_dummy NUMBER := 0;
678: locked_by_other_user EXCEPTION;

Line 690: FROM gme_batch_step_activities

686:
687: IF p_batch_step_activities.batchstep_activity_id IS NOT NULL THEN
688: SELECT 1
689: INTO l_dummy
690: FROM gme_batch_step_activities
691: WHERE batchstep_activity_id =
692: p_batch_step_activities.batchstep_activity_id
693: FOR UPDATE NOWAIT;
694:

Line 695: UPDATE gme_batch_step_activities

691: WHERE batchstep_activity_id =
692: p_batch_step_activities.batchstep_activity_id
693: FOR UPDATE NOWAIT;
694:
695: UPDATE gme_batch_step_activities
696: SET batch_id = p_batch_step_activities.batch_id
697: ,activity = p_batch_step_activities.activity
698: ,batchstep_id = p_batch_step_activities.batchstep_id
699: ,oprn_line_id = p_batch_step_activities.oprn_line_id

Line 761: FROM gme_batch_step_activities

757: AND p_batch_step_activities.batchstep_id IS NOT NULL
758: AND p_batch_step_activities.activity IS NOT NULL THEN
759: SELECT 1
760: INTO l_dummy
761: FROM gme_batch_step_activities
762: WHERE batch_id = p_batch_step_activities.batch_id
763: AND batchstep_id = p_batch_step_activities.batchstep_id
764: AND activity = p_batch_step_activities.activity
765: FOR UPDATE NOWAIT;

Line 767: UPDATE gme_batch_step_activities

763: AND batchstep_id = p_batch_step_activities.batchstep_id
764: AND activity = p_batch_step_activities.activity
765: FOR UPDATE NOWAIT;
766:
767: UPDATE gme_batch_step_activities
768: SET batch_id = p_batch_step_activities.batch_id
769: ,activity = p_batch_step_activities.activity
770: ,batchstep_id = p_batch_step_activities.batchstep_id
771: ,oprn_line_id = p_batch_step_activities.oprn_line_id

Line 895: | Lock_Row will lock a row in gme_batch_step_activities

Line 899: | Lock_Row will lock a row in gme_batch_step_activities

895: | Lock_Row will lock a row in gme_batch_step_activities
896: |
897: |
898: | DESCRIPTION
899: | Lock_Row will lock a row in gme_batch_step_activities
900: |
901: |
902: |
903: | PARAMETERS

Line 904: | p_batch_step_activities IN gme_batch_step_activities%ROWTYPE

900: |
901: |
902: |
903: | PARAMETERS
904: | p_batch_step_activities IN gme_batch_step_activities%ROWTYPE
905: |
906: | RETURNS
907: | BOOLEAN
908: | HISTORY

Line 917: p_batch_step_activities IN gme_batch_step_activities%ROWTYPE)

913: +=============================================================================
914: Api end of comments
915: */
916: FUNCTION lock_row (
917: p_batch_step_activities IN gme_batch_step_activities%ROWTYPE)
918: RETURN BOOLEAN
919: IS
920: l_dummy NUMBER;
921: l_api_name CONSTANT VARCHAR2 (30) := 'lock_row';

Line 931: FROM gme_batch_step_activities

927:
928: IF p_batch_step_activities.batchstep_activity_id IS NOT NULL THEN
929: SELECT 1
930: INTO l_dummy
931: FROM gme_batch_step_activities
932: WHERE batchstep_activity_id =
933: p_batch_step_activities.batchstep_activity_id
934: FOR UPDATE NOWAIT;
935: ELSIF p_batch_step_activities.batch_id IS NOT NULL

Line 940: FROM gme_batch_step_activities

936: AND p_batch_step_activities.batchstep_id IS NOT NULL
937: AND p_batch_step_activities.activity IS NOT NULL THEN
938: SELECT 1
939: INTO l_dummy
940: FROM gme_batch_step_activities
941: WHERE batch_id = p_batch_step_activities.batch_id
942: AND batchstep_id = p_batch_step_activities.batchstep_id
943: AND activity = p_batch_step_activities.activity
944: FOR UPDATE NOWAIT;

Line 970: END gme_batch_step_activities_dbl;

966: END IF;
967:
968: RETURN FALSE;
969: END lock_row;
970: END gme_batch_step_activities_dbl;