1 PACKAGE OKC_ARTICLE_STATUS_CHANGE_PVT AS
2 /* $Header: OKCVARTSTSS.pls 120.0.12000000.1 2007/01/17 11:32:03 appldev ship $ */
3
4 ---------------------------------------
5 -- PROCEDURE hold_unhold --
6 ---------------------------------------
7 -- Procedure to set an article version status from hold to unhold (Approved)
8 -- and vice-versa.
9 -- Parameters: article_version_id , p_hold_yn => Y means Hold and N means Unhold
10 -- (Approved).
11 -- This will be called from the UI only. So we can save db access to check
12 -- if article version is global or Not.
13
14
15 PROCEDURE hold_unhold(
16 p_api_version IN NUMBER,
17 p_init_msg_list IN VARCHAR2 ,
18 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_count OUT NOCOPY NUMBER,
22 x_msg_data OUT NOCOPY VARCHAR2,
23 p_hold_yn IN VARCHAR2 := 'Y',
24 p_article_version_id IN NUMBER
25 );
26
27 ---------------------------------------
28 -- PROCEDURE pending-approval --
29 ---------------------------------------
30 -- Procedure to set an article version status from draft to pending approval
31 -- Parameters: article_version_id , p_adopt_as_is_yn => Y means Adoption at a
32 -- Local Org as is and N means Local version
33 -- This will be called from the UI only. So we can save db access to check
34 -- if article version is global or Not.
35
36
37 PROCEDURE pending_approval(
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 ,
40
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 p_current_org_id IN NUMBER,
45 p_adopt_as_is_yn IN VARCHAR2,
46 p_article_version_id IN NUMBER,
47 p_article_title IN VARCHAR,
48 p_article_version_number IN VARCHAR
49 );
50
51 ---------------------------------------
52 -- PROCEDURE approve
53 ---------------------------------------
54 -- Procedure to set an article version status from pending approval to approved.
55 -- Parameters: article_version_id , p_adopt_as_is_yn => Y means Adoption at a
56 -- Local Org as is and N means Local version
57 -- This will be called from the UI only. So we can save db access to check
58 -- if article version is global or Not.
59
60 PROCEDURE approve(
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 ,
63
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_current_org_id IN NUMBER,
68 p_adopt_as_is_yn IN VARCHAR2,
69 p_article_version_id IN NUMBER
70 );
71
72 ---------------------------------------
73 -- PROCEDURE reject
74 ---------------------------------------
75 -- Procedure to set an article version status from pending approval to rejected.
76 -- Parameters: article_version_id , p_adopt_as_is_yn => Y means Adoption at a
77 -- Local Org as is and N means Local version
78 -- This will be called from the UI only. So we can save db access to check
79 -- if article version is global or Not.
80
81
82 PROCEDURE reject(
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 ,
85
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2,
89 p_current_org_id IN NUMBER,
90 p_adopt_as_is_yn IN VARCHAR2,
91 p_article_version_id IN NUMBER
92 );
93
94 END OKC_ARTICLE_STATUS_CHANGE_PVT;