1 Package pqh_documents_api as
2 /* $Header: pqdocapi.pkh 120.1 2005/09/15 14:14:40 rthiagar noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------<CREATE_PRINT_DOCUMENT>--------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 --
18 --
19 -- Post Success:
20 --
21 --
22 -- Name Type Description
23 --
24 -- Post Failure:
25 --
26 --
27 -- Access Status:
28 -- Public.
29 --
30 -- {End Of Comments}
31 --
32 procedure create_print_document
33 (p_validate in boolean default false
34 ,p_effective_date in date
35 ,p_short_name in varchar2
36 ,p_document_name in varchar2
37 ,p_file_id in number
38 ,p_formula_id in number
39 ,p_enable_flag in varchar2
40 ,p_document_category in varchar2
41 ,p_document_id out NOCOPY number
42 ,p_object_version_number out NOCOPY number
43 ,p_effective_start_date out NOCOPY date
44 ,p_effective_end_date out NOCOPY date
45 /* Added for XDO changes */
46 ,p_lob_code in varchar2
47 ,p_language in varchar2
48 ,p_territory in varchar2
49 );
50 --
51 -- ----------------------------------------------------------------------------
52 -- |--------------------------<CREATE_DOCUMENT>--------------------------|
53 -- ----------------------------------------------------------------------------
54 --
55 procedure create_document
56 (p_validate in boolean default false
57 ,p_effective_date in date
58 ,p_short_name in varchar2
59 ,p_document_name in varchar2
60 ,p_file_id in number
61 ,p_formula_id in number
62 ,p_enable_flag in varchar2
63 ,p_document_category in varchar2
64 ,p_document_id out NOCOPY number
65 ,p_object_version_number out NOCOPY number
66 ,p_effective_start_date out NOCOPY date
67 ,p_effective_end_date out NOCOPY date
68 /* Added for XDO changes */
69 ,p_lob_code in varchar2
70 ,p_language in varchar2
71 ,p_territory in varchar2
72 );
73 --
74 -- ----------------------------------------------------------------------------
75 -- |--------------------------<UPDATE_PRINT_DOCUMENT>--------------------------|
76 -- ----------------------------------------------------------------------------
77 -- {Start Of Comments}
78 --
79 -- Description:
80 --
81 --
82 -- Prerequisites:
83 --
84 --
85 -- In Parameters:
86 -- Name Reqd Type Description
87 --
88 --
89 -- Post Success:
90 --
91 --
92 -- Name Type Description
93 --
94 -- Post Failure:
95 --
96 --
97 -- Access Status:
98 -- Public.
99 --
100 -- {End Of Comments}
101 --
102 procedure update_print_document
103 (p_validate in boolean default false
104 ,p_effective_date in date
105 ,p_datetrack_mode in varchar2
106 ,p_short_name in varchar2 default hr_api.g_varchar2
107 ,p_document_name in varchar2 default hr_api.g_varchar2
108 ,p_file_id in number default hr_api.g_number
109 ,p_formula_id in number default hr_api.g_number
110 ,p_enable_flag in varchar2 default hr_api.g_varchar2
111 ,p_document_category in varchar2 default hr_api.g_varchar2
112 ,p_document_id in number
113 ,p_object_version_number in OUT NOCOPY number
114 ,p_effective_start_date OUT NOCOPY date
115 ,p_effective_end_date OUT NOCOPY date
116 /* Added for XDO changes */
117 ,p_lob_code in varchar2
118 ,p_language in varchar2
119 ,p_territory in varchar2
120 );
121 --
122 -- ----------------------------------------------------------------------------
123 -- |--------------------------<UPDATE_DOCUMENT>--------------------------|
124 -- ----------------------------------------------------------------------------
125 --
126 procedure update_document
127 (p_validate in boolean default false
128 ,p_effective_date in date
129 ,p_datetrack_mode in varchar2
130 ,p_short_name in varchar2 default hr_api.g_varchar2
131 ,p_document_name in varchar2 default hr_api.g_varchar2
132 ,p_file_id in number default hr_api.g_number
133 ,p_formula_id in number default hr_api.g_number
134 ,p_enable_flag in varchar2 default hr_api.g_varchar2
135 ,p_document_category in varchar2 default hr_api.g_varchar2
136 ,p_document_id in number
137 ,p_object_version_number in OUT NOCOPY number
138 ,p_effective_start_date OUT NOCOPY date
139 ,p_effective_end_date OUT NOCOPY date
140 /* Added for XDO changes */
141 ,p_lob_code in varchar2
142 ,p_language in varchar2
143 ,p_territory in varchar2
144 );
145 -- ----------------------------------------------------------------------------
146 -- |--------------------------<DELETE_PRINT_DOCUMENT>--------------------------|
147 -- ----------------------------------------------------------------------------
148 -- {Start Of Comments}
149 --
150 -- Description:
151 --
152 --
153 -- Prerequisites:
154 --
155 --
156 -- In Parameters:
157 -- Name Reqd Type Description
158 --
159 --
160 -- Post Success:
161 --
162 --
163 -- Name Type Description
164 --
165 -- Post Failure:
166 --
167 --
168 -- Access Status:
169 -- Public.
170 --
171 -- {End Of Comments}
172 --
173 procedure delete_print_document
174 (p_validate in boolean default false
175 ,p_effective_date in date
176 ,p_datetrack_mode in varchar2
177 ,p_document_id in number
178 ,p_object_version_number in OUT NOCOPY number
179 ,p_effective_start_date OUT NOCOPY date
180 ,p_effective_end_date OUT NOCOPY date
181 );
182 --
183 -- ----------------------------------------------------------------------------
184 -- |--------------------------<DELETE_DOCUMENT>--------------------------|
185 -- ----------------------------------------------------------------------------
186 procedure delete_document
187 (p_validate in boolean default false
188 ,p_effective_date in date
189 ,p_datetrack_mode in varchar2
190 ,p_document_id in number
191 ,p_object_version_number in OUT NOCOPY number
192 ,p_effective_start_date OUT NOCOPY date
193 ,p_effective_end_date OUT NOCOPY date
194 );
195 --
196 end pqh_documents_api;