APPS.HRDPP_UPDATE_CBR_QUALD_BNF dependencies on HR_PUMP_GET

Line 241: hr_pump_get.gl(l.pval001,'YES_NO',d(l.pval036),vn)) p1,

237: p_batch_line_id in number) is
238: cursor cr is
239: select l.rowid myrowid,
240: decode(l.pval001,cn,vn,vn,vh,
241: hr_pump_get.gl(l.pval001,'YES_NO',d(l.pval036),vn)) p1,
242: l.pval001 d1,
243: decode(l.pval002,cn,dn,vn,dh,d(l.pval002)) p2,
244: l.pval002 d2,
245: decode(l.pval003,cn,dn,vn,dh,d(l.pval003)) p3,

Line 248: hr_pump_get.gl(l.pval004,'BEN_CBR_INELG_RSN',d(l.pval036),vn)) p4,

244: l.pval002 d2,
245: decode(l.pval003,cn,dn,vn,dh,d(l.pval003)) p3,
246: l.pval003 d3,
247: decode(l.pval004,cn,vn,vn,vh,
248: hr_pump_get.gl(l.pval004,'BEN_CBR_INELG_RSN',d(l.pval036),vn)) p4,
249: l.pval004 d4,
250: decode(l.pval005,cn,vn,vn,vh,l.pval005) p5,
251: l.pval005 d5,
252: decode(l.pval006,cn,vn,vn,vh,l.pval006) p6,

Line 353: hr_pump_get.get_cbr_quald_bnf_id

349: if c.p37 is null then
350: L_CBR_QUALD_BNF_ID:=nn;
351: else
352: L_CBR_QUALD_BNF_ID :=
353: hr_pump_get.get_cbr_quald_bnf_id
354: (P_CBR_QUALD_BNF_USER_KEY => c.p37);
355: end if;
356: --
357: if c.d38=cn then

Line 363: hr_pump_get.get_quald_bnf_person_id

359: elsif c.d38 is null then
360: L_QUALD_BNF_PERSON_ID:=nh;
361: else
362: L_QUALD_BNF_PERSON_ID :=
363: hr_pump_get.get_quald_bnf_person_id
364: (P_QUALD_BNF_PERSON_USER_KEY => c.p38);
365: end if;
366: --
367: if c.d39=cn or

Line 374: hr_pump_get.get_pgm_id

370: elsif c.d39 is null then
371: L_PGM_ID:=nh;
372: else
373: L_PGM_ID :=
374: hr_pump_get.get_pgm_id
375: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
376: ,P_PROGRAM => c.p39
377: ,P_EFFECTIVE_DATE => c.p36);
378: end if;

Line 386: hr_pump_get.get_ptip_id

382: elsif c.d40 is null then
383: L_PTIP_ID:=nh;
384: else
385: L_PTIP_ID :=
386: hr_pump_get.get_ptip_id
387: (P_PTIP_USER_KEY => c.p40);
388: end if;
389: --
390: if c.d41=cn or

Line 397: hr_pump_get.get_pl_typ_id

393: elsif c.d41 is null then
394: L_PL_TYP_ID:=nh;
395: else
396: L_PL_TYP_ID :=
397: hr_pump_get.get_pl_typ_id
398: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
399: ,P_PLAN_TYPE => c.p41
400: ,P_EFFECTIVE_DATE => c.p36);
401: end if;

Line 409: hr_pump_get.get_cvrd_emp_person_id

405: elsif c.d42 is null then
406: L_CVRD_EMP_PERSON_ID:=nh;
407: else
408: L_CVRD_EMP_PERSON_ID :=
409: hr_pump_get.get_cvrd_emp_person_id
410: (P_CVRD_EMP_PERSON_USER_KEY => c.p42);
411: end if;
412: --
413: if c.p37 is null then

Line 417: hr_pump_get.GET_CBR_QUALD_BNF_OVN

413: if c.p37 is null then
414: L_OBJECT_VERSION_NUMBER:=nn;
415: else
416: L_OBJECT_VERSION_NUMBER :=
417: hr_pump_get.GET_CBR_QUALD_BNF_OVN
418: (P_CBR_QUALD_BNF_USER_KEY => c.p37);
419: end if;
420: --
421: hr_data_pump.api_trc_on;