116: BEGIN
117: RETURN(get_rec(p_opt_rec, l_row_notfound));
118: END get_rec;
119: ---------------------------------------------------------------------------
120: -- FUNCTION get_rec for: OKL_OPTIONS_V
121: ---------------------------------------------------------------------------
122: FUNCTION get_rec (
123: p_optv_rec IN optv_rec_type,
124: x_no_data_found OUT NOCOPY BOOLEAN
151: CREATION_DATE,
152: LAST_UPDATED_BY,
153: LAST_UPDATE_DATE,
154: LAST_UPDATE_LOGIN
155: FROM Okl_Options_V
156: WHERE okl_options_v.id = p_id;
157: l_okl_optv_pk okl_optv_pk_csr%ROWTYPE;
158: l_optv_rec optv_rec_type;
159: BEGIN
152: LAST_UPDATED_BY,
153: LAST_UPDATE_DATE,
154: LAST_UPDATE_LOGIN
155: FROM Okl_Options_V
156: WHERE okl_options_v.id = p_id;
157: l_okl_optv_pk okl_optv_pk_csr%ROWTYPE;
158: l_optv_rec optv_rec_type;
159: BEGIN
160: x_no_data_found := TRUE;
201: RETURN(get_rec(p_optv_rec, l_row_notfound));
202: END get_rec;
203:
204: ---------------------------------------------------
205: -- FUNCTION null_out_defaults for: OKL_OPTIONS_V --
206: ---------------------------------------------------
207: FUNCTION null_out_defaults (
208: p_optv_rec IN optv_rec_type
209: ) RETURN optv_rec_type IS
292: ---------------------------------------------------------------------------
293: -- PROCEDURE Validate_Attributes
294: ---------------------------------------------------------------------------
295: -------------------------------------------
296: -- Validate_Attributes for:OKL_OPTIONS_V --
297: -------------------------------------------
298: ----------------TCHGS NEW CHANGES BEGIN --------------------------
299: ---------------------------------------------------------------------------
300: -- PROCEDURE Validate_Id
516: p_optv_rec IN optv_rec_type,
517: x_return_status OUT NOCOPY VARCHAR2
518: ) IS
519:
520: CURSOR okl_options_unique (p_unique OKL_OPTIONS_V.NAME%TYPE) IS
521: SELECT '1'
522: FROM OKL_OPTIONS_V
523: WHERE OKL_OPTIONS_V.NAME = p_unique AND
524: OKL_OPTIONS_V.ID <> NVL(p_optv_rec.id,-9999);
518: ) IS
519:
520: CURSOR okl_options_unique (p_unique OKL_OPTIONS_V.NAME%TYPE) IS
521: SELECT '1'
522: FROM OKL_OPTIONS_V
523: WHERE OKL_OPTIONS_V.NAME = p_unique AND
524: OKL_OPTIONS_V.ID <> NVL(p_optv_rec.id,-9999);
525:
526: l_unique_key OKL_OPTIONS_V.NAME%TYPE;
519:
520: CURSOR okl_options_unique (p_unique OKL_OPTIONS_V.NAME%TYPE) IS
521: SELECT '1'
522: FROM OKL_OPTIONS_V
523: WHERE OKL_OPTIONS_V.NAME = p_unique AND
524: OKL_OPTIONS_V.ID <> NVL(p_optv_rec.id,-9999);
525:
526: l_unique_key OKL_OPTIONS_V.NAME%TYPE;
527:
520: CURSOR okl_options_unique (p_unique OKL_OPTIONS_V.NAME%TYPE) IS
521: SELECT '1'
522: FROM OKL_OPTIONS_V
523: WHERE OKL_OPTIONS_V.NAME = p_unique AND
524: OKL_OPTIONS_V.ID <> NVL(p_optv_rec.id,-9999);
525:
526: l_unique_key OKL_OPTIONS_V.NAME%TYPE;
527:
528:
522: FROM OKL_OPTIONS_V
523: WHERE OKL_OPTIONS_V.NAME = p_unique AND
524: OKL_OPTIONS_V.ID <> NVL(p_optv_rec.id,-9999);
525:
526: l_unique_key OKL_OPTIONS_V.NAME%TYPE;
527:
528:
529: BEGIN
530: OPEN okl_options_unique (p_optv_rec.name);
529: BEGIN
530: OPEN okl_options_unique (p_optv_rec.name);
531: FETCH okl_options_unique INTO l_unique_key;
532: IF okl_options_unique%FOUND THEN
533: OKC_API.set_message('OKL','OKL_NOT_UNIQUE', 'OKL_TABLE_NAME','Okl_Options_V');
534: x_return_status := OKC_API.G_RET_STS_ERROR;
535: ELSE
536: x_return_status := OKC_API.G_RET_STS_SUCCESS;
537: END IF;
739: ---------------------------------------------------------------------------
740: -- PROCEDURE Validate_Record
741: ---------------------------------------------------------------------------
742: ---------------------------------------
743: -- Validate_Record for:OKL_OPTIONS_V --
744: ---------------------------------------
745: -- FUNCTION Validate_Record (
746: -- p_optv_rec IN optv_rec_type
747: -- ) RETURN VARCHAR2 IS
825: ---------------------------------------------------------------------------
826: -- PROCEDURE validate_row
827: ---------------------------------------------------------------------------
828: ------------------------------------
829: -- validate_row for:OKL_OPTIONS_V --
830: ------------------------------------
831: PROCEDURE validate_row(
832: p_api_version IN NUMBER,
833: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1117: '_PVT'
1118: );
1119: END insert_row;
1120: ----------------------------------
1121: -- insert_row for:OKL_OPTIONS_V --
1122: ----------------------------------
1123: PROCEDURE insert_row(
1124: p_api_version IN NUMBER,
1125: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1151: l_optv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1152: RETURN(l_optv_rec);
1153: END fill_who_columns;
1154: --------------------------------------
1155: -- Set_Attributes for:OKL_OPTIONS_V --
1156: --------------------------------------
1157: FUNCTION Set_Attributes (
1158: p_optv_rec IN optv_rec_type,
1159: x_optv_rec OUT NOCOPY optv_rec_type
1446: '_PVT'
1447: );
1448: END lock_row;
1449: --------------------------------
1450: -- lock_row for:OKL_OPTIONS_V --
1451: --------------------------------
1452: PROCEDURE lock_row(
1453: p_api_version IN NUMBER,
1454: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1848: '_PVT'
1849: );
1850: END update_row;
1851: ----------------------------------
1852: -- update_row for:OKL_OPTIONS_V --
1853: ----------------------------------
1854: PROCEDURE update_row(
1855: p_api_version IN NUMBER,
1856: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2007: END IF;
2008: RETURN(l_return_status);
2009: END populate_new_record;
2010: --------------------------------------
2011: -- Set_Attributes for:OKL_OPTIONS_V --
2012: --------------------------------------
2013: FUNCTION Set_Attributes (
2014: p_optv_rec IN optv_rec_type,
2015: x_optv_rec OUT NOCOPY optv_rec_type
2260: '_PVT'
2261: );
2262: END delete_row;
2263: ----------------------------------
2264: -- delete_row for:OKL_OPTIONS_V --
2265: ----------------------------------
2266: PROCEDURE delete_row(
2267: p_api_version IN NUMBER,
2268: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,