1 Package per_pss_bus as
2 /* $Header: pepssrhi.pkh 120.0 2005/05/31 15:35:00 appldev noship $ */
3 --
4 --
5 -- ----------------------------------------------------------------------------
6 -- |--------------------< chk_survey_name_company_code >----------------------|
7 -- ----------------------------------------------------------------------------
8 --
9 -- Description
10 -- This procedure is used to check that survey_name and
11 -- survey_company_code:
12 -- a) Are not null since they are mandatory.
13 -- b) Form a unique combination.
14 --
15 -- Pre Requisites
16 -- None.
17 --
18 -- In Parameters
19 -- salary_survey_id
20 -- object_version_number
21 -- survey_name
22 -- survey_company_code.
23 --
24 -- Post Success
25 -- Processing continues if the survey_name and survey_company_code are not
26 -- null and the combination is valid.
27 --
28 -- Post Failure
29 -- An application error is raised and processing is terminated if the
30 -- survey_name or survey_company_code are null or combination is invalid.
31 --
32 -- Developer/Implementation Notes
33 -- None.
34 --
35 -- Access Status
36 -- Internal row handler use only.
37 --
38 Procedure chk_survey_name_company_code
39 (p_salary_survey_id in number,
40 p_object_version_number in number,
41 p_survey_name in per_salary_surveys.survey_name%TYPE,
42 p_survey_company_code in per_salary_surveys.survey_company_code%TYPE);
43
44 --
45 -- ----------------------------------------------------------------------------
46 -- |---------------------------< insert_validate >----------------------------|
47 -- ----------------------------------------------------------------------------
48 -- {Start Of Comments}
49 --
50 -- Description:
51 -- This procedure controls the execution of all insert business rules
52 -- validation.
53 --
54 -- Prerequisites:
55 -- This private procedure is called from ins procedure.
56 --
57 -- In Parameters:
58 -- A Pl/Sql record structre.
59 --
60 -- Post Success:
61 -- Processing continues.
62 --
63 -- Post Failure:
64 -- If a business rules fails the error will not be handled by this procedure
65 -- unless explicity coded.
66 --
67 -- Developer Implementation Notes:
68 -- For insert, your business rules should be executed from this procedure and
69 -- should ideally (unless really necessary) just be straight procedure or
70 -- function calls. Try and avoid using conditional branching logic.
71 --
72 -- Access Status:
73 -- Internal Row Handler Use Only.
74 --
75 -- {End Of Comments}
76 -- ----------------------------------------------------------------------------
77 Procedure insert_validate(p_rec in per_pss_shd.g_rec_type,
78 p_effective_date in date);
79 --
80 -- ----------------------------------------------------------------------------
81 -- |---------------------------< update_validate >----------------------------|
82 -- ----------------------------------------------------------------------------
83 -- {Start Of Comments}
84 --
85 -- Description:
86 -- This procedure controls the execution of all update business rules
87 -- validation.
88 --
89 -- Prerequisites:
90 -- This private procedure is called from upd procedure.
91 --
92 -- In Parameters:
93 -- A Pl/Sql record structre.
94 --
95 -- Post Success:
96 -- Processing continues.
97 --
98 -- Post Failure:
99 -- If a business rules fails the error will not be handled by this procedure
100 -- unless explicity coded.
101 --
102 -- Developer Implementation Notes:
103 -- For update, your business rules should be executed from this procedure and
104 -- should ideally (unless really necessary) just be straight procedure or
105 -- function calls. Try and avoid using conditional branching logic.
106 --
107 -- Access Status:
108 -- Internal Row Handler Use Only.
109 --
110 -- {End Of Comments}
111 -- ----------------------------------------------------------------------------
112 Procedure update_validate(p_rec in per_pss_shd.g_rec_type,
113 p_effective_date in date);
114 --
115 -- ----------------------------------------------------------------------------
116 -- |---------------------------< delete_validate >----------------------------|
117 -- ----------------------------------------------------------------------------
118 -- {Start Of Comments}
119 --
120 -- Description:
121 -- This procedure controls the execution of all delete business rules
122 -- validation.
123 --
124 -- Prerequisites:
125 -- This private procedure is called from del procedure.
126 --
127 -- In Parameters:
128 -- A Pl/Sql record structre.
129 --
130 -- Post Success:
131 -- Processing continues.
132 --
133 -- Post Failure:
134 -- If a business rules fails the error will not be handled by this procedure
135 -- unless explicity coded.
136 --
137 -- Developer Implementation Notes:
138 -- For delete, your business rules should be executed from this procedure and
139 -- should ideally (unless really necessary) just be straight procedure or
140 -- function calls. Try and avoid using conditional branching logic.
141 --
142 -- Access Status:
143 -- Internal Row Handler Use Only.
144 --
145 -- {End Of Comments}
146 -- ----------------------------------------------------------------------------
147 Procedure delete_validate(p_rec in per_pss_shd.g_rec_type);
148 --
149 end per_pss_bus;