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