APPS.OKL_LAP_PVT dependencies on OKL_LEASE_APPLICATIONS_TL

Line 11: DELETE FROM OKL_LEASE_APPLICATIONS_TL T

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

Line 17: UPDATE OKL_LEASE_APPLICATIONS_TL T

13: SELECT NULL
14: FROM OKL_LEASE_APPS_ALL_B B
15: WHERE B.ID =T.ID);
16:
17: UPDATE OKL_LEASE_APPLICATIONS_TL T
18: SET (SHORT_DESCRIPTION,
19: COMMENTS) = (SELECT B.SHORT_DESCRIPTION
20: , B.COMMENTS
21: FROM OKL_LEASE_APPLICATIONS_TL B

Line 21: FROM OKL_LEASE_APPLICATIONS_TL B

17: UPDATE OKL_LEASE_APPLICATIONS_TL T
18: SET (SHORT_DESCRIPTION,
19: COMMENTS) = (SELECT B.SHORT_DESCRIPTION
20: , B.COMMENTS
21: FROM OKL_LEASE_APPLICATIONS_TL B
22: WHERE B.ID = T.ID
23: AND B.LANGUAGE = T.SOURCE_LANG)
24: WHERE (T.ID, T.LANGUAGE) IN (SELECT SUBT.ID
25: , SUBT.LANGUAGE

Line 26: FROM OKL_LEASE_APPLICATIONS_TL SUBB

22: WHERE B.ID = T.ID
23: AND B.LANGUAGE = T.SOURCE_LANG)
24: WHERE (T.ID, T.LANGUAGE) IN (SELECT SUBT.ID
25: , SUBT.LANGUAGE
26: FROM OKL_LEASE_APPLICATIONS_TL SUBB
27: , OKL_LEASE_APPLICATIONS_TL SUBT
28: WHERE SUBB.ID = SUBT.ID
29: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
30: AND (SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION

Line 27: , OKL_LEASE_APPLICATIONS_TL SUBT

23: AND B.LANGUAGE = T.SOURCE_LANG)
24: WHERE (T.ID, T.LANGUAGE) IN (SELECT SUBT.ID
25: , SUBT.LANGUAGE
26: FROM OKL_LEASE_APPLICATIONS_TL SUBB
27: , OKL_LEASE_APPLICATIONS_TL SUBT
28: WHERE SUBB.ID = SUBT.ID
29: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
30: AND (SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION
31: OR (SUBB.COMMENTS <> SUBT.COMMENTS)

Line 37: INSERT INTO OKL_LEASE_APPLICATIONS_TL (

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

Line 61: FROM OKL_LEASE_APPLICATIONS_TL B, FND_LANGUAGES L

57: B.LAST_UPDATE_DATE,
58: B.LAST_UPDATE_LOGIN,
59: B.SHORT_DESCRIPTION,
60: B.COMMENTS
61: FROM OKL_LEASE_APPLICATIONS_TL B, FND_LANGUAGES L
62: WHERE L.INSTALLED_FLAG IN ('I', 'B')
63: AND B.LANGUAGE = USERENV('LANG')
64: AND NOT EXISTS (
65: SELECT NULL

Line 66: FROM OKL_LEASE_APPLICATIONS_TL T

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

Line 874: INSERT INTO OKL_LEASE_APPLICATIONS_TL (

870: ELSE
871: l_sfwt_flag := 'Y';
872: END IF;
873:
874: INSERT INTO OKL_LEASE_APPLICATIONS_TL (
875: id
876: ,language
877: ,source_lang
878: ,sfwt_flag

Line 1364: UPDATE OKL_LEASE_APPLICATIONS_TL

1360: BEGIN
1361:
1362: l_prog_name := G_PKG_NAME||'.update_row (TL)';
1363:
1364: UPDATE OKL_LEASE_APPLICATIONS_TL
1365: SET
1366: source_lang = USERENV('LANG')
1367: ,sfwt_flag = 'Y'
1368: ,last_updated_by = G_USER_ID

Line 1375: UPDATE OKL_LEASE_APPLICATIONS_TL

1371: ,short_description = p_laptl_rec.short_description
1372: ,comments = p_laptl_rec.comments
1373: WHERE ID = p_laptl_rec.id;
1374:
1375: UPDATE OKL_LEASE_APPLICATIONS_TL
1376: SET SFWT_FLAG = 'N'
1377: WHERE ID = p_laptl_rec.id
1378: AND SOURCE_LANG = LANGUAGE;
1379:

Line 1835: DELETE FROM OKL_LEASE_APPLICATIONS_TL WHERE id = p_id;

1831:
1832: l_prog_name := G_PKG_NAME||'.delete_row (V)';
1833:
1834: DELETE FROM OKL_LEASE_APPLICATIONS_B WHERE id = p_id;
1835: DELETE FROM OKL_LEASE_APPLICATIONS_TL WHERE id = p_id;
1836:
1837: x_return_status := G_RET_STS_SUCCESS;
1838:
1839: EXCEPTION