APPS.OKC_SAE_PVT dependencies on OKC_STD_ARTICLES_V

Line 289: -- FUNCTION get_rec for: OKC_STD_ARTICLES_V

285: RETURN(get_rec(p_okc_std_articles_tl_rec, l_row_notfound));
286:
287: END get_rec;
288: ---------------------------------------------------------------------------
289: -- FUNCTION get_rec for: OKC_STD_ARTICLES_V
290: ---------------------------------------------------------------------------
291: FUNCTION get_rec (
292: p_saev_rec IN saev_rec_type,
293: x_no_data_found OUT NOCOPY BOOLEAN

Line 323: FROM Okc_Std_Articles_V

319: CREATION_DATE,
320: LAST_UPDATED_BY,
321: LAST_UPDATE_DATE,
322: LAST_UPDATE_LOGIN
323: FROM Okc_Std_Articles_V
324: WHERE okc_std_articles_v.id = p_id;
325: l_okc_saev_pk okc_saev_pk_csr%ROWTYPE;
326: l_saev_rec saev_rec_type;
327: BEGIN

Line 324: WHERE okc_std_articles_v.id = p_id;

320: LAST_UPDATED_BY,
321: LAST_UPDATE_DATE,
322: LAST_UPDATE_LOGIN
323: FROM Okc_Std_Articles_V
324: WHERE okc_std_articles_v.id = p_id;
325: l_okc_saev_pk okc_saev_pk_csr%ROWTYPE;
326: l_saev_rec saev_rec_type;
327: BEGIN
328:

Line 386: -- FUNCTION null_out_defaults for: OKC_STD_ARTICLES_V --

382:
383: END get_rec;
384:
385: --------------------------------------------------------
386: -- FUNCTION null_out_defaults for: OKC_STD_ARTICLES_V --
387: --------------------------------------------------------
388: FUNCTION null_out_defaults (
389: p_saev_rec IN saev_rec_type
390: ) RETURN saev_rec_type IS

Line 873: cursor c1 is select id from okc_std_articles_v where UPPER(name)=UPPER(p_saev_rec.name);

869: -- End of comments
870: procedure validate_name(p_saev_rec IN saev_rec_type,
871: x_return_status OUT NOCOPY VARCHAR2) is
872:
873: cursor c1 is select id from okc_std_articles_v where UPPER(name)=UPPER(p_saev_rec.name);
874: l_id number:=OKC_API.G_MISS_NUM;
875: BEGIN
876:
877: IF (l_debug = 'Y') THEN

Line 944: -- Validate_Attributes for:OKC_STD_ARTICLES_V --

940: ---------------------------------------------------------------------------
941: -- PROCEDURE Validate_Attributes
942: ---------------------------------------------------------------------------
943: ------------------------------------------------
944: -- Validate_Attributes for:OKC_STD_ARTICLES_V --
945: ------------------------------------------------
946: FUNCTION Validate_Attributes (
947: p_saev_rec IN saev_rec_type
948: ) RETURN VARCHAR2 IS

Line 1051: -- Validate_Record for:OKC_STD_ARTICLES_V --

1047: ---------------------------------------------------------------------------
1048: -- PROCEDURE Validate_Record
1049: ---------------------------------------------------------------------------
1050: --------------------------------------------
1051: -- Validate_Record for:OKC_STD_ARTICLES_V --
1052: --------------------------------------------
1053: FUNCTION Validate_Record (
1054: p_saev_rec IN saev_rec_type
1055: ) RETURN VARCHAR2 IS

Line 1171: -- validate_row for:OKC_STD_ARTICLES_V --

1167: ---------------------------------------------------------------------------
1168: -- PROCEDURE validate_row
1169: ---------------------------------------------------------------------------
1170: -----------------------------------------
1171: -- validate_row for:OKC_STD_ARTICLES_V --
1172: -----------------------------------------
1173: PROCEDURE validate_row(
1174: p_api_version IN NUMBER,
1175: p_init_msg_list IN VARCHAR2 ,

Line 1692: -- insert_row for:OKC_STD_ARTICLES_V --

1688: );
1689:
1690: END insert_row;
1691: ---------------------------------------
1692: -- insert_row for:OKC_STD_ARTICLES_V --
1693: ---------------------------------------
1694: PROCEDURE insert_row(
1695: p_api_version IN NUMBER,
1696: p_init_msg_list IN VARCHAR2 ,

Line 1731: -- Set_Attributes for:OKC_STD_ARTICLES_V --

1727: RETURN(l_saev_rec);
1728:
1729: END fill_who_columns;
1730: -------------------------------------------
1731: -- Set_Attributes for:OKC_STD_ARTICLES_V --
1732: -------------------------------------------
1733: FUNCTION Set_Attributes (
1734: p_saev_rec IN saev_rec_type,
1735: x_saev_rec OUT NOCOPY saev_rec_type

Line 2286: -- lock_row for:OKC_STD_ARTICLES_V --

2282: );
2283:
2284: END lock_row;
2285: -------------------------------------
2286: -- lock_row for:OKC_STD_ARTICLES_V --
2287: -------------------------------------
2288: PROCEDURE lock_row(
2289: p_api_version IN NUMBER,
2290: p_init_msg_list IN VARCHAR2 ,

Line 3005: -- update_row for:OKC_STD_ARTICLES_V --

3001: );
3002:
3003: END update_row;
3004: ---------------------------------------
3005: -- update_row for:OKC_STD_ARTICLES_V --
3006: ---------------------------------------
3007: PROCEDURE update_row(
3008: p_api_version IN NUMBER,
3009: p_init_msg_list IN VARCHAR2 ,

Line 3177: -- Set_Attributes for:OKC_STD_ARTICLES_V --

3173: RETURN(l_return_status);
3174:
3175: END populate_new_record;
3176: -------------------------------------------
3177: -- Set_Attributes for:OKC_STD_ARTICLES_V --
3178: -------------------------------------------
3179: FUNCTION Set_Attributes (
3180: p_saev_rec IN saev_rec_type,
3181: x_saev_rec OUT NOCOPY saev_rec_type

Line 3660: -- delete_row for:OKC_STD_ARTICLES_V --

3656: );
3657:
3658: END delete_row;
3659: ---------------------------------------
3660: -- delete_row for:OKC_STD_ARTICLES_V --
3661: ---------------------------------------
3662: PROCEDURE delete_row(
3663: p_api_version IN NUMBER,
3664: p_init_msg_list IN VARCHAR2 ,