[Home] [Help]
86: ,P_USER_ROW_USER_KEY in varchar2) is
87: blid number := p_data_pump_batch_line_id;
88: begin
89: if blid is not null then
90: delete from hr_pump_batch_lines where batch_line_id = blid;
91: delete from hr_pump_batch_exceptions
92: where source_type = 'BATCH_LINE' and source_id = blid;
93: end if;
94: insert into hr_pump_batch_lines
90: delete from hr_pump_batch_lines where batch_line_id = blid;
91: delete from hr_pump_batch_exceptions
92: where source_type = 'BATCH_LINE' and source_id = blid;
93: end if;
94: insert into hr_pump_batch_lines
95: (batch_id
96: ,batch_line_id
97: ,business_group_name
98: ,api_module_id
105: ,pval006
106: ,pval007)
107: values
108: (p_batch_id
109: ,nvl(blid,hr_pump_batch_lines_s.nextval)
110: ,p_data_pump_business_grp_name
111: ,3048
112: ,'U'
113: ,p_user_sequence
131: decode(l.pval004,cn,dn,d(l.pval004)) p4,
132: decode(l.pval005,cn,dn,d(l.pval005)) p5,
133: decode(l.pval006,cn,vn,l.pval006) p6,
134: decode(l.pval007,cn,vn,l.pval007) p7
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;
145: open cr;
146: fetch cr into c;
147: if cr%notfound then
148: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
149: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
150: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
151: hr_utility.set_message_token('VALUE',p_batch_line_id);
152: hr_utility.raise_error;
153: end if;
190: ,P_EFFECTIVE_END_DATE => c.p5);
191: hr_data_pump.api_trc_off;
192:
193: --
194: update hr_pump_batch_lines l set
195: l.pval004 = decode(c.p4,null,cn,dc(c.p4)),
196: l.pval005 = decode(c.p5,null,cn,dc(c.p5))
197: where l.rowid = c.myrowid;
198: --