1 PACKAGE gme_process_parameters_pvt AS
2 /* $Header: GMEVPPRS.pls 120.1 2005/06/03 13:48:25 appldev $ */
3 PROCEDURE insert_process_parameter (
4 p_batch_no IN VARCHAR2 := NULL
5 ,p_org_code IN VARCHAR2 := NULL
6 ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
7 ,p_batchstep_no IN NUMBER := NULL
8 ,p_activity IN VARCHAR2 := NULL
9 ,p_parameter IN VARCHAR2 := NULL
10 ,p_process_param_rec IN gme_process_parameters%ROWTYPE
11 ,x_process_param_rec OUT NOCOPY gme_process_parameters%ROWTYPE
12 ,x_return_status OUT NOCOPY VARCHAR2);
13
14 PROCEDURE update_process_parameter (
15 p_batch_no IN VARCHAR2 := NULL
16 ,p_org_code IN VARCHAR2 := NULL
17 ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
18 ,p_batchstep_no IN NUMBER := NULL
19 ,p_activity IN VARCHAR2 := NULL
20 ,p_parameter IN VARCHAR2 := NULL
21 ,p_process_param_rec IN gme_process_parameters%ROWTYPE
22 ,x_process_param_rec OUT NOCOPY gme_process_parameters%ROWTYPE
23 ,x_return_status OUT NOCOPY VARCHAR2);
24
25 PROCEDURE delete_process_parameter (
26 p_batch_no IN VARCHAR2 := NULL
27 ,p_org_code IN VARCHAR2 := NULL
28 ,p_batchstep_no IN NUMBER := NULL
29 ,p_activity IN VARCHAR2 := NULL
30 ,p_parameter IN VARCHAR2 := NULL
31 ,p_process_param_rec IN gme_process_parameters%ROWTYPE
32 ,x_return_status OUT NOCOPY VARCHAR2);
33
34 PROCEDURE validate_process_param (
35 p_org_code IN VARCHAR2 := NULL
36 ,p_batch_no IN VARCHAR2 := NULL
37 ,p_batchstep_no IN NUMBER := NULL
38 ,p_activity IN VARCHAR2 := NULL
39 ,p_resource IN VARCHAR2 := NULL
40 ,p_parameter IN VARCHAR2 := NULL
41 ,x_batch_id OUT NOCOPY NUMBER
42 ,x_batchstep_id OUT NOCOPY NUMBER
43 ,x_activity_id OUT NOCOPY NUMBER
44 ,x_resource_id OUT NOCOPY NUMBER
45 ,x_parameter_id OUT NOCOPY NUMBER
46 ,x_proc_param_id OUT NOCOPY NUMBER
47 ,x_step_status OUT NOCOPY NUMBER
48 ,x_return_status OUT NOCOPY VARCHAR2);
49 END gme_process_parameters_pvt;
[Home] [Help]