1 Package hr_eap_bus as
2 /* $Header: hreaprhi.pkh 120.0 2005/05/30 23:58 appldev noship $ */
3
4 -- ----------------------------------------------------------------------------
5 -- |------------------< CHK_EXTERNAL_APPLICATION_NAME>------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This procedure ensures EXTERNAL_APPLICATION_NAME is not null and unique.
11 -- Pre Conditions:
12 -- g_old_rec has been populated with details of the values currently in
13 -- the database.
14 --
15 -- In Arguments:
16 -- P_EXTERNAL_APPLICATION_NAME
17 -- Post Success:
18 -- Processing continues if P_EXTERNAL_APPLICATION_NAME is not null and unique
19 --
20 -- Post Failure:
21 -- An application error is raised if P_EXTERNAL_APPLICATION_NAME is null
22 -- or exists already in table.
23 --
24 -- {End Of Comments}
25 -- ----------------------------------------------------------------------------
26 Procedure CHK_EXTERNAL_APPLICATION_NAME
27 (p_external_application_name in varchar2
28 );
29
30 -- ----------------------------------------------------------------------------
31 -- |---------------------------< insert_validate >----------------------------|
32 -- ----------------------------------------------------------------------------
33 -- {Start of comments}
34 --
35 -- Description:
36 -- This procedure controls the execution of all insert business rules
37 -- validation.
38 --
39 -- Prerequisites:
40 -- This private procedure is called from ins procedure.
41 --
42 -- In Parameters:
43 -- A Pl/Sql record structure.
44 --
45 -- Post Success:
46 -- Processing continues.
47 --
48 -- Post Failure:
49 -- If a business rules fails the error will not be handled by this procedure
50 -- unless explicity coded.
51 --
52 -- Developer Implementation Notes:
53 -- For insert, your business rules should be executed from this procedure
54 -- and should ideally (unless really necessary) just be straight procedure
55 -- or function calls. Try and avoid using conditional branching logic.
56 --
57 -- Access Status:
58 -- Internal Row Handler Use Only.
59 --
60 -- {End of comments}
61 -- ----------------------------------------------------------------------------
62 Procedure insert_validate
63 (p_rec in hr_eap_shd.g_rec_type
64 );
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 structure.
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 -- Access Status:
89 -- Internal Row Handler Use Only.
90 --
91 -- {End Of Comments}
92 -- ----------------------------------------------------------------------------
93 Procedure update_validate
94 (p_rec in hr_eap_shd.g_rec_type
95 );
96 --
97 -- ----------------------------------------------------------------------------
98 -- |---------------------------< delete_validate >----------------------------|
99 -- ----------------------------------------------------------------------------
100 -- {Start Of Comments}
101 --
102 -- Description:
103 -- This procedure controls the execution of all delete business rules
104 -- validation.
105 --
106 -- Prerequisites:
107 -- This private procedure is called from del procedure.
108 --
109 -- In Parameters:
110 -- A Pl/Sql record structure.
111 --
112 -- Post Success:
113 -- Processing continues.
114 --
115 -- Post Failure:
116 -- If a business rules fails the error will not be handled by this procedure
117 -- unless explicity coded.
118 --
119 -- Developer Implementation Notes:
120 -- For delete, your business rules should be executed from this procedure
121 -- and should ideally (unless really necessary) just be straight procedure
122 -- or function calls. Try and avoid using conditional branching logic.
123 --
124 -- Access Status:
125 -- Internal Row Handler Use Only.
126 --
127 -- {End Of Comments}
128 -- ----------------------------------------------------------------------------
129 Procedure delete_validate
130 (p_rec in hr_eap_shd.g_rec_type
131 );
132 --
133 end hr_eap_bus;