1 Package pay_pwo_bus AUTHID CURRENT_USER as
2 /* $Header: pypworhi.pkh 120.2 2011/12/23 09:39:22 emunisek 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_occupation_id already exists.
14 --
15 -- In Arguments:
16 -- p_occupation_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_occupation_id in number) return varchar2;
30 -- ----------------------------------------------------------------------------
31 -- |-----------------------------< chk_job_group >----------------------------|
32 -- ----------------------------------------------------------------------------
33 -- Description : This function is used to validate the job being inserted. It
34 -- must be a valid HR Job Group job.
35 -- Validation : The job must exist in new view per_jobs_v
36 -- On Failure : Raise message 'The job you have entered is not for a valid HR
37 -- Job Group.'
38 -- ----------------------------------------------------------------------------
39 FUNCTION chk_job_group (p_job_id in number
40 ,p_business_group_id in number)
41 RETURN BOOLEAN;
42 -- ----------------------------------------------------------------------------
43 -- |---------------------------< insert_validate >----------------------------|
44 -- ----------------------------------------------------------------------------
45 -- {Start Of Comments}
46 --
47 -- Description:
48 -- This procedure controls the execution of all insert business rules
49 -- validation.
50 --
51 -- Prerequisites:
52 -- This private procedure is called from ins procedure.
53 --
54 -- In Parameters:
55 -- A Pl/Sql record structre.
56 --
57 -- Post Success:
58 -- Processing continues.
59 --
60 -- Post Failure:
61 -- If a business rules fails the error will not be handled by this procedure
62 -- unless explicity coded.
63 --
64 -- Developer Implementation Notes:
65 -- For insert, your business rules should be executed from this procedure and
66 -- should ideally (unless really necessary) just be straight procedure or
67 -- function calls. Try and avoid using conditional branching logic.
68 --
69 -- Access Status:
70 -- Internal Row Handler Use Only.
71 --
72 -- {End Of Comments}
73 -- ----------------------------------------------------------------------------
74 Procedure insert_validate(p_rec in pay_pwo_shd.g_rec_type);
75 --
76 -- ----------------------------------------------------------------------------
77 -- |---------------------------< update_validate >----------------------------|
78 -- ----------------------------------------------------------------------------
79 -- {Start Of Comments}
80 --
81 -- Description:
82 -- This procedure controls the execution of all update business rules
83 -- validation.
84 --
85 -- Prerequisites:
86 -- This private procedure is called from upd procedure.
87 --
88 -- In Parameters:
89 -- A Pl/Sql record structre.
90 --
91 -- Post Success:
92 -- Processing continues.
93 --
94 -- Post Failure:
95 -- If a business rules fails the error will not be handled by this procedure
96 -- unless explicity coded.
97 --
98 -- Developer Implementation Notes:
99 -- For update, your business rules should be executed from this procedure and
100 -- should ideally (unless really necessary) just be straight procedure or
101 -- function calls. Try and avoid using conditional branching logic.
102 --
103 -- Access Status:
104 -- Internal Row Handler Use Only.
105 --
106 -- {End Of Comments}
107 -- ----------------------------------------------------------------------------
108 Procedure update_validate(p_rec in pay_pwo_shd.g_rec_type);
109 --
110 -- ----------------------------------------------------------------------------
111 -- |---------------------------< delete_validate >----------------------------|
112 -- ----------------------------------------------------------------------------
113 -- {Start Of Comments}
114 --
115 -- Description:
116 -- This procedure controls the execution of all delete business rules
117 -- validation.
118 --
119 -- Prerequisites:
120 -- This private procedure is called from del procedure.
121 --
122 -- In Parameters:
123 -- A Pl/Sql record structre.
124 --
125 -- Post Success:
126 -- Processing continues.
127 --
128 -- Post Failure:
129 -- If a business rules fails the error will not be handled by this procedure
130 -- unless explicity coded.
131 --
132 -- Developer Implementation Notes:
133 -- For delete, your business rules should be executed from this procedure and
134 -- should ideally (unless really necessary) just be straight procedure or
135 -- function calls. Try and avoid using conditional branching logic.
136 --
137 -- Access Status:
138 -- Internal Row Handler Use Only.
139 --
140 -- {End Of Comments}
141 -- ----------------------------------------------------------------------------
142 Procedure delete_validate(p_rec in pay_pwo_shd.g_rec_type);
143 --
144 end pay_pwo_bus;
[Home] [Help]