[Home] [Help]
83: ,P_PERSON_USER_KEY in varchar2) is
84: blid number := p_data_pump_batch_line_id;
85: begin
86: if blid is not null then
87: delete from hr_pump_batch_lines where batch_line_id = blid;
88: delete from hr_pump_batch_exceptions
89: where source_type = 'BATCH_LINE' and source_id = blid;
90: end if;
91: insert into hr_pump_batch_lines
87: delete from hr_pump_batch_lines where batch_line_id = blid;
88: delete from hr_pump_batch_exceptions
89: where source_type = 'BATCH_LINE' and source_id = blid;
90: end if;
91: insert into hr_pump_batch_lines
92: (batch_id
93: ,batch_line_id
94: ,business_group_name
95: ,api_module_id
99: ,pval001
100: ,pval005)
101: values
102: (p_batch_id
103: ,nvl(blid,hr_pump_batch_lines_s.nextval)
104: ,p_data_pump_business_grp_name
105: ,1200
106: ,'U'
107: ,p_user_sequence
119: l.pval002 p2,
120: l.pval003 p3,
121: l.pval004 p4,
122: decode(l.pval005,cn,vn,l.pval005) p5
123: from hr_pump_batch_lines l
124: where l.batch_line_id = p_batch_line_id;
125: --
126: c cr%rowtype;
127: l_validate boolean := false;
135: open cr;
136: fetch cr into c;
137: if cr%notfound then
138: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
139: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
140: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
141: hr_utility.set_message_token('VALUE',p_batch_line_id);
142: hr_utility.raise_error;
143: end if;
182: else
183: c.p3 := 'FALSE';
184: end if;
185: --
186: update hr_pump_batch_lines l set
187: l.pval001 = decode(c.p1,null,cn,dc(c.p1)),
188: l.pval002 = decode(c.p2,null,cn,c.p2),
189: l.pval003 = decode(c.p3,null,cn,c.p3),
190: l.pval004 = decode(c.p4,null,cn,c.p4)