APPS.HRDPP_DELETE_BAL_TYPE dependencies on HR_PUMP_BATCH_LINES

Line 86: delete from hr_pump_batch_lines where batch_line_id = blid;

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

Line 90: insert into hr_pump_batch_lines

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

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

97: ,link_value
98: ,pval001)
99: values
100: (p_batch_id
101: ,nvl(blid,hr_pump_batch_lines_s.nextval)
102: ,p_data_pump_business_grp_name
103: ,3586
104: ,'U'
105: ,p_user_sequence

Line 116: from hr_pump_batch_lines l

112: p_batch_line_id in number) is
113: cursor cr is
114: select l.rowid myrowid,
115: decode(l.pval001,cn,vn,l.pval001) p1
116: from hr_pump_batch_lines l
117: where l.batch_line_id = p_batch_line_id;
118: --
119: c cr%rowtype;
120: l_validate boolean := false;

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

126: open cr;
127: fetch cr into c;
128: if cr%notfound then
129: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
130: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
131: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
132: hr_utility.set_message_token('VALUE',p_batch_line_id);
133: hr_utility.raise_error;
134: end if;