DBA Data[Home] [Help]

APPS.OKC_CAT_PVT dependencies on OKC_K_ARTICLES_V

Line 446: -- FUNCTION get_rec for: OKC_K_ARTICLES_V

442: RETURN(get_rec(p_okc_k_articles_tl_rec, l_row_notfound));
443:
444: END get_rec;
445: ---------------------------------------------------------------------------
446: -- FUNCTION get_rec for: OKC_K_ARTICLES_V
447: ---------------------------------------------------------------------------
448: FUNCTION get_rec (
449: p_catv_rec IN catv_rec_type,
450: x_no_data_found OUT NOCOPY BOOLEAN

Line 491: FROM Okc_K_Articles_V

487: CREATION_DATE,
488: LAST_UPDATED_BY,
489: LAST_UPDATE_DATE,
490: LAST_UPDATE_LOGIN
491: FROM Okc_K_Articles_V
492: WHERE okc_k_articles_v.id = p_id;
493: l_okc_catv_pk okc_catv_pk_csr%ROWTYPE;
494: l_catv_rec catv_rec_type;
495: BEGIN

Line 492: WHERE okc_k_articles_v.id = p_id;

488: LAST_UPDATED_BY,
489: LAST_UPDATE_DATE,
490: LAST_UPDATE_LOGIN
491: FROM Okc_K_Articles_V
492: WHERE okc_k_articles_v.id = p_id;
493: l_okc_catv_pk okc_catv_pk_csr%ROWTYPE;
494: l_catv_rec catv_rec_type;
495: BEGIN
496:

Line 566: -- FUNCTION null_out_defaults for: OKC_K_ARTICLES_V --

562:
563: END get_rec;
564:
565: ------------------------------------------------------
566: -- FUNCTION null_out_defaults for: OKC_K_ARTICLES_V --
567: ------------------------------------------------------
568: FUNCTION null_out_defaults (
569: p_catv_rec IN catv_rec_type
570: ) RETURN catv_rec_type IS

Line 1070: -- Validate_Attributes for:OKC_K_ARTICLES_V --

1066: end validate_chr_id;
1067:
1068: /*+++++++++++++End of hand code +++++++++++++++++++*/
1069: ----------------------------------------------
1070: -- Validate_Attributes for:OKC_K_ARTICLES_V --
1071: ----------------------------------------------
1072: FUNCTION Validate_Attributes (
1073: p_catv_rec IN catv_rec_type
1074: ) RETURN VARCHAR2 IS

Line 1208: -- Validate_Record for:OKC_K_ARTICLES_V --

1204: ---------------------------------------------------------------------------
1205: -- PROCEDURE Validate_Record
1206: ---------------------------------------------------------------------------
1207: ------------------------------------------
1208: -- Validate_Record for:OKC_K_ARTICLES_V --
1209: ------------------------------------------
1210: FUNCTION Validate_Record (
1211: p_catv_rec IN catv_rec_type
1212: ) RETURN VARCHAR2 IS

Line 1450: -- validate_row for:OKC_K_ARTICLES_V --

1446: ---------------------------------------------------------------------------
1447: -- PROCEDURE validate_row
1448: ---------------------------------------------------------------------------
1449: ---------------------------------------
1450: -- validate_row for:OKC_K_ARTICLES_V --
1451: ---------------------------------------
1452: PROCEDURE validate_row(
1453: p_api_version IN NUMBER,
1454: p_init_msg_list IN VARCHAR2 ,

Line 1994: -- insert_row for:OKC_K_ARTICLES_V --

1990: );
1991:
1992: END insert_row;
1993: -------------------------------------
1994: -- insert_row for:OKC_K_ARTICLES_V --
1995: -------------------------------------
1996: PROCEDURE insert_row(
1997: p_api_version IN NUMBER,
1998: p_init_msg_list IN VARCHAR2 ,

Line 2043: -- Set_Attributes for:OKC_K_ARTICLES_V --

2039: RETURN(l_catv_rec);
2040:
2041: END fill_who_columns;
2042: -----------------------------------------
2043: -- Set_Attributes for:OKC_K_ARTICLES_V --
2044: -----------------------------------------
2045: FUNCTION Set_Attributes (
2046: p_catv_rec IN catv_rec_type,
2047: x_catv_rec OUT NOCOPY catv_rec_type

Line 2582: -- lock_row for:OKC_K_ARTICLES_V --

2578: );
2579:
2580: END lock_row;
2581: -----------------------------------
2582: -- lock_row for:OKC_K_ARTICLES_V --
2583: -----------------------------------
2584: PROCEDURE lock_row(
2585: p_api_version IN NUMBER,
2586: p_init_msg_list IN VARCHAR2 ,

Line 3363: -- update_row for:OKC_K_ARTICLES_V --

3359: );
3360:
3361: END update_row;
3362: -------------------------------------
3363: -- update_row for:OKC_K_ARTICLES_V --
3364: -------------------------------------
3365: PROCEDURE update_row(
3366: p_api_version IN NUMBER,
3367: p_init_msg_list IN VARCHAR2 ,

Line 3583: -- Set_Attributes for:OKC_K_ARTICLES_V --

3579: RETURN(l_return_status);
3580:
3581: END populate_new_record;
3582: -----------------------------------------
3583: -- Set_Attributes for:OKC_K_ARTICLES_V --
3584: -----------------------------------------
3585: FUNCTION Set_Attributes (
3586: p_catv_rec IN catv_rec_type,
3587: x_catv_rec OUT NOCOPY catv_rec_type

Line 4054: -- delete_row for:OKC_K_ARTICLES_V --

4050: );
4051:
4052: END delete_row;
4053: -------------------------------------
4054: -- delete_row for:OKC_K_ARTICLES_V --
4055: -------------------------------------
4056: PROCEDURE delete_row(
4057: p_api_version IN NUMBER,
4058: p_init_msg_list IN VARCHAR2 ,