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_CRF_PVT dependencies on OKL_CURE_REFUNDS

Line 94: -- FUNCTION get_rec for: OKL_CURE_REFUNDS_V

90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_CURE_REFUNDS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_crfv_rec IN crfv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 100: CURSOR okl_cure_refunds_pk_csr (p_cure_refund_id IN NUMBER) IS

96: FUNCTION get_rec (
97: p_crfv_rec IN crfv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN crfv_rec_type IS
100: CURSOR okl_cure_refunds_pk_csr (p_cure_refund_id IN NUMBER) IS
101: SELECT
102: CURE_REFUND_ID,
103: REFUND_NUMBER,
104: STATUS,

Line 145: FROM OKL_CURE_REFUNDS

141: LAST_UPDATE_DATE,
142: LAST_UPDATE_LOGIN,
143: CURE_REFUND_HEADER_ID,
144: RECEIVED_AMOUNT
145: FROM OKL_CURE_REFUNDS
146: WHERE OKL_CURE_REFUNDS.cure_refund_id = p_cure_refund_id;
147: l_okl_cure_refunds_pk okl_cure_refunds_pk_csr%ROWTYPE;
148: l_crfv_rec crfv_rec_type;
149: BEGIN

Line 146: WHERE OKL_CURE_REFUNDS.cure_refund_id = p_cure_refund_id;

142: LAST_UPDATE_LOGIN,
143: CURE_REFUND_HEADER_ID,
144: RECEIVED_AMOUNT
145: FROM OKL_CURE_REFUNDS
146: WHERE OKL_CURE_REFUNDS.cure_refund_id = p_cure_refund_id;
147: l_okl_cure_refunds_pk okl_cure_refunds_pk_csr%ROWTYPE;
148: l_crfv_rec crfv_rec_type;
149: BEGIN
150: x_no_data_found := TRUE;

Line 147: l_okl_cure_refunds_pk okl_cure_refunds_pk_csr%ROWTYPE;

143: CURE_REFUND_HEADER_ID,
144: RECEIVED_AMOUNT
145: FROM OKL_CURE_REFUNDS
146: WHERE OKL_CURE_REFUNDS.cure_refund_id = p_cure_refund_id;
147: l_okl_cure_refunds_pk okl_cure_refunds_pk_csr%ROWTYPE;
148: l_crfv_rec crfv_rec_type;
149: BEGIN
150: x_no_data_found := TRUE;
151: -- Get current database values

Line 152: OPEN okl_cure_refunds_pk_csr (p_crfv_rec.cure_refund_id);

148: l_crfv_rec crfv_rec_type;
149: BEGIN
150: x_no_data_found := TRUE;
151: -- Get current database values
152: OPEN okl_cure_refunds_pk_csr (p_crfv_rec.cure_refund_id);
153: FETCH okl_cure_refunds_pk_csr INTO
154: l_crfv_rec.cure_refund_id,
155: l_crfv_rec.refund_number,
156: l_crfv_rec.status,

Line 153: FETCH okl_cure_refunds_pk_csr INTO

149: BEGIN
150: x_no_data_found := TRUE;
151: -- Get current database values
152: OPEN okl_cure_refunds_pk_csr (p_crfv_rec.cure_refund_id);
153: FETCH okl_cure_refunds_pk_csr INTO
154: l_crfv_rec.cure_refund_id,
155: l_crfv_rec.refund_number,
156: l_crfv_rec.status,
157: l_crfv_rec.amount,

Line 197: x_no_data_found := okl_cure_refunds_pk_csr%NOTFOUND;

193: l_crfv_rec.last_update_date,
194: l_crfv_rec.last_update_login,
195: l_crfv_rec.cure_refund_header_id,
196: l_crfv_rec.RECEIVED_AMOUNT;
197: x_no_data_found := okl_cure_refunds_pk_csr%NOTFOUND;
198: CLOSE okl_cure_refunds_pk_csr;
199: RETURN(l_crfv_rec);
200: END get_rec;
201:

Line 198: CLOSE okl_cure_refunds_pk_csr;

194: l_crfv_rec.last_update_login,
195: l_crfv_rec.cure_refund_header_id,
196: l_crfv_rec.RECEIVED_AMOUNT;
197: x_no_data_found := okl_cure_refunds_pk_csr%NOTFOUND;
198: CLOSE okl_cure_refunds_pk_csr;
199: RETURN(l_crfv_rec);
200: END get_rec;
201:
202: ------------------------------------------------------------------

Line 231: -- FUNCTION get_rec for: OKL_CURE_REFUNDS

227: BEGIN
228: RETURN(get_rec(p_crfv_rec, l_row_not_found));
229: END get_rec;
230: ---------------------------------------------------------------------------
231: -- FUNCTION get_rec for: OKL_CURE_REFUNDS
232: ---------------------------------------------------------------------------
233: FUNCTION get_rec (
234: p_crf_rec IN crf_rec_type,
235: x_no_data_found OUT NOCOPY BOOLEAN

Line 282: FROM Okl_Cure_Refunds

278: LAST_UPDATE_DATE,
279: LAST_UPDATE_LOGIN,
280: CURE_REFUND_HEADER_ID,
281: received_amount
282: FROM Okl_Cure_Refunds
283: WHERE okl_cure_refunds.cure_refund_id = p_cure_refund_id;
284: l_okl_cure_refund_pk okl_cure_refund_pk_csr%ROWTYPE;
285: l_crf_rec crf_rec_type;
286: BEGIN

Line 283: WHERE okl_cure_refunds.cure_refund_id = p_cure_refund_id;

279: LAST_UPDATE_LOGIN,
280: CURE_REFUND_HEADER_ID,
281: received_amount
282: FROM Okl_Cure_Refunds
283: WHERE okl_cure_refunds.cure_refund_id = p_cure_refund_id;
284: l_okl_cure_refund_pk okl_cure_refund_pk_csr%ROWTYPE;
285: l_crf_rec crf_rec_type;
286: BEGIN
287: x_no_data_found := TRUE;

Line 368: -- FUNCTION null_out_defaults for: OKL_CURE_REFUNDS_V

364: BEGIN
365: RETURN(get_rec(p_crf_rec, l_row_not_found));
366: END get_rec;
367: ---------------------------------------------------------------------------
368: -- FUNCTION null_out_defaults for: OKL_CURE_REFUNDS_V
369: ---------------------------------------------------------------------------
370: FUNCTION null_out_defaults (
371: p_crfv_rec IN crfv_rec_type
372: ) RETURN crfv_rec_type IS

Line 710: -- Validate_Attributes for:OKL_CURE_REFUNDS_V --

706: ---------------------------------------------------------------------------
707: -- FUNCTION Validate_Attributes
708: ---------------------------------------------------------------------------
709: ------------------------------------------------
710: -- Validate_Attributes for:OKL_CURE_REFUNDS_V --
711: ------------------------------------------------
712: FUNCTION Validate_Attributes (
713: p_crfv_rec IN crfv_rec_type
714: ) RETURN VARCHAR2 IS

Line 811: -- Validate Record for:OKL_CURE_REFUNDS_V --

807: ---------------------------------------------------------------------------
808: -- PROCEDURE Validate_Record
809: ---------------------------------------------------------------------------
810: --------------------------------------------
811: -- Validate Record for:OKL_CURE_REFUNDS_V --
812: --------------------------------------------
813: FUNCTION Validate_Record (
814: p_crfv_rec IN crfv_rec_type,
815: p_db_crfv_rec IN crfv_rec_type

Line 937: -- validate_row for:OKL_CURE_REFUNDS_V --

933: ---------------------------------------------------------------------------
934: -- PROCEDURE validate_row
935: ---------------------------------------------------------------------------
936: -----------------------------------------
937: -- validate_row for:OKL_CURE_REFUNDS_V --
938: -----------------------------------------
939: PROCEDURE validate_row(
940: p_api_version IN NUMBER,
941: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1014: -- PL/SQL TBL validate_row for:OKL_CURE_REFUNDS_V --

1010: '_PVT'
1011: );
1012: END validate_row;
1013: ----------------------------------------------------
1014: -- PL/SQL TBL validate_row for:OKL_CURE_REFUNDS_V --
1015: ----------------------------------------------------
1016: PROCEDURE validate_row(
1017: p_api_version IN NUMBER,
1018: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1110: -- PL/SQL TBL validate_row for:OKL_CURE_REFUNDS_V --

1106: );
1107: END validate_row;
1108:
1109: ----------------------------------------------------
1110: -- PL/SQL TBL validate_row for:OKL_CURE_REFUNDS_V --
1111: ----------------------------------------------------
1112: PROCEDURE validate_row(
1113: p_api_version IN NUMBER,
1114: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1175: -- insert_row for:OKL_CURE_REFUNDS --

1171: ---------------------------------------------------------------------------
1172: -- PROCEDURE insert_row
1173: ---------------------------------------------------------------------------
1174: -------------------------------------
1175: -- insert_row for:OKL_CURE_REFUNDS --
1176: -------------------------------------
1177: PROCEDURE insert_row(
1178: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1179: x_return_status OUT NOCOPY VARCHAR2,

Line 1191: -- Set_Attributes for:OKL_CURE_REFUNDS --

1187: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1188: l_crf_rec crf_rec_type := p_crf_rec;
1189: l_def_crf_rec crf_rec_type;
1190: -----------------------------------------
1191: -- Set_Attributes for:OKL_CURE_REFUNDS --
1192: -----------------------------------------
1193: FUNCTION Set_Attributes (
1194: p_crf_rec IN crf_rec_type,
1195: x_crf_rec OUT NOCOPY crf_rec_type

Line 1222: INSERT INTO OKL_CURE_REFUNDS(

1218: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1219: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1220: RAISE OKL_API.G_EXCEPTION_ERROR;
1221: END IF;
1222: INSERT INTO OKL_CURE_REFUNDS(
1223: cure_refund_id,
1224: refund_number,
1225: status,
1226: amount,

Line 1349: -- insert_row for :OKL_CURE_REFUNDS_V --

1345: '_PVT'
1346: );
1347: END insert_row;
1348: ----------------------------------------
1349: -- insert_row for :OKL_CURE_REFUNDS_V --
1350: ----------------------------------------
1351: PROCEDURE insert_row(
1352: p_api_version IN NUMBER,
1353: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1383: -- Set_Attributes for:OKL_CURE_REFUNDS_V --

1379: l_crfv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1380: RETURN(l_crfv_rec);
1381: END fill_who_columns;
1382: -------------------------------------------
1383: -- Set_Attributes for:OKL_CURE_REFUNDS_V --
1384: -------------------------------------------
1385: FUNCTION Set_Attributes (
1386: p_crfv_rec IN crfv_rec_type,
1387: x_crfv_rec OUT NOCOPY crfv_rec_type

Line 1659: -- lock_row for:OKL_CURE_REFUNDS --

1655: ---------------------------------------------------------------------------
1656: -- PROCEDURE lock_row
1657: ---------------------------------------------------------------------------
1658: -----------------------------------
1659: -- lock_row for:OKL_CURE_REFUNDS --
1660: -----------------------------------
1661: PROCEDURE lock_row(
1662: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1663: x_return_status OUT NOCOPY VARCHAR2,

Line 1672: FROM OKL_CURE_REFUNDS

1668: E_Resource_Busy EXCEPTION;
1669: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1670: CURSOR lock_csr (p_crf_rec IN crf_rec_type) IS
1671: SELECT OBJECT_VERSION_NUMBER
1672: FROM OKL_CURE_REFUNDS
1673: WHERE CURE_REFUND_ID = p_crf_rec.cure_refund_id
1674: AND OBJECT_VERSION_NUMBER = p_crf_rec.object_version_number
1675: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1676:

Line 1679: FROM OKL_CURE_REFUNDS

1675: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1676:
1677: CURSOR lchk_csr (p_crf_rec IN crf_rec_type) IS
1678: SELECT OBJECT_VERSION_NUMBER
1679: FROM OKL_CURE_REFUNDS
1680: WHERE CURE_REFUND_ID = p_crf_rec.cure_refund_id;
1681: l_api_version CONSTANT NUMBER := 1;
1682: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1683: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1684: l_object_version_number OKL_CURE_REFUNDS.OBJECT_VERSION_NUMBER%TYPE;

1680: WHERE CURE_REFUND_ID = p_crf_rec.cure_refund_id;
1681: l_api_version CONSTANT NUMBER := 1;
1682: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1683: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1684: l_object_version_number OKL_CURE_REFUNDS.OBJECT_VERSION_NUMBER%TYPE;
1685: lc_object_version_number OKL_CURE_REFUNDS.OBJECT_VERSION_NUMBER%TYPE;
1686: l_row_notfound BOOLEAN := FALSE;
1687: lc_row_notfound BOOLEAN := FALSE;
1688: BEGIN

Line 1685: lc_object_version_number OKL_CURE_REFUNDS.OBJECT_VERSION_NUMBER%TYPE;

1681: l_api_version CONSTANT NUMBER := 1;
1682: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1683: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1684: l_object_version_number OKL_CURE_REFUNDS.OBJECT_VERSION_NUMBER%TYPE;
1685: lc_object_version_number OKL_CURE_REFUNDS.OBJECT_VERSION_NUMBER%TYPE;
1686: l_row_notfound BOOLEAN := FALSE;
1687: lc_row_notfound BOOLEAN := FALSE;
1688: BEGIN
1689: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1766: -- lock_row for: OKL_CURE_REFUNDS_V --

1762: '_PVT'
1763: );
1764: END lock_row;
1765: --------------------------------------
1766: -- lock_row for: OKL_CURE_REFUNDS_V --
1767: --------------------------------------
1768: PROCEDURE lock_row(
1769: p_api_version IN NUMBER,
1770: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2006: -- update_row for:OKL_CURE_REFUNDS --

2002: ---------------------------------------------------------------------------
2003: -- PROCEDURE update_row
2004: ---------------------------------------------------------------------------
2005: -------------------------------------
2006: -- update_row for:OKL_CURE_REFUNDS --
2007: -------------------------------------
2008: PROCEDURE update_row(
2009: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2010: x_return_status OUT NOCOPY VARCHAR2,

Line 2217: -- Set_Attributes for:OKL_CURE_REFUNDS --

2213: END IF;
2214: RETURN(l_return_status);
2215: END populate_new_record;
2216: -----------------------------------------
2217: -- Set_Attributes for:OKL_CURE_REFUNDS --
2218: -----------------------------------------
2219: FUNCTION Set_Attributes (
2220: p_crf_rec IN crf_rec_type,
2221: x_crf_rec OUT NOCOPY crf_rec_type

Line 2255: UPDATE OKL_CURE_REFUNDS

2251: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2252: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2253: RAISE OKL_API.G_EXCEPTION_ERROR;
2254: END IF;
2255: UPDATE OKL_CURE_REFUNDS
2256: SET REFUND_NUMBER = l_def_crf_rec.refund_number,
2257: STATUS = l_def_crf_rec.status,
2258: AMOUNT = l_def_crf_rec.amount,
2259: BALANCE = l_def_crf_rec.balance,

Line 2336: -- update_row for:OKL_CURE_REFUNDS_V --

2332: '_PVT'
2333: );
2334: END update_row;
2335: ---------------------------------------
2336: -- update_row for:OKL_CURE_REFUNDS_V --
2337: ---------------------------------------
2338: PROCEDURE update_row(
2339: p_api_version IN NUMBER,
2340: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2561: -- Set_Attributes for:OKL_CURE_REFUNDS_V --

2557: END IF;
2558: RETURN(l_return_status);
2559: END populate_new_record;
2560: -------------------------------------------
2561: -- Set_Attributes for:OKL_CURE_REFUNDS_V --
2562: -------------------------------------------
2563: FUNCTION Set_Attributes (
2564: p_crfv_rec IN crfv_rec_type,
2565: x_crfv_rec OUT NOCOPY crfv_rec_type

Line 2853: -- delete_row for:OKL_CURE_REFUNDS --

2849: ---------------------------------------------------------------------------
2850: -- PROCEDURE delete_row
2851: ---------------------------------------------------------------------------
2852: -------------------------------------
2853: -- delete_row for:OKL_CURE_REFUNDS --
2854: -------------------------------------
2855: PROCEDURE delete_row(
2856: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2857: x_return_status OUT NOCOPY VARCHAR2,

Line 2878: DELETE FROM OKL_CURE_REFUNDS

2874: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2875: RAISE OKL_API.G_EXCEPTION_ERROR;
2876: END IF;
2877:
2878: DELETE FROM OKL_CURE_REFUNDS
2879: WHERE CURE_REFUND_ID = p_crf_rec.cure_refund_id;
2880:
2881: x_return_status := l_return_status;
2882: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2916: -- delete_row for:OKL_CURE_REFUNDS_V --

2912: '_PVT'
2913: );
2914: END delete_row;
2915: ---------------------------------------
2916: -- delete_row for:OKL_CURE_REFUNDS_V --
2917: ---------------------------------------
2918: PROCEDURE delete_row(
2919: p_api_version IN NUMBER,
2920: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2998: -- PL/SQL TBL delete_row for:OKL_CURE_REFUNDS_V --

2994: '_PVT'
2995: );
2996: END delete_row;
2997: --------------------------------------------------
2998: -- PL/SQL TBL delete_row for:OKL_CURE_REFUNDS_V --
2999: --------------------------------------------------
3000: PROCEDURE delete_row(
3001: p_api_version IN NUMBER,
3002: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3094: -- PL/SQL TBL delete_row for:OKL_CURE_REFUNDS_V --

3090: );
3091: END delete_row;
3092:
3093: --------------------------------------------------
3094: -- PL/SQL TBL delete_row for:OKL_CURE_REFUNDS_V --
3095: --------------------------------------------------
3096: PROCEDURE delete_row(
3097: p_api_version IN NUMBER,
3098: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,