1 package FND_RESPONSIBILITY_PKG AUTHID CURRENT_USER as
2 /* $Header: AFSCRSPS.pls 120.3 2005/10/31 09:03:39 fskinner ship $ */
3 /*#
4 * Table Handler to insert or update data in FND_RESPONSIBILITY table.
5 * @rep:scope public
6 * @rep:product FND
7 * @rep:displayname Responsibility
8 * @rep:lifecycle active
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY FND_RESPONSIBILITY
11 * @rep:ihelp FND/@o_funcsec#o_funcsec See the related online help
12 */
13
14
15 procedure INSERT_ROW (
16 X_ROWID in out nocopy VARCHAR2,
17 X_RESPONSIBILITY_ID in NUMBER,
18 X_APPLICATION_ID in NUMBER,
19 X_WEB_HOST_NAME in VARCHAR2,
20 X_WEB_AGENT_NAME in VARCHAR2,
21 X_DATA_GROUP_APPLICATION_ID in NUMBER,
22 X_DATA_GROUP_ID in NUMBER,
23 X_MENU_ID in NUMBER,
24 X_START_DATE in DATE,
25 X_END_DATE in DATE,
26 X_GROUP_APPLICATION_ID in NUMBER,
27 X_REQUEST_GROUP_ID in NUMBER,
28 X_VERSION in VARCHAR2,
29 X_RESPONSIBILITY_KEY in VARCHAR2,
30 X_RESPONSIBILITY_NAME in VARCHAR2,
31 X_DESCRIPTION in VARCHAR2,
32 X_CREATION_DATE in DATE,
33 X_CREATED_BY in NUMBER,
34 X_LAST_UPDATE_DATE in DATE,
35 X_LAST_UPDATED_BY in NUMBER,
36 X_LAST_UPDATE_LOGIN in NUMBER);
37
38 procedure LOCK_ROW (
39 X_RESPONSIBILITY_ID in NUMBER,
40 X_APPLICATION_ID in NUMBER,
41 X_WEB_HOST_NAME in VARCHAR2,
42 X_WEB_AGENT_NAME in VARCHAR2,
43 X_DATA_GROUP_APPLICATION_ID in NUMBER,
44 X_DATA_GROUP_ID in NUMBER,
45 X_MENU_ID in NUMBER,
46 X_START_DATE in DATE,
47 X_END_DATE in DATE,
48 X_GROUP_APPLICATION_ID in NUMBER,
49 X_REQUEST_GROUP_ID in NUMBER,
50 X_VERSION in VARCHAR2,
51 X_RESPONSIBILITY_KEY in VARCHAR2,
52 X_RESPONSIBILITY_NAME in VARCHAR2,
53 X_DESCRIPTION in VARCHAR2 );
54
55 procedure UPDATE_ROW (
56 X_RESPONSIBILITY_ID in NUMBER,
57 X_APPLICATION_ID in NUMBER,
58 X_WEB_HOST_NAME in VARCHAR2,
59 X_WEB_AGENT_NAME in VARCHAR2,
60 X_DATA_GROUP_APPLICATION_ID in NUMBER,
61 X_DATA_GROUP_ID in NUMBER,
62 X_MENU_ID in NUMBER,
63 X_START_DATE in DATE,
64 X_END_DATE in DATE,
65 X_GROUP_APPLICATION_ID in NUMBER,
66 X_REQUEST_GROUP_ID in NUMBER,
67 X_VERSION in VARCHAR2,
68 X_RESPONSIBILITY_KEY in VARCHAR2,
69 X_RESPONSIBILITY_NAME in VARCHAR2,
70 X_DESCRIPTION in VARCHAR2,
71 X_LAST_UPDATE_DATE in DATE,
72 X_LAST_UPDATED_BY in NUMBER,
73 X_LAST_UPDATE_LOGIN in NUMBER );
74
75 procedure TRANSLATE_ROW (
76 X_APP_SHORT_NAME in VARCHAR2,
77 X_RESP_KEY in VARCHAR2,
78 X_RESPONSIBILITY_NAME in VARCHAR2,
79 X_DESCRIPTION in VARCHAR2,
80 X_OWNER in VARCHAR2);
81
82 procedure LOAD_ROW (
83 X_APP_SHORT_NAME in VARCHAR2,
84 X_RESP_KEY in VARCHAR2,
85 X_RESPONSIBILITY_ID in VARCHAR2,
86 X_RESPONSIBILITY_NAME in VARCHAR2,
87 X_OWNER in VARCHAR2,
88 X_DATA_GROUP_APP_SHORT_NAME in VARCHAR2,
89 X_DATA_GROUP_NAME in VARCHAR2,
90 X_MENU_NAME in VARCHAR2,
91 X_START_DATE in VARCHAR2,
92 X_END_DATE in VARCHAR2,
93 X_DESCRIPTION in VARCHAR2,
94 X_GROUP_APP_SHORT_NAME in VARCHAR2,
95 X_REQUEST_GROUP_NAME in VARCHAR2,
96 X_VERSION in VARCHAR2,
97 X_WEB_HOST_NAME in VARCHAR2,
98 X_WEB_AGENT_NAME in VARCHAR2 );
99
100 procedure DELETE_ROW (
101 X_RESPONSIBILITY_ID in NUMBER,
102 X_APPLICATION_ID in NUMBER );
103
104 procedure ADD_LANGUAGE;
105
106 -- Overloaded !!
107 procedure TRANSLATE_ROW (
108 X_APP_SHORT_NAME in VARCHAR2,
109 X_RESP_KEY in VARCHAR2,
110 X_RESPONSIBILITY_NAME in VARCHAR2,
111 X_DESCRIPTION in VARCHAR2,
112 X_OWNER in VARCHAR2,
113 X_CUSTOM_MODE in VARCHAR2,
114 X_LAST_UPDATE_DATE in VARCHAR2);
115
116 -- Overloaded!!
117 /*#
118 * Creates or updates User's Responsibility data as appropriate.
119 * @param x_app_short_name Application Short Name
120 * @param x_resp_key Responsibility Key
121 * @param x_responsibility_id Responsibility ID
122 * @param x_responsibility_name Responsibility Name
123 * @param x_owner Owner Name
124 * @param x_data_group_app_short_name Application Short Name attached with Data Group
125 * @param x_data_group_name Data Group Name
126 * @param x_menu_name Menu Name Assigned to Responsibility
127 * @param x_start_date Responsibility Effective Start Date
128 * @param x_end_date Responsibility Effective End Date
129 * @param x_description Responsibility Description
130 * @param x_group_app_short_name Application Short Name attached with Request Group
131 * @param x_request_group_name Request Group Name
132 * @param x_version Version
133 * @param x_web_host_name Web Host Name
134 * @param x_web_agent_name Web Agent Name
135 * @param x_custom_mode Custom Mode
136 * @param x_last_update_date Creation/Update Date
137 * @rep:scope public
138 * @rep:lifecycle active
139 * @rep:displayname Create/Update Responsibility
140 * @rep:compatibility S
141 * @rep:ihelp FND/@dev_p_funcworks#dev_p_funcworks See the related online help
142 */
143 procedure LOAD_ROW (
144 X_APP_SHORT_NAME in VARCHAR2,
145 X_RESP_KEY in VARCHAR2,
146 X_RESPONSIBILITY_ID in VARCHAR2,
147 X_RESPONSIBILITY_NAME in VARCHAR2,
148 X_OWNER in VARCHAR2,
149 X_DATA_GROUP_APP_SHORT_NAME in VARCHAR2,
150 X_DATA_GROUP_NAME in VARCHAR2,
151 X_MENU_NAME in VARCHAR2,
152 X_START_DATE in VARCHAR2,
153 X_END_DATE in VARCHAR2,
154 X_DESCRIPTION in VARCHAR2,
155 X_GROUP_APP_SHORT_NAME in VARCHAR2,
156 X_REQUEST_GROUP_NAME in VARCHAR2,
157 X_VERSION in VARCHAR2,
158 X_WEB_HOST_NAME in VARCHAR2,
159 X_WEB_AGENT_NAME in VARCHAR2,
160 X_CUSTOM_MODE in VARCHAR2,
161 X_LAST_UPDATE_DATE in VARCHAR2);
162
163 --------------------------------------------------------------------------
164 /*
165 ** resp_synch - The centralized routine for communicating resp changes
166 ** with wf and entity mgr.
167 */
168 PROCEDURE resp_synch(p_application_id in number,
169 p_responsibility_id in number);
170 --------------------------------------------------------------------------
171
172 -- Overloaded!!
173 /*#
174 * Creates or updates User's Responsibility data as appropriate.
175 * @param x_app_short_name Application Short Name
176 * @param x_resp_key Responsibility Key
177 * @param x_responsibility_name Responsibility Name
178 * @param x_owner Owner Name
179 * @param x_data_group_app_short_name Application Short Name attached with Data Group
180 * @param x_data_group_name Data Group Name
181 * @param x_menu_name Menu Name Assigned to Responsibility
182 * @param x_start_date Responsibility Effective Start Date
183 * @param x_end_date Responsibility Effective End Date
184 * @param x_description Responsibility Description
185 * @param x_group_app_short_name Application Short Name attached with Request Group
186 * @param x_request_group_name Request Group Name
187 * @param x_version Version
188 * @param x_web_host_name Web Host Name
189 * @param x_web_agent_name Web Agent Name
190 * @param x_custom_mode Custom Mode
191 * @param x_last_update_date Creation/Update Date
192 * @rep:scope public
193 * @rep:lifecycle active
194 * @rep:displayname Create/Update Responsibility
195 * @rep:compatibility S
196 * @rep:ihelp FND/@dev_p_funcworks#dev_p_funcworks See the related online help
197 */
198 procedure LOAD_ROW (
199 X_APP_SHORT_NAME in VARCHAR2,
200 X_RESP_KEY in VARCHAR2,
201 X_RESPONSIBILITY_NAME in VARCHAR2,
202 X_OWNER in VARCHAR2,
203 X_DATA_GROUP_APP_SHORT_NAME in VARCHAR2,
204 X_DATA_GROUP_NAME in VARCHAR2,
205 X_MENU_NAME in VARCHAR2,
206 X_START_DATE in VARCHAR2,
207 X_END_DATE in VARCHAR2,
208 X_DESCRIPTION in VARCHAR2,
209 X_GROUP_APP_SHORT_NAME in VARCHAR2,
210 X_REQUEST_GROUP_NAME in VARCHAR2,
211 X_VERSION in VARCHAR2,
212 X_WEB_HOST_NAME in VARCHAR2,
213 X_WEB_AGENT_NAME in VARCHAR2,
214 X_CUSTOM_MODE in VARCHAR2,
215 X_LAST_UPDATE_DATE in VARCHAR2);
216
217 end FND_RESPONSIBILITY_PKG;