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_B

Line 43: FROM OKL_DATA_SRC_FNCTNS_B B --fixed bug 3321017 by kmotepal

39: BEGIN
40: DELETE FROM OKL_DATA_SRC_FNCTNS_TL T
41: WHERE NOT EXISTS (
42: SELECT NULL
43: FROM OKL_DATA_SRC_FNCTNS_B B --fixed bug 3321017 by kmotepal
44: WHERE B.ID = T.ID
45: );
46:
47: UPDATE OKL_DATA_SRC_FNCTNS_TL T SET (

Line 102: -- FUNCTION get_rec for: OKL_DATA_SRC_FNCTNS_B

98:
99: END add_language;
100:
101: ---------------------------------------------------------------------------
102: -- FUNCTION get_rec for: OKL_DATA_SRC_FNCTNS_B
103: ---------------------------------------------------------------------------
104: FUNCTION get_rec (
105: p_dsf_rec IN dsf_rec_type,
106: x_no_data_found OUT NOCOPY BOOLEAN

Line 108: CURSOR okl_data_src_fnctns_b_pk_csr (p_id IN NUMBER) IS

104: FUNCTION get_rec (
105: p_dsf_rec IN dsf_rec_type,
106: x_no_data_found OUT NOCOPY BOOLEAN
107: ) RETURN dsf_rec_type IS
108: CURSOR okl_data_src_fnctns_b_pk_csr (p_id IN NUMBER) IS
109: SELECT
110: ID,
111: OBJECT_VERSION_NUMBER,
112: NAME,

Line 140: FROM Okl_Data_Src_Fnctns_B

136: CREATION_DATE,
137: LAST_UPDATED_BY,
138: LAST_UPDATE_DATE,
139: LAST_UPDATE_LOGIN
140: FROM Okl_Data_Src_Fnctns_B
141: WHERE okl_data_src_fnctns_b.id = p_id;
142: l_okl_data_src_fnctns_b_pk okl_data_src_fnctns_b_pk_csr%ROWTYPE;
143: l_dsf_rec dsf_rec_type;
144: BEGIN

Line 141: WHERE okl_data_src_fnctns_b.id = p_id;

137: LAST_UPDATED_BY,
138: LAST_UPDATE_DATE,
139: LAST_UPDATE_LOGIN
140: FROM Okl_Data_Src_Fnctns_B
141: WHERE okl_data_src_fnctns_b.id = p_id;
142: l_okl_data_src_fnctns_b_pk okl_data_src_fnctns_b_pk_csr%ROWTYPE;
143: l_dsf_rec dsf_rec_type;
144: BEGIN
145: x_no_data_found := TRUE;

Line 142: l_okl_data_src_fnctns_b_pk okl_data_src_fnctns_b_pk_csr%ROWTYPE;

138: LAST_UPDATE_DATE,
139: LAST_UPDATE_LOGIN
140: FROM Okl_Data_Src_Fnctns_B
141: WHERE okl_data_src_fnctns_b.id = p_id;
142: l_okl_data_src_fnctns_b_pk okl_data_src_fnctns_b_pk_csr%ROWTYPE;
143: l_dsf_rec dsf_rec_type;
144: BEGIN
145: x_no_data_found := TRUE;
146: -- Get current database values

Line 147: OPEN okl_data_src_fnctns_b_pk_csr (p_dsf_rec.id);

143: l_dsf_rec dsf_rec_type;
144: BEGIN
145: x_no_data_found := TRUE;
146: -- Get current database values
147: OPEN okl_data_src_fnctns_b_pk_csr (p_dsf_rec.id);
148: FETCH okl_data_src_fnctns_b_pk_csr INTO
149: l_dsf_rec.ID,
150: l_dsf_rec.OBJECT_VERSION_NUMBER,
151: l_dsf_rec.NAME,

Line 148: FETCH okl_data_src_fnctns_b_pk_csr INTO

144: BEGIN
145: x_no_data_found := TRUE;
146: -- Get current database values
147: OPEN okl_data_src_fnctns_b_pk_csr (p_dsf_rec.id);
148: FETCH okl_data_src_fnctns_b_pk_csr INTO
149: l_dsf_rec.ID,
150: l_dsf_rec.OBJECT_VERSION_NUMBER,
151: l_dsf_rec.NAME,
152: l_dsf_rec.VERSION,

Line 179: x_no_data_found := okl_data_src_fnctns_b_pk_csr%NOTFOUND;

175: l_dsf_rec.CREATION_DATE,
176: l_dsf_rec.LAST_UPDATED_BY,
177: l_dsf_rec.LAST_UPDATE_DATE,
178: l_dsf_rec.LAST_UPDATE_LOGIN;
179: x_no_data_found := okl_data_src_fnctns_b_pk_csr%NOTFOUND;
180: CLOSE okl_data_src_fnctns_b_pk_csr;
181: RETURN(l_dsf_rec);
182: END get_rec;
183:

Line 180: CLOSE okl_data_src_fnctns_b_pk_csr;

176: l_dsf_rec.LAST_UPDATED_BY,
177: l_dsf_rec.LAST_UPDATE_DATE,
178: l_dsf_rec.LAST_UPDATE_LOGIN;
179: x_no_data_found := okl_data_src_fnctns_b_pk_csr%NOTFOUND;
180: CLOSE okl_data_src_fnctns_b_pk_csr;
181: RETURN(l_dsf_rec);
182: END get_rec;
183:
184: FUNCTION get_rec (

Line 1668: -- insert_row for:OKL_DATA_SRC_FNCTNS_B --

1664: ---------------------------------------------------------------------------
1665: -- PROCEDURE insert_row
1666: ---------------------------------------------------------------------------
1667: ------------------------------------------
1668: -- insert_row for:OKL_DATA_SRC_FNCTNS_B --
1669: ------------------------------------------
1670: PROCEDURE insert_row(
1671: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1672: x_return_status OUT NOCOPY VARCHAR2,

Line 1684: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_B --

1680: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1681: l_dsf_rec dsf_rec_type := p_dsf_rec;
1682: l_def_dsf_rec dsf_rec_type;
1683: ----------------------------------------------
1684: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_B --
1685: ----------------------------------------------
1686: FUNCTION Set_Attributes (
1687: p_dsf_rec IN dsf_rec_type,
1688: x_dsf_rec OUT NOCOPY dsf_rec_type

Line 1715: INSERT INTO OKL_DATA_SRC_FNCTNS_B(

1711: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1712: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1713: RAISE OKC_API.G_EXCEPTION_ERROR;
1714: END IF;
1715: INSERT INTO OKL_DATA_SRC_FNCTNS_B(
1716: id,
1717: object_version_number,
1718: name,
1719: version,

Line 2170: -- lock_row for:OKL_DATA_SRC_FNCTNS_B --

2166: ---------------------------------------------------------------------------
2167: -- PROCEDURE lock_row
2168: ---------------------------------------------------------------------------
2169: ----------------------------------------
2170: -- lock_row for:OKL_DATA_SRC_FNCTNS_B --
2171: ----------------------------------------
2172: PROCEDURE lock_row(
2173: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2174: x_return_status OUT NOCOPY VARCHAR2,

Line 2183: FROM OKL_DATA_SRC_FNCTNS_B

2179: E_Resource_Busy EXCEPTION;
2180: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2181: CURSOR lock_csr (p_dsf_rec IN dsf_rec_type) IS
2182: SELECT OBJECT_VERSION_NUMBER
2183: FROM OKL_DATA_SRC_FNCTNS_B
2184: WHERE ID = p_dsf_rec.id
2185: AND OBJECT_VERSION_NUMBER = p_dsf_rec.object_version_number
2186: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2187:

Line 2190: FROM OKL_DATA_SRC_FNCTNS_B

2186: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2187:
2188: CURSOR lchk_csr (p_dsf_rec IN dsf_rec_type) IS
2189: SELECT OBJECT_VERSION_NUMBER
2190: FROM OKL_DATA_SRC_FNCTNS_B
2191: WHERE ID = p_dsf_rec.id;
2192: l_api_version CONSTANT NUMBER := 1;
2193: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2194: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2195: l_object_version_number OKL_DATA_SRC_FNCTNS_B.OBJECT_VERSION_NUMBER%TYPE;

2191: WHERE ID = p_dsf_rec.id;
2192: l_api_version CONSTANT NUMBER := 1;
2193: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2194: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2195: l_object_version_number OKL_DATA_SRC_FNCTNS_B.OBJECT_VERSION_NUMBER%TYPE;
2196: lc_object_version_number OKL_DATA_SRC_FNCTNS_B.OBJECT_VERSION_NUMBER%TYPE;
2197: l_row_notfound BOOLEAN := FALSE;
2198: lc_row_notfound BOOLEAN := FALSE;
2199: BEGIN

Line 2196: lc_object_version_number OKL_DATA_SRC_FNCTNS_B.OBJECT_VERSION_NUMBER%TYPE;

2192: l_api_version CONSTANT NUMBER := 1;
2193: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2194: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2195: l_object_version_number OKL_DATA_SRC_FNCTNS_B.OBJECT_VERSION_NUMBER%TYPE;
2196: lc_object_version_number OKL_DATA_SRC_FNCTNS_B.OBJECT_VERSION_NUMBER%TYPE;
2197: l_row_notfound BOOLEAN := FALSE;
2198: lc_row_notfound BOOLEAN := FALSE;
2199: BEGIN
2200: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2534: -- update_row for:OKL_DATA_SRC_FNCTNS_B --

2530: ---------------------------------------------------------------------------
2531: -- PROCEDURE update_row
2532: ---------------------------------------------------------------------------
2533: ------------------------------------------
2534: -- update_row for:OKL_DATA_SRC_FNCTNS_B --
2535: ------------------------------------------
2536: PROCEDURE update_row(
2537: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2538: x_return_status OUT NOCOPY VARCHAR2,

Line 2690: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_B --

2686: END IF;
2687: RETURN(l_return_status);
2688: END populate_new_record;
2689: ----------------------------------------------
2690: -- Set_Attributes for:OKL_DATA_SRC_FNCTNS_B --
2691: ----------------------------------------------
2692: FUNCTION Set_Attributes (
2693: p_dsf_rec IN dsf_rec_type,
2694: x_dsf_rec OUT NOCOPY dsf_rec_type

Line 2727: UPDATE OKL_DATA_SRC_FNCTNS_B

2723: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2724: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2725: RAISE OKC_API.G_EXCEPTION_ERROR;
2726: END IF;
2727: UPDATE OKL_DATA_SRC_FNCTNS_B
2728: SET OBJECT_VERSION_NUMBER = l_def_dsf_rec.object_version_number,
2729: NAME = l_def_dsf_rec.name,
2730: VERSION = l_def_dsf_rec.version,
2731: SOURCE = l_def_dsf_rec.source,

Line 3351: -- delete_row for:OKL_DATA_SRC_FNCTNS_B --

3347: ---------------------------------------------------------------------------
3348: -- PROCEDURE delete_row
3349: ---------------------------------------------------------------------------
3350: ------------------------------------------
3351: -- delete_row for:OKL_DATA_SRC_FNCTNS_B --
3352: ------------------------------------------
3353: PROCEDURE delete_row(
3354: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3355: x_return_status OUT NOCOPY VARCHAR2,

Line 3375: DELETE FROM OKL_DATA_SRC_FNCTNS_B

3371: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3372: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3373: RAISE OKC_API.G_EXCEPTION_ERROR;
3374: END IF;
3375: DELETE FROM OKL_DATA_SRC_FNCTNS_B
3376: WHERE ID = l_dsf_rec.id;
3377:
3378: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3379: EXCEPTION

Line 3730: FROM OKL_DATA_SRC_FNCTNS_B

3726:
3727: BEGIN
3728: SELECT ID , LAST_UPDATED_BY, LAST_UPDATE_DATE
3729: INTO id, db_luby, db_ludate
3730: FROM OKL_DATA_SRC_FNCTNS_B
3731: where ID = p_dsfv_rec.id;
3732:
3733: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
3734: db_ludate, '')) then

Line 3736: UPDATE OKL_DATA_SRC_FNCTNS_B

3732:
3733: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
3734: db_ludate, '')) then
3735: --Update _b
3736: UPDATE OKL_DATA_SRC_FNCTNS_B
3737: SET
3738: OBJECT_VERSION_NUMBER = TO_NUMBER(p_dsfv_rec.OBJECT_VERSION_NUMBER),
3739: NAME = p_dsfv_rec.NAME,
3740: SOURCE = p_dsfv_rec.SOURCE,

Line 3814: INSERT INTO OKL_DATA_SRC_FNCTNS_B

3810:
3811: END;
3812: EXCEPTION
3813: when no_data_found then
3814: INSERT INTO OKL_DATA_SRC_FNCTNS_B
3815: (
3816: ID,
3817: OBJECT_VERSION_NUMBER,
3818: NAME,

Line 3880: from OKL_DATA_SRC_FNCTNS_B

3876: f_ludate,
3877: 0
3878: FROM DUAL
3879: WHERE NOT EXISTS (SELECT 1
3880: from OKL_DATA_SRC_FNCTNS_B
3881: where (ID = TO_NUMBER(p_dsfv_rec.id) OR
3882: (NAME = p_dsfv_rec.name AND VERSION = p_dsfv_rec.version)));
3883:
3884: INSERT INTO OKL_DATA_SRC_FNCTNS_TL