[Home] [Help]
85: ,P_LANGUAGE_CODE in varchar2 default null) is
86: blid number := p_data_pump_batch_line_id;
87: begin
88: if blid is not null then
89: delete from hr_pump_batch_lines where batch_line_id = blid;
90: delete from hr_pump_batch_exceptions
91: where source_type = 'BATCH_LINE' and source_id = blid;
92: end if;
93: insert into hr_pump_batch_lines
89: delete from hr_pump_batch_lines where batch_line_id = blid;
90: delete from hr_pump_batch_exceptions
91: where source_type = 'BATCH_LINE' and source_id = blid;
92: end if;
93: insert into hr_pump_batch_lines
94: (batch_id
95: ,batch_line_id
96: ,business_group_name
97: ,api_module_id
103: ,pval008
104: ,pval009)
105: values
106: (p_batch_id
107: ,nvl(blid,hr_pump_batch_lines_s.nextval)
108: ,p_data_pump_business_grp_name
109: ,1187
110: ,'U'
111: ,p_user_sequence
131: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
132: l.pval008 d8,
133: decode(l.pval009,cn,vn,vn,vh,l.pval009) p9,
134: l.pval009 d9
135: from hr_pump_batch_lines l
136: where l.batch_line_id = p_batch_line_id;
137: --
138: c cr%rowtype;
139: l_validate boolean := false;
148: open cr;
149: fetch cr into c;
150: if cr%notfound then
151: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
152: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
153: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
154: hr_utility.set_message_token('VALUE',p_batch_line_id);
155: hr_utility.raise_error;
156: end if;
212: else
213: c.p6 := 'FALSE';
214: end if;
215: --
216: update hr_pump_batch_lines l set
217: l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
218: l.pval003 = decode(c.p3,null,cn,dc(c.p3)),
219: l.pval004 = decode(c.p4,null,cn,c.p4),
220: l.pval005 = decode(c.p5,null,cn,c.p5),