[Home] [Help]
92: else
93: L_PERFORM_PREDEL_VALIDATION := 'FALSE';
94: end if;
95: if blid is not null then
96: delete from hr_pump_batch_lines where batch_line_id = blid;
97: delete from hr_pump_batch_exceptions
98: where source_type = 'BATCH_LINE' and source_id = blid;
99: end if;
100: insert into hr_pump_batch_lines
96: delete from hr_pump_batch_lines where batch_line_id = blid;
97: delete from hr_pump_batch_exceptions
98: where source_type = 'BATCH_LINE' and source_id = blid;
99: end if;
100: insert into hr_pump_batch_lines
101: (batch_id
102: ,batch_line_id
103: ,business_group_name
104: ,api_module_id
109: ,pval002
110: ,pval004)
111: values
112: (p_batch_id
113: ,nvl(blid,hr_pump_batch_lines_s.nextval)
114: ,p_data_pump_business_grp_name
115: ,3691
116: ,'U'
117: ,p_user_sequence
130: decode(l.pval002,cn,vn,vn,null,l.pval002) p2,
131: l.pval002 d2,
132: l.pval003 p3,
133: decode(l.pval004,cn,vn,l.pval004) p4
134: from hr_pump_batch_lines l
135: where l.batch_line_id = p_batch_line_id;
136: --
137: c cr%rowtype;
138: l_validate boolean := false;
144: open cr;
145: fetch cr into c;
146: if cr%notfound then
147: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
148: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
149: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
150: hr_utility.set_message_token('VALUE',p_batch_line_id);
151: hr_utility.raise_error;
152: end if;
159: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
160: hr_utility.set_message_token('TYPE','BOOLEAN');
161: hr_utility.set_message_token('PARAMETER','P_PERFORM_PREDEL_VALIDATION');
162: hr_utility.set_message_token('VALUE',c.p2);
163: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
164: hr_utility.raise_error;
165: end if;
166: --
167: if c.p4 is null then
181: ,P_PERSON_ORG_MANAGER_WARNING => c.p3);
182: hr_data_pump.api_trc_off;
183:
184: --
185: update hr_pump_batch_lines l set
186: l.pval003 = decode(c.p3,null,cn,c.p3)
187: where l.rowid = c.myrowid;
188: --
189: close cr;