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