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