1 Package ame_gcf_bus AUTHID CURRENT_USER as
2 /* $Header: amgcfrhi.pkh 120.0 2005/09/02 03:59 mbocutt noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------< chk_application_id >----------------------------|
6 -- ----------------------------------------------------------------------------
7 procedure chk_application_id(p_application_id in number
8 ,p_effective_date in date
9 );
10 -- ----------------------------------------------------------------------------
11 -- |---------------------------< chk_approval_group_id >----------------------------|
12 -- ----------------------------------------------------------------------------
13 procedure chk_approval_group_id(p_approval_group_id in number
14 ,p_effective_date in date
15 );
16 --
17 -- ----------------------------------------------------------------------------
18 -- |---------------------------< insert_validate >----------------------------|
19 -- ----------------------------------------------------------------------------
20 -- {Start Of Comments}
21 --
22 -- Description:
23 -- This procedure controls the execution of all insert business rules
24 -- validation.
25 --
26 -- Prerequisites:
27 -- This private procedure is called from ins procedure.
28 --
29 -- In Parameters:
30 -- A Pl/Sql record structre.
31 --
32 -- Post Success:
33 -- Processing continues.
34 --
35 -- Post Failure:
36 -- If a business rules fails the error will not be handled by this procedure
37 -- unless explicity coded.
38 --
39 -- Developer Implementation Notes:
40 -- For insert, your business rules should be executed from this procedure and
41 -- should ideally (unless really necessary) just be straight procedure or
42 -- function calls. Try and avoid using conditional branching logic.
43 --
44 -- Access Status:
45 -- Internal Row Handler Use Only.
46 --
47 -- {End Of Comments}
48 -- ----------------------------------------------------------------------------
49 Procedure insert_validate
50 (p_rec in ame_gcf_shd.g_rec_type
51 ,p_effective_date in date
52 ,p_datetrack_mode in varchar2
53 ,p_validation_start_date in date
54 ,p_validation_end_date in date
55 );
56 --
57 -- ----------------------------------------------------------------------------
58 -- |---------------------------< update_validate >----------------------------|
59 -- ----------------------------------------------------------------------------
60 -- {Start Of Comments}
61 --
62 -- Description:
63 -- This procedure controls the execution of all update business rules
64 -- validation.
65 --
66 -- Prerequisites:
67 -- This private procedure is called from upd procedure.
68 --
69 -- In Parameters:
70 -- A Pl/Sql record structre.
71 --
72 -- Post Success:
73 -- Processing continues.
74 --
75 -- Post Failure:
76 -- If a business rules fails the error will not be handled by this procedure
77 -- unless explicity coded.
78 --
79 -- Developer Implementation Notes:
80 -- For update, your business rules should be executed from this procedure and
81 -- should ideally (unless really necessary) just be straight procedure or
82 -- function calls. Try and avoid using conditional branching logic.
83 --
84 -- Access Status:
85 -- Internal Row Handler Use Only.
86 --
87 -- {End Of Comments}
88 -- ----------------------------------------------------------------------------
89 Procedure update_validate
90 (p_rec in ame_gcf_shd.g_rec_type
91 ,p_effective_date in date
92 ,p_datetrack_mode in varchar2
93 ,p_validation_start_date in date
94 ,p_validation_end_date in date
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 and
121 -- should ideally (unless really necessary) just be straight procedure or
122 -- 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 ame_gcf_shd.g_rec_type
131 ,p_effective_date in date
132 ,p_datetrack_mode in varchar2
133 ,p_validation_start_date in date
134 ,p_validation_end_date in date
135 );
136 --
137 end ame_gcf_bus;