APPS.HRDPP_CREATE_PERSON_ADDRESS dependencies on HR_PUMP_BATCH_LINES

Line 154: delete from hr_pump_batch_lines where batch_line_id = blid;

150: else
151: L_VALIDATE_COUNTY := 'FALSE';
152: end if;
153: if blid is not null then
154: delete from hr_pump_batch_lines where batch_line_id = blid;
155: delete from hr_pump_batch_exceptions
156: where source_type = 'BATCH_LINE' and source_id = blid;
157: end if;
158: insert into hr_pump_batch_lines

Line 158: insert into hr_pump_batch_lines

154: delete from hr_pump_batch_lines where batch_line_id = blid;
155: delete from hr_pump_batch_exceptions
156: where source_type = 'BATCH_LINE' and source_id = blid;
157: end if;
158: insert into hr_pump_batch_lines
159: (batch_id
160: ,batch_line_id
161: ,business_group_name
162: ,api_module_id

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

217: ,pval053
218: ,pval054)
219: values
220: (p_batch_id
221: ,nvl(blid,hr_pump_batch_lines_s.nextval)
222: ,p_data_pump_business_grp_name
223: ,1183
224: ,'U'
225: ,p_user_sequence

Line 391: from hr_pump_batch_lines l

387: decode(l.pval053,cn,vn,vn,vn,l.pval053) p53,
388: l.pval053 d53,
389: decode(l.pval054,cn,vn,vn,vn,l.pval054) p54,
390: l.pval054 d54
391: from hr_pump_batch_lines l
392: where l.batch_line_id = p_batch_line_id;
393: --
394: c cr%rowtype;
395: l_validate boolean := false;

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

404: open cr;
405: fetch cr into c;
406: if cr%notfound then
407: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
408: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
409: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
410: hr_utility.set_message_token('VALUE',p_batch_line_id);
411: hr_utility.raise_error;
412: end if;

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

419: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
420: hr_utility.set_message_token('TYPE','BOOLEAN');
421: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
422: hr_utility.set_message_token('VALUE',c.p2);
423: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
424: hr_utility.raise_error;
425: end if;
426: --
427: if upper(c.p3) = 'TRUE' then

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

432: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
433: hr_utility.set_message_token('TYPE','BOOLEAN');
434: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
435: hr_utility.set_message_token('VALUE',c.p3);
436: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
437: hr_utility.raise_error;
438: end if;
439: --
440: if c.p53 is null then

Line 517: update hr_pump_batch_lines l set

513: hr_data_pump.api_trc_off;
514: --
515: iuk(p_batch_line_id,c.p51,L_ADDRESS_ID);
516: --
517: update hr_pump_batch_lines l set
518: l.pval051 = decode(c.p51,null,cn,c.p51),
519: l.pval052 = decode(c.p52,null,cn,c.p52)
520: where l.rowid = c.myrowid;
521: --