DBA Data[Home] [Help]

APPS.OKL_ASD_PVT dependencies on OKL_TXD_ASSETS_V

Line 290: CURSOR c_target_kle_id_validate(p_id OKL_TXD_ASSETS_V.TARGET_KLE_ID%TYPE) is

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

Line 1016: -- FUNCTION get_rec for: OKL_TXD_ASSETS_V

1012: BEGIN
1013: RETURN(get_rec(p_okl_txd_assets_tl_rec, l_row_notfound));
1014: END get_rec;
1015: ---------------------------------------------------------------------------
1016: -- FUNCTION get_rec for: OKL_TXD_ASSETS_V
1017: ---------------------------------------------------------------------------
1018: FUNCTION get_rec (
1019: p_asdv_rec IN asdv_rec_type,
1020: x_no_data_found OUT NOCOPY BOOLEAN

Line 1063: FROM Okl_Txd_Assets_V txd

1059: creation_date,
1060: last_updated_by,
1061: last_update_date,
1062: last_update_login
1063: FROM Okl_Txd_Assets_V txd
1064: WHERE txd.id = p_id;
1065: l_okl_asdv_pk okl_asdv_pk_csr%ROWTYPE;
1066: l_asdv_rec asdv_rec_type;
1067: BEGIN

Line 1126: -- FUNCTION null_out_defaults for: OKL_TXD_ASSETS_V --

1122: RETURN(get_rec(p_asdv_rec, l_row_notfound));
1123: END get_rec;
1124:
1125: ------------------------------------------------------
1126: -- FUNCTION null_out_defaults for: OKL_TXD_ASSETS_V --
1127: ------------------------------------------------------
1128: FUNCTION null_out_defaults (
1129: p_asdv_rec IN asdv_rec_type
1130: ) RETURN asdv_rec_type IS

Line 1251: -- Validate_Attributes for:OKL_TXD_ASSETS_V --

1247: ---------------------------------------------------------------------------
1248: -- PROCEDURE Validate_Attributes
1249: ---------------------------------------------------------------------------
1250: ----------------------------------------------
1251: -- Validate_Attributes for:OKL_TXD_ASSETS_V --
1252: ----------------------------------------------
1253: FUNCTION Validate_Attributes (
1254: p_asdv_rec IN asdv_rec_type
1255: ) RETURN VARCHAR2 IS

Line 1361: -- Validate_Record for:OKL_TXD_ASSETS_V --

1357: ---------------------------------------------------------------------------
1358: -- PROCEDURE Validate_Record
1359: ---------------------------------------------------------------------------
1360: ------------------------------------------
1361: -- Validate_Record for:OKL_TXD_ASSETS_V --
1362: ------------------------------------------
1363: FUNCTION Validate_Record (
1364: p_asdv_rec IN asdv_rec_type
1365: ) RETURN VARCHAR2 IS

Line 1520: -- validate_row for:OKL_TXD_ASSETS_V --

1516: ---------------------------------------------------------------------------
1517: -- PROCEDURE validate_row
1518: ---------------------------------------------------------------------------
1519: ---------------------------------------
1520: -- validate_row for:OKL_TXD_ASSETS_V --
1521: ---------------------------------------
1522: PROCEDURE validate_row(
1523: p_api_version IN NUMBER,
1524: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1957: -- insert_row for:OKL_TXD_ASSETS_V --

1953: '_PVT'
1954: );
1955: END insert_row;
1956: -------------------------------------
1957: -- insert_row for:OKL_TXD_ASSETS_V --
1958: -------------------------------------
1959: PROCEDURE insert_row(
1960: p_api_version IN NUMBER,
1961: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1994: -- Set_Attributes for:OKL_TXD_ASSETS_V --

1990: l_asdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1991: RETURN(l_asdv_rec);
1992: END fill_who_columns;
1993: -----------------------------------------
1994: -- Set_Attributes for:OKL_TXD_ASSETS_V --
1995: -----------------------------------------
1996: FUNCTION Set_Attributes (
1997: p_asdv_rec IN asdv_rec_type,
1998: x_asdv_rec OUT NOCOPY asdv_rec_type

Line 2423: -- lock_row for:OKL_TXD_ASSETS_V --

2419: '_PVT'
2420: );
2421: END lock_row;
2422: -----------------------------------
2423: -- lock_row for:OKL_TXD_ASSETS_V --
2424: -----------------------------------
2425: PROCEDURE lock_row(
2426: p_api_version IN NUMBER,
2427: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3094: -- update_row for:OKL_TXD_ASSETS_V --

3090: '_PVT'
3091: );
3092: END update_row;
3093: -------------------------------------
3094: -- update_row for:OKL_TXD_ASSETS_V --
3095: -------------------------------------
3096: PROCEDURE update_row(
3097: p_api_version IN NUMBER,
3098: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3322: -- Set_Attributes for:OKL_TXD_ASSETS_V --

3318: -- Multi Currency Change
3319: RETURN(l_return_status);
3320: END populate_new_record;
3321: -----------------------------------------
3322: -- Set_Attributes for:OKL_TXD_ASSETS_V --
3323: -----------------------------------------
3324: FUNCTION Set_Attributes (
3325: p_asdv_rec IN asdv_rec_type,
3326: x_asdv_rec OUT NOCOPY asdv_rec_type

Line 3709: -- delete_row for:OKL_TXD_ASSETS_V --

3705: '_PVT'
3706: );
3707: END delete_row;
3708: -------------------------------------
3709: -- delete_row for:OKL_TXD_ASSETS_V --
3710: -------------------------------------
3711: PROCEDURE delete_row(
3712: p_api_version IN NUMBER,
3713: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,