[Home] [Help]
85: ,P_LANGUAGE_CODE in varchar2) 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: ,pval005
104: ,pval006)
105: values
106: (p_batch_id
107: ,nvl(blid,hr_pump_batch_lines_s.nextval)
108: ,p_data_pump_business_grp_name
109: ,2208
110: ,'U'
111: ,p_user_sequence
127: l.pval003 p3,
128: l.pval004 p4,
129: decode(l.pval005,cn,vn,l.pval005) p5,
130: decode(l.pval006,cn,vn,l.pval006) p6
131: from hr_pump_batch_lines l
132: where l.batch_line_id = p_batch_line_id;
133: --
134: c cr%rowtype;
135: l_validate boolean := false;
140: open cr;
141: fetch cr into c;
142: if cr%notfound then
143: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
144: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
145: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
146: hr_utility.set_message_token('VALUE',p_batch_line_id);
147: hr_utility.raise_error;
148: end if;
170: ,P_OBJECT_VERSION_NUMBER => c.p4);
171: hr_data_pump.api_trc_off;
172:
173: --
174: update hr_pump_batch_lines l set
175: l.pval003 = decode(c.p3,null,cn,c.p3),
176: l.pval004 = decode(c.p4,null,cn,c.p4)
177: where l.rowid = c.myrowid;
178: --