APPS.GMD_STABILITY_STUDIES_PVT dependencies on GMD_STABILITY_STUDIES_TL

Line 216: insert into GMD_STABILITY_STUDIES_TL (

212: X_LAST_UPDATED_BY,
213: X_LAST_UPDATE_LOGIN
214: );
215:
216: insert into GMD_STABILITY_STUDIES_TL (
217: SS_ID,
218: DESCRIPTION,
219: CREATION_DATE,
220: CREATED_BY,

Line 240: from GMD_STABILITY_STUDIES_TL T

236: from FND_LANGUAGES L
237: where L.INSTALLED_FLAG in ('I', 'B')
238: and not exists
239: (select NULL
240: from GMD_STABILITY_STUDIES_TL T
241: where T.SS_ID = X_SS_ID
242: and T.LANGUAGE = L.LANGUAGE_CODE);
243:
244: open c;

Line 387: from GMD_STABILITY_STUDIES_TL

383:
384: cursor c1 is select
385: DESCRIPTION,
386: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
387: from GMD_STABILITY_STUDIES_TL
388: where SS_ID = X_SS_ID
389: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
390: for update of SS_ID nowait;
391: begin

Line 667: update GMD_STABILITY_STUDIES_TL set

663: if (sql%notfound) then
664: raise no_data_found;
665: end if;
666:
667: update GMD_STABILITY_STUDIES_TL set
668: DESCRIPTION = X_DESCRIPTION,
669: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
670: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
671: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 685: delete from GMD_STABILITY_STUDIES_TL

681: procedure DELETE_ROW (
682: X_SS_ID in NUMBER
683: ) is
684: begin
685: delete from GMD_STABILITY_STUDIES_TL
686: where SS_ID = X_SS_ID;
687:
688: if (sql%notfound) then
689: raise no_data_found;

Line 703: delete from GMD_STABILITY_STUDIES_TL T

699:
700: procedure ADD_LANGUAGE
701: is
702: begin
703: delete from GMD_STABILITY_STUDIES_TL T
704: where not exists
705: (select NULL
706: from GMD_STABILITY_STUDIES_B B
707: where B.SS_ID = T.SS_ID

Line 710: update GMD_STABILITY_STUDIES_TL T set (

706: from GMD_STABILITY_STUDIES_B B
707: where B.SS_ID = T.SS_ID
708: );
709:
710: update GMD_STABILITY_STUDIES_TL T set (
711: DESCRIPTION
712: ) = (select
713: B.DESCRIPTION
714: from GMD_STABILITY_STUDIES_TL B

Line 714: from GMD_STABILITY_STUDIES_TL B

710: update GMD_STABILITY_STUDIES_TL T set (
711: DESCRIPTION
712: ) = (select
713: B.DESCRIPTION
714: from GMD_STABILITY_STUDIES_TL B
715: where B.SS_ID = T.SS_ID
716: and B.LANGUAGE = T.SOURCE_LANG)
717: where (
718: T.SS_ID,

Line 723: from GMD_STABILITY_STUDIES_TL SUBB, GMD_STABILITY_STUDIES_TL SUBT

719: T.LANGUAGE
720: ) in (select
721: SUBT.SS_ID,
722: SUBT.LANGUAGE
723: from GMD_STABILITY_STUDIES_TL SUBB, GMD_STABILITY_STUDIES_TL SUBT
724: where SUBB.SS_ID = SUBT.SS_ID
725: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
726: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
727: ));

Line 729: insert into GMD_STABILITY_STUDIES_TL (

725: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
726: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
727: ));
728:
729: insert into GMD_STABILITY_STUDIES_TL (
730: SS_ID,
731: DESCRIPTION,
732: CREATION_DATE,
733: CREATED_BY,

Line 749: from GMD_STABILITY_STUDIES_TL B, FND_LANGUAGES L

745: B.LAST_UPDATE_DATE,
746: B.LAST_UPDATE_LOGIN,
747: L.LANGUAGE_CODE,
748: B.SOURCE_LANG
749: from GMD_STABILITY_STUDIES_TL B, FND_LANGUAGES L
750: where L.INSTALLED_FLAG in ('I', 'B')
751: and B.LANGUAGE = userenv('LANG')
752: and not exists
753: (select NULL

Line 754: from GMD_STABILITY_STUDIES_TL T

750: where L.INSTALLED_FLAG in ('I', 'B')
751: and B.LANGUAGE = userenv('LANG')
752: and not exists
753: (select NULL
754: from GMD_STABILITY_STUDIES_TL T
755: where T.SS_ID = B.SS_ID
756: and T.LANGUAGE = L.LANGUAGE_CODE);
757: end ADD_LANGUAGE;
758: