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_DSF_PVT dependencies on OKL_DATA_SRC_FNCTNS_V

Line 245: -- FUNCTION get_rec for: OKL_DATA_SRC_FNCTNS_V

241: BEGIN
242: RETURN(get_rec(p_okl_data_src_fnctns_tl_rec, l_row_notfound));
243: END get_rec;
244: ---------------------------------------------------------------------------
245: -- FUNCTION get_rec for: OKL_DATA_SRC_FNCTNS_V
246: ---------------------------------------------------------------------------
247: FUNCTION get_rec (
248: p_dsfv_rec IN dsfv_rec_type,
249: x_no_data_found OUT NOCOPY BOOLEAN

Line 285: FROM Okl_Data_Src_Fnctns_V

281: CREATION_DATE,
282: LAST_UPDATED_BY,
283: LAST_UPDATE_DATE,
284: LAST_UPDATE_LOGIN
285: FROM Okl_Data_Src_Fnctns_V
286: WHERE okl_data_src_fnctns_v.id = p_id;
287: l_okl_dsfv_pk okl_dsfv_pk_csr%ROWTYPE;
288: l_dsfv_rec dsfv_rec_type;
289: BEGIN

Line 286: WHERE okl_data_src_fnctns_v.id = p_id;

282: LAST_UPDATED_BY,
283: LAST_UPDATE_DATE,
284: LAST_UPDATE_LOGIN
285: FROM Okl_Data_Src_Fnctns_V
286: WHERE okl_data_src_fnctns_v.id = p_id;
287: l_okl_dsfv_pk okl_dsfv_pk_csr%ROWTYPE;
288: l_dsfv_rec dsfv_rec_type;
289: BEGIN
290: x_no_data_found := TRUE;

Line 340: -- FUNCTION null_out_defaults for: OKL_DATA_SRC_FNCTNS_V --

336: RETURN(get_rec(p_dsfv_rec, l_row_notfound));
337: END get_rec;
338:
339: -----------------------------------------------------------
340: -- FUNCTION null_out_defaults for: OKL_DATA_SRC_FNCTNS_V --
341: -----------------------------------------------------------
342: FUNCTION null_out_defaults (
343: p_dsfv_rec IN dsfv_rec_type
344: ) RETURN dsfv_rec_type IS

Line 447: -- Validate_Attributes for:OKL_DATA_SRC_FNCTNS_V --

443: ---------------------------------------------------------------------------
444: -- PROCEDURE Validate_Attributes
445: ---------------------------------------------------------------------------
446: ---------------------------------------------------
447: -- Validate_Attributes for:OKL_DATA_SRC_FNCTNS_V --
448: ---------------------------------------------------
449: FUNCTION Validate_Attributes (
450: p_dsfv_rec IN dsfv_rec_type
451: ) RETURN VARCHAR2 IS

Line 497: -- Validate_Record for:OKL_DATA_SRC_FNCTNS_V --

493: ---------------------------------------------------------------------------
494: -- PROCEDURE Validate_Record
495: ---------------------------------------------------------------------------
496: -----------------------------------------------
497: -- Validate_Record for:OKL_DATA_SRC_FNCTNS_V --
498: -----------------------------------------------
499: FUNCTION Validate_Record (
500: p_dsfv_rec IN dsfv_rec_type
501: ) RETURN VARCHAR2 IS

Line 911: CURSOR okl_fclv_code_csr (p_code IN OKL_DATA_SRC_FNCTNS_V.fnctn_code%TYPE) IS

907: l_row_found VARCHAR2(1) := OKL_API.G_TRUE;
908:
909: -- Cursor For OKL_DSF_FCL_FK;
910: /*
911: CURSOR okl_fclv_code_csr (p_code IN OKL_DATA_SRC_FNCTNS_V.fnctn_code%TYPE) IS
912: SELECT '1'
913: FROM FND_COMMON_LOOKUPS
914: WHERE FND_COMMON_LOOKUPS.LOOKUP_CODE = p_code
915: AND FND_COMMON_LOOKUPS.LOOKUP_TYPE = 'OKL_FUNCTION_TYPE';

Line 1268: CURSOR c1( p_id okl_data_src_fnctns_v.id%TYPE,

1264: l_dummy VARCHAR2(1);
1265: l_row_found Boolean := False;
1266:
1267: /*
1268: CURSOR c1( p_id okl_data_src_fnctns_v.id%TYPE,
1269: p_name okl_data_src_fnctns_v.name%TYPE,
1270: p_version okl_data_src_fnctns_v.version%TYPE ) is
1271: SELECT 1
1272: FROM okl_data_src_fnctns_v

Line 1269: p_name okl_data_src_fnctns_v.name%TYPE,

1265: l_row_found Boolean := False;
1266:
1267: /*
1268: CURSOR c1( p_id okl_data_src_fnctns_v.id%TYPE,
1269: p_name okl_data_src_fnctns_v.name%TYPE,
1270: p_version okl_data_src_fnctns_v.version%TYPE ) is
1271: SELECT 1
1272: FROM okl_data_src_fnctns_v
1273: WHERE id = p_id

Line 1270: p_version okl_data_src_fnctns_v.version%TYPE ) is

1266:
1267: /*
1268: CURSOR c1( p_id okl_data_src_fnctns_v.id%TYPE,
1269: p_name okl_data_src_fnctns_v.name%TYPE,
1270: p_version okl_data_src_fnctns_v.version%TYPE ) is
1271: SELECT 1
1272: FROM okl_data_src_fnctns_v
1273: WHERE id = p_id
1274: AND name = p_name

Line 1272: FROM okl_data_src_fnctns_v

1268: CURSOR c1( p_id okl_data_src_fnctns_v.id%TYPE,
1269: p_name okl_data_src_fnctns_v.name%TYPE,
1270: p_version okl_data_src_fnctns_v.version%TYPE ) is
1271: SELECT 1
1272: FROM okl_data_src_fnctns_v
1273: WHERE id = p_id
1274: AND name = p_name
1275: AND version = p_version
1276: AND id <> nvl( p_dsfv_rec.id, -9999 );

Line 1280: CURSOR c1( p_id okl_data_src_fnctns_v.id%TYPE,

1276: AND id <> nvl( p_dsfv_rec.id, -9999 );
1277: */
1278:
1279: -- Changed the cursor select statement
1280: CURSOR c1( p_id okl_data_src_fnctns_v.id%TYPE,
1281: p_name okl_data_src_fnctns_v.name%TYPE,
1282: p_version okl_data_src_fnctns_v.version%TYPE ) is
1283: SELECT 1
1284: FROM okl_data_src_fnctns_v

Line 1281: p_name okl_data_src_fnctns_v.name%TYPE,

1277: */
1278:
1279: -- Changed the cursor select statement
1280: CURSOR c1( p_id okl_data_src_fnctns_v.id%TYPE,
1281: p_name okl_data_src_fnctns_v.name%TYPE,
1282: p_version okl_data_src_fnctns_v.version%TYPE ) is
1283: SELECT 1
1284: FROM okl_data_src_fnctns_v
1285: WHERE name = p_name

Line 1282: p_version okl_data_src_fnctns_v.version%TYPE ) is

1278:
1279: -- Changed the cursor select statement
1280: CURSOR c1( p_id okl_data_src_fnctns_v.id%TYPE,
1281: p_name okl_data_src_fnctns_v.name%TYPE,
1282: p_version okl_data_src_fnctns_v.version%TYPE ) is
1283: SELECT 1
1284: FROM okl_data_src_fnctns_v
1285: WHERE name = p_name
1286: AND version = p_version

Line 1284: FROM okl_data_src_fnctns_v

1280: CURSOR c1( p_id okl_data_src_fnctns_v.id%TYPE,
1281: p_name okl_data_src_fnctns_v.name%TYPE,
1282: p_version okl_data_src_fnctns_v.version%TYPE ) is
1283: SELECT 1
1284: FROM okl_data_src_fnctns_v
1285: WHERE name = p_name
1286: AND version = p_version
1287: AND id <> nvl( p_dsfv_rec.id, -9999 );
1288:

Line 1300: OKC_API.set_message( 'OKL', G_UNQS, G_TABLE_TOKEN, 'Okl_Data_Src_Fnctns_V' );

1296: FETCH c1 into l_dummy;
1297: l_row_found := c1%FOUND;
1298: CLOSE c1;
1299: IF l_row_found then
1300: OKC_API.set_message( 'OKL', G_UNQS, G_TABLE_TOKEN, 'Okl_Data_Src_Fnctns_V' );
1301: x_return_status := OKC_API.G_RET_STS_ERROR;
1302: END IF;
1303:
1304: EXCEPTION

Line 1512: -- validate_row for:OKL_DATA_SRC_FNCTNS_V --

1508: ---------------------------------------------------------------------------
1509: -- PROCEDURE validate_row
1510: ---------------------------------------------------------------------------
1511: --------------------------------------------
1512: -- validate_row for:OKL_DATA_SRC_FNCTNS_V --
1513: --------------------------------------------
1514: PROCEDURE validate_row(
1515: p_api_version IN NUMBER,
1516: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1927: -- insert_row for:OKL_DATA_SRC_FNCTNS_V --

1923: '_PVT'
1924: );
1925: END insert_row;
1926: ------------------------------------------
1927: -- insert_row for:OKL_DATA_SRC_FNCTNS_V --
1928: ------------------------------------------
1929: PROCEDURE insert_row(
1930: p_api_version IN NUMBER,
1931: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1963: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_V --

1959: l_dsfv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1960: RETURN(l_dsfv_rec);
1961: END fill_who_columns;
1962: ----------------------------------------------
1963: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_V --
1964: ----------------------------------------------
1965: FUNCTION Set_Attributes (
1966: p_dsfv_rec IN dsfv_rec_type,
1967: x_dsfv_rec OUT NOCOPY dsfv_rec_type

Line 2361: -- lock_row for:OKL_DATA_SRC_FNCTNS_V --

2357: '_PVT'
2358: );
2359: END lock_row;
2360: ----------------------------------------
2361: -- lock_row for:OKL_DATA_SRC_FNCTNS_V --
2362: ----------------------------------------
2363: PROCEDURE lock_row(
2364: p_api_version IN NUMBER,
2365: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2961: -- update_row for:OKL_DATA_SRC_FNCTNS_V --

2957: '_PVT'
2958: );
2959: END update_row;
2960: ------------------------------------------
2961: -- update_row for:OKL_DATA_SRC_FNCTNS_V --
2962: ------------------------------------------
2963: PROCEDURE update_row(
2964: p_api_version IN NUMBER,
2965: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3142: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_V --

3138: END IF;
3139: RETURN(l_return_status);
3140: END populate_new_record;
3141: ----------------------------------------------
3142: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_V --
3143: ----------------------------------------------
3144: FUNCTION Set_Attributes (
3145: p_dsfv_rec IN dsfv_rec_type,
3146: x_dsfv_rec OUT NOCOPY dsfv_rec_type

Line 3496: -- delete_row for:OKL_DATA_SRC_FNCTNS_V --

3492: '_PVT'
3493: );
3494: END delete_row;
3495: ------------------------------------------
3496: -- delete_row for:OKL_DATA_SRC_FNCTNS_V --
3497: ------------------------------------------
3498: PROCEDURE delete_row(
3499: p_api_version IN NUMBER,
3500: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,