eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ALR_DISTRIBUTION_LISTS_PKG dependencies on ALR_DISTRIBUTION_LISTS_S

Line 161: select alr_distribution_lists_s.nextval into l_list_id from dual;

157: end if;
158: exception
159: when NO_DATA_FOUND then
160:
161: select alr_distribution_lists_s.nextval into l_list_id from dual;
162:
163: ALR_DISTRIBUTION_LISTS_PKG.INSERT_ROW(
164: X_ROWID => l_row_id,
165: X_APPLICATION_ID => l_app_id,

Line 270: update ALR_DISTRIBUTION_LISTS set

266: X_LAST_UPDATE_LOGIN in NUMBER
267: ) is
268: begin
269: if (X_END_DATE_ACTIVE is null) then
270: update ALR_DISTRIBUTION_LISTS set
271: NAME = X_NAME,
272: DESCRIPTION = X_DESCRIPTION,
273: TO_RECIPIENTS = X_TO_RECIPIENTS,
274: CC_RECIPIENTS = X_CC_RECIPIENTS,

Line 290: update ALR_DISTRIBUTION_LISTS set

286: where APPLICATION_ID = X_APPLICATION_ID
287: and LIST_ID = X_LIST_ID
288: and END_DATE_ACTIVE is null;
289: else
290: update ALR_DISTRIBUTION_LISTS set
291: NAME = X_NAME,
292: DESCRIPTION = X_DESCRIPTION,
293: TO_RECIPIENTS = X_TO_RECIPIENTS,
294: CC_RECIPIENTS = X_CC_RECIPIENTS,