APPS.AMW_CERTIFICATION_PKG dependencies on AMW_CERTIFICATION_TL

Line 130: insert into AMW_CERTIFICATION_TL (

126: X_STATEMENT_GROUP_ID,
127: X_FINANCIAL_STATEMENT_ID
128: );
129:
130: insert into AMW_CERTIFICATION_TL (
131: OBJECT_VERSION_NUMBER,
132: ORIG_SYSTEM_REFERENCE,
133: LAST_UPDATED_BY,
134: LAST_UPDATE_DATE,

Line 160: from AMW_CERTIFICATION_TL T

156: from FND_LANGUAGES L
157: where L.INSTALLED_FLAG in ('I', 'B')
158: and not exists
159: (select NULL
160: from AMW_CERTIFICATION_TL T
161: where T.CERTIFICATION_ID = X_CERTIFICATION_ID
162: and T.LANGUAGE = L.LANGUAGE_CODE);
163:
164: open c;

Line 253: from AMW_CERTIFICATION_TL

249: cursor c1 is select
250: CERTIFICATION_NAME,
251: CERTIFICATION_DESCRIPTION,
252: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
253: from AMW_CERTIFICATION_TL
254: where CERTIFICATION_ID = X_CERTIFICATION_ID
255: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
256: for update of CERTIFICATION_ID nowait;
257: begin

Line 428: update AMW_CERTIFICATION_TL set

424: if (sql%notfound) then
425: raise no_data_found;
426: end if;
427:
428: update AMW_CERTIFICATION_TL set
429: CERTIFICATION_NAME = X_CERTIFICATION_NAME,
430: CERTIFICATION_DESCRIPTION = X_CERTIFICATION_DESCRIPTION,
431: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
432: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 447: delete from AMW_CERTIFICATION_TL

443: procedure DELETE_ROW (
444: X_CERTIFICATION_ID in NUMBER
445: ) is
446: begin
447: delete from AMW_CERTIFICATION_TL
448: where CERTIFICATION_ID = X_CERTIFICATION_ID;
449:
450: if (sql%notfound) then
451: raise no_data_found;

Line 465: delete from AMW_CERTIFICATION_TL T

461:
462: procedure ADD_LANGUAGE
463: is
464: begin
465: delete from AMW_CERTIFICATION_TL T
466: where not exists
467: (select NULL
468: from AMW_CERTIFICATION_B B
469: where B.CERTIFICATION_ID = T.CERTIFICATION_ID

Line 472: update AMW_CERTIFICATION_TL T set (

468: from AMW_CERTIFICATION_B B
469: where B.CERTIFICATION_ID = T.CERTIFICATION_ID
470: );
471:
472: update AMW_CERTIFICATION_TL T set (
473: CERTIFICATION_NAME,
474: CERTIFICATION_DESCRIPTION
475: ) = (select
476: B.CERTIFICATION_NAME,

Line 478: from AMW_CERTIFICATION_TL B

474: CERTIFICATION_DESCRIPTION
475: ) = (select
476: B.CERTIFICATION_NAME,
477: B.CERTIFICATION_DESCRIPTION
478: from AMW_CERTIFICATION_TL B
479: where B.CERTIFICATION_ID = T.CERTIFICATION_ID
480: and B.LANGUAGE = T.SOURCE_LANG)
481: where (
482: T.CERTIFICATION_ID,

Line 487: from AMW_CERTIFICATION_TL SUBB, AMW_CERTIFICATION_TL SUBT

483: T.LANGUAGE
484: ) in (select
485: SUBT.CERTIFICATION_ID,
486: SUBT.LANGUAGE
487: from AMW_CERTIFICATION_TL SUBB, AMW_CERTIFICATION_TL SUBT
488: where SUBB.CERTIFICATION_ID = SUBT.CERTIFICATION_ID
489: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
490: and (SUBB.CERTIFICATION_NAME <> SUBT.CERTIFICATION_NAME
491: or SUBB.CERTIFICATION_DESCRIPTION <> SUBT.CERTIFICATION_DESCRIPTION

Line 496: insert into AMW_CERTIFICATION_TL (

492: or (SUBB.CERTIFICATION_DESCRIPTION is null and SUBT.CERTIFICATION_DESCRIPTION is not null)
493: or (SUBB.CERTIFICATION_DESCRIPTION is not null and SUBT.CERTIFICATION_DESCRIPTION is null)
494: ));
495:
496: insert into AMW_CERTIFICATION_TL (
497: OBJECT_VERSION_NUMBER,
498: ORIG_SYSTEM_REFERENCE,
499: LAST_UPDATED_BY,
500: LAST_UPDATE_DATE,

Line 522: from AMW_CERTIFICATION_TL B, FND_LANGUAGES L

518: B.LAST_UPDATE_LOGIN,
519: B.CERTIFICATION_ID,
520: B.CERTIFICATION_NAME,
521: L.LANGUAGE_CODE
522: from AMW_CERTIFICATION_TL B, FND_LANGUAGES L
523: where L.INSTALLED_FLAG in ('I', 'B')
524: and B.LANGUAGE = userenv('LANG')
525: and not exists
526: (select NULL

Line 527: from AMW_CERTIFICATION_TL T

523: where L.INSTALLED_FLAG in ('I', 'B')
524: and B.LANGUAGE = userenv('LANG')
525: and not exists
526: (select NULL
527: from AMW_CERTIFICATION_TL T
528: where T.CERTIFICATION_ID = B.CERTIFICATION_ID
529: and T.LANGUAGE = L.LANGUAGE_CODE);
530: end ADD_LANGUAGE;
531: