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 390: from hr_pump_batch_lines l

386: decode(l.pval053,cn,vn,vn,vn,l.pval053) p53,
387: l.pval053 d53,
388: decode(l.pval054,cn,vn,vn,vn,l.pval054) p54,
389: l.pval054 d54
390: from hr_pump_batch_lines l
391: where l.batch_line_id = p_batch_line_id;
392: --
393: c cr%rowtype;
394: 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: L_COMMENTS := c.plongval;

Line 522: update hr_pump_batch_lines l set

518: hr_data_pump.api_trc_off;
519: --
520: iuk(p_batch_line_id,c.p51,L_ADDRESS_ID);
521: --
522: update hr_pump_batch_lines l set
523: l.pval051 = decode(c.p51,null,cn,c.p51),
524: l.pval052 = decode(c.p52,null,cn,c.p52)
525: where l.rowid = c.myrowid;
526: --