1 Package hxc_hts_bus AUTHID CURRENT_USER as
2 /* $Header: hxchtsrhi.pkh 120.0 2005/05/29 05:44:35 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-----------------------< chk_name >---------------------------------------|
6 -- ----------------------------------------------------------------------------
7 -- Description:
8 -- This procedure insures a valid time source name
9 --
10 -- Pre Conditions:
11 -- None
12 --
13 -- In Arguments:
14 -- name
15 -- time_source_id
16 --
17 -- Post Success:
18 -- Processing continues if the name business rules have not been violated
19 --
20 -- Post Failure:
21 -- An application error is raised if the name is not valid
22 --
23 -- ----------------------------------------------------------------------------
24 Procedure chk_name
25 (
26 p_name in hxc_time_sources.name%TYPE
27 ,p_time_source_id in hxc_time_sources.time_source_id%TYPE
28 );
29 --
30 -- ----------------------------------------------------------------------------
31 -- |-----------------------< chk_delete >-------------------------------------|
32 -- ----------------------------------------------------------------------------
33 -- {Start Of Comments}
34 --
35 -- Description:
36 -- This procedure carries out delete time referential integrity checks
37 -- to ensure that a time source is not being used
38 -- in approvals or retrieval areas
39 --
40 -- Pre Conditions:
41 -- None
42 --
43 -- In Arguments:
44 -- time_source_id
45 --
46 -- Post Success:
47 -- Processing continues if the name is not being referenced
48 --
49 -- Post Failure:
50 -- An application error is raised if the rule is being used.
51 --
52 -- {End Of Comments}
53 -- ----------------------------------------------------------------------------
54 Procedure chk_delete
55 (
56 p_time_source_id in hxc_time_sources.time_source_id%TYPE
57 );
58 --
59 -- ----------------------------------------------------------------------------
60 -- |---------------------------< insert_validate >----------------------------|
61 -- ----------------------------------------------------------------------------
62 -- {Start of comments}
63 --
64 -- Description:
65 -- This procedure controls the execution of all insert business rules
66 -- validation.
67 --
68 -- Prerequisites:
69 -- This private procedure is called from ins procedure.
70 --
71 -- In Parameters:
72 -- A Pl/Sql record structure.
73 --
74 -- Post Success:
75 -- Processing continues.
76 --
77 -- Post Failure:
78 -- If a business rules fails the error will not be handled by this procedure
79 -- unless explicity coded.
80 --
81 -- Developer Implementation Notes:
82 -- For insert, your business rules should be executed from this procedure and
83 -- should ideally (unless really necessary) just be straight procedure or
84 -- function calls. Try and avoid using conditional branching logic.
85 --
86 -- Access Status:
87 -- Internal Row Handler Use Only.
88 --
89 -- {End of comments}
90 -- ----------------------------------------------------------------------------
91 Procedure insert_validate
92 (p_effective_date in date
93 ,p_rec in hxc_hts_shd.g_rec_type
94 );
95 --
96 -- ----------------------------------------------------------------------------
97 -- |---------------------------< update_validate >----------------------------|
98 -- ----------------------------------------------------------------------------
99 -- {Start Of Comments}
100 --
101 -- Description:
102 -- This procedure controls the execution of all update business rules
103 -- validation.
104 --
105 -- Prerequisites:
106 -- This private procedure is called from upd procedure.
107 --
108 -- In Parameters:
109 -- A Pl/Sql record structure.
110 --
111 -- Post Success:
112 -- Processing continues.
113 --
114 -- Post Failure:
115 -- If a business rules fails the error will not be handled by this procedure
116 -- unless explicity coded.
117 --
118 -- Developer Implementation Notes:
119 -- For update, your business rules should be executed from this procedure and
120 -- should ideally (unless really necessary) just be straight procedure or
121 -- function calls. Try and avoid using conditional branching logic.
122 --
123 -- Access Status:
124 -- Internal Row Handler Use Only.
125 --
126 -- {End Of Comments}
127 -- ----------------------------------------------------------------------------
128 Procedure update_validate
129 (p_effective_date in date
130 ,p_rec in hxc_hts_shd.g_rec_type
131 );
132 --
133 -- ----------------------------------------------------------------------------
134 -- |---------------------------< delete_validate >----------------------------|
135 -- ----------------------------------------------------------------------------
136 -- {Start Of Comments}
137 --
138 -- Description:
139 -- This procedure controls the execution of all delete business rules
140 -- validation.
141 --
142 -- Prerequisites:
143 -- This private procedure is called from del procedure.
144 --
145 -- In Parameters:
146 -- A Pl/Sql record structure.
147 --
148 -- Post Success:
149 -- Processing continues.
150 --
151 -- Post Failure:
152 -- If a business rules fails the error will not be handled by this procedure
153 -- unless explicity coded.
154 --
155 -- Developer Implementation Notes:
156 -- For delete, your business rules should be executed from this procedure and
157 -- should ideally (unless really necessary) just be straight procedure or
158 -- function calls. Try and avoid using conditional branching logic.
159 --
160 -- Access Status:
161 -- Internal Row Handler Use Only.
162 --
163 -- {End Of Comments}
164 -- ----------------------------------------------------------------------------
165 Procedure delete_validate
166 (p_rec in hxc_hts_shd.g_rec_type
167 );
168 --
169 end hxc_hts_bus;