APPS.GMD_SPEC_TESTS_PVT dependencies on GMD_SPEC_TESTS_TL

Line 256: insert into GMD_SPEC_TESTS_TL (

252: X_CALC_UOM_CONV_IND,
253: X_TO_QTY_UOM
254: );
255:
256: insert into GMD_SPEC_TESTS_TL (
257: CREATED_BY,
258: LAST_UPDATED_BY,
259: LAST_UPDATE_DATE,
260: LAST_UPDATE_LOGIN,

Line 282: from GMD_SPEC_TESTS_TL T

278: from FND_LANGUAGES L
279: where L.INSTALLED_FLAG in ('I', 'B')
280: and not exists
281: (select NULL
282: from GMD_SPEC_TESTS_TL T
283: where T.SPEC_ID = X_SPEC_ID
284: and T.TEST_ID = X_TEST_ID
285: and T.LANGUAGE = L.LANGUAGE_CODE);
286:

Line 458: from GMD_SPEC_TESTS_TL

454:
455: cursor c1 is select
456: TEST_DISPLAY,
457: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
458: from GMD_SPEC_TESTS_TL
459: where SPEC_ID = X_SPEC_ID
460: and TEST_ID = X_TEST_ID
461: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
462: for update of SPEC_ID nowait;

Line 804: update GMD_SPEC_TESTS_TL set

800: if (sql%notfound) then
801: raise no_data_found;
802: end if;
803:
804: update GMD_SPEC_TESTS_TL set
805: TEST_DISPLAY = X_TEST_DISPLAY,
806: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
807: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
808: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),

Line 825: delete from GMD_SPEC_TESTS_TL

821: P_TEST_ID in NUMBER
822: ) RETURN BOOLEAN IS
823: begin
824: IF p_spec_id IS NOT NULL and p_test_id IS NOT NULL THEN
825: delete from GMD_SPEC_TESTS_TL
826: where SPEC_ID = P_SPEC_ID
827: and TEST_ID = P_TEST_ID;
828:
829: if (sql%notfound) then

Line 862: delete from GMD_SPEC_TESTS_TL T

858:
859: procedure ADD_LANGUAGE
860: is
861: begin
862: delete from GMD_SPEC_TESTS_TL T
863: where not exists
864: (select NULL
865: from GMD_SPEC_TESTS_B B
866: where B.SPEC_ID = T.SPEC_ID

Line 870: update GMD_SPEC_TESTS_TL T set (

866: where B.SPEC_ID = T.SPEC_ID
867: and B.TEST_ID = T.TEST_ID
868: );
869:
870: update GMD_SPEC_TESTS_TL T set (
871: TEST_DISPLAY
872: ) = (select
873: B.TEST_DISPLAY
874: from GMD_SPEC_TESTS_TL B

Line 874: from GMD_SPEC_TESTS_TL B

870: update GMD_SPEC_TESTS_TL T set (
871: TEST_DISPLAY
872: ) = (select
873: B.TEST_DISPLAY
874: from GMD_SPEC_TESTS_TL B
875: where B.SPEC_ID = T.SPEC_ID
876: and B.TEST_ID = T.TEST_ID
877: and B.LANGUAGE = T.SOURCE_LANG)
878: where (

Line 886: from GMD_SPEC_TESTS_TL SUBB, GMD_SPEC_TESTS_TL SUBT

882: ) in (select
883: SUBT.SPEC_ID,
884: SUBT.TEST_ID,
885: SUBT.LANGUAGE
886: from GMD_SPEC_TESTS_TL SUBB, GMD_SPEC_TESTS_TL SUBT
887: where SUBB.SPEC_ID = SUBT.SPEC_ID
888: and SUBB.TEST_ID = SUBT.TEST_ID
889: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
890: and (SUBB.TEST_DISPLAY <> SUBT.TEST_DISPLAY

Line 895: insert into GMD_SPEC_TESTS_TL (

891: or (SUBB.TEST_DISPLAY is null and SUBT.TEST_DISPLAY is not null)
892: or (SUBB.TEST_DISPLAY is not null and SUBT.TEST_DISPLAY is null)
893: ));
894:
895: insert into GMD_SPEC_TESTS_TL (
896: CREATED_BY,
897: LAST_UPDATED_BY,
898: LAST_UPDATE_DATE,
899: LAST_UPDATE_LOGIN,

Line 917: from GMD_SPEC_TESTS_TL B, FND_LANGUAGES L

913: B.TEST_DISPLAY,
914: B.CREATION_DATE,
915: L.LANGUAGE_CODE,
916: B.SOURCE_LANG
917: from GMD_SPEC_TESTS_TL B, FND_LANGUAGES L
918: where L.INSTALLED_FLAG in ('I', 'B')
919: and B.LANGUAGE = userenv('LANG')
920: and not exists
921: (select NULL

Line 922: from GMD_SPEC_TESTS_TL T

918: where L.INSTALLED_FLAG in ('I', 'B')
919: and B.LANGUAGE = userenv('LANG')
920: and not exists
921: (select NULL
922: from GMD_SPEC_TESTS_TL T
923: where T.SPEC_ID = B.SPEC_ID
924: and T.TEST_ID = B.TEST_ID
925: and T.LANGUAGE = L.LANGUAGE_CODE);
926: end ADD_LANGUAGE;