960: PROCEDURE validate_dnz_khr_id(x_return_status OUT NOCOPY VARCHAR2,
961: p_talv_rec IN talv_rec_type) IS
962:
963: ln_dummy number := 0;
964: CURSOR c_dnz_khr_id_validate(p_dnz_khr_id OKL_TXL_ASSETS_V.DNZ_KHR_ID%TYPE) is
965: SELECT 1
966: FROM DUAL
967: WHERE EXISTS (SELECT '1'
968: FROM OKC_K_HEADERS_B chrv
2062: BEGIN
2063: RETURN(get_rec(p_okl_txl_assets_tl_rec, l_row_notfound));
2064: END get_rec;
2065: ---------------------------------------------------------------------------
2066: -- FUNCTION get_rec for: OKL_TXL_ASSETS_V
2067: ---------------------------------------------------------------------------
2068: FUNCTION get_rec (
2069: p_talv_rec IN talv_rec_type,
2070: x_no_data_found OUT NOCOPY BOOLEAN
2158: RESIDUAL_SHR_PARTY_ID,
2159: RESIDUAL_SHR_AMOUNT,
2160: RETIREMENT_ID
2161: -- VRS Project - END
2162: FROM Okl_Txl_Assets_V
2163: WHERE okl_txl_assets_v.id = p_id;
2164: l_okl_talv_pk okl_talv_pk_csr%ROWTYPE;
2165: l_talv_rec talv_rec_type;
2166: BEGIN
2159: RESIDUAL_SHR_AMOUNT,
2160: RETIREMENT_ID
2161: -- VRS Project - END
2162: FROM Okl_Txl_Assets_V
2163: WHERE okl_txl_assets_v.id = p_id;
2164: l_okl_talv_pk okl_talv_pk_csr%ROWTYPE;
2165: l_talv_rec talv_rec_type;
2166: BEGIN
2167: x_no_data_found := TRUE;
2271: RETURN(get_rec(p_talv_rec, l_row_notfound));
2272: END get_rec;
2273:
2274: ------------------------------------------------------
2275: -- FUNCTION null_out_defaults for: OKL_TXL_ASSETS_V --
2276: ------------------------------------------------------
2277: FUNCTION null_out_defaults (
2278: p_talv_rec IN talv_rec_type
2279: ) RETURN talv_rec_type IS
2539: ---------------------------------------------------------------------------
2540: -- PROCEDURE Validate_Attributes
2541: ---------------------------------------------------------------------------
2542: ----------------------------------------------
2543: -- Validate_Attributes for:OKL_TXL_ASSETS_V --
2544: ----------------------------------------------
2545: FUNCTION Validate_Attributes (
2546: p_talv_rec IN talv_rec_type
2547: ) RETURN VARCHAR2 IS
2739: ---------------------------------------------------------------------------
2740: -- PROCEDURE Validate_Record
2741: ---------------------------------------------------------------------------
2742: ------------------------------------------
2743: -- Validate_Record for:OKL_TXL_ASSETS_V --
2744: ------------------------------------------
2745: FUNCTION Validate_Record (
2746: p_talv_rec IN talv_rec_type
2747: ) RETURN VARCHAR2 IS
3012: ---------------------------------------------------------------------------
3013: -- PROCEDURE validate_row
3014: ---------------------------------------------------------------------------
3015: ---------------------------------------
3016: -- validate_row for:OKL_TXL_ASSETS_V --
3017: ---------------------------------------
3018: PROCEDURE validate_row(
3019: p_api_version IN NUMBER,
3020: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3533: '_PVT'
3534: );
3535: END insert_row;
3536: -------------------------------------
3537: -- insert_row for:OKL_TXL_ASSETS_V --
3538: -------------------------------------
3539: PROCEDURE insert_row(
3540: p_api_version IN NUMBER,
3541: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3570: l_talv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3571: RETURN(l_talv_rec);
3572: END fill_who_columns;
3573: -----------------------------------------
3574: -- Set_Attributes for:OKL_TXL_ASSETS_V --
3575: -----------------------------------------
3576: FUNCTION Set_Attributes (
3577: p_talv_rec IN talv_rec_type,
3578: x_talv_rec OUT NOCOPY talv_rec_type
4006: '_PVT'
4007: );
4008: END lock_row;
4009: -----------------------------------
4010: -- lock_row for:OKL_TXL_ASSETS_V --
4011: -----------------------------------
4012: PROCEDURE lock_row(
4013: p_api_version IN NUMBER,
4014: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4860: '_PVT'
4861: );
4862: END update_row;
4863: -------------------------------------
4864: -- update_row for:OKL_TXL_ASSETS_V --
4865: -------------------------------------
4866: PROCEDURE update_row(
4867: p_api_version IN NUMBER,
4868: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5252:
5253: RETURN(l_return_status);
5254: END populate_new_record;
5255: -----------------------------------------
5256: -- Set_Attributes for:OKL_TXL_ASSETS_V --
5257: -----------------------------------------
5258: FUNCTION Set_Attributes (
5259: p_talv_rec IN talv_rec_type,
5260: x_talv_rec OUT NOCOPY talv_rec_type
5640: '_PVT'
5641: );
5642: END delete_row;
5643: -------------------------------------
5644: -- delete_row for:OKL_TXL_ASSETS_V --
5645: -------------------------------------
5646: PROCEDURE delete_row(
5647: p_api_version IN NUMBER,
5648: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,