[Home] [Help]
84: ,P_PERSON_USER_KEY in varchar2) is
85: blid number := p_data_pump_batch_line_id;
86: begin
87: if blid is not null then
88: delete from hr_pump_batch_lines where batch_line_id = blid;
89: delete from hr_pump_batch_exceptions
90: where source_type = 'BATCH_LINE' and source_id = blid;
91: end if;
92: insert into hr_pump_batch_lines
88: delete from hr_pump_batch_lines where batch_line_id = blid;
89: delete from hr_pump_batch_exceptions
90: where source_type = 'BATCH_LINE' and source_id = blid;
91: end if;
92: insert into hr_pump_batch_lines
93: (batch_id
94: ,batch_line_id
95: ,business_group_name
96: ,api_module_id
101: ,pval002
102: ,pval006)
103: values
104: (p_batch_id
105: ,nvl(blid,hr_pump_batch_lines_s.nextval)
106: ,p_data_pump_business_grp_name
107: ,3863
108: ,'U'
109: ,p_user_sequence
125: l.pval003 p3,
126: l.pval004 p4,
127: l.pval005 p5,
128: decode(l.pval006,cn,vn,l.pval006) p6
129: from hr_pump_batch_lines l
130: where l.batch_line_id = p_batch_line_id;
131: --
132: c cr%rowtype;
133: l_validate boolean := false;
141: open cr;
142: fetch cr into c;
143: if cr%notfound then
144: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
145: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
146: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
147: hr_utility.set_message_token('VALUE',p_batch_line_id);
148: hr_utility.raise_error;
149: end if;
189: else
190: c.p4 := 'FALSE';
191: end if;
192: --
193: update hr_pump_batch_lines l set
194: l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
195: l.pval003 = decode(c.p3,null,cn,c.p3),
196: l.pval004 = decode(c.p4,null,cn,c.p4),
197: l.pval005 = decode(c.p5,null,cn,c.p5)