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_PMR_PVT dependencies on OKL_PARAMETERS_B

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

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

Line 102: -- FUNCTION get_rec for: OKL_PARAMETERS_B

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

Line 108: CURSOR okl_parameters_b_pk_csr (p_id IN NUMBER) IS

104: FUNCTION get_rec (
105: p_pmr_rec IN pmr_rec_type,
106: x_no_data_found OUT NOCOPY BOOLEAN
107: ) RETURN pmr_rec_type IS
108: CURSOR okl_parameters_b_pk_csr (p_id IN NUMBER) IS
109: SELECT
110: ID,
111: NAME,
112: CUSTOMIZATION_LEVEL,

Line 120: FROM Okl_Parameters_B

116: CREATION_DATE,
117: LAST_UPDATED_BY,
118: LAST_UPDATE_DATE,
119: LAST_UPDATE_LOGIN
120: FROM Okl_Parameters_B
121: WHERE okl_parameters_b.id = p_id;
122: l_okl_parameters_b_pk okl_parameters_b_pk_csr%ROWTYPE;
123: l_pmr_rec pmr_rec_type;
124: BEGIN

Line 121: WHERE okl_parameters_b.id = p_id;

117: LAST_UPDATED_BY,
118: LAST_UPDATE_DATE,
119: LAST_UPDATE_LOGIN
120: FROM Okl_Parameters_B
121: WHERE okl_parameters_b.id = p_id;
122: l_okl_parameters_b_pk okl_parameters_b_pk_csr%ROWTYPE;
123: l_pmr_rec pmr_rec_type;
124: BEGIN
125: x_no_data_found := TRUE;

Line 122: l_okl_parameters_b_pk okl_parameters_b_pk_csr%ROWTYPE;

118: LAST_UPDATE_DATE,
119: LAST_UPDATE_LOGIN
120: FROM Okl_Parameters_B
121: WHERE okl_parameters_b.id = p_id;
122: l_okl_parameters_b_pk okl_parameters_b_pk_csr%ROWTYPE;
123: l_pmr_rec pmr_rec_type;
124: BEGIN
125: x_no_data_found := TRUE;
126: -- Get current database values

Line 127: OPEN okl_parameters_b_pk_csr (p_pmr_rec.id);

123: l_pmr_rec pmr_rec_type;
124: BEGIN
125: x_no_data_found := TRUE;
126: -- Get current database values
127: OPEN okl_parameters_b_pk_csr (p_pmr_rec.id);
128: FETCH okl_parameters_b_pk_csr INTO
129: l_pmr_rec.ID,
130: l_pmr_rec.NAME,
131: l_pmr_rec.DATATYPE,

Line 128: FETCH okl_parameters_b_pk_csr INTO

124: BEGIN
125: x_no_data_found := TRUE;
126: -- Get current database values
127: OPEN okl_parameters_b_pk_csr (p_pmr_rec.id);
128: FETCH okl_parameters_b_pk_csr INTO
129: l_pmr_rec.ID,
130: l_pmr_rec.NAME,
131: l_pmr_rec.DATATYPE,
132: l_pmr_rec.CUSTOMIZATION_LEVEL,

Line 139: x_no_data_found := okl_parameters_b_pk_csr%NOTFOUND;

135: l_pmr_rec.CREATION_DATE,
136: l_pmr_rec.LAST_UPDATED_BY,
137: l_pmr_rec.LAST_UPDATE_DATE,
138: l_pmr_rec.LAST_UPDATE_LOGIN;
139: x_no_data_found := okl_parameters_b_pk_csr%NOTFOUND;
140: CLOSE okl_parameters_b_pk_csr;
141: RETURN(l_pmr_rec);
142: END get_rec;
143:

Line 140: CLOSE okl_parameters_b_pk_csr;

136: l_pmr_rec.LAST_UPDATED_BY,
137: l_pmr_rec.LAST_UPDATE_DATE,
138: l_pmr_rec.LAST_UPDATE_LOGIN;
139: x_no_data_found := okl_parameters_b_pk_csr%NOTFOUND;
140: CLOSE okl_parameters_b_pk_csr;
141: RETURN(l_pmr_rec);
142: END get_rec;
143:
144: FUNCTION get_rec (

Line 1183: -- insert_row for:OKL_PARAMETERS_B --

1179: ---------------------------------------------------------------------------
1180: -- PROCEDURE insert_row
1181: ---------------------------------------------------------------------------
1182: -------------------------------------
1183: -- insert_row for:OKL_PARAMETERS_B --
1184: -------------------------------------
1185: PROCEDURE insert_row(
1186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1187: x_return_status OUT NOCOPY VARCHAR2,

Line 1199: -- Set_Attributes for:OKL_PARAMETERS_B --

1195: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1196: l_pmr_rec pmr_rec_type := p_pmr_rec;
1197: l_def_pmr_rec pmr_rec_type;
1198: -----------------------------------------
1199: -- Set_Attributes for:OKL_PARAMETERS_B --
1200: -----------------------------------------
1201: FUNCTION Set_Attributes (
1202: p_pmr_rec IN pmr_rec_type,
1203: x_pmr_rec OUT NOCOPY pmr_rec_type

Line 1230: INSERT INTO OKL_PARAMETERS_B(

1226: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1227: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1228: RAISE OKC_API.G_EXCEPTION_ERROR;
1229: END IF;
1230: INSERT INTO OKL_PARAMETERS_B(
1231: id,
1232: name,
1233: datatype,
1234: object_version_number,

Line 1646: -- lock_row for:OKL_PARAMETERS_B --

1642: ---------------------------------------------------------------------------
1643: -- PROCEDURE lock_row
1644: ---------------------------------------------------------------------------
1645: -----------------------------------
1646: -- lock_row for:OKL_PARAMETERS_B --
1647: -----------------------------------
1648: PROCEDURE lock_row(
1649: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1650: x_return_status OUT NOCOPY VARCHAR2,

Line 1659: FROM OKL_PARAMETERS_B

1655: E_Resource_Busy EXCEPTION;
1656: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1657: CURSOR lock_csr (p_pmr_rec IN pmr_rec_type) IS
1658: SELECT OBJECT_VERSION_NUMBER
1659: FROM OKL_PARAMETERS_B
1660: WHERE ID = p_pmr_rec.id
1661: AND OBJECT_VERSION_NUMBER = p_pmr_rec.object_version_number
1662: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1663:

Line 1666: FROM OKL_PARAMETERS_B

1662: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1663:
1664: CURSOR lchk_csr (p_pmr_rec IN pmr_rec_type) IS
1665: SELECT OBJECT_VERSION_NUMBER
1666: FROM OKL_PARAMETERS_B
1667: WHERE ID = p_pmr_rec.id;
1668: l_api_version CONSTANT NUMBER := 1;
1669: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1670: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1671: l_object_version_number OKL_PARAMETERS_B.OBJECT_VERSION_NUMBER%TYPE;

1667: WHERE ID = p_pmr_rec.id;
1668: l_api_version CONSTANT NUMBER := 1;
1669: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1670: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1671: l_object_version_number OKL_PARAMETERS_B.OBJECT_VERSION_NUMBER%TYPE;
1672: lc_object_version_number OKL_PARAMETERS_B.OBJECT_VERSION_NUMBER%TYPE;
1673: l_row_notfound BOOLEAN := FALSE;
1674: lc_row_notfound BOOLEAN := FALSE;
1675: BEGIN

Line 1672: lc_object_version_number OKL_PARAMETERS_B.OBJECT_VERSION_NUMBER%TYPE;

1668: l_api_version CONSTANT NUMBER := 1;
1669: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1670: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1671: l_object_version_number OKL_PARAMETERS_B.OBJECT_VERSION_NUMBER%TYPE;
1672: lc_object_version_number OKL_PARAMETERS_B.OBJECT_VERSION_NUMBER%TYPE;
1673: l_row_notfound BOOLEAN := FALSE;
1674: lc_row_notfound BOOLEAN := FALSE;
1675: BEGIN
1676: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2011: -- update_row for:OKL_PARAMETERS_B --

2007: ---------------------------------------------------------------------------
2008: -- PROCEDURE update_row
2009: ---------------------------------------------------------------------------
2010: -------------------------------------
2011: -- update_row for:OKL_PARAMETERS_B --
2012: -------------------------------------
2013: PROCEDURE update_row(
2014: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2015: x_return_status OUT NOCOPY VARCHAR2,

Line 2087: -- Set_Attributes for:OKL_PARAMETERS_B --

2083: END IF;
2084: RETURN(l_return_status);
2085: END populate_new_record;
2086: -----------------------------------------
2087: -- Set_Attributes for:OKL_PARAMETERS_B --
2088: -----------------------------------------
2089: FUNCTION Set_Attributes (
2090: p_pmr_rec IN pmr_rec_type,
2091: x_pmr_rec OUT NOCOPY pmr_rec_type

Line 2124: UPDATE OKL_PARAMETERS_B

2120: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2121: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2122: RAISE OKC_API.G_EXCEPTION_ERROR;
2123: END IF;
2124: UPDATE OKL_PARAMETERS_B
2125: SET DATATYPE = l_def_pmr_rec.datatype,
2126: CUSTOMIZATION_LEVEL = l_def_pmr_rec.customization_level,
2127: NAME = l_def_pmr_rec.name,
2128: OBJECT_VERSION_NUMBER = l_def_pmr_rec.object_version_number,

Line 2653: -- delete_row for:OKL_PARAMETERS_B --

2649: ---------------------------------------------------------------------------
2650: -- PROCEDURE delete_row
2651: ---------------------------------------------------------------------------
2652: -------------------------------------
2653: -- delete_row for:OKL_PARAMETERS_B --
2654: -------------------------------------
2655: PROCEDURE delete_row(
2656: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2657: x_return_status OUT NOCOPY VARCHAR2,

Line 2677: DELETE FROM OKL_PARAMETERS_B

2673: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2674: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2675: RAISE OKC_API.G_EXCEPTION_ERROR;
2676: END IF;
2677: DELETE FROM OKL_PARAMETERS_B
2678: WHERE ID = l_pmr_rec.id;
2679:
2680: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2681: EXCEPTION

Line 3033: FROM OKL_PARAMETERS_B

3029:
3030: BEGIN
3031: SELECT ID , LAST_UPDATED_BY, LAST_UPDATE_DATE
3032: INTO id, db_luby, db_ludate
3033: FROM OKL_PARAMETERS_B
3034: where ID = p_pmrv_rec.id;
3035:
3036: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
3037: db_ludate, '')) then

Line 3039: UPDATE OKL_PARAMETERS_B

3035:
3036: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
3037: db_ludate, '')) then
3038: --Update _b
3039: UPDATE OKL_PARAMETERS_B
3040: SET
3041: DATATYPE = p_pmrv_rec.datatype,
3042: OBJECT_VERSION_NUMBER = TO_NUMBER(p_pmrv_rec.object_version_number),
3043: CUSTOMIZATION_LEVEL = p_pmrv_rec.customization_level,

Line 3097: INSERT INTO OKL_PARAMETERS_B

3093:
3094: END;
3095: EXCEPTION
3096: when no_data_found then
3097: INSERT INTO OKL_PARAMETERS_B
3098: (
3099: ID,
3100: NAME,
3101: DATATYPE,

Line 3123: from OKL_PARAMETERS_B

3119: f_ludate,
3120: 0
3121: FROM DUAL
3122: WHERE NOT EXISTS (SELECT 1
3123: from OKL_PARAMETERS_B
3124: where ( ID = TO_NUMBER(p_pmrv_rec.id) OR (NAME = p_pmrv_rec.name)));
3125:
3126: INSERT INTO OKL_PARAMETERS_TL
3127: (