1 Package pqh_rng_bus as
2 /* $Header: pqrngrhi.pkh 120.0 2005/05/29 02:36:01 appldev noship $ */
3 --
4 FUNCTION chk_if_member_enabled(p_routing_list_id in number,
5 p_routing_list_member_id in number)
6 RETURN NUMBER;
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_rng_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_rng_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_rng_shd.g_rec_type
111 ,p_effective_date in date);
112 --
113 end pqh_rng_bus;