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