APPS.OKL_VLR_PVT dependencies on OKL_VALIDATION_RESULTS_TL

Line 11: DELETE FROM OKL_VALIDATION_RESULTS_TL T

7: PROCEDURE add_language IS
8:
9: BEGIN
10:
11: DELETE FROM OKL_VALIDATION_RESULTS_TL T
12: WHERE NOT EXISTS (SELECT NULL FROM OKL_VALIDATION_RESULTS_B B WHERE B.ID =T.ID);
13:
14: UPDATE OKL_VALIDATION_RESULTS_TL T
15: SET (VALIDATION_TEXT) =

Line 14: UPDATE OKL_VALIDATION_RESULTS_TL T

10:
11: DELETE FROM OKL_VALIDATION_RESULTS_TL T
12: WHERE NOT EXISTS (SELECT NULL FROM OKL_VALIDATION_RESULTS_B B WHERE B.ID =T.ID);
13:
14: UPDATE OKL_VALIDATION_RESULTS_TL T
15: SET (VALIDATION_TEXT) =
16: (SELECT
17: B.VALIDATION_TEXT
18: FROM

Line 19: OKL_VALIDATION_RESULTS_TL B

15: SET (VALIDATION_TEXT) =
16: (SELECT
17: B.VALIDATION_TEXT
18: FROM
19: OKL_VALIDATION_RESULTS_TL B
20: WHERE
21: B.ID = T.ID
22: AND B.LANGUAGE = T.SOURCE_LANG)
23: WHERE (T.ID, T.LANGUAGE) IN (SELECT

Line 27: OKL_VALIDATION_RESULTS_TL SUBB,

23: WHERE (T.ID, T.LANGUAGE) IN (SELECT
24: SUBT.ID,
25: SUBT.LANGUAGE
26: FROM
27: OKL_VALIDATION_RESULTS_TL SUBB,
28: OKL_VALIDATION_RESULTS_TL SUBT
29: WHERE
30: SUBB.ID = SUBT.ID
31: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 28: OKL_VALIDATION_RESULTS_TL SUBT

24: SUBT.ID,
25: SUBT.LANGUAGE
26: FROM
27: OKL_VALIDATION_RESULTS_TL SUBB,
28: OKL_VALIDATION_RESULTS_TL SUBT
29: WHERE
30: SUBB.ID = SUBT.ID
31: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
32: AND (SUBB.VALIDATION_TEXT <> SUBT.VALIDATION_TEXT

Line 37: INSERT INTO OKL_VALIDATION_RESULTS_TL (

33: OR (SUBB.VALIDATION_TEXT IS NULL AND SUBT.VALIDATION_TEXT IS NOT NULL)
34: )
35: );
36:
37: INSERT INTO OKL_VALIDATION_RESULTS_TL (
38: ID,
39: LANGUAGE,
40: SOURCE_LANG,
41: SFWT_FLAG,

Line 59: FROM OKL_VALIDATION_RESULTS_TL B, FND_LANGUAGES L

55: B.LAST_UPDATED_BY,
56: B.LAST_UPDATE_DATE,
57: B.LAST_UPDATE_LOGIN,
58: B.VALIDATION_TEXT
59: FROM OKL_VALIDATION_RESULTS_TL B, FND_LANGUAGES L
60: WHERE L.INSTALLED_FLAG IN ('I', 'B')
61: AND B.LANGUAGE = USERENV('LANG')
62: AND NOT EXISTS (
63: SELECT NULL

Line 64: FROM OKL_VALIDATION_RESULTS_TL T

60: WHERE L.INSTALLED_FLAG IN ('I', 'B')
61: AND B.LANGUAGE = USERENV('LANG')
62: AND NOT EXISTS (
63: SELECT NULL
64: FROM OKL_VALIDATION_RESULTS_TL T
65: WHERE T.ID = B.ID
66: AND T.LANGUAGE = L.LANGUAGE_CODE
67: );
68:

Line 537: INSERT INTO OKL_VALIDATION_RESULTS_TL (

533: ELSE
534: l_sfwt_flag := 'Y';
535: END IF;
536:
537: INSERT INTO OKL_VALIDATION_RESULTS_TL (
538: id
539: ,language
540: ,source_lang
541: ,sfwt_flag

Line 998: UPDATE OKL_VALIDATION_RESULTS_TL

994: BEGIN
995:
996: l_prog_name := G_PKG_NAME||'.update_row (TL)';
997:
998: UPDATE OKL_VALIDATION_RESULTS_TL
999: SET
1000: source_lang = USERENV('LANG')
1001: ,sfwt_flag = 'Y'
1002: ,last_updated_by = G_USER_ID

Line 1008: UPDATE OKL_VALIDATION_RESULTS_TL

1004: ,last_update_login = G_LOGIN_ID
1005: ,validation_text = p_vlrtl_rec.validation_text
1006: WHERE ID = p_vlrtl_rec.id;
1007:
1008: UPDATE OKL_VALIDATION_RESULTS_TL
1009: SET SFWT_FLAG = 'N'
1010: WHERE ID = p_vlrtl_rec.id
1011: AND SOURCE_LANG = LANGUAGE;
1012:

Line 1396: DELETE FROM OKL_VALIDATION_RESULTS_TL WHERE id = p_id;

1392:
1393: l_prog_name := G_PKG_NAME||'.delete_row (V)';
1394:
1395: DELETE FROM OKL_VALIDATION_RESULTS_B WHERE id = p_id;
1396: DELETE FROM OKL_VALIDATION_RESULTS_TL WHERE id = p_id;
1397:
1398: x_return_status := G_RET_STS_SUCCESS;
1399:
1400: EXCEPTION