1 Package per_asr_bus AUTHID CURRENT_USER as
2 /* $Header: peasrrhi.pkh 115.3 99/10/05 09:44:19 porting ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------< insert_validate >----------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This procedure controls the execution of all insert business rules
11 -- validation.
12 --
13 -- Pre Conditions:
14 -- This private procedure is called from ins procedure.
15 --
16 -- In Parameters:
17 -- A Pl/Sql record structre.
18 --
19 -- Post Success:
20 -- Processing continues.
21 --
22 -- Post Failure:
23 -- If a business rules fails the error will not be handled by this procedure
24 -- unless explicity coded.
25 --
26 -- Developer Implementation Notes:
27 -- For insert, your business rules should be executed from this procedure and
28 -- should ideally (unless really necessary) just be straight procedure or
29 -- function calls. Try and avoid using conditional branching logic.
30 --
31 -- Access Status:
32 -- Internal Table Handler Use Only.
33 --
34 -- {End Of Comments}
35 -- ----------------------------------------------------------------------------
36 Procedure insert_validate
37 (p_rec in per_asr_shd.g_rec_type
38 ,p_effective_date in date);
39 --
40 -- ----------------------------------------------------------------------------
41 -- |---------------------------< update_validate >----------------------------|
42 -- ----------------------------------------------------------------------------
43 -- {Start Of Comments}
44 --
45 -- Description:
46 -- This procedure controls the execution of all update business rules
47 -- validation.
48 --
49 -- Pre Conditions:
50 -- This private procedure is called from upd procedure.
51 --
52 -- In Parameters:
53 -- A Pl/Sql record structre.
54 --
55 -- Post Success:
56 -- Processing continues.
57 --
58 -- Post Failure:
59 -- If a business rules fails the error will not be handled by this procedure
60 -- unless explicity coded.
61 --
62 -- Developer Implementation Notes:
63 -- For update, your business rules should be executed from this procedure and
64 -- should ideally (unless really necessary) just be straight procedure or
65 -- function calls. Try and avoid using conditional branching logic.
66 --
67 -- Access Status:
68 -- Internal Table Handler Use Only.
69 --
70 -- {End Of Comments}
71 -- ----------------------------------------------------------------------------
72 Procedure update_validate
73 (p_rec in per_asr_shd.g_rec_type
74 ,p_effective_date in date);
75 --
76 -- ----------------------------------------------------------------------------
77 -- |---------------------------< delete_validate >----------------------------|
78 -- ----------------------------------------------------------------------------
79 -- {Start Of Comments}
80 --
81 -- Description:
82 -- This procedure controls the execution of all delete business rules
83 -- validation.
84 --
85 -- Pre Conditions:
86 -- This private procedure is called from del procedure.
87 --
88 -- In Parameters:
89 -- A Pl/Sql record structre.
90 --
91 -- Post Success:
92 -- Processing continues.
93 --
94 -- Post Failure:
95 -- If a business rules fails the error will not be handled by this procedure
96 -- unless explicity coded.
97 --
98 -- Developer Implementation Notes:
99 -- For delete, your business rules should be executed from this procedure and
100 -- should ideally (unless really necessary) just be straight procedure or
101 -- function calls. Try and avoid using conditional branching logic.
102 --
103 -- Access Status:
104 -- Internal Table Handler Use Only.
105 --
106 -- {End Of Comments}
107 -- ----------------------------------------------------------------------------
108 Procedure delete_validate(p_rec in per_asr_shd.g_rec_type);
109 --
110 -- ----------------------------------------------------------------------------
111 -- |----------------------< return_legislation_code >--------------------------|
112 -- ----------------------------------------------------------------------------
113 -- {Start Of Comments}
114 --
115 -- Description:
116 -- This function gets the legislation code
117 --
118 -- Pre Conditions:
119 -- This private procedure will be called from the user hook procedures.
120 --
121 -- In Parameters:
122 -- the primary key of the table (per_assessment_groups)
123 --
124 -- Post Success:
125 -- Processing continues.
126 --
127 -- Post Failure:
128 -- If the legislation code is not found then it errors out
129 --
130 -- Developer Implementation Notes:
131 --
132 -- Access Status:
133 -- Internal Table Handler Use Only.
134 --
135 -- {End Of Comments}
136 --
137 Function return_legislation_code (
138 p_assessment_group_id in number)
139 return varchar2;
140 --
141 --
142 end per_asr_bus;