1 Package ben_ler_bus AUTHID CURRENT_USER as
2 /* $Header: belerrhi.pkh 120.2 2006/11/03 10:24:29 vborkar noship $ */
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_ler_id already exists.
14 --
15 -- In Arguments:
16 -- p_ler_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_ler_id in number) return varchar2;
30 -- added for bug: 4651734 for MLS
31 PROCEDURE set_translation_globals(p_business_group_id IN NUMBER);
32
33 procedure validate_translation(ler_id IN NUMBER,
34 language IN VARCHAR2,
35 ler_name IN VARCHAR2,
36 p_business_group_id IN NUMBER DEFAULT NULL);
37
38 --
39 --
40 -- ----------------------------------------------------------------------------
41 -- |---------------------------< insert_validate >----------------------------|
42 -- ----------------------------------------------------------------------------
43 -- {Start Of Comments}
44 --
45 -- Description:
46 -- This procedure controls the execution of all insert business rules
47 -- validation.
48 --
49 -- Prerequisites:
50 -- This private procedure is called from ins procedure.
51 --
52 -- In Parameters:
53 -- A Pl/Sql record structre.
54 --
55 -- Post Success:
56 -- Processing continues.
57 --
58 -- Post Failure:
59 -- If a business rules fails the error will not be handled by this procedure
60 -- unless explicity coded.
61 --
62 -- Developer Implementation Notes:
63 -- For insert, your business rules should be executed from this procedure and
64 -- should ideally (unless really necessary) just be straight procedure or
65 -- function calls. Try and avoid using conditional branching logic.
66 --
67 -- Access Status:
68 -- Internal Row Handler Use Only.
69 --
70 -- {End Of Comments}
71 -- ----------------------------------------------------------------------------
72 Procedure insert_validate
73 (p_rec in ben_ler_shd.g_rec_type,
74 p_effective_date in date,
75 p_datetrack_mode in varchar2,
76 p_validation_start_date in date,
77 p_validation_end_date in date);
78 --
79 -- ----------------------------------------------------------------------------
80 -- |---------------------------< update_validate >----------------------------|
81 -- ----------------------------------------------------------------------------
82 -- {Start Of Comments}
83 --
84 -- Description:
85 -- This procedure controls the execution of all update business rules
86 -- validation.
87 --
88 -- Prerequisites:
89 -- This private procedure is called from upd procedure.
90 --
91 -- In Parameters:
92 -- A Pl/Sql record structre.
93 --
94 -- Post Success:
95 -- Processing continues.
96 --
97 -- Post Failure:
98 -- If a business rules fails the error will not be handled by this procedure
99 -- unless explicity coded.
100 --
101 -- Developer Implementation Notes:
102 -- For update, your business rules should be executed from this procedure and
103 -- should ideally (unless really necessary) just be straight procedure or
104 -- function calls. Try and avoid using conditional branching logic.
105 --
106 -- Access Status:
107 -- Internal Row Handler Use Only.
108 --
109 -- {End Of Comments}
110 -- ----------------------------------------------------------------------------
111 Procedure update_validate
112 (p_rec in ben_ler_shd.g_rec_type,
113 p_effective_date in date,
114 p_datetrack_mode in varchar2,
115 p_validation_start_date in date,
116 p_validation_end_date in date);
117 --
118 -- ----------------------------------------------------------------------------
119 -- |---------------------------< delete_validate >----------------------------|
120 -- ----------------------------------------------------------------------------
121 -- {Start Of Comments}
122 --
123 -- Description:
124 -- This procedure controls the execution of all delete business rules
125 -- validation.
126 --
127 -- Prerequisites:
128 -- This private procedure is called from del procedure.
129 --
130 -- In Parameters:
131 -- A Pl/Sql record structre.
132 --
133 -- Post Success:
134 -- Processing continues.
135 --
136 -- Post Failure:
137 -- If a business rules fails the error will not be handled by this procedure
138 -- unless explicity coded.
139 --
140 -- Developer Implementation Notes:
141 -- For delete, your business rules should be executed from this procedure and
142 -- should ideally (unless really necessary) just be straight procedure or
143 -- function calls. Try and avoid using conditional branching logic.
144 --
145 -- Access Status:
146 -- Internal Row Handler Use Only.
147 --
148 -- {End Of Comments}
149 -- ----------------------------------------------------------------------------
150 Procedure delete_validate
151 (p_rec in ben_ler_shd.g_rec_type,
152 p_effective_date in date,
153 p_datetrack_mode in varchar2,
154 p_validation_start_date in date,
155 p_validation_end_date in date);
156 --
157 end ben_ler_bus;