[Home] [Help]
76: ,P_PERSON_USER_KEY in varchar2) is
77: blid number := p_data_pump_batch_line_id;
78: begin
79: if blid is not null then
80: delete from hr_pump_batch_lines where batch_line_id = blid;
81: delete from hr_pump_batch_exceptions
82: where source_type = 'BATCH_LINE' and source_id = blid;
83: end if;
84: insert into hr_pump_batch_lines
80: delete from hr_pump_batch_lines where batch_line_id = blid;
81: delete from hr_pump_batch_exceptions
82: where source_type = 'BATCH_LINE' and source_id = blid;
83: end if;
84: insert into hr_pump_batch_lines
85: (batch_id
86: ,batch_line_id
87: ,business_group_name
88: ,api_module_id
104: ,pval013
105: ,pval015)
106: values
107: (p_batch_id
108: ,nvl(blid,hr_pump_batch_lines_s.nextval)
109: ,p_data_pump_business_grp_name
110: ,1594
111: ,'U'
112: ,p_user_sequence
160: hr_pump_get.gl(l.pval013,'HR_EMP_EXTRACT_RUN_TYPE',dn,vn)) p13,
161: l.pval013 d13,
162: l.pval014 p14,
163: decode(l.pval015,cn,vn,l.pval015) p15
164: from hr_pump_batch_lines l
165: where l.batch_line_id = p_batch_line_id;
166: --
167: c cr%rowtype;
168: l_validate boolean := false;
173: open cr;
174: fetch cr into c;
175: if cr%notfound then
176: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
177: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
178: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
179: hr_utility.set_message_token('VALUE',p_batch_line_id);
180: hr_utility.raise_error;
181: end if;
208: ,c.p14);
209: hr_data_pump.api_trc_off;
210:
211: --
212: update hr_pump_batch_lines l set
213: l.pval014 = decode(c.p14,null,cn,c.p14)
214: where l.rowid = c.myrowid;
215: --
216: close cr;