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_RESOURCES_DBL dependencies on GME_BATCH_STEP_RESOURCES

Line 1: PACKAGE BODY gme_batch_step_resources_dbl AS

1: PACKAGE BODY gme_batch_step_resources_dbl AS
2: /* $Header: GMEVGSRB.pls 120.1 2005/06/03 11:00:34 appldev $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_STEP_RESOURCES';

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

1: PACKAGE BODY gme_batch_step_resources_dbl AS
2: /* $Header: GMEVGSRB.pls 120.1 2005/06/03 11:00:34 appldev $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_STEP_RESOURCES';
6: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
7: g_pkg_name VARCHAR2 (30) := 'GME_BATCH_STEP_RESOURCES_DBL';
8:
9: /*============================================================================

Line 7: g_pkg_name VARCHAR2 (30) := 'GME_BATCH_STEP_RESOURCES_DBL';

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

Line 47: | Insert_Row will insert a row in gme_batch_step_resources

Line 51: | Insert_Row will insert a row in gme_batch_step_resources

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

Line 56: | p_batch_step_resources IN gme_batch_step_resources%ROWTYPE

52: |
53: |
54: |
55: | PARAMETERS
56: | p_batch_step_resources IN gme_batch_step_resources%ROWTYPE
57: | x_batch_step_resources IN OUT NOCOPY gme_batch_step_resources%ROWTYPE
58: |
59: | RETURNS
60: | BOOLEAN

Line 57: | x_batch_step_resources IN OUT NOCOPY gme_batch_step_resources%ROWTYPE

Line 70: p_batch_step_resources IN gme_batch_step_resources%ROWTYPE

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

Line 71: ,x_batch_step_resources IN OUT NOCOPY gme_batch_step_resources%ROWTYPE)

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

Line 83: INSERT INTO gme_batch_step_resources

79: END IF;
80:
81: x_batch_step_resources := p_batch_step_resources;
82:
83: INSERT INTO gme_batch_step_resources
84: (batchstep_resource_id
85: ,batchstep_activity_id
86: ,resources
87: ,cost_analysis_code

Line 277: | Fetch_Row will fetch a row in gme_batch_step_resources

Line 281: | Fetch_Row will fetch a row in gme_batch_step_resources

277: | Fetch_Row will fetch a row in gme_batch_step_resources
278: |
279: |
280: | DESCRIPTION
281: | Fetch_Row will fetch a row in gme_batch_step_resources
282: |
283: |
284: |
285: | PARAMETERS

Line 286: | p_batch_step_resources IN gme_batch_step_resources%ROWTYPE

282: |
283: |
284: |
285: | PARAMETERS
286: | p_batch_step_resources IN gme_batch_step_resources%ROWTYPE
287: | x_batch_step_resources IN OUT NOCOPY gme_batch_step_resources%ROWTYPE
288: |
289: | RETURNS
290: | BOOLEAN

Line 287: | x_batch_step_resources IN OUT NOCOPY gme_batch_step_resources%ROWTYPE

Line 300: p_batch_step_resources IN gme_batch_step_resources%ROWTYPE

296: +=============================================================================
297: Api end of comments
298: */
299: FUNCTION fetch_row (
300: p_batch_step_resources IN gme_batch_step_resources%ROWTYPE
301: ,x_batch_step_resources IN OUT NOCOPY gme_batch_step_resources%ROWTYPE)
302: RETURN BOOLEAN
303: IS
304: l_api_name CONSTANT VARCHAR2 (30) := 'fetch_row';

Line 301: ,x_batch_step_resources IN OUT NOCOPY gme_batch_step_resources%ROWTYPE)

297: Api end of comments
298: */
299: FUNCTION fetch_row (
300: p_batch_step_resources IN gme_batch_step_resources%ROWTYPE
301: ,x_batch_step_resources IN OUT NOCOPY gme_batch_step_resources%ROWTYPE)
302: RETURN BOOLEAN
303: IS
304: l_api_name CONSTANT VARCHAR2 (30) := 'fetch_row';
305: BEGIN

Line 472: FROM gme_batch_step_resources

468: ,x_batch_step_resources.capacity_um
469: ,x_batch_step_resources.usage_um
470: ,x_batch_step_resources.resource_qty_um
471: ,x_batch_step_resources.organization_id
472: FROM gme_batch_step_resources
473: WHERE batchstep_resource_id =
474: p_batch_step_resources.batchstep_resource_id;
475: ELSIF p_batch_step_resources.batchstep_activity_id IS NOT NULL
476: AND p_batch_step_resources.resources IS NOT NULL THEN

Line 637: FROM gme_batch_step_resources

633: ,x_batch_step_resources.capacity_um
634: ,x_batch_step_resources.usage_um
635: ,x_batch_step_resources.resource_qty_um
636: ,x_batch_step_resources.organization_id
637: FROM gme_batch_step_resources
638: WHERE batchstep_activity_id =
639: p_batch_step_resources.batchstep_activity_id
640: AND resources = p_batch_step_resources.resources;
641: ELSE

Line 677: | Delete_Row will delete a row in gme_batch_step_resources

Line 681: | Delete_Row will delete a row in gme_batch_step_resources

677: | Delete_Row will delete a row in gme_batch_step_resources
678: |
679: |
680: | DESCRIPTION
681: | Delete_Row will delete a row in gme_batch_step_resources
682: |
683: |
684: |
685: | PARAMETERS

Line 686: | p_batch_step_resources IN gme_batch_step_resources%ROWTYPE

682: |
683: |
684: |
685: | PARAMETERS
686: | p_batch_step_resources IN gme_batch_step_resources%ROWTYPE
687: |
688: | RETURNS
689: | BOOLEAN
690: | HISTORY

Line 700: p_batch_step_resources IN gme_batch_step_resources%ROWTYPE)

696: +=============================================================================
697: Api end of comments
698: */
699: FUNCTION delete_row (
700: p_batch_step_resources IN gme_batch_step_resources%ROWTYPE)
701: RETURN BOOLEAN
702: IS
703: l_dummy NUMBER := 0;
704: locked_by_other_user EXCEPTION;

Line 716: FROM gme_batch_step_resources

712:
713: IF p_batch_step_resources.batchstep_resource_id IS NOT NULL THEN
714: SELECT 1
715: INTO l_dummy
716: FROM gme_batch_step_resources
717: WHERE batchstep_resource_id =
718: p_batch_step_resources.batchstep_resource_id
719: FOR UPDATE NOWAIT;
720:

Line 721: DELETE FROM gme_batch_step_resources

717: WHERE batchstep_resource_id =
718: p_batch_step_resources.batchstep_resource_id
719: FOR UPDATE NOWAIT;
720:
721: DELETE FROM gme_batch_step_resources
722: WHERE batchstep_resource_id =
723: p_batch_step_resources.batchstep_resource_id;
724: ELSIF p_batch_step_resources.batchstep_activity_id IS NOT NULL
725: AND p_batch_step_resources.resources IS NOT NULL THEN

Line 728: FROM gme_batch_step_resources

724: ELSIF p_batch_step_resources.batchstep_activity_id IS NOT NULL
725: AND p_batch_step_resources.resources IS NOT NULL THEN
726: SELECT 1
727: INTO l_dummy
728: FROM gme_batch_step_resources
729: WHERE batchstep_activity_id =
730: p_batch_step_resources.batchstep_activity_id
731: AND resources = p_batch_step_resources.resources
732: FOR UPDATE NOWAIT;

Line 734: DELETE FROM gme_batch_step_resources

730: p_batch_step_resources.batchstep_activity_id
731: AND resources = p_batch_step_resources.resources
732: FOR UPDATE NOWAIT;
733:
734: DELETE FROM gme_batch_step_resources
735: WHERE batchstep_activity_id =
736: p_batch_step_resources.batchstep_activity_id
737: AND resources = p_batch_step_resources.resources;
738: ELSE

Line 793: | Update_Row will update a row in gme_batch_step_resources

Line 797: | Update_Row will update a row in gme_batch_step_resources

793: | Update_Row will update a row in gme_batch_step_resources
794: |
795: |
796: | DESCRIPTION
797: | Update_Row will update a row in gme_batch_step_resources
798: |
799: |
800: |
801: | PARAMETERS

Line 802: | p_batch_step_resources IN gme_batch_step_resources%ROWTYPE

798: |
799: |
800: |
801: | PARAMETERS
802: | p_batch_step_resources IN gme_batch_step_resources%ROWTYPE
803: |
804: | RETURNS
805: | BOOLEAN
806: | HISTORY

Line 816: p_batch_step_resources IN gme_batch_step_resources%ROWTYPE)

812: +=============================================================================
813: Api end of comments
814: */
815: FUNCTION update_row (
816: p_batch_step_resources IN gme_batch_step_resources%ROWTYPE)
817: RETURN BOOLEAN
818: IS
819: l_dummy NUMBER := 0;
820: locked_by_other_user EXCEPTION;

Line 832: FROM gme_batch_step_resources

828:
829: IF p_batch_step_resources.batchstep_resource_id IS NOT NULL THEN
830: SELECT 1
831: INTO l_dummy
832: FROM gme_batch_step_resources
833: WHERE batchstep_resource_id =
834: p_batch_step_resources.batchstep_resource_id
835: FOR UPDATE NOWAIT;
836:

Line 837: UPDATE gme_batch_step_resources

833: WHERE batchstep_resource_id =
834: p_batch_step_resources.batchstep_resource_id
835: FOR UPDATE NOWAIT;
836:
837: UPDATE gme_batch_step_resources
838: SET batchstep_activity_id =
839: p_batch_step_resources.batchstep_activity_id
840: ,resources = p_batch_step_resources.resources
841: ,cost_analysis_code = p_batch_step_resources.cost_analysis_code

Line 931: FROM gme_batch_step_resources

927: ELSIF p_batch_step_resources.batchstep_activity_id IS NOT NULL
928: AND p_batch_step_resources.resources IS NOT NULL THEN
929: SELECT 1
930: INTO l_dummy
931: FROM gme_batch_step_resources
932: WHERE batchstep_activity_id =
933: p_batch_step_resources.batchstep_activity_id
934: AND resources = p_batch_step_resources.resources
935: FOR UPDATE NOWAIT;

Line 937: UPDATE gme_batch_step_resources

933: p_batch_step_resources.batchstep_activity_id
934: AND resources = p_batch_step_resources.resources
935: FOR UPDATE NOWAIT;
936:
937: UPDATE gme_batch_step_resources
938: SET batchstep_activity_id =
939: p_batch_step_resources.batchstep_activity_id
940: ,resources = p_batch_step_resources.resources
941: ,cost_analysis_code = p_batch_step_resources.cost_analysis_code

Line 1095: | Lock_Row will lock a row in gme_batch_step_resources

Line 1099: | Lock_Row will lock a row in gme_batch_step_resources

1095: | Lock_Row will lock a row in gme_batch_step_resources
1096: |
1097: |
1098: | DESCRIPTION
1099: | Lock_Row will lock a row in gme_batch_step_resources
1100: |
1101: |
1102: |
1103: | PARAMETERS

Line 1104: | p_batch_step_resources IN gme_batch_step_resources%ROWTYPE

1100: |
1101: |
1102: |
1103: | PARAMETERS
1104: | p_batch_step_resources IN gme_batch_step_resources%ROWTYPE
1105: |
1106: | RETURNS
1107: | BOOLEAN
1108: | HISTORY

Line 1117: p_batch_step_resources IN gme_batch_step_resources%ROWTYPE)

1113: +=============================================================================
1114: Api end of comments
1115: */
1116: FUNCTION lock_row (
1117: p_batch_step_resources IN gme_batch_step_resources%ROWTYPE)
1118: RETURN BOOLEAN
1119: IS
1120: l_dummy NUMBER;
1121: l_api_name CONSTANT VARCHAR2 (30) := 'lock_row';

Line 1131: FROM gme_batch_step_resources

1127:
1128: IF p_batch_step_resources.batchstep_resource_id IS NOT NULL THEN
1129: SELECT 1
1130: INTO l_dummy
1131: FROM gme_batch_step_resources
1132: WHERE batchstep_resource_id =
1133: p_batch_step_resources.batchstep_resource_id
1134: FOR UPDATE NOWAIT;
1135: ELSIF p_batch_step_resources.batchstep_activity_id IS NOT NULL

Line 1139: FROM gme_batch_step_resources

1135: ELSIF p_batch_step_resources.batchstep_activity_id IS NOT NULL
1136: AND p_batch_step_resources.resources IS NOT NULL THEN
1137: SELECT 1
1138: INTO l_dummy
1139: FROM gme_batch_step_resources
1140: WHERE batchstep_activity_id =
1141: p_batch_step_resources.batchstep_activity_id
1142: AND resources = p_batch_step_resources.resources
1143: FOR UPDATE NOWAIT;

Line 1170: END gme_batch_step_resources_dbl;

1166: END IF;
1167:
1168: RETURN FALSE;
1169: END lock_row;
1170: END gme_batch_step_resources_dbl;