APPS.HRDPP_UPDATE_MX_EMP_ASG_CRITER dependencies on HR_PUMP_BATCH_LINES

Line 147: delete from hr_pump_batch_lines where batch_line_id = blid;

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

Line 151: insert into hr_pump_batch_lines

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

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

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

Line 396: from hr_pump_batch_lines l

392: l.pval062 d62,
393: decode(l.pval063,cn,vn,vn,vn,l.pval063) p63,
394: l.pval063 d63,
395: decode(l.pval064,cn,vn,l.pval064) p64
396: from hr_pump_batch_lines l
397: where l.batch_line_id = p_batch_line_id;
398: --
399: c cr%rowtype;
400: l_validate boolean := false;

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

424: open cr;
425: fetch cr into c;
426: if cr%notfound then
427: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
428: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
429: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
430: hr_utility.set_message_token('VALUE',p_batch_line_id);
431: hr_utility.raise_error;
432: end if;

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

439: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
440: hr_utility.set_message_token('TYPE','BOOLEAN');
441: hr_utility.set_message_token('PARAMETER','P_CALLED_FROM_MASS_UPDATE');
442: hr_utility.set_message_token('VALUE',c.p3);
443: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
444: hr_utility.raise_error;
445: end if;
446: --
447: if c.p49 is null then

Line 717: update hr_pump_batch_lines l set

713: else
714: c.p46 := 'FALSE';
715: end if;
716: --
717: update hr_pump_batch_lines l set
718: l.pval037 = decode(c.p37,null,cn,c.p37),
719: l.pval038 = decode(c.p38,null,cn,c.p38),
720: l.pval039 = decode(c.p39,null,cn,c.p39),
721: l.pval040 = decode(c.p40,null,cn,dc(c.p40)),