1 Package hr_pab_bus AUTHID CURRENT_USER as
2 /* $Header: hrpabrhi.pkh 115.0 99/07/17 05:36:15 porting ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------< check_unique_patt_bit >----------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 -- Public
9 -- Description
10 -- Ensure that the Pattern Bit Code is unique
11 --
12 Procedure check_unique_patt_bit (p_pattern_bit_code in varchar2);
13 --
14 -- ----------------------------------------------------------------------------
15 -- |---------------------------< insert_validate >----------------------------|
16 -- ----------------------------------------------------------------------------
17 -- {Start Of Comments}
18 --
19 -- Description:
20 -- This procedure controls the execution of all insert business rules
21 -- validation.
22 --
23 -- Pre Conditions:
24 -- This private procedure is called from ins procedure.
25 --
26 -- In Parameters:
27 -- A Pl/Sql record structre.
28 --
29 -- Post Success:
30 -- Processing continues.
31 --
32 -- Post Failure:
33 -- If a business rules fails the error will not be handled by this procedure
34 -- unless explicity coded.
35 --
36 -- Developer Implementation Notes:
37 -- For insert, your business rules should be executed from this procedure and
38 -- should ideally (unless really necessary) just be straight procedure or
39 -- function calls. Try and avoid using conditional branching logic.
40 --
41 -- Access Status:
42 -- Internal Table Handler Use Only.
43 --
44 -- {End Of Comments}
45 -- ----------------------------------------------------------------------------
46 Procedure insert_validate(p_rec in hr_pab_shd.g_rec_type);
47 --
48 -- ----------------------------------------------------------------------------
49 -- |---------------------------< update_validate >----------------------------|
50 -- ----------------------------------------------------------------------------
51 -- {Start Of Comments}
52 --
53 -- Description:
54 -- This procedure controls the execution of all update business rules
55 -- validation.
56 --
57 -- Pre Conditions:
58 -- This private procedure is called from upd procedure.
59 --
60 -- In Parameters:
61 -- A Pl/Sql record structre.
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 update, your business rules should be executed from this procedure and
72 -- should ideally (unless really necessary) just be straight procedure or
73 -- function calls. Try and avoid using conditional branching logic.
74 --
75 -- Access Status:
76 -- Internal Table Handler Use Only.
77 --
78 -- {End Of Comments}
79 -- ----------------------------------------------------------------------------
80 Procedure update_validate(p_rec in hr_pab_shd.g_rec_type);
81 --
82 -- ----------------------------------------------------------------------------
83 -- |---------------------------< delete_validate >----------------------------|
84 -- ----------------------------------------------------------------------------
85 -- {Start Of Comments}
86 --
87 -- Description:
88 -- This procedure controls the execution of all delete business rules
89 -- validation.
90 --
91 -- Pre Conditions:
92 -- This private procedure is called from del procedure.
93 --
94 -- In Parameters:
95 -- A Pl/Sql record structre.
96 --
97 -- Post Success:
98 -- Processing continues.
99 --
100 -- Post Failure:
101 -- If a business rules fails the error will not be handled by this procedure
102 -- unless explicity coded.
103 --
104 -- Developer Implementation Notes:
105 -- For delete, your business rules should be executed from this procedure and
106 -- should ideally (unless really necessary) just be straight procedure or
107 -- function calls. Try and avoid using conditional branching logic.
108 --
109 -- Access Status:
110 -- Internal Table Handler Use Only.
111 --
112 -- {End Of Comments}
113 -- ----------------------------------------------------------------------------
114 Procedure delete_validate(p_rec in hr_pab_shd.g_rec_type);
115 --
116 end hr_pab_bus;