eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_APPROVAL_DETAILS_PKG dependencies on AMS_APPROVAL_DETAILS

Line 1: package body AMS_APPROVAL_DETAILS_PKG as

1: package body AMS_APPROVAL_DETAILS_PKG as
2: /* $Header: amslapdb.pls 120.1 2005/06/27 05:37:47 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_APPROVAL_DETAIL_ID in NUMBER,

Line 32: cursor C is select ROWID from AMS_APPROVAL_DETAILS

28: X_LAST_UPDATE_DATE in DATE,
29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER
31: ) is
32: cursor C is select ROWID from AMS_APPROVAL_DETAILS
33: where APPROVAL_DETAIL_ID = X_APPROVAL_DETAIL_ID
34: ;
35: begin
36: insert into AMS_APPROVAL_DETAILS (

Line 36: insert into AMS_APPROVAL_DETAILS (

32: cursor C is select ROWID from AMS_APPROVAL_DETAILS
33: where APPROVAL_DETAIL_ID = X_APPROVAL_DETAIL_ID
34: ;
35: begin
36: insert into AMS_APPROVAL_DETAILS (
37: START_DATE_ACTIVE,
38: END_DATE_ACTIVE,
39: APPROVAL_DETAIL_ID,
40: OBJECT_VERSION_NUMBER,

Line 88: insert into AMS_APPROVAL_DETAILS_TL (

84: X_LAST_UPDATED_BY,
85: X_LAST_UPDATE_LOGIN
86: );
87:
88: insert into AMS_APPROVAL_DETAILS_TL (
89: APPROVAL_DETAIL_ID,
90: CREATION_DATE,
91: CREATED_BY,
92: LAST_UPDATE_DATE,

Line 116: from AMS_APPROVAL_DETAILS_TL T

112: from FND_LANGUAGES L
113: where L.INSTALLED_FLAG in ('I', 'B')
114: and not exists
115: (select NULL
116: from AMS_APPROVAL_DETAILS_TL T
117: where T.APPROVAL_DETAIL_ID = X_APPROVAL_DETAIL_ID
118: and T.LANGUAGE = L.LANGUAGE_CODE);
119:
120: open c;

Line 169: from AMS_APPROVAL_DETAILS

165: APPROVAL_PRIORITY,
166: APPROVAL_LIMIT_TO,
167: APPROVAL_LIMIT_FROM,
168: SEEDED_FLAG
169: from AMS_APPROVAL_DETAILS
170: where APPROVAL_DETAIL_ID = X_APPROVAL_DETAIL_ID
171: for update of APPROVAL_DETAIL_ID nowait;
172: recinfo c%rowtype;
173:

Line 178: from AMS_APPROVAL_DETAILS_TL

174: cursor c1 is select
175: NAME,
176: DESCRIPTION,
177: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
178: from AMS_APPROVAL_DETAILS_TL
179: where APPROVAL_DETAIL_ID = X_APPROVAL_DETAIL_ID
180: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
181: for update of APPROVAL_DETAIL_ID nowait;
182: begin

Line 271: update AMS_APPROVAL_DETAILS set

267: X_LAST_UPDATED_BY in NUMBER,
268: X_LAST_UPDATE_LOGIN in NUMBER
269: ) is
270: begin
271: update AMS_APPROVAL_DETAILS set
272: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
273: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
274: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
275: --SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,

Line 299: update AMS_APPROVAL_DETAILS_TL set

295: if (sql%notfound) then
296: raise no_data_found;
297: end if;
298:
299: update AMS_APPROVAL_DETAILS_TL set
300: NAME = X_NAME,
301: DESCRIPTION = X_DESCRIPTION,
302: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
303: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 318: delete from AMS_APPROVAL_DETAILS_TL

314: procedure DELETE_ROW (
315: X_APPROVAL_DETAIL_ID in NUMBER
316: ) is
317: begin
318: delete from AMS_APPROVAL_DETAILS_TL
319: where APPROVAL_DETAIL_ID = X_APPROVAL_DETAIL_ID;
320:
321: if (sql%notfound) then
322: raise no_data_found;

Line 325: delete from AMS_APPROVAL_DETAILS

321: if (sql%notfound) then
322: raise no_data_found;
323: end if;
324:
325: delete from AMS_APPROVAL_DETAILS
326: where APPROVAL_DETAIL_ID = X_APPROVAL_DETAIL_ID;
327:
328: if (sql%notfound) then
329: raise no_data_found;

Line 336: delete from AMS_APPROVAL_DETAILS_TL T

332:
333: procedure ADD_LANGUAGE
334: is
335: begin
336: delete from AMS_APPROVAL_DETAILS_TL T
337: where not exists
338: (select NULL
339: from AMS_APPROVAL_DETAILS B
340: where B.APPROVAL_DETAIL_ID = T.APPROVAL_DETAIL_ID

Line 339: from AMS_APPROVAL_DETAILS B

335: begin
336: delete from AMS_APPROVAL_DETAILS_TL T
337: where not exists
338: (select NULL
339: from AMS_APPROVAL_DETAILS B
340: where B.APPROVAL_DETAIL_ID = T.APPROVAL_DETAIL_ID
341: );
342:
343: update AMS_APPROVAL_DETAILS_TL T set (

Line 343: update AMS_APPROVAL_DETAILS_TL T set (

339: from AMS_APPROVAL_DETAILS B
340: where B.APPROVAL_DETAIL_ID = T.APPROVAL_DETAIL_ID
341: );
342:
343: update AMS_APPROVAL_DETAILS_TL T set (
344: NAME,
345: DESCRIPTION
346: ) = (select
347: B.NAME,

Line 349: from AMS_APPROVAL_DETAILS_TL B

345: DESCRIPTION
346: ) = (select
347: B.NAME,
348: B.DESCRIPTION
349: from AMS_APPROVAL_DETAILS_TL B
350: where B.APPROVAL_DETAIL_ID = T.APPROVAL_DETAIL_ID
351: and B.LANGUAGE = T.SOURCE_LANG)
352: where (
353: T.APPROVAL_DETAIL_ID,

Line 358: from AMS_APPROVAL_DETAILS_TL SUBB, AMS_APPROVAL_DETAILS_TL SUBT

354: T.LANGUAGE
355: ) in (select
356: SUBT.APPROVAL_DETAIL_ID,
357: SUBT.LANGUAGE
358: from AMS_APPROVAL_DETAILS_TL SUBB, AMS_APPROVAL_DETAILS_TL SUBT
359: where SUBB.APPROVAL_DETAIL_ID = SUBT.APPROVAL_DETAIL_ID
360: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
361: and (SUBB.NAME <> SUBT.NAME
362: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 367: insert into AMS_APPROVAL_DETAILS_TL (

363: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
364: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
365: ));
366:
367: insert into AMS_APPROVAL_DETAILS_TL (
368: APPROVAL_DETAIL_ID,
369: CREATION_DATE,
370: CREATED_BY,
371: LAST_UPDATE_DATE,

Line 391: from AMS_APPROVAL_DETAILS_TL B, FND_LANGUAGES L

387: B.DESCRIPTION,
388: --B.SECURITY_GROUP_ID,
389: L.LANGUAGE_CODE,
390: B.SOURCE_LANG
391: from AMS_APPROVAL_DETAILS_TL B, FND_LANGUAGES L
392: where L.INSTALLED_FLAG in ('I', 'B')
393: and B.LANGUAGE = userenv('LANG')
394: and not exists
395: (select NULL

Line 396: from AMS_APPROVAL_DETAILS_TL T

392: where L.INSTALLED_FLAG in ('I', 'B')
393: and B.LANGUAGE = userenv('LANG')
394: and not exists
395: (select NULL
396: from AMS_APPROVAL_DETAILS_TL T
397: where T.APPROVAL_DETAIL_ID = B.APPROVAL_DETAIL_ID
398: and T.LANGUAGE = L.LANGUAGE_CODE);
399: end ADD_LANGUAGE;
400:

Line 408: update AMS_APPROVAL_DETAILS_TL set

404: X_DESCRIPTION in VARCHAR2,
405: X_OWNER in VARCHAR2
406: ) IS
407: begin
408: update AMS_APPROVAL_DETAILS_TL set
409: name = nvl(x_name, name),
410: description = nvl(x_description, description),
411: source_lang = userenv('LANG'),
412: last_update_date = sysdate,

Line 452: from AMS_APPROVAL_DETAILS

448: l_row_id varchar2(100);
449:
450: cursor c_obj_verno is
451: select object_version_number
452: from AMS_APPROVAL_DETAILS
453: where approval_detail_id = X_APPROVAL_DETAIL_ID;
454:
455: cursor c_chk_apr_dtls_exists is
456: select 'x'

Line 457: from AMS_APPROVAL_DETAILS

453: where approval_detail_id = X_APPROVAL_DETAIL_ID;
454:
455: cursor c_chk_apr_dtls_exists is
456: select 'x'
457: from AMS_APPROVAL_DETAILS
458: where approval_detail_id = X_APPROVAL_DETAIL_ID;
459:
460: cursor c_get_apr_dtl_id is
461: select AMS_APPROVAL_DETAILS_S.nextval

Line 461: select AMS_APPROVAL_DETAILS_S.nextval

457: from AMS_APPROVAL_DETAILS
458: where approval_detail_id = X_APPROVAL_DETAIL_ID;
459:
460: cursor c_get_apr_dtl_id is
461: select AMS_APPROVAL_DETAILS_S.nextval
462: from dual;
463:
464: BEGIN
465: if X_OWNER = 'SEED' then

Line 483: AMS_APPROVAL_DETAILS_PKG.INSERT_ROW(

479: else
480: l_approval_detail_id := X_APPROVAL_DETAIL_ID;
481: end if;
482: l_obj_verno := 1;
483: AMS_APPROVAL_DETAILS_PKG.INSERT_ROW(
484: X_ROWID => l_row_id,
485: X_APPROVAL_DETAIL_ID => l_approval_detail_id,
486: X_START_DATE_ACTIVE => X_START_DATE_ACTIVE,
487: X_END_DATE_ACTIVE => X_END_DATE_ACTIVE,

Line 518: AMS_APPROVAL_DETAILS_PKG.UPDATE_ROW(

514: fetch c_obj_verno into l_obj_verno;
515: close c_obj_verno;
516: -- assigning value for l_user_status_id
517: l_approval_detail_id := X_APPROVAL_DETAIL_ID;
518: AMS_APPROVAL_DETAILS_PKG.UPDATE_ROW(
519: X_APPROVAL_DETAIL_ID => l_approval_detail_id,
520: X_START_DATE_ACTIVE => X_START_DATE_ACTIVE,
521: X_END_DATE_ACTIVE => X_END_DATE_ACTIVE,
522: X_OBJECT_VERSION_NUMBER => l_obj_verno+1,

Line 547: end AMS_APPROVAL_DETAILS_PKG;

543: );
544: END iF;
545: END;
546:
547: end AMS_APPROVAL_DETAILS_PKG;