1 Package pay_user_column_instance_swi As
2 /* $Header: pypciswi.pkh 120.0 2005/05/29 07:24 appldev noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------< create_user_column_instance >---------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: pay_user_column_instance_api.create_user_column_instance
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_user_column_instance
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_user_row_id in number
30 ,p_user_column_id in number
31 ,p_value in varchar2 default null
32 ,p_business_group_id in number default null
33 ,p_legislation_code in varchar2 default null
34 ,p_user_column_instance_id out nocopy number
35 ,p_object_version_number out nocopy number
36 ,p_effective_start_date out nocopy date
37 ,p_effective_end_date out nocopy date
38 ,p_return_status out nocopy varchar2
39
40 );
41 -- ----------------------------------------------------------------------------
42 -- |----------------------< update_user_column_instance >---------------------|
43 -- ----------------------------------------------------------------------------
44 -- {Start of comments}
45 --
46 -- Description:
47 -- This procedure is the self-service wrapper procedure to the following
48 -- API: pay_user_column_instance_api.update_user_column_instance
49 --
50 -- Pre-requisites
51 -- All 'IN' parameters to this procedure have been appropriately derived.
52 --
53 -- Post Success:
54 -- p_return_status will return value indicating success.
55 --
56 -- Post Failure:
57 -- p_return_status will return value indication failure.
58 --
59 -- Access Status:
60 -- Internal Development use only.
61 --
62 -- {End of comments}
63 -- ----------------------------------------------------------------------------
64 PROCEDURE update_user_column_instance
65 (p_validate in number default hr_api.g_false_num
66 ,p_effective_date in date
67 ,p_user_column_instance_id in number
68 ,p_datetrack_update_mode in varchar2
69 ,p_value in varchar2 default hr_api.g_varchar2
70 ,p_object_version_number in out nocopy number
71 ,p_effective_start_date out nocopy date
72 ,p_effective_end_date out nocopy date
73 ,p_return_status out nocopy varchar2
74 );
75 -- ----------------------------------------------------------------------------
76 -- |----------------------< delete_user_column_instance >---------------------|
77 -- ----------------------------------------------------------------------------
78 -- {Start of comments}
79 --
80 -- Description:
81 -- This procedure is the self-service wrapper procedure to the following
82 -- API: pay_user_column_instance_api.delete_user_column_instance
83 --
84 -- Pre-requisites
85 -- All 'IN' parameters to this procedure have been appropriately derived.
86 --
87 -- Post Success:
88 -- p_return_status will return value indicating success.
89 --
90 -- Post Failure:
91 -- p_return_status will return value indication failure.
92 --
93 -- Access Status:
94 -- Internal Development use only.
95 --
96 -- {End of comments}
97 -- ----------------------------------------------------------------------------
98 PROCEDURE delete_user_column_instance
99 (p_validate in number default hr_api.g_false_num
100 ,p_effective_date in date
101 ,p_user_column_instance_id in number
102 ,p_datetrack_update_mode in varchar2
103 ,p_object_version_number in out nocopy number
104 ,p_effective_start_date out nocopy date
105 ,p_effective_end_date out nocopy date
106 ,p_return_status out nocopy varchar2
107 );
108 end pay_user_column_instance_swi;