APPS.HRDPP_CREATE_GB_PERSON_ADDRESS dependencies on HR_PUMP_BATCH_LINES

Line 141: delete from hr_pump_batch_lines where batch_line_id = blid;

137: else
138: L_PRADD_OVLAPVAL_OVERRIDE := 'FALSE';
139: end if;
140: if blid is not null then
141: delete from hr_pump_batch_lines where batch_line_id = blid;
142: delete from hr_pump_batch_exceptions
143: where source_type = 'BATCH_LINE' and source_id = blid;
144: end if;
145: insert into hr_pump_batch_lines

Line 145: insert into hr_pump_batch_lines

141: delete from hr_pump_batch_lines where batch_line_id = blid;
142: delete from hr_pump_batch_exceptions
143: where source_type = 'BATCH_LINE' and source_id = blid;
144: end if;
145: insert into hr_pump_batch_lines
146: (batch_id
147: ,batch_line_id
148: ,business_group_name
149: ,api_module_id

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

199: ,pval048
200: ,pval049)
201: values
202: (p_batch_id
203: ,nvl(blid,hr_pump_batch_lines_s.nextval)
204: ,p_data_pump_business_grp_name
205: ,1379
206: ,'U'
207: ,p_user_sequence

Line 357: from hr_pump_batch_lines l

353: l.pval047 p47,
354: decode(l.pval048,cn,vn,vn,vn,l.pval048) p48,
355: l.pval048 d48,
356: decode(l.pval049,cn,vn,l.pval049) p49
357: from hr_pump_batch_lines l
358: where l.batch_line_id = p_batch_line_id;
359: --
360: c cr%rowtype;
361: l_validate boolean := false;

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

370: open cr;
371: fetch cr into c;
372: if cr%notfound then
373: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
374: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
375: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
376: hr_utility.set_message_token('VALUE',p_batch_line_id);
377: hr_utility.raise_error;
378: end if;

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

385: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
386: hr_utility.set_message_token('TYPE','BOOLEAN');
387: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
388: hr_utility.set_message_token('VALUE',c.p2);
389: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
390: hr_utility.raise_error;
391: end if;
392: --
393: L_COMMENTS := c.plongval;

Line 470: update hr_pump_batch_lines l set

466: hr_data_pump.api_trc_off;
467: --
468: iuk(p_batch_line_id,c.p46,L_ADDRESS_ID);
469: --
470: update hr_pump_batch_lines l set
471: l.pval046 = decode(c.p46,null,cn,c.p46),
472: l.pval047 = decode(c.p47,null,cn,c.p47)
473: where l.rowid = c.myrowid;
474: --