1 package bsc_sec_utility AS
2 /*$Header: BSCSECUS.pls 120.0 2005/06/01 15:58:53 appldev noship $*/
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
4 -- dbdrv: checkfile(115.3=120.0):~PROD:~PATH:~FILE
5 function get_item_value(p_level_view_name varchar2,p_level_value varchar2) return varchar2;
6 function get_lowest_dim_ind(p_tab_id varchar2,p_resp_id varchar2) return number;
7 function get_parent_value(p_tab_id number,p_level_index number,p_level_value varchar2) return varchar2;
8
9 procedure Update_tab_access (
10 P_ROWID in ROWID := null,
11 P_RESP_ID in number,
12 P_TAB_ID in number,
13 P_START_DATE in date,
14 P_END_DATE in date,
15 P_LAST_UPDATED_BY in NUMBER := null,
16 P_LAST_UPDATE_LOGIN in NUMBER := null,
17 P_LAST_UPDATE_DATE in DATE := null,
18 p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
19 p_commit IN VARCHAR2 := fnd_api.g_FALSE,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_errorcode OUT NOCOPY NUMBER,
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2
24 ) ;
25
26
27 procedure Update_list_access (
28 P_ROWID in ROWID := null,
29 P_RESP_ID in number,
30 P_TAB_ID in number,
31 P_DIM_LEVEL_INDEX in number,
32 P_DIM_LEVEL_VALUE in VARCHAR2,
33 P_LAST_UPDATED_BY in NUMBER := null,
34 P_LAST_UPDATE_LOGIN in NUMBER := null,
35 P_LAST_UPDATE_DATE in DATE := null,
36 p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
37 p_commit IN VARCHAR2 := fnd_api.g_FALSE,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_errorcode OUT NOCOPY NUMBER,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2
42 ) ;
43
44 procedure insert_tab_access (
45 P_RESP_ID in number,
46 P_TAB_ID in number,
47 P_START_DATE in date,
48 P_END_DATE in date,
49 P_CREATED_BY in NUMBER := null,
50 P_CREATION_DATE in DATE := null,
51 P_LAST_UPDATED_BY in NUMBER := null,
52 P_LAST_UPDATE_LOGIN in NUMBER := null,
53 P_LAST_UPDATE_DATE in DATE := null,
54 p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
55 p_commit IN VARCHAR2 := fnd_api.g_FALSE,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_errorcode OUT NOCOPY NUMBER,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2
60 ) ;
61
62 procedure insert_kpi_access (
63 P_RESP_ID in number,
64 P_INDICATOR in number,
65 P_START_DATE in date,
66 P_END_DATE in date,
67 P_CREATED_BY in NUMBER := null,
68 P_CREATION_DATE in DATE := null,
69 P_LAST_UPDATED_BY in NUMBER := null,
70 P_LAST_UPDATE_LOGIN in NUMBER := null,
71 P_LAST_UPDATE_DATE in DATE := null,
72 p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
73 p_commit IN VARCHAR2 := fnd_api.g_FALSE,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_errorcode OUT NOCOPY NUMBER,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2
78 ) ;
79
80 procedure Update_kpi_access (
81 P_ROWID in ROWID := null,
82 P_RESP_ID in number,
83 P_INDICATOR in number,
84 P_START_DATE in date,
85 P_END_DATE in date,
86 P_LAST_UPDATED_BY in NUMBER := null,
87 P_LAST_UPDATE_LOGIN in NUMBER := null,
88 P_LAST_UPDATE_DATE in DATE := null,
89 p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
90 p_commit IN VARCHAR2 := fnd_api.g_FALSE,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_errorcode OUT NOCOPY NUMBER,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2
95 ) ;
96
97 procedure remove_kpi_access(
98 p_resp_id in number,
99 p_indicator in number,
100 p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE,
101 p_commit IN VARCHAR2 := fnd_api.g_FALSE,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_errorcode OUT NOCOPY NUMBER,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2
106 ) ;
107
108
109 END bsc_sec_utility;