DBA Data[Home] [Help]

APPS.OKC_ART_BLK_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 6: ver_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,

2: /* $Header: OKCVARTBLKS.pls 120.0 2005/05/25 19:28:00 appldev noship $ */
3:
4: TYPE ver_details_rec is RECORD(
5: org_id OKC_ARTICLES_ALL.ORG_ID%TYPE,
6: ver_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,
7: global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE,
8: adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE
9: );
10: TYPE ver_details_tbl_type is TABLE OF ver_details_rec;

Line 7: global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE,

3:
4: TYPE ver_details_rec is RECORD(
5: org_id OKC_ARTICLES_ALL.ORG_ID%TYPE,
6: ver_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,
7: global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE,
8: adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE
9: );
10: TYPE ver_details_tbl_type is TABLE OF ver_details_rec;
11:

Line 8: adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE

4: TYPE ver_details_rec is RECORD(
5: org_id OKC_ARTICLES_ALL.ORG_ID%TYPE,
6: ver_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,
7: global_yn OKC_ARTICLE_VERSIONS.GLOBAL_YN%TYPE,
8: adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE
9: );
10: TYPE ver_details_tbl_type is TABLE OF ver_details_rec;
11:
12: TYPE validation_rec IS RECORD (

Line 16: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,

12: TYPE validation_rec IS RECORD (
13: error_code VARCHAR2(250), -- contains some pre-defined error codes
14: error_message VARCHAR2(2000), -- contains a detail error message
15: article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE,
16: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,
17: article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE
18: );
19:
20: TYPE validation_tbl_type IS TABLE OF validation_rec INDEX BY BINARY_INTEGER;