DBA Data[Home] [Help]

APPS.HRDPP_UPDATE_EMP_ASG_CRITERIA dependencies on HR_PUMP_GET

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

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

Line 444: hr_pump_get.get_assignment_id

440: if c.p49 is null then
441: L_ASSIGNMENT_ID:=nn;
442: else
443: L_ASSIGNMENT_ID :=
444: hr_pump_get.get_assignment_id
445: (P_ASSIGNMENT_USER_KEY => c.p49);
446: end if;
447: --
448: if c.d50=cn or

Line 455: hr_pump_get.get_grade_id

451: elsif c.d50 is null then
452: L_GRADE_ID:=nh;
453: else
454: L_GRADE_ID :=
455: hr_pump_get.get_grade_id
456: (P_GRADE_NAME => c.p50
457: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
458: ,P_EFFECTIVE_DATE => c.p1);
459: end if;

Line 468: hr_pump_get.get_position_id

464: elsif c.d51 is null then
465: L_POSITION_ID:=nh;
466: else
467: L_POSITION_ID :=
468: hr_pump_get.get_position_id
469: (P_POSITION_NAME => c.p51
470: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
471: ,P_EFFECTIVE_DATE => c.p1);
472: end if;

Line 481: hr_pump_get.get_job_id

477: elsif c.d52 is null then
478: L_JOB_ID:=nh;
479: else
480: L_JOB_ID :=
481: hr_pump_get.get_job_id
482: (P_JOB_NAME => c.p52
483: ,P_EFFECTIVE_DATE => c.p1
484: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
485: end if;

Line 494: hr_pump_get.get_payroll_id

490: elsif c.d53 is null then
491: L_PAYROLL_ID:=nh;
492: else
493: L_PAYROLL_ID :=
494: hr_pump_get.get_payroll_id
495: (P_PAYROLL_NAME => c.p53
496: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
497: ,P_EFFECTIVE_DATE => c.p1);
498: end if;

Line 508: hr_pump_get.get_location_id

504: c.d55 is null then
505: L_LOCATION_ID:=nh;
506: else
507: L_LOCATION_ID :=
508: hr_pump_get.get_location_id
509: (P_LOCATION_CODE => c.p54
510: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
511: ,P_LANGUAGE_CODE => c.p55);
512: end if;

Line 523: hr_pump_get.get_organization_id

519: c.d55 is null then
520: L_ORGANIZATION_ID:=nh;
521: else
522: L_ORGANIZATION_ID :=
523: hr_pump_get.get_organization_id
524: (P_ORGANIZATION_NAME => c.p56
525: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
526: ,P_EFFECTIVE_DATE => c.p1
527: ,P_LANGUAGE_CODE => c.p55);

Line 536: hr_pump_get.get_pay_basis_id

532: elsif c.d57 is null then
533: L_PAY_BASIS_ID:=nh;
534: else
535: L_PAY_BASIS_ID :=
536: hr_pump_get.get_pay_basis_id
537: (P_PAY_BASIS_NAME => c.p57
538: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
539: end if;
540: --

Line 547: hr_pump_get.get_contract_id

543: elsif c.d58 is null then
544: L_CONTRACT_ID:=nh;
545: else
546: L_CONTRACT_ID :=
547: hr_pump_get.get_contract_id
548: (P_CONTRACT_USER_KEY => c.p58);
549: end if;
550: --
551: if c.d59=cn or

Line 559: hr_pump_get.get_establishment_id

555: c.d60 is null then
556: L_ESTABLISHMENT_ID:=nh;
557: else
558: L_ESTABLISHMENT_ID :=
559: hr_pump_get.get_establishment_id
560: (P_ESTABLISHMENT_NAME => c.p59
561: ,P_LOCATION => c.p60);
562: end if;
563: --

Line 571: hr_pump_get.GET_GRADE_LADDER_PGM_ID

567: elsif c.d61 is null then
568: L_GRADE_LADDER_PGM_ID:=nh;
569: else
570: L_GRADE_LADDER_PGM_ID :=
571: hr_pump_get.GET_GRADE_LADDER_PGM_ID
572: (P_GRADE_LADDER_NAME => c.p61
573: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
574: ,P_EFFECTIVE_DATE => c.p1);
575: end if;

Line 583: hr_pump_get.GET_SUPERVISOR_ASSIGNMENT_ID

579: elsif c.d62 is null then
580: L_SUPERVISOR_ASSIGNMENT_ID:=nh;
581: else
582: L_SUPERVISOR_ASSIGNMENT_ID :=
583: hr_pump_get.GET_SUPERVISOR_ASSIGNMENT_ID
584: (P_SVR_ASSIGNMENT_USER_KEY => c.p62);
585: end if;
586: --
587: if c.p49 is null or

Line 592: hr_pump_get.GET_ASG_OVN

588: c.p1 is null then
589: L_OBJECT_VERSION_NUMBER:=nn;
590: else
591: L_OBJECT_VERSION_NUMBER :=
592: hr_pump_get.GET_ASG_OVN
593: (P_ASSIGNMENT_USER_KEY => c.p49
594: ,P_EFFECTIVE_DATE => c.p1);
595: end if;
596: --

Line 602: hr_pump_get.get_soft_coding_keyflex_id

598: c.p1 is null then
599: L_SOFT_CODING_KEYFLEX_ID:=nn;
600: else
601: L_SOFT_CODING_KEYFLEX_ID :=
602: hr_pump_get.get_soft_coding_keyflex_id
603: (P_CON_SEG_USER_NAME => c.p63
604: ,P_EFFECTIVE_DATE => c.p1);
605: end if;
606: --