APPS.HRDPP_DELETE_PRTT_RT_VAL dependencies on HR_PUMP_BATCH_LINES

Line 89: delete from hr_pump_batch_lines where batch_line_id = blid;

85: ,P_PERSON_USER_KEY in varchar2) is
86: blid number := p_data_pump_batch_line_id;
87: begin
88: if blid is not null then
89: delete from hr_pump_batch_lines where batch_line_id = blid;
90: delete from hr_pump_batch_exceptions
91: where source_type = 'BATCH_LINE' and source_id = blid;
92: end if;
93: insert into hr_pump_batch_lines

Line 93: insert into hr_pump_batch_lines

89: delete from hr_pump_batch_lines where batch_line_id = blid;
90: delete from hr_pump_batch_exceptions
91: where source_type = 'BATCH_LINE' and source_id = blid;
92: end if;
93: insert into hr_pump_batch_lines
94: (batch_id
95: ,batch_line_id
96: ,business_group_name
97: ,api_module_id

Line 107: ,nvl(blid,hr_pump_batch_lines_s.nextval)

103: ,pval003
104: ,pval004)
105: values
106: (p_batch_id
107: ,nvl(blid,hr_pump_batch_lines_s.nextval)
108: ,p_data_pump_business_grp_name
109: ,707
110: ,'U'
111: ,p_user_sequence

Line 129: from hr_pump_batch_lines l

125: decode(l.pval002,cn,vn,l.pval002) p2,
126: decode(l.pval003,cn,vn,vn,vn,l.pval003) p3,
127: l.pval003 d3,
128: decode(l.pval004,cn,vn,l.pval004) p4
129: from hr_pump_batch_lines l
130: where l.batch_line_id = p_batch_line_id;
131: --
132: c cr%rowtype;
133: l_validate boolean := false;

Line 145: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

141: open cr;
142: fetch cr into c;
143: if cr%notfound then
144: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
145: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
146: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
147: hr_utility.set_message_token('VALUE',p_batch_line_id);
148: hr_utility.raise_error;
149: end if;