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