APPS.OKL_IDX_PVT dependencies on OKL_INDICES_V

Line 262: CURSOR c_idx(v_name OKL_INDICES_V.NAME%TYPE,

258: l_unq_tbl OKC_UTIL.unq_tbl_type;
259: l_idxv_status VARCHAR2(1);
260: l_row_found Boolean := False;
261:
262: CURSOR c_idx(v_name OKL_INDICES_V.NAME%TYPE,
263: v_id OKL_INDICES_V.ID%TYPE) is
264: SELECT '1'
265: FROM okl_indices_v
266: WHERE name = v_name

Line 263: v_id OKL_INDICES_V.ID%TYPE) is

259: l_idxv_status VARCHAR2(1);
260: l_row_found Boolean := False;
261:
262: CURSOR c_idx(v_name OKL_INDICES_V.NAME%TYPE,
263: v_id OKL_INDICES_V.ID%TYPE) is
264: SELECT '1'
265: FROM okl_indices_v
266: WHERE name = v_name
267: AND ID <> v_id;

Line 265: FROM okl_indices_v

261:
262: CURSOR c_idx(v_name OKL_INDICES_V.NAME%TYPE,
263: v_id OKL_INDICES_V.ID%TYPE) is
264: SELECT '1'
265: FROM okl_indices_v
266: WHERE name = v_name
267: AND ID <> v_id;
268:
269: BEGIN

Line 429: -- FUNCTION get_rec for: OKL_INDICES_V

425: BEGIN
426: RETURN(get_rec(p_idx_rec, l_row_notfound));
427: END get_rec;
428: ---------------------------------------------------------------------------
429: -- FUNCTION get_rec for: OKL_INDICES_V
430: ---------------------------------------------------------------------------
431: FUNCTION get_rec (
432: p_idxv_rec IN idxv_rec_type,
433: x_no_data_found OUT NOCOPY BOOLEAN

Line 468: FROM Okl_Indices_V

464: CREATION_DATE,
465: LAST_UPDATED_BY,
466: LAST_UPDATE_DATE,
467: LAST_UPDATE_LOGIN
468: FROM Okl_Indices_V
469: WHERE okl_indices_v.id = p_id;
470: l_okl_idxv_pk okl_idxv_pk_csr%ROWTYPE;
471: l_idxv_rec idxv_rec_type;
472: BEGIN

Line 469: WHERE okl_indices_v.id = p_id;

465: LAST_UPDATED_BY,
466: LAST_UPDATE_DATE,
467: LAST_UPDATE_LOGIN
468: FROM Okl_Indices_V
469: WHERE okl_indices_v.id = p_id;
470: l_okl_idxv_pk okl_idxv_pk_csr%ROWTYPE;
471: l_idxv_rec idxv_rec_type;
472: BEGIN
473: x_no_data_found := TRUE;

Line 522: -- FUNCTION null_out_defaults for: OKL_INDICES_V --

518: RETURN(get_rec(p_idxv_rec, l_row_notfound));
519: END get_rec;
520:
521: ---------------------------------------------------
522: -- FUNCTION null_out_defaults for: OKL_INDICES_V --
523: ---------------------------------------------------
524: FUNCTION null_out_defaults (
525: p_idxv_rec IN idxv_rec_type
526: ) RETURN idxv_rec_type IS

Line 625: -- Validate_Attributes for:OKL_INDICES_V --

621: ---------------------------------------------------------------------------
622: -- PROCEDURE Validate_Attributes
623: ---------------------------------------------------------------------------
624: -------------------------------------------
625: -- Validate_Attributes for:OKL_INDICES_V --
626: -------------------------------------------
627: FUNCTION Validate_Attributes (
628: p_idxv_rec IN idxv_rec_type
629: ) RETURN VARCHAR2 IS

Line 709: -- Validate_Record for:OKL_INDICES_V --

705:
706: ---------------------------------------------------------------------------
707: -- PROCEDURE Validate_Record
708: ---------------------------------------------------------------------------
709: -- Validate_Record for:OKL_INDICES_V --
710: -- History : 04/20/2001 Inserted Robin Edwin for validate Unique
711: ---------------------------------------------------------------------------
712:
713: FUNCTION Validate_Record (

Line 849: -- validate_row for:OKL_INDICES_V --

845: ---------------------------------------------------------------------------
846: -- PROCEDURE validate_row
847: ---------------------------------------------------------------------------
848: ------------------------------------
849: -- validate_row for:OKL_INDICES_V --
850: ------------------------------------
851: PROCEDURE validate_row(
852: p_api_version IN NUMBER,
853: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1148: -- insert_row for:OKL_INDICES_V --

1144: '_PVT'
1145: );
1146: END insert_row;
1147: ----------------------------------
1148: -- insert_row for:OKL_INDICES_V --
1149: ----------------------------------
1150: PROCEDURE insert_row(
1151: p_api_version IN NUMBER,
1152: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1182: -- Set_Attributes for:OKL_INDICES_V --

1178: l_idxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1179: RETURN(l_idxv_rec);
1180: END fill_who_columns;
1181: --------------------------------------
1182: -- Set_Attributes for:OKL_INDICES_V --
1183: --------------------------------------
1184: FUNCTION Set_Attributes (
1185: p_idxv_rec IN idxv_rec_type,
1186: x_idxv_rec OUT NOCOPY idxv_rec_type

Line 1488: -- lock_row for:OKL_INDICES_V --

1484: '_PVT'
1485: );
1486: END lock_row;
1487: --------------------------------
1488: -- lock_row for:OKL_INDICES_V --
1489: --------------------------------
1490: PROCEDURE lock_row(
1491: p_api_version IN NUMBER,
1492: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1909: -- update_row for:OKL_INDICES_V --

1905: '_PVT'
1906: );
1907: END update_row;
1908: ----------------------------------
1909: -- update_row for:OKL_INDICES_V --
1910: ----------------------------------
1911: PROCEDURE update_row(
1912: p_api_version IN NUMBER,
1913: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2084: -- Set_Attributes for:OKL_INDICES_V --

2080: END IF;
2081: RETURN(l_return_status);
2082: END populate_new_record;
2083: --------------------------------------
2084: -- Set_Attributes for:OKL_INDICES_V --
2085: --------------------------------------
2086: FUNCTION Set_Attributes (
2087: p_idxv_rec IN idxv_rec_type,
2088: x_idxv_rec OUT NOCOPY idxv_rec_type

Line 2354: -- delete_row for:OKL_INDICES_V --

2350: '_PVT'
2351: );
2352: END delete_row;
2353: ----------------------------------
2354: -- delete_row for:OKL_INDICES_V --
2355: ----------------------------------
2356: PROCEDURE delete_row(
2357: p_api_version IN NUMBER,
2358: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,