APPS.BEN_EXT_ASG_EVT dependencies on BEN_EXT_CHLG

Line 7: l_old_rec ben_ext_chlg.g_asg_rec_type;

3: for each row
4: --
5: declare
6: --
7: l_old_rec ben_ext_chlg.g_asg_rec_type;
8: l_new_rec ben_ext_chlg.g_asg_rec_type;
9:
10: CURSOR csr_leg_cd (c_bus_grp_id IN number) is
11: SELECT legislation_code

Line 8: l_new_rec ben_ext_chlg.g_asg_rec_type;

4: --
5: declare
6: --
7: l_old_rec ben_ext_chlg.g_asg_rec_type;
8: l_new_rec ben_ext_chlg.g_asg_rec_type;
9:
10: CURSOR csr_leg_cd (c_bus_grp_id IN number) is
11: SELECT legislation_code
12: FROM per_business_groups_perf

Line 98: ben_ext_chlg.log_asg_chg

94: l_old_rec.update_mode := 'UPDATE';
95: end if;
96: --
97: if :new.primary_flag = 'Y' then
98: ben_ext_chlg.log_asg_chg
99: (p_event => 'UPDATE'
100: ,p_old_rec => l_old_rec
101: ,p_new_rec => l_new_rec
102: );

Line 112: ben_ext_chlg.log_asg_chg

108: fetch csr_leg_cd InTo l_leg_code;
109:
110: if csr_leg_cd%FOUND And
111: l_leg_code = 'NL' Then
112: ben_ext_chlg.log_asg_chg
113: (p_event => 'UPDATE'
114: ,p_old_rec => l_old_rec
115: ,p_new_rec => l_new_rec
116: );

Line 129: ben_ext_chlg.log_asg_chg

125: fetch csr_leg_cd InTo l_leg_code;
126:
127: if csr_leg_cd%FOUND And
128: l_leg_code = 'NL' Then
129: ben_ext_chlg.log_asg_chg
130: (p_event => 'UPDATE'
131: ,p_old_rec => l_old_rec
132: ,p_new_rec => l_new_rec
133: );

Line 138: ben_ext_chlg.log_asg_chg

134: END IF;
135: end if;
136: --
137: elsif INSERTING then
138: ben_ext_chlg.log_asg_chg
139: (p_event => 'INSERT'
140: ,p_old_rec => l_old_rec
141: ,p_new_rec => l_new_rec
142: );

Line 144: ben_ext_chlg.log_asg_chg

140: ,p_old_rec => l_old_rec
141: ,p_new_rec => l_new_rec
142: );
143: elsif DELETING then
144: ben_ext_chlg.log_asg_chg
145: (p_event => 'DELETE'
146: ,p_old_rec => l_old_rec
147: ,p_new_rec => l_new_rec
148: );