DBA Data[Home] [Help]

APPS.ALR_VALID_RESPONSES_PKG dependencies on ALR_VALID_RESPONSES_PKG

Line 1: package body ALR_VALID_RESPONSES_PKG as

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

Line 130: ALR_VALID_RESPONSES_PKG.UPDATE_ROW(

126:
127: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
128: x_custom_mode)) then
129:
130: ALR_VALID_RESPONSES_PKG.UPDATE_ROW(
131: X_APPLICATION_ID => l_app_id,
132: X_ALERT_ID => l_alert_id,
133: X_RESPONSE_SET_ID => l_response_set_id,
134: X_RESPONSE_ID => l_response_id,

Line 150: ALR_VALID_RESPONSES_PKG.INSERT_ROW(

146: when NO_DATA_FOUND then
147:
148: select ALR_VALID_RESPONSES_S.nextval into l_response_id from DUAL;
149:
150: ALR_VALID_RESPONSES_PKG.INSERT_ROW(
151: X_ROWID => l_row_id,
152: X_APPLICATION_ID => l_app_id,
153: X_ALERT_ID => l_alert_id,
154: X_RESPONSE_SET_ID => l_response_set_id,

Line 264: end ALR_VALID_RESPONSES_PKG;

260: end if;
261:
262: end DELETE_ROW;
263:
264: end ALR_VALID_RESPONSES_PKG;