APPS.HRDPP_UPDATE_CBR_PER_IN_LER dependencies on HR_PUMP_GET

Line 229: hr_pump_get.gl(l.pval001,'YES_NO',d(l.pval035),vn)) p1,

225: p_batch_line_id in number) is
226: cursor cr is
227: select l.rowid myrowid,
228: decode(l.pval001,cn,vn,vn,vh,
229: hr_pump_get.gl(l.pval001,'YES_NO',d(l.pval035),vn)) p1,
230: l.pval001 d1,
231: decode(l.pval002,cn,nn,vn,nh,n(l.pval002)) p2,
232: l.pval002 d2,
233: decode(l.pval003,cn,dn,vn,dh,d(l.pval003)) p3,

Line 329: hr_pump_get.get_cbr_per_in_ler_id

325: if c.p36 is null then
326: L_CBR_PER_IN_LER_ID:=nn;
327: else
328: L_CBR_PER_IN_LER_ID :=
329: hr_pump_get.get_cbr_per_in_ler_id
330: (P_CBR_PER_IN_LER_USER_KEY => c.p36);
331: end if;
332: --
333: if c.d37=cn then

Line 339: hr_pump_get.get_per_in_ler_id

335: elsif c.d37 is null then
336: L_PER_IN_LER_ID:=nh;
337: else
338: L_PER_IN_LER_ID :=
339: hr_pump_get.get_per_in_ler_id
340: (P_PER_IN_LER_USER_KEY => c.p37);
341: end if;
342: --
343: if c.d38=cn then

Line 349: hr_pump_get.get_cbr_quald_bnf_id

345: elsif c.d38 is null then
346: L_CBR_QUALD_BNF_ID:=nh;
347: else
348: L_CBR_QUALD_BNF_ID :=
349: hr_pump_get.get_cbr_quald_bnf_id
350: (P_CBR_QUALD_BNF_USER_KEY => c.p38);
351: end if;
352: --
353: if c.p36 is null then

Line 357: hr_pump_get.GET_CBR_PER_IN_LER_OVN

353: if c.p36 is null then
354: L_OBJECT_VERSION_NUMBER:=nn;
355: else
356: L_OBJECT_VERSION_NUMBER :=
357: hr_pump_get.GET_CBR_PER_IN_LER_OVN
358: (P_CBR_PER_IN_LER_USER_KEY => c.p36);
359: end if;
360: --
361: hr_data_pump.api_trc_on;