APPS.GMD_CUSTOMER_TESTS_PVT dependencies on GMD_CUSTOMER_TESTS_TL

Line 45: insert into GMD_CUSTOMER_TESTS_TL (

41: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
42: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
43: );
44:
45: insert into GMD_CUSTOMER_TESTS_TL (
46: TEST_ID,
47: CUST_ID,
48: CUST_TEST_DISPLAY,
49: CREATION_DATE,

Line 71: from GMD_CUSTOMER_TESTS_TL T

67: from FND_LANGUAGES L
68: where L.INSTALLED_FLAG in ('I', 'B')
69: and not exists
70: (select NULL
71: from GMD_CUSTOMER_TESTS_TL T
72: where T.TEST_ID = X_TEST_ID
73: and T.CUST_ID = X_CUST_ID
74: and T.LANGUAGE = L.LANGUAGE_CODE);
75:

Line 133: from GMD_CUSTOMER_TESTS_TL

129:
130: cursor c1 is select
131: CUST_TEST_DISPLAY,
132: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
133: from GMD_CUSTOMER_TESTS_TL
134: where TEST_ID = X_TEST_ID
135: and CUST_ID = X_CUST_ID
136: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
137: for update of TEST_ID nowait;

Line 196: update GMD_CUSTOMER_TESTS_TL set

192: if (sql%notfound) then
193: raise no_data_found;
194: end if;
195:
196: update GMD_CUSTOMER_TESTS_TL set
197: CUST_TEST_DISPLAY = X_CUST_TEST_DISPLAY,
198: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
199: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
200: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),

Line 216: delete from GMD_CUSTOMER_TESTS_TL

212: P_TEST_ID IN NUMBER,
213: P_CUST_ID IN NUMBER) RETURN BOOLEAN IS
214: begin
215: IF P_TEST_ID IS NOT NULL AND P_CUST_ID IS NOT NULL THEN
216: delete from GMD_CUSTOMER_TESTS_TL
217: where TEST_ID = P_TEST_ID
218: and CUST_ID = P_CUST_ID;
219:
220: if (sql%notfound) then

Line 251: delete from GMD_CUSTOMER_TESTS_TL T

247:
248: procedure ADD_LANGUAGE
249: is
250: begin
251: delete from GMD_CUSTOMER_TESTS_TL T
252: where not exists
253: (select NULL
254: from GMD_CUSTOMER_TESTS_B B
255: where B.TEST_ID = T.TEST_ID

Line 259: update GMD_CUSTOMER_TESTS_TL T set (

255: where B.TEST_ID = T.TEST_ID
256: and B.CUST_ID = T.CUST_ID
257: );
258:
259: update GMD_CUSTOMER_TESTS_TL T set (
260: CUST_TEST_DISPLAY
261: ) = (select
262: B.CUST_TEST_DISPLAY
263: from GMD_CUSTOMER_TESTS_TL B

Line 263: from GMD_CUSTOMER_TESTS_TL B

259: update GMD_CUSTOMER_TESTS_TL T set (
260: CUST_TEST_DISPLAY
261: ) = (select
262: B.CUST_TEST_DISPLAY
263: from GMD_CUSTOMER_TESTS_TL B
264: where B.TEST_ID = T.TEST_ID
265: and B.CUST_ID = T.CUST_ID
266: and B.LANGUAGE = T.SOURCE_LANG)
267: where (

Line 275: from GMD_CUSTOMER_TESTS_TL SUBB, GMD_CUSTOMER_TESTS_TL SUBT

271: ) in (select
272: SUBT.TEST_ID,
273: SUBT.CUST_ID,
274: SUBT.LANGUAGE
275: from GMD_CUSTOMER_TESTS_TL SUBB, GMD_CUSTOMER_TESTS_TL SUBT
276: where SUBB.TEST_ID = SUBT.TEST_ID
277: and SUBB.CUST_ID = SUBT.CUST_ID
278: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
279: and (SUBB.CUST_TEST_DISPLAY <> SUBT.CUST_TEST_DISPLAY

Line 282: insert into GMD_CUSTOMER_TESTS_TL (

278: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
279: and (SUBB.CUST_TEST_DISPLAY <> SUBT.CUST_TEST_DISPLAY
280: ));
281:
282: insert into GMD_CUSTOMER_TESTS_TL (
283: TEST_ID,
284: CUST_ID,
285: CUST_TEST_DISPLAY,
286: CREATION_DATE,

Line 304: from GMD_CUSTOMER_TESTS_TL B, FND_LANGUAGES L

300: B.LAST_UPDATE_DATE,
301: B.LAST_UPDATE_LOGIN,
302: L.LANGUAGE_CODE,
303: B.SOURCE_LANG
304: from GMD_CUSTOMER_TESTS_TL B, FND_LANGUAGES L
305: where L.INSTALLED_FLAG in ('I', 'B')
306: and B.LANGUAGE = userenv('LANG')
307: and not exists
308: (select NULL

Line 309: from GMD_CUSTOMER_TESTS_TL T

305: where L.INSTALLED_FLAG in ('I', 'B')
306: and B.LANGUAGE = userenv('LANG')
307: and not exists
308: (select NULL
309: from GMD_CUSTOMER_TESTS_TL T
310: where T.TEST_ID = B.TEST_ID
311: and T.CUST_ID = B.CUST_ID
312: and T.LANGUAGE = L.LANGUAGE_CODE);
313: end ADD_LANGUAGE;