DBA Data[Home] [Help]

APPS.HRDPP_UPDATE_AU_EMP_ASG dependencies on HR_PUMP_GET

Line 384: hr_pump_get.gl(l.pval004,'EMP_ASSIGN_REASON',d(l.pval001),vn)) p4,

380: decode(l.pval002,cn,vn,l.pval002) p2,
381: decode(l.pval003,cn,vn,vn,vh,l.pval003) p3,
382: l.pval003 d3,
383: decode(l.pval004,cn,vn,vn,vh,
384: hr_pump_get.gl(l.pval004,'EMP_ASSIGN_REASON',d(l.pval001),vn)) p4,
385: l.pval004 d4,
386: decode(l.pval005,cn,vn,vn,null,l.pval005) p5,
387: l.pval005 d5,
388: decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,

Line 391: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),vn)) p7,

387: l.pval005 d5,
388: decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,
389: l.pval006 d6,
390: decode(l.pval007,cn,vn,vn,vh,
391: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),vn)) p7,
392: l.pval007 d7,
393: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
394: l.pval008 d8,
395: decode(l.pval009,cn,vn,vn,vh,

Line 396: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),vn)) p9,

392: l.pval007 d7,
393: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
394: l.pval008 d8,
395: decode(l.pval009,cn,vn,vn,vh,
396: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),vn)) p9,
397: l.pval009 d9,
398: decode(l.pval010,cn,nn,vn,nh,n(l.pval010)) p10,
399: l.pval010 d10,
400: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,

Line 403: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),vn)) p12,

399: l.pval010 d10,
400: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,
401: l.pval011 d11,
402: decode(l.pval012,cn,vn,vn,vh,
403: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),vn)) p12,
404: l.pval012 d12,
405: decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
406: l.pval013 d13,
407: decode(l.pval014,cn,vn,vn,vh,

Line 408: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),vn)) p14,

404: l.pval012 d12,
405: decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
406: l.pval013 d13,
407: decode(l.pval014,cn,vn,vn,vh,
408: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),vn)) p14,
409: l.pval014 d14,
410: decode(l.pval015,cn,nn,vn,nh,n(l.pval015)) p15,
411: l.pval015 d15,
412: decode(l.pval016,cn,vn,vn,vh,

Line 413: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),vn)) p16,

409: l.pval014 d14,
410: decode(l.pval015,cn,nn,vn,nh,n(l.pval015)) p15,
411: l.pval015 d15,
412: decode(l.pval016,cn,vn,vn,vh,
413: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),vn)) p16,
414: l.pval016 d16,
415: decode(l.pval017,cn,vn,vn,vh,
416: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),vn)) p17,
417: l.pval017 d17,

Line 416: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),vn)) p17,

412: decode(l.pval016,cn,vn,vn,vh,
413: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),vn)) p16,
414: l.pval016 d16,
415: decode(l.pval017,cn,vn,vn,vh,
416: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),vn)) p17,
417: l.pval017 d17,
418: decode(l.pval018,cn,vn,vn,vh,l.pval018) p18,
419: l.pval018 d18,
420: decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,

Line 423: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),vn)) p20,

419: l.pval018 d18,
420: decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,
421: l.pval019 d19,
422: decode(l.pval020,cn,vn,vn,vh,
423: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),vn)) p20,
424: l.pval020 d20,
425: decode(l.pval021,cn,vn,vn,'N',
426: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),vn)) p21,
427: l.pval021 d21,

Line 426: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),vn)) p21,

422: decode(l.pval020,cn,vn,vn,vh,
423: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),vn)) p20,
424: l.pval020 d20,
425: decode(l.pval021,cn,vn,vn,'N',
426: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),vn)) p21,
427: l.pval021 d21,
428: decode(l.pval022,cn,vn,vn,vh,
429: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),vn)) p22,
430: l.pval022 d22,

Line 429: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),vn)) p22,

425: decode(l.pval021,cn,vn,vn,'N',
426: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),vn)) p21,
427: l.pval021 d21,
428: decode(l.pval022,cn,vn,vn,vh,
429: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),vn)) p22,
430: l.pval022 d22,
431: decode(l.pval023,cn,vn,vn,vh,l.pval023) p23,
432: l.pval023 d23,
433: decode(l.pval024,cn,vn,vn,vh,l.pval024) p24,

Line 602: hr_pump_get.get_assignment_id

598: if c.p88 is null then
599: L_ASSIGNMENT_ID:=nn;
600: else
601: L_ASSIGNMENT_ID :=
602: hr_pump_get.get_assignment_id
603: (P_ASSIGNMENT_USER_KEY => c.p88);
604: end if;
605: --
606: if c.p88 is null or

Line 611: hr_pump_get.GET_ASG_OVN

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

Line 622: hr_pump_get.get_supervisor_id

618: elsif c.d89 is null then
619: L_SUPERVISOR_ID:=nh;
620: else
621: L_SUPERVISOR_ID :=
622: hr_pump_get.get_supervisor_id
623: (P_SUPERVISOR_USER_KEY => c.p89);
624: end if;
625: --
626: if c.d90=cn then

Line 632: hr_pump_get.get_default_code_comb_id

628: elsif c.d90 is null then
629: L_DEFAULT_CODE_COMB_ID:=nh;
630: else
631: L_DEFAULT_CODE_COMB_ID :=
632: hr_pump_get.get_default_code_comb_id
633: (P_DEFAULT_CODE_COMB_USER_KEY => c.p90);
634: end if;
635: --
636: if c.d91=cn then

Line 642: hr_pump_get.get_set_of_books_id

638: elsif c.d91 is null then
639: L_SET_OF_BOOKS_ID:=nh;
640: else
641: L_SET_OF_BOOKS_ID :=
642: hr_pump_get.get_set_of_books_id
643: (P_SET_OF_BOOKS_NAME => c.p91);
644: end if;
645: --
646: if c.d92=cn then

Line 663: hr_pump_get.get_contract_id

659: elsif c.d93 is null then
660: L_CONTRACT_ID:=nh;
661: else
662: L_CONTRACT_ID :=
663: hr_pump_get.get_contract_id
664: (P_CONTRACT_USER_KEY => c.p93);
665: end if;
666: --
667: if c.d94=cn or

Line 675: hr_pump_get.get_establishment_id

671: c.d95 is null then
672: L_ESTABLISHMENT_ID:=nh;
673: else
674: L_ESTABLISHMENT_ID :=
675: hr_pump_get.get_establishment_id
676: (P_ESTABLISHMENT_NAME => c.p94
677: ,P_LOCATION => c.p95);
678: end if;
679: --

Line 687: hr_pump_get.get_collective_agreement_id

683: elsif c.d96 is null then
684: L_COLLECTIVE_AGREEMENT_ID:=nh;
685: else
686: L_COLLECTIVE_AGREEMENT_ID :=
687: hr_pump_get.get_collective_agreement_id
688: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
689: ,P_CAGR_NAME => c.p96
690: ,P_EFFECTIVE_DATE => c.p1);
691: end if;