APPS.OKC_ATN_PVT dependencies on OKC_ARTICLE_TRANS_V

Line 97: -- FUNCTION get_rec for: OKC_ARTICLE_TRANS_V

93: BEGIN
94: RETURN(get_rec(p_atn_rec, l_row_notfound));
95: END get_rec;
96: ---------------------------------------------------------------------------
97: -- FUNCTION get_rec for: OKC_ARTICLE_TRANS_V
98: ---------------------------------------------------------------------------
99: FUNCTION get_rec (
100: p_atnv_rec IN atnv_rec_type,
101: x_no_data_found OUT NOCOPY BOOLEAN

Line 116: FROM Okc_Article_Trans_V

112: CREATION_DATE,
113: LAST_UPDATED_BY,
114: LAST_UPDATE_DATE,
115: LAST_UPDATE_LOGIN
116: FROM Okc_Article_Trans_V
117: WHERE okc_article_trans_v.id = p_id;
118: l_okc_atnv_pk okc_atnv_pk_csr%ROWTYPE;
119: l_atnv_rec atnv_rec_type;
120: BEGIN

Line 117: WHERE okc_article_trans_v.id = p_id;

113: LAST_UPDATED_BY,
114: LAST_UPDATE_DATE,
115: LAST_UPDATE_LOGIN
116: FROM Okc_Article_Trans_V
117: WHERE okc_article_trans_v.id = p_id;
118: l_okc_atnv_pk okc_atnv_pk_csr%ROWTYPE;
119: l_atnv_rec atnv_rec_type;
120: BEGIN
121: x_no_data_found := TRUE;

Line 150: -- FUNCTION null_out_defaults for: OKC_ARTICLE_TRANS_V --

146: RETURN(get_rec(p_atnv_rec, l_row_notfound));
147: END get_rec;
148:
149: ---------------------------------------------------------
150: -- FUNCTION null_out_defaults for: OKC_ARTICLE_TRANS_V --
151: ---------------------------------------------------------
152: FUNCTION null_out_defaults (
153: p_atnv_rec IN atnv_rec_type
154: ) RETURN atnv_rec_type IS

Line 379: -- Validate_Attributes for:OKC_ARTICLE_TRANS_V --

375: end validate_dnz_chr_id;
376:
377: /*+++++++++++++End of hand code +++++++++++++++++*/
378: -------------------------------------------------
379: -- Validate_Attributes for:OKC_ARTICLE_TRANS_V --
380: -------------------------------------------------
381: FUNCTION Validate_Attributes (
382: p_atnv_rec IN atnv_rec_type
383: ) RETURN VARCHAR2 IS

Line 471: -- Validate_Record for:OKC_ARTICLE_TRANS_V --

467: ---------------------------------------------------------------------------
468: -- PROCEDURE Validate_Record
469: ---------------------------------------------------------------------------
470: ---------------------------------------------
471: -- Validate_Record for:OKC_ARTICLE_TRANS_V --
472: ---------------------------------------------
473: FUNCTION Validate_Record (
474: p_atnv_rec IN atnv_rec_type
475: --+++++++++++++++Start handcode +++++++++++++++++++++++++++++++++++

Line 697: select '!' from okc_article_trans_v

693: ---------------End of the commented code-----------*/
694: /*+++++++++++++Start of hand code +++++++++++++++++*/
695:
696: cursor pk1_csr is
697: select '!' from okc_article_trans_v
698: where cat_id = p_atnv_rec.cat_id
699: and cle_id = p_atnv_rec.cle_id;
700: cursor pk2_csr is
701: select '!' from okc_article_trans_v

Line 701: select '!' from okc_article_trans_v

697: select '!' from okc_article_trans_v
698: where cat_id = p_atnv_rec.cat_id
699: and cle_id = p_atnv_rec.cle_id;
700: cursor pk2_csr is
701: select '!' from okc_article_trans_v
702: where cat_id = p_atnv_rec.cat_id
703: and rul_id = p_atnv_rec.rul_id;
704: l_dummy varchar2(1) := '?';
705: BEGIN

Line 802: -- validate_row for:OKC_ARTICLE_TRANS_V --

798: ---------------------------------------------------------------------------
799: -- PROCEDURE validate_row
800: ---------------------------------------------------------------------------
801: ------------------------------------------
802: -- validate_row for:OKC_ARTICLE_TRANS_V --
803: ------------------------------------------
804: PROCEDURE validate_row(
805: p_api_version IN NUMBER,
806: p_init_msg_list IN VARCHAR2 ,

Line 1053: -- insert_row for:OKC_ARTICLE_TRANS_V --

1049: '_PVT'
1050: );
1051: END insert_row;
1052: ----------------------------------------
1053: -- insert_row for:OKC_ARTICLE_TRANS_V --
1054: ----------------------------------------
1055: PROCEDURE insert_row(
1056: p_api_version IN NUMBER,
1057: p_init_msg_list IN VARCHAR2 ,

Line 1087: -- Set_Attributes for:OKC_ARTICLE_TRANS_V --

1083: l_atnv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1084: RETURN(l_atnv_rec);
1085: END fill_who_columns;
1086: --------------------------------------------
1087: -- Set_Attributes for:OKC_ARTICLE_TRANS_V --
1088: --------------------------------------------
1089: FUNCTION Set_Attributes (
1090: p_atnv_rec IN atnv_rec_type,
1091: x_atnv_rec OUT NOCOPY atnv_rec_type

Line 1378: -- lock_row for:OKC_ARTICLE_TRANS_V --

1374: '_PVT'
1375: );
1376: END lock_row;
1377: --------------------------------------
1378: -- lock_row for:OKC_ARTICLE_TRANS_V --
1379: --------------------------------------
1380: PROCEDURE lock_row(
1381: p_api_version IN NUMBER,
1382: p_init_msg_list IN VARCHAR2 ,

Line 1691: -- update_row for:OKC_ARTICLE_TRANS_V --

1687: '_PVT'
1688: );
1689: END update_row;
1690: ----------------------------------------
1691: -- update_row for:OKC_ARTICLE_TRANS_V --
1692: ----------------------------------------
1693: PROCEDURE update_row(
1694: p_api_version IN NUMBER,
1695: p_init_msg_list IN VARCHAR2 ,

Line 1786: -- Set_Attributes for:OKC_ARTICLE_TRANS_V --

1782: END IF;
1783: RETURN(l_return_status);
1784: END populate_new_record;
1785: --------------------------------------------
1786: -- Set_Attributes for:OKC_ARTICLE_TRANS_V --
1787: --------------------------------------------
1788: FUNCTION Set_Attributes (
1789: p_atnv_rec IN atnv_rec_type,
1790: x_atnv_rec OUT NOCOPY atnv_rec_type

Line 2030: -- delete_row for:OKC_ARTICLE_TRANS_V --

2026: '_PVT'
2027: );
2028: END delete_row;
2029: ----------------------------------------
2030: -- delete_row for:OKC_ARTICLE_TRANS_V --
2031: ----------------------------------------
2032: PROCEDURE delete_row(
2033: p_api_version IN NUMBER,
2034: p_init_msg_list IN VARCHAR2 ,