1 Package pqh_ptx_bus as
2 /* $Header: pqptxrhi.pkh 120.0.12010000.1 2008/07/28 13:05:46 appldev ship $ */
3 --
4 --
5 -- ---------------------------------------------------------------------------
6 -- |---------------------< return_legislation_code >-------------------------|
7 -- ---------------------------------------------------------------------------
8 --
9 -- Description:
10 -- Return the legislation code for a specific primary key value
11 --
12 -- Prerequisites:
13 -- The primary key identified by p_position_transaction_id already exists.
14 --
15 -- In Arguments:
16 -- p_position_transaction_id
17 --
18 -- Post Success:
19 -- If the value is found this function will return the values business
20 -- group legislation code.
21 --
22 -- Post Failure:
23 -- An error is raised if the value does not exist.
24 --
25 -- Access Status:
26 -- Internal Development Use Only.
27 --
28 function return_legislation_code
29 (p_position_transaction_id in number) return varchar2;
30 --
31 --
32 -- ----------------------------------------------------------------------------
33 -- |--------------------------< chk_end_dates >---------------------|
34 -- ----------------------------------------------------------------------------
35 --
36 procedure chk_end_dates
37 (
38 p_position_transaction_id in number
39 ,position_id in number
40 ,availability_status_id in number
41 ,p_effective_date in date
42 ,current_org_prop_end_date in date
43 ,current_job_prop_end_date in date
44 ,avail_status_prop_end_date in date
45 ,earliest_hire_date in date
46 ,fill_by_date in date
47 ,proposed_date_for_layoff in date
48 ,date_effective in date
49 ,p_object_version_number in number);
50 --
51 -- ----------------------------------------------------------------------------
52 -- |---------------------------< insert_validate >----------------------------|
53 -- ----------------------------------------------------------------------------
54 -- {Start Of Comments}
55 --
56 -- Description:
57 -- This procedure controls the execution of all insert business rules
58 -- validation.
59 --
60 -- Prerequisites:
61 -- This private procedure is called from ins procedure.
62 --
63 -- In Parameters:
64 -- A Pl/Sql record structre.
65 --
66 -- Post Success:
67 -- Processing continues.
68 --
69 -- Post Failure:
70 -- If a business rules fails the error will not be handled by this procedure
71 -- unless explicity coded.
72 --
73 -- Developer Implementation Notes:
74 -- For insert, your business rules should be executed from this procedure and
75 -- should ideally (unless really necessary) just be straight procedure or
76 -- function calls. Try and avoid using conditional branching logic.
77 --
78 -- Access Status:
79 -- Internal Row Handler Use Only.
80 --
81 -- {End Of Comments}
82 -- ----------------------------------------------------------------------------
83 Procedure insert_validate(p_rec in pqh_ptx_shd.g_rec_type
84 ,p_effective_date in date);
85 --
86 -- ----------------------------------------------------------------------------
87 -- |---------------------------< update_validate >----------------------------|
88 -- ----------------------------------------------------------------------------
89 -- {Start Of Comments}
90 --
91 -- Description:
92 -- This procedure controls the execution of all update business rules
93 -- validation.
94 --
95 -- Prerequisites:
96 -- This private procedure is called from upd procedure.
97 --
98 -- In Parameters:
99 -- A Pl/Sql record structre.
100 --
101 -- Post Success:
102 -- Processing continues.
103 --
104 -- Post Failure:
105 -- If a business rules fails the error will not be handled by this procedure
106 -- unless explicity coded.
107 --
108 -- Developer Implementation Notes:
109 -- For update, your business rules should be executed from this procedure and
110 -- should ideally (unless really necessary) just be straight procedure or
111 -- function calls. Try and avoid using conditional branching logic.
112 --
113 -- Access Status:
114 -- Internal Row Handler Use Only.
115 --
116 -- {End Of Comments}
117 -- ----------------------------------------------------------------------------
118 Procedure update_validate(p_rec in pqh_ptx_shd.g_rec_type
119 ,p_effective_date in date);
120 --
121 -- ----------------------------------------------------------------------------
122 -- |---------------------------< delete_validate >----------------------------|
123 -- ----------------------------------------------------------------------------
124 -- {Start Of Comments}
125 --
126 -- Description:
127 -- This procedure controls the execution of all delete business rules
128 -- validation.
129 --
130 -- Prerequisites:
131 -- This private procedure is called from del procedure.
132 --
133 -- In Parameters:
134 -- A Pl/Sql record structre.
135 --
136 -- Post Success:
137 -- Processing continues.
138 --
139 -- Post Failure:
140 -- If a business rules fails the error will not be handled by this procedure
141 -- unless explicity coded.
142 --
143 -- Developer Implementation Notes:
144 -- For delete, your business rules should be executed from this procedure and
145 -- should ideally (unless really necessary) just be straight procedure or
146 -- function calls. Try and avoid using conditional branching logic.
147 --
148 -- Access Status:
149 -- Internal Row Handler Use Only.
150 --
151 -- {End Of Comments}
152 -- ----------------------------------------------------------------------------
153 Procedure delete_validate(p_rec in pqh_ptx_shd.g_rec_type
154 ,p_effective_date in date);
155 --
156 end pqh_ptx_bus;