APPS.AMS_APPROVERS_PKG dependencies on AMS_APPROVERS

Line 1: package body AMS_APPROVERS_PKG as

1: package body AMS_APPROVERS_PKG as
2: /* $Header: amslaprb.pls 120.1 2005/06/27 05:38:04 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_APPROVER_ID in NUMBER,

Line 25: insert into AMS_APPROVERS (

21: X_LAST_UPDATED_BY in NUMBER,
22: X_LAST_UPDATE_LOGIN in NUMBER
23: ) is
24: begin
25: insert into AMS_APPROVERS (
26: SEEDED_FLAG,
27: ACTIVE_FLAG,
28: START_DATE_ACTIVE,
29: END_DATE_ACTIVE,

Line 96: from AMS_APPROVERS

92: OBJECT_APPROVER_ID,
93: NOTIFICATION_TYPE,
94: NOTIFICATION_TIMEOUT,
95: APPROVER_ID
96: from AMS_APPROVERS
97: where APPROVER_ID = X_APPROVER_ID
98: for update of APPROVER_ID nowait;
99: begin
100: for tlinfo in c1 loop

Line 154: update AMS_APPROVERS set

150: X_LAST_UPDATED_BY in NUMBER,
151: X_LAST_UPDATE_LOGIN in NUMBER
152: ) is
153: begin
154: update AMS_APPROVERS set
155: SEEDED_FLAG = X_SEEDED_FLAG,
156: ACTIVE_FLAG = nvl(X_ACTIVE_FLAG, 'Y'),
157: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
158: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 182: delete from AMS_APPROVERS

178: procedure DELETE_ROW (
179: X_APPROVER_ID in NUMBER
180: ) is
181: begin
182: delete from AMS_APPROVERS
183: where APPROVER_ID = X_APPROVER_ID;
184:
185: if (sql%notfound) then
186: raise no_data_found;

Line 215: from AMS_APPROVERS

211: l_row_id varchar2(100);
212:
213: cursor c_obj_verno is
214: select object_version_number
215: from AMS_APPROVERS
216: where approver_id = X_APPROVER_ID;
217:
218: cursor c_chk_apr_exists is
219: select 'x'

Line 220: from AMS_APPROVERS

216: where approver_id = X_APPROVER_ID;
217:
218: cursor c_chk_apr_exists is
219: select 'x'
220: from AMS_APPROVERS
221: where approver_id = X_APPROVER_ID;
222:
223: cursor c_get_apr_id is
224: select AMS_APPROVERS_S.nextval

Line 224: select AMS_APPROVERS_S.nextval

220: from AMS_APPROVERS
221: where approver_id = X_APPROVER_ID;
222:
223: cursor c_get_apr_id is
224: select AMS_APPROVERS_S.nextval
225: from dual;
226:
227: BEGIN
228: if X_OWNER = 'SEED' then

Line 246: AMS_APPROVERS_PKG.INSERT_ROW(

242: else
243: l_approver_id := X_APPROVER_ID;
244: end if;
245: l_obj_verno := 1;
246: AMS_APPROVERS_PKG.INSERT_ROW(
247: X_ROWID => l_row_id,
248: X_APPROVER_ID => l_approver_id,
249: X_SEEDED_FLAG => X_SEEDED_FLAG,
250: X_ACTIVE_FLAG => X_ACTIVE_FLAG,

Line 274: AMS_APPROVERS_PKG.UPDATE_ROW(

270: fetch c_obj_verno into l_obj_verno;
271: close c_obj_verno;
272: -- assigning value for l_user_status_id
273: l_approver_id := X_APPROVER_ID;
274: AMS_APPROVERS_PKG.UPDATE_ROW(
275: X_APPROVER_ID => l_approver_id,
276: X_SEEDED_FLAG => X_SEEDED_FLAG,
277: X_ACTIVE_FLAG => X_ACTIVE_FLAG,
278: X_START_DATE_ACTIVE => X_START_DATE_ACTIVE,

Line 296: END AMS_APPROVERS_PKG;

292: END IF;
293:
294: END LOAD_ROW;
295:
296: END AMS_APPROVERS_PKG;
297:
298: