1 PACKAGE AMW_PARAMETERS_PVT_PKG as
2 /*$Header: amwparps.pls 120.1 2005/10/25 23:25:31 appldev noship $*/
3 PROCEDURE insert_parameter(
4 p_parameter_name IN VARCHAR2,
5 p_parameter_value IN VARCHAR2,
6 p_pk1 IN VARCHAR2,
7 p_pk2 IN VARCHAR2,
8 p_pk3 IN VARCHAR2,
9 p_pk4 IN VARCHAR2,
10 p_pk5 IN VARCHAR2);
11
12 PROCEDURE update_parameter(
13 p_parameter_name in varchar2,
14 p_parameter_value in varchar2,
15 p_pk1 in varchar2,
16 p_pk2 in varchar2,
17 p_pk3 in varchar2,
18 p_pk4 in varchar2,
19 p_pk5 in varchar2);
20
21 PROCEDURE initialize_org_parameters(
22 p_process_approval_option IN VARCHAR2,
23 p_process_auto_approve IN VARCHAR2,
24 p_pk1 IN VARCHAR2,
25 p_pk2 IN VARCHAR2 := NULL,
26 p_pk3 IN VARCHAR2 := NULL,
27 p_pk4 IN VARCHAR2 := NULL,
28 p_pk5 IN VARCHAR2 := NULL,
29 p_commit IN VARCHAR2 := FND_API.G_FALSE,
30 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY VARCHAR2,
34 x_msg_data OUT NOCOPY VARCHAR2
35 );
36
37 PROCEDURE update_org_parameters(
38 p_process_approval_option IN VARCHAR2,
39 p_process_auto_approve IN VARCHAR2,
40 p_pk1 IN VARCHAR2,
41 p_pk2 IN VARCHAR2 := NULL,
42 p_pk3 IN VARCHAR2 := NULL,
43 p_pk4 IN VARCHAR2 := NULL,
44 p_pk5 IN VARCHAR2 := NULL,
45 p_commit IN VARCHAR2 := FND_API.G_FALSE,
46 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
47 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY VARCHAR2,
50 x_msg_data OUT NOCOPY VARCHAR2
51 );
52
53 procedure load_initial_seed_data (p_PARAMETER_NAME in varchar2,
54 p_parameter_value in varchar2,
55 p_pk1 in varchar2,
56 p_pk2 in varchar2,
57 p_pk3 in varchar2,
58 p_pk4 in varchar2,
59 p_pk5 in varchar2,
60 x_owner in varchar2,
61 x_last_update_date in varchar2);
62
63 --kosriniv..for bug fix..4336520
64 PROCEDURE default_org_parameters(
65 p_org IN VARCHAR2,
66 p_commit IN VARCHAR2 := FND_API.G_FALSE,
67 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY VARCHAR2,
71 x_msg_data OUT NOCOPY VARCHAR2
72 );
73
74
75 -- kosriniv ..update orgs concurrent programs
76 PROCEDURE update_all_org_params_cp(
77 errbuf out nocopy varchar2,
78 retcode out nocopy varchar2,
79 p_proc_approval_option in varchar2, -- A,B,C..
80 p_approval_required in varchar2, -- Y/N ..Y means auto_approve is No and N means auto_approve is Yes.
81 p_all_orgs in varchar2 -- NOCONF means only orgs that have not been configured..ALL means set/update all the orgs..
82 );
83 END AMW_PARAMETERS_PVT_PKG;