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_SIB_PVT dependencies on OKL_SUBSIDY_POOL_BUDGETS_TL

Line 98: DELETE FROM OKL_SUBSIDY_POOL_BUDGETS_TL T

94: -- PROCEDURE add_language
95: ---------------------------------------------------------------------------
96: PROCEDURE add_language IS
97: BEGIN
98: DELETE FROM OKL_SUBSIDY_POOL_BUDGETS_TL T
99: WHERE NOT EXISTS (
100: SELECT NULL
101: FROM OKL_SUBSIDY_POOL_BUDGETS_B B
102: WHERE B.ID =T.ID

Line 105: UPDATE OKL_SUBSIDY_POOL_BUDGETS_TL T SET(

101: FROM OKL_SUBSIDY_POOL_BUDGETS_B B
102: WHERE B.ID =T.ID
103: );
104:
105: UPDATE OKL_SUBSIDY_POOL_BUDGETS_TL T SET(
106: NOTE) = (SELECT
107: B.NOTE
108: FROM OKL_SUBSIDY_POOL_BUDGETS_TL B
109: WHERE B.ID = T.ID

Line 108: FROM OKL_SUBSIDY_POOL_BUDGETS_TL B

104:
105: UPDATE OKL_SUBSIDY_POOL_BUDGETS_TL T SET(
106: NOTE) = (SELECT
107: B.NOTE
108: FROM OKL_SUBSIDY_POOL_BUDGETS_TL B
109: WHERE B.ID = T.ID
110: AND B.LANGUAGE = T.SOURCE_LANG)
111: WHERE ( T.ID,
112: T.LANGUAGE)

Line 116: FROM OKL_SUBSIDY_POOL_BUDGETS_TL SUBB, OKL_SUBSIDY_POOL_BUDGETS_TL SUBT

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

Line 123: INSERT INTO OKL_SUBSIDY_POOL_BUDGETS_TL (

119: AND (SUBB.NOTE <> SUBT.NOTE
120: OR (SUBB.NOTE IS NULL AND SUBT.NOTE IS NOT NULL)
121: ));
122:
123: INSERT INTO OKL_SUBSIDY_POOL_BUDGETS_TL (
124: ID,
125: NOTE,
126: LANGUAGE,
127: SOURCE_LANG,

Line 145: FROM OKL_SUBSIDY_POOL_BUDGETS_TL B, FND_LANGUAGES L

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

Line 150: FROM OKL_SUBSIDY_POOL_BUDGETS_TL T

146: WHERE L.INSTALLED_FLAG IN ('I', 'B')
147: AND B.LANGUAGE = USERENV('LANG')
148: AND NOT EXISTS (
149: SELECT NULL
150: FROM OKL_SUBSIDY_POOL_BUDGETS_TL T
151: WHERE T.ID = B.ID
152: AND T.LANGUAGE = L.LANGUAGE_CODE
153: );
154: END add_language;

Line 381: -- FUNCTION get_rec for: OKL_SUBSIDY_POOL_BUDGETS_TL

377: BEGIN
378: RETURN(get_rec(p_sib_rec, l_row_not_found));
379: END get_rec;
380: ---------------------------------------------------------------------------
381: -- FUNCTION get_rec for: OKL_SUBSIDY_POOL_BUDGETS_TL
382: ---------------------------------------------------------------------------
383: FUNCTION get_rec (
384: p_OklSubsidyPoolBudgetsTlRec IN OklSubsidyPoolBudgetsTlRecType,
385: x_no_data_found OUT NOCOPY BOOLEAN

Line 400: FROM Okl_Subsidy_Pool_Budgets_Tl

396: CREATION_DATE,
397: LAST_UPDATED_BY,
398: LAST_UPDATE_DATE,
399: LAST_UPDATE_LOGIN
400: FROM Okl_Subsidy_Pool_Budgets_Tl
401: WHERE okl_subsidy_pool_budgets_tl.id = p_id
402: AND okl_subsidy_pool_budgets_tl.language = p_language;
403: l_okl_subsidy_pool_6 okl_subsidy_pool_bu5%ROWTYPE;
404: l_OklSubsidyPoolBudgetsTlRec OklSubsidyPoolBudgetsTlRecType;

Line 401: WHERE okl_subsidy_pool_budgets_tl.id = p_id

397: LAST_UPDATED_BY,
398: LAST_UPDATE_DATE,
399: LAST_UPDATE_LOGIN
400: FROM Okl_Subsidy_Pool_Budgets_Tl
401: WHERE okl_subsidy_pool_budgets_tl.id = p_id
402: AND okl_subsidy_pool_budgets_tl.language = p_language;
403: l_okl_subsidy_pool_6 okl_subsidy_pool_bu5%ROWTYPE;
404: l_OklSubsidyPoolBudgetsTlRec OklSubsidyPoolBudgetsTlRecType;
405: BEGIN

Line 402: AND okl_subsidy_pool_budgets_tl.language = p_language;

398: LAST_UPDATE_DATE,
399: LAST_UPDATE_LOGIN
400: FROM Okl_Subsidy_Pool_Budgets_Tl
401: WHERE okl_subsidy_pool_budgets_tl.id = p_id
402: AND okl_subsidy_pool_budgets_tl.language = p_language;
403: l_okl_subsidy_pool_6 okl_subsidy_pool_bu5%ROWTYPE;
404: l_OklSubsidyPoolBudgetsTlRec OklSubsidyPoolBudgetsTlRecType;
405: BEGIN
406: x_no_data_found := TRUE;

Line 1416: -- insert_row for:OKL_SUBSIDY_POOL_BUDGETS_TL --

1412: '_PVT'
1413: );
1414: END insert_row;
1415: ------------------------------------------------
1416: -- insert_row for:OKL_SUBSIDY_POOL_BUDGETS_TL --
1417: ------------------------------------------------
1418: PROCEDURE insert_row(
1419: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1420: x_return_status OUT NOCOPY VARCHAR2,

Line 1436: -- Set_Attributes for:OKL_SUBSIDY_POOL_BUDGETS_TL --

1432: SELECT *
1433: FROM FND_LANGUAGES
1434: WHERE INSTALLED_FLAG IN ('I', 'B');
1435: ----------------------------------------------------
1436: -- Set_Attributes for:OKL_SUBSIDY_POOL_BUDGETS_TL --
1437: ----------------------------------------------------
1438: FUNCTION Set_Attributes (
1439: p_OklSubsidyPoolBudgetsTlRec IN OklSubsidyPoolBudgetsTlRecType,
1440: XOklSubsidyPoolBudgetsTlRec OUT NOCOPY OklSubsidyPoolBudgetsTlRecType

Line 1471: INSERT INTO OKL_SUBSIDY_POOL_BUDGETS_TL(

1467: RAISE OKL_API.G_EXCEPTION_ERROR;
1468: END IF;
1469: FOR l_lang_rec IN get_languages LOOP
1470: l_OklSubsidyPoolBudgetsTlRec.language := l_lang_rec.language_code;
1471: INSERT INTO OKL_SUBSIDY_POOL_BUDGETS_TL(
1472: id,
1473: note,
1474: language,
1475: source_lang,

Line 1966: -- lock_row for:OKL_SUBSIDY_POOL_BUDGETS_TL --

1962: '_PVT'
1963: );
1964: END lock_row;
1965: ----------------------------------------------
1966: -- lock_row for:OKL_SUBSIDY_POOL_BUDGETS_TL --
1967: ----------------------------------------------
1968: PROCEDURE lock_row(
1969: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1970: x_return_status OUT NOCOPY VARCHAR2,

Line 1979: FROM OKL_SUBSIDY_POOL_BUDGETS_TL

1975: E_Resource_Busy EXCEPTION;
1976: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1977: CURSOR lock_csr (p_OklSubsidyPoolBudgetsTlRec IN OklSubsidyPoolBudgetsTlRecType) IS
1978: SELECT *
1979: FROM OKL_SUBSIDY_POOL_BUDGETS_TL
1980: WHERE ID = p_OklSubsidyPoolBudgetsTlRec.id
1981: FOR UPDATE NOWAIT;
1982:
1983: l_api_version CONSTANT NUMBER := 1;

Line 2567: -- update_row for:OKL_SUBSIDY_POOL_BUDGETS_TL --

2563: '_PVT'
2564: );
2565: END update_row;
2566: ------------------------------------------------
2567: -- update_row for:OKL_SUBSIDY_POOL_BUDGETS_TL --
2568: ------------------------------------------------
2569: PROCEDURE update_row(
2570: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2571: x_return_status OUT NOCOPY VARCHAR2,

Line 2642: -- Set_Attributes for:OKL_SUBSIDY_POOL_BUDGETS_TL --

2638: END IF;
2639: RETURN(l_return_status);
2640: END populate_new_record;
2641: ----------------------------------------------------
2642: -- Set_Attributes for:OKL_SUBSIDY_POOL_BUDGETS_TL --
2643: ----------------------------------------------------
2644: FUNCTION Set_Attributes (
2645: p_OklSubsidyPoolBudgetsTlRec IN OklSubsidyPoolBudgetsTlRecType,
2646: XOklSubsidyPoolBudgetsTlRec OUT NOCOPY OklSubsidyPoolBudgetsTlRecType

Line 2681: UPDATE OKL_SUBSIDY_POOL_BUDGETS_TL

2677: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2678: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2679: RAISE OKL_API.G_EXCEPTION_ERROR;
2680: END IF;
2681: UPDATE OKL_SUBSIDY_POOL_BUDGETS_TL
2682: SET NOTE = LDefOklSubsidyPoolBudgetsTlRec.note,
2683: CREATED_BY = LDefOklSubsidyPoolBudgetsTlRec.created_by,
2684: CREATION_DATE = LDefOklSubsidyPoolBudgetsTlRec.creation_date,
2685: LAST_UPDATED_BY = LDefOklSubsidyPoolBudgetsTlRec.last_updated_by,

Line 2691: UPDATE OKL_SUBSIDY_POOL_BUDGETS_TL

2687: LAST_UPDATE_LOGIN = LDefOklSubsidyPoolBudgetsTlRec.last_update_login
2688: WHERE ID = LDefOklSubsidyPoolBudgetsTlRec.id
2689: AND SOURCE_LANG = USERENV('LANG');
2690:
2691: UPDATE OKL_SUBSIDY_POOL_BUDGETS_TL
2692: SET SFWT_FLAG = 'Y'
2693: WHERE ID = LDefOklSubsidyPoolBudgetsTlRec.id
2694: AND SOURCE_LANG <> USERENV('LANG');
2695:

Line 3282: -- delete_row for:OKL_SUBSIDY_POOL_BUDGETS_TL --

3278: '_PVT'
3279: );
3280: END delete_row;
3281: ------------------------------------------------
3282: -- delete_row for:OKL_SUBSIDY_POOL_BUDGETS_TL --
3283: ------------------------------------------------
3284: PROCEDURE delete_row(
3285: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3286: x_return_status OUT NOCOPY VARCHAR2,

Line 3307: DELETE FROM OKL_SUBSIDY_POOL_BUDGETS_TL

3303: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3304: RAISE OKL_API.G_EXCEPTION_ERROR;
3305: END IF;
3306:
3307: DELETE FROM OKL_SUBSIDY_POOL_BUDGETS_TL
3308: WHERE ID = p_OklSubsidyPoolBudgetsTlRec.id;
3309:
3310: x_return_status := l_return_status;
3311: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);