DBA Data[Home] [Help]

APPS.HRDPP_CREATE_PLAN_BENEFICIARY dependencies on HR_PUMP_GET

Line 268: hr_pump_get.gl(l.pval004,'BEN_PRMRY_CNTNGNT',d(l.pval043),l.pval048)) p4,

264: l.pval001 p1,
265: decode(l.pval002,cn,dn,d(l.pval002)) p2,
266: decode(l.pval003,cn,dn,d(l.pval003)) p3,
267: decode(l.pval004,cn,vn,vn,vn,
268: hr_pump_get.gl(l.pval004,'BEN_PRMRY_CNTNGNT',d(l.pval043),l.pval048)) p4,
269: l.pval004 d4,
270: decode(l.pval005,cn,nn,vn,nn,n(l.pval005)) p5,
271: l.pval005 d5,
272: decode(l.pval006,cn,nn,vn,nn,n(l.pval006)) p6,

Line 408: hr_pump_get.get_prtt_enrt_rslt_id

404: if c.p45 is null then
405: L_PRTT_ENRT_RSLT_ID:=nn;
406: else
407: L_PRTT_ENRT_RSLT_ID :=
408: hr_pump_get.get_prtt_enrt_rslt_id
409: (P_PRTT_ENRT_RSLT_USER_KEY => c.p45);
410: end if;
411: --
412: if c.p46 is null then

Line 416: hr_pump_get.get_bnf_person_id

412: if c.p46 is null then
413: L_BNF_PERSON_ID:=nn;
414: else
415: L_BNF_PERSON_ID :=
416: hr_pump_get.get_bnf_person_id
417: (P_BNF_PERSON_USER_KEY => c.p46);
418: end if;
419: --
420: if c.p47 is null or

Line 426: hr_pump_get.get_organization_id

422: c.p48 is null then
423: L_ORGANIZATION_ID:=nn;
424: else
425: L_ORGANIZATION_ID :=
426: hr_pump_get.get_organization_id
427: (P_ORGANIZATION_NAME => c.p47
428: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
429: ,P_EFFECTIVE_DATE => c.p43
430: ,P_LANGUAGE_CODE => c.p48);

Line 437: hr_pump_get.get_ttee_person_id

433: if c.p49 is null then
434: L_TTEE_PERSON_ID:=nn;
435: else
436: L_TTEE_PERSON_ID :=
437: hr_pump_get.get_ttee_person_id
438: (P_TTEE_PERSON_USER_KEY => c.p49);
439: end if;
440: --
441: if c.p50 is null or

Line 446: hr_pump_get.GET_AMT_DSGD_UOM_CODE

442: c.p43 is null then
443: L_AMT_DSGD_UOM:=vn;
444: else
445: L_AMT_DSGD_UOM :=
446: hr_pump_get.GET_AMT_DSGD_UOM_CODE
447: (P_AMT_DSGD_UOM => c.p50
448: ,P_EFFECTIVE_DATE => c.p43);
449: end if;
450: --

Line 452: hr_pump_get.get_request_id;

448: ,P_EFFECTIVE_DATE => c.p43);
449: end if;
450: --
451: L_REQUEST_ID :=
452: hr_pump_get.get_request_id;
453: --
454: L_PROGRAM_APPLICATION_ID :=
455: hr_pump_get.get_program_application_id;
456: --

Line 455: hr_pump_get.get_program_application_id;

451: L_REQUEST_ID :=
452: hr_pump_get.get_request_id;
453: --
454: L_PROGRAM_APPLICATION_ID :=
455: hr_pump_get.get_program_application_id;
456: --
457: L_PROGRAM_ID :=
458: hr_pump_get.get_program_id;
459: --

Line 458: hr_pump_get.get_program_id;

454: L_PROGRAM_APPLICATION_ID :=
455: hr_pump_get.get_program_application_id;
456: --
457: L_PROGRAM_ID :=
458: hr_pump_get.get_program_id;
459: --
460: if c.p51 is null then
461: L_PER_IN_LER_ID:=nn;
462: else

Line 464: hr_pump_get.get_per_in_ler_id

460: if c.p51 is null then
461: L_PER_IN_LER_ID:=nn;
462: else
463: L_PER_IN_LER_ID :=
464: hr_pump_get.get_per_in_ler_id
465: (P_PER_IN_LER_USER_KEY => c.p51);
466: end if;
467: --
468: hr_data_pump.api_trc_on;