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.

[Home] [Help]

APPS.OKL_KRP_PVT dependencies on OKL_K_RATE_PARAMS_V

Line 140: -- FUNCTION get_rec for: OKL_K_RATE_PARAMS_V

136: null;
137: END api_copy;
138:
139: ---------------------------------------------------------------------------
140: -- FUNCTION get_rec for: OKL_K_RATE_PARAMS_V
141: ---------------------------------------------------------------------------
142: FUNCTION get_rec (
143: p_krpv_rec IN krpv_rec_type,
144: x_no_data_found OUT NOCOPY BOOLEAN

Line 146: CURSOR okl_k_rate_params_v_u1_csr (p_effective_from_date IN DATE,

142: FUNCTION get_rec (
143: p_krpv_rec IN krpv_rec_type,
144: x_no_data_found OUT NOCOPY BOOLEAN
145: ) RETURN krpv_rec_type IS
146: CURSOR okl_k_rate_params_v_u1_csr (p_effective_from_date IN DATE,
147: p_khr_id IN NUMBER,
148: p_parameter_type_code IN VARCHAR2) IS
149: SELECT
150: KHR_ID,

Line 199: FROM Okl_K_Rate_Params_V

195: LAST_UPDATED_BY,
196: LAST_UPDATE_DATE,
197: LAST_UPDATE_LOGIN,
198: CATCHUP_FREQUENCY_CODE
199: FROM Okl_K_Rate_Params_V
200: WHERE okl_k_rate_params_v.effective_from_date = p_effective_from_date
201: AND okl_k_rate_params_v.khr_id = p_khr_id
202: AND okl_k_rate_params_v.parameter_type_code = p_parameter_type_code;
203: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;

Line 200: WHERE okl_k_rate_params_v.effective_from_date = p_effective_from_date

196: LAST_UPDATE_DATE,
197: LAST_UPDATE_LOGIN,
198: CATCHUP_FREQUENCY_CODE
199: FROM Okl_K_Rate_Params_V
200: WHERE okl_k_rate_params_v.effective_from_date = p_effective_from_date
201: AND okl_k_rate_params_v.khr_id = p_khr_id
202: AND okl_k_rate_params_v.parameter_type_code = p_parameter_type_code;
203: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;
204: l_krpv_rec krpv_rec_type;

Line 201: AND okl_k_rate_params_v.khr_id = p_khr_id

197: LAST_UPDATE_LOGIN,
198: CATCHUP_FREQUENCY_CODE
199: FROM Okl_K_Rate_Params_V
200: WHERE okl_k_rate_params_v.effective_from_date = p_effective_from_date
201: AND okl_k_rate_params_v.khr_id = p_khr_id
202: AND okl_k_rate_params_v.parameter_type_code = p_parameter_type_code;
203: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;
204: l_krpv_rec krpv_rec_type;
205: BEGIN

Line 202: AND okl_k_rate_params_v.parameter_type_code = p_parameter_type_code;

198: CATCHUP_FREQUENCY_CODE
199: FROM Okl_K_Rate_Params_V
200: WHERE okl_k_rate_params_v.effective_from_date = p_effective_from_date
201: AND okl_k_rate_params_v.khr_id = p_khr_id
202: AND okl_k_rate_params_v.parameter_type_code = p_parameter_type_code;
203: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;
204: l_krpv_rec krpv_rec_type;
205: BEGIN
206: x_no_data_found := TRUE;

Line 203: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;

199: FROM Okl_K_Rate_Params_V
200: WHERE okl_k_rate_params_v.effective_from_date = p_effective_from_date
201: AND okl_k_rate_params_v.khr_id = p_khr_id
202: AND okl_k_rate_params_v.parameter_type_code = p_parameter_type_code;
203: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;
204: l_krpv_rec krpv_rec_type;
205: BEGIN
206: x_no_data_found := TRUE;
207: -- Get current database values

Line 208: OPEN okl_k_rate_params_v_u1_csr (p_krpv_rec.effective_from_date,

204: l_krpv_rec krpv_rec_type;
205: BEGIN
206: x_no_data_found := TRUE;
207: -- Get current database values
208: OPEN okl_k_rate_params_v_u1_csr (p_krpv_rec.effective_from_date,
209: p_krpv_rec.khr_id,
210: p_krpv_rec.parameter_type_code);
211: FETCH okl_k_rate_params_v_u1_csr INTO
212: l_krpv_rec.khr_id,

Line 211: FETCH okl_k_rate_params_v_u1_csr INTO

207: -- Get current database values
208: OPEN okl_k_rate_params_v_u1_csr (p_krpv_rec.effective_from_date,
209: p_krpv_rec.khr_id,
210: p_krpv_rec.parameter_type_code);
211: FETCH okl_k_rate_params_v_u1_csr INTO
212: l_krpv_rec.khr_id,
213: l_krpv_rec.parameter_type_code,
214: l_krpv_rec.effective_from_date,
215: l_krpv_rec.effective_to_date,

Line 261: x_no_data_found := okl_k_rate_params_v_u1_csr%NOTFOUND;

257: l_krpv_rec.last_updated_by,
258: l_krpv_rec.last_update_date,
259: l_krpv_rec.last_update_login,
260: l_krpv_rec.catchup_frequency_code;
261: x_no_data_found := okl_k_rate_params_v_u1_csr%NOTFOUND;
262: CLOSE okl_k_rate_params_v_u1_csr;
263: RETURN(l_krpv_rec);
264: END get_rec;
265:

Line 262: CLOSE okl_k_rate_params_v_u1_csr;

258: l_krpv_rec.last_update_date,
259: l_krpv_rec.last_update_login,
260: l_krpv_rec.catchup_frequency_code;
261: x_no_data_found := okl_k_rate_params_v_u1_csr%NOTFOUND;
262: CLOSE okl_k_rate_params_v_u1_csr;
263: RETURN(l_krpv_rec);
264: END get_rec;
265:
266: ------------------------------------------------------------------

Line 454: -- FUNCTION null_out_defaults for: OKL_K_RATE_PARAMS_V

450: BEGIN
451: RETURN(get_rec(p_krp_rec, l_row_not_found));
452: END get_rec;
453: ---------------------------------------------------------------------------
454: -- FUNCTION null_out_defaults for: OKL_K_RATE_PARAMS_V
455: ---------------------------------------------------------------------------
456: FUNCTION null_out_defaults (
457: p_krpv_rec IN krpv_rec_type
458: ) RETURN krpv_rec_type IS

Line 896: -- Validate_Attributes for:OKL_K_RATE_PARAMS_V --

892: ---------------------------------------------------------------------------
893: -- FUNCTION Validate_Attributes
894: ---------------------------------------------------------------------------
895: -------------------------------------------------
896: -- Validate_Attributes for:OKL_K_RATE_PARAMS_V --
897: -------------------------------------------------
898: FUNCTION Validate_Attributes (
899: p_krpv_rec IN krpv_rec_type
900: ) RETURN VARCHAR2 IS

Line 952: -- Validate_Attributes for:OKL_K_RATE_PARAMS_V --

948: ---------------------------------------------------------------------------
949: -- FUNCTION Validate_Attributes, Custom, overloaded
950: ---------------------------------------------------------------------------
951: -------------------------------------------------
952: -- Validate_Attributes for:OKL_K_RATE_PARAMS_V --
953: -------------------------------------------------
954: FUNCTION Validate_Attributes (
955: p_krpv_rec IN krpv_rec_type,
956: p_stack_messages IN VARCHAR2

Line 1537: -- Validate Record for:OKL_K_RATE_PARAMS_V --

1533: ---------------------------------------------------------------------------
1534: -- PROCEDURE Validate_Record
1535: ---------------------------------------------------------------------------
1536: ---------------------------------------------
1537: -- Validate Record for:OKL_K_RATE_PARAMS_V --
1538: ---------------------------------------------
1539: FUNCTION Validate_Record (
1540: p_krpv_rec IN krpv_rec_type,
1541: p_db_krpv_rec IN krpv_rec_type

Line 4048: -- validate_row for:OKL_K_RATE_PARAMS_V --

4044: ---------------------------------------------------------------------------
4045: -- PROCEDURE validate_row
4046: ---------------------------------------------------------------------------
4047: ------------------------------------------
4048: -- validate_row for:OKL_K_RATE_PARAMS_V --
4049: ------------------------------------------
4050: PROCEDURE validate_row(
4051: p_api_version IN NUMBER,
4052: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 4125: -- PL/SQL TBL validate_row for:OKL_K_RATE_PARAMS_V --

4121: '_PVT'
4122: );
4123: END validate_row;
4124: -----------------------------------------------------
4125: -- PL/SQL TBL validate_row for:OKL_K_RATE_PARAMS_V --
4126: -----------------------------------------------------
4127: PROCEDURE validate_row(
4128: p_api_version IN NUMBER,
4129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 4221: -- PL/SQL TBL validate_row for:OKL_K_RATE_PARAMS_V --

4217: );
4218: END validate_row;
4219:
4220: -----------------------------------------------------
4221: -- PL/SQL TBL validate_row for:OKL_K_RATE_PARAMS_V --
4222: -----------------------------------------------------
4223: PROCEDURE validate_row(
4224: p_api_version IN NUMBER,
4225: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 4605: -- insert_row for :OKL_K_RATE_PARAMS_V --

4601: '_PVT'
4602: );
4603: END insert_row;
4604: -----------------------------------------
4605: -- insert_row for :OKL_K_RATE_PARAMS_V --
4606: -----------------------------------------
4607: PROCEDURE insert_row(
4608: p_api_version IN NUMBER,
4609: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 4639: -- Set_Attributes for:OKL_K_RATE_PARAMS_V --

4635: l_krpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
4636: RETURN(l_krpv_rec);
4637: END fill_who_columns;
4638: --------------------------------------------
4639: -- Set_Attributes for:OKL_K_RATE_PARAMS_V --
4640: --------------------------------------------
4641: FUNCTION Set_Attributes (
4642: p_krpv_rec IN krpv_rec_type,
4643: x_krpv_rec OUT NOCOPY krpv_rec_type

Line 5200: -- lock_row for: OKL_K_RATE_PARAMS_V --

5196: '_PVT'
5197: );
5198: END lock_row;
5199: ---------------------------------------
5200: -- lock_row for: OKL_K_RATE_PARAMS_V --
5201: ---------------------------------------
5202: PROCEDURE lock_row(
5203: p_api_version IN NUMBER,
5204: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 5793: -- update_row for:OKL_K_RATE_PARAMS_V --

5789: '_PVT'
5790: );
5791: END update_row;
5792: ----------------------------------------
5793: -- update_row for:OKL_K_RATE_PARAMS_V --
5794: ----------------------------------------
5795: PROCEDURE update_row(
5796: p_api_version IN NUMBER,
5797: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 6041: -- Set_Attributes for:OKL_K_RATE_PARAMS_V --

6037: END IF;
6038: RETURN(l_return_status);
6039: END populate_new_record;
6040: --------------------------------------------
6041: -- Set_Attributes for:OKL_K_RATE_PARAMS_V --
6042: --------------------------------------------
6043: FUNCTION Set_Attributes (
6044: p_krpv_rec IN krpv_rec_type,
6045: x_krpv_rec OUT NOCOPY krpv_rec_type

Line 6399: -- delete_row for:OKL_K_RATE_PARAMS_V --

6395: '_PVT'
6396: );
6397: END delete_row;
6398: ----------------------------------------
6399: -- delete_row for:OKL_K_RATE_PARAMS_V --
6400: ----------------------------------------
6401: PROCEDURE delete_row(
6402: p_api_version IN NUMBER,
6403: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 6481: -- PL/SQL TBL delete_row for:OKL_K_RATE_PARAMS_V --

6477: '_PVT'
6478: );
6479: END delete_row;
6480: ---------------------------------------------------
6481: -- PL/SQL TBL delete_row for:OKL_K_RATE_PARAMS_V --
6482: ---------------------------------------------------
6483: PROCEDURE delete_row(
6484: p_api_version IN NUMBER,
6485: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 6577: -- PL/SQL TBL delete_row for:OKL_K_RATE_PARAMS_V --

6573: );
6574: END delete_row;
6575:
6576: ---------------------------------------------------
6577: -- PL/SQL TBL delete_row for:OKL_K_RATE_PARAMS_V --
6578: ---------------------------------------------------
6579: PROCEDURE delete_row(
6580: p_api_version IN NUMBER,
6581: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,