1 Package per_pmp_bus as
2 /* $Header: pepmprhi.pkh 120.2 2006/08/11 05:49:43 tpapired noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------------< return_status_code >----------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 -- Description:
9 -- Returns the plan's status.
10 --
11 -- Prerequisites:
12 -- The plan must already exist and p_plan_id must have a value.
13 --
14 -- In Arguments:
15 -- p_plan_id
16 --
17 -- Post Success:
18 -- The plan's status is returned as a varchar2.
19 --
20 -- Post Failure:
21 -- Null is returned.
22 --
23 -- Access Status:
24 -- Internal Oracle Use Only.
25 --
26 -- ----------------------------------------------------------------------------
27 function return_status_code
28 (p_plan_id in number) return varchar2;
29 --
30 -- ----------------------------------------------------------------------------
31 -- |------------------------------< return_ovn >------------------------------|
32 -- ----------------------------------------------------------------------------
33 --
34 -- Description:
35 -- Returns the plan's object version number.
36 --
37 -- Prerequisites:
38 -- The plan must already exist and p_plan_id must have a value.
39 --
40 -- In Arguments:
41 -- p_plan_id
42 --
43 -- Post Success:
44 -- The plan's OVN is returned as a number.
45 --
46 -- Post Failure:
47 -- Null is returned.
48 --
49 -- Access Status:
50 -- Internal Oracle Use Only.
51 --
52 -- ----------------------------------------------------------------------------
53 function return_ovn
54 (p_plan_id in number) return number;
55 --
56 -- ----------------------------------------------------------------------------
57 -- |---------------------------< insert_validate >----------------------------|
58 -- ----------------------------------------------------------------------------
59 -- {Start of comments}
60 --
61 -- Description:
62 -- This procedure controls the execution of all insert business rules
63 -- validation.
64 --
65 -- Prerequisites:
66 -- This private procedure is called from ins procedure.
67 --
68 -- In Parameters:
69 -- A Pl/Sql record structure.
70 --
71 -- Post Success:
72 -- Processing continues.
73 --
74 -- Post Failure:
75 -- If a business rules fails the error will not be handled by this procedure
76 -- unless explicity coded.
77 --
78 -- Developer Implementation Notes:
79 -- For insert, your business rules should be executed from this procedure
80 -- and should ideally (unless really necessary) just be straight procedure
81 -- or function calls. Try and avoid using conditional branching logic.
82 --
83 -- Access Status:
84 -- Internal Row Handler Use Only.
85 --
86 -- {End of comments}
87 -- ----------------------------------------------------------------------------
88 Procedure insert_validate
89 (p_effective_date in date
90 ,p_rec in per_pmp_shd.g_rec_type
91 ,p_duplicate_name_warning out nocopy boolean
92 ,p_no_life_events_warning out nocopy boolean
93 );
94 --
95 -- ----------------------------------------------------------------------------
96 -- |---------------------------< update_validate >----------------------------|
97 -- ----------------------------------------------------------------------------
98 -- {Start Of Comments}
99 --
100 -- Description:
101 -- This procedure controls the execution of all update business rules
102 -- validation.
103 --
104 -- Prerequisites:
105 -- This private procedure is called from upd procedure.
106 --
107 -- In Parameters:
108 -- A Pl/Sql record structure.
109 --
110 -- Post Success:
111 -- Processing continues.
112 --
113 -- Post Failure:
114 -- If a business rules fails the error will not be handled by this procedure
115 -- unless explicity coded.
116 --
117 -- Access Status:
118 -- Internal Row Handler Use Only.
119 --
120 -- {End Of Comments}
121 -- ----------------------------------------------------------------------------
122 Procedure update_validate
123 (p_effective_date in date
124 ,p_rec in per_pmp_shd.g_rec_type
125 ,p_duplicate_name_warning out nocopy boolean
126 ,p_no_life_events_warning out nocopy boolean
127 );
128 --
129 -- ----------------------------------------------------------------------------
130 -- |---------------------------< delete_validate >----------------------------|
131 -- ----------------------------------------------------------------------------
132 -- {Start Of Comments}
133 --
134 -- Description:
135 -- This procedure controls the execution of all delete business rules
136 -- validation.
137 --
138 -- Prerequisites:
139 -- This private procedure is called from del procedure.
140 --
141 -- In Parameters:
142 -- A Pl/Sql record structure.
143 --
144 -- Post Success:
145 -- Processing continues.
146 --
147 -- Post Failure:
148 -- If a business rules fails the error will not be handled by this procedure
149 -- unless explicity coded.
150 --
151 -- Developer Implementation Notes:
152 -- For delete, your business rules should be executed from this procedure
153 -- and should ideally (unless really necessary) just be straight procedure
154 -- or function calls. Try and avoid using conditional branching logic.
155 --
156 -- Access Status:
157 -- Internal Row Handler Use Only.
158 --
159 -- {End Of Comments}
160 -- ----------------------------------------------------------------------------
161 Procedure delete_validate
162 (p_rec in per_pmp_shd.g_rec_type
163 );
164 --
165 end per_pmp_bus;
[Home] [Help]