DBA Data[Home] [Help]

APPS.HRDPP_CREATE_PRTT_ENRT_RESULT dependencies on HR_PUMP_GET

Line 325: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval058),vn)) p4,

321: l.pval001 p1,
322: decode(l.pval002,cn,dn,d(l.pval002)) p2,
323: decode(l.pval003,cn,dn,d(l.pval003)) p3,
324: decode(l.pval004,cn,vn,vn,vn,
325: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval058),vn)) p4,
326: l.pval004 d4,
327: decode(l.pval005,cn,vn,vn,vn,
328: hr_pump_get.gl(l.pval005,'YES_NO',d(l.pval058),vn)) p5,
329: l.pval005 d5,

Line 328: hr_pump_get.gl(l.pval005,'YES_NO',d(l.pval058),vn)) p5,

324: decode(l.pval004,cn,vn,vn,vn,
325: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval058),vn)) p4,
326: l.pval004 d4,
327: decode(l.pval005,cn,vn,vn,vn,
328: hr_pump_get.gl(l.pval005,'YES_NO',d(l.pval058),vn)) p5,
329: l.pval005 d5,
330: decode(l.pval006,cn,nn,vn,nn,n(l.pval006)) p6,
331: l.pval006 d6,
332: decode(l.pval007,cn,dn,vn,dn,d(l.pval007)) p7,

Line 335: hr_pump_get.gl(l.pval008,'BEN_ENRT_RSLT_MTHD',d(l.pval058),vn)) p8,

331: l.pval006 d6,
332: decode(l.pval007,cn,dn,vn,dn,d(l.pval007)) p7,
333: l.pval007 d7,
334: decode(l.pval008,cn,vn,vn,vn,
335: hr_pump_get.gl(l.pval008,'BEN_ENRT_RSLT_MTHD',d(l.pval058),vn)) p8,
336: l.pval008 d8,
337: decode(l.pval009,cn,vn,vn,vn,
338: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval058),vn)) p9,
339: l.pval009 d9,

Line 338: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval058),vn)) p9,

334: decode(l.pval008,cn,vn,vn,vn,
335: hr_pump_get.gl(l.pval008,'BEN_ENRT_RSLT_MTHD',d(l.pval058),vn)) p8,
336: l.pval008 d8,
337: decode(l.pval009,cn,vn,vn,vn,
338: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval058),vn)) p9,
339: l.pval009 d9,
340: decode(l.pval010,cn,vn,vn,vn,
341: hr_pump_get.gl(l.pval010,'YES_NO',d(l.pval058),vn)) p10,
342: l.pval010 d10,

Line 341: hr_pump_get.gl(l.pval010,'YES_NO',d(l.pval058),vn)) p10,

337: decode(l.pval009,cn,vn,vn,vn,
338: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval058),vn)) p9,
339: l.pval009 d9,
340: decode(l.pval010,cn,vn,vn,vn,
341: hr_pump_get.gl(l.pval010,'YES_NO',d(l.pval058),vn)) p10,
342: l.pval010 d10,
343: decode(l.pval011,cn,vn,vn,vn,
344: hr_pump_get.gl(l.pval011,'BEN_OVRID_RSN',d(l.pval058),vn)) p11,
345: l.pval011 d11,

Line 344: hr_pump_get.gl(l.pval011,'BEN_OVRID_RSN',d(l.pval058),vn)) p11,

340: decode(l.pval010,cn,vn,vn,vn,
341: hr_pump_get.gl(l.pval010,'YES_NO',d(l.pval058),vn)) p10,
342: l.pval010 d10,
343: decode(l.pval011,cn,vn,vn,vn,
344: hr_pump_get.gl(l.pval011,'BEN_OVRID_RSN',d(l.pval058),vn)) p11,
345: l.pval011 d11,
346: decode(l.pval012,cn,dn,vn,dn,d(l.pval012)) p12,
347: l.pval012 d12,
348: decode(l.pval013,cn,dn,vn,dn,d(l.pval013)) p13,

Line 428: hr_pump_get.gl(l.pval053,'BEN_BNFT_TYP',d(l.pval058),vn)) p53,

424: decode(l.pval051,cn,dn,vn,dn,d(l.pval051)) p51,
425: l.pval051 d51,
426: l.pval052 p52,
427: decode(l.pval053,cn,vn,vn,vn,
428: hr_pump_get.gl(l.pval053,'BEN_BNFT_TYP',d(l.pval058),vn)) p53,
429: l.pval053 d53,
430: decode(l.pval054,cn,nn,vn,nn,n(l.pval054)) p54,
431: l.pval054 d54,
432: decode(l.pval055,cn,vn,vn,vn,

Line 433: hr_pump_get.gl(l.pval055,'BEN_PRTT_ENRT_RSLT_STAT',d(l.pval058),vn)) p55,

429: l.pval053 d53,
430: decode(l.pval054,cn,nn,vn,nn,n(l.pval054)) p54,
431: l.pval054 d54,
432: decode(l.pval055,cn,vn,vn,vn,
433: hr_pump_get.gl(l.pval055,'BEN_PRTT_ENRT_RSLT_STAT',d(l.pval058),vn)) p55,
434: l.pval055 d55,
435: decode(l.pval056,cn,vn,vn,vn,
436: hr_pump_get.gl(l.pval056,'BEN_NNMNTRY_UOM',d(l.pval058),vn)) p56,
437: l.pval056 d56,

Line 436: hr_pump_get.gl(l.pval056,'BEN_NNMNTRY_UOM',d(l.pval058),vn)) p56,

432: decode(l.pval055,cn,vn,vn,vn,
433: hr_pump_get.gl(l.pval055,'BEN_PRTT_ENRT_RSLT_STAT',d(l.pval058),vn)) p55,
434: l.pval055 d55,
435: decode(l.pval056,cn,vn,vn,vn,
436: hr_pump_get.gl(l.pval056,'BEN_NNMNTRY_UOM',d(l.pval058),vn)) p56,
437: l.pval056 d56,
438: decode(l.pval057,cn,vn,vn,vn,
439: hr_pump_get.gl(l.pval057,'BEN_COMP_LVL',d(l.pval058),vn)) p57,
440: l.pval057 d57,

Line 439: hr_pump_get.gl(l.pval057,'BEN_COMP_LVL',d(l.pval058),vn)) p57,

435: decode(l.pval056,cn,vn,vn,vn,
436: hr_pump_get.gl(l.pval056,'BEN_NNMNTRY_UOM',d(l.pval058),vn)) p56,
437: l.pval056 d56,
438: decode(l.pval057,cn,vn,vn,vn,
439: hr_pump_get.gl(l.pval057,'BEN_COMP_LVL',d(l.pval058),vn)) p57,
440: l.pval057 d57,
441: decode(l.pval058,cn,dn,d(l.pval058)) p58,
442: decode(l.pval059,cn,vn,vn,null,l.pval059) p59,
443: l.pval059 d59,

Line 517: hr_pump_get.get_oipl_id

513: if c.p60 is null then
514: L_OIPL_ID:=nn;
515: else
516: L_OIPL_ID :=
517: hr_pump_get.get_oipl_id
518: (P_OIPL_USER_KEY => c.p60);
519: end if;
520: --
521: if c.p61 is null then

Line 525: hr_pump_get.get_person_id

521: if c.p61 is null then
522: L_PERSON_ID:=nn;
523: else
524: L_PERSON_ID :=
525: hr_pump_get.get_person_id
526: (P_PERSON_USER_KEY => c.p61);
527: end if;
528: --
529: if c.p62 is null then

Line 533: hr_pump_get.get_assignment_id

529: if c.p62 is null then
530: L_ASSIGNMENT_ID:=nn;
531: else
532: L_ASSIGNMENT_ID :=
533: hr_pump_get.get_assignment_id
534: (P_ASSIGNMENT_USER_KEY => c.p62);
535: end if;
536: --
537: if c.p63 is null or

Line 542: hr_pump_get.get_pgm_id

538: c.p58 is null then
539: L_PGM_ID:=nn;
540: else
541: L_PGM_ID :=
542: hr_pump_get.get_pgm_id
543: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
544: ,P_PROGRAM => c.p63
545: ,P_EFFECTIVE_DATE => c.p58);
546: end if;

Line 553: hr_pump_get.get_pl_id

549: c.p58 is null then
550: L_PL_ID:=nn;
551: else
552: L_PL_ID :=
553: hr_pump_get.get_pl_id
554: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
555: ,P_PLAN => c.p64
556: ,P_EFFECTIVE_DATE => c.p58);
557: end if;

Line 563: hr_pump_get.get_rplcs_sspndd_rslt_id

559: if c.p65 is null then
560: L_RPLCS_SSPNDD_RSLT_ID:=nn;
561: else
562: L_RPLCS_SSPNDD_RSLT_ID :=
563: hr_pump_get.get_rplcs_sspndd_rslt_id
564: (P_RPLCS_SSPNDD_RSLT_USER_KEY => c.p65);
565: end if;
566: --
567: if c.p66 is null then

Line 571: hr_pump_get.get_ptip_id

567: if c.p66 is null then
568: L_PTIP_ID:=nn;
569: else
570: L_PTIP_ID :=
571: hr_pump_get.get_ptip_id
572: (P_PTIP_USER_KEY => c.p66);
573: end if;
574: --
575: if c.p67 is null or

Line 580: hr_pump_get.get_pl_typ_id

576: c.p58 is null then
577: L_PL_TYP_ID:=nn;
578: else
579: L_PL_TYP_ID :=
580: hr_pump_get.get_pl_typ_id
581: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
582: ,P_PLAN_TYPE => c.p67
583: ,P_EFFECTIVE_DATE => c.p58);
584: end if;

Line 591: hr_pump_get.get_ler_id

587: c.p58 is null then
588: L_LER_ID:=nn;
589: else
590: L_LER_ID :=
591: hr_pump_get.get_ler_id
592: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
593: ,P_LIFE_EVENT_REASON => c.p68
594: ,P_EFFECTIVE_DATE => c.p58);
595: end if;

Line 602: hr_pump_get.GET_UOM_CODE

598: c.p58 is null then
599: L_UOM:=vn;
600: else
601: L_UOM :=
602: hr_pump_get.GET_UOM_CODE
603: (P_UOM => c.p69
604: ,P_EFFECTIVE_DATE => c.p58);
605: end if;
606: --

Line 608: hr_pump_get.get_request_id;

604: ,P_EFFECTIVE_DATE => c.p58);
605: end if;
606: --
607: L_REQUEST_ID :=
608: hr_pump_get.get_request_id;
609: --
610: L_PROGRAM_APPLICATION_ID :=
611: hr_pump_get.get_program_application_id;
612: --

Line 611: hr_pump_get.get_program_application_id;

607: L_REQUEST_ID :=
608: hr_pump_get.get_request_id;
609: --
610: L_PROGRAM_APPLICATION_ID :=
611: hr_pump_get.get_program_application_id;
612: --
613: L_PROGRAM_ID :=
614: hr_pump_get.get_program_id;
615: --

Line 614: hr_pump_get.get_program_id;

610: L_PROGRAM_APPLICATION_ID :=
611: hr_pump_get.get_program_application_id;
612: --
613: L_PROGRAM_ID :=
614: hr_pump_get.get_program_id;
615: --
616: if c.p70 is null then
617: L_PER_IN_LER_ID:=nn;
618: else

Line 620: hr_pump_get.get_per_in_ler_id

616: if c.p70 is null then
617: L_PER_IN_LER_ID:=nn;
618: else
619: L_PER_IN_LER_ID :=
620: hr_pump_get.get_per_in_ler_id
621: (P_PER_IN_LER_USER_KEY => c.p70);
622: end if;
623: --
624: hr_data_pump.api_trc_on;