[Home] [Help]
84: ,P_LIFE_EVENT_REASON in varchar2) 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: ,pval004
102: ,pval005)
103: values
104: (p_batch_id
105: ,nvl(blid,hr_pump_batch_lines_s.nextval)
106: ,p_data_pump_business_grp_name
107: ,479
108: ,'U'
109: ,p_user_sequence
122: decode(l.pval002,cn,dn,d(l.pval002)) p2,
123: decode(l.pval003,cn,dn,d(l.pval003)) p3,
124: decode(l.pval004,cn,vn,l.pval004) p4,
125: decode(l.pval005,cn,vn,l.pval005) p5
126: from hr_pump_batch_lines l
127: where l.batch_line_id = p_batch_line_id;
128: --
129: c cr%rowtype;
130: l_validate boolean := false;
136: open cr;
137: fetch cr into c;
138: if cr%notfound then
139: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
140: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
141: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
142: hr_utility.set_message_token('VALUE',p_batch_line_id);
143: hr_utility.raise_error;
144: end if;
176: ,P_DATETRACK_MODE => c.p4);
177: hr_data_pump.api_trc_off;
178:
179: --
180: update hr_pump_batch_lines l set
181: l.pval001 = decode(c.p1,null,cn,dc(c.p1)),
182: l.pval002 = decode(c.p2,null,cn,dc(c.p2))
183: where l.rowid = c.myrowid;
184: --