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_CFS_PVT dependencies on OKL_CURE_FUND_SUMS

Line 94: -- FUNCTION get_rec for: OKL_CURE_FUND_SUMS_V

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

Line 100: CURSOR OKL_cure_fund_sums_pk_csr (p_cure_fund_sum_id IN NUMBER) IS

96: FUNCTION get_rec (
97: p_cfsv_rec IN cfsv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN cfsv_rec_type IS
100: CURSOR OKL_cure_fund_sums_pk_csr (p_cure_fund_sum_id IN NUMBER) IS
101: SELECT
102: CURE_FUND_SUM_ID,
103: vendor_id,
104: BALANCE,

Line 132: FROM OKL_CURE_FUND_SUMS

128: CREATION_DATE,
129: LAST_UPDATED_BY,
130: LAST_UPDATE_DATE,
131: LAST_UPDATE_LOGIN
132: FROM OKL_CURE_FUND_SUMS
133: WHERE OKL_CURE_FUND_SUMS.cure_fund_sum_id = p_cure_fund_sum_id;
134: l_OKL_cure_fund_sums_pk OKL_cure_fund_sums_pk_csr%ROWTYPE;
135: l_cfsv_rec cfsv_rec_type;
136: BEGIN

Line 133: WHERE OKL_CURE_FUND_SUMS.cure_fund_sum_id = p_cure_fund_sum_id;

129: LAST_UPDATED_BY,
130: LAST_UPDATE_DATE,
131: LAST_UPDATE_LOGIN
132: FROM OKL_CURE_FUND_SUMS
133: WHERE OKL_CURE_FUND_SUMS.cure_fund_sum_id = p_cure_fund_sum_id;
134: l_OKL_cure_fund_sums_pk OKL_cure_fund_sums_pk_csr%ROWTYPE;
135: l_cfsv_rec cfsv_rec_type;
136: BEGIN
137: x_no_data_found := TRUE;

Line 134: l_OKL_cure_fund_sums_pk OKL_cure_fund_sums_pk_csr%ROWTYPE;

130: LAST_UPDATE_DATE,
131: LAST_UPDATE_LOGIN
132: FROM OKL_CURE_FUND_SUMS
133: WHERE OKL_CURE_FUND_SUMS.cure_fund_sum_id = p_cure_fund_sum_id;
134: l_OKL_cure_fund_sums_pk OKL_cure_fund_sums_pk_csr%ROWTYPE;
135: l_cfsv_rec cfsv_rec_type;
136: BEGIN
137: x_no_data_found := TRUE;
138: -- Get current database values

Line 139: OPEN OKL_cure_fund_sums_pk_csr (p_cfsv_rec.cure_fund_sum_id);

135: l_cfsv_rec cfsv_rec_type;
136: BEGIN
137: x_no_data_found := TRUE;
138: -- Get current database values
139: OPEN OKL_cure_fund_sums_pk_csr (p_cfsv_rec.cure_fund_sum_id);
140: FETCH OKL_cure_fund_sums_pk_csr INTO
141: l_cfsv_rec.cure_fund_sum_id,
142: l_cfsv_rec.vendor_id,
143: l_cfsv_rec.balance,

Line 140: FETCH OKL_cure_fund_sums_pk_csr INTO

136: BEGIN
137: x_no_data_found := TRUE;
138: -- Get current database values
139: OPEN OKL_cure_fund_sums_pk_csr (p_cfsv_rec.cure_fund_sum_id);
140: FETCH OKL_cure_fund_sums_pk_csr INTO
141: l_cfsv_rec.cure_fund_sum_id,
142: l_cfsv_rec.vendor_id,
143: l_cfsv_rec.balance,
144: l_cfsv_rec.object_version_number,

Line 171: x_no_data_found := OKL_cure_fund_sums_pk_csr%NOTFOUND;

167: l_cfsv_rec.creation_date,
168: l_cfsv_rec.last_updated_by,
169: l_cfsv_rec.last_update_date,
170: l_cfsv_rec.last_update_login;
171: x_no_data_found := OKL_cure_fund_sums_pk_csr%NOTFOUND;
172: CLOSE OKL_cure_fund_sums_pk_csr;
173: RETURN(l_cfsv_rec);
174: END get_rec;
175:

Line 172: CLOSE OKL_cure_fund_sums_pk_csr;

168: l_cfsv_rec.last_updated_by,
169: l_cfsv_rec.last_update_date,
170: l_cfsv_rec.last_update_login;
171: x_no_data_found := OKL_cure_fund_sums_pk_csr%NOTFOUND;
172: CLOSE OKL_cure_fund_sums_pk_csr;
173: RETURN(l_cfsv_rec);
174: END get_rec;
175:
176: ------------------------------------------------------------------

Line 205: -- FUNCTION get_rec for: OKL_CURE_FUND_SUMS

201: BEGIN
202: RETURN(get_rec(p_cfsv_rec, l_row_not_found));
203: END get_rec;
204: ---------------------------------------------------------------------------
205: -- FUNCTION get_rec for: OKL_CURE_FUND_SUMS
206: ---------------------------------------------------------------------------
207: FUNCTION get_rec (
208: p_cfs_rec IN cfs_rec_type,
209: x_no_data_found OUT NOCOPY BOOLEAN

Line 243: FROM OKL_Cure_Fund_Sums

239: CREATION_DATE,
240: LAST_UPDATED_BY,
241: LAST_UPDATE_DATE,
242: LAST_UPDATE_LOGIN
243: FROM OKL_Cure_Fund_Sums
244: WHERE OKL_cure_fund_sums.cure_fund_sum_id = p_cure_fund_sum_id;
245: l_OKL_cure_funds_sum_pk OKL_cure_funds_sum_pk_csr%ROWTYPE;
246: l_cfs_rec cfs_rec_type;
247: BEGIN

Line 244: WHERE OKL_cure_fund_sums.cure_fund_sum_id = p_cure_fund_sum_id;

240: LAST_UPDATED_BY,
241: LAST_UPDATE_DATE,
242: LAST_UPDATE_LOGIN
243: FROM OKL_Cure_Fund_Sums
244: WHERE OKL_cure_fund_sums.cure_fund_sum_id = p_cure_fund_sum_id;
245: l_OKL_cure_funds_sum_pk OKL_cure_funds_sum_pk_csr%ROWTYPE;
246: l_cfs_rec cfs_rec_type;
247: BEGIN
248: x_no_data_found := TRUE;

Line 316: -- FUNCTION null_out_defaults for: OKL_CURE_FUND_SUMS_V

312: BEGIN
313: RETURN(get_rec(p_cfs_rec, l_row_not_found));
314: END get_rec;
315: ---------------------------------------------------------------------------
316: -- FUNCTION null_out_defaults for: OKL_CURE_FUND_SUMS_V
317: ---------------------------------------------------------------------------
318: FUNCTION null_out_defaults (
319: p_cfsv_rec IN cfsv_rec_type
320: ) RETURN cfsv_rec_type IS

Line 520: -- Validate_Attributes for:OKL_CURE_FUND_SUMS_V --

516: ---------------------------------------------------------------------------
517: -- FUNCTION Validate_Attributes
518: ---------------------------------------------------------------------------
519: --------------------------------------------------
520: -- Validate_Attributes for:OKL_CURE_FUND_SUMS_V --
521: --------------------------------------------------
522: FUNCTION Validate_Attributes (
523: p_cfsv_rec IN cfsv_rec_type
524: ) RETURN VARCHAR2 IS

Line 602: -- Validate Record for:OKL_CURE_FUND_SUMS_V --

598: ---------------------------------------------------------------------------
599: -- PROCEDURE Validate_Record
600: ---------------------------------------------------------------------------
601: ----------------------------------------------
602: -- Validate Record for:OKL_CURE_FUND_SUMS_V --
603: ----------------------------------------------
604: FUNCTION Validate_Record (
605: p_cfsv_rec IN cfsv_rec_type,
606: p_db_cfsv_rec IN cfsv_rec_type

Line 702: -- validate_row for:OKL_CURE_FUND_SUMS_V --

698: ---------------------------------------------------------------------------
699: -- PROCEDURE validate_row
700: ---------------------------------------------------------------------------
701: -------------------------------------------
702: -- validate_row for:OKL_CURE_FUND_SUMS_V --
703: -------------------------------------------
704: PROCEDURE validate_row(
705: p_api_version IN NUMBER,
706: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 779: -- PL/SQL TBL validate_row for:OKL_CURE_FUND_SUMS_V --

775: '_PVT'
776: );
777: END validate_row;
778: ------------------------------------------------------
779: -- PL/SQL TBL validate_row for:OKL_CURE_FUND_SUMS_V --
780: ------------------------------------------------------
781: PROCEDURE validate_row(
782: p_api_version IN NUMBER,
783: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 875: -- PL/SQL TBL validate_row for:OKL_CURE_FUND_SUMS_V --

871: );
872: END validate_row;
873:
874: ------------------------------------------------------
875: -- PL/SQL TBL validate_row for:OKL_CURE_FUND_SUMS_V --
876: ------------------------------------------------------
877: PROCEDURE validate_row(
878: p_api_version IN NUMBER,
879: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 940: -- insert_row for:OKL_CURE_FUND_SUMS --

936: ---------------------------------------------------------------------------
937: -- PROCEDURE insert_row
938: ---------------------------------------------------------------------------
939: ---------------------------------------
940: -- insert_row for:OKL_CURE_FUND_SUMS --
941: ---------------------------------------
942: PROCEDURE insert_row(
943: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
944: x_return_status OUT NOCOPY VARCHAR2,

Line 956: -- Set_Attributes for:OKL_CURE_FUND_SUMS --

952: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
953: l_cfs_rec cfs_rec_type := p_cfs_rec;
954: l_def_cfs_rec cfs_rec_type;
955: -------------------------------------------
956: -- Set_Attributes for:OKL_CURE_FUND_SUMS --
957: -------------------------------------------
958: FUNCTION Set_Attributes (
959: p_cfs_rec IN cfs_rec_type,
960: x_cfs_rec OUT NOCOPY cfs_rec_type

Line 987: INSERT INTO OKL_CURE_FUND_SUMS(

983: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
984: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
985: RAISE OKL_API.G_EXCEPTION_ERROR;
986: END IF;
987: INSERT INTO OKL_CURE_FUND_SUMS(
988: cure_fund_sum_id,
989: vendor_id,
990: balance,
991: object_version_number,

Line 1086: -- insert_row for :OKL_CURE_FUND_SUMS_V --

1082: '_PVT'
1083: );
1084: END insert_row;
1085: ------------------------------------------
1086: -- insert_row for :OKL_CURE_FUND_SUMS_V --
1087: ------------------------------------------
1088: PROCEDURE insert_row(
1089: p_api_version IN NUMBER,
1090: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1120: -- Set_Attributes for:OKL_CURE_FUND_SUMS_V --

1116: l_cfsv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1117: RETURN(l_cfsv_rec);
1118: END fill_who_columns;
1119: ---------------------------------------------
1120: -- Set_Attributes for:OKL_CURE_FUND_SUMS_V --
1121: ---------------------------------------------
1122: FUNCTION Set_Attributes (
1123: p_cfsv_rec IN cfsv_rec_type,
1124: x_cfsv_rec OUT NOCOPY cfsv_rec_type

Line 1396: -- lock_row for:OKL_CURE_FUND_SUMS --

1392: ---------------------------------------------------------------------------
1393: -- PROCEDURE lock_row
1394: ---------------------------------------------------------------------------
1395: -------------------------------------
1396: -- lock_row for:OKL_CURE_FUND_SUMS --
1397: -------------------------------------
1398: PROCEDURE lock_row(
1399: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1400: x_return_status OUT NOCOPY VARCHAR2,

Line 1409: FROM OKL_CURE_FUND_SUMS

1405: E_Resource_Busy EXCEPTION;
1406: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1407: CURSOR lock_csr (p_cfs_rec IN cfs_rec_type) IS
1408: SELECT OBJECT_VERSION_NUMBER
1409: FROM OKL_CURE_FUND_SUMS
1410: WHERE CURE_FUND_SUM_ID = p_cfs_rec.cure_fund_sum_id
1411: AND OBJECT_VERSION_NUMBER = p_cfs_rec.object_version_number
1412: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1413:

Line 1416: FROM OKL_CURE_FUND_SUMS

1412: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1413:
1414: CURSOR lchk_csr (p_cfs_rec IN cfs_rec_type) IS
1415: SELECT OBJECT_VERSION_NUMBER
1416: FROM OKL_CURE_FUND_SUMS
1417: WHERE CURE_FUND_SUM_ID = p_cfs_rec.cure_fund_sum_id;
1418: l_api_version CONSTANT NUMBER := 1;
1419: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1420: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1421: l_object_version_number OKL_CURE_FUND_SUMS.OBJECT_VERSION_NUMBER%TYPE;

1417: WHERE CURE_FUND_SUM_ID = p_cfs_rec.cure_fund_sum_id;
1418: l_api_version CONSTANT NUMBER := 1;
1419: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1420: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1421: l_object_version_number OKL_CURE_FUND_SUMS.OBJECT_VERSION_NUMBER%TYPE;
1422: lc_object_version_number OKL_CURE_FUND_SUMS.OBJECT_VERSION_NUMBER%TYPE;
1423: l_row_notfound BOOLEAN := FALSE;
1424: lc_row_notfound BOOLEAN := FALSE;
1425: BEGIN

Line 1422: lc_object_version_number OKL_CURE_FUND_SUMS.OBJECT_VERSION_NUMBER%TYPE;

1418: l_api_version CONSTANT NUMBER := 1;
1419: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1420: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1421: l_object_version_number OKL_CURE_FUND_SUMS.OBJECT_VERSION_NUMBER%TYPE;
1422: lc_object_version_number OKL_CURE_FUND_SUMS.OBJECT_VERSION_NUMBER%TYPE;
1423: l_row_notfound BOOLEAN := FALSE;
1424: lc_row_notfound BOOLEAN := FALSE;
1425: BEGIN
1426: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1503: -- lock_row for: OKL_CURE_FUND_SUMS_V --

1499: '_PVT'
1500: );
1501: END lock_row;
1502: ----------------------------------------
1503: -- lock_row for: OKL_CURE_FUND_SUMS_V --
1504: ----------------------------------------
1505: PROCEDURE lock_row(
1506: p_api_version IN NUMBER,
1507: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1743: -- update_row for:OKL_CURE_FUND_SUMS --

1739: ---------------------------------------------------------------------------
1740: -- PROCEDURE update_row
1741: ---------------------------------------------------------------------------
1742: ---------------------------------------
1743: -- update_row for:OKL_CURE_FUND_SUMS --
1744: ---------------------------------------
1745: PROCEDURE update_row(
1746: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1747: x_return_status OUT NOCOPY VARCHAR2,

Line 1898: -- Set_Attributes for:OKL_CURE_FUND_SUMS --

1894: END IF;
1895: RETURN(l_return_status);
1896: END populate_new_record;
1897: -------------------------------------------
1898: -- Set_Attributes for:OKL_CURE_FUND_SUMS --
1899: -------------------------------------------
1900: FUNCTION Set_Attributes (
1901: p_cfs_rec IN cfs_rec_type,
1902: x_cfs_rec OUT NOCOPY cfs_rec_type

Line 1936: UPDATE OKL_CURE_FUND_SUMS

1932: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1933: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1934: RAISE OKL_API.G_EXCEPTION_ERROR;
1935: END IF;
1936: UPDATE OKL_CURE_FUND_SUMS
1937: SET vendor_id = l_def_cfs_rec.vendor_id,
1938: BALANCE = l_def_cfs_rec.balance,
1939: OBJECT_VERSION_NUMBER = l_def_cfs_rec.object_version_number,
1940: ORG_ID = l_def_cfs_rec.org_id,

Line 2004: -- update_row for:OKL_CURE_FUND_SUMS_V --

2000: '_PVT'
2001: );
2002: END update_row;
2003: -----------------------------------------
2004: -- update_row for:OKL_CURE_FUND_SUMS_V --
2005: -----------------------------------------
2006: PROCEDURE update_row(
2007: p_api_version IN NUMBER,
2008: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2172: -- Set_Attributes for:OKL_CURE_FUND_SUMS_V --

2168: END IF;
2169: RETURN(l_return_status);
2170: END populate_new_record;
2171: ---------------------------------------------
2172: -- Set_Attributes for:OKL_CURE_FUND_SUMS_V --
2173: ---------------------------------------------
2174: FUNCTION Set_Attributes (
2175: p_cfsv_rec IN cfsv_rec_type,
2176: x_cfsv_rec OUT NOCOPY cfsv_rec_type

Line 2464: -- delete_row for:OKL_CURE_FUND_SUMS --

2460: ---------------------------------------------------------------------------
2461: -- PROCEDURE delete_row
2462: ---------------------------------------------------------------------------
2463: ---------------------------------------
2464: -- delete_row for:OKL_CURE_FUND_SUMS --
2465: ---------------------------------------
2466: PROCEDURE delete_row(
2467: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2468: x_return_status OUT NOCOPY VARCHAR2,

Line 2489: DELETE FROM OKL_CURE_FUND_SUMS

2485: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2486: RAISE OKL_API.G_EXCEPTION_ERROR;
2487: END IF;
2488:
2489: DELETE FROM OKL_CURE_FUND_SUMS
2490: WHERE CURE_FUND_SUM_ID = p_cfs_rec.cure_fund_sum_id;
2491:
2492: x_return_status := l_return_status;
2493: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2527: -- delete_row for:OKL_CURE_FUND_SUMS_V --

2523: '_PVT'
2524: );
2525: END delete_row;
2526: -----------------------------------------
2527: -- delete_row for:OKL_CURE_FUND_SUMS_V --
2528: -----------------------------------------
2529: PROCEDURE delete_row(
2530: p_api_version IN NUMBER,
2531: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2609: -- PL/SQL TBL delete_row for:OKL_CURE_FUND_SUMS_V --

2605: '_PVT'
2606: );
2607: END delete_row;
2608: ----------------------------------------------------
2609: -- PL/SQL TBL delete_row for:OKL_CURE_FUND_SUMS_V --
2610: ----------------------------------------------------
2611: PROCEDURE delete_row(
2612: p_api_version IN NUMBER,
2613: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2705: -- PL/SQL TBL delete_row for:OKL_CURE_FUND_SUMS_V --

2701: );
2702: END delete_row;
2703:
2704: ----------------------------------------------------
2705: -- PL/SQL TBL delete_row for:OKL_CURE_FUND_SUMS_V --
2706: ----------------------------------------------------
2707: PROCEDURE delete_row(
2708: p_api_version IN NUMBER,
2709: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,