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

Line 1: PACKAGE BODY gme_process_parameters_pvt AS

1: PACKAGE BODY gme_process_parameters_pvt AS
2: /* $Header: GMEVPPRB.pls 120.3 2006/03/17 11:12:54 pxkumar noship $ */
3: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_PROCESS_PARAMETERS_PVT';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_PROCESS_PARAMETERS_PVT';

1: PACKAGE BODY gme_process_parameters_pvt AS
2: /* $Header: GMEVPPRB.pls 120.3 2006/03/17 11:12:54 pxkumar noship $ */
3: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_PROCESS_PARAMETERS_PVT';
5:
6: /*===========================================================================================
7: Procedure
8: insert_process_parameter

Line 15: p_process_param_rec gme_process_parameters%ROWTYPE - details of the process parameter

11: Parameters
12: p_process_param_rec.batchstep_resource_id OR
13: (p_plant_code,p_batch_no,p_batchstep_no,p_activity,p_resource,p_parameter ) to uniquely
14: identify an process parameter
15: p_process_param_rec gme_process_parameters%ROWTYPE - details of the process parameter
16: x_return_status reflects return status of the API
17: =============================================================================================*/
18: PROCEDURE insert_process_parameter (
19: p_batch_no IN VARCHAR2

Line 25: ,p_process_param_rec IN gme_process_parameters%ROWTYPE

21: ,p_validate_flexfields IN VARCHAR2
22: ,p_batchstep_no IN NUMBER
23: ,p_activity IN VARCHAR2
24: ,p_parameter IN VARCHAR2
25: ,p_process_param_rec IN gme_process_parameters%ROWTYPE
26: ,x_process_param_rec OUT NOCOPY gme_process_parameters%ROWTYPE
27: ,x_return_status OUT NOCOPY VARCHAR2)
28: IS
29: CURSOR cur_validate_batch_type (v_resource_id NUMBER)

Line 26: ,x_process_param_rec OUT NOCOPY gme_process_parameters%ROWTYPE

22: ,p_batchstep_no IN NUMBER
23: ,p_activity IN VARCHAR2
24: ,p_parameter IN VARCHAR2
25: ,p_process_param_rec IN gme_process_parameters%ROWTYPE
26: ,x_process_param_rec OUT NOCOPY gme_process_parameters%ROWTYPE
27: ,x_return_status OUT NOCOPY VARCHAR2)
28: IS
29: CURSOR cur_validate_batch_type (v_resource_id NUMBER)
30: IS

Line 61: l_process_param_rec gme_process_parameters%ROWTYPE;

57: wrong_actual_value EXCEPTION;
58: validation_failure EXCEPTION;
59: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_PROCESS_PARAMETER';
60: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
61: l_process_param_rec gme_process_parameters%ROWTYPE;
62: l_resource_id NUMBER;
63: l_activity_id NUMBER;
64: l_batchstep_id NUMBER;
65: l_dummy NUMBER;

Line 319: with gme_process_parameters_dbl.insert_row

315: END IF;
316:
317: /* Nsinha as part of GME_Process_Parameter_APIs_TD:
318: Replaced the call to gme_api_process_parameters.insert_process_param
319: with gme_process_parameters_dbl.insert_row
320: */
321: IF NOT gme_process_parameters_dbl.insert_row
322: (p_process_parameters => l_process_param_rec
323: ,x_process_parameters => x_process_param_rec) THEN

Line 321: IF NOT gme_process_parameters_dbl.insert_row

317: /* Nsinha as part of GME_Process_Parameter_APIs_TD:
318: Replaced the call to gme_api_process_parameters.insert_process_param
319: with gme_process_parameters_dbl.insert_row
320: */
321: IF NOT gme_process_parameters_dbl.insert_row
322: (p_process_parameters => l_process_param_rec
323: ,x_process_parameters => x_process_param_rec) THEN
324: RAISE fnd_api.g_exc_error;
325: END IF;

Line 360: p_process_param_rec gme_process_parameters%ROWTYPE - details of the process parameter

356: Parameters
357: p_process_param_rec.batchstep_resource_id OR
358: (p_plant_code,p_batch_no,p_batchstep_no,p_activity,p_parameter ) to uniquely
359: identify an process parameter
360: p_process_param_rec gme_process_parameters%ROWTYPE - details of the process parameter
361: x_return_status reflects return status of the API
362: =============================================================================================*/
363: PROCEDURE update_process_parameter (
364: p_batch_no IN VARCHAR2 := NULL

Line 370: ,p_process_param_rec IN gme_process_parameters%ROWTYPE

366: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
367: ,p_batchstep_no IN NUMBER := NULL
368: ,p_activity IN VARCHAR2 := NULL
369: ,p_parameter IN VARCHAR2 := NULL
370: ,p_process_param_rec IN gme_process_parameters%ROWTYPE
371: ,x_process_param_rec OUT NOCOPY gme_process_parameters%ROWTYPE
372: ,x_return_status OUT NOCOPY VARCHAR2)
373: IS
374: CURSOR cur_validate_parameter (v_proc_param_id NUMBER)

Line 371: ,x_process_param_rec OUT NOCOPY gme_process_parameters%ROWTYPE

367: ,p_batchstep_no IN NUMBER := NULL
368: ,p_activity IN VARCHAR2 := NULL
369: ,p_parameter IN VARCHAR2 := NULL
370: ,p_process_param_rec IN gme_process_parameters%ROWTYPE
371: ,x_process_param_rec OUT NOCOPY gme_process_parameters%ROWTYPE
372: ,x_return_status OUT NOCOPY VARCHAR2)
373: IS
374: CURSOR cur_validate_parameter (v_proc_param_id NUMBER)
375: IS

Line 377: FROM gme_process_parameters

373: IS
374: CURSOR cur_validate_parameter (v_proc_param_id NUMBER)
375: IS
376: SELECT batchstep_id, batch_id
377: FROM gme_process_parameters
378: WHERE process_param_id = v_proc_param_id;
379:
380: CURSOR cur_validate_batch_type (v_proc_param_id NUMBER)
381: IS

Line 383: FROM gme_batch_header b, gme_process_parameters p

379:
380: CURSOR cur_validate_batch_type (v_proc_param_id NUMBER)
381: IS
382: SELECT 1
383: FROM gme_batch_header b, gme_process_parameters p
384: WHERE b.batch_id = p.batch_id
385: AND p.process_param_id = v_proc_param_id
386: AND b.batch_type = 10;
387:

Line 414: l_process_param_rec gme_process_parameters%ROWTYPE;

410: param_details_not_found EXCEPTION;
411: batch_steps_fetch_error EXCEPTION;
412: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_PROCESS_PARAMETER';
413: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
414: l_process_param_rec gme_process_parameters%ROWTYPE;
415: l_batch_steps gme_batch_steps%ROWTYPE;
416: l_proc_param_id NUMBER;
417: l_resource_id NUMBER;
418: l_activity_id NUMBER;

Line 524: IF NOT gme_process_parameters_dbl.fetch_row (l_process_param_rec

520: END IF;
521:
522: l_process_param_rec.process_param_id := l_proc_param_id;
523:
524: IF NOT gme_process_parameters_dbl.fetch_row (l_process_param_rec
525: ,l_process_param_rec) THEN
526: RAISE fnd_api.g_exc_error;
527: END IF;
528:

Line 600: with gme_process_parameters_dbl.update_row

596: RAISE no_change;
597: END IF;
598:
599: /* Replace the call to gme_api_process_parameters.update_process_param
600: with gme_process_parameters_dbl.update_row
601: */
602: IF NOT gme_process_parameters_dbl.update_row
603: (p_process_parameters => l_process_param_rec) THEN
604: RAISE fnd_api.g_exc_error;

Line 602: IF NOT gme_process_parameters_dbl.update_row

598:
599: /* Replace the call to gme_api_process_parameters.update_process_param
600: with gme_process_parameters_dbl.update_row
601: */
602: IF NOT gme_process_parameters_dbl.update_row
603: (p_process_parameters => l_process_param_rec) THEN
604: RAISE fnd_api.g_exc_error;
605: END IF;
606:

Line 644: p_process_param_rec gme_process_parameters%ROWTYPE - details of the process parameter

640: Parameters
641: p_process_param_rec.batchstep_resource_id OR
642: (p_plant_code,p_batch_no,p_batchstep_no,p_activity,p_parameter ) to uniquely
643: identify an process parameter
644: p_process_param_rec gme_process_parameters%ROWTYPE - details of the process parameter
645: x_return_status reflects return status of the API
646: =============================================================================================*/
647: PROCEDURE delete_process_parameter (
648: p_batch_no IN VARCHAR2

Line 653: ,p_process_param_rec IN gme_process_parameters%ROWTYPE

649: ,p_org_code IN VARCHAR2
650: ,p_batchstep_no IN NUMBER
651: ,p_activity IN VARCHAR2
652: ,p_parameter IN VARCHAR2
653: ,p_process_param_rec IN gme_process_parameters%ROWTYPE
654: ,x_return_status OUT NOCOPY VARCHAR2)
655: IS
656: CURSOR cur_validate_parameter (v_proc_param_id NUMBER)
657: IS

Line 659: FROM gme_process_parameters

655: IS
656: CURSOR cur_validate_parameter (v_proc_param_id NUMBER)
657: IS
658: SELECT batchstep_id, batch_id
659: FROM gme_process_parameters
660: WHERE process_param_id = v_proc_param_id;
661:
662: CURSOR cur_validate_batch_type (v_proc_param_id NUMBER)
663: IS

Line 665: FROM gme_batch_header b, gme_process_parameters p

661:
662: CURSOR cur_validate_batch_type (v_proc_param_id NUMBER)
663: IS
664: SELECT 1
665: FROM gme_batch_header b, gme_process_parameters p
666: WHERE b.batch_id = p.batch_id
667: AND p.process_param_id = v_proc_param_id
668: AND b.batch_type = 10;
669:

Line 686: l_process_param_rec gme_process_parameters%ROWTYPE;

682: param_not_found EXCEPTION;
683: delete_param_failed EXCEPTION;
684: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_PROCESS_PARAMETER';
685: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
686: l_process_param_rec gme_process_parameters%ROWTYPE;
687: l_proc_param_id NUMBER;
688: l_resource_id NUMBER;
689: l_activity_id NUMBER;
690: l_batchstep_id NUMBER;

Line 790: with gme_process_parameters_dbl.delete_row

786: l_process_param_rec.process_param_id := l_proc_param_id;
787: x_return_status := l_return_status;
788:
789: /* Replace the call to gme_api_process_parameters.delete_process_param
790: with gme_process_parameters_dbl.delete_row
791: */
792: IF NOT gme_process_parameters_dbl.delete_row
793: (p_process_parameters => l_process_param_rec) THEN
794: RAISE fnd_api.g_exc_error;

Line 792: IF NOT gme_process_parameters_dbl.delete_row

788:
789: /* Replace the call to gme_api_process_parameters.delete_process_param
790: with gme_process_parameters_dbl.delete_row
791: */
792: IF NOT gme_process_parameters_dbl.delete_row
793: (p_process_parameters => l_process_param_rec) THEN
794: RAISE fnd_api.g_exc_error;
795: END IF;
796: EXCEPTION

Line 891: FROM gme_process_parameters p, gmp_process_parameters l

887:
888: CURSOR cur_get_parameter (v_resource_id NUMBER, v_parameter VARCHAR2)
889: IS
890: SELECT process_param_id
891: FROM gme_process_parameters p, gmp_process_parameters l
892: WHERE p.parameter_id = l.parameter_id
893: AND p.batchstep_resource_id = v_resource_id
894: AND l.parameter_name = v_parameter
895: AND l.delete_mark = 0;

Line 1106: END gme_process_parameters_pvt;

1102: WHEN OTHERS THEN
1103: x_return_status := fnd_api.g_ret_sts_unexp_error;
1104: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1105: END validate_process_param;
1106: END gme_process_parameters_pvt;