APPS.ALR_ORACLE_MAIL_ACCOUNTS_PKG dependencies on ALR_ORACLE_MAIL_ACCOUNTS

Line 1: package body ALR_ORACLE_MAIL_ACCOUNTS_PKG as

1: package body ALR_ORACLE_MAIL_ACCOUNTS_PKG as
2: /* $Header: ALROMLAB.pls 120.3.12010000.1 2008/07/27 06:58:48 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_APPLICATION_ID in NUMBER,

Line 17: cursor C is select ROWID from ALR_ORACLE_MAIL_ACCOUNTS

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from ALR_ORACLE_MAIL_ACCOUNTS
18: where APPLICATION_ID = X_APPLICATION_ID
19: and ORACLE_ID = X_ORACLE_ID
20: ;
21: begin

Line 22: insert into ALR_ORACLE_MAIL_ACCOUNTS (

18: where APPLICATION_ID = X_APPLICATION_ID
19: and ORACLE_ID = X_ORACLE_ID
20: ;
21: begin
22: insert into ALR_ORACLE_MAIL_ACCOUNTS (
23: LAST_UPDATE_LOGIN,
24: APPLICATION_ID,
25: ORACLE_ID,
26: NAME,

Line 97: from ALR_ORACLE_MAIL_ACCOUNTS

93: where ORACLE_USERNAME = X_ORACLE_USERNAME;
94:
95: select last_updated_by, last_update_date
96: into db_luby, db_ludate
97: from ALR_ORACLE_MAIL_ACCOUNTS
98: where application_id = l_app_id
99: and oracle_id = l_oracle_id;
100:
101: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

Line 104: ALR_ORACLE_MAIL_ACCOUNTS_PKG.UPDATE_ROW(

100:
101: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
102: x_custom_mode)) then
103:
104: ALR_ORACLE_MAIL_ACCOUNTS_PKG.UPDATE_ROW(
105: X_APPLICATION_ID => l_app_id,
106: X_ORACLE_ID => l_oracle_id,
107: X_NAME => X_NAME,
108: X_ENCRYPTED_PASSWORD => X_ENCRYPTED_PASSWORD,

Line 120: ALR_ORACLE_MAIL_ACCOUNTS_PKG.INSERT_ROW(

116: end if;
117:
118: exception
119: when no_data_found then
120: ALR_ORACLE_MAIL_ACCOUNTS_PKG.INSERT_ROW(
121: X_ROWID => l_row_id,
122: X_APPLICATION_ID => l_app_id,
123: X_ORACLE_ID => l_oracle_id,
124: X_NAME => X_NAME,

Line 152: from ALR_ORACLE_MAIL_ACCOUNTS

148: SENDMAIL_ACCOUNT,
149: DEFAULT_RESPONSE_ACCOUNT,
150: APPLICATION_ID,
151: ORACLE_ID
152: from ALR_ORACLE_MAIL_ACCOUNTS
153: where APPLICATION_ID = X_APPLICATION_ID
154: and ORACLE_ID = X_ORACLE_ID
155: for update of APPLICATION_ID nowait;
156: begin

Line 190: update ALR_ORACLE_MAIL_ACCOUNTS set

186: X_LAST_UPDATED_BY in NUMBER,
187: X_LAST_UPDATE_LOGIN in NUMBER
188: ) is
189: begin
190: update ALR_ORACLE_MAIL_ACCOUNTS set
191: NAME = X_NAME,
192: ENCRYPTED_PASSWORD = X_ENCRYPTED_PASSWORD,
193: SENDMAIL_ACCOUNT = X_SENDMAIL_ACCOUNT,
194: DEFAULT_RESPONSE_ACCOUNT = X_DEFAULT_RESPONSE_ACCOUNT,

Line 213: delete from ALR_ORACLE_MAIL_ACCOUNTS

209: X_APPLICATION_ID in NUMBER,
210: X_ORACLE_ID in NUMBER
211: ) is
212: begin
213: delete from ALR_ORACLE_MAIL_ACCOUNTS
214: where APPLICATION_ID = X_APPLICATION_ID
215: and ORACLE_ID = X_ORACLE_ID;
216:
217: if (sql%notfound) then

Line 223: end ALR_ORACLE_MAIL_ACCOUNTS_PKG;

219: end if;
220:
221: end DELETE_ROW;
222:
223: end ALR_ORACLE_MAIL_ACCOUNTS_PKG;