[Home] [Help]
84: ,P_PERSONAL_PAY_METHOD_USER_KEY 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: ,pval002
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: ,1389
108: ,'U'
109: ,p_user_sequence
122: decode(l.pval002,cn,vn,l.pval002) p2,
123: decode(l.pval003,cn,dn,d(l.pval003)) p3,
124: decode(l.pval004,cn,dn,d(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;
172: ,P_EFFECTIVE_END_DATE => c.p4);
173: hr_data_pump.api_trc_off;
174:
175: --
176: update hr_pump_batch_lines l set
177: l.pval003 = decode(c.p3,null,cn,dc(c.p3)),
178: l.pval004 = decode(c.p4,null,cn,dc(c.p4))
179: where l.rowid = c.myrowid;
180: --