1 Package pay_user_column_swi As
2 /* $Header: pypucswi.pkh 120.0 2005/05/29 07:59 appldev noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |--------------------------< create_user_column >--------------------------|
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_api.create_user_column
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
27 (
28 p_validate in number default hr_api.g_false_num
29 ,p_business_group_id in number default null
30 ,p_legislation_code in varchar2 default null
31 ,p_user_table_id in number
32 ,p_formula_id in number default null
33 ,p_user_column_name in varchar2
34 ,p_user_column_id out nocopy number
35 ,p_object_version_number out nocopy number
36 ,p_return_status out nocopy varchar2
37
38 );
39 -- ----------------------------------------------------------------------------
40 -- |--------------------------< update_user_column >--------------------------|
41 -- ----------------------------------------------------------------------------
42 -- {Start of comments}
43 --
44 -- Description:
45 -- This procedure is the self-service wrapper procedure to the following
46 -- API: pay_user_column_api.update_user_column
47 --
48 -- Pre-requisites
49 -- All 'IN' parameters to this procedure have been appropriately derived.
50 --
51 -- Post Success:
52 -- p_return_status will return value indicating success.
53 --
54 -- Post Failure:
55 -- p_return_status will return value indication failure.
56 --
57 -- Access Status:
58 -- Internal Development use only.
59 --
60 -- {End of comments}
61 -- ----------------------------------------------------------------------------
62 PROCEDURE update_user_column
63 (p_validate in number default hr_api.g_false_num
64 ,p_user_column_id in number
65 ,p_user_column_name in varchar2 default hr_api.g_varchar2
66 ,p_formula_id in number default hr_api.g_number
67 ,p_object_version_number in out nocopy number
68 ,p_return_status out nocopy varchar2
69
70 );
71 -- ----------------------------------------------------------------------------
72 -- |--------------------------< delete_user_column >--------------------------|
73 -- ----------------------------------------------------------------------------
74 -- {Start of comments}
75 --
76 -- Description:
77 -- This procedure is the self-service wrapper procedure to the following
78 -- API: pay_user_column_api.delete_user_column
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 delete_user_column
95 (p_validate in number default hr_api.g_false_num
96 ,p_user_column_id in number
97 ,p_object_version_number in out nocopy number
98 ,p_return_status out nocopy varchar2
99
100 );
101 end pay_user_column_swi;