APPS.HRDPP_HIRE_MX_APPLICANT dependencies on HR_PUMP_BATCH_LINES

Line 103: delete from hr_pump_batch_lines where batch_line_id = blid;

99: else
100: L_MIGRATE := 'FALSE';
101: end if;
102: if blid is not null then
103: delete from hr_pump_batch_lines where batch_line_id = blid;
104: delete from hr_pump_batch_exceptions
105: where source_type = 'BATCH_LINE' and source_id = blid;
106: end if;
107: insert into hr_pump_batch_lines

Line 107: insert into hr_pump_batch_lines

103: delete from hr_pump_batch_lines where batch_line_id = blid;
104: delete from hr_pump_batch_exceptions
105: where source_type = 'BATCH_LINE' and source_id = blid;
106: end if;
107: insert into hr_pump_batch_lines
108: (batch_id
109: ,batch_line_id
110: ,business_group_name
111: ,api_module_id

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

122: ,pval013
123: ,pval014)
124: values
125: (p_batch_id
126: ,nvl(blid,hr_pump_batch_lines_s.nextval)
127: ,p_data_pump_business_grp_name
128: ,3856
129: ,'U'
130: ,p_user_sequence

Line 168: from hr_pump_batch_lines l

164: decode(l.pval013,cn,vn,vn,vh,l.pval013) p13,
165: l.pval013 d13,
166: decode(l.pval014,cn,vn,vn,vh,l.pval014) p14,
167: l.pval014 d14
168: from hr_pump_batch_lines l
169: where l.batch_line_id = p_batch_line_id;
170: --
171: c cr%rowtype;
172: l_validate boolean := false;

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

183: open cr;
184: fetch cr into c;
185: if cr%notfound then
186: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
187: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
188: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
189: hr_utility.set_message_token('VALUE',p_batch_line_id);
190: hr_utility.raise_error;
191: end if;

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

198: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
199: hr_utility.set_message_token('TYPE','BOOLEAN');
200: hr_utility.set_message_token('PARAMETER','P_MIGRATE');
201: hr_utility.set_message_token('VALUE',c.p10);
202: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
203: hr_utility.raise_error;
204: end if;
205: --
206: if c.p11 is null then

Line 279: update hr_pump_batch_lines l set

275: else
276: c.p7 := 'FALSE';
277: end if;
278: --
279: update hr_pump_batch_lines l set
280: l.pval003 = decode(c.p3,null,cn,c.p3),
281: l.pval004 = decode(c.p4,null,cn,dc(c.p4)),
282: l.pval005 = decode(c.p5,null,cn,dc(c.p5)),
283: l.pval006 = decode(c.p6,null,cn,c.p6),