1 Package ben_pcg_bus as
2 /* $Header: bepcgrhi.pkh 120.0 2005/05/28 10:11:18 appldev 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_prtt_clm_gd_or_svc_typ_id already exists.
14 --
15 -- In Arguments:
16 -- p_prtt_clm_gd_or_svc_typ_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_prtt_clm_gd_or_svc_typ_id in number) return varchar2;
30 --
31 --
32 -- ----------------------------------------------------------------------------
33 -- |---------------------------< insert_validate >----------------------------|
34 -- ----------------------------------------------------------------------------
35 -- {Start Of Comments}
36 --
37 -- Description:
38 -- This procedure controls the execution of all insert business rules
39 -- validation.
40 --
41 -- Prerequisites:
42 -- This private procedure is called from ins procedure.
43 --
44 -- In Parameters:
45 -- A Pl/Sql record structre.
46 --
47 -- Post Success:
48 -- Processing continues.
49 --
50 -- Post Failure:
51 -- If a business rules fails the error will not be handled by this procedure
52 -- unless explicity coded.
53 --
54 -- Developer Implementation Notes:
55 -- For insert, your business rules should be executed from this procedure and
56 -- should ideally (unless really necessary) just be straight procedure or
57 -- function calls. Try and avoid using conditional branching logic.
58 --
59 -- Access Status:
60 -- Internal Row Handler Use Only.
61 --
62 -- {End Of Comments}
63 -- ----------------------------------------------------------------------------
64 Procedure insert_validate(p_rec in ben_pcg_shd.g_rec_type);
65 --
66 -- ----------------------------------------------------------------------------
67 -- |---------------------------< update_validate >----------------------------|
68 -- ----------------------------------------------------------------------------
69 -- {Start Of Comments}
70 --
71 -- Description:
72 -- This procedure controls the execution of all update business rules
73 -- validation.
74 --
75 -- Prerequisites:
76 -- This private procedure is called from upd procedure.
77 --
78 -- In Parameters:
79 -- A Pl/Sql record structre.
80 --
81 -- Post Success:
82 -- Processing continues.
83 --
84 -- Post Failure:
85 -- If a business rules fails the error will not be handled by this procedure
86 -- unless explicity coded.
87 --
88 -- Developer Implementation Notes:
89 -- For update, your business rules should be executed from this procedure and
90 -- should ideally (unless really necessary) just be straight procedure or
91 -- function calls. Try and avoid using conditional branching logic.
92 --
93 -- Access Status:
94 -- Internal Row Handler Use Only.
95 --
96 -- {End Of Comments}
97 -- ----------------------------------------------------------------------------
98 procedure update_validate(p_rec in ben_pcg_shd.g_rec_type);
99 --
100 -- ----------------------------------------------------------------------------
101 -- |---------------------------< delete_validate >----------------------------|
102 -- ----------------------------------------------------------------------------
103 -- {Start Of Comments}
104 --
105 -- Description:
106 -- This procedure controls the execution of all delete business rules
107 -- validation.
108 --
109 -- Prerequisites:
110 -- This private procedure is called from del procedure.
111 --
112 -- In Parameters:
113 -- A Pl/Sql record structre.
114 --
115 -- Post Success:
116 -- Processing continues.
117 --
118 -- Post Failure:
119 -- If a business rules fails the error will not be handled by this procedure
120 -- unless explicity coded.
121 --
122 -- Developer Implementation Notes:
123 -- For delete, your business rules should be executed from this procedure and
124 -- should ideally (unless really necessary) just be straight procedure or
125 -- function calls. Try and avoid using conditional branching logic.
126 --
127 -- Access Status:
128 -- Internal Row Handler Use Only.
129 --
130 -- {End Of Comments}
131 -- ----------------------------------------------------------------------------
132 Procedure delete_validate(p_rec in ben_pcg_shd.g_rec_type);
133 --
134 end ben_pcg_bus;