DBA Data[Home] [Help]

APPS.ALR_RESPONSE_VARIABLES_PKG dependencies on ALR_RESPONSE_VARIABLES_PKG

Line 1: package body ALR_RESPONSE_VARIABLES_PKG as

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

Line 139: ALR_RESPONSE_VARIABLES_PKG.UPDATE_ROW(

135:
136: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
137: x_custom_mode)) then
138:
139: ALR_RESPONSE_VARIABLES_PKG.UPDATE_ROW(
140: X_APPLICATION_ID => l_app_id,
141: X_ALERT_ID => l_alert_id,
142: X_RESPONSE_SET_ID => l_response_set_id,
143: X_VARIABLE_NUMBER => l_variable_number,

Line 162: ALR_RESPONSE_VARIABLES_PKG.INSERT_ROW(

158: when NO_DATA_FOUND then
159:
160: select ALR_RESPONSE_VARIABLES_S.nextval into l_variable_number from dual;
161:
162: ALR_RESPONSE_VARIABLES_PKG.INSERT_ROW(
163: X_ROWID => l_row_id,
164: X_APPLICATION_ID => l_app_id,
165: X_ALERT_ID => l_alert_id,
166: X_RESPONSE_SET_ID => l_response_set_id,

Line 300: end ALR_RESPONSE_VARIABLES_PKG;

296:
297: end DELETE_ROW;
298:
299:
300: end ALR_RESPONSE_VARIABLES_PKG;