[Home] [Help]
94: else
95: L_MULTI_ROW_ACTN := 'FALSE';
96: end if;
97: if blid is not null then
98: delete from hr_pump_batch_lines where batch_line_id = blid;
99: delete from hr_pump_batch_exceptions
100: where source_type = 'BATCH_LINE' and source_id = blid;
101: end if;
102: insert into hr_pump_batch_lines
98: delete from hr_pump_batch_lines where batch_line_id = blid;
99: delete from hr_pump_batch_exceptions
100: where source_type = 'BATCH_LINE' and source_id = blid;
101: end if;
102: insert into hr_pump_batch_lines
103: (batch_id
104: ,batch_line_id
105: ,business_group_name
106: ,api_module_id
113: ,pval006
114: ,pval007)
115: values
116: (p_batch_id
117: ,nvl(blid,hr_pump_batch_lines_s.nextval)
118: ,p_data_pump_business_grp_name
119: ,608
120: ,'U'
121: ,p_user_sequence
139: decode(l.pval005,cn,vn,vn,null,l.pval005) p5,
140: l.pval005 d5,
141: decode(l.pval006,cn,vn,l.pval006) p6,
142: decode(l.pval007,cn,vn,l.pval007) p7
143: from hr_pump_batch_lines l
144: where l.batch_line_id = p_batch_line_id;
145: --
146: c cr%rowtype;
147: l_validate boolean := false;
154: open cr;
155: fetch cr into c;
156: if cr%notfound then
157: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
158: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
159: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
160: hr_utility.set_message_token('VALUE',p_batch_line_id);
161: hr_utility.raise_error;
162: end if;
169: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
170: hr_utility.set_message_token('TYPE','BOOLEAN');
171: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
172: hr_utility.set_message_token('VALUE',c.p5);
173: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
174: hr_utility.raise_error;
175: end if;
176: --
177: if c.p7 is null then
206: ,P_CALLED_FROM => c.p6);
207: hr_data_pump.api_trc_off;
208:
209: --
210: update hr_pump_batch_lines l set
211: l.pval001 = decode(c.p1,null,cn,dc(c.p1)),
212: l.pval002 = decode(c.p2,null,cn,dc(c.p2))
213: where l.rowid = c.myrowid;
214: --