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.AME_CONFIG_VARS_API dependencies on AME_SEED_UTILITY

Line 10: if AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is not null and to_number(AME_SEED_UTILITY.AME_INSTALLATION_LEVEL) >= 2 then

6: ,X_APPLICATION_ID out nocopy number
7: ) as
8: begin
9: if X_APPLICATION_SHORT_NAME is null then
10: if AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is not null and to_number(AME_SEED_UTILITY.AME_INSTALLATION_LEVEL) >= 2 then
11: X_APPLICATION_ID := 0;
12: else
13: X_APPLICATION_ID := null;
14: end if;

Line 39: if AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is not null and

35: ,X_VARIABLE_VALUE in out nocopy varchar2
36: ) as
37: begin
38: if X_VARIABLE_NAME = 'rulePriorityModes' then
39: if AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is not null and
40: instrb(X_VARIABLE_VALUE,':',1,7) = 0 then
41: X_VARIABLE_VALUE := 'disabled:' || X_VARIABLE_VALUE || ':disabled';
42: elsif AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is null and instrb(X_VARIABLE_VALUE,':',1,7) > 0 then
43: X_VARIABLE_VALUE := substrb(X_VARIABLE_VALUE, instrb(X_VARIABLE_VALUE,':', 1, 1)+1);

Line 42: elsif AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is null and instrb(X_VARIABLE_VALUE,':',1,7) > 0 then

38: if X_VARIABLE_NAME = 'rulePriorityModes' then
39: if AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is not null and
40: instrb(X_VARIABLE_VALUE,':',1,7) = 0 then
41: X_VARIABLE_VALUE := 'disabled:' || X_VARIABLE_VALUE || ':disabled';
42: elsif AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is null and instrb(X_VARIABLE_VALUE,':',1,7) > 0 then
43: X_VARIABLE_VALUE := substrb(X_VARIABLE_VALUE, instrb(X_VARIABLE_VALUE,':', 1, 1)+1);
44: X_VARIABLE_VALUE := substrb(X_VARIABLE_VALUE, 1, instrb(X_VARIABLE_VALUE,':',1,6)-1);
45: end if;
46: end if;

Line 149: if not AME_SEED_UTILITY.MLS_ENABLED then

145: and (X_APPLICATION_ID is null or X_APPLICATION_ID = 0))
146: or (APPLICATION_ID = X_APPLICATION_ID))
147: and sysdate between START_DATE and nvl(END_DATE - (1/86400), sysdate));
148:
149: if not AME_SEED_UTILITY.MLS_ENABLED then
150: return;
151: end if;
152: if(X_APPLICATION_ID = 0 or X_APPLICATION_ID = null) then
153: insert into AME_CONFIG_VARS_TL

Line 248: if not AME_SEED_UTILITY.MLS_ENABLED then

244: ,X_LAST_UPDATE_LOGIN
245: ,X_OBJECT_VERSION_NUMBER
246: );
247:
248: if not AME_SEED_UTILITY.MLS_ENABLED then
249: return;
250: end if;
251: if(X_APPLICATION_ID = 0 or X_APPLICATION_ID = null) then
252: update AME_CONFIG_VARS_TL

Line 295: if not AME_SEED_UTILITY.MLS_ENABLED then

291: END_DATE = X_END_DATE,
292: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
293: where ROWID = X_ROWID;
294:
295: if not AME_SEED_UTILITY.MLS_ENABLED then
296: return;
297: end if;
298: if(X_APPLICATION_ID = 0 or X_APPLICATION_ID = null) then
299: update AME_CONFIG_VARS_TL

Line 344: L_END_DATE := AME_SEED_UTILITY.GET_DEFAULT_END_DATE;

340: L_USER_CONFIG_VAR_NAME := X_USER_CONFIG_VAR_NAME;
341: L_DESCRIPTION := X_DESCRIPTION;
342: L_OWNER := X_OWNER;
343: L_LAST_UPDATE_DATE := X_LAST_UPDATE_DATE;
344: L_END_DATE := AME_SEED_UTILITY.GET_DEFAULT_END_DATE;
345:
346: KEY_TO_IDS
347: (X_APPLICATION_SHORT_NAME => L_APPLICATION_SHORT_NAME
348: ,X_TRANSACTION_TYPE_ID => L_TRANSACTION_TYPE_ID

Line 378: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)

374: ,X_USER_CONFIG_VAR_NAME => L_USER_CONFIG_VAR_NAME
375: ,X_APPLICATION_ID => L_APPLICATION_ID
376: ,X_VARIABLE_VALUE => L_VARIABLE_VALUE
377: ,X_DESCRIPTION => L_DESCRIPTION
378: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
379: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
380: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
381: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
382: ,X_LAST_UPDATE_LOGIN => 0

Line 379: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

375: ,X_APPLICATION_ID => L_APPLICATION_ID
376: ,X_VARIABLE_VALUE => L_VARIABLE_VALUE
377: ,X_DESCRIPTION => L_DESCRIPTION
378: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
379: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
380: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
381: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
382: ,X_LAST_UPDATE_LOGIN => 0
383: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

Line 380: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)

376: ,X_VARIABLE_VALUE => L_VARIABLE_VALUE
377: ,X_DESCRIPTION => L_DESCRIPTION
378: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
379: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
380: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
381: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
382: ,X_LAST_UPDATE_LOGIN => 0
383: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
384: ,X_END_DATE => L_END_DATE

Line 381: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

377: ,X_DESCRIPTION => L_DESCRIPTION
378: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
379: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
380: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
381: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
382: ,X_LAST_UPDATE_LOGIN => 0
383: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
384: ,X_END_DATE => L_END_DATE
385: ,X_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER

Line 383: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

379: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
380: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
381: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
382: ,X_LAST_UPDATE_LOGIN => 0
383: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
384: ,X_END_DATE => L_END_DATE
385: ,X_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER
386: );
387: else

Line 394: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

390: ,X_USER_CONFIG_VAR_NAME => L_USER_CONFIG_VAR_NAME
391: ,X_APPLICATION_ID => L_APPLICATION_ID
392: ,X_VARIABLE_VALUE => L_VARIABLE_VALUE
393: ,X_DESCRIPTION => L_DESCRIPTION
394: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
395: ,X_END_DATE => L_END_DATE
396: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
397: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
398: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)

Line 396: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)

392: ,X_VARIABLE_VALUE => L_VARIABLE_VALUE
393: ,X_DESCRIPTION => L_DESCRIPTION
394: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
395: ,X_END_DATE => L_END_DATE
396: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
397: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
398: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
399: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
400: ,X_LAST_UPDATE_LOGIN => 0

Line 397: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

393: ,X_DESCRIPTION => L_DESCRIPTION
394: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
395: ,X_END_DATE => L_END_DATE
396: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
397: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
398: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
399: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
400: ,X_LAST_UPDATE_LOGIN => 0
401: ,X_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER

Line 398: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)

394: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
395: ,X_END_DATE => L_END_DATE
396: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
397: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
398: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
399: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
400: ,X_LAST_UPDATE_LOGIN => 0
401: ,X_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER
402: );

Line 399: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

395: ,X_END_DATE => L_END_DATE
396: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
397: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
398: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
399: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
400: ,X_LAST_UPDATE_LOGIN => 0
401: ,X_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER
402: );
403: end if;

Line 413: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

409: ,X_USER_CONFIG_VAR_NAME => L_USER_CONFIG_VAR_NAME
410: ,X_APPLICATION_ID => L_APPLICATION_ID
411: ,X_VARIABLE_VALUE => L_VARIABLE_VALUE
412: ,X_DESCRIPTION => L_DESCRIPTION
413: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
414: ,X_END_DATE => L_END_DATE
415: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
416: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
417: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)

Line 415: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)

411: ,X_VARIABLE_VALUE => L_VARIABLE_VALUE
412: ,X_DESCRIPTION => L_DESCRIPTION
413: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
414: ,X_END_DATE => L_END_DATE
415: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
416: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
417: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
418: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
419: ,X_LAST_UPDATE_LOGIN => 0

Line 416: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

412: ,X_DESCRIPTION => L_DESCRIPTION
413: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
414: ,X_END_DATE => L_END_DATE
415: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
416: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
417: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
418: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
419: ,X_LAST_UPDATE_LOGIN => 0
420: ,X_OBJECT_VERSION_NUMBER => 1

Line 417: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)

413: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
414: ,X_END_DATE => L_END_DATE
415: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
416: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
417: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
418: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
419: ,X_LAST_UPDATE_LOGIN => 0
420: ,X_OBJECT_VERSION_NUMBER => 1
421: );

Line 418: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

414: ,X_END_DATE => L_END_DATE
415: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
416: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
417: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
418: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
419: ,X_LAST_UPDATE_LOGIN => 0
420: ,X_OBJECT_VERSION_NUMBER => 1
421: );
422: end;

Line 434: if not AME_SEED_UTILITY.MLS_ENABLED then

430: ,X_LAST_UPDATE_DATE in varchar2
431: ) as
432: L_DUMMY varchar2(1);
433: begin
434: if not AME_SEED_UTILITY.MLS_ENABLED then
435: return;
436: end if;
437: begin
438: select null

Line 448: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),

444: update AME_CONFIG_VARS_TL ACVTL
445: set USER_CONFIG_VAR_NAME = nvl(X_USER_CONFIG_VAR_NAME,ACVTL.USER_CONFIG_VAR_NAME),
446: DESCRIPTION = nvl(X_DESCRIPTION,ACVTL.DESCRIPTION),
447: SOURCE_LANG = userenv('LANG'),
448: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),
449: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
450: LAST_UPDATE_LOGIN = 0
451: where ACVTL.VARIABLE_NAME = X_VARIABLE_NAME
452: and userenv('LANG') in (ACVTL.LANGUAGE,ACVTL.SOURCE_LANG);

Line 449: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),

445: set USER_CONFIG_VAR_NAME = nvl(X_USER_CONFIG_VAR_NAME,ACVTL.USER_CONFIG_VAR_NAME),
446: DESCRIPTION = nvl(X_DESCRIPTION,ACVTL.DESCRIPTION),
447: SOURCE_LANG = userenv('LANG'),
448: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),
449: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),
450: LAST_UPDATE_LOGIN = 0
451: where ACVTL.VARIABLE_NAME = X_VARIABLE_NAME
452: and userenv('LANG') in (ACVTL.LANGUAGE,ACVTL.SOURCE_LANG);
453: exception

Line 475: AME_SEED_UTILITY.DATE_AS_STRING(ACVTL.LAST_UPDATE_DATE),

471: begin
472: if X_UPLOAD_MODE = 'NLS' then
473: begin
474: select ACVTL.LAST_UPDATED_BY,
475: AME_SEED_UTILITY.DATE_AS_STRING(ACVTL.LAST_UPDATE_DATE),
476: AME_SEED_UTILITY.OWNER_AS_STRING(ACVTL.CREATED_BY)
477: into X_CURRENT_OWNER,
478: X_CURRENT_LAST_UPDATE_DATE,
479: X_CREATED_BY

Line 476: AME_SEED_UTILITY.OWNER_AS_STRING(ACVTL.CREATED_BY)

472: if X_UPLOAD_MODE = 'NLS' then
473: begin
474: select ACVTL.LAST_UPDATED_BY,
475: AME_SEED_UTILITY.DATE_AS_STRING(ACVTL.LAST_UPDATE_DATE),
476: AME_SEED_UTILITY.OWNER_AS_STRING(ACVTL.CREATED_BY)
477: into X_CURRENT_OWNER,
478: X_CURRENT_LAST_UPDATE_DATE,
479: X_CREATED_BY
480: from AME_CONFIG_VARS_TL ACVTL

Line 483: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then

479: X_CREATED_BY
480: from AME_CONFIG_VARS_TL ACVTL
481: where ACVTL.VARIABLE_NAME = X_VARIABLE_NAME
482: and ACVTL.LANGUAGE = userenv('LANG');
483: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then
484: return true;
485: else
486: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST
487: (X_CURRENT_OWNER => X_CURRENT_OWNER

Line 486: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST

482: and ACVTL.LANGUAGE = userenv('LANG');
483: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then
484: return true;
485: else
486: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST
487: (X_CURRENT_OWNER => X_CURRENT_OWNER
488: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE
489: ,X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER)
490: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE

Line 489: ,X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER)

485: else
486: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST
487: (X_CURRENT_OWNER => X_CURRENT_OWNER
488: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE
489: ,X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER)
490: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
491: ,X_CUSTOM_MODE => X_CUSTOM_MODE
492: );
493: end if;

Line 502: AME_SEED_UTILITY.DATE_AS_STRING(ACV.LAST_UPDATE_DATE)

498: else
499: begin
500: if X_APPLICATION_SHORT_NAME is not null then
501: select ACV.LAST_UPDATED_BY,
502: AME_SEED_UTILITY.DATE_AS_STRING(ACV.LAST_UPDATE_DATE)
503: into X_CURRENT_OWNER,
504: X_CURRENT_LAST_UPDATE_DATE
505: from AME_CONFIG_VARS ACV,
506: AME_CALLING_APPS ACA,

Line 518: AME_SEED_UTILITY.DATE_AS_STRING(ACV.LAST_UPDATE_DATE)

514: and sysdate between ACV.START_DATE and nvl(ACV.END_DATE - (1/86400),sysdate)
515: and sysdate between ACA.START_DATE and nvl(ACA.END_DATE - (1/86400),sysdate);
516: else
517: select ACV.LAST_UPDATED_BY,
518: AME_SEED_UTILITY.DATE_AS_STRING(ACV.LAST_UPDATE_DATE)
519: into X_CURRENT_OWNER,
520: X_CURRENT_LAST_UPDATE_DATE
521: from AME_CONFIG_VARS ACV
522: where (ACV.APPLICATION_ID is null or ACV.APPLICATION_ID = 0)

Line 526: return AME_SEED_UTILITY.MERGE_ROW_TEST

522: where (ACV.APPLICATION_ID is null or ACV.APPLICATION_ID = 0)
523: and ACV.VARIABLE_NAME = X_VARIABLE_NAME
524: and sysdate between ACV.START_DATE and nvl(ACV.END_DATE - (1/86400),sysdate);
525: end if;
526: return AME_SEED_UTILITY.MERGE_ROW_TEST
527: (X_CURRENT_OWNER => X_CURRENT_OWNER
528: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE
529: ,X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER)
530: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE

Line 529: ,X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER)

525: end if;
526: return AME_SEED_UTILITY.MERGE_ROW_TEST
527: (X_CURRENT_OWNER => X_CURRENT_OWNER
528: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE
529: ,X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER)
530: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
531: ,X_CUSTOM_MODE => X_CUSTOM_MODE
532: );
533: exception

Line 555: AME_SEED_UTILITY.INIT_AME_INSTALLATION_LEVEL;

551: ) as
552: X_ATTRIBUTE_VALUE varchar2(10);
553: X_APPLICATION_NAME AME_CALLING_APPS.APPLICATION_NAME%TYPE;
554: begin
555: AME_SEED_UTILITY.INIT_AME_INSTALLATION_LEVEL;
556:
557: if AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is not null and
558: X_VARIABLE_NAME = 'useWorkflow' then
559: if X_VARIABLE_VALUE = 'yes' then

Line 557: if AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is not null and

553: X_APPLICATION_NAME AME_CALLING_APPS.APPLICATION_NAME%TYPE;
554: begin
555: AME_SEED_UTILITY.INIT_AME_INSTALLATION_LEVEL;
556:
557: if AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is not null and
558: X_VARIABLE_NAME = 'useWorkflow' then
559: if X_VARIABLE_VALUE = 'yes' then
560: X_ATTRIBUTE_VALUE := 'true';
561: else

Line 594: if AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is null then

590: );
591: return;
592: end if;
593:
594: if AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is null then
595: if X_VARIABLE_NAME in ('allowAllApproverTypes'
596: ,'allowFyiNotifications'
597: ,'allowAllItemClassRules'
598: ,'productionFunctionality') then

Line 606: elsif AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is not null and to_number(AME_SEED_UTILITY.AME_INSTALLATION_LEVEL) >= 2 then

602: ,'ONCE_PER_SUBLIST'
603: ,'ONCE_PER_GROUP_OR_CHAIN') then
604: return;
605: end if;
606: elsif AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is not null and to_number(AME_SEED_UTILITY.AME_INSTALLATION_LEVEL) >= 2 then
607: if X_VARIABLE_NAME in ('helpPath'
608: ,'htmlPath'
609: ,'imagePath'
610: ,'portalUrl') then

Line 659: if AME_SEED_UTILITY.MLS_ENABLED then

655: and nvl(APPLICATION_ID,0) = nvl(X_APPLICATION_ID,0);
656: if sql%notfound then
657: raise no_data_found;
658: end if;
659: if AME_SEED_UTILITY.MLS_ENABLED then
660: delete from AME_CONFIG_VARS_TL
661: where VARIABLE_NAME = X_VARIABLE_NAME;
662: end if;
663: end DELETE_ROW;