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_RXL_PVT dependencies on OKL_EXT_AR_LINE_SOURCES_TL

Line 104: DELETE FROM OKL_EXT_AR_LINE_SOURCES_TL T

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

Line 111: UPDATE OKL_EXT_AR_LINE_SOURCES_TL T SET(

107: FROM OKL_EXT_AR_LINE_SOURCES_B B
108: WHERE B.LINE_EXTENSION_ID =T.LINE_EXTENSION_ID
109: );
110:
111: UPDATE OKL_EXT_AR_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_AR_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_AR_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_AR_LINE_SOURCES_TL SUBB, OKL_EXT_AR_LINE_SOURCES_TL SUBT

124: T.LANGUAGE)
125: IN (SELECT
126: SUBT.LINE_EXTENSION_ID,
127: SUBT.LANGUAGE
128: FROM OKL_EXT_AR_LINE_SOURCES_TL SUBB, OKL_EXT_AR_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_AR_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_AR_LINE_SOURCES_TL (
142: LINE_EXTENSION_ID,
143: LANGUAGE,
144: SOURCE_LANG,
145: SFWT_FLAG,

Line 169: FROM OKL_EXT_AR_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_AR_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_AR_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_AR_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 332: -- FUNCTION get_rec for: OKL_EXT_AR_LINE_SOURCES_TL

328: BEGIN
329: RETURN(get_rec(p_rxlv_rec, l_row_not_found));
330: END get_rec;
331: ---------------------------------------------------------------------------
332: -- FUNCTION get_rec for: OKL_EXT_AR_LINE_SOURCES_TL
333: ---------------------------------------------------------------------------
334: FUNCTION get_rec (
335: p_rxll_rec IN rxll_rec_type,
336: x_no_data_found OUT NOCOPY BOOLEAN

Line 354: FROM Okl_Ext_Ar_Line_Sources_Tl

350: LAST_UPDATED_BY,
351: LAST_UPDATE_DATE,
352: LAST_UPDATE_LOGIN,
353: INVENTORY_ITEM_NAME
354: FROM Okl_Ext_Ar_Line_Sources_Tl
355: WHERE okl_ext_ar_line_sources_tl.line_extension_id = p_line_extension_id
356: AND okl_ext_ar_line_sources_tl.language = p_language;
357: l_okl_ext_ar_line_srcs_tl_pk okl_ext_ar_line_srcs_tl_pk_csr%ROWTYPE;
358: l_rxll_rec rxll_rec_type;

Line 355: WHERE okl_ext_ar_line_sources_tl.line_extension_id = p_line_extension_id

351: LAST_UPDATE_DATE,
352: LAST_UPDATE_LOGIN,
353: INVENTORY_ITEM_NAME
354: FROM Okl_Ext_Ar_Line_Sources_Tl
355: WHERE okl_ext_ar_line_sources_tl.line_extension_id = p_line_extension_id
356: AND okl_ext_ar_line_sources_tl.language = p_language;
357: l_okl_ext_ar_line_srcs_tl_pk okl_ext_ar_line_srcs_tl_pk_csr%ROWTYPE;
358: l_rxll_rec rxll_rec_type;
359: BEGIN

Line 356: AND okl_ext_ar_line_sources_tl.language = p_language;

352: LAST_UPDATE_LOGIN,
353: INVENTORY_ITEM_NAME
354: FROM Okl_Ext_Ar_Line_Sources_Tl
355: WHERE okl_ext_ar_line_sources_tl.line_extension_id = p_line_extension_id
356: AND okl_ext_ar_line_sources_tl.language = p_language;
357: l_okl_ext_ar_line_srcs_tl_pk okl_ext_ar_line_srcs_tl_pk_csr%ROWTYPE;
358: l_rxll_rec rxll_rec_type;
359: BEGIN
360: x_no_data_found := TRUE;

Line 1712: -- insert_row for:OKL_EXT_AR_LINE_SOURCES_TL --

1708: '_PVT'
1709: );
1710: END insert_row;
1711: -----------------------------------------------
1712: -- insert_row for:OKL_EXT_AR_LINE_SOURCES_TL --
1713: -----------------------------------------------
1714: PROCEDURE insert_row(
1715: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1716: x_return_status OUT NOCOPY VARCHAR2,

Line 1728: -- Set_Attributes for:OKL_EXT_AR_LINE_SOURCES_TL --

1724: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1725: l_rxll_rec rxll_rec_type := p_rxll_rec;
1726: l_def_rxll_rec rxll_rec_type;
1727: ---------------------------------------------------
1728: -- Set_Attributes for:OKL_EXT_AR_LINE_SOURCES_TL --
1729: ---------------------------------------------------
1730: FUNCTION Set_Attributes (
1731: p_rxll_rec IN rxll_rec_type,
1732: x_rxll_rec OUT NOCOPY rxll_rec_type

Line 1761: INSERT INTO OKL_EXT_AR_LINE_SOURCES_TL(

1757: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1758: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1759: RAISE OKL_API.G_EXCEPTION_ERROR;
1760: END IF;
1761: INSERT INTO OKL_EXT_AR_LINE_SOURCES_TL(
1762: line_extension_id,
1763: language,
1764: source_lang,
1765: sfwt_flag,

Line 2260: -- lock_row for:OKL_EXT_AR_LINE_SOURCES_TL --

2256: '_PVT'
2257: );
2258: END lock_row;
2259: ---------------------------------------------
2260: -- lock_row for:OKL_EXT_AR_LINE_SOURCES_TL --
2261: ---------------------------------------------
2262: PROCEDURE lock_row(
2263: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2264: x_return_status OUT NOCOPY VARCHAR2,

Line 2273: FROM OKL_EXT_AR_LINE_SOURCES_TL

2269: E_Resource_Busy EXCEPTION;
2270: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2271: CURSOR lock_csr (p_rxll_rec IN rxll_rec_type) IS
2272: SELECT *
2273: FROM OKL_EXT_AR_LINE_SOURCES_TL
2274: WHERE LINE_EXTENSION_ID = p_rxll_rec.line_extension_id
2275: FOR UPDATE NOWAIT;
2276:
2277: l_api_version CONSTANT NUMBER := 1;

Line 2903: -- update_row for:OKL_EXT_AR_LINE_SOURCES_TL --

2899: '_PVT'
2900: );
2901: END update_row;
2902: -----------------------------------------------
2903: -- update_row for:OKL_EXT_AR_LINE_SOURCES_TL --
2904: -----------------------------------------------
2905: PROCEDURE update_row(
2906: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2907: x_return_status OUT NOCOPY VARCHAR2,

Line 2977: -- Set_Attributes for:OKL_EXT_AR_LINE_SOURCES_TL --

2973: END IF;
2974: RETURN(l_return_status);
2975: END populate_new_record;
2976: ---------------------------------------------------
2977: -- Set_Attributes for:OKL_EXT_AR_LINE_SOURCES_TL --
2978: ---------------------------------------------------
2979: FUNCTION Set_Attributes (
2980: p_rxll_rec IN rxll_rec_type,
2981: x_rxll_rec OUT NOCOPY rxll_rec_type

Line 3016: UPDATE OKL_EXT_AR_LINE_SOURCES_TL

3012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3013: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3014: RAISE OKL_API.G_EXCEPTION_ERROR;
3015: END IF;
3016: UPDATE OKL_EXT_AR_LINE_SOURCES_TL
3017: SET INVENTORY_ORG_NAME = l_def_rxll_rec.inventory_org_name,
3018: STREAM_TYPE_NAME = l_def_rxll_rec.stream_type_name,
3019: TRANS_LINE_DESCRIPTION = l_def_rxll_rec.trans_line_description,
3020: CREATED_BY = l_def_rxll_rec.created_by,

Line 3029: UPDATE OKL_EXT_AR_LINE_SOURCES_TL

3025: INVENTORY_ITEM_NAME = l_def_rxll_rec.inventory_item_name
3026: WHERE LINE_EXTENSION_ID = l_def_rxll_rec.line_extension_id
3027: AND SOURCE_LANG = USERENV('LANG');
3028:
3029: UPDATE OKL_EXT_AR_LINE_SOURCES_TL
3030: SET SFWT_FLAG = 'Y'
3031: WHERE LINE_EXTENSION_ID = l_def_rxll_rec.line_extension_id
3032: AND SOURCE_LANG <> USERENV('LANG');
3033:

Line 3650: -- delete_row for:OKL_EXT_AR_LINE_SOURCES_TL --

3646: '_PVT'
3647: );
3648: END delete_row;
3649: -----------------------------------------------
3650: -- delete_row for:OKL_EXT_AR_LINE_SOURCES_TL --
3651: -----------------------------------------------
3652: PROCEDURE delete_row(
3653: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3654: x_return_status OUT NOCOPY VARCHAR2,

Line 3675: DELETE FROM OKL_EXT_AR_LINE_SOURCES_TL

3671: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3672: RAISE OKL_API.G_EXCEPTION_ERROR;
3673: END IF;
3674:
3675: DELETE FROM OKL_EXT_AR_LINE_SOURCES_TL
3676: WHERE LINE_EXTENSION_ID = p_rxll_rec.line_extension_id;
3677:
3678: x_return_status := l_return_status;
3679: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3972: -- insert_row for:OKL_EXT_AR_LINE_SOURCES_TL --

3968: ---------------------------------------------------------------------------
3969: -- Added for Bug# 6268782 : PRASJAIN
3970: -------------------------------------------------
3971: -- insert_row for:OKL_EXT_AR_LINE_SOURCES_B --
3972: -- insert_row for:OKL_EXT_AR_LINE_SOURCES_TL --
3973: -------------------------------------------------
3974: PROCEDURE insert_row(
3975: p_api_version IN NUMBER,
3976: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,