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_PXL_PVT dependencies on OKL_EXT_AP_LINE_SOURCES_TL

Line 104: DELETE FROM OKL_EXT_AP_LINE_SOURCES_TL T

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

Line 111: UPDATE OKL_EXT_AP_LINE_SOURCES_TL T SET(

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

Line 120: FROM OKL_EXT_AP_LINE_SOURCES_TL B

116: B.INVENTORY_ORG_NAME,
117: B.STREAM_TYPE_NAME,
118: B.TRANS_LINE_DESCRIPTION,
119: B.INVENTORY_ITEM_NAME
120: FROM OKL_EXT_AP_LINE_SOURCES_TL B
121: WHERE B.LINE_EXTENSION_ID = T.LINE_EXTENSION_ID
122: AND B.LANGUAGE = T.SOURCE_LANG)
123: WHERE ( T.LINE_EXTENSION_ID,
124: T.LANGUAGE)

Line 128: FROM OKL_EXT_AP_LINE_SOURCES_TL SUBB, OKL_EXT_AP_LINE_SOURCES_TL SUBT

124: T.LANGUAGE)
125: IN (SELECT
126: SUBT.LINE_EXTENSION_ID,
127: SUBT.LANGUAGE
128: FROM OKL_EXT_AP_LINE_SOURCES_TL SUBB, OKL_EXT_AP_LINE_SOURCES_TL SUBT
129: WHERE SUBB.LINE_EXTENSION_ID = SUBT.LINE_EXTENSION_ID
130: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
131: AND (SUBB.INVENTORY_ORG_NAME <> SUBT.INVENTORY_ORG_NAME
132: OR SUBB.STREAM_TYPE_NAME <> SUBT.STREAM_TYPE_NAME

Line 141: INSERT INTO OKL_EXT_AP_LINE_SOURCES_TL (

137: OR (SUBB.TRANS_LINE_DESCRIPTION IS NULL AND SUBT.TRANS_LINE_DESCRIPTION IS NOT NULL)
138: OR (SUBB.INVENTORY_ITEM_NAME IS NULL AND SUBT.INVENTORY_ITEM_NAME IS NOT NULL)
139: ));
140:
141: INSERT INTO OKL_EXT_AP_LINE_SOURCES_TL (
142: LINE_EXTENSION_ID,
143: LANGUAGE,
144: SOURCE_LANG,
145: SFWT_FLAG,

Line 169: FROM OKL_EXT_AP_LINE_SOURCES_TL B, FND_LANGUAGES L

165: B.LAST_UPDATED_BY,
166: B.LAST_UPDATE_DATE,
167: B.LAST_UPDATE_LOGIN,
168: B.INVENTORY_ITEM_NAME
169: FROM OKL_EXT_AP_LINE_SOURCES_TL B, FND_LANGUAGES L
170: WHERE L.INSTALLED_FLAG IN ('I', 'B')
171: AND B.LANGUAGE = USERENV('LANG')
172: AND NOT EXISTS (
173: SELECT NULL

Line 174: FROM OKL_EXT_AP_LINE_SOURCES_TL T

170: WHERE L.INSTALLED_FLAG IN ('I', 'B')
171: AND B.LANGUAGE = USERENV('LANG')
172: AND NOT EXISTS (
173: SELECT NULL
174: FROM OKL_EXT_AP_LINE_SOURCES_TL T
175: WHERE T.LINE_EXTENSION_ID = B.LINE_EXTENSION_ID
176: AND T.LANGUAGE = L.LANGUAGE_CODE
177: );
178: END add_language;

Line 465: -- FUNCTION get_rec for: OKL_EXT_AP_LINE_SOURCES_TL

461: BEGIN
462: RETURN(get_rec(p_pxl_rec, l_row_not_found));
463: END get_rec;
464: ---------------------------------------------------------------------------
465: -- FUNCTION get_rec for: OKL_EXT_AP_LINE_SOURCES_TL
466: ---------------------------------------------------------------------------
467: FUNCTION get_rec (
468: p_pxll_rec IN pxll_rec_type,
469: x_no_data_found OUT NOCOPY BOOLEAN

Line 487: FROM Okl_Ext_Ap_Line_Sources_Tl

483: LAST_UPDATED_BY,
484: LAST_UPDATE_DATE,
485: LAST_UPDATE_LOGIN,
486: INVENTORY_ITEM_NAME
487: FROM Okl_Ext_Ap_Line_Sources_Tl
488: WHERE okl_ext_ap_line_sources_tl.line_extension_id = p_line_extension_id
489: AND okl_ext_ap_line_sources_tl.language = p_language;
490: l_okl_ext_ap_line_s10 okl_ext_ap_line_sou9%ROWTYPE;
491: l_pxll_rec pxll_rec_type;

Line 488: WHERE okl_ext_ap_line_sources_tl.line_extension_id = p_line_extension_id

484: LAST_UPDATE_DATE,
485: LAST_UPDATE_LOGIN,
486: INVENTORY_ITEM_NAME
487: FROM Okl_Ext_Ap_Line_Sources_Tl
488: WHERE okl_ext_ap_line_sources_tl.line_extension_id = p_line_extension_id
489: AND okl_ext_ap_line_sources_tl.language = p_language;
490: l_okl_ext_ap_line_s10 okl_ext_ap_line_sou9%ROWTYPE;
491: l_pxll_rec pxll_rec_type;
492: BEGIN

Line 489: AND okl_ext_ap_line_sources_tl.language = p_language;

485: LAST_UPDATE_LOGIN,
486: INVENTORY_ITEM_NAME
487: FROM Okl_Ext_Ap_Line_Sources_Tl
488: WHERE okl_ext_ap_line_sources_tl.line_extension_id = p_line_extension_id
489: AND okl_ext_ap_line_sources_tl.language = p_language;
490: l_okl_ext_ap_line_s10 okl_ext_ap_line_sou9%ROWTYPE;
491: l_pxll_rec pxll_rec_type;
492: BEGIN
493: x_no_data_found := TRUE;

Line 1594: -- insert_row for:OKL_EXT_AP_LINE_SOURCES_TL --

1590: '_PVT'
1591: );
1592: END insert_row;
1593: -----------------------------------------------
1594: -- insert_row for:OKL_EXT_AP_LINE_SOURCES_TL --
1595: -----------------------------------------------
1596: PROCEDURE insert_row(
1597: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1598: x_return_status OUT NOCOPY VARCHAR2,

Line 1614: -- Set_Attributes for:OKL_EXT_AP_LINE_SOURCES_TL --

1610: SELECT *
1611: FROM FND_LANGUAGES
1612: WHERE INSTALLED_FLAG IN ('I', 'B');
1613: ---------------------------------------------------
1614: -- Set_Attributes for:OKL_EXT_AP_LINE_SOURCES_TL --
1615: ---------------------------------------------------
1616: FUNCTION Set_Attributes (
1617: p_pxll_rec IN pxll_rec_type,
1618: x_pxll_rec OUT NOCOPY pxll_rec_type

Line 1647: INSERT INTO OKL_EXT_AP_LINE_SOURCES_TL(

1643: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1644: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1645: RAISE OKL_API.G_EXCEPTION_ERROR;
1646: END IF;
1647: INSERT INTO OKL_EXT_AP_LINE_SOURCES_TL(
1648: line_extension_id,
1649: language,
1650: source_lang,
1651: sfwt_flag,

Line 2146: -- lock_row for:OKL_EXT_AP_LINE_SOURCES_TL --

2142: '_PVT'
2143: );
2144: END lock_row;
2145: ---------------------------------------------
2146: -- lock_row for:OKL_EXT_AP_LINE_SOURCES_TL --
2147: ---------------------------------------------
2148: PROCEDURE lock_row(
2149: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2150: x_return_status OUT NOCOPY VARCHAR2,

Line 2159: FROM OKL_EXT_AP_LINE_SOURCES_TL

2155: E_Resource_Busy EXCEPTION;
2156: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2157: CURSOR lock_csr (p_pxll_rec IN pxll_rec_type) IS
2158: SELECT *
2159: FROM OKL_EXT_AP_LINE_SOURCES_TL
2160: WHERE LINE_EXTENSION_ID = p_pxll_rec.line_extension_id
2161: FOR UPDATE NOWAIT;
2162:
2163: l_api_version CONSTANT NUMBER := 1;

Line 2769: -- update_row for:OKL_EXT_AP_LINE_SOURCES_TL --

2765: '_PVT'
2766: );
2767: END update_row;
2768: -----------------------------------------------
2769: -- update_row for:OKL_EXT_AP_LINE_SOURCES_TL --
2770: -----------------------------------------------
2771: PROCEDURE update_row(
2772: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2773: x_return_status OUT NOCOPY VARCHAR2,

Line 2843: -- Set_Attributes for:OKL_EXT_AP_LINE_SOURCES_TL --

2839: END IF;
2840: RETURN(l_return_status);
2841: END populate_new_record;
2842: ---------------------------------------------------
2843: -- Set_Attributes for:OKL_EXT_AP_LINE_SOURCES_TL --
2844: ---------------------------------------------------
2845: FUNCTION Set_Attributes (
2846: p_pxll_rec IN pxll_rec_type,
2847: x_pxll_rec OUT NOCOPY pxll_rec_type

Line 2882: UPDATE OKL_EXT_AP_LINE_SOURCES_TL

2878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2879: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2880: RAISE OKL_API.G_EXCEPTION_ERROR;
2881: END IF;
2882: UPDATE OKL_EXT_AP_LINE_SOURCES_TL
2883: SET INVENTORY_ORG_NAME = l_def_pxll_rec.inventory_org_name,
2884: STREAM_TYPE_NAME = l_def_pxll_rec.stream_type_name,
2885: TRANS_LINE_DESCRIPTION = l_def_pxll_rec.trans_line_description,
2886: CREATED_BY = l_def_pxll_rec.created_by,

Line 2895: UPDATE OKL_EXT_AP_LINE_SOURCES_TL

2891: INVENTORY_ITEM_NAME = l_def_pxll_rec.inventory_item_name
2892: WHERE LINE_EXTENSION_ID = l_def_pxll_rec.line_extension_id
2893: AND SOURCE_LANG = USERENV('LANG');
2894:
2895: UPDATE OKL_EXT_AP_LINE_SOURCES_TL
2896: SET SFWT_FLAG = 'Y'
2897: WHERE LINE_EXTENSION_ID = l_def_pxll_rec.line_extension_id
2898: AND SOURCE_LANG <> USERENV('LANG');
2899:

Line 3502: -- delete_row for:OKL_EXT_AP_LINE_SOURCES_TL --

3498: '_PVT'
3499: );
3500: END delete_row;
3501: -----------------------------------------------
3502: -- delete_row for:OKL_EXT_AP_LINE_SOURCES_TL --
3503: -----------------------------------------------
3504: PROCEDURE delete_row(
3505: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3506: x_return_status OUT NOCOPY VARCHAR2,

Line 3527: DELETE FROM OKL_EXT_AP_LINE_SOURCES_TL

3523: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3524: RAISE OKL_API.G_EXCEPTION_ERROR;
3525: END IF;
3526:
3527: DELETE FROM OKL_EXT_AP_LINE_SOURCES_TL
3528: WHERE LINE_EXTENSION_ID = p_pxll_rec.line_extension_id;
3529:
3530: x_return_status := l_return_status;
3531: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3824: -- insert_row for:OKL_EXT_AP_LINE_SOURCES_TL --

3820: ---------------------------------------------------------------------------
3821: -- Added for Bug# 6268782 : PRASJAIN
3822: -------------------------------------------------
3823: -- insert_row for:OKL_EXT_AP_LINE_SOURCES_B --
3824: -- insert_row for:OKL_EXT_AP_LINE_SOURCES_TL --
3825: -------------------------------------------------
3826: PROCEDURE insert_row(
3827: p_api_version IN NUMBER,
3828: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,