1 Package per_ctc_bus as
2 /* $Header: pectcrhi.pkh 120.0 2005/05/31 07:20:26 appldev noship $ */
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 -- Prerequisites:
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 Row Handler Use Only.
33 --
34 -- {End Of Comments}
35 -- ----------------------------------------------------------------------------
36 Procedure insert_validate
37 (p_rec in per_ctc_shd.g_rec_type,
38 p_effective_date in date,
39 p_datetrack_mode in varchar2,
40 p_validation_start_date in date,
41 p_validation_end_date in date);
42 --
43 -- ----------------------------------------------------------------------------
44 -- |---------------------------< update_validate >----------------------------|
45 -- ----------------------------------------------------------------------------
46 -- {Start Of Comments}
47 --
48 -- Description:
49 -- This procedure controls the execution of all update business rules
50 -- validation.
51 --
52 -- Prerequisites:
53 -- This private procedure is called from upd procedure.
54 --
55 -- In Parameters:
56 -- A Pl/Sql record structre.
57 --
58 -- Post Success:
59 -- Processing continues.
60 --
61 -- Post Failure:
62 -- If a business rules fails the error will not be handled by this procedure
63 -- unless explicity coded.
64 --
65 -- Developer Implementation Notes:
66 -- For update, your business rules should be executed from this procedure and
67 -- should ideally (unless really necessary) just be straight procedure or
68 -- function calls. Try and avoid using conditional branching logic.
69 --
70 -- Access Status:
71 -- Internal Row Handler Use Only.
72 --
73 -- {End Of Comments}
74 -- ----------------------------------------------------------------------------
75 Procedure update_validate
76 (p_rec in per_ctc_shd.g_rec_type,
77 p_effective_date in date,
78 p_datetrack_mode in varchar2,
79 p_validation_start_date in date,
80 p_validation_end_date in date);
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 -- Prerequisites:
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 Row Handler Use Only.
111 --
112 -- {End Of Comments}
113 -- ----------------------------------------------------------------------------
114 Procedure delete_validate
115 (p_rec in per_ctc_shd.g_rec_type,
116 p_effective_date in date,
117 p_datetrack_mode in varchar2,
118 p_validation_start_date in date,
119 p_validation_end_date in date);
120 --
121 -- ---------------------------------------------------------------------------
122 -- |---------------------< chk_assignment_exists >---------------------------|
123 -- ---------------------------------------------------------------------------
124 --
125 -- Description:
126 -- Function checks whether the given contract is referenced by any assignments and
127 -- returns True of False accordingly.
128 --
129 -- Pre-conditions:
130 -- None
131 --
132 -- In Arguments:
133 -- p_contract_id
134 --
135 -- Post Success:
136 -- True or False always returned.
137 --
138 -- Post Failure:
139 -- Failure is not allowed.
140 --
141 -- Access Status:
142 -- Internal Development Use Only.
143 --
144 function chk_assignment_exists
145 (p_contract_id in per_contracts_f.contract_id%TYPE) return boolean;
146 --
147 -- ---------------------------------------------------------------------------
148 -- |---------------------< return_legislation_code >-------------------------|
149 -- ---------------------------------------------------------------------------
150 --
151 -- Description:
152 -- Return the legislation code for a specific person
153 --
154 -- Prerequisites:
155 -- The contract identified by p_contract_id already exists.
156 --
157 -- In Arguments:
158 -- p_contract_id
159 --
160 -- Post Success:
161 -- If the contract is found this function will return the contract's business
162 -- group legislation code.
163 --
164 -- Post Failure:
165 -- An error is raised if the contract does not exist.
166 --
167 -- Access Status:
168 -- Internal Development Use Only.
169 --
170 function return_legislation_code
171 (p_contract_id in number
172 ) return varchar2;
173 --
174 end per_ctc_bus;