DBA Data[Home] [Help]

APPS.OKL_IVE_PVT dependencies on OKL_INDEX_VALUES_V

Line 240: FROM OKL_INDEX_VALUES_V

236: CURSOR ive_csr(v_idx_id NUMBER,
237: v_datetime_valid DATE,
238: v_id NUMBER) IS
239: SELECT '1'
240: FROM OKL_INDEX_VALUES_V
241: WHERE IDX_ID = v_idx_id
242: AND DATETIME_VALID = v_datetime_valid
243: AND ID <> v_id;
244:

Line 371: -- FUNCTION get_rec for: OKL_INDEX_VALUES_V

367: BEGIN
368: RETURN(get_rec(p_ive_rec, l_row_notfound));
369: END get_rec;
370: ---------------------------------------------------------------------------
371: -- FUNCTION get_rec for: OKL_INDEX_VALUES_V
372: ---------------------------------------------------------------------------
373: FUNCTION get_rec (
374: p_ivev_rec IN ivev_rec_type,
375: x_no_data_found OUT NOCOPY BOOLEAN

Line 394: FROM Okl_Index_Values_V

390: CREATION_DATE,
391: LAST_UPDATED_BY,
392: LAST_UPDATE_DATE,
393: LAST_UPDATE_LOGIN
394: FROM Okl_Index_Values_V
395: WHERE okl_index_values_v.id = p_id;
396: l_okl_ivev_pk okl_ivev_pk_csr%ROWTYPE;
397: l_ivev_rec ivev_rec_type;
398: BEGIN

Line 395: WHERE okl_index_values_v.id = p_id;

391: LAST_UPDATED_BY,
392: LAST_UPDATE_DATE,
393: LAST_UPDATE_LOGIN
394: FROM Okl_Index_Values_V
395: WHERE okl_index_values_v.id = p_id;
396: l_okl_ivev_pk okl_ivev_pk_csr%ROWTYPE;
397: l_ivev_rec ivev_rec_type;
398: BEGIN
399: x_no_data_found := TRUE;

Line 432: -- FUNCTION null_out_defaults for: OKL_INDEX_VALUES_V --

428: RETURN(get_rec(p_ivev_rec, l_row_notfound));
429: END get_rec;
430:
431: --------------------------------------------------------
432: -- FUNCTION null_out_defaults for: OKL_INDEX_VALUES_V --
433: --------------------------------------------------------
434: FUNCTION null_out_defaults (
435: p_ivev_rec IN ivev_rec_type
436: ) RETURN ivev_rec_type IS

Line 487: -- Validate_Attributes for:OKL_INDEX_VALUES_V --

483: ---------------------------------------------------------------------------
484: -- PROCEDURE Validate_Attributes
485: ---------------------------------------------------------------------------
486: ------------------------------------------------
487: -- Validate_Attributes for:OKL_INDEX_VALUES_V --
488: ------------------------------------------------
489: FUNCTION Validate_Attributes (
490: p_ivev_rec IN ivev_rec_type
491: ) RETURN VARCHAR2 IS

Line 570: -- Validate_Record for:OKL_INDEX_VALUES_V --

566: ---------------------------------------------------------------------------
567: -- PROCEDURE Validate_Record
568: ---------------------------------------------------------------------------
569: --------------------------------------------
570: -- Validate_Record for:OKL_INDEX_VALUES_V --
571: --------------------------------------------
572: FUNCTION Validate_Record (
573: p_ivev_rec IN ivev_rec_type
574: ) RETURN VARCHAR2 IS

Line 636: -- validate_row for:OKL_INDEX_VALUES_V --

632: ---------------------------------------------------------------------------
633: -- PROCEDURE validate_row
634: ---------------------------------------------------------------------------
635: -----------------------------------------
636: -- validate_row for:OKL_INDEX_VALUES_V --
637: -----------------------------------------
638: PROCEDURE validate_row(
639: p_api_version IN NUMBER,
640: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 903: -- insert_row for:OKL_INDEX_VALUES_V --

899: '_PVT'
900: );
901: END insert_row;
902: ---------------------------------------
903: -- insert_row for:OKL_INDEX_VALUES_V --
904: ---------------------------------------
905: PROCEDURE insert_row(
906: p_api_version IN NUMBER,
907: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 937: -- Set_Attributes for:OKL_INDEX_VALUES_V --

933: l_ivev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
934: RETURN(l_ivev_rec);
935: END fill_who_columns;
936: -------------------------------------------
937: -- Set_Attributes for:OKL_INDEX_VALUES_V --
938: -------------------------------------------
939: FUNCTION Set_Attributes (
940: p_ivev_rec IN ivev_rec_type,
941: x_ivev_rec OUT NOCOPY ivev_rec_type

Line 1241: -- lock_row for:OKL_INDEX_VALUES_V --

1237: '_PVT'
1238: );
1239: END lock_row;
1240: -------------------------------------
1241: -- lock_row for:OKL_INDEX_VALUES_V --
1242: -------------------------------------
1243: PROCEDURE lock_row(
1244: p_api_version IN NUMBER,
1245: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1582: -- update_row for:OKL_INDEX_VALUES_V --

1578: '_PVT'
1579: );
1580: END update_row;
1581: ---------------------------------------
1582: -- update_row for:OKL_INDEX_VALUES_V --
1583: ---------------------------------------
1584: PROCEDURE update_row(
1585: p_api_version IN NUMBER,
1586: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1693: -- Set_Attributes for:OKL_INDEX_VALUES_V --

1689: END IF;
1690: RETURN(l_return_status);
1691: END populate_new_record;
1692: -------------------------------------------
1693: -- Set_Attributes for:OKL_INDEX_VALUES_V --
1694: -------------------------------------------
1695: FUNCTION Set_Attributes (
1696: p_ivev_rec IN ivev_rec_type,
1697: x_ivev_rec OUT NOCOPY ivev_rec_type

Line 1956: -- delete_row for:OKL_INDEX_VALUES_V --

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