DBA Data[Home] [Help]

APPS.ALR_RESPONSE_SETS_PKG dependencies on ALR_RESPONSE_SETS_PKG

Line 1: package body ALR_RESPONSE_SETS_PKG as

1: package body ALR_RESPONSE_SETS_PKG as
2: /* $Header: ALRRSTSB.pls 120.4.12010000.1 2008/07/27 06:59:00 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_APPLICATION_ID in NUMBER,

Line 126: ALR_RESPONSE_SETS_PKG.UPDATE_ROW(

122:
123: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
124: x_custom_mode)) then
125:
126: ALR_RESPONSE_SETS_PKG.UPDATE_ROW(
127: X_APPLICATION_ID => l_app_id,
128: X_ALERT_ID => l_alert_id,
129: X_RESPONSE_SET_ID => l_resp_set_id,
130: X_NAME => X_RESP_SET_NAME,

Line 147: ALR_RESPONSE_SETS_PKG.INSERT_ROW(

143: when NO_DATA_FOUND then
144:
145: select ALR_RESPONSE_SETS_S.nextval into l_resp_set_id from DUAL;
146:
147: ALR_RESPONSE_SETS_PKG.INSERT_ROW(
148: X_ROWID => l_row_id,
149: X_APPLICATION_ID => l_app_id,
150: X_ALERT_ID => l_alert_id,
151: X_RESPONSE_SET_ID => l_resp_set_id,

Line 259: end ALR_RESPONSE_SETS_PKG;

255: end if;
256:
257: end DELETE_ROW;
258:
259: end ALR_RESPONSE_SETS_PKG;