1 Package pqh_de_result_sets_swi AUTHID CURRENT_USER As
2 /* $Header: pqrssswi.pkh 115.2 2002/12/03 20:43:27 rpasapul noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |--------------------------< delete_result_sets >--------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: pqh_de_result_sets_api.delete_result_sets
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_result_sets
27 (p_validate in number default hr_api.g_false_num
28 ,p_result_set_id in number
29 ,p_object_version_number in number
30 ,p_return_status out nocopy varchar2
31 );
32 -- ----------------------------------------------------------------------------
33 -- |--------------------------< insert_result_sets >--------------------------|
34 -- ----------------------------------------------------------------------------
35 -- {Start of comments}
36 --
37 -- Description:
38 -- This procedure is the self-service wrapper procedure to the following
39 -- API: pqh_de_result_sets_api.insert_result_sets
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_result_sets
56 (p_validate in number default hr_api.g_false_num
57 ,p_effective_date in date
58 ,p_gradual_value_number_from in number
59 ,p_gradual_value_number_to in number
60 ,p_grade_id in number
61 ,p_result_set_id out nocopy number
62 ,p_object_version_number out nocopy number
63 ,p_return_status out nocopy varchar2
64 );
65 -- ----------------------------------------------------------------------------
66 -- |--------------------------< update_result_sets >--------------------------|
67 -- ----------------------------------------------------------------------------
68 -- {Start of comments}
69 --
70 -- Description:
71 -- This procedure is the self-service wrapper procedure to the following
72 -- API: pqh_de_result_sets_api.update_result_sets
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_result_sets
89 (p_validate in number default hr_api.g_false_num
90 ,p_effective_date in date
91 ,p_result_set_id in number
92 ,p_object_version_number in out nocopy number
93 ,p_gradual_value_number_from in number default hr_api.g_number
94 ,p_gradual_value_number_to in number default hr_api.g_number
95 ,p_grade_id in number default hr_api.g_number
96 ,p_return_status out nocopy varchar2
97 );
98 end pqh_de_result_sets_swi;
[Home] [Help]