84: BEGIN
85: RETURN(get_rec(p_pov_rec, l_row_notfound));
86: END get_rec;
87: ---------------------------------------------------------------------------
88: -- FUNCTION get_rec for: OKL_PDT_OPT_VALS_V
89: ---------------------------------------------------------------------------
90: FUNCTION get_rec (
91: p_povv_rec IN povv_rec_type,
92: x_no_data_found OUT NOCOPY BOOLEAN
103: CREATION_DATE,
104: LAST_UPDATED_BY,
105: LAST_UPDATE_DATE,
106: LAST_UPDATE_LOGIN
107: FROM Okl_Pdt_Opt_Vals_V
108: WHERE okl_pdt_opt_vals_v.id = p_id;
109: l_okl_povv_pk okl_povv_pk_csr%ROWTYPE;
110: l_povv_rec povv_rec_type;
111: BEGIN
104: LAST_UPDATED_BY,
105: LAST_UPDATE_DATE,
106: LAST_UPDATE_LOGIN
107: FROM Okl_Pdt_Opt_Vals_V
108: WHERE okl_pdt_opt_vals_v.id = p_id;
109: l_okl_povv_pk okl_povv_pk_csr%ROWTYPE;
110: l_povv_rec povv_rec_type;
111: BEGIN
112: x_no_data_found := TRUE;
137: RETURN(get_rec(p_povv_rec, l_row_notfound));
138: END get_rec;
139:
140: --------------------------------------------------------
141: -- FUNCTION null_out_defaults for: OKL_PDT_OPT_VALS_V --
142: --------------------------------------------------------
143: FUNCTION null_out_defaults (
144: p_povv_rec IN povv_rec_type
145: ) RETURN povv_rec_type IS
180: ---------------------------------------------------------------------------
181: -- PROCEDURE Validate_Attributes
182: ---------------------------------------------------------------------------
183: ------------------------------------------------
184: -- Validate_Attributes for:OKL_PDT_OPT_VALS_V --
185: ------------------------------------------------
186:
187: ----------------TCHGS NEW CHANGS BEGIN --------------------------
188:
284: SELECT ID
285: FROM OKL_OPT_VALUES_V
286: WHERE OKL_OPT_VALUES_V.ID = p_foreign;
287:
288: l_foreign_key OKL_PDT_OPT_VALS_V.OVE_ID%TYPE;
289:
290:
291: BEGIN
292: -- initialize return status
348: SELECT ID
349: FROM OKL_PDT_OPTS_V
350: WHERE OKL_PDT_OPTS_V.ID = p_foreign;
351:
352: l_foreign_key OKL_PDT_OPT_VALS_V.PON_ID%TYPE;
353:
354:
355: BEGIN
356: -- initialize return status
498: p_povv_rec IN povv_rec_type,
499: x_return_status OUT NOCOPY VARCHAR2
500: ) IS
501:
502: CURSOR okl_pdt_opt_vals_unique (p_unique1 OKL_PDT_OPT_VALS_V.OVE_ID%TYPE, p_unique2 OKL_PDT_OPT_VALS_V.PON_ID%TYPE) IS
503: SELECT '1'
504: FROM OKL_PDT_OPT_VALS_V
505: WHERE OKL_PDT_OPT_VALS_V.OVE_ID = p_unique1 AND
506: OKL_PDT_OPT_VALS_V.PON_ID = p_unique2 AND
500: ) IS
501:
502: CURSOR okl_pdt_opt_vals_unique (p_unique1 OKL_PDT_OPT_VALS_V.OVE_ID%TYPE, p_unique2 OKL_PDT_OPT_VALS_V.PON_ID%TYPE) IS
503: SELECT '1'
504: FROM OKL_PDT_OPT_VALS_V
505: WHERE OKL_PDT_OPT_VALS_V.OVE_ID = p_unique1 AND
506: OKL_PDT_OPT_VALS_V.PON_ID = p_unique2 AND
507: OKL_PDT_OPT_VALS_V.ID <> nvl(p_povv_rec.id,-9999);
508:
501:
502: CURSOR okl_pdt_opt_vals_unique (p_unique1 OKL_PDT_OPT_VALS_V.OVE_ID%TYPE, p_unique2 OKL_PDT_OPT_VALS_V.PON_ID%TYPE) IS
503: SELECT '1'
504: FROM OKL_PDT_OPT_VALS_V
505: WHERE OKL_PDT_OPT_VALS_V.OVE_ID = p_unique1 AND
506: OKL_PDT_OPT_VALS_V.PON_ID = p_unique2 AND
507: OKL_PDT_OPT_VALS_V.ID <> nvl(p_povv_rec.id,-9999);
508:
509: l_unique_key VARCHAR2(1);
502: CURSOR okl_pdt_opt_vals_unique (p_unique1 OKL_PDT_OPT_VALS_V.OVE_ID%TYPE, p_unique2 OKL_PDT_OPT_VALS_V.PON_ID%TYPE) IS
503: SELECT '1'
504: FROM OKL_PDT_OPT_VALS_V
505: WHERE OKL_PDT_OPT_VALS_V.OVE_ID = p_unique1 AND
506: OKL_PDT_OPT_VALS_V.PON_ID = p_unique2 AND
507: OKL_PDT_OPT_VALS_V.ID <> nvl(p_povv_rec.id,-9999);
508:
509: l_unique_key VARCHAR2(1);
510:
503: SELECT '1'
504: FROM OKL_PDT_OPT_VALS_V
505: WHERE OKL_PDT_OPT_VALS_V.OVE_ID = p_unique1 AND
506: OKL_PDT_OPT_VALS_V.PON_ID = p_unique2 AND
507: OKL_PDT_OPT_VALS_V.ID <> nvl(p_povv_rec.id,-9999);
508:
509: l_unique_key VARCHAR2(1);
510:
511: BEGIN
742: ---------------------------------------------------------------------------
743: -- PROCEDURE Validate_Record
744: ---------------------------------------------------------------------------
745: --------------------------------------------
746: -- Validate_Record for:OKL_PDT_OPT_VALS_V --
747: --------------------------------------------
748: -- FUNCTION Validate_Record (
749: -- p_povv_rec IN povv_rec_type
750: -- ) RETURN VARCHAR2 IS
796: ---------------------------------------------------------------------------
797: -- PROCEDURE validate_row
798: ---------------------------------------------------------------------------
799: -----------------------------------------
800: -- validate_row for:OKL_PDT_OPT_VALS_V --
801: -----------------------------------------
802: PROCEDURE validate_row(
803: p_api_version IN NUMBER,
804: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1056: '_PVT'
1057: );
1058: END insert_row;
1059: ---------------------------------------
1060: -- insert_row for:OKL_PDT_OPT_VALS_V --
1061: ---------------------------------------
1062: PROCEDURE insert_row(
1063: p_api_version IN NUMBER,
1064: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1090: l_povv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1091: RETURN(l_povv_rec);
1092: END fill_who_columns;
1093: -------------------------------------------
1094: -- Set_Attributes for:OKL_PDT_OPT_VALS_V --
1095: -------------------------------------------
1096: FUNCTION Set_Attributes (
1097: p_povv_rec IN povv_rec_type,
1098: x_povv_rec OUT NOCOPY povv_rec_type
1385: '_PVT'
1386: );
1387: END lock_row;
1388: -------------------------------------
1389: -- lock_row for:OKL_PDT_OPT_VALS_V --
1390: -------------------------------------
1391: PROCEDURE lock_row(
1392: p_api_version IN NUMBER,
1393: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1707: '_PVT'
1708: );
1709: END update_row;
1710: ---------------------------------------
1711: -- update_row for:OKL_PDT_OPT_VALS_V --
1712: ---------------------------------------
1713: PROCEDURE update_row(
1714: p_api_version IN NUMBER,
1715: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1802: END IF;
1803: RETURN(l_return_status);
1804: END populate_new_record;
1805: -------------------------------------------
1806: -- Set_Attributes for:OKL_PDT_OPT_VALS_V --
1807: -------------------------------------------
1808: FUNCTION Set_Attributes (
1809: p_povv_rec IN povv_rec_type,
1810: x_povv_rec OUT NOCOPY povv_rec_type
2055: '_PVT'
2056: );
2057: END delete_row;
2058: ---------------------------------------
2059: -- delete_row for:OKL_PDT_OPT_VALS_V --
2060: ---------------------------------------
2061: PROCEDURE delete_row(
2062: p_api_version IN NUMBER,
2063: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,