1 package okc_artwf_pvt as
2 /* $Header: OKCARTWFS.pls 120.4 2006/07/06 23:45:14 muteshev noship $ */
3
4 procedure start_wf_after_import( p_req_id in number,
5 p_batch_number in varchar2,
6 p_org_id in varchar2);
7
8 -- for testing - don't use in apps code
9 procedure test( p_org_id in number,
10 p_article_version_id in number);
11
12 procedure check_status( p_org_id in number,
13 p_article_version_id in number,
14 x_result out nocopy varchar2,
15 x_msg_count out nocopy number,
16 x_msg_data out nocopy varchar2);
17 procedure clean;
18
19 -- for testing - don't use in apps code
20 procedure print_tab;
21 -- for testing - don't use in apps code
22 procedure print_err;
23
24 function get_write_ptr return binary_integer;
25 procedure get_write_ptr(x_write_ptr out nocopy binary_integer);
26 function get_error_ptr return binary_integer;
27 procedure get_error_ptr(x_error_ptr out nocopy binary_integer);
28
29 procedure get_tab( p_ptr in binary_integer,
30 x_article_id out nocopy okc_articles_all.article_id%type,
31 x_article_version_id out nocopy okc_article_versions.article_version_id%type,
32 x_article_status out nocopy okc_article_versions.article_status%type,
33 x_adoption_type out nocopy okc_article_versions.adoption_type%type,
34 x_global_yn out nocopy okc_article_versions.global_yn%type,
35 x_key out nocopy varchar2);
36
37 procedure get_err( p_ptr in binary_integer,
38 x_article_id out nocopy okc_articles_all.article_id%type,
39 x_article_version_id out nocopy okc_article_versions.article_version_id%type,
40 x_article_status out nocopy okc_article_versions.article_status%type,
41 x_adoption_type out nocopy okc_article_versions.adoption_type%type,
42 x_global_yn out nocopy okc_article_versions.global_yn%type,
43 x_key out nocopy varchar2);
44
45 procedure set_notification( itemtype in varchar2,
46 itemkey in varchar2,
47 actid in number,
48 funcmode in varchar2,
49 resultout out nocopy varchar2);
50
51 procedure set_approver( itemtype in varchar2,
52 itemkey in varchar2,
53 actid in number,
54 funcmode in varchar2,
55 resultout out nocopy varchar2);
56
57 procedure set_notified_list( itemtype in varchar2,
58 itemkey in varchar2,
59 actid in number,
60 funcmode in varchar2,
61 resultout out nocopy varchar2);
62
63 procedure set_notified( itemtype in varchar2,
64 itemkey in varchar2,
65 actid in number,
66 funcmode in varchar2,
67 resultout out nocopy varchar2);
68
69 function get_pending_meaning return varchar2;
70 function get_adopted_meaning return varchar2;
71
72 procedure start_wf_processes(result out nocopy varchar2);
73 procedure start_wf_process( org_id in number,
74 article_version_id in number,
75 result out nocopy varchar2);
76
77 procedure selector( itemtype in varchar2,
78 itemkey in varchar2,
79 actid in number,
80 command in varchar2,
81 resultout in out nocopy varchar2);
82
83 procedure select_process( itemtype in varchar2,
84 itemkey in varchar2,
85 actid in number,
86 command in varchar2,
87 resultout in out nocopy varchar2);
88
89 procedure set_approved( itemtype in varchar2,
90 itemkey in varchar2,
91 actid in number,
92 funcmode in varchar2,
93 resultout out nocopy varchar2);
94
95 procedure set_rejected( itemtype in varchar2,
96 itemkey in varchar2,
97 actid in number,
98 funcmode in varchar2,
99 resultout out nocopy varchar2);
100
101 procedure decrement_counter( itemtype in varchar2,
102 itemkey in varchar2,
103 actid in number,
104 funcmode in varchar2,
105 resultout out nocopy varchar2);
106
107 function validate_article_version( p_search_flow in varchar2,
108 p_article_version_id in number,
109 p_article_status in varchar2,
110 p_org_id in number)
111 return varchar2;
112
113 function validate_article_version( p_article_version_id in number,
114 p_article_status in varchar2,
115 p_org_id in number)
116 return varchar2;
117
118 function pre_submit_validation( p_org_id in number) return varchar2;
119 function pre_submit_validation( p_org_id in number, p_intent in varchar2) return varchar2;
120
121 procedure transfer( itemtype in varchar2,
122 itemkey in varchar2,
123 actid in number,
124 funcmode in varchar2,
125 resultout out nocopy varchar2);
126
127 PROCEDURE orgname( document_id in varchar2,
128 display_type in varchar2,
129 document in out NOCOPY varchar2,
130 document_type in out NOCOPY varchar2);
131
132 PROCEDURE subject( document_id in varchar2,
133 display_type in varchar2,
134 document in out NOCOPY varchar2,
135 document_type in out NOCOPY varchar2);
136
137 function get_intent_pub( art_ver_id in number) return varchar2;
138
139 procedure callback( document_id in varchar2,
140 display_type in varchar2,
141 document in out NOCOPY varchar2,
142 document_type in out NOCOPY varchar2);
143
144 -- bug 5261848 - cr3 start
145 function get_g_article_text(p_org_id number, p_article_version_id number)
146 return okc_article_versions.article_text%type;
147 function get_g_localized_yn(p_org_id number, p_article_version_id number)
148 return varchar2;
149 function get_g_translated_yn(p_article_version_id number)
150 return okc_article_versions.translated_yn%type;
151 function get_g_article_version_id(p_org_id number, p_article_version_id number)
152 return okc_article_versions.article_version_id%type;
153 -- bug 5261848 - cr3 end
154
155 end;