1 Package pqh_document_attributes_swi AUTHID CURRENT_USER As
2 /* $Header: pqdoaswi.pkh 115.1 2003/03/06 20:36:27 nsanghal noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |-----------------------< create_document_attribute >----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: pqh_document_attributes_api.create_document_attribute
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_attribute
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_document_id in number
30 ,p_attribute_id in number
31 ,p_tag_name in varchar2
32 ,p_document_attribute_id out nocopy number
33 ,p_object_version_number out nocopy number
34 ,p_effective_start_date out nocopy date
35 ,p_effective_end_date out nocopy date
36 ,p_return_status out nocopy varchar2
37 );
38 -- ----------------------------------------------------------------------------
39 -- |-----------------------< delete_document_attribute >----------------------|
40 -- ----------------------------------------------------------------------------
41 -- {Start of comments}
42 --
43 -- Description:
44 -- This procedure is the self-service wrapper procedure to the following
45 -- API: pqh_document_attributes_api.delete_document_attribute
46 --
47 -- Pre-requisites
48 -- All 'IN' parameters to this procedure have been appropriately derived.
49 --
50 -- Post Success:
51 -- p_return_status will return value indicating success.
52 --
53 -- Post Failure:
54 -- p_return_status will return value indication failure.
55 --
56 -- Access Status:
57 -- Internal Development use only.
58 --
59 -- {End of comments}
60 -- ----------------------------------------------------------------------------
61 PROCEDURE delete_document_attribute
62 (p_validate in number default hr_api.g_false_num
63 ,p_effective_date in date
64 ,p_datetrack_mode in varchar2
65 ,p_document_attribute_id in number
66 ,p_object_version_number in out nocopy number
67 ,p_effective_start_date out nocopy date
68 ,p_effective_end_date out nocopy date
69 ,p_return_status out nocopy varchar2
70 );
71 -- ----------------------------------------------------------------------------
72 -- |-----------------------< update_document_attribute >----------------------|
73 -- ----------------------------------------------------------------------------
74 -- {Start of comments}
75 --
76 -- Description:
77 -- This procedure is the self-service wrapper procedure to the following
78 -- API: pqh_document_attributes_api.update_document_attribute
79 --
80 -- Pre-requisites
81 -- All 'IN' parameters to this procedure have been appropriately derived.
82 --
83 -- Post Success:
84 -- p_return_status will return value indicating success.
85 --
86 -- Post Failure:
87 -- p_return_status will return value indication failure.
88 --
89 -- Access Status:
90 -- Internal Development use only.
91 --
92 -- {End of comments}
93 -- ----------------------------------------------------------------------------
94 PROCEDURE update_document_attribute
95 (p_validate in number default hr_api.g_false_num
96 ,p_effective_date in date
97 ,p_datetrack_mode in varchar2
98 ,p_document_attribute_id in number
99 ,p_object_version_number in out NOCOPY number
100 ,p_document_id in number default hr_api.g_number
101 ,p_attribute_id in number default hr_api.g_number
102 ,p_tag_name in varchar2 default hr_api.g_varchar2
103 ,p_effective_start_date out NOCOPY date
104 ,p_effective_end_date out NOCOPY date
105 ,p_return_status out NOCOPY varchar2
106 );
107 end pqh_document_attributes_swi;
[Home] [Help]