1 Package ota_nhs_ins AUTHID CURRENT_USER as
2 /* $Header: otnhsrhi.pkh 120.0 2005/05/29 07:26:54 appldev noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------< set_base_key_value >----------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of Comments}
7 -- Description:
8 -- This procedure is called to register the next ID value from the database
9 -- sequence.
10 --
11 -- Prerequisites:
12 --
13 -- In Parameters:
14 -- Primary Key
15 --
16 -- Post Success:
17 --
18 -- Post Failure:
19 --
20 -- Developer Implementation Notes:
21 -- None.
22 --
23 -- Access Status:
24 -- Internal Development Use Only.
25 --
26 -- {End of Comments}
27 -- ----------------------------------------------------------------------------
28 procedure set_base_key_value
29 (p_nota_history_id in number);
30 --
31
32 --
33 -- ----------------------------------------------------------------------------
34 -- |---------------------------------< ins >----------------------------------|
35 -- ----------------------------------------------------------------------------
36 -- {Start Of Comments}
37 --
38 -- Description:
39 -- This procedure is the record interface for the insert process
40 -- for the specified entity. The role of this process is to insert a fully
41 -- validated row, into the HR schema passing back to the calling process,
42 -- any system generated values (e.g. primary and object version number
43 -- attributes). This process is the main backbone of the ins
44 -- process. The processing of this procedure is as follows:
45 -- 1) The controlling validation process insert_validate is executed
46 -- which will execute all private and public validation business rule
47 -- processes.
48 -- 2) The pre_insert business process is then executed which enables any
49 -- logic to be processed before the insert dml process is executed.
50 -- 3) The insert_dml process will physical perform the insert dml into the
51 -- specified entity.
52 -- 4) The post_insert business process is then executed which enables any
53 -- logic to be processed after the insert dml process.
54 --
55 -- Prerequisites:
56 -- The main parameters to the this process have to be in the record
57 -- format.
58 --
59 -- In Parameters:
60 --
61 -- Post Success:
62 -- A fully validated row will be inserted into the specified entity
63 -- without being committed.
64 --
65 -- Post Failure:
66 -- If an error has occurred, an error message will be supplied with the work
67 -- rolled back.
68 --
69 -- Developer Implementation Notes:
70 -- None.
71 --
72 -- Access Status:
73 -- Internal Development Use Only.
74 --
75 -- {End Of Comments}
76 -- ----------------------------------------------------------------------------
77 Procedure ins
78 (p_effective_date in date,
79 p_rec in out nocopy ota_nhs_shd.g_rec_type
80 );
81 --
82 -- ----------------------------------------------------------------------------
83 -- |---------------------------------< ins >----------------------------------|
84 -- ----------------------------------------------------------------------------
85 -- {Start Of Comments}
86 --
87 -- Description:
88 -- This procedure is the attribute interface for the insert
89 -- process for the specified entity and is the outermost layer. The role
90 -- of this process is to insert a fully validated row into the HR schema
91 -- passing back to the calling process, any system generated values
92 -- (e.g. object version number attributes).The processing of this
93 -- procedure is as follows:
94 -- 1) The attributes are converted into a local record structure by
95 -- calling the convert_args function.
96 -- 2) After the conversion has taken place, the corresponding record ins
97 -- interface process is executed.
98 -- 3) OUT parameters are then set to their corresponding record attributes.
99 --
100 -- Prerequisites:
101 --
102 -- In Parameters:
103 --
104 -- Post Success:
105 -- A fully validated row will be inserted for the specified entity
106 -- without being committed.
107 --
108 -- Post Failure:
109 -- If an error has occurred, an error message will be supplied with the work
110 -- rolled back.
111 --
112 -- Developer Implementation Notes:
113 -- None.
114 --
115 -- Access Status:
116 -- Internal Development Use Only.
117 --
118 -- {End Of Comments}
119 -- ----------------------------------------------------------------------------
120 Procedure ins
121 (p_effective_date in date,
122 p_nota_history_id out nocopy number,
123 p_person_id in number,
124 p_contact_id in number default null,
125 p_trng_title in varchar2,
126 p_provider in varchar2 default null,
127 p_type in varchar2 default null,
128 p_centre in varchar2 default null,
129 p_completion_date in date,
130 p_award in varchar2 default null,
131 p_rating in varchar2 default null,
132 p_duration in number default null,
133 p_duration_units in varchar2 default null,
134 p_activity_version_id in number default null,
135 p_status in varchar2,
136 p_verified_by_id in number default null,
137 p_nth_information_category in varchar2 default null,
138 p_nth_information1 in varchar2 default null,
139 p_nth_information2 in varchar2 default null,
140 p_nth_information3 in varchar2 default null,
141 p_nth_information4 in varchar2 default null,
142 p_nth_information5 in varchar2 default null,
143 p_nth_information6 in varchar2 default null,
144 p_nth_information7 in varchar2 default null,
145 p_nth_information8 in varchar2 default null,
146 p_nth_information9 in varchar2 default null,
147 p_nth_information10 in varchar2 default null,
148 p_nth_information11 in varchar2 default null,
149 p_nth_information12 in varchar2 default null,
150 p_nth_information13 in varchar2 default null,
151 p_nth_information15 in varchar2 default null,
152 p_nth_information16 in varchar2 default null,
153 p_nth_information17 in varchar2 default null,
154 p_nth_information18 in varchar2 default null,
155 p_nth_information19 in varchar2 default null,
156 p_nth_information20 in varchar2 default null,
157 p_org_id in number default null,
158 p_object_version_number out nocopy number,
159 p_business_group_id in number,
160 p_nth_information14 in varchar2 default null,
161 p_customer_id in number default null,
162 p_organization_id in number default null
163 );
164 --
165 end ota_nhs_ins;