APPS.HRDPP_UPDATE_MX_EMP_ASG_CRITER dependencies on HR_PUMP_GET

Line 347: hr_pump_get.gl(l.pval034,'EMP_CAT',d(l.pval001),l.pval055)) p34,

343: l.pval032 d32,
344: decode(l.pval033,cn,vn,vn,vh,l.pval033) p33,
345: l.pval033 d33,
346: decode(l.pval034,cn,vn,vn,vh,
347: hr_pump_get.gl(l.pval034,'EMP_CAT',d(l.pval001),l.pval055)) p34,
348: l.pval034 d34,
349: decode(l.pval035,cn,vn,vn,vh,l.pval035) p35,
350: l.pval035 d35,
351: decode(l.pval036,cn,vn,vn,vh,

Line 352: hr_pump_get.gl(l.pval036,'MX_STAT_IMSS_LEAVING_REASON',d(l.pval001),l.pval055)) p36,

348: l.pval034 d34,
349: decode(l.pval035,cn,vn,vn,vh,l.pval035) p35,
350: l.pval035 d35,
351: decode(l.pval036,cn,vn,vn,vh,
352: hr_pump_get.gl(l.pval036,'MX_STAT_IMSS_LEAVING_REASON',d(l.pval001),l.pval055)) p36,
353: l.pval036 d36,
354: decode(l.pval037,cn,nn,n(l.pval037)) p37,
355: decode(l.pval038,cn,nn,n(l.pval038)) p38,
356: l.pval039 p39,

Line 451: hr_pump_get.get_assignment_id

447: if c.p49 is null then
448: L_ASSIGNMENT_ID:=nn;
449: else
450: L_ASSIGNMENT_ID :=
451: hr_pump_get.get_assignment_id
452: (P_ASSIGNMENT_USER_KEY => c.p49);
453: end if;
454: --
455: if c.d50=cn or

Line 462: hr_pump_get.get_grade_id

458: elsif c.d50 is null then
459: L_GRADE_ID:=nh;
460: else
461: L_GRADE_ID :=
462: hr_pump_get.get_grade_id
463: (P_GRADE_NAME => c.p50
464: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
465: ,P_EFFECTIVE_DATE => c.p1);
466: end if;

Line 475: hr_pump_get.get_position_id

471: elsif c.d51 is null then
472: L_POSITION_ID:=nh;
473: else
474: L_POSITION_ID :=
475: hr_pump_get.get_position_id
476: (P_POSITION_NAME => c.p51
477: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
478: ,P_EFFECTIVE_DATE => c.p1);
479: end if;

Line 488: hr_pump_get.get_job_id

484: elsif c.d52 is null then
485: L_JOB_ID:=nh;
486: else
487: L_JOB_ID :=
488: hr_pump_get.get_job_id
489: (P_JOB_NAME => c.p52
490: ,P_EFFECTIVE_DATE => c.p1
491: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
492: end if;

Line 501: hr_pump_get.get_payroll_id

497: elsif c.d53 is null then
498: L_PAYROLL_ID:=nh;
499: else
500: L_PAYROLL_ID :=
501: hr_pump_get.get_payroll_id
502: (P_PAYROLL_NAME => c.p53
503: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
504: ,P_EFFECTIVE_DATE => c.p1);
505: end if;

Line 515: hr_pump_get.get_location_id

511: c.d55 is null then
512: L_LOCATION_ID:=nh;
513: else
514: L_LOCATION_ID :=
515: hr_pump_get.get_location_id
516: (P_LOCATION_CODE => c.p54
517: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
518: ,P_LANGUAGE_CODE => c.p55);
519: end if;

Line 530: hr_pump_get.get_organization_id

526: c.d55 is null then
527: L_ORGANIZATION_ID:=nh;
528: else
529: L_ORGANIZATION_ID :=
530: hr_pump_get.get_organization_id
531: (P_ORGANIZATION_NAME => c.p56
532: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
533: ,P_EFFECTIVE_DATE => c.p1
534: ,P_LANGUAGE_CODE => c.p55);

Line 543: hr_pump_get.get_pay_basis_id

539: elsif c.d57 is null then
540: L_PAY_BASIS_ID:=nh;
541: else
542: L_PAY_BASIS_ID :=
543: hr_pump_get.get_pay_basis_id
544: (P_PAY_BASIS_NAME => c.p57
545: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
546: end if;
547: --

Line 554: hr_pump_get.get_contract_id

550: elsif c.d58 is null then
551: L_CONTRACT_ID:=nh;
552: else
553: L_CONTRACT_ID :=
554: hr_pump_get.get_contract_id
555: (P_CONTRACT_USER_KEY => c.p58);
556: end if;
557: --
558: if c.d59=cn or

Line 566: hr_pump_get.get_establishment_id

562: c.d60 is null then
563: L_ESTABLISHMENT_ID:=nh;
564: else
565: L_ESTABLISHMENT_ID :=
566: hr_pump_get.get_establishment_id
567: (P_ESTABLISHMENT_NAME => c.p59
568: ,P_LOCATION => c.p60);
569: end if;
570: --

Line 589: hr_pump_get.GET_GRADE_LADDER_PGM_ID

585: elsif c.d62 is null then
586: L_GRADE_LADDER_PGM_ID:=nh;
587: else
588: L_GRADE_LADDER_PGM_ID :=
589: hr_pump_get.GET_GRADE_LADDER_PGM_ID
590: (P_GRADE_LADDER_NAME => c.p62
591: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
592: ,P_EFFECTIVE_DATE => c.p1);
593: end if;

Line 601: hr_pump_get.GET_SUPERVISOR_ASSIGNMENT_ID

597: elsif c.d63 is null then
598: L_SUPERVISOR_ASSIGNMENT_ID:=nh;
599: else
600: L_SUPERVISOR_ASSIGNMENT_ID :=
601: hr_pump_get.GET_SUPERVISOR_ASSIGNMENT_ID
602: (P_SVR_ASSIGNMENT_USER_KEY => c.p63);
603: end if;
604: --
605: if c.p49 is null or

Line 610: hr_pump_get.GET_ASG_OVN

606: c.p1 is null then
607: L_OBJECT_VERSION_NUMBER:=nn;
608: else
609: L_OBJECT_VERSION_NUMBER :=
610: hr_pump_get.GET_ASG_OVN
611: (P_ASSIGNMENT_USER_KEY => c.p49
612: ,P_EFFECTIVE_DATE => c.p1);
613: end if;
614: --

Line 620: hr_pump_get.get_soft_coding_keyflex_id

616: c.p1 is null then
617: L_SOFT_CODING_KEYFLEX_ID:=nn;
618: else
619: L_SOFT_CODING_KEYFLEX_ID :=
620: hr_pump_get.get_soft_coding_keyflex_id
621: (P_CON_SEG_USER_NAME => c.p64
622: ,P_EFFECTIVE_DATE => c.p1);
623: end if;
624: --