1 PACKAGE OKC_ART_BLK_PVT AUTHID CURRENT_USER AS
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;
11
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;
21
22 TYPE num_tbl_type IS TABLE OF NUMBER;
23 TYPE date_tbl_type IS TABLE OF DATE;
24 TYPE varchar_tbl_type IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
25
26
27 ---------------- Private APIs BEGIN ----------------------------
28 FUNCTION get_uniq_id RETURN NUMBER;
29
30
31 PROCEDURE validate_article_versions_blk(
32 p_api_version IN NUMBER ,
33 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
34 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
35 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL ,
36 x_return_status OUT NOCOPY VARCHAR2 ,
37 x_msg_count OUT NOCOPY NUMBER ,
38 x_msg_data OUT NOCOPY VARCHAR2 ,
39
40 p_org_id IN NUMBER ,
41 p_art_ver_tbl IN num_tbl_type ,
42 p_id IN NUMBER DEFAULT NULL,
43 x_qa_return_status OUT NOCOPY VARCHAR2,
44 x_validation_results OUT NOCOPY validation_tbl_type );
45
46
47 PROCEDURE auto_adopt_articles_blk(
48 p_api_version IN NUMBER ,
49 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
50 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
51 x_return_status OUT NOCOPY VARCHAR2 ,
52 x_msg_count OUT NOCOPY NUMBER ,
53 x_msg_data OUT NOCOPY VARCHAR2 ,
54
55 p_id IN NUMBER);
56
57 PROCEDURE pending_approval_blk(
58 p_api_version IN NUMBER ,
59 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
60 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
61 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL ,
62 x_return_status OUT NOCOPY VARCHAR2 ,
63 x_msg_count OUT NOCOPY NUMBER ,
64 x_msg_data OUT NOCOPY VARCHAR2 ,
65
66 p_org_id IN NUMBER ,
67 p_art_ver_tbl IN num_tbl_type ,
68 x_validation_results OUT NOCOPY validation_tbl_type );
69
70
71 PROCEDURE approve_blk(
72 p_api_version IN NUMBER ,
73 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
74 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
75 x_return_status OUT NOCOPY VARCHAR2 ,
76 x_msg_count OUT NOCOPY NUMBER ,
77 x_msg_data OUT NOCOPY VARCHAR2 ,
78
79 p_org_id IN NUMBER ,
80 p_art_ver_tbl IN num_tbl_type ,
81 x_validation_results OUT NOCOPY validation_tbl_type );
82
83
84 PROCEDURE reject_blk(
85 p_api_version IN NUMBER ,
86 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
87 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
88 x_return_status OUT NOCOPY VARCHAR2 ,
89 x_msg_count OUT NOCOPY NUMBER ,
90 x_msg_data OUT NOCOPY VARCHAR2 ,
91
92 p_org_id IN NUMBER ,
93 p_art_ver_tbl IN num_tbl_type ,
94 x_validation_results OUT NOCOPY validation_tbl_type );
95
96
97 ---------------- Private APIs END ------------------------------
98
99
100 END OKC_ART_BLK_PVT;