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_PTC_PVT dependencies on OKL_PROPERTY_TAX_TL

Line 99: DELETE FROM OKL_PROPERTY_TAX_TL T

95: -- PROCEDURE add_language
96: ---------------------------------------------------------------------------
97: PROCEDURE add_language IS
98: BEGIN
99: DELETE FROM OKL_PROPERTY_TAX_TL T
100: WHERE NOT EXISTS (
101: SELECT NULL
102: FROM OKL_PROPERTY_TAX_ALL_B B --Changed _TL to _B by rvaduri for MLS compliance
103: WHERE B.ID =T.ID

Line 106: UPDATE OKL_PROPERTY_TAX_TL T SET(

102: FROM OKL_PROPERTY_TAX_ALL_B B --Changed _TL to _B by rvaduri for MLS compliance
103: WHERE B.ID =T.ID
104: );
105:
106: UPDATE OKL_PROPERTY_TAX_TL T SET(
107: ASSET_DESCRIPTION) = (SELECT
108: B.ASSET_DESCRIPTION
109: FROM OKL_PROPERTY_TAX_TL B
110: WHERE B.ID = T.ID

Line 109: FROM OKL_PROPERTY_TAX_TL B

105:
106: UPDATE OKL_PROPERTY_TAX_TL T SET(
107: ASSET_DESCRIPTION) = (SELECT
108: B.ASSET_DESCRIPTION
109: FROM OKL_PROPERTY_TAX_TL B
110: WHERE B.ID = T.ID
111: AND B.LANGUAGE = T.SOURCE_LANG)
112: WHERE ( T.ID, T.LANGUAGE)
113: IN (SELECT

Line 116: FROM OKL_PROPERTY_TAX_TL SUBB, OKL_PROPERTY_TAX_TL SUBT

112: WHERE ( T.ID, T.LANGUAGE)
113: IN (SELECT
114: SUBT.ID
115: ,SUBT.LANGUAGE
116: FROM OKL_PROPERTY_TAX_TL SUBB, OKL_PROPERTY_TAX_TL SUBT
117: WHERE SUBB.ID = SUBT.ID
118: AND SUBB.LANGUAGE = SUBT.LANGUAGE
119: AND ( SUBB.ASSET_DESCRIPTION <> SUBT.ASSET_DESCRIPTION
120: OR (SUBB.LANGUAGE IS NOT NULL AND SUBT.LANGUAGE IS NULL)

Line 124: INSERT INTO OKL_PROPERTY_TAX_TL (

120: OR (SUBB.LANGUAGE IS NOT NULL AND SUBT.LANGUAGE IS NULL)
121: OR (SUBB.ASSET_DESCRIPTION IS NULL AND SUBT.ASSET_DESCRIPTION IS NOT NULL)
122: ));
123:
124: INSERT INTO OKL_PROPERTY_TAX_TL (
125: ID,
126: LANGUAGE,
127: SOURCE_LANG,
128: SFWT_FLAG,

Line 146: FROM OKL_PROPERTY_TAX_TL B, FND_LANGUAGES L

142: B.CREATION_DATE,
143: B.LAST_UPDATED_BY,
144: B.LAST_UPDATE_DATE,
145: B.LAST_UPDATE_LOGIN
146: FROM OKL_PROPERTY_TAX_TL B, FND_LANGUAGES L
147: WHERE L.INSTALLED_FLAG IN ('I', 'B')
148: AND B.LANGUAGE = USERENV('LANG')
149: AND NOT EXISTS (
150: SELECT NULL

Line 151: FROM OKL_PROPERTY_TAX_TL T

147: WHERE L.INSTALLED_FLAG IN ('I', 'B')
148: AND B.LANGUAGE = USERENV('LANG')
149: AND NOT EXISTS (
150: SELECT NULL
151: FROM OKL_PROPERTY_TAX_TL T
152: WHERE T.ID = B.ID
153: -- Added as per Bug 2876076 by rvaduri
154: AND T.LANGUAGE = L.LANGUAGE_CODE
155: );

Line 457: -- FUNCTION get_rec for: OKL_PROPERTY_TAX_TL

453: BEGIN
454: RETURN(get_rec(p_ptc_rec, l_row_not_found));
455: END get_rec;
456: ---------------------------------------------------------------------------
457: -- FUNCTION get_rec for: OKL_PROPERTY_TAX_TL
458: ---------------------------------------------------------------------------
459: FUNCTION get_rec (
460: p_ptct_rec IN ptct_rec_type,
461: x_no_data_found OUT NOCOPY BOOLEAN

Line 475: FROM Okl_Property_Tax_Tl

471: CREATION_DATE,
472: LAST_UPDATED_BY,
473: LAST_UPDATE_DATE,
474: LAST_UPDATE_LOGIN
475: FROM Okl_Property_Tax_Tl
476: WHERE Okl_Property_Tax_Tl.id = p_id;
477: l_okl_ptct_pk okl_ptct_pk_csr%ROWTYPE;
478: l_ptct_rec ptct_rec_type;
479: BEGIN

Line 476: WHERE Okl_Property_Tax_Tl.id = p_id;

472: LAST_UPDATED_BY,
473: LAST_UPDATE_DATE,
474: LAST_UPDATE_LOGIN
475: FROM Okl_Property_Tax_Tl
476: WHERE Okl_Property_Tax_Tl.id = p_id;
477: l_okl_ptct_pk okl_ptct_pk_csr%ROWTYPE;
478: l_ptct_rec ptct_rec_type;
479: BEGIN
480: x_no_data_found := TRUE;

Line 1669: -- insert_row for:OKL_PROPERTY_TAX_TL --

1665: '_PVT'
1666: );
1667: END insert_row;
1668: -----------------------------------------------
1669: -- insert_row for:OKL_PROPERTY_TAX_TL --
1670: -----------------------------------------------
1671: PROCEDURE insert_row(
1672: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1673: x_return_status OUT NOCOPY VARCHAR2,

Line 1689: -- Set_Attributes for:OKL_PROPERTY_TAX_TL --

1685: SELECT *
1686: FROM FND_LANGUAGES
1687: WHERE INSTALLED_FLAG IN ('I', 'B');
1688: ---------------------------------------------------
1689: -- Set_Attributes for:OKL_PROPERTY_TAX_TL --
1690: ---------------------------------------------------
1691: FUNCTION Set_Attributes (
1692: p_ptct_rec IN ptct_rec_type,
1693: x_ptct_rec OUT NOCOPY ptct_rec_type

Line 1724: INSERT INTO OKL_PROPERTY_TAX_TL(

1720: RAISE OKC_API.G_EXCEPTION_ERROR;
1721: END IF;
1722: FOR l_lang_rec IN get_languages LOOP
1723: l_ptct_rec.language := l_lang_rec.language_code;
1724: INSERT INTO OKL_PROPERTY_TAX_TL(
1725: id,
1726: language,
1727: source_lang,
1728: sfwt_flag,

Line 2363: -- lock_row for:OKL_PROPERTY_TAX_TL --

2359: '_PVT'
2360: );
2361: END lock_row;
2362: ---------------------------------------------
2363: -- lock_row for:OKL_PROPERTY_TAX_TL --
2364: ---------------------------------------------
2365: PROCEDURE lock_row(
2366: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2367: x_return_status OUT NOCOPY VARCHAR2,

Line 2376: FROM OKL_PROPERTY_TAX_TL

2372: E_Resource_Busy EXCEPTION;
2373: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2374: CURSOR lock_csr (p_ptct_rec IN ptct_rec_type) IS
2375: SELECT *
2376: FROM OKL_PROPERTY_TAX_TL
2377: WHERE ID = p_ptct_rec.id
2378: FOR UPDATE NOWAIT;
2379:
2380: l_api_version CONSTANT NUMBER := 1;

Line 3060: -- update_row for:OKL_PROPERTY_TAX_TL --

3056: '_PVT'
3057: );
3058: END update_row;
3059: -----------------------------------------------
3060: -- update_row for:OKL_PROPERTY_TAX_TL --
3061: -----------------------------------------------
3062: PROCEDURE update_row(
3063: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3064: x_return_status OUT NOCOPY VARCHAR2,

Line 3135: -- Set_Attributes for:OKL_PROPERTY_TAX_TL --

3131: END IF;
3132: RETURN(l_return_status);
3133: END populate_new_record;
3134: ---------------------------------------------------
3135: -- Set_Attributes for:OKL_PROPERTY_TAX_TL --
3136: ---------------------------------------------------
3137: FUNCTION Set_Attributes (
3138: p_ptct_rec IN ptct_rec_type,
3139: x_ptct_rec OUT NOCOPY ptct_rec_type

Line 3174: UPDATE OKL_PROPERTY_TAX_TL

3170: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3171: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3172: RAISE OKC_API.G_EXCEPTION_ERROR;
3173: END IF;
3174: UPDATE OKL_PROPERTY_TAX_TL
3175: SET ASSET_DESCRIPTION = l_def_ptct_rec.asset_description,
3176: SOURCE_LANG = l_def_ptct_rec.source_lang,-- Fix for bug 3637102
3177: CREATED_BY = l_def_ptct_rec.created_by,
3178: CREATION_DATE = l_def_ptct_rec.creation_date,

Line 3186: UPDATE OKL_PROPERTY_TAX_TL

3182: WHERE ID = l_def_ptct_rec.id
3183: AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);--Fix for bug 3637102
3184: --AND SOURCE_LANG = USERENV('LANG');
3185:
3186: UPDATE OKL_PROPERTY_TAX_TL
3187: SET SFWT_FLAG = 'Y'
3188: WHERE ID = l_def_ptct_rec.id
3189: AND SOURCE_LANG <> USERENV('LANG');
3190:

Line 3865: -- delete_row for:OKL_PROPERTY_TAX_TL --

3861: '_PVT'
3862: );
3863: END delete_row;
3864: -----------------------------------------------
3865: -- delete_row for:OKL_PROPERTY_TAX_TL --
3866: -----------------------------------------------
3867: PROCEDURE delete_row(
3868: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3869: x_return_status OUT NOCOPY VARCHAR2,

Line 3890: DELETE FROM OKL_PROPERTY_TAX_TL

3886: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3887: RAISE OKC_API.G_EXCEPTION_ERROR;
3888: END IF;
3889:
3890: DELETE FROM OKL_PROPERTY_TAX_TL
3891: WHERE ID = p_ptct_rec.id;
3892:
3893: x_return_status := l_return_status;
3894: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);