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