APPS.ALR_MESSAGE_SYSTEMS_PKG dependencies on ALR_MESSAGE_SYSTEMS

Line 1: package body ALR_MESSAGE_SYSTEMS_PKG as

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

Line 16: cursor C is select ROWID from ALR_MESSAGE_SYSTEMS

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from ALR_MESSAGE_SYSTEMS
17: where NAME = X_NAME
18: ;
19: begin
20: insert into ALR_MESSAGE_SYSTEMS (

Line 20: insert into ALR_MESSAGE_SYSTEMS (

16: cursor C is select ROWID from ALR_MESSAGE_SYSTEMS
17: where NAME = X_NAME
18: ;
19: begin
20: insert into ALR_MESSAGE_SYSTEMS (
21: NAME,
22: CODE,
23: COMMAND,
24: ARGUMENTS,

Line 82: from ALR_MESSAGE_SYSTEMS

78: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
79:
80: select last_updated_by, last_update_date
81: into db_luby, db_ludate
82: from ALR_MESSAGE_SYSTEMS
83: where name = X_NAME;
84:
85: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
86: x_custom_mode)) then

Line 88: ALR_MESSAGE_SYSTEMS_PKG.UPDATE_ROW(

84:
85: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
86: x_custom_mode)) then
87:
88: ALR_MESSAGE_SYSTEMS_PKG.UPDATE_ROW(
89: X_NAME => X_NAME,
90: X_CODE => X_CODE,
91: X_COMMAND => X_COMMAND,
92: X_ARGUMENTS => X_ARGUMENTS,

Line 102: ALR_MESSAGE_SYSTEMS_PKG.INSERT_ROW(

98: end if;
99:
100: exception
101: when NO_DATA_FOUND then
102: ALR_MESSAGE_SYSTEMS_PKG.INSERT_ROW(
103: X_ROWID => l_row_id,
104: X_NAME => X_NAME,
105: X_CODE => X_CODE,
106: X_COMMAND => X_COMMAND,

Line 131: from ALR_MESSAGE_SYSTEMS

127: COMMAND,
128: ARGUMENTS,
129: ENABLED_FLAG,
130: NAME
131: from ALR_MESSAGE_SYSTEMS
132: where NAME = X_NAME
133: for update of NAME nowait;
134: begin
135: for recinfo in c1 loop

Line 165: update ALR_MESSAGE_SYSTEMS set

161: X_LAST_UPDATED_BY in NUMBER,
162: X_LAST_UPDATE_LOGIN in NUMBER
163: ) is
164: begin
165: update ALR_MESSAGE_SYSTEMS set
166: NAME = X_NAME,
167: CODE = X_CODE,
168: COMMAND = X_COMMAND,
169: ARGUMENTS = X_ARGUMENTS,

Line 185: delete from ALR_MESSAGE_SYSTEMS

181: procedure DELETE_ROW (
182: X_NAME in VARCHAR2
183: ) is
184: begin
185: delete from ALR_MESSAGE_SYSTEMS
186: where NAME = X_NAME;
187:
188: if (sql%notfound) then
189: raise no_data_found;

Line 195: end ALR_MESSAGE_SYSTEMS_PKG;

191:
192: end DELETE_ROW;
193:
194:
195: end ALR_MESSAGE_SYSTEMS_PKG;