APPS.FND_RESP_FUNCTIONS_PKG dependencies on FND_RESP_FUNCTIONS

Line 1: package body FND_RESP_FUNCTIONS_PKG as

1: package body FND_RESP_FUNCTIONS_PKG as
2: /* $Header: AFSCRFNB.pls 120.1 2005/07/02 03:09:15 appldev ship $ */
3:
4:
5: procedure INSERT_ROW (

Line 17: cursor C is select ROWID from FND_RESP_FUNCTIONS

13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATE_LOGIN in NUMBER)
16: is
17: cursor C is select ROWID from FND_RESP_FUNCTIONS
18: where APPLICATION_ID = X_APPLICATION_ID
19: and RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
20: and RULE_TYPE = X_RULE_TYPE
21: and ACTION_ID = X_ACTION_ID;

Line 23: insert into FND_RESP_FUNCTIONS (

19: and RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
20: and RULE_TYPE = X_RULE_TYPE
21: and ACTION_ID = X_ACTION_ID;
22: begin
23: insert into FND_RESP_FUNCTIONS (
24: APPLICATION_ID,
25: RESPONSIBILITY_ID,
26: ACTION_ID,
27: RULE_TYPE,

Line 66: from FND_RESP_FUNCTIONS

62: X_RULE_TYPE in VARCHAR2
63: ) is
64: cursor c1 is select
65: RULE_TYPE
66: from FND_RESP_FUNCTIONS
67: where APPLICATION_ID = X_APPLICATION_ID
68: and RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
69: and RULE_TYPE = X_RULE_TYPE
70: and ACTION_ID = X_ACTION_ID

Line 98: update FND_RESP_FUNCTIONS set

94: X_LAST_UPDATE_LOGIN in NUMBER)
95: is
96: begin
97: -- Kind of dull, but included for completeness.
98: update FND_RESP_FUNCTIONS set
99: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
100: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
101: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
102: where APPLICATION_ID = X_APPLICATION_ID

Line 122: delete from FND_RESP_FUNCTIONS

118: X_RULE_TYPE in VARCHAR2,
119: X_ACTION_ID in NUMBER
120: ) is
121: begin
122: delete from FND_RESP_FUNCTIONS
123: where APPLICATION_ID = X_APPLICATION_ID
124: and RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
125: and RULE_TYPE = X_RULE_TYPE
126: and ACTION_ID = X_ACTION_ID;

Line 145: fnd_resp_functions_pkg.load_row(

141: X_ACTION in VARCHAR2,
142: X_OWNER in VARCHAR2 )
143: is
144: begin
145: fnd_resp_functions_pkg.load_row(
146: X_APP_SHORT_NAME => X_APP_SHORT_NAME,
147: X_RESP_KEY => X_RESP_KEY,
148: X_RULE_TYPE => X_RULE_TYPE,
149: X_ACTION => X_ACTION,

Line 208: from fnd_resp_functions

204:
205: begin
206: select LAST_UPDATED_BY, LAST_UPDATE_DATE
207: into db_luby, db_ludate
208: from fnd_resp_functions
209: where ACTION_ID = act_id
210: and APPLICATION_ID = app_id
211: and RESPONSIBILITY_ID = resp_id
212: and RULE_TYPE = X_RULE_TYPE;

Line 216: fnd_resp_functions_pkg.update_row(

212: and RULE_TYPE = X_RULE_TYPE;
213:
214: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
215: db_ludate, X_CUSTOM_MODE)) then
216: fnd_resp_functions_pkg.update_row(
217: X_APPLICATION_ID => app_id,
218: X_RESPONSIBILITY_ID => resp_id,
219: X_ACTION_ID => act_id,
220: X_RULE_TYPE => X_RULE_TYPE,

Line 227: fnd_resp_functions_pkg.insert_row (

223: X_LAST_UPDATE_LOGIN => 0);
224: end if;
225: exception
226: when no_data_found then
227: fnd_resp_functions_pkg.insert_row (
228: X_ROWID => row_id ,
229: X_APPLICATION_ID => app_id,
230: X_RESPONSIBILITY_ID => resp_id,
231: X_ACTION_ID => act_id,

Line 241: end FND_RESP_FUNCTIONS_PKG;

237: X_LAST_UPDATE_LOGIN => 0);
238: end;
239: end LOAD_ROW;
240:
241: end FND_RESP_FUNCTIONS_PKG;