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