APPS.ALR_PERIODIC_SETS_PKG dependencies on ALR_PERIODIC_SETS

Line 1: package body ALR_PERIODIC_SETS_PKG as

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

Line 15: cursor C is select ROWID from ALR_PERIODIC_SETS

11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: ) is
15: cursor C is select ROWID from ALR_PERIODIC_SETS
16: where APPLICATION_ID = X_APPLICATION_ID
17: and PERIODIC_SET_ID = X_PERIODIC_SET_ID
18: ;
19: begin

Line 20: insert into ALR_PERIODIC_SETS (

16: where APPLICATION_ID = X_APPLICATION_ID
17: and PERIODIC_SET_ID = X_PERIODIC_SET_ID
18: ;
19: begin
20: insert into ALR_PERIODIC_SETS (
21: CREATION_DATE,
22: LAST_UPDATE_LOGIN,
23: NAME,
24: DESCRIPTION,

Line 84: from alr_periodic_sets

80: from fnd_application
81: where application_short_name = X_APPLICATION_SHORT_NAME;
82:
83: select periodic_set_id into l_per_id
84: from alr_periodic_sets
85: where application_id = l_app_id
86: and name = X_NAME;
87:
88: /* TSHORT 5251609 - Deleting children as

Line 98: from ALR_PERIODIC_SETS

94: and periodic_set_id = l_per_id;
95:
96: select last_updated_by, last_update_date
97: into db_luby, db_ludate
98: from ALR_PERIODIC_SETS
99: where application_id = l_app_id
100: and periodic_set_id = l_per_id;
101:
102: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,

Line 106: ALR_PERIODIC_SETS_PKG.UPDATE_ROW(

102: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,db_ludate,
103: x_custom_mode)) then
104:
105:
106: ALR_PERIODIC_SETS_PKG.UPDATE_ROW(
107: X_APPLICATION_ID => l_app_id,
108: X_PERIODIC_SET_ID => l_per_id,
109: X_NAME => X_NAME,
110: X_DESCRIPTION => X_DESCRIPTION,

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 122: ALR_PERIODIC_SETS_PKG.INSERT_ROW(

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,
125: X_PERIODIC_SET_ID => l_per_id,
126: X_NAME => X_NAME,

Line 148: from ALR_PERIODIC_SETS

144: NAME,
145: DESCRIPTION,
146: APPLICATION_ID,
147: PERIODIC_SET_ID
148: from ALR_PERIODIC_SETS
149: where APPLICATION_ID = X_APPLICATION_ID
150: and PERIODIC_SET_ID = X_PERIODIC_SET_ID
151: for update of APPLICATION_ID nowait;
152: begin

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,

Line 200: delete from ALR_PERIODIC_SETS

196: X_APPLICATION_ID in NUMBER,
197: X_PERIODIC_SET_ID in NUMBER
198: ) is
199: begin
200: delete from ALR_PERIODIC_SETS
201: where APPLICATION_ID = X_APPLICATION_ID
202: and PERIODIC_SET_ID = X_PERIODIC_SET_ID;
203:
204: if (sql%notfound) then

Line 211: end ALR_PERIODIC_SETS_PKG;

207:
208: end DELETE_ROW;
209:
210:
211: end ALR_PERIODIC_SETS_PKG;