1 Package pqh_rap_bus as
2 /* $Header: pqraprhi.pkh 120.0 2005/05/29 02:24 appldev noship $ */
3 --
4 -- ---------------------------------------------------------------------------
5 -- |----------------------< set_security_group_id >--------------------------|
6 -- ---------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- The procedure is not define as it is calling parent procedure in the
11 -- insert_validate and update_validate procedures.
12 --
13 -- {End Of Comments}
14 -- ---------------------------------------------------------------------------
15 --
16 -- ---------------------------------------------------------------------------
17 -- |---------------------< return_legislation_code >-------------------------|
18 -- ---------------------------------------------------------------------------
19 -- {Start Of Comments}
20 --
21 -- Description:
22 -- Return the legislation code for a specific primary key value
23 --
24 -- Prerequisites:
25 -- The primary key identified by p_rank_process_approval_id
26 -- already exists.
27 --
28 -- In Arguments:
29 -- p_rank_process_approval_id
30 --
31 --
32 -- Post Success:
33 -- The business group's legislation code will be returned.
34 --
35 -- Post Failure:
36 -- An error is raised if the value does not exist.
37 --
38 -- Access Status:
39 -- Internal Development Use Only.
40 --
41 -- {End Of Comments}
42 -- ---------------------------------------------------------------------------
43 FUNCTION return_legislation_code
44 (p_rank_process_approval_id in number
45 ) RETURN varchar2;
46 --
47 --
48 -- ----------------------------------------------------------------------------
49 -- |---------------------------< insert_validate >----------------------------|
50 -- ----------------------------------------------------------------------------
51 -- {Start of comments}
52 --
53 -- Description:
54 -- This procedure controls the execution of all insert business rules
55 -- validation.
56 --
57 -- Prerequisites:
58 -- This private procedure is called from ins procedure.
59 --
60 -- In Parameters:
61 -- A Pl/Sql record structure.
62 --
63 -- Post Success:
64 -- Processing continues.
65 --
66 -- Post Failure:
67 -- If a business rules fails the error will not be handled by this procedure
68 -- unless explicity coded.
69 --
70 -- Developer Implementation Notes:
71 -- For insert, your business rules should be executed from this procedure
72 -- and should ideally (unless really necessary) just be straight procedure
73 -- or function calls. Try and avoid using conditional branching logic.
74 --
75 -- Access Status:
76 -- Internal Row Handler Use Only.
77 --
78 -- {End of comments}
79 -- ----------------------------------------------------------------------------
80 Procedure insert_validate
81 (p_effective_date in date
82 ,p_rec in pqh_rap_shd.g_rec_type
83 );
84 --
85 -- ----------------------------------------------------------------------------
86 -- |---------------------------< update_validate >----------------------------|
87 -- ----------------------------------------------------------------------------
88 -- {Start Of Comments}
89 --
90 -- Description:
91 -- This procedure controls the execution of all update business rules
92 -- validation.
93 --
94 -- Prerequisites:
95 -- This private procedure is called from upd procedure.
96 --
97 -- In Parameters:
98 -- A Pl/Sql record structure.
99 --
100 -- Post Success:
101 -- Processing continues.
102 --
103 -- Post Failure:
104 -- If a business rules fails the error will not be handled by this procedure
105 -- unless explicity coded.
106 --
107 -- Access Status:
108 -- Internal Row Handler Use Only.
109 --
110 -- {End Of Comments}
111 -- ----------------------------------------------------------------------------
112 Procedure update_validate
113 (p_effective_date in date
114 ,p_rec in pqh_rap_shd.g_rec_type
115 );
116 --
117 -- ----------------------------------------------------------------------------
118 -- |---------------------------< delete_validate >----------------------------|
119 -- ----------------------------------------------------------------------------
120 -- {Start Of Comments}
121 --
122 -- Description:
123 -- This procedure controls the execution of all delete business rules
124 -- validation.
125 --
126 -- Prerequisites:
127 -- This private procedure is called from del procedure.
128 --
129 -- In Parameters:
130 -- A Pl/Sql record structure.
131 --
132 -- Post Success:
133 -- Processing continues.
134 --
135 -- Post Failure:
136 -- If a business rules fails the error will not be handled by this procedure
137 -- unless explicity coded.
138 --
139 -- Developer Implementation Notes:
140 -- For delete, your business rules should be executed from this procedure
141 -- and should ideally (unless really necessary) just be straight procedure
142 -- or function calls. Try and avoid using conditional branching logic.
143 --
144 -- Access Status:
145 -- Internal Row Handler Use Only.
146 --
147 -- {End Of Comments}
148 -- ----------------------------------------------------------------------------
149 Procedure delete_validate
150 (p_rec in pqh_rap_shd.g_rec_type
151 );
152 --
153 end pqh_rap_bus;