DBA Data[Home] [Help]

PACKAGE: APPS.PQH_DOCUMENT_ATTRIBUTES_API

Source


1 Package pqh_document_attributes_api AUTHID CURRENT_USER as
2 /* $Header: pqdoaapi.pkh 120.0 2005/05/29 01:48:50 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------<CREATE_DOCUMENT_ATTRIBUTE>--------------------------|
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_DOCUMENT_ATTRIBUTE
33     (p_validate                       in     boolean  default false
34     ,p_effective_date                 in     date
35     ,p_document_id                    in     number
36     ,p_attribute_id                   in     number
37     ,p_tag_name                       in     varchar2
38     ,p_document_attribute_id             out NOCOPY 	number
39     ,p_object_version_number             out NOCOPY	number
40     ,p_effective_start_date              out NOCOPY	date
41     ,p_effective_end_date                out NOCOPY	date
42     );
43 --
44 -- ----------------------------------------------------------------------------
45 -- |--------------------------<UPDATE_DOCUMENT_ATTRIBUTE>--------------------------|
46 -- ----------------------------------------------------------------------------
47 -- {Start Of Comments}
48 --
49 -- Description:
50 --
51 --
52 -- Prerequisites:
53 --
54 --
55 -- In Parameters:
56 --   Name                           Reqd Type     Description
57 --
58 --
59 -- Post Success:
60 --
61 --
62 --   Name                           Type     Description
63 --
64 -- Post Failure:
65 --
66 --
67 -- Access Status:
68 --   Public.
69 --
70 -- {End Of Comments}
71 --
72 procedure update_document_attribute
73     (p_validate                     in     boolean  default false
74     ,p_effective_date               in     date
75     ,p_datetrack_mode               in     varchar2
76     ,p_document_attribute_id        in     number
77     ,p_object_version_number        in OUT NOCOPY number
78     ,p_document_id                  in     number    default hr_api.g_number
79     ,p_attribute_id                 in     number    default hr_api.g_number
80     ,p_tag_name                     in     varchar2  default hr_api.g_varchar2
81     ,p_effective_start_date            OUT NOCOPY date
82     ,p_effective_end_date              OUT NOCOPY date
83     );
84 
85 -- ----------------------------------------------------------------------------
86 -- |--------------------------<DELETE_DOCUMENT_ATTRIBUTE>--------------------------|
87 -- ----------------------------------------------------------------------------
88 -- {Start Of Comments}
89 --
90 -- Description:
91 --
92 --
93 -- Prerequisites:
94 --
95 --
96 -- In Parameters:
97 --   Name                           Reqd Type     Description
98 --
99 --
100 -- Post Success:
101 --
102 --
103 --   Name                           Type     Description
104 --
105 -- Post Failure:
106 --
107 --
108 -- Access Status:
109 --   Public.
110 --
111 -- {End Of Comments}
112 --
113 procedure delete_document_attribute
114   (p_validate                       in     boolean  default false
115   ,p_effective_date                 in     date
116   ,p_datetrack_mode                 in     varchar2
117   ,p_document_attribute_id          in     number
118   ,p_object_version_number          in OUT NOCOPY     number
119   ,p_effective_start_date           OUT    NOCOPY     date
120   ,p_effective_end_date     	    OUT    NOCOPY     date
121   );
122 --
123 
124 end pqh_document_attributes_api;