DBA Data[Home] [Help]

APPS.OKL_CSP_PVT dependencies on OKL_SLCTD_OPTNS_V

Line 286: -- FUNCTION get_rec for: OKL_SLCTD_OPTNS_V

282: BEGIN
283: RETURN(get_rec(p_csp_rec, l_row_notfound));
284: END get_rec;
285: ---------------------------------------------------------------------------
286: -- FUNCTION get_rec for: OKL_SLCTD_OPTNS_V
287: ---------------------------------------------------------------------------
288: FUNCTION get_rec (
289: p_cspv_rec IN cspv_rec_type,
290: x_no_data_found OUT NOCOPY BOOLEAN

Line 319: FROM Okl_Slctd_Optns_V

315: CREATION_DATE,
316: LAST_UPDATED_BY,
317: LAST_UPDATE_DATE,
318: LAST_UPDATE_LOGIN
319: FROM Okl_Slctd_Optns_V
320: WHERE okl_slctd_optns_v.id = p_id;
321: l_okl_cspv_pk okl_cspv_pk_csr%ROWTYPE;
322: l_cspv_rec cspv_rec_type;
323: BEGIN

Line 320: WHERE okl_slctd_optns_v.id = p_id;

316: LAST_UPDATED_BY,
317: LAST_UPDATE_DATE,
318: LAST_UPDATE_LOGIN
319: FROM Okl_Slctd_Optns_V
320: WHERE okl_slctd_optns_v.id = p_id;
321: l_okl_cspv_pk okl_cspv_pk_csr%ROWTYPE;
322: l_cspv_rec cspv_rec_type;
323: BEGIN
324: x_no_data_found := TRUE;

Line 367: -- FUNCTION null_out_defaults for: OKL_SLCTD_OPTNS_V --

363: RETURN(get_rec(p_cspv_rec, l_row_notfound));
364: END get_rec;
365:
366: -------------------------------------------------------
367: -- FUNCTION null_out_defaults for: OKL_SLCTD_OPTNS_V --
368: -------------------------------------------------------
369: FUNCTION null_out_defaults (
370: p_cspv_rec IN cspv_rec_type
371: ) RETURN cspv_rec_type IS

Line 452: -- Validate_Attributes for:OKL_SLCTD_OPTNS_V --

448: ---------------------------------------------------------------------------
449: -- PROCEDURE Validate_Attributes
450: ---------------------------------------------------------------------------
451: -----------------------------------------------
452: -- Validate_Attributes for:OKL_SLCTD_OPTNS_V --
453: -----------------------------------------------
454: FUNCTION Validate_Attributes (
455: p_cspv_rec IN cspv_rec_type
456: ) RETURN VARCHAR2 IS

Line 493: -- Validate_Record for:OKL_SLCTD_OPTNS_V --

489: ---------------------------------------------------------------------------
490: -- PROCEDURE Validate_Record
491: ---------------------------------------------------------------------------
492: -------------------------------------------
493: -- Validate_Record for:OKL_SLCTD_OPTNS_V --
494: -------------------------------------------
495: FUNCTION Validate_Record (
496: p_cspv_rec IN cspv_rec_type
497: ) RETURN VARCHAR2 IS

Line 573: -- validate_row for:OKL_SLCTD_OPTNS_V --

569: ---------------------------------------------------------------------------
570: -- PROCEDURE validate_row
571: ---------------------------------------------------------------------------
572: ----------------------------------------
573: -- validate_row for:OKL_SLCTD_OPTNS_V --
574: ----------------------------------------
575: PROCEDURE validate_row(
576: p_api_version IN NUMBER,
577: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 852: -- insert_row for:OKL_SLCTD_OPTNS_V --

848: '_PVT'
849: );
850: END insert_row;
851: --------------------------------------
852: -- insert_row for:OKL_SLCTD_OPTNS_V --
853: --------------------------------------
854: PROCEDURE insert_row(
855: p_api_version IN NUMBER,
856: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 886: -- Set_Attributes for:OKL_SLCTD_OPTNS_V --

882: l_cspv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
883: RETURN(l_cspv_rec);
884: END fill_who_columns;
885: ------------------------------------------
886: -- Set_Attributes for:OKL_SLCTD_OPTNS_V --
887: ------------------------------------------
888: FUNCTION Set_Attributes (
889: p_cspv_rec IN cspv_rec_type,
890: x_cspv_rec OUT NOCOPY cspv_rec_type

Line 1172: -- lock_row for:OKL_SLCTD_OPTNS_V --

1168: '_PVT'
1169: );
1170: END lock_row;
1171: ------------------------------------
1172: -- lock_row for:OKL_SLCTD_OPTNS_V --
1173: ------------------------------------
1174: PROCEDURE lock_row(
1175: p_api_version IN NUMBER,
1176: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1555: -- update_row for:OKL_SLCTD_OPTNS_V --

1551: '_PVT'
1552: );
1553: END update_row;
1554: --------------------------------------
1555: -- update_row for:OKL_SLCTD_OPTNS_V --
1556: --------------------------------------
1557: PROCEDURE update_row(
1558: p_api_version IN NUMBER,
1559: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1706: -- Set_Attributes for:OKL_SLCTD_OPTNS_V --

1702: END IF;
1703: RETURN(l_return_status);
1704: END populate_new_record;
1705: ------------------------------------------
1706: -- Set_Attributes for:OKL_SLCTD_OPTNS_V --
1707: ------------------------------------------
1708: FUNCTION Set_Attributes (
1709: p_cspv_rec IN cspv_rec_type,
1710: x_cspv_rec OUT NOCOPY cspv_rec_type

Line 1949: -- delete_row for:OKL_SLCTD_OPTNS_V --

1945: '_PVT'
1946: );
1947: END delete_row;
1948: --------------------------------------
1949: -- delete_row for:OKL_SLCTD_OPTNS_V --
1950: --------------------------------------
1951: PROCEDURE delete_row(
1952: p_api_version IN NUMBER,
1953: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,