201: BEGIN
202: RETURN(get_rec(p_okl_parameters_tl_rec, l_row_notfound));
203: END get_rec;
204: ---------------------------------------------------------------------------
205: -- FUNCTION get_rec for: OKL_PARAMETERS_V
206: ---------------------------------------------------------------------------
207: FUNCTION get_rec (
208: p_pmrv_rec IN pmrv_rec_type,
209: x_no_data_found OUT NOCOPY BOOLEAN
221: CREATION_DATE,
222: LAST_UPDATED_BY,
223: LAST_UPDATE_DATE,
224: LAST_UPDATE_LOGIN
225: FROM Okl_Parameters_V
226: WHERE okl_parameters_v.id = p_id;
227: l_okl_pmrv_pk okl_pmrv_pk_csr%ROWTYPE;
228: l_pmrv_rec pmrv_rec_type;
229: BEGIN
222: LAST_UPDATED_BY,
223: LAST_UPDATE_DATE,
224: LAST_UPDATE_LOGIN
225: FROM Okl_Parameters_V
226: WHERE okl_parameters_v.id = p_id;
227: l_okl_pmrv_pk okl_pmrv_pk_csr%ROWTYPE;
228: l_pmrv_rec pmrv_rec_type;
229: BEGIN
230: x_no_data_found := TRUE;
256: RETURN(get_rec(p_pmrv_rec, l_row_notfound));
257: END get_rec;
258:
259: ------------------------------------------------------
260: -- FUNCTION null_out_defaults for: OKL_PARAMETERS_V --
261: ------------------------------------------------------
262: FUNCTION null_out_defaults (
263: p_pmrv_rec IN pmrv_rec_type
264: ) RETURN pmrv_rec_type IS
304: ---------------------------------------------------------------------------
305: -- PROCEDURE Validate_Attributes
306: ---------------------------------------------------------------------------
307: ----------------------------------------------
308: -- Validate_Attributes for:OKL_PARAMETERS_V --
309: ----------------------------------------------
310: FUNCTION Validate_Attributes (
311: p_pmrv_rec IN pmrv_rec_type
312: ) RETURN VARCHAR2 IS
344: ---------------------------------------------------------------------------
345: -- PROCEDURE Validate_Record
346: ---------------------------------------------------------------------------
347: ------------------------------------------
348: -- Validate_Record for:OKL_PARAMETERS_V --
349: ------------------------------------------
350: FUNCTION Validate_Record (
351: p_pmrv_rec IN pmrv_rec_type
352: ) RETURN VARCHAR2 IS
847: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
848: l_unq_tbl OKC_UTIL.unq_tbl_type;
849: l_dummy VARCHAR2(1);
850: l_row_found Boolean := False;
851: CURSOR c1( p_id okl_parameters_v.id%TYPE,
852: p_name okl_parameters_v.name%TYPE ) is
853: SELECT 1
854: FROM okl_parameters_v
855: WHERE id = p_id
848: l_unq_tbl OKC_UTIL.unq_tbl_type;
849: l_dummy VARCHAR2(1);
850: l_row_found Boolean := False;
851: CURSOR c1( p_id okl_parameters_v.id%TYPE,
852: p_name okl_parameters_v.name%TYPE ) is
853: SELECT 1
854: FROM okl_parameters_v
855: WHERE id = p_id
856: AND name = p_name
850: l_row_found Boolean := False;
851: CURSOR c1( p_id okl_parameters_v.id%TYPE,
852: p_name okl_parameters_v.name%TYPE ) is
853: SELECT 1
854: FROM okl_parameters_v
855: WHERE id = p_id
856: AND name = p_name
857: AND id <> nvl( p_pmrv_rec.id, -9999 );
858:
866: l_row_found := c1%FOUND;
867: CLOSE c1;
868: /* RPOONUGA001: Changed the token name from G_TABLE_NAME to G_TABLE_TOKEN */
869: IF l_row_found then
870: OKC_API.set_message( G_APP_NAME, G_UNQS, G_TABLE_TOKEN, 'Okl_Parameters_V' );
871: x_return_status := OKC_API.G_RET_STS_ERROR;
872: END IF;
873:
874: EXCEPTION
1022: ---------------------------------------------------------------------------
1023: -- PROCEDURE validate_row
1024: ---------------------------------------------------------------------------
1025: ---------------------------------------
1026: -- validate_row for:OKL_PARAMETERS_V --
1027: ---------------------------------------
1028: PROCEDURE validate_row(
1029: p_api_version IN NUMBER,
1030: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1398: '_PVT'
1399: );
1400: END insert_row;
1401: -------------------------------------
1402: -- insert_row for:OKL_PARAMETERS_V --
1403: -------------------------------------
1404: PROCEDURE insert_row(
1405: p_api_version IN NUMBER,
1406: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1434: l_pmrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1435: RETURN(l_pmrv_rec);
1436: END fill_who_columns;
1437: -----------------------------------------
1438: -- Set_Attributes for:OKL_PARAMETERS_V --
1439: -----------------------------------------
1440: FUNCTION Set_Attributes (
1441: p_pmrv_rec IN pmrv_rec_type,
1442: x_pmrv_rec OUT NOCOPY pmrv_rec_type
1833: '_PVT'
1834: );
1835: END lock_row;
1836: -----------------------------------
1837: -- lock_row for:OKL_PARAMETERS_V --
1838: -----------------------------------
1839: PROCEDURE lock_row(
1840: p_api_version IN NUMBER,
1841: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2335: '_PVT'
2336: );
2337: END update_row;
2338: -------------------------------------
2339: -- update_row for:OKL_PARAMETERS_V --
2340: -------------------------------------
2341: PROCEDURE update_row(
2342: p_api_version IN NUMBER,
2343: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2436: END IF;
2437: RETURN(l_return_status);
2438: END populate_new_record;
2439: -----------------------------------------
2440: -- Set_Attributes for:OKL_PARAMETERS_V --
2441: -----------------------------------------
2442: FUNCTION Set_Attributes (
2443: p_pmrv_rec IN pmrv_rec_type,
2444: x_pmrv_rec OUT NOCOPY pmrv_rec_type
2794: '_PVT'
2795: );
2796: END delete_row;
2797: -------------------------------------
2798: -- delete_row for:OKL_PARAMETERS_V --
2799: -------------------------------------
2800: PROCEDURE delete_row(
2801: p_api_version IN NUMBER,
2802: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,