DBA Data[Home] [Help]

APPS.ALR_PERIODIC_SETS_PKG dependencies on ALR_PERIODIC_SETS_S

Line 120: select alr_periodic_sets_s.nextval into l_per_id from dual;

116: exception
117:
118: when NO_DATA_FOUND then
119:
120: select alr_periodic_sets_s.nextval into l_per_id from dual;
121:
122: ALR_PERIODIC_SETS_PKG.INSERT_ROW(
123: X_ROWID => l_row_id,
124: X_APPLICATION_ID => l_app_id,

Line 179: update ALR_PERIODIC_SETS set

175: X_LAST_UPDATED_BY in NUMBER,
176: X_LAST_UPDATE_LOGIN in NUMBER
177: ) is
178: begin
179: update ALR_PERIODIC_SETS set
180: NAME = X_NAME,
181: DESCRIPTION = X_DESCRIPTION,
182: APPLICATION_ID = X_APPLICATION_ID,
183: PERIODIC_SET_ID = X_PERIODIC_SET_ID,