eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_FXL_PVT dependencies on OKL_EXT_FA_LINE_SOURCES_TL

Line 104: DELETE FROM OKL_EXT_FA_LINE_SOURCES_TL T

100: -- PROCEDURE add_language
101: ---------------------------------------------------------------------------
102: PROCEDURE add_language IS
103: BEGIN
104: DELETE FROM OKL_EXT_FA_LINE_SOURCES_TL T
105: WHERE NOT EXISTS (
106: SELECT NULL
107: FROM OKL_EXT_FA_LINE_SOURCES_B B
108: WHERE B.LINE_EXTENSION_ID =T.LINE_EXTENSION_ID

Line 111: UPDATE OKL_EXT_FA_LINE_SOURCES_TL T SET(

107: FROM OKL_EXT_FA_LINE_SOURCES_B B
108: WHERE B.LINE_EXTENSION_ID =T.LINE_EXTENSION_ID
109: );
110:
111: UPDATE OKL_EXT_FA_LINE_SOURCES_TL T SET(
112: INVENTORY_ORG_NAME,
113: TRANS_LINE_DESCRIPTION) = (SELECT
114: B.INVENTORY_ORG_NAME,
115: B.TRANS_LINE_DESCRIPTION

Line 116: FROM OKL_EXT_FA_LINE_SOURCES_TL B

112: INVENTORY_ORG_NAME,
113: TRANS_LINE_DESCRIPTION) = (SELECT
114: B.INVENTORY_ORG_NAME,
115: B.TRANS_LINE_DESCRIPTION
116: FROM OKL_EXT_FA_LINE_SOURCES_TL B
117: WHERE B.LINE_EXTENSION_ID = T.LINE_EXTENSION_ID
118: AND B.LANGUAGE = T.SOURCE_LANG)
119: WHERE ( T.LINE_EXTENSION_ID,
120: T.LANGUAGE)

Line 124: FROM OKL_EXT_FA_LINE_SOURCES_TL SUBB, OKL_EXT_FA_LINE_SOURCES_TL SUBT

120: T.LANGUAGE)
121: IN (SELECT
122: SUBT.LINE_EXTENSION_ID,
123: SUBT.LANGUAGE
124: FROM OKL_EXT_FA_LINE_SOURCES_TL SUBB, OKL_EXT_FA_LINE_SOURCES_TL SUBT
125: WHERE SUBB.LINE_EXTENSION_ID = SUBT.LINE_EXTENSION_ID
126: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
127: AND (SUBB.INVENTORY_ORG_NAME <> SUBT.INVENTORY_ORG_NAME
128: OR SUBB.TRANS_LINE_DESCRIPTION <> SUBT.TRANS_LINE_DESCRIPTION

Line 133: INSERT INTO OKL_EXT_FA_LINE_SOURCES_TL (

129: OR (SUBB.INVENTORY_ORG_NAME IS NULL AND SUBT.INVENTORY_ORG_NAME IS NOT NULL)
130: OR (SUBB.TRANS_LINE_DESCRIPTION IS NULL AND SUBT.TRANS_LINE_DESCRIPTION IS NOT NULL)
131: ));
132:
133: INSERT INTO OKL_EXT_FA_LINE_SOURCES_TL (
134: LINE_EXTENSION_ID,
135: LANGUAGE,
136: SOURCE_LANG,
137: SFWT_FLAG,

Line 157: FROM OKL_EXT_FA_LINE_SOURCES_TL B, FND_LANGUAGES L

153: B.CREATION_DATE,
154: B.LAST_UPDATED_BY,
155: B.LAST_UPDATE_DATE,
156: B.LAST_UPDATE_LOGIN
157: FROM OKL_EXT_FA_LINE_SOURCES_TL B, FND_LANGUAGES L
158: WHERE L.INSTALLED_FLAG IN ('I', 'B')
159: AND B.LANGUAGE = USERENV('LANG')
160: AND NOT EXISTS (
161: SELECT NULL

Line 162: FROM OKL_EXT_FA_LINE_SOURCES_TL T

158: WHERE L.INSTALLED_FLAG IN ('I', 'B')
159: AND B.LANGUAGE = USERENV('LANG')
160: AND NOT EXISTS (
161: SELECT NULL
162: FROM OKL_EXT_FA_LINE_SOURCES_TL T
163: WHERE T.LINE_EXTENSION_ID = B.LINE_EXTENSION_ID
164: AND T.LANGUAGE = L.LANGUAGE_CODE
165: );
166: END add_language;

Line 429: -- FUNCTION get_rec for: OKL_EXT_FA_LINE_SOURCES_TL

425: BEGIN
426: RETURN(get_rec(p_fxl_rec, l_row_not_found));
427: END get_rec;
428: ---------------------------------------------------------------------------
429: -- FUNCTION get_rec for: OKL_EXT_FA_LINE_SOURCES_TL
430: ---------------------------------------------------------------------------
431: FUNCTION get_rec (
432: p_fxll_rec IN fxll_rec_type,
433: x_no_data_found OUT NOCOPY BOOLEAN

Line 449: FROM Okl_Ext_Fa_Line_Sources_Tl

445: CREATION_DATE,
446: LAST_UPDATED_BY,
447: LAST_UPDATE_DATE,
448: LAST_UPDATE_LOGIN
449: FROM Okl_Ext_Fa_Line_Sources_Tl
450: WHERE okl_ext_fa_line_sources_tl.line_extension_id = p_line_extension_id
451: AND okl_ext_fa_line_sources_tl.language = p_language;
452: l_okl_ext_fa_line_s10 okl_ext_fa_line_sou9%ROWTYPE;
453: l_fxll_rec fxll_rec_type;

Line 450: WHERE okl_ext_fa_line_sources_tl.line_extension_id = p_line_extension_id

446: LAST_UPDATED_BY,
447: LAST_UPDATE_DATE,
448: LAST_UPDATE_LOGIN
449: FROM Okl_Ext_Fa_Line_Sources_Tl
450: WHERE okl_ext_fa_line_sources_tl.line_extension_id = p_line_extension_id
451: AND okl_ext_fa_line_sources_tl.language = p_language;
452: l_okl_ext_fa_line_s10 okl_ext_fa_line_sou9%ROWTYPE;
453: l_fxll_rec fxll_rec_type;
454: BEGIN

Line 451: AND okl_ext_fa_line_sources_tl.language = p_language;

447: LAST_UPDATE_DATE,
448: LAST_UPDATE_LOGIN
449: FROM Okl_Ext_Fa_Line_Sources_Tl
450: WHERE okl_ext_fa_line_sources_tl.line_extension_id = p_line_extension_id
451: AND okl_ext_fa_line_sources_tl.language = p_language;
452: l_okl_ext_fa_line_s10 okl_ext_fa_line_sou9%ROWTYPE;
453: l_fxll_rec fxll_rec_type;
454: BEGIN
455: x_no_data_found := TRUE;

Line 1577: -- insert_row for:OKL_EXT_FA_LINE_SOURCES_TL --

1573: '_PVT'
1574: );
1575: END insert_row;
1576: -----------------------------------------------
1577: -- insert_row for:OKL_EXT_FA_LINE_SOURCES_TL --
1578: -----------------------------------------------
1579: PROCEDURE insert_row(
1580: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1581: x_return_status OUT NOCOPY VARCHAR2,

Line 1597: -- Set_Attributes for:OKL_EXT_FA_LINE_SOURCES_TL --

1593: SELECT *
1594: FROM FND_LANGUAGES
1595: WHERE INSTALLED_FLAG IN ('I', 'B');
1596: ---------------------------------------------------
1597: -- Set_Attributes for:OKL_EXT_FA_LINE_SOURCES_TL --
1598: ---------------------------------------------------
1599: FUNCTION Set_Attributes (
1600: p_fxll_rec IN fxll_rec_type,
1601: x_fxll_rec OUT NOCOPY fxll_rec_type

Line 1630: INSERT INTO OKL_EXT_FA_LINE_SOURCES_TL(

1626: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1627: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1628: RAISE OKL_API.G_EXCEPTION_ERROR;
1629: END IF;
1630: INSERT INTO OKL_EXT_FA_LINE_SOURCES_TL(
1631: line_extension_id,
1632: language,
1633: source_lang,
1634: sfwt_flag,

Line 2125: -- lock_row for:OKL_EXT_FA_LINE_SOURCES_TL --

2121: '_PVT'
2122: );
2123: END lock_row;
2124: ---------------------------------------------
2125: -- lock_row for:OKL_EXT_FA_LINE_SOURCES_TL --
2126: ---------------------------------------------
2127: PROCEDURE lock_row(
2128: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2129: x_return_status OUT NOCOPY VARCHAR2,

Line 2138: FROM OKL_EXT_FA_LINE_SOURCES_TL

2134: E_Resource_Busy EXCEPTION;
2135: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2136: CURSOR lock_csr (p_fxll_rec IN fxll_rec_type) IS
2137: SELECT *
2138: FROM OKL_EXT_FA_LINE_SOURCES_TL
2139: WHERE LINE_EXTENSION_ID = p_fxll_rec.line_extension_id
2140: FOR UPDATE NOWAIT;
2141:
2142: l_api_version CONSTANT NUMBER := 1;

Line 2728: -- update_row for:OKL_EXT_FA_LINE_SOURCES_TL --

2724: '_PVT'
2725: );
2726: END update_row;
2727: -----------------------------------------------
2728: -- update_row for:OKL_EXT_FA_LINE_SOURCES_TL --
2729: -----------------------------------------------
2730: PROCEDURE update_row(
2731: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2732: x_return_status OUT NOCOPY VARCHAR2,

Line 2796: -- Set_Attributes for:OKL_EXT_FA_LINE_SOURCES_TL --

2792: END IF;
2793: RETURN(l_return_status);
2794: END populate_new_record;
2795: ---------------------------------------------------
2796: -- Set_Attributes for:OKL_EXT_FA_LINE_SOURCES_TL --
2797: ---------------------------------------------------
2798: FUNCTION Set_Attributes (
2799: p_fxll_rec IN fxll_rec_type,
2800: x_fxll_rec OUT NOCOPY fxll_rec_type

Line 2835: UPDATE OKL_EXT_FA_LINE_SOURCES_TL

2831: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2832: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2833: RAISE OKL_API.G_EXCEPTION_ERROR;
2834: END IF;
2835: UPDATE OKL_EXT_FA_LINE_SOURCES_TL
2836: SET INVENTORY_ORG_NAME = l_def_fxll_rec.inventory_org_name,
2837: TRANS_LINE_DESCRIPTION = l_def_fxll_rec.trans_line_description,
2838: CREATED_BY = l_def_fxll_rec.created_by,
2839: CREATION_DATE = l_def_fxll_rec.creation_date,

Line 2846: UPDATE OKL_EXT_FA_LINE_SOURCES_TL

2842: LAST_UPDATE_LOGIN = l_def_fxll_rec.last_update_login
2843: WHERE LINE_EXTENSION_ID = l_def_fxll_rec.line_extension_id
2844: AND SOURCE_LANG = USERENV('LANG');
2845:
2846: UPDATE OKL_EXT_FA_LINE_SOURCES_TL
2847: SET SFWT_FLAG = 'Y'
2848: WHERE LINE_EXTENSION_ID = l_def_fxll_rec.line_extension_id
2849: AND SOURCE_LANG <> USERENV('LANG');
2850:

Line 3432: -- delete_row for:OKL_EXT_FA_LINE_SOURCES_TL --

3428: '_PVT'
3429: );
3430: END delete_row;
3431: -----------------------------------------------
3432: -- delete_row for:OKL_EXT_FA_LINE_SOURCES_TL --
3433: -----------------------------------------------
3434: PROCEDURE delete_row(
3435: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3436: x_return_status OUT NOCOPY VARCHAR2,

Line 3457: DELETE FROM OKL_EXT_FA_LINE_SOURCES_TL

3453: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3454: RAISE OKL_API.G_EXCEPTION_ERROR;
3455: END IF;
3456:
3457: DELETE FROM OKL_EXT_FA_LINE_SOURCES_TL
3458: WHERE LINE_EXTENSION_ID = p_fxll_rec.line_extension_id;
3459:
3460: x_return_status := l_return_status;
3461: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);