APPS.OKL_QQL_PVT dependencies on OKL_QUICK_QUOTE_LINES_TL

Line 11: DELETE FROM OKL_QUICK_QUOTE_LINES_TL T

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

Line 14: UPDATE OKL_QUICK_QUOTE_LINES_TL T

10:
11: DELETE FROM OKL_QUICK_QUOTE_LINES_TL T
12: WHERE NOT EXISTS (SELECT NULL FROM OKL_QUICK_QUOTE_LINES_B B WHERE B.ID =T.ID);
13:
14: UPDATE OKL_QUICK_QUOTE_LINES_TL T
15: SET (SHORT_DESCRIPTION,
16: DESCRIPTION,
17: COMMENTS) =
18: (SELECT

Line 23: OKL_QUICK_QUOTE_LINES_TL B

19: B.SHORT_DESCRIPTION,
20: B.DESCRIPTION,
21: B.COMMENTS
22: FROM
23: OKL_QUICK_QUOTE_LINES_TL B
24: WHERE
25: B.ID = T.ID
26: AND B.LANGUAGE = T.SOURCE_LANG)
27: WHERE (T.ID, T.LANGUAGE) IN (SELECT

Line 31: OKL_QUICK_QUOTE_LINES_TL SUBB,

27: WHERE (T.ID, T.LANGUAGE) IN (SELECT
28: SUBT.ID,
29: SUBT.LANGUAGE
30: FROM
31: OKL_QUICK_QUOTE_LINES_TL SUBB,
32: OKL_QUICK_QUOTE_LINES_TL SUBT
33: WHERE
34: SUBB.ID = SUBT.ID
35: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 32: OKL_QUICK_QUOTE_LINES_TL SUBT

28: SUBT.ID,
29: SUBT.LANGUAGE
30: FROM
31: OKL_QUICK_QUOTE_LINES_TL SUBB,
32: OKL_QUICK_QUOTE_LINES_TL SUBT
33: WHERE
34: SUBB.ID = SUBT.ID
35: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
36: AND (SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION

Line 45: INSERT INTO OKL_QUICK_QUOTE_LINES_TL (

41: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
42: )
43: );
44:
45: INSERT INTO OKL_QUICK_QUOTE_LINES_TL (
46: ID,
47: LANGUAGE,
48: SOURCE_LANG,
49: SFWT_FLAG,

Line 71: FROM OKL_QUICK_QUOTE_LINES_TL B, FND_LANGUAGES L

67: B.LAST_UPDATE_LOGIN,
68: B.SHORT_DESCRIPTION,
69: B.DESCRIPTION,
70: B.COMMENTS
71: FROM OKL_QUICK_QUOTE_LINES_TL B, FND_LANGUAGES L
72: WHERE L.INSTALLED_FLAG IN ('I', 'B')
73: AND B.LANGUAGE = USERENV('LANG')
74: AND NOT EXISTS (
75: SELECT NULL

Line 76: FROM OKL_QUICK_QUOTE_LINES_TL T

72: WHERE L.INSTALLED_FLAG IN ('I', 'B')
73: AND B.LANGUAGE = USERENV('LANG')
74: AND NOT EXISTS (
75: SELECT NULL
76: FROM OKL_QUICK_QUOTE_LINES_TL T
77: WHERE T.ID = B.ID
78: AND T.LANGUAGE = L.LANGUAGE_CODE
79: );
80:

Line 572: INSERT INTO OKL_QUICK_QUOTE_LINES_TL (

568: ELSE
569: l_sfwt_flag := 'Y';
570: END IF;
571:
572: INSERT INTO OKL_QUICK_QUOTE_LINES_TL (
573: id
574: ,language
575: ,source_lang
576: ,sfwt_flag

Line 1043: UPDATE OKL_QUICK_QUOTE_LINES_TL

1039: BEGIN
1040:
1041: l_prog_name := G_PKG_NAME||'.update_row (TL)';
1042:
1043: UPDATE OKL_QUICK_QUOTE_LINES_TL
1044: SET
1045: source_lang = USERENV('LANG')
1046: ,sfwt_flag = 'Y'
1047: ,last_updated_by = G_USER_ID

Line 1055: UPDATE OKL_QUICK_QUOTE_LINES_TL

1051: ,description = p_qqltl_rec.description
1052: ,comments = p_qqltl_rec.comments
1053: WHERE ID = p_qqltl_rec.id;
1054:
1055: UPDATE OKL_QUICK_QUOTE_LINES_TL
1056: SET SFWT_FLAG = 'N'
1057: WHERE ID = p_qqltl_rec.id
1058: AND SOURCE_LANG = LANGUAGE;
1059:

Line 1563: DELETE FROM OKL_QUICK_QUOTE_LINES_TL WHERE id = p_id;

1559:
1560: l_prog_name := G_PKG_NAME||'.delete_row (V)';
1561:
1562: DELETE FROM OKL_QUICK_QUOTE_LINES_B WHERE id = p_id;
1563: DELETE FROM OKL_QUICK_QUOTE_LINES_TL WHERE id = p_id;
1564:
1565: x_return_status := G_RET_STS_SUCCESS;
1566:
1567: EXCEPTION