DBA Data[Home] [Help]

APPS.OKL_VP_CAT_PVT dependencies on OKC_K_ARTICLES_V

Line 304: -- FUNCTION get_rec for: OKC_K_ARTICLES_V

300: BEGIN
301: RETURN(get_rec(p_okc_k_articles_tl_rec, l_row_notfound));
302: END get_rec;
303: ---------------------------------------------------------------------------
304: -- FUNCTION get_rec for: OKC_K_ARTICLES_V
305: ---------------------------------------------------------------------------
306: FUNCTION get_rec (
307: p_catv_rec IN catv_rec_type,
308: x_no_data_found OUT NOCOPY BOOLEAN

Line 349: FROM Okc_K_Articles_V

345: CREATION_DATE,
346: LAST_UPDATED_BY,
347: LAST_UPDATE_DATE,
348: LAST_UPDATE_LOGIN
349: FROM Okc_K_Articles_V
350: WHERE okc_k_articles_v.id = p_id;
351: l_okc_catv_pk okc_catv_pk_csr%ROWTYPE;
352: l_catv_rec catv_rec_type;
353: BEGIN

Line 350: WHERE okc_k_articles_v.id = p_id;

346: LAST_UPDATED_BY,
347: LAST_UPDATE_DATE,
348: LAST_UPDATE_LOGIN
349: FROM Okc_K_Articles_V
350: WHERE okc_k_articles_v.id = p_id;
351: l_okc_catv_pk okc_catv_pk_csr%ROWTYPE;
352: l_catv_rec catv_rec_type;
353: BEGIN
354: x_no_data_found := TRUE;

Line 409: -- FUNCTION null_out_defaults for: OKC_K_ARTICLES_V --

405: RETURN(get_rec(p_catv_rec, l_row_notfound));
406: END get_rec;
407:
408: ------------------------------------------------------
409: -- FUNCTION null_out_defaults for: OKC_K_ARTICLES_V --
410: ------------------------------------------------------
411: FUNCTION null_out_defaults (
412: p_catv_rec IN catv_rec_type
413: ) RETURN catv_rec_type IS

Line 782: -- Validate_Attributes for:OKC_K_ARTICLES_V --

778: end validate_chr_id;
779:
780: /*+++++++++++++End of hand code +++++++++++++++++++*/
781: ----------------------------------------------
782: -- Validate_Attributes for:OKC_K_ARTICLES_V --
783: ----------------------------------------------
784: FUNCTION Validate_Attributes (
785: p_catv_rec IN catv_rec_type
786: ) RETURN VARCHAR2 IS

Line 899: -- Validate_Record for:OKC_K_ARTICLES_V --

895: ---------------------------------------------------------------------------
896: -- PROCEDURE Validate_Record
897: ---------------------------------------------------------------------------
898: ------------------------------------------
899: -- Validate_Record for:OKC_K_ARTICLES_V --
900: ------------------------------------------
901: FUNCTION Validate_Record (
902: p_catv_rec IN catv_rec_type
903: ) RETURN VARCHAR2 IS

Line 1091: FROM Okc_K_Articles_V

1087: CREATION_DATE,
1088: LAST_UPDATED_BY,
1089: LAST_UPDATE_DATE,
1090: LAST_UPDATE_LOGIN
1091: FROM Okc_K_Articles_V
1092: WHERE okc_k_articles_v.id = p_id;
1093: l_okc_catv_pk okc_catv_pk_csr%ROWTYPE;
1094: CURSOR okc_savv_pk_csr (p_sae_id IN NUMBER,
1095: p_sav_release IN VARCHAR2) IS

Line 1092: WHERE okc_k_articles_v.id = p_id;

1088: LAST_UPDATED_BY,
1089: LAST_UPDATE_DATE,
1090: LAST_UPDATE_LOGIN
1091: FROM Okc_K_Articles_V
1092: WHERE okc_k_articles_v.id = p_id;
1093: l_okc_catv_pk okc_catv_pk_csr%ROWTYPE;
1094: CURSOR okc_savv_pk_csr (p_sae_id IN NUMBER,
1095: p_sav_release IN VARCHAR2) IS
1096: SELECT

Line 1422: -- validate_row for:OKC_K_ARTICLES_V --

1418: ---------------------------------------------------------------------------
1419: -- PROCEDURE validate_row
1420: ---------------------------------------------------------------------------
1421: ---------------------------------------
1422: -- validate_row for:OKC_K_ARTICLES_V --
1423: ---------------------------------------
1424: PROCEDURE validate_row(
1425: p_api_version IN NUMBER,
1426: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1842: -- insert_row for:OKC_K_ARTICLES_V --

1838: '_PVT'
1839: );
1840: END insert_row;
1841: -------------------------------------
1842: -- insert_row for:OKC_K_ARTICLES_V --
1843: -------------------------------------
1844: PROCEDURE insert_row(
1845: p_api_version IN NUMBER,
1846: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1878: -- Set_Attributes for:OKC_K_ARTICLES_V --

1874: l_catv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1875: RETURN(l_catv_rec);
1876: END fill_who_columns;
1877: -----------------------------------------
1878: -- Set_Attributes for:OKC_K_ARTICLES_V --
1879: -----------------------------------------
1880: FUNCTION Set_Attributes (
1881: p_catv_rec IN catv_rec_type,
1882: x_catv_rec OUT NOCOPY catv_rec_type

Line 2265: -- lock_row for:OKC_K_ARTICLES_V --

2261: '_PVT'
2262: );
2263: END lock_row;
2264: -----------------------------------
2265: -- lock_row for:OKC_K_ARTICLES_V --
2266: -----------------------------------
2267: PROCEDURE lock_row(
2268: p_api_version IN NUMBER,
2269: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2902: -- update_row for:OKC_K_ARTICLES_V --

2898: '_PVT'
2899: );
2900: END update_row;
2901: -------------------------------------
2902: -- update_row for:OKC_K_ARTICLES_V --
2903: -------------------------------------
2904: PROCEDURE update_row(
2905: p_api_version IN NUMBER,
2906: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3107: -- Set_Attributes for:OKC_K_ARTICLES_V --

3103: END IF;
3104: RETURN(l_return_status);
3105: END populate_new_record;
3106: -----------------------------------------
3107: -- Set_Attributes for:OKC_K_ARTICLES_V --
3108: -----------------------------------------
3109: FUNCTION Set_Attributes (
3110: p_catv_rec IN catv_rec_type,
3111: x_catv_rec OUT NOCOPY catv_rec_type

Line 3450: -- delete_row for:OKC_K_ARTICLES_V --

3446: '_PVT'
3447: );
3448: END delete_row;
3449: -------------------------------------
3450: -- delete_row for:OKC_K_ARTICLES_V --
3451: -------------------------------------
3452: PROCEDURE delete_row(
3453: p_api_version IN NUMBER,
3454: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,