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_CHD_PVT dependencies on OKL_CURE_REFUND_HEADERS_TL

Line 98: DELETE FROM OKL_CURE_REFUND_HEADERS_TL T

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

Line 105: UPDATE OKL_CURE_REFUND_HEADERS_TL T SET(

101: FROM OKL_CURE_REFUND_HEADERS_B B
102: WHERE B.CURE_REFUND_HEADER_ID =T.CURE_REFUND_HEADER_ID
103: );
104:
105: UPDATE OKL_CURE_REFUND_HEADERS_TL T SET(
106: DESCRIPTION) = (SELECT
107: B.DESCRIPTION
108: FROM OKL_CURE_REFUND_HEADERS_TL B
109: WHERE B.CURE_REFUND_HEADER_ID = T.CURE_REFUND_HEADER_ID

Line 108: FROM OKL_CURE_REFUND_HEADERS_TL B

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

Line 116: FROM OKL_CURE_REFUND_HEADERS_TL SUBB, OKL_CURE_REFUND_HEADERS_TL SUBT

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

Line 123: INSERT INTO OKL_CURE_REFUND_HEADERS_TL (

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

Line 145: FROM OKL_CURE_REFUND_HEADERS_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_CURE_REFUND_HEADERS_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_CURE_REFUND_HEADERS_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_CURE_REFUND_HEADERS_TL T
151: WHERE T.CURE_REFUND_HEADER_ID = B.CURE_REFUND_HEADER_ID
152: AND T.LANGUAGE = L.LANGUAGE_CODE
153: );
154: END add_language;

Line 435: -- FUNCTION get_rec for: OKL_CURE_REFUND_HEADERS_TL

431: BEGIN
432: RETURN(get_rec(p_chd_rec, l_row_not_found));
433: END get_rec;
434: ---------------------------------------------------------------------------
435: -- FUNCTION get_rec for: OKL_CURE_REFUND_HEADERS_TL
436: ---------------------------------------------------------------------------
437: FUNCTION get_rec (
438: p_okl_cure_refund_h182 IN OklCureRefundHeadersTlRecType,
439: x_no_data_found OUT NOCOPY BOOLEAN

Line 454: FROM Okl_Cure_Refund_Headers_Tl

450: CREATION_DATE,
451: LAST_UPDATED_BY,
452: LAST_UPDATE_DATE,
453: LAST_UPDATE_LOGIN
454: FROM Okl_Cure_Refund_Headers_Tl
455: WHERE okl_cure_refund_headers_tl.cure_refund_header_id = p_cure_refund_header_id
456: AND okl_cure_refund_headers_tl.language = p_language;
457: l_okl_cure_refund_h181 okl_cure_refund_hea180%ROWTYPE;
458: l_okl_cure_refund_h183 OklCureRefundHeadersTlRecType;

Line 455: WHERE okl_cure_refund_headers_tl.cure_refund_header_id = p_cure_refund_header_id

451: LAST_UPDATED_BY,
452: LAST_UPDATE_DATE,
453: LAST_UPDATE_LOGIN
454: FROM Okl_Cure_Refund_Headers_Tl
455: WHERE okl_cure_refund_headers_tl.cure_refund_header_id = p_cure_refund_header_id
456: AND okl_cure_refund_headers_tl.language = p_language;
457: l_okl_cure_refund_h181 okl_cure_refund_hea180%ROWTYPE;
458: l_okl_cure_refund_h183 OklCureRefundHeadersTlRecType;
459: BEGIN

Line 456: AND okl_cure_refund_headers_tl.language = p_language;

452: LAST_UPDATE_DATE,
453: LAST_UPDATE_LOGIN
454: FROM Okl_Cure_Refund_Headers_Tl
455: WHERE okl_cure_refund_headers_tl.cure_refund_header_id = p_cure_refund_header_id
456: AND okl_cure_refund_headers_tl.language = p_language;
457: l_okl_cure_refund_h181 okl_cure_refund_hea180%ROWTYPE;
458: l_okl_cure_refund_h183 OklCureRefundHeadersTlRecType;
459: BEGIN
460: x_no_data_found := TRUE;

Line 1524: -- insert_row for:OKL_CURE_REFUND_HEADERS_TL --

1520: '_PVT'
1521: );
1522: END insert_row;
1523: -----------------------------------------------
1524: -- insert_row for:OKL_CURE_REFUND_HEADERS_TL --
1525: -----------------------------------------------
1526: PROCEDURE insert_row(
1527: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1528: x_return_status OUT NOCOPY VARCHAR2,

Line 1544: -- Set_Attributes for:OKL_CURE_REFUND_HEADERS_TL --

1540: SELECT *
1541: FROM FND_LANGUAGES
1542: WHERE INSTALLED_FLAG IN ('I', 'B');
1543: ---------------------------------------------------
1544: -- Set_Attributes for:OKL_CURE_REFUND_HEADERS_TL --
1545: ---------------------------------------------------
1546: FUNCTION Set_Attributes (
1547: p_okl_cure_refund_h182 IN OklCureRefundHeadersTlRecType,
1548: XOklCureRefundHeadersTlRec OUT NOCOPY OklCureRefundHeadersTlRecType

Line 1579: INSERT INTO OKL_CURE_REFUND_HEADERS_TL(

1575: RAISE OKL_API.G_EXCEPTION_ERROR;
1576: END IF;
1577: FOR l_lang_rec IN get_languages LOOP
1578: l_okl_cure_refund_h183.language := l_lang_rec.language_code;
1579: INSERT INTO OKL_CURE_REFUND_HEADERS_TL(
1580: cure_refund_header_id,
1581: language,
1582: source_lang,
1583: sfwt_flag,

Line 2074: -- lock_row for:OKL_CURE_REFUND_HEADERS_TL --

2070: '_PVT'
2071: );
2072: END lock_row;
2073: ---------------------------------------------
2074: -- lock_row for:OKL_CURE_REFUND_HEADERS_TL --
2075: ---------------------------------------------
2076: PROCEDURE lock_row(
2077: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2078: x_return_status OUT NOCOPY VARCHAR2,

Line 2087: FROM OKL_CURE_REFUND_HEADERS_TL

2083: E_Resource_Busy EXCEPTION;
2084: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2085: CURSOR lock_csr (p_okl_cure_refund_h182 IN OklCureRefundHeadersTlRecType) IS
2086: SELECT *
2087: FROM OKL_CURE_REFUND_HEADERS_TL
2088: WHERE CURE_REFUND_HEADER_ID = p_okl_cure_refund_h182.cure_refund_header_id
2089: FOR UPDATE NOWAIT;
2090:
2091: l_api_version CONSTANT NUMBER := 1;

Line 2740: -- update_row for:OKL_CURE_REFUND_HEADERS_TL --

2736: '_PVT'
2737: );
2738: END update_row;
2739: -----------------------------------------------
2740: -- update_row for:OKL_CURE_REFUND_HEADERS_TL --
2741: -----------------------------------------------
2742: PROCEDURE update_row(
2743: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2744: x_return_status OUT NOCOPY VARCHAR2,

Line 2815: -- Set_Attributes for:OKL_CURE_REFUND_HEADERS_TL --

2811: END IF;
2812: RETURN(l_return_status);
2813: END populate_new_record;
2814: ---------------------------------------------------
2815: -- Set_Attributes for:OKL_CURE_REFUND_HEADERS_TL --
2816: ---------------------------------------------------
2817: FUNCTION Set_Attributes (
2818: p_okl_cure_refund_h182 IN OklCureRefundHeadersTlRecType,
2819: XOklCureRefundHeadersTlRec OUT NOCOPY OklCureRefundHeadersTlRecType

Line 2854: UPDATE OKL_CURE_REFUND_HEADERS_TL

2850: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2851: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2852: RAISE OKL_API.G_EXCEPTION_ERROR;
2853: END IF;
2854: UPDATE OKL_CURE_REFUND_HEADERS_TL
2855: SET DESCRIPTION = LDefOklCureRefundHeadersTlRec.description,
2856: CREATED_BY = LDefOklCureRefundHeadersTlRec.created_by,
2857: CREATION_DATE = LDefOklCureRefundHeadersTlRec.creation_date,
2858: LAST_UPDATED_BY = LDefOklCureRefundHeadersTlRec.last_updated_by,

Line 2867: UPDATE OKL_CURE_REFUND_HEADERS_TL

2863: WHERE CURE_REFUND_HEADER_ID = LDefOklCureRefundHeadersTlRec.cure_refund_header_id
2864: AND USERENV('LANG') IN (SOURCE_LANG, LANGUAGE);
2865: -- AND SOURCE_LANG = USERENV('LANG'); commented out for bug 3631702
2866:
2867: UPDATE OKL_CURE_REFUND_HEADERS_TL
2868: SET SFWT_FLAG = 'Y'
2869: WHERE CURE_REFUND_HEADER_ID = LDefOklCureRefundHeadersTlRec.cure_refund_header_id
2870: AND SOURCE_LANG <> USERENV('LANG');
2871:

Line 3508: -- delete_row for:OKL_CURE_REFUND_HEADERS_TL --

3504: '_PVT'
3505: );
3506: END delete_row;
3507: -----------------------------------------------
3508: -- delete_row for:OKL_CURE_REFUND_HEADERS_TL --
3509: -----------------------------------------------
3510: PROCEDURE delete_row(
3511: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3512: x_return_status OUT NOCOPY VARCHAR2,

Line 3533: DELETE FROM OKL_CURE_REFUND_HEADERS_TL

3529: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3530: RAISE OKL_API.G_EXCEPTION_ERROR;
3531: END IF;
3532:
3533: DELETE FROM OKL_CURE_REFUND_HEADERS_TL
3534: WHERE CURE_REFUND_HEADER_ID = p_okl_cure_refund_h182.cure_refund_header_id;
3535:
3536: x_return_status := l_return_status;
3537: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);