APPS.HRDPP_CREATE_CN_PERSON_ADDRESS dependencies on HR_PUMP_BATCH_LINES

Line 148: delete from hr_pump_batch_lines where batch_line_id = blid;

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

Line 152: insert into hr_pump_batch_lines

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

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

205: ,pval047
206: ,pval048)
207: values
208: (p_batch_id
209: ,nvl(blid,hr_pump_batch_lines_s.nextval)
210: ,p_data_pump_business_grp_name
211: ,2906
212: ,'U'
213: ,p_user_sequence

Line 358: from hr_pump_batch_lines l

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

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

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

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

387: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
388: hr_utility.set_message_token('TYPE','BOOLEAN');
389: hr_utility.set_message_token('PARAMETER','P_PRADD_OVLAPVAL_OVERRIDE');
390: hr_utility.set_message_token('VALUE',c.p2);
391: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
392: hr_utility.raise_error;
393: end if;
394: --
395: if upper(c.p3) = 'TRUE' then

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

400: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
401: hr_utility.set_message_token('TYPE','BOOLEAN');
402: hr_utility.set_message_token('PARAMETER','P_VALIDATE_COUNTY');
403: hr_utility.set_message_token('VALUE',c.p3);
404: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
405: hr_utility.raise_error;
406: end if;
407: --
408: L_COMMENTS := c.plongval;

Line 484: update hr_pump_batch_lines l set

480: hr_data_pump.api_trc_off;
481: --
482: iuk(p_batch_line_id,c.p45,L_ADDRESS_ID);
483: --
484: update hr_pump_batch_lines l set
485: l.pval045 = decode(c.p45,null,cn,c.p45),
486: l.pval046 = decode(c.p46,null,cn,c.p46)
487: where l.rowid = c.myrowid;
488: --