1 Package pqh_de_operation_groups_swi AUTHID CURRENT_USER As
2 /* $Header: pqopgswi.pkh 115.1 2002/12/03 00:09:21 rpasapul noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------< delete_operation_groups >-----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: pqh_de_operation_groups_api.delete_operation_groups
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_operation_groups
27 (p_validate in number default hr_api.g_false_num
28 ,p_operation_group_id in number
29 ,p_object_version_number in number
30 ,p_return_status out nocopy varchar2
31 );
32 -- ----------------------------------------------------------------------------
33 -- |------------------------< insert_operation_groups >-----------------------|
34 -- ----------------------------------------------------------------------------
35 -- {Start of comments}
36 --
37 -- Description:
38 -- This procedure is the self-service wrapper procedure to the following
39 -- API: pqh_de_operation_groups_api.insert_operation_groups
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_operation_groups
56 (p_validate in number default hr_api.g_false_num
57 ,p_effective_date in date
58 ,p_operation_group_code in varchar2
59 ,p_description in varchar2
60 ,p_business_group_id in number
61 ,p_operation_group_id out nocopy number
62 ,p_object_version_number out nocopy number
63 ,p_return_status out nocopy varchar2
64 );
65 -- ----------------------------------------------------------------------------
66 -- |------------------------< update_operation_groups >-----------------------|
67 -- ----------------------------------------------------------------------------
68 -- {Start of comments}
69 --
70 -- Description:
71 -- This procedure is the self-service wrapper procedure to the following
72 -- API: pqh_de_operation_groups_api.update_operation_groups
73 --
74 -- Pre-requisites
75 -- All 'IN' parameters to this procedure have been appropriately derived.
76 --
77 -- Post Success:
78 -- p_return_status will return value indicating success.
79 --
80 -- Post Failure:
81 -- p_return_status will return value indication failure.
82 --
83 -- Access Status:
84 -- Internal Development use only.
85 --
86 -- {End of comments}
87 -- ----------------------------------------------------------------------------
88 PROCEDURE update_operation_groups
89 (p_validate in number default hr_api.g_false_num
90 ,p_effective_date in date
91 ,p_operation_group_id in number
92 ,p_object_version_number in out nocopy number
93 ,p_operation_group_code in varchar2 default hr_api.g_varchar2
94 ,p_description in varchar2 default hr_api.g_varchar2
95 ,p_business_group_id in number default hr_api.g_number
96 ,p_return_status out nocopy varchar2
97 );
98 end pqh_de_operation_groups_swi;