APPS.EDR_FWK_TEST_PKG dependencies on EDR_FWK_TEST_TL

Line 138: insert into EDR_FWK_TEST_TL (

134: X_LAST_UPDATED_BY,
135: X_LAST_UPDATE_LOGIN
136: );
137:
138: insert into EDR_FWK_TEST_TL (
139: FWK_TEST_ID,
140: FWK_TEST_DESCRIPTION,
141: CREATED_BY,
142: CREATION_DATE,

Line 162: from EDR_FWK_TEST_TL T

158: from FND_LANGUAGES L
159: where L.INSTALLED_FLAG in ('I', 'B')
160: and not exists
161: (select NULL
162: from EDR_FWK_TEST_TL T
163: where T.FWK_TEST_ID = X_FWK_TEST_ID
164: and T.LANGUAGE = L.LANGUAGE_CODE);
165:
166: open c;

Line 259: from EDR_FWK_TEST_TL

255:
256: cursor c1 is select
257: FWK_TEST_DESCRIPTION,
258: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
259: from EDR_FWK_TEST_TL
260: where FWK_TEST_ID = X_FWK_TEST_ID
261: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
262: for update of FWK_TEST_ID nowait;
263: begin

Line 452: update EDR_FWK_TEST_TL set

448: if (sql%notfound) then
449: raise no_data_found;
450: end if;
451:
452: update EDR_FWK_TEST_TL set
453: FWK_TEST_DESCRIPTION = X_FWK_TEST_DESCRIPTION,
454: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
455: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
456: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 470: delete from EDR_FWK_TEST_TL

466: procedure DELETE_ROW (
467: X_FWK_TEST_ID in NUMBER
468: ) is
469: begin
470: delete from EDR_FWK_TEST_TL
471: where FWK_TEST_ID = X_FWK_TEST_ID;
472:
473: if (sql%notfound) then
474: raise no_data_found;

Line 488: delete from EDR_FWK_TEST_TL T

484:
485: procedure ADD_LANGUAGE
486: is
487: begin
488: delete from EDR_FWK_TEST_TL T
489: where not exists
490: (select NULL
491: from EDR_FWK_TEST_B B
492: where B.FWK_TEST_ID = T.FWK_TEST_ID

Line 495: update EDR_FWK_TEST_TL T set (

491: from EDR_FWK_TEST_B B
492: where B.FWK_TEST_ID = T.FWK_TEST_ID
493: );
494:
495: update EDR_FWK_TEST_TL T set (
496: FWK_TEST_DESCRIPTION
497: ) = (select
498: B.FWK_TEST_DESCRIPTION
499: from EDR_FWK_TEST_TL B

Line 499: from EDR_FWK_TEST_TL B

495: update EDR_FWK_TEST_TL T set (
496: FWK_TEST_DESCRIPTION
497: ) = (select
498: B.FWK_TEST_DESCRIPTION
499: from EDR_FWK_TEST_TL B
500: where B.FWK_TEST_ID = T.FWK_TEST_ID
501: and B.LANGUAGE = T.SOURCE_LANG)
502: where (
503: T.FWK_TEST_ID,

Line 508: from EDR_FWK_TEST_TL SUBB, EDR_FWK_TEST_TL SUBT

504: T.LANGUAGE
505: ) in (select
506: SUBT.FWK_TEST_ID,
507: SUBT.LANGUAGE
508: from EDR_FWK_TEST_TL SUBB, EDR_FWK_TEST_TL SUBT
509: where SUBB.FWK_TEST_ID = SUBT.FWK_TEST_ID
510: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
511: and (SUBB.FWK_TEST_DESCRIPTION <> SUBT.FWK_TEST_DESCRIPTION
512: or (SUBB.FWK_TEST_DESCRIPTION is null and SUBT.FWK_TEST_DESCRIPTION is not null)

Line 516: insert into EDR_FWK_TEST_TL (

512: or (SUBB.FWK_TEST_DESCRIPTION is null and SUBT.FWK_TEST_DESCRIPTION is not null)
513: or (SUBB.FWK_TEST_DESCRIPTION is not null and SUBT.FWK_TEST_DESCRIPTION is null)
514: ));
515:
516: insert into EDR_FWK_TEST_TL (
517: FWK_TEST_ID,
518: FWK_TEST_DESCRIPTION,
519: CREATED_BY,
520: CREATION_DATE,

Line 536: from EDR_FWK_TEST_TL B, FND_LANGUAGES L

532: B.LAST_UPDATED_BY,
533: B.LAST_UPDATE_LOGIN,
534: L.LANGUAGE_CODE,
535: B.SOURCE_LANG
536: from EDR_FWK_TEST_TL B, FND_LANGUAGES L
537: where L.INSTALLED_FLAG in ('I', 'B')
538: and B.LANGUAGE = userenv('LANG')
539: and not exists
540: (select NULL

Line 541: from EDR_FWK_TEST_TL T

537: where L.INSTALLED_FLAG in ('I', 'B')
538: and B.LANGUAGE = userenv('LANG')
539: and not exists
540: (select NULL
541: from EDR_FWK_TEST_TL T
542: where T.FWK_TEST_ID = B.FWK_TEST_ID
543: and T.LANGUAGE = L.LANGUAGE_CODE);
544: end ADD_LANGUAGE;
545: