APPS.HRDPP_CREATE_TAXABILITY_RULES dependencies on HR_PUMP_BATCH_LINES

Line 101: delete from hr_pump_batch_lines where batch_line_id = blid;

97: ,P_SPREADSHEET_IDENTIFIER in varchar2 default null) is
98: blid number := p_data_pump_batch_line_id;
99: begin
100: if blid is not null then
101: delete from hr_pump_batch_lines where batch_line_id = blid;
102: delete from hr_pump_batch_exceptions
103: where source_type = 'BATCH_LINE' and source_id = blid;
104: end if;
105: insert into hr_pump_batch_lines

Line 105: insert into hr_pump_batch_lines

101: delete from hr_pump_batch_lines where batch_line_id = blid;
102: delete from hr_pump_batch_exceptions
103: where source_type = 'BATCH_LINE' and source_id = blid;
104: end if;
105: insert into hr_pump_batch_lines
106: (batch_id
107: ,batch_line_id
108: ,business_group_name
109: ,api_module_id

Line 131: ,nvl(blid,hr_pump_batch_lines_s.nextval)

127: ,pval015
128: ,pval016)
129: values
130: (p_batch_id
131: ,nvl(blid,hr_pump_batch_lines_s.nextval)
132: ,p_data_pump_business_grp_name
133: ,3849
134: ,'U'
135: ,p_user_sequence

Line 190: from hr_pump_batch_lines l

186: decode(l.pval015,cn,vn,vn,vn,l.pval015) p15,
187: l.pval015 d15,
188: decode(l.pval016,cn,vn,vn,vn,l.pval016) p16,
189: l.pval016 d16
190: from hr_pump_batch_lines l
191: where l.batch_line_id = p_batch_line_id;
192: --
193: c cr%rowtype;
194: l_validate boolean := false;

Line 202: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

198: open cr;
199: fetch cr into c;
200: if cr%notfound then
201: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
202: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
203: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
204: hr_utility.set_message_token('VALUE',p_batch_line_id);
205: hr_utility.raise_error;
206: end if;