[Home] [Help]
84: ,P_EFFECTIVE_DATE in date) is
85: blid number := p_data_pump_batch_line_id;
86: begin
87: if blid is not null then
88: delete from hr_pump_batch_lines where batch_line_id = blid;
89: delete from hr_pump_batch_exceptions
90: where source_type = 'BATCH_LINE' and source_id = blid;
91: end if;
92: insert into hr_pump_batch_lines
88: delete from hr_pump_batch_lines where batch_line_id = blid;
89: delete from hr_pump_batch_exceptions
90: where source_type = 'BATCH_LINE' and source_id = blid;
91: end if;
92: insert into hr_pump_batch_lines
93: (batch_id
94: ,batch_line_id
95: ,business_group_name
96: ,api_module_id
101: ,pval002
102: ,pval003)
103: values
104: (p_batch_id
105: ,nvl(blid,hr_pump_batch_lines_s.nextval)
106: ,p_data_pump_business_grp_name
107: ,2836
108: ,'U'
109: ,p_user_sequence
120: select l.rowid myrowid,
121: decode(l.pval001,cn,nn,n(l.pval001)) p1,
122: decode(l.pval002,cn,vn,l.pval002) p2,
123: decode(l.pval003,cn,dn,d(l.pval003)) p3
124: from hr_pump_batch_lines l
125: where l.batch_line_id = p_batch_line_id;
126: --
127: c cr%rowtype;
128: l_validate boolean := false;
133: open cr;
134: fetch cr into c;
135: if cr%notfound then
136: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
137: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
138: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
139: hr_utility.set_message_token('VALUE',p_batch_line_id);
140: hr_utility.raise_error;
141: end if;
158: ,P_OBJECT_VERSION_NUMBER => c.p1);
159: hr_data_pump.api_trc_off;
160:
161: --
162: update hr_pump_batch_lines l set
163: l.pval001 = decode(c.p1,null,cn,c.p1)
164: where l.rowid = c.myrowid;
165: --
166: close cr;