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