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