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_FPR_PVT dependencies on OKL_FNCTN_PRMTRS_B

Line 47: FROM OKL_FNCTN_PRMTRS_B B --fixed bug 3321017 by kmotepal

43: BEGIN
44: DELETE FROM OKL_FNCTN_PRMTRS_TL T
45: WHERE NOT EXISTS (
46: SELECT NULL
47: FROM OKL_FNCTN_PRMTRS_B B --fixed bug 3321017 by kmotepal
48: WHERE B.ID = T.ID
49: );
50:
51: UPDATE OKL_FNCTN_PRMTRS_TL T SET (

Line 113: -- FUNCTION get_rec for: OKL_FNCTN_PRMTRS_B

109:
110: END add_language;
111:
112: ---------------------------------------------------------------------------
113: -- FUNCTION get_rec for: OKL_FNCTN_PRMTRS_B
114: ---------------------------------------------------------------------------
115: FUNCTION get_rec (
116: p_fpr_rec IN fpr_rec_type,
117: x_no_data_found OUT NOCOPY BOOLEAN

Line 119: CURSOR okl_fnctn_prmtrs_b_pk_csr (p_id IN NUMBER) IS

115: FUNCTION get_rec (
116: p_fpr_rec IN fpr_rec_type,
117: x_no_data_found OUT NOCOPY BOOLEAN
118: ) RETURN fpr_rec_type IS
119: CURSOR okl_fnctn_prmtrs_b_pk_csr (p_id IN NUMBER) IS
120: SELECT
121: ID,
122: DSF_ID,
123: PMR_ID,

Line 132: FROM Okl_Fnctn_Prmtrs_B

128: CREATION_DATE,
129: LAST_UPDATED_BY,
130: LAST_UPDATE_DATE,
131: LAST_UPDATE_LOGIN
132: FROM Okl_Fnctn_Prmtrs_B
133: WHERE okl_fnctn_prmtrs_b.id = p_id;
134: l_okl_fnctn_prmtrs_b_pk okl_fnctn_prmtrs_b_pk_csr%ROWTYPE;
135: l_fpr_rec fpr_rec_type;
136: BEGIN

Line 133: WHERE okl_fnctn_prmtrs_b.id = p_id;

129: LAST_UPDATED_BY,
130: LAST_UPDATE_DATE,
131: LAST_UPDATE_LOGIN
132: FROM Okl_Fnctn_Prmtrs_B
133: WHERE okl_fnctn_prmtrs_b.id = p_id;
134: l_okl_fnctn_prmtrs_b_pk okl_fnctn_prmtrs_b_pk_csr%ROWTYPE;
135: l_fpr_rec fpr_rec_type;
136: BEGIN
137: x_no_data_found := TRUE;

Line 134: l_okl_fnctn_prmtrs_b_pk okl_fnctn_prmtrs_b_pk_csr%ROWTYPE;

130: LAST_UPDATE_DATE,
131: LAST_UPDATE_LOGIN
132: FROM Okl_Fnctn_Prmtrs_B
133: WHERE okl_fnctn_prmtrs_b.id = p_id;
134: l_okl_fnctn_prmtrs_b_pk okl_fnctn_prmtrs_b_pk_csr%ROWTYPE;
135: l_fpr_rec fpr_rec_type;
136: BEGIN
137: x_no_data_found := TRUE;
138: -- Get current database values

Line 139: OPEN okl_fnctn_prmtrs_b_pk_csr (p_fpr_rec.id);

135: l_fpr_rec fpr_rec_type;
136: BEGIN
137: x_no_data_found := TRUE;
138: -- Get current database values
139: OPEN okl_fnctn_prmtrs_b_pk_csr (p_fpr_rec.id);
140: FETCH okl_fnctn_prmtrs_b_pk_csr INTO
141: l_fpr_rec.ID,
142: l_fpr_rec.DSF_ID,
143: l_fpr_rec.PMR_ID,

Line 140: FETCH okl_fnctn_prmtrs_b_pk_csr INTO

136: BEGIN
137: x_no_data_found := TRUE;
138: -- Get current database values
139: OPEN okl_fnctn_prmtrs_b_pk_csr (p_fpr_rec.id);
140: FETCH okl_fnctn_prmtrs_b_pk_csr INTO
141: l_fpr_rec.ID,
142: l_fpr_rec.DSF_ID,
143: l_fpr_rec.PMR_ID,
144: l_fpr_rec.FPR_TYPE,

Line 152: x_no_data_found := okl_fnctn_prmtrs_b_pk_csr%NOTFOUND;

148: l_fpr_rec.CREATION_DATE,
149: l_fpr_rec.LAST_UPDATED_BY,
150: l_fpr_rec.LAST_UPDATE_DATE,
151: l_fpr_rec.LAST_UPDATE_LOGIN;
152: x_no_data_found := okl_fnctn_prmtrs_b_pk_csr%NOTFOUND;
153: CLOSE okl_fnctn_prmtrs_b_pk_csr;
154: RETURN(l_fpr_rec);
155: END get_rec;
156:

Line 153: CLOSE okl_fnctn_prmtrs_b_pk_csr;

149: l_fpr_rec.LAST_UPDATED_BY,
150: l_fpr_rec.LAST_UPDATE_DATE,
151: l_fpr_rec.LAST_UPDATE_LOGIN;
152: x_no_data_found := okl_fnctn_prmtrs_b_pk_csr%NOTFOUND;
153: CLOSE okl_fnctn_prmtrs_b_pk_csr;
154: RETURN(l_fpr_rec);
155: END get_rec;
156:
157: FUNCTION get_rec (

Line 1353: -- insert_row for:OKL_FNCTN_PRMTRS_B --

1349: ---------------------------------------------------------------------------
1350: -- PROCEDURE insert_row
1351: ---------------------------------------------------------------------------
1352: ---------------------------------------
1353: -- insert_row for:OKL_FNCTN_PRMTRS_B --
1354: ---------------------------------------
1355: PROCEDURE insert_row(
1356: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1357: x_return_status OUT NOCOPY VARCHAR2,

Line 1369: -- Set_Attributes for:OKL_FNCTN_PRMTRS_B --

1365: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1366: l_fpr_rec fpr_rec_type := p_fpr_rec;
1367: l_def_fpr_rec fpr_rec_type;
1368: -------------------------------------------
1369: -- Set_Attributes for:OKL_FNCTN_PRMTRS_B --
1370: -------------------------------------------
1371: FUNCTION Set_Attributes (
1372: p_fpr_rec IN fpr_rec_type,
1373: x_fpr_rec OUT NOCOPY fpr_rec_type

Line 1400: INSERT INTO OKL_FNCTN_PRMTRS_B(

1396: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1397: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1398: RAISE Okc_Api.G_EXCEPTION_ERROR;
1399: END IF;
1400: INSERT INTO OKL_FNCTN_PRMTRS_B(
1401: id,
1402: dsf_id,
1403: pmr_id,
1404: fpr_type,

Line 1825: -- lock_row for:OKL_FNCTN_PRMTRS_B --

1821: ---------------------------------------------------------------------------
1822: -- PROCEDURE lock_row
1823: ---------------------------------------------------------------------------
1824: -------------------------------------
1825: -- lock_row for:OKL_FNCTN_PRMTRS_B --
1826: -------------------------------------
1827: PROCEDURE lock_row(
1828: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1829: x_return_status OUT NOCOPY VARCHAR2,

Line 1838: FROM OKL_FNCTN_PRMTRS_B

1834: E_Resource_Busy EXCEPTION;
1835: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1836: CURSOR lock_csr (p_fpr_rec IN fpr_rec_type) IS
1837: SELECT OBJECT_VERSION_NUMBER
1838: FROM OKL_FNCTN_PRMTRS_B
1839: WHERE ID = p_fpr_rec.id
1840: AND OBJECT_VERSION_NUMBER = p_fpr_rec.object_version_number
1841: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1842:

Line 1845: FROM OKL_FNCTN_PRMTRS_B

1841: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1842:
1843: CURSOR lchk_csr (p_fpr_rec IN fpr_rec_type) IS
1844: SELECT OBJECT_VERSION_NUMBER
1845: FROM OKL_FNCTN_PRMTRS_B
1846: WHERE ID = p_fpr_rec.id;
1847: l_api_version CONSTANT NUMBER := 1;
1848: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1849: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 1850: l_object_version_number OKL_FNCTN_PRMTRS_B.OBJECT_VERSION_NUMBER%TYPE;

1846: WHERE ID = p_fpr_rec.id;
1847: l_api_version CONSTANT NUMBER := 1;
1848: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1849: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1850: l_object_version_number OKL_FNCTN_PRMTRS_B.OBJECT_VERSION_NUMBER%TYPE;
1851: lc_object_version_number OKL_FNCTN_PRMTRS_B.OBJECT_VERSION_NUMBER%TYPE;
1852: l_row_notfound BOOLEAN := FALSE;
1853: lc_row_notfound BOOLEAN := FALSE;
1854: BEGIN

Line 1851: lc_object_version_number OKL_FNCTN_PRMTRS_B.OBJECT_VERSION_NUMBER%TYPE;

1847: l_api_version CONSTANT NUMBER := 1;
1848: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1849: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1850: l_object_version_number OKL_FNCTN_PRMTRS_B.OBJECT_VERSION_NUMBER%TYPE;
1851: lc_object_version_number OKL_FNCTN_PRMTRS_B.OBJECT_VERSION_NUMBER%TYPE;
1852: l_row_notfound BOOLEAN := FALSE;
1853: lc_row_notfound BOOLEAN := FALSE;
1854: BEGIN
1855: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 2194: -- update_row for:OKL_FNCTN_PRMTRS_B --

2190: ---------------------------------------------------------------------------
2191: -- PROCEDURE update_row
2192: ---------------------------------------------------------------------------
2193: ---------------------------------------
2194: -- update_row for:OKL_FNCTN_PRMTRS_B --
2195: ---------------------------------------
2196: PROCEDURE update_row(
2197: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2198: x_return_status OUT NOCOPY VARCHAR2,

Line 2274: -- Set_Attributes for:OKL_FNCTN_PRMTRS_B --

2270: END IF;
2271: RETURN(l_return_status);
2272: END populate_new_record;
2273: -------------------------------------------
2274: -- Set_Attributes for:OKL_FNCTN_PRMTRS_B --
2275: -------------------------------------------
2276: FUNCTION Set_Attributes (
2277: p_fpr_rec IN fpr_rec_type,
2278: x_fpr_rec OUT NOCOPY fpr_rec_type

Line 2311: UPDATE OKL_FNCTN_PRMTRS_B

2307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2308: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2309: RAISE Okc_Api.G_EXCEPTION_ERROR;
2310: END IF;
2311: UPDATE OKL_FNCTN_PRMTRS_B
2312: SET DSF_ID = l_def_fpr_rec.dsf_id,
2313: PMR_ID = l_def_fpr_rec.pmr_id,
2314: FPR_TYPE = l_def_fpr_rec.fpr_type,
2315: OBJECT_VERSION_NUMBER = l_def_fpr_rec.object_version_number,

Line 2854: -- delete_row for:OKL_FNCTN_PRMTRS_B --

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

Line 2878: DELETE FROM OKL_FNCTN_PRMTRS_B

2874: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2875: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2876: RAISE Okc_Api.G_EXCEPTION_ERROR;
2877: END IF;
2878: DELETE FROM OKL_FNCTN_PRMTRS_B
2879: WHERE ID = l_fpr_rec.id;
2880:
2881: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2882: EXCEPTION

Line 3239: FROM OKL_FNCTN_PRMTRS_B

3235:
3236: BEGIN
3237: SELECT ID , LAST_UPDATED_BY, LAST_UPDATE_DATE
3238: INTO id, db_luby, db_ludate
3239: FROM OKL_FNCTN_PRMTRS_B
3240: where ID = p_fprv_rec.id;
3241:
3242: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
3243: db_ludate, '')) then

Line 3245: UPDATE OKL_FNCTN_PRMTRS_B

3241:
3242: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
3243: db_ludate, '')) then
3244: --Update _b
3245: UPDATE OKL_FNCTN_PRMTRS_B
3246: SET FPR_TYPE = p_fprv_rec.fpr_type,
3247: OBJECT_VERSION_NUMBER = TO_NUMBER(p_fprv_rec.object_version_number),
3248: SEQUENCE_NUMBER = TO_NUMBER(p_fprv_rec.sequence_number),
3249: LAST_UPDATE_DATE = f_ludate,

Line 3304: INSERT INTO OKL_FNCTN_PRMTRS_B

3300: END IF;
3301: END;
3302: EXCEPTION
3303: when no_data_found then
3304: INSERT INTO OKL_FNCTN_PRMTRS_B
3305: (
3306: ID,
3307: DSF_ID,
3308: PMR_ID,