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:
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
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)
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
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;
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
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
131: |
132: | TYPE
133: | Private
134: | USAGE
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
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
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
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
149: | HISTORY
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
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
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
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
391: |
392: | TYPE
393: | Private
394: | USAGE
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
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
400: |
401: |
402: |
403: | PARAMETERS
404: | p_process_parameters IN gme_process_parameters%ROWTYPE
405: |
406: | RETURNS
407: | BOOLEAN
408: | HISTORY
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;
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
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
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;
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
481: |
482: | TYPE
483: | Private
484: | USAGE
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
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
490: |
491: |
492: |
493: | PARAMETERS
494: | p_process_parameters IN gme_process_parameters%ROWTYPE
495: |
496: | RETURNS
497: | BOOLEAN
498: | HISTORY
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;
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
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
625: |
626: | TYPE
627: | Private
628: | USAGE
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
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
634: |
635: |
636: |
637: | PARAMETERS
638: | p_process_parameters IN gme_process_parameters%ROWTYPE
639: |
640: | RETURNS
641: | BOOLEAN
642: | HISTORY
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
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
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;
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
699: |
700: |
701: |
702: | PARAMETERS
703: | p_process_parameters IN gme_process_parameters%ROWTYPE
704: |
705: | RETURNS
706: | BOOLEAN
707: | HISTORY
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;
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
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:
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;