APPS.HRDPP_DELETE_PLAN_BENEFICIARY dependencies on HR_PUMP_BATCH_LINES

Line 97: delete from hr_pump_batch_lines where batch_line_id = blid;

93: else
94: L_MULTI_ROW_ACTN := 'FALSE';
95: end if;
96: if blid is not null then
97: delete from hr_pump_batch_lines where batch_line_id = blid;
98: delete from hr_pump_batch_exceptions
99: where source_type = 'BATCH_LINE' and source_id = blid;
100: end if;
101: insert into hr_pump_batch_lines

Line 101: insert into hr_pump_batch_lines

97: delete from hr_pump_batch_lines where batch_line_id = blid;
98: delete from hr_pump_batch_exceptions
99: where source_type = 'BATCH_LINE' and source_id = blid;
100: end if;
101: insert into hr_pump_batch_lines
102: (batch_id
103: ,batch_line_id
104: ,business_group_name
105: ,api_module_id

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

111: ,pval005
112: ,pval006)
113: values
114: (p_batch_id
115: ,nvl(blid,hr_pump_batch_lines_s.nextval)
116: ,p_data_pump_business_grp_name
117: ,570
118: ,'U'
119: ,p_user_sequence

Line 139: from hr_pump_batch_lines l

135: decode(l.pval004,cn,vn,l.pval004) p4,
136: decode(l.pval005,cn,vn,vn,null,l.pval005) p5,
137: l.pval005 d5,
138: decode(l.pval006,cn,vn,l.pval006) p6
139: from hr_pump_batch_lines l
140: where l.batch_line_id = p_batch_line_id;
141: --
142: c cr%rowtype;
143: l_validate boolean := false;

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

150: open cr;
151: fetch cr into c;
152: if cr%notfound then
153: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
154: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
155: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
156: hr_utility.set_message_token('VALUE',p_batch_line_id);
157: hr_utility.raise_error;
158: end if;

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

165: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
166: hr_utility.set_message_token('TYPE','BOOLEAN');
167: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
168: hr_utility.set_message_token('VALUE',c.p5);
169: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
170: hr_utility.raise_error;
171: end if;
172: --
173: if c.p6 is null then

Line 205: update hr_pump_batch_lines l set

201: ,P_MULTI_ROW_ACTN => L_MULTI_ROW_ACTN);
202: hr_data_pump.api_trc_off;
203:
204: --
205: update hr_pump_batch_lines l set
206: l.pval001 = decode(c.p1,null,cn,dc(c.p1)),
207: l.pval002 = decode(c.p2,null,cn,dc(c.p2))
208: where l.rowid = c.myrowid;
209: --