DBA Data[Home] [Help]

PACKAGE: APPS.HR_QUEST_ANS_VAL_API

Source


1 Package hr_quest_ans_val_api as
2 /* $Header: hrqsvapi.pkh 120.0 2005/05/31 02:30:37 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< insert_quest_answer_val >--------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:This procedure is the API wrapper procedure to the following
10 --
11 --  RHI: hr_qsv_ins.ins
12 --
13 -- Pre-requisites
14 --
15 --  All 'IN' parameters to this procedure have been appropriately derived.
16 --
17 -- Post Success:
18 --
19 --  p_quest_answer_val_id    will contain the generated or surrogate value.
20 --  p_object_version_number  will contain latest OVN.
21 --
22 -- Post Failure:
23 --
24 --  p_quest_answer_val_id    will contain null
25 --  p_object_version_number  will contain null
26 --
27 -- Access Status:
28 --
29 --  Internal Development use only.
30 --
31 -- {End of comments}
32 --
33 procedure insert_quest_answer_val
34   ( p_validate                       in     boolean  default false
35    ,p_questionnaire_answer_id        in     number
36    ,p_field_id                       in     number
37    ,p_value                          in     varchar2 default null
38    ,p_quest_answer_val_id               out nocopy number
39    ,p_object_version_number             out nocopy number
40   );
41 
42 --
43 -- ----------------------------------------------------------------------------
44 -- |--------------------------< update_quest_answer_val >--------------------------|
45 -- ----------------------------------------------------------------------------
46 -- {Start Of Comments}
47 --
48 -- Description:This procedure is the API wrapper procedure to the following
49 --
50 --  RHI: hr_qsv_upd.upd
51 --
52 -- Pre-requisites
53 --
54 --  All 'IN' parameters to this procedure have been appropriately derived.
55 --
56 -- Post Success:
57 --
58 --  p_object_version_number  will contain latest OVN.
59 --
60 -- Post Failure:
61 
62 --  p_object_version_number with the old one.
63 --
64 -- Access Status:
65 --
66 --  Internal Development use only.
67 --
68 -- {End of comments}
69 --
70 procedure update_quest_answer_val
71   (p_validate                     in     boolean  default false
72   ,p_quest_answer_val_id          in     number
73   ,p_object_version_number        in out nocopy number
74   ,p_value                        in     varchar2 default hr_api.g_varchar2
75   );
76 
77 --
78 -- ----------------------------------------------------------------------------
79 -- |--------------------------< delete_quest_answer_val >--------------------------|
80 -- ----------------------------------------------------------------------------
81 -- {Start Of Comments}
82 --
83 -- Description:This procedure is the API wrapper procedure to the following
84 --
85 --  RHI: hr_qsv_del.del
86 --
87 -- Pre-requisites
88 --
89 --  All 'IN' parameters to this procedure have been appropriately derived.
90 --
91 -- Post Success:
92 --
93 --
94 -- Post Failure:
95 --
96 --
97 --
98 -- Access Status:
99 --
100 --  Internal Development use only.
101 --
102 -- {End of comments}
103 --
104 
105 procedure delete_quest_answer_val
106   (
107    p_validate                      in     boolean  default false
108   ,p_quest_answer_val_id           in     number
109   ,p_object_version_number         in     number
110   );
111 
112 --
113 end hr_quest_ans_val_api;