APPS.ALR_PROFILE_OPTIONS_PKG dependencies on ALR_PROFILE_OPTIONS

Line 1: package body ALR_PROFILE_OPTIONS_PKG as

1: package body ALR_PROFILE_OPTIONS_PKG as
2: /* $Header: ALRPOPTB.pls 120.3.12010000.1 2008/07/27 06:58:51 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_PROFILE_OPTION_NAME in VARCHAR2,

Line 18: cursor C is select ROWID from ALR_PROFILE_OPTIONS

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from ALR_PROFILE_OPTIONS
19: where PROFILE_OPTION_NAME = X_PROFILE_OPTION_NAME
20: ;
21: begin
22: insert into ALR_PROFILE_OPTIONS (

Line 22: insert into ALR_PROFILE_OPTIONS (

18: cursor C is select ROWID from ALR_PROFILE_OPTIONS
19: where PROFILE_OPTION_NAME = X_PROFILE_OPTION_NAME
20: ;
21: begin
22: insert into ALR_PROFILE_OPTIONS (
23: PROFILE_OPTION_NAME,
24: PROFILE_OPTION_VALUE,
25: PROFILE_OPTION_LONG,
26: DESCRIPTION,

Line 89: from ALR_PROFILE_OPTIONS

85: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
86:
87: select last_updated_by, last_update_date
88: into db_luby, db_ludate
89: from ALR_PROFILE_OPTIONS
90: where profile_option_name = X_PROFILE_OPTION_NAME;
91:
92: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
93: x_custom_mode)) then

Line 95: ALR_PROFILE_OPTIONS_PKG.UPDATE_ROW(

91:
92: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
93: x_custom_mode)) then
94:
95: ALR_PROFILE_OPTIONS_PKG.UPDATE_ROW(
96: X_PROFILE_OPTION_NAME => X_PROFILE_OPTION_NAME,
97: X_PROFILE_OPTION_VALUE => X_PROFILE_OPTION_VALUE,
98: X_PROFILE_OPTION_LONG => X_PROFILE_OPTION_LONG,
99: X_DESCRIPTION => X_DESCRIPTION,

Line 111: ALR_PROFILE_OPTIONS_PKG.INSERT_ROW(

107: end if;
108:
109: exception
110: when NO_DATA_FOUND then
111: ALR_PROFILE_OPTIONS_PKG.INSERT_ROW(
112: X_ROWID => l_row_id,
113: X_PROFILE_OPTION_NAME => X_PROFILE_OPTION_NAME,
114: X_PROFILE_OPTION_VALUE => X_PROFILE_OPTION_VALUE,
115: X_PROFILE_OPTION_LONG => X_PROFILE_OPTION_LONG,

Line 145: from ALR_PROFILE_OPTIONS

141: LONG_FLAG,
142: ENCRYPTED_PASSWORD,
143: LOOKUP_TYPE,
144: PROFILE_OPTION_NAME
145: from ALR_PROFILE_OPTIONS
146: where PROFILE_OPTION_NAME = X_PROFILE_OPTION_NAME
147: for update of PROFILE_OPTION_NAME nowait;
148: begin
149: for recinfo in c1 loop

Line 185: update ALR_PROFILE_OPTIONS set

181: X_LAST_UPDATED_BY in NUMBER,
182: X_LAST_UPDATE_LOGIN in NUMBER
183: ) is
184: begin
185: update ALR_PROFILE_OPTIONS set
186: PROFILE_OPTION_VALUE = X_PROFILE_OPTION_VALUE,
187: PROFILE_OPTION_LONG = X_PROFILE_OPTION_LONG,
188: DESCRIPTION = X_DESCRIPTION,
189: LONG_FLAG = X_LONG_FLAG,

Line 207: delete from ALR_PROFILE_OPTIONS

203: procedure DELETE_ROW (
204: X_PROFILE_OPTION_NAME in VARCHAR2
205: ) is
206: begin
207: delete from ALR_PROFILE_OPTIONS
208: where PROFILE_OPTION_NAME = X_PROFILE_OPTION_NAME;
209:
210: if (sql%notfound) then
211: raise no_data_found;

Line 216: end ALR_PROFILE_OPTIONS_PKG;

212: end if;
213:
214: end DELETE_ROW;
215:
216: end ALR_PROFILE_OPTIONS_PKG;