DBA Data[Home] [Help]

APPS.HRDPP_UPDATE_GB_EMP_ASG dependencies on HR_PUMP_GET

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

327: decode(l.pval002,cn,vn,l.pval002) p2,
328: decode(l.pval003,cn,vn,vn,vh,l.pval003) p3,
329: l.pval003 d3,
330: decode(l.pval004,cn,vn,vn,vh,
331: hr_pump_get.gl(l.pval004,'EMP_ASSIGN_REASON',d(l.pval001),vn)) p4,
332: l.pval004 d4,
333: decode(l.pval005,cn,vn,vn,vh,l.pval005) p5,
334: l.pval005 d5,
335: decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,

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

334: l.pval005 d5,
335: decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,
336: l.pval006 d6,
337: decode(l.pval007,cn,vn,vn,vh,
338: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),vn)) p7,
339: l.pval007 d7,
340: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
341: l.pval008 d8,
342: decode(l.pval009,cn,vn,vn,vh,

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

339: l.pval007 d7,
340: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
341: l.pval008 d8,
342: decode(l.pval009,cn,vn,vn,vh,
343: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),vn)) p9,
344: l.pval009 d9,
345: decode(l.pval010,cn,nn,vn,nh,n(l.pval010)) p10,
346: l.pval010 d10,
347: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,

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

346: l.pval010 d10,
347: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,
348: l.pval011 d11,
349: decode(l.pval012,cn,vn,vn,vh,
350: hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),vn)) p12,
351: l.pval012 d12,
352: decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
353: l.pval013 d13,
354: decode(l.pval014,cn,vn,vn,vh,

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

351: l.pval012 d12,
352: decode(l.pval013,cn,nn,vn,nh,n(l.pval013)) p13,
353: l.pval013 d13,
354: decode(l.pval014,cn,vn,vn,vh,
355: hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),vn)) p14,
356: l.pval014 d14,
357: decode(l.pval015,cn,nn,vn,nh,n(l.pval015)) p15,
358: l.pval015 d15,
359: decode(l.pval016,cn,vn,vn,vh,

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

356: l.pval014 d14,
357: decode(l.pval015,cn,nn,vn,nh,n(l.pval015)) p15,
358: l.pval015 d15,
359: decode(l.pval016,cn,vn,vn,vh,
360: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),vn)) p16,
361: l.pval016 d16,
362: decode(l.pval017,cn,vn,vn,vh,
363: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),vn)) p17,
364: l.pval017 d17,

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

359: decode(l.pval016,cn,vn,vn,vh,
360: hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),vn)) p16,
361: l.pval016 d16,
362: decode(l.pval017,cn,vn,vn,vh,
363: hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),vn)) p17,
364: l.pval017 d17,
365: decode(l.pval018,cn,vn,vn,vh,l.pval018) p18,
366: l.pval018 d18,
367: decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,

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

366: l.pval018 d18,
367: decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,
368: l.pval019 d19,
369: decode(l.pval020,cn,vn,vn,vh,
370: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),vn)) p20,
371: l.pval020 d20,
372: decode(l.pval021,cn,vn,vn,vh,
373: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),vn)) p21,
374: l.pval021 d21,

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

369: decode(l.pval020,cn,vn,vn,vh,
370: hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),vn)) p20,
371: l.pval020 d20,
372: decode(l.pval021,cn,vn,vn,vh,
373: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),vn)) p21,
374: l.pval021 d21,
375: decode(l.pval022,cn,vn,vn,vh,
376: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),vn)) p22,
377: l.pval022 d22,

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

372: decode(l.pval021,cn,vn,vn,vh,
373: hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),vn)) p21,
374: l.pval021 d21,
375: decode(l.pval022,cn,vn,vn,vh,
376: hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),vn)) p22,
377: l.pval022 d22,
378: decode(l.pval023,cn,vn,vn,vh,l.pval023) p23,
379: l.pval023 d23,
380: decode(l.pval024,cn,vn,vn,vh,l.pval024) p24,

Line 515: hr_pump_get.get_assignment_id

511: if c.p71 is null then
512: L_ASSIGNMENT_ID:=nn;
513: else
514: L_ASSIGNMENT_ID :=
515: hr_pump_get.get_assignment_id
516: (P_ASSIGNMENT_USER_KEY => c.p71);
517: end if;
518: --
519: if c.p71 is null or

Line 524: hr_pump_get.GET_ASG_OVN

520: c.p1 is null then
521: L_OBJECT_VERSION_NUMBER:=nn;
522: else
523: L_OBJECT_VERSION_NUMBER :=
524: hr_pump_get.GET_ASG_OVN
525: (P_ASSIGNMENT_USER_KEY => c.p71
526: ,P_EFFECTIVE_DATE => c.p1);
527: end if;
528: --

Line 535: hr_pump_get.get_supervisor_id

531: elsif c.d72 is null then
532: L_SUPERVISOR_ID:=nh;
533: else
534: L_SUPERVISOR_ID :=
535: hr_pump_get.get_supervisor_id
536: (P_SUPERVISOR_USER_KEY => c.p72);
537: end if;
538: --
539: if c.d73=cn then

Line 545: hr_pump_get.get_default_code_comb_id

541: elsif c.d73 is null then
542: L_DEFAULT_CODE_COMB_ID:=nh;
543: else
544: L_DEFAULT_CODE_COMB_ID :=
545: hr_pump_get.get_default_code_comb_id
546: (P_DEFAULT_CODE_COMB_USER_KEY => c.p73);
547: end if;
548: --
549: if c.d74=cn then

Line 555: hr_pump_get.get_set_of_books_id

551: elsif c.d74 is null then
552: L_SET_OF_BOOKS_ID:=nh;
553: else
554: L_SET_OF_BOOKS_ID :=
555: hr_pump_get.get_set_of_books_id
556: (P_SET_OF_BOOKS_NAME => c.p74);
557: end if;
558: --
559: if c.d75=cn then

Line 565: hr_pump_get.get_contract_id

561: elsif c.d75 is null then
562: L_CONTRACT_ID:=nh;
563: else
564: L_CONTRACT_ID :=
565: hr_pump_get.get_contract_id
566: (P_CONTRACT_USER_KEY => c.p75);
567: end if;
568: --
569: if c.d76=cn or

Line 577: hr_pump_get.get_establishment_id

573: c.d77 is null then
574: L_ESTABLISHMENT_ID:=nh;
575: else
576: L_ESTABLISHMENT_ID :=
577: hr_pump_get.get_establishment_id
578: (P_ESTABLISHMENT_NAME => c.p76
579: ,P_LOCATION => c.p77);
580: end if;
581: --

Line 589: hr_pump_get.get_collective_agreement_id

585: elsif c.d78 is null then
586: L_COLLECTIVE_AGREEMENT_ID:=nh;
587: else
588: L_COLLECTIVE_AGREEMENT_ID :=
589: hr_pump_get.get_collective_agreement_id
590: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
591: ,P_CAGR_NAME => c.p78
592: ,P_EFFECTIVE_DATE => c.p1);
593: end if;

Line 601: hr_pump_get.get_supervisor_assignment_id

597: elsif c.d79 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.p79);
603: end if;
604: --
605: hr_data_pump.api_trc_on;