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