APPS.HRDPP_CREATE_US_PERSON_ADDRESS dependencies on HR_PUMP_BATCH_LINES

Line 151: delete from hr_pump_batch_lines where batch_line_id = blid;

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

Line 155: insert into hr_pump_batch_lines

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

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

211: ,pval050
212: ,pval051)
213: values
214: (p_batch_id
215: ,nvl(blid,hr_pump_batch_lines_s.nextval)
216: ,p_data_pump_business_grp_name
217: ,1378
218: ,'U'
219: ,p_user_sequence

Line 375: from hr_pump_batch_lines l

371: l.pval049 p49,
372: decode(l.pval050,cn,vn,vn,vn,l.pval050) p50,
373: l.pval050 d50,
374: decode(l.pval051,cn,vn,l.pval051) p51
375: from hr_pump_batch_lines l
376: where l.batch_line_id = p_batch_line_id;
377: --
378: c cr%rowtype;
379: l_validate boolean := false;

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

389: open cr;
390: fetch cr into c;
391: if cr%notfound then
392: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
393: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
394: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
395: hr_utility.set_message_token('VALUE',p_batch_line_id);
396: hr_utility.raise_error;
397: end if;

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

404: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
405: hr_utility.set_message_token('TYPE','BOOLEAN');
406: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
407: hr_utility.set_message_token('VALUE',c.p2);
408: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
409: hr_utility.raise_error;
410: end if;
411: --
412: if upper(c.p3) = 'TRUE' then

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

417: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
418: hr_utility.set_message_token('TYPE','BOOLEAN');
419: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
420: hr_utility.set_message_token('VALUE',c.p3);
421: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
422: hr_utility.raise_error;
423: end if;
424: --
425: L_COMMENTS := c.plongval;

Line 504: update hr_pump_batch_lines l set

500: hr_data_pump.api_trc_off;
501: --
502: iuk(p_batch_line_id,c.p48,L_ADDRESS_ID);
503: --
504: update hr_pump_batch_lines l set
505: l.pval048 = decode(c.p48,null,cn,c.p48),
506: l.pval049 = decode(c.p49,null,cn,c.p49)
507: where l.rowid = c.myrowid;
508: --