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_PROCESS_PARAMETERS_DBL dependencies on GME_PROCESS_PARAMETERS

Line 1: PACKAGE BODY gme_process_parameters_dbl AS

1: PACKAGE BODY gme_process_parameters_dbl AS
2: /* $Header: GMEVGPPB.pls 120.3 2006/03/17 11:13:28 pxkumar noship $ */
3: g_table_name VARCHAR2 (80) DEFAULT 'GME_PROCESS_PARAMETERS';
4: g_package_name VARCHAR2 (32) DEFAULT 'GME_PROCESS_PARAMETERS_DBL';
5:

Line 3: g_table_name VARCHAR2 (80) DEFAULT 'GME_PROCESS_PARAMETERS';

1: PACKAGE BODY gme_process_parameters_dbl AS
2: /* $Header: GMEVGPPB.pls 120.3 2006/03/17 11:13:28 pxkumar noship $ */
3: g_table_name VARCHAR2 (80) DEFAULT 'GME_PROCESS_PARAMETERS';
4: g_package_name VARCHAR2 (32) DEFAULT 'GME_PROCESS_PARAMETERS_DBL';
5:
6: FUNCTION insert_row (
7: p_process_parameters IN gme_process_parameters%ROWTYPE

Line 4: g_package_name VARCHAR2 (32) DEFAULT 'GME_PROCESS_PARAMETERS_DBL';

1: PACKAGE BODY gme_process_parameters_dbl AS
2: /* $Header: GMEVGPPB.pls 120.3 2006/03/17 11:13:28 pxkumar noship $ */
3: g_table_name VARCHAR2 (80) DEFAULT 'GME_PROCESS_PARAMETERS';
4: g_package_name VARCHAR2 (32) DEFAULT 'GME_PROCESS_PARAMETERS_DBL';
5:
6: FUNCTION insert_row (
7: p_process_parameters IN gme_process_parameters%ROWTYPE
8: ,x_process_parameters IN OUT NOCOPY gme_process_parameters%ROWTYPE)

Line 7: p_process_parameters IN gme_process_parameters%ROWTYPE

3: g_table_name VARCHAR2 (80) DEFAULT 'GME_PROCESS_PARAMETERS';
4: g_package_name VARCHAR2 (32) DEFAULT 'GME_PROCESS_PARAMETERS_DBL';
5:
6: FUNCTION insert_row (
7: p_process_parameters IN gme_process_parameters%ROWTYPE
8: ,x_process_parameters IN OUT NOCOPY gme_process_parameters%ROWTYPE)
9: RETURN BOOLEAN
10: IS
11: BEGIN

Line 8: ,x_process_parameters IN OUT NOCOPY gme_process_parameters%ROWTYPE)

4: g_package_name VARCHAR2 (32) DEFAULT 'GME_PROCESS_PARAMETERS_DBL';
5:
6: FUNCTION insert_row (
7: p_process_parameters IN gme_process_parameters%ROWTYPE
8: ,x_process_parameters IN OUT NOCOPY gme_process_parameters%ROWTYPE)
9: RETURN BOOLEAN
10: IS
11: BEGIN
12: x_process_parameters := p_process_parameters;

Line 14: INSERT INTO gme_process_parameters

10: IS
11: BEGIN
12: x_process_parameters := p_process_parameters;
13:
14: INSERT INTO gme_process_parameters
15: (process_param_id
16: ,batch_id
17: ,batchstep_id
18: ,batchstep_activity_id

Line 62: VALUES (gme_process_parameters_id_s.NEXTVAL

58: ,attribute30
59: ,creation_date, created_by
60: ,last_update_date, last_updated_by
61: ,last_update_login)
62: VALUES (gme_process_parameters_id_s.NEXTVAL
63: ,x_process_parameters.batch_id
64: ,x_process_parameters.batchstep_id
65: ,x_process_parameters.batchstep_activity_id
66: ,x_process_parameters.batchstep_resource_id

Line 135: | Fetch_Row will fetch a row in gme_process_parameters

Line 139: | Fetch_Row will fetch a row in gme_process_parameters

135: | Fetch_Row will fetch a row in gme_process_parameters
136: |
137: |
138: | DESCRIPTION
139: | Fetch_Row will fetch a row in gme_process_parameters
140: |
141: |
142: |
143: | PARAMETERS

Line 144: | p_process_parameters IN gme_process_parameters%ROWTYPE

140: |
141: |
142: |
143: | PARAMETERS
144: | p_process_parameters IN gme_process_parameters%ROWTYPE
145: | x_process_parameters OUT gme_process_parameters%ROWTYPE
146: |
147: | RETURNS
148: | BOOLEAN

Line 145: | x_process_parameters OUT gme_process_parameters%ROWTYPE

Line 158: p_process_parameters IN gme_process_parameters%ROWTYPE

154: +=============================================================================
155: Api end of comments
156: */
157: FUNCTION fetch_row (
158: p_process_parameters IN gme_process_parameters%ROWTYPE
159: ,x_process_parameters IN OUT NOCOPY gme_process_parameters%ROWTYPE)
160: RETURN BOOLEAN
161: IS
162: BEGIN

Line 159: ,x_process_parameters IN OUT NOCOPY gme_process_parameters%ROWTYPE)

155: Api end of comments
156: */
157: FUNCTION fetch_row (
158: p_process_parameters IN gme_process_parameters%ROWTYPE
159: ,x_process_parameters IN OUT NOCOPY gme_process_parameters%ROWTYPE)
160: RETURN BOOLEAN
161: IS
162: BEGIN
163: IF p_process_parameters.process_param_id IS NOT NULL THEN

Line 262: FROM gme_process_parameters

258: ,x_process_parameters.creation_date
259: ,x_process_parameters.last_updated_by
260: ,x_process_parameters.last_update_date
261: ,x_process_parameters.last_update_login
262: FROM gme_process_parameters
263: WHERE process_param_id = p_process_parameters.process_param_id;
264: ELSIF p_process_parameters.batchstep_resource_id IS NOT NULL
265: AND p_process_parameters.parameter_id IS NOT NULL THEN
266: SELECT process_param_id

Line 364: FROM gme_process_parameters

360: ,x_process_parameters.creation_date
361: ,x_process_parameters.last_updated_by
362: ,x_process_parameters.last_update_date
363: ,x_process_parameters.last_update_login
364: FROM gme_process_parameters
365: WHERE batchstep_resource_id =
366: p_process_parameters.batchstep_resource_id
367: AND parameter_id = p_process_parameters.parameter_id;
368: ELSE

Line 395: | Delete_Row will delete a row in gme_process_parameters

Line 399: | Delete_Row will delete a row in gme_process_parameters

395: | Delete_Row will delete a row in gme_process_parameters
396: |
397: |
398: | DESCRIPTION
399: | Delete_Row will delete a row in gme_process_parameters
400: |
401: |
402: |
403: | PARAMETERS

Line 404: | p_process_parameters IN gme_process_parameters%ROWTYPE

400: |
401: |
402: |
403: | PARAMETERS
404: | p_process_parameters IN gme_process_parameters%ROWTYPE
405: |
406: | RETURNS
407: | BOOLEAN
408: | HISTORY

Line 417: p_process_parameters IN gme_process_parameters%ROWTYPE)

413: +=============================================================================
414: Api end of comments
415: */
416: FUNCTION delete_row (
417: p_process_parameters IN gme_process_parameters%ROWTYPE)
418: RETURN BOOLEAN
419: IS
420: l_dummy NUMBER;
421: locked_by_other_user EXCEPTION;

Line 427: FROM gme_process_parameters

423: BEGIN
424: IF p_process_parameters.process_param_id IS NOT NULL THEN
425: SELECT 1
426: INTO l_dummy
427: FROM gme_process_parameters
428: WHERE process_param_id = p_process_parameters.process_param_id
429: FOR UPDATE NOWAIT;
430:
431: DELETE FROM gme_process_parameters

Line 431: DELETE FROM gme_process_parameters

427: FROM gme_process_parameters
428: WHERE process_param_id = p_process_parameters.process_param_id
429: FOR UPDATE NOWAIT;
430:
431: DELETE FROM gme_process_parameters
432: WHERE process_param_id = p_process_parameters.process_param_id;
433: ELSIF p_process_parameters.batchstep_resource_id IS NOT NULL
434: AND p_process_parameters.parameter_id IS NOT NULL THEN
435: SELECT 1

Line 437: FROM gme_process_parameters

433: ELSIF p_process_parameters.batchstep_resource_id IS NOT NULL
434: AND p_process_parameters.parameter_id IS NOT NULL THEN
435: SELECT 1
436: INTO l_dummy
437: FROM gme_process_parameters
438: WHERE batchstep_resource_id =
439: p_process_parameters.batchstep_resource_id
440: AND parameter_id = p_process_parameters.parameter_id
441: FOR UPDATE NOWAIT;

Line 443: DELETE FROM gme_process_parameters

439: p_process_parameters.batchstep_resource_id
440: AND parameter_id = p_process_parameters.parameter_id
441: FOR UPDATE NOWAIT;
442:
443: DELETE FROM gme_process_parameters
444: WHERE batchstep_resource_id =
445: p_process_parameters.batchstep_resource_id
446: AND parameter_id = p_process_parameters.parameter_id;
447: ELSE

Line 485: | Update_Row will update a row in gme_process_parameters

Line 489: | Update_Row will update a row in gme_process_parameters

485: | Update_Row will update a row in gme_process_parameters
486: |
487: |
488: | DESCRIPTION
489: | Update_Row will update a row in gme_process_parameters
490: |
491: |
492: |
493: | PARAMETERS

Line 494: | p_process_parameters IN gme_process_parameters%ROWTYPE

490: |
491: |
492: |
493: | PARAMETERS
494: | p_process_parameters IN gme_process_parameters%ROWTYPE
495: |
496: | RETURNS
497: | BOOLEAN
498: | HISTORY

Line 507: p_process_parameters IN gme_process_parameters%ROWTYPE)

503: +=============================================================================
504: Api end of comments
505: */
506: FUNCTION update_row (
507: p_process_parameters IN gme_process_parameters%ROWTYPE)
508: RETURN BOOLEAN
509: IS
510: l_dummy NUMBER := 0;
511: locked_by_other_user EXCEPTION;

Line 517: FROM gme_process_parameters

513: BEGIN
514: IF p_process_parameters.process_param_id IS NOT NULL THEN
515: SELECT 1
516: INTO l_dummy
517: FROM gme_process_parameters
518: WHERE process_param_id = p_process_parameters.process_param_id
519: FOR UPDATE NOWAIT;
520:
521: UPDATE gme_process_parameters

Line 521: UPDATE gme_process_parameters

517: FROM gme_process_parameters
518: WHERE process_param_id = p_process_parameters.process_param_id
519: FOR UPDATE NOWAIT;
520:
521: UPDATE gme_process_parameters
522: SET batch_id = p_process_parameters.batch_id
523: ,batchstep_id = p_process_parameters.batchstep_id
524: ,batchstep_activity_id =
525: p_process_parameters.batchstep_activity_id

Line 629: | Lock_Row will lock a row in gme_process_parameters

Line 633: | Lock_Row will lock a row in gme_process_parameters

629: | Lock_Row will lock a row in gme_process_parameters
630: |
631: |
632: | DESCRIPTION
633: | Lock_Row will lock a row in gme_process_parameters
634: |
635: |
636: |
637: | PARAMETERS

Line 638: | p_process_parameters IN gme_process_parameters%ROWTYPE

634: |
635: |
636: |
637: | PARAMETERS
638: | p_process_parameters IN gme_process_parameters%ROWTYPE
639: |
640: | RETURNS
641: | BOOLEAN
642: | HISTORY

Line 650: FUNCTION lock_row (p_process_parameters IN gme_process_parameters%ROWTYPE)

646: |
647: +=============================================================================
648: Api end of comments
649: */
650: FUNCTION lock_row (p_process_parameters IN gme_process_parameters%ROWTYPE)
651: RETURN BOOLEAN
652: IS
653: l_dummy NUMBER;
654: BEGIN

Line 658: FROM gme_process_parameters

654: BEGIN
655: IF p_process_parameters.process_param_id IS NOT NULL THEN
656: SELECT 1
657: INTO l_dummy
658: FROM gme_process_parameters
659: WHERE process_param_id = p_process_parameters.process_param_id
660: FOR UPDATE NOWAIT;
661: /*ELSE p_process_parameters.batchstep_resource_id IS NOT NULL
662: AND p_process_parameters.parameter_id IS NOT NULL

Line 664: SELECT 1 INTO l_dummy FROM gme_process_parameters

660: FOR UPDATE NOWAIT;
661: /*ELSE p_process_parameters.batchstep_resource_id IS NOT NULL
662: AND p_process_parameters.parameter_id IS NOT NULL
663: THEN
664: SELECT 1 INTO l_dummy FROM gme_process_parameters
665: WHERE batchstep_resource_id = p_process_parameters.batchstep_resource_id
666: AND parameter_id = p_process_parameters.parameter_id
667: FOR UPDATE NOWAIT; */
668: END IF;

Line 698: | Delete_Row will delete a row in gme_process_parameters

694: | Delete_all will delete all process parameters for a resource
695: |
696: |
697: | DESCRIPTION
698: | Delete_Row will delete a row in gme_process_parameters
699: |
700: |
701: |
702: | PARAMETERS

Line 703: | p_process_parameters IN gme_process_parameters%ROWTYPE

699: |
700: |
701: |
702: | PARAMETERS
703: | p_process_parameters IN gme_process_parameters%ROWTYPE
704: |
705: | RETURNS
706: | BOOLEAN
707: | HISTORY

Line 716: p_process_parameters IN gme_process_parameters%ROWTYPE)

712: +=============================================================================
713: Api end of comments
714: */
715: FUNCTION delete_all (
716: p_process_parameters IN gme_process_parameters%ROWTYPE)
717: RETURN BOOLEAN
718: IS
719: l_process_param_ids gme_common_pvt.number_tab;
720: locked_by_other_user EXCEPTION;

Line 726: FROM gme_process_parameters

722: BEGIN
723: IF p_process_parameters.batchstep_resource_id IS NOT NULL THEN
724: SELECT process_param_id
725: BULK COLLECT INTO l_process_param_ids
726: FROM gme_process_parameters
727: WHERE process_param_id = p_process_parameters.process_param_id
728: FOR UPDATE NOWAIT;
729:
730: DELETE FROM gme_process_parameters

Line 730: DELETE FROM gme_process_parameters

726: FROM gme_process_parameters
727: WHERE process_param_id = p_process_parameters.process_param_id
728: FOR UPDATE NOWAIT;
729:
730: DELETE FROM gme_process_parameters
731: WHERE batchstep_resource_id =
732: p_process_parameters.batchstep_resource_id;
733: END IF;
734:

Line 754: END gme_process_parameters_dbl;

750: WHEN OTHERS THEN
751: fnd_msg_pub.add_exc_msg (g_package_name, 'delete_all');
752: RETURN FALSE;
753: END delete_all;
754: END gme_process_parameters_dbl;