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