DBA Data[Home] [Help]

APPS.AME_PRODUCTION_ACTIONS_API dependencies on AME_SEED_UTILITY

Line 84: if not AME_SEED_UTILITY.MLS_ENABLED then

80: and PARAMETER = X_PARAMETER
81: and PARAMETER_TWO = X_PARAMETER_TWO
82: and sysdate between START_DATE and nvl(END_DATE - (1/86400), sysdate));
83:
84: if not AME_SEED_UTILITY.MLS_ENABLED then
85: return;
86: end if;
87:
88: insert into AME_ACTIONS_TL

Line 180: if not AME_SEED_UTILITY.MLS_ENABLED then

176: ,X_LAST_UPDATE_LOGIN
177: ,X_OBJECT_VERSION_NUMBER
178: );
179:
180: if not AME_SEED_UTILITY.MLS_ENABLED then
181: return;
182: end if;
183:
184: update AME_ACTIONS_TL

Line 248: L_END_DATE := AME_SEED_UTILITY.GET_DEFAULT_END_DATE;

244: L_PARAMETER_TWO := X_PARAMETER_TWO;
245: L_DESCRIPTION := X_DESCRIPTION;
246: L_OWNER := X_OWNER;
247: L_LAST_UPDATE_DATE := X_LAST_UPDATE_DATE;
248: L_END_DATE := AME_SEED_UTILITY.GET_DEFAULT_END_DATE;
249:
250: VALIDATE_ROW
251: (X_ACTION_TYPE_NAME => L_ACTION_TYPE_NAME);
252:

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

271: if X_CUSTOM_MODE = 'FORCE' then
272: FORCE_UPDATE_ROW
273: (X_ROWID => L_ROWID
274: ,X_DESCRIPTION => L_DESCRIPTION
275: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
276: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
277: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
278: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
279: ,X_LAST_UPDATE_LOGIN => 0

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

272: FORCE_UPDATE_ROW
273: (X_ROWID => L_ROWID
274: ,X_DESCRIPTION => L_DESCRIPTION
275: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
276: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
277: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
278: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
279: ,X_LAST_UPDATE_LOGIN => 0
280: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

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

273: (X_ROWID => L_ROWID
274: ,X_DESCRIPTION => L_DESCRIPTION
275: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
276: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
277: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
278: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
279: ,X_LAST_UPDATE_LOGIN => 0
280: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
281: ,X_END_DATE => L_END_DATE

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

274: ,X_DESCRIPTION => L_DESCRIPTION
275: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
276: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
277: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
278: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
279: ,X_LAST_UPDATE_LOGIN => 0
280: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
281: ,X_END_DATE => L_END_DATE
282: ,X_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER + 1

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

276: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
277: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
278: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
279: ,X_LAST_UPDATE_LOGIN => 0
280: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
281: ,X_END_DATE => L_END_DATE
282: ,X_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER + 1
283: );
284: else

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

287: ,X_ACTION_TYPE_ID => L_ACTION_TYPE_ID
288: ,X_PARAMETER => L_PARAMETER
289: ,X_PARAMETER_TWO => L_PARAMETER_TWO
290: ,X_DESCRIPTION => L_DESCRIPTION
291: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
292: ,X_END_DATE => L_END_DATE
293: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
294: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
295: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)

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

289: ,X_PARAMETER_TWO => L_PARAMETER_TWO
290: ,X_DESCRIPTION => L_DESCRIPTION
291: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
292: ,X_END_DATE => L_END_DATE
293: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
294: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
295: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
296: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
297: ,X_LAST_UPDATE_LOGIN => 0

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

290: ,X_DESCRIPTION => L_DESCRIPTION
291: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
292: ,X_END_DATE => L_END_DATE
293: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
294: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
295: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
296: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
297: ,X_LAST_UPDATE_LOGIN => 0
298: ,X_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER + 1

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

291: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
292: ,X_END_DATE => L_END_DATE
293: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
294: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
295: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
296: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
297: ,X_LAST_UPDATE_LOGIN => 0
298: ,X_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER + 1
299: );

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

292: ,X_END_DATE => L_END_DATE
293: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
294: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
295: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
296: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
297: ,X_LAST_UPDATE_LOGIN => 0
298: ,X_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER + 1
299: );
300: end if;

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

304: (X_ACTION_TYPE_ID => L_ACTION_TYPE_ID
305: ,X_PARAMETER => L_PARAMETER
306: ,X_PARAMETER_TWO => L_PARAMETER_TWO
307: ,X_DESCRIPTION => L_DESCRIPTION
308: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
309: ,X_END_DATE => L_END_DATE
310: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
311: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
312: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)

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

306: ,X_PARAMETER_TWO => L_PARAMETER_TWO
307: ,X_DESCRIPTION => L_DESCRIPTION
308: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
309: ,X_END_DATE => L_END_DATE
310: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
311: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
312: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
313: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
314: ,X_LAST_UPDATE_LOGIN => 0

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

307: ,X_DESCRIPTION => L_DESCRIPTION
308: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
309: ,X_END_DATE => L_END_DATE
310: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
311: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
312: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
313: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
314: ,X_LAST_UPDATE_LOGIN => 0
315: ,X_OBJECT_VERSION_NUMBER => 1

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

308: ,X_START_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
309: ,X_END_DATE => L_END_DATE
310: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
311: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
312: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
313: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
314: ,X_LAST_UPDATE_LOGIN => 0
315: ,X_OBJECT_VERSION_NUMBER => 1
316: );

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

309: ,X_END_DATE => L_END_DATE
310: ,X_CREATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
311: ,X_CREATION_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
312: ,X_LAST_UPDATED_BY => AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER)
313: ,X_LAST_UPDATE_DATE => AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE)
314: ,X_LAST_UPDATE_LOGIN => 0
315: ,X_OBJECT_VERSION_NUMBER => 1
316: );
317: end;

Line 337: if not AME_SEED_UTILITY.MLS_ENABLED then

333: L_ACTION_TYPE_NAME AME_ACTION_TYPES.NAME%TYPE;
334: L_OWNER varchar2(100);
335: L_LAST_UPDATE_DATE varchar2(19);
336: begin
337: if not AME_SEED_UTILITY.MLS_ENABLED then
338: return;
339: end if;
340:
341: L_ACTION_TYPE_NAME := X_ACTION_TYPE_NAME;

Line 371: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE),

367:
368: update AME_ACTIONS_TL ACTTL
369: set DESCRIPTION = nvl(L_DESCRIPTION,DESCRIPTION),
370: SOURCE_LANG = userenv('LANG'),
371: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE),
372: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER),
373: LAST_UPDATE_LOGIN = 0
374: where ACTTL.ACTION_ID = L_ACTION_ID
375: and userenv('LANG') in (ACTTL.LANGUAGE,ACTTL.SOURCE_LANG);

Line 372: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER),

368: update AME_ACTIONS_TL ACTTL
369: set DESCRIPTION = nvl(L_DESCRIPTION,DESCRIPTION),
370: SOURCE_LANG = userenv('LANG'),
371: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(L_LAST_UPDATE_DATE),
372: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(L_OWNER),
373: LAST_UPDATE_LOGIN = 0
374: where ACTTL.ACTION_ID = L_ACTION_ID
375: and userenv('LANG') in (ACTTL.LANGUAGE,ACTTL.SOURCE_LANG);
376: exception

Line 398: AME_SEED_UTILITY.DATE_AS_STRING(ACTTL.LAST_UPDATE_DATE),

394: begin
395: if X_UPLOAD_MODE = 'NLS' then
396: begin
397: select ACTTL.LAST_UPDATED_BY,
398: AME_SEED_UTILITY.DATE_AS_STRING(ACTTL.LAST_UPDATE_DATE),
399: AME_SEED_UTILITY.OWNER_AS_STRING(ACTTL.CREATED_BY)
400: into X_CURRENT_OWNER,
401: X_CURRENT_LAST_UPDATE_DATE,
402: X_CREATED_BY

Line 399: AME_SEED_UTILITY.OWNER_AS_STRING(ACTTL.CREATED_BY)

395: if X_UPLOAD_MODE = 'NLS' then
396: begin
397: select ACTTL.LAST_UPDATED_BY,
398: AME_SEED_UTILITY.DATE_AS_STRING(ACTTL.LAST_UPDATE_DATE),
399: AME_SEED_UTILITY.OWNER_AS_STRING(ACTTL.CREATED_BY)
400: into X_CURRENT_OWNER,
401: X_CURRENT_LAST_UPDATE_DATE,
402: X_CREATED_BY
403: from AME_ACTIONS_TL ACTTL,

Line 414: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then

410: and ACT.PARAMETER_TWO = X_PARAMETER_TWO
411: and ACTTL.LANGUAGE = userenv('LANG')
412: and sysdate between ACT.START_DATE and nvl(ACT.END_DATE - (1/86400),sysdate)
413: and sysdate between AAT.START_DATE and nvl(AAT.END_DATE - (1/86400),sysdate);
414: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then
415: return true;
416: else
417: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST
418: (X_CURRENT_OWNER => X_CURRENT_OWNER

Line 417: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST

413: and sysdate between AAT.START_DATE and nvl(AAT.END_DATE - (1/86400),sysdate);
414: if AME_SEED_UTILITY.IS_SEED_USER(X_CREATED_BY) then
415: return true;
416: else
417: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST
418: (X_CURRENT_OWNER => X_CURRENT_OWNER
419: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE
420: ,X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER)
421: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE

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

416: else
417: return AME_SEED_UTILITY.TL_MERGE_ROW_TEST
418: (X_CURRENT_OWNER => X_CURRENT_OWNER
419: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE
420: ,X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER)
421: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
422: ,X_CUSTOM_MODE => X_CUSTOM_MODE
423: );
424: end if;

Line 432: AME_SEED_UTILITY.DATE_AS_STRING(ACT.LAST_UPDATE_DATE)

428: end;
429: else
430: begin
431: select ACT.LAST_UPDATED_BY,
432: AME_SEED_UTILITY.DATE_AS_STRING(ACT.LAST_UPDATE_DATE)
433: into X_CURRENT_OWNER,
434: X_CURRENT_LAST_UPDATE_DATE
435: from AME_ACTIONS ACT,
436: AME_ACTION_TYPES AAT

Line 443: return AME_SEED_UTILITY.MERGE_ROW_TEST

439: and ACT.PARAMETER = X_PARAMETER
440: and ACT.PARAMETER_TWO = X_PARAMETER_TWO
441: and sysdate between ACT.START_DATE and nvl(ACT.END_DATE - (1/86400),sysdate)
442: and sysdate between AAT.START_DATE and nvl(AAT.END_DATE - (1/86400),sysdate);
443: return AME_SEED_UTILITY.MERGE_ROW_TEST
444: (X_CURRENT_OWNER => X_CURRENT_OWNER
445: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE
446: ,X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER)
447: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE

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

442: and sysdate between AAT.START_DATE and nvl(AAT.END_DATE - (1/86400),sysdate);
443: return AME_SEED_UTILITY.MERGE_ROW_TEST
444: (X_CURRENT_OWNER => X_CURRENT_OWNER
445: ,X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE
446: ,X_OWNER => AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER)
447: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE
448: ,X_CUSTOM_MODE => X_CUSTOM_MODE
449: );
450: exception

Line 468: AME_SEED_UTILITY.INIT_AME_INSTALLATION_LEVEL;

464: ,X_UPLOAD_MODE in varchar2
465: ,X_CUSTOM_MODE in varchar2
466: ) as
467: begin
468: AME_SEED_UTILITY.INIT_AME_INSTALLATION_LEVEL;
469:
470: if AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is null then
471: raise_application_error (-20001,'AME is trying to upload production actions to a 11.5.9 or lower instance');
472: end if;

Line 470: if AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is null then

466: ) as
467: begin
468: AME_SEED_UTILITY.INIT_AME_INSTALLATION_LEVEL;
469:
470: if AME_SEED_UTILITY.AME_INSTALLATION_LEVEL is null then
471: raise_application_error (-20001,'AME is trying to upload production actions to a 11.5.9 or lower instance');
472: end if;
473:
474: if MERGE_ROW_TEST

Line 510: if AME_SEED_UTILITY.MLS_ENABLED then

506: procedure DELETE_ROW
507: (X_ACTION_ID in number
508: ) as
509: begin
510: if AME_SEED_UTILITY.MLS_ENABLED then
511: delete from AME_ACTIONS_TL
512: where ACTION_ID = X_ACTION_ID;
513: end if;
514: delete from AME_ACTIONS