DBA Data[Home] [Help]

APPS.OKL_TAL_PVT dependencies on OKL_TXL_ASSETS_V

Line 964: CURSOR c_dnz_khr_id_validate(p_dnz_khr_id OKL_TXL_ASSETS_V.DNZ_KHR_ID%TYPE) is

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

Line 2066: -- FUNCTION get_rec for: OKL_TXL_ASSETS_V

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

Line 2162: FROM Okl_Txl_Assets_V

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

Line 2163: WHERE okl_txl_assets_v.id = p_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
2167: x_no_data_found := TRUE;

Line 2275: -- FUNCTION null_out_defaults for: OKL_TXL_ASSETS_V --

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

Line 2543: -- Validate_Attributes for:OKL_TXL_ASSETS_V --

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

Line 2743: -- Validate_Record for:OKL_TXL_ASSETS_V --

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

Line 3016: -- validate_row for:OKL_TXL_ASSETS_V --

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,

Line 3537: -- insert_row for:OKL_TXL_ASSETS_V --

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,

Line 3574: -- Set_Attributes for:OKL_TXL_ASSETS_V --

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

Line 4010: -- lock_row for:OKL_TXL_ASSETS_V --

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,

Line 4864: -- update_row for:OKL_TXL_ASSETS_V --

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,

Line 5256: -- Set_Attributes for:OKL_TXL_ASSETS_V --

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

Line 5644: -- delete_row for:OKL_TXL_ASSETS_V --

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,