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