DBA Data[Home] [Help]

APPS.HRDPP_UPDATE_QUALIFICATION_TYP dependencies on HR_PUMP_GET

Line 438: hr_pump_get.gl(l.pval060,'PER_QUAL_FWK_CREDIT_TYPE',d(l.pval001),l.pval002)) p60,

434: l.pval058 d58,
435: decode(l.pval059,cn,vn,vn,vh,l.pval059) p59,
436: l.pval059 d59,
437: decode(l.pval060,cn,vn,vn,vh,
438: hr_pump_get.gl(l.pval060,'PER_QUAL_FWK_CREDIT_TYPE',d(l.pval001),l.pval002)) p60,
439: l.pval060 d60,
440: decode(l.pval061,cn,nn,vn,nh,n(l.pval061)) p61,
441: l.pval061 d61,
442: decode(l.pval062,cn,vn,vn,vh,

Line 443: hr_pump_get.gl(l.pval062,'PER_QUAL_FWK_LEVEL_TYPE',d(l.pval001),l.pval002)) p62,

439: l.pval060 d60,
440: decode(l.pval061,cn,nn,vn,nh,n(l.pval061)) p61,
441: l.pval061 d61,
442: decode(l.pval062,cn,vn,vn,vh,
443: hr_pump_get.gl(l.pval062,'PER_QUAL_FWK_LEVEL_TYPE',d(l.pval001),l.pval002)) p62,
444: l.pval062 d62,
445: decode(l.pval063,cn,nn,vn,nh,
446: hr_pump_get.gl(l.pval063,'PER_QUAL_FWK_LEVEL_NUMBER',d(l.pval001),l.pval002)) p63,
447: l.pval063 d63,

Line 446: hr_pump_get.gl(l.pval063,'PER_QUAL_FWK_LEVEL_NUMBER',d(l.pval001),l.pval002)) p63,

442: decode(l.pval062,cn,vn,vn,vh,
443: hr_pump_get.gl(l.pval062,'PER_QUAL_FWK_LEVEL_TYPE',d(l.pval001),l.pval002)) p62,
444: l.pval062 d62,
445: decode(l.pval063,cn,nn,vn,nh,
446: hr_pump_get.gl(l.pval063,'PER_QUAL_FWK_LEVEL_NUMBER',d(l.pval001),l.pval002)) p63,
447: l.pval063 d63,
448: decode(l.pval064,cn,vn,vn,vh,
449: hr_pump_get.gl(l.pval064,'PER_QUAL_FWK_FIELD',d(l.pval001),l.pval002)) p64,
450: l.pval064 d64,

Line 449: hr_pump_get.gl(l.pval064,'PER_QUAL_FWK_FIELD',d(l.pval001),l.pval002)) p64,

445: decode(l.pval063,cn,nn,vn,nh,
446: hr_pump_get.gl(l.pval063,'PER_QUAL_FWK_LEVEL_NUMBER',d(l.pval001),l.pval002)) p63,
447: l.pval063 d63,
448: decode(l.pval064,cn,vn,vn,vh,
449: hr_pump_get.gl(l.pval064,'PER_QUAL_FWK_FIELD',d(l.pval001),l.pval002)) p64,
450: l.pval064 d64,
451: decode(l.pval065,cn,vn,vn,vh,
452: hr_pump_get.gl(l.pval065,'PER_QUAL_FWK_SUB_FIELD',d(l.pval001),l.pval002)) p65,
453: l.pval065 d65,

Line 452: hr_pump_get.gl(l.pval065,'PER_QUAL_FWK_SUB_FIELD',d(l.pval001),l.pval002)) p65,

448: decode(l.pval064,cn,vn,vn,vh,
449: hr_pump_get.gl(l.pval064,'PER_QUAL_FWK_FIELD',d(l.pval001),l.pval002)) p64,
450: l.pval064 d64,
451: decode(l.pval065,cn,vn,vn,vh,
452: hr_pump_get.gl(l.pval065,'PER_QUAL_FWK_SUB_FIELD',d(l.pval001),l.pval002)) p65,
453: l.pval065 d65,
454: decode(l.pval066,cn,vn,vn,vh,
455: hr_pump_get.gl(l.pval066,'PER_QUAL_FWK_PROVIDER',d(l.pval001),l.pval002)) p66,
456: l.pval066 d66,

Line 455: hr_pump_get.gl(l.pval066,'PER_QUAL_FWK_PROVIDER',d(l.pval001),l.pval002)) p66,

451: decode(l.pval065,cn,vn,vn,vh,
452: hr_pump_get.gl(l.pval065,'PER_QUAL_FWK_SUB_FIELD',d(l.pval001),l.pval002)) p65,
453: l.pval065 d65,
454: decode(l.pval066,cn,vn,vn,vh,
455: hr_pump_get.gl(l.pval066,'PER_QUAL_FWK_PROVIDER',d(l.pval001),l.pval002)) p66,
456: l.pval066 d66,
457: decode(l.pval067,cn,vn,vn,vh,
458: hr_pump_get.gl(l.pval067,'PER_QUAL_FWK_QA_ORG',d(l.pval001),l.pval002)) p67,
459: l.pval067 d67,

Line 458: hr_pump_get.gl(l.pval067,'PER_QUAL_FWK_QA_ORG',d(l.pval001),l.pval002)) p67,

454: decode(l.pval066,cn,vn,vn,vh,
455: hr_pump_get.gl(l.pval066,'PER_QUAL_FWK_PROVIDER',d(l.pval001),l.pval002)) p66,
456: l.pval066 d66,
457: decode(l.pval067,cn,vn,vn,vh,
458: hr_pump_get.gl(l.pval067,'PER_QUAL_FWK_QA_ORG',d(l.pval001),l.pval002)) p67,
459: l.pval067 d67,
460: decode(l.pval068,cn,vn,l.pval068) p68
461: from hr_pump_batch_lines l
462: where l.batch_line_id = p_batch_line_id;

Line 482: hr_pump_get.get_qualification_type_id

478: hr_utility.raise_error;
479: end if;
480: --
481: L_QUALIFICATION_TYPE_ID :=
482: hr_pump_get.get_qualification_type_id
483: (P_DATA_PUMP_ALWAYS_CALL => null
484: ,P_QUALIFICATION_TYPE_NAME => c.p68);
485: --
486: L_OBJECT_VERSION_NUMBER :=

Line 487: hr_pump_get.GET_EQT_OVN

483: (P_DATA_PUMP_ALWAYS_CALL => null
484: ,P_QUALIFICATION_TYPE_NAME => c.p68);
485: --
486: L_OBJECT_VERSION_NUMBER :=
487: hr_pump_get.GET_EQT_OVN
488: (P_DATA_PUMP_ALWAYS_CALL => null
489: ,P_QUALIFICATION_TYPE_NAME => c.p68);
490: --
491: hr_data_pump.api_trc_on;