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