[Home] [Help]
286:
287: PROCEDURE validate_target_kle_id(x_return_status OUT NOCOPY VARCHAR2,
288: p_asdv_rec IN asdv_rec_type) IS
289: ln_dummy number := 0;
290: CURSOR c_target_kle_id_validate(p_id OKL_TXD_ASSETS_V.TARGET_KLE_ID%TYPE) is
291: SELECT 1
292: FROM DUAL
293: WHERE EXISTS (SELECT '1'
294: FROM OKL_K_LINES_V kle
994: BEGIN
995: RETURN(get_rec(p_okl_txd_assets_tl_rec, l_row_notfound));
996: END get_rec;
997: ---------------------------------------------------------------------------
998: -- FUNCTION get_rec for: OKL_TXD_ASSETS_V
999: ---------------------------------------------------------------------------
1000: FUNCTION get_rec (
1001: p_asdv_rec IN asdv_rec_type,
1002: x_no_data_found OUT NOCOPY BOOLEAN
1041: creation_date,
1042: last_updated_by,
1043: last_update_date,
1044: last_update_login
1045: FROM Okl_Txd_Assets_V txd
1046: WHERE txd.id = p_id;
1047: l_okl_asdv_pk okl_asdv_pk_csr%ROWTYPE;
1048: l_asdv_rec asdv_rec_type;
1049: BEGIN
1104: RETURN(get_rec(p_asdv_rec, l_row_notfound));
1105: END get_rec;
1106:
1107: ------------------------------------------------------
1108: -- FUNCTION null_out_defaults for: OKL_TXD_ASSETS_V --
1109: ------------------------------------------------------
1110: FUNCTION null_out_defaults (
1111: p_asdv_rec IN asdv_rec_type
1112: ) RETURN asdv_rec_type IS
1229: ---------------------------------------------------------------------------
1230: -- PROCEDURE Validate_Attributes
1231: ---------------------------------------------------------------------------
1232: ----------------------------------------------
1233: -- Validate_Attributes for:OKL_TXD_ASSETS_V --
1234: ----------------------------------------------
1235: FUNCTION Validate_Attributes (
1236: p_asdv_rec IN asdv_rec_type
1237: ) RETURN VARCHAR2 IS
1339: ---------------------------------------------------------------------------
1340: -- PROCEDURE Validate_Record
1341: ---------------------------------------------------------------------------
1342: ------------------------------------------
1343: -- Validate_Record for:OKL_TXD_ASSETS_V --
1344: ------------------------------------------
1345: FUNCTION Validate_Record (
1346: p_asdv_rec IN asdv_rec_type
1347: ) RETURN VARCHAR2 IS
1498: ---------------------------------------------------------------------------
1499: -- PROCEDURE validate_row
1500: ---------------------------------------------------------------------------
1501: ---------------------------------------
1502: -- validate_row for:OKL_TXD_ASSETS_V --
1503: ---------------------------------------
1504: PROCEDURE validate_row(
1505: p_api_version IN NUMBER,
1506: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1935: '_PVT'
1936: );
1937: END insert_row;
1938: -------------------------------------
1939: -- insert_row for:OKL_TXD_ASSETS_V --
1940: -------------------------------------
1941: PROCEDURE insert_row(
1942: p_api_version IN NUMBER,
1943: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1972: l_asdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1973: RETURN(l_asdv_rec);
1974: END fill_who_columns;
1975: -----------------------------------------
1976: -- Set_Attributes for:OKL_TXD_ASSETS_V --
1977: -----------------------------------------
1978: FUNCTION Set_Attributes (
1979: p_asdv_rec IN asdv_rec_type,
1980: x_asdv_rec OUT NOCOPY asdv_rec_type
2401: '_PVT'
2402: );
2403: END lock_row;
2404: -----------------------------------
2405: -- lock_row for:OKL_TXD_ASSETS_V --
2406: -----------------------------------
2407: PROCEDURE lock_row(
2408: p_api_version IN NUMBER,
2409: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3072: '_PVT'
3073: );
3074: END update_row;
3075: -------------------------------------
3076: -- update_row for:OKL_TXD_ASSETS_V --
3077: -------------------------------------
3078: PROCEDURE update_row(
3079: p_api_version IN NUMBER,
3080: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3300: -- Multi Currency Change
3301: RETURN(l_return_status);
3302: END populate_new_record;
3303: -----------------------------------------
3304: -- Set_Attributes for:OKL_TXD_ASSETS_V --
3305: -----------------------------------------
3306: FUNCTION Set_Attributes (
3307: p_asdv_rec IN asdv_rec_type,
3308: x_asdv_rec OUT NOCOPY asdv_rec_type
3687: '_PVT'
3688: );
3689: END delete_row;
3690: -------------------------------------
3691: -- delete_row for:OKL_TXD_ASSETS_V --
3692: -------------------------------------
3693: PROCEDURE delete_row(
3694: p_api_version IN NUMBER,
3695: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,