APPS.HRDPP_UPDATE_PERSON_LIFE_EVENT dependencies on HR_PUMP_GET

Line 269: hr_pump_get.gl(l.pval001,'BEN_PER_IN_LER_STAT',d(l.pval043),vn)) p1,

265: p_batch_line_id in number) is
266: cursor cr is
267: select l.rowid myrowid,
268: decode(l.pval001,cn,vn,vn,vh,
269: hr_pump_get.gl(l.pval001,'BEN_PER_IN_LER_STAT',d(l.pval043),vn)) p1,
270: l.pval001 d1,
271: decode(l.pval002,cn,vn,vn,vh,
272: hr_pump_get.gl(l.pval002,'BEN_PER_IN_LER_STAT',d(l.pval043),vn)) p2,
273: l.pval002 d2,

Line 272: hr_pump_get.gl(l.pval002,'BEN_PER_IN_LER_STAT',d(l.pval043),vn)) p2,

268: decode(l.pval001,cn,vn,vn,vh,
269: hr_pump_get.gl(l.pval001,'BEN_PER_IN_LER_STAT',d(l.pval043),vn)) p1,
270: l.pval001 d1,
271: decode(l.pval002,cn,vn,vn,vh,
272: hr_pump_get.gl(l.pval002,'BEN_PER_IN_LER_STAT',d(l.pval043),vn)) p2,
273: l.pval002 d2,
274: decode(l.pval003,cn,dn,vn,dh,d(l.pval003)) p3,
275: l.pval003 d3,
276: decode(l.pval004,cn,dn,d(l.pval004)) p4,

Line 407: hr_pump_get.get_per_in_ler_id

403: if c.p44 is null then
404: L_PER_IN_LER_ID:=nn;
405: else
406: L_PER_IN_LER_ID :=
407: hr_pump_get.get_per_in_ler_id
408: (P_PER_IN_LER_USER_KEY => c.p44);
409: end if;
410: --
411: if c.d45=cn then

Line 417: hr_pump_get.get_trgr_table_pk_id

413: elsif c.d45 is null then
414: L_TRGR_TABLE_PK_ID:=nh;
415: else
416: L_TRGR_TABLE_PK_ID :=
417: hr_pump_get.get_trgr_table_pk_id
418: (P_TRGR_TABLE_PK_USER_KEY => c.p45);
419: end if;
420: --
421: if c.d46=cn then

Line 427: hr_pump_get.get_ptnl_ler_for_per_id

423: elsif c.d46 is null then
424: L_PTNL_LER_FOR_PER_ID:=nh;
425: else
426: L_PTNL_LER_FOR_PER_ID :=
427: hr_pump_get.get_ptnl_ler_for_per_id
428: (P_PTNL_LER_FOR_PER_USER_KEY => c.p46);
429: end if;
430: --
431: if c.d47=cn then

Line 437: hr_pump_get.get_bckt_per_in_ler_id

433: elsif c.d47 is null then
434: L_BCKT_PER_IN_LER_ID:=nh;
435: else
436: L_BCKT_PER_IN_LER_ID :=
437: hr_pump_get.get_bckt_per_in_ler_id
438: (P_BCKT_PER_IN_LER_USER_KEY => c.p47);
439: end if;
440: --
441: if c.d48=cn or

Line 448: hr_pump_get.get_ler_id

444: elsif c.d48 is null then
445: L_LER_ID:=nh;
446: else
447: L_LER_ID :=
448: hr_pump_get.get_ler_id
449: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
450: ,P_LIFE_EVENT_REASON => c.p48
451: ,P_EFFECTIVE_DATE => c.p43);
452: end if;

Line 460: hr_pump_get.get_person_id

456: elsif c.d49 is null then
457: L_PERSON_ID:=nh;
458: else
459: L_PERSON_ID :=
460: hr_pump_get.get_person_id
461: (P_PERSON_USER_KEY => c.p49);
462: end if;
463: --
464: if c.d50=cn then

Line 470: hr_pump_get.get_assignment_id

466: elsif c.d50 is null then
467: L_ASSIGNMENT_ID:=nh;
468: else
469: L_ASSIGNMENT_ID :=
470: hr_pump_get.get_assignment_id
471: (P_ASSIGNMENT_USER_KEY => c.p50);
472: end if;
473: --
474: if c.d51=cn then

Line 480: hr_pump_get.get_ws_mgr_id

476: elsif c.d51 is null then
477: L_WS_MGR_ID:=nh;
478: else
479: L_WS_MGR_ID :=
480: hr_pump_get.get_ws_mgr_id
481: (P_WS_MGR_USER_KEY => c.p51);
482: end if;
483: --
484: if c.d52=cn then

Line 490: hr_pump_get.get_group_pl_id

486: elsif c.d52 is null then
487: L_GROUP_PL_ID:=nh;
488: else
489: L_GROUP_PL_ID :=
490: hr_pump_get.get_group_pl_id
491: (P_GROUP_PL_USER_KEY => c.p52);
492: end if;
493: --
494: if c.d53=cn then

Line 500: hr_pump_get.get_mgr_ovrid_person_id

496: elsif c.d53 is null then
497: L_MGR_OVRID_PERSON_ID:=nh;
498: else
499: L_MGR_OVRID_PERSON_ID :=
500: hr_pump_get.get_mgr_ovrid_person_id
501: (P_MGR_OVRID_PERSON_USER_KEY => c.p53);
502: end if;
503: --
504: L_REQUEST_ID :=

Line 505: hr_pump_get.get_request_id;

501: (P_MGR_OVRID_PERSON_USER_KEY => c.p53);
502: end if;
503: --
504: L_REQUEST_ID :=
505: hr_pump_get.get_request_id;
506: --
507: L_PROGRAM_APPLICATION_ID :=
508: hr_pump_get.get_program_application_id;
509: --

Line 508: hr_pump_get.get_program_application_id;

504: L_REQUEST_ID :=
505: hr_pump_get.get_request_id;
506: --
507: L_PROGRAM_APPLICATION_ID :=
508: hr_pump_get.get_program_application_id;
509: --
510: L_PROGRAM_ID :=
511: hr_pump_get.get_program_id;
512: --

Line 511: hr_pump_get.get_program_id;

507: L_PROGRAM_APPLICATION_ID :=
508: hr_pump_get.get_program_application_id;
509: --
510: L_PROGRAM_ID :=
511: hr_pump_get.get_program_id;
512: --
513: if c.p44 is null then
514: L_OBJECT_VERSION_NUMBER:=nn;
515: else

Line 517: hr_pump_get.GET_PER_IN_LER_OVN

513: if c.p44 is null then
514: L_OBJECT_VERSION_NUMBER:=nn;
515: else
516: L_OBJECT_VERSION_NUMBER :=
517: hr_pump_get.GET_PER_IN_LER_OVN
518: (P_PER_IN_LER_USER_KEY => c.p44);
519: end if;
520: --
521: hr_data_pump.api_trc_on;