1 Package pqh_documents_swi As
2 /* $Header: pqdocswi.pkh 120.1 2005/09/15 14:17:22 rthiagar noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------------< create_document >---------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: pqh_documents_api.create_document
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_document
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_short_name in varchar2
30 ,p_document_name in varchar2
31 ,p_file_id in number
32 ,p_formula_id in number
33 ,p_enable_flag in varchar2
34 ,p_document_category in varchar2
35 ,p_document_id out nocopy number
36 ,p_object_version_number out nocopy number
37 ,p_effective_start_date out nocopy date
38 ,p_effective_end_date out nocopy date
39 ,p_return_status out nocopy varchar2
40 /* Added for XDO changes */
41 ,p_lob_code in varchar2
42 ,p_language in varchar2
43 ,p_territory in varchar2
44 );
45 -- ----------------------------------------------------------------------------
46 -- |----------------------------< delete_document >---------------------------|
47 -- ----------------------------------------------------------------------------
48 -- {Start of comments}
49 --
50 -- Description:
51 -- This procedure is the self-service wrapper procedure to the following
52 -- API: pqh_documents_api.delete_document
53 --
54 -- Pre-requisites
55 -- All 'IN' parameters to this procedure have been appropriately derived.
56 --
57 -- Post Success:
58 -- p_return_status will return value indicating success.
59 --
60 -- Post Failure:
61 -- p_return_status will return value indication failure.
62 --
63 -- Access Status:
64 -- Internal Development use only.
65 --
66 -- {End of comments}
67 -- ----------------------------------------------------------------------------
68 PROCEDURE delete_document
69 (p_validate in number default hr_api.g_false_num
70 ,p_effective_date in date
71 ,p_datetrack_mode in varchar2
72 ,p_document_id in number
73 ,p_object_version_number in out nocopy number
74 ,p_effective_start_date out nocopy date
75 ,p_effective_end_date out nocopy date
76 ,p_return_status out nocopy varchar2
77 );
78 -- ----------------------------------------------------------------------------
79 -- |----------------------------< update_document >---------------------------|
80 -- ----------------------------------------------------------------------------
81 -- {Start of comments}
82 --
83 -- Description:
84 -- This procedure is the self-service wrapper procedure to the following
85 -- API: pqh_documents_api.update_document
86 --
87 -- Pre-requisites
88 -- All 'IN' parameters to this procedure have been appropriately derived.
89 --
90 -- Post Success:
91 -- p_return_status will return value indicating success.
92 --
93 -- Post Failure:
94 -- p_return_status will return value indication failure.
95 --
96 -- Access Status:
97 -- Internal Development use only.
98 --
99 -- {End of comments}
100 -- ----------------------------------------------------------------------------
101 PROCEDURE update_document
102 (p_validate in number default hr_api.g_false_num
103 ,p_effective_date in date
104 ,p_datetrack_mode in varchar2
105 ,p_short_name in varchar2 default hr_api.g_varchar2
106 ,p_document_name in varchar2 default hr_api.g_varchar2
107 ,p_file_id in number default hr_api.g_number
108 ,p_formula_id in number default hr_api.g_number
109 ,p_enable_flag in varchar2 default hr_api.g_varchar2
110 ,p_document_category in varchar2 default hr_api.g_varchar2
111 ,p_document_id in number
112 ,p_object_version_number in out NOCOPY number
113 ,p_effective_start_date out NOCOPY date
114 ,p_effective_end_date out NOCOPY date
115 ,p_return_status out NOCOPY varchar2
116 /* Added for XDO changes */
117 ,p_lob_code in varchar2
118 ,p_language in varchar2
119 ,p_territory in varchar2
120 );
121 end pqh_documents_swi;