APPS.HRDPP_UPLOAD_SALARY_PROPOSAL dependencies on HR_PUMP_GET

Line 386: hr_pump_get.gl(l.pval003,'PROPOSAL_REASON',dn,vn)) p3,

382: decode(l.pval001,cn,dn,d(l.pval001)) p1,
383: decode(l.pval002,cn,nn,vn,nn,n(l.pval002)) p2,
384: l.pval002 d2,
385: decode(l.pval003,cn,vn,vn,vn,
386: hr_pump_get.gl(l.pval003,'PROPOSAL_REASON',dn,vn)) p3,
387: l.pval003 d3,
388: decode(l.pval004,cn,dn,vn,dn,d(l.pval004)) p4,
389: l.pval004 d4,
390: decode(l.pval005,cn,nn,vn,nn,n(l.pval005)) p5,

Line 397: hr_pump_get.gl(l.pval009,'PROPOSAL_REASON',dn,vn)) p9,

393: l.pval006 d6,
394: decode(l.pval007,cn,nn,n(l.pval007)) p7,
395: decode(l.pval008,cn,nn,n(l.pval008)) p8,
396: decode(l.pval009,cn,vn,
397: hr_pump_get.gl(l.pval009,'PROPOSAL_REASON',dn,vn)) p9,
398: decode(l.pval010,cn,nn,vn,nn,n(l.pval010)) p10,
399: l.pval010 d10,
400: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,
401: l.pval011 d11,

Line 403: hr_pump_get.gl(l.pval012,'YES_NO',dn,vn)) p12,

399: l.pval010 d10,
400: decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,
401: l.pval011 d11,
402: decode(l.pval012,cn,vn,
403: hr_pump_get.gl(l.pval012,'YES_NO',dn,vn)) p12,
404: decode(l.pval013,cn,nn,n(l.pval013)) p13,
405: decode(l.pval014,cn,nn,n(l.pval014)) p14,
406: decode(l.pval015,cn,vn,
407: hr_pump_get.gl(l.pval015,'PROPOSAL_REASON',dn,vn)) p15,

Line 407: hr_pump_get.gl(l.pval015,'PROPOSAL_REASON',dn,vn)) p15,

403: hr_pump_get.gl(l.pval012,'YES_NO',dn,vn)) p12,
404: decode(l.pval013,cn,nn,n(l.pval013)) p13,
405: decode(l.pval014,cn,nn,n(l.pval014)) p14,
406: decode(l.pval015,cn,vn,
407: hr_pump_get.gl(l.pval015,'PROPOSAL_REASON',dn,vn)) p15,
408: decode(l.pval016,cn,nn,vn,nn,n(l.pval016)) p16,
409: l.pval016 d16,
410: decode(l.pval017,cn,nn,vn,nn,n(l.pval017)) p17,
411: l.pval017 d17,

Line 413: hr_pump_get.gl(l.pval018,'YES_NO',dn,vn)) p18,

409: l.pval016 d16,
410: decode(l.pval017,cn,nn,vn,nn,n(l.pval017)) p17,
411: l.pval017 d17,
412: decode(l.pval018,cn,vn,
413: hr_pump_get.gl(l.pval018,'YES_NO',dn,vn)) p18,
414: decode(l.pval019,cn,nn,n(l.pval019)) p19,
415: decode(l.pval020,cn,nn,n(l.pval020)) p20,
416: decode(l.pval021,cn,vn,
417: hr_pump_get.gl(l.pval021,'PROPOSAL_REASON',dn,vn)) p21,

Line 417: hr_pump_get.gl(l.pval021,'PROPOSAL_REASON',dn,vn)) p21,

413: hr_pump_get.gl(l.pval018,'YES_NO',dn,vn)) p18,
414: decode(l.pval019,cn,nn,n(l.pval019)) p19,
415: decode(l.pval020,cn,nn,n(l.pval020)) p20,
416: decode(l.pval021,cn,vn,
417: hr_pump_get.gl(l.pval021,'PROPOSAL_REASON',dn,vn)) p21,
418: decode(l.pval022,cn,nn,vn,nn,n(l.pval022)) p22,
419: l.pval022 d22,
420: decode(l.pval023,cn,nn,vn,nn,n(l.pval023)) p23,
421: l.pval023 d23,

Line 423: hr_pump_get.gl(l.pval024,'YES_NO',dn,vn)) p24,

419: l.pval022 d22,
420: decode(l.pval023,cn,nn,vn,nn,n(l.pval023)) p23,
421: l.pval023 d23,
422: decode(l.pval024,cn,vn,
423: hr_pump_get.gl(l.pval024,'YES_NO',dn,vn)) p24,
424: decode(l.pval025,cn,nn,n(l.pval025)) p25,
425: decode(l.pval026,cn,nn,n(l.pval026)) p26,
426: decode(l.pval027,cn,vn,
427: hr_pump_get.gl(l.pval027,'PROPOSAL_REASON',dn,vn)) p27,

Line 427: hr_pump_get.gl(l.pval027,'PROPOSAL_REASON',dn,vn)) p27,

423: hr_pump_get.gl(l.pval024,'YES_NO',dn,vn)) p24,
424: decode(l.pval025,cn,nn,n(l.pval025)) p25,
425: decode(l.pval026,cn,nn,n(l.pval026)) p26,
426: decode(l.pval027,cn,vn,
427: hr_pump_get.gl(l.pval027,'PROPOSAL_REASON',dn,vn)) p27,
428: decode(l.pval028,cn,nn,vn,nn,n(l.pval028)) p28,
429: l.pval028 d28,
430: decode(l.pval029,cn,nn,vn,nn,n(l.pval029)) p29,
431: l.pval029 d29,

Line 433: hr_pump_get.gl(l.pval030,'YES_NO',dn,vn)) p30,

429: l.pval028 d28,
430: decode(l.pval029,cn,nn,vn,nn,n(l.pval029)) p29,
431: l.pval029 d29,
432: decode(l.pval030,cn,vn,
433: hr_pump_get.gl(l.pval030,'YES_NO',dn,vn)) p30,
434: decode(l.pval031,cn,nn,n(l.pval031)) p31,
435: decode(l.pval032,cn,nn,n(l.pval032)) p32,
436: decode(l.pval033,cn,vn,
437: hr_pump_get.gl(l.pval033,'PROPOSAL_REASON',dn,vn)) p33,

Line 437: hr_pump_get.gl(l.pval033,'PROPOSAL_REASON',dn,vn)) p33,

433: hr_pump_get.gl(l.pval030,'YES_NO',dn,vn)) p30,
434: decode(l.pval031,cn,nn,n(l.pval031)) p31,
435: decode(l.pval032,cn,nn,n(l.pval032)) p32,
436: decode(l.pval033,cn,vn,
437: hr_pump_get.gl(l.pval033,'PROPOSAL_REASON',dn,vn)) p33,
438: decode(l.pval034,cn,nn,vn,nn,n(l.pval034)) p34,
439: l.pval034 d34,
440: decode(l.pval035,cn,nn,vn,nn,n(l.pval035)) p35,
441: l.pval035 d35,

Line 443: hr_pump_get.gl(l.pval036,'YES_NO',dn,vn)) p36,

439: l.pval034 d34,
440: decode(l.pval035,cn,nn,vn,nn,n(l.pval035)) p35,
441: l.pval035 d35,
442: decode(l.pval036,cn,vn,
443: hr_pump_get.gl(l.pval036,'YES_NO',dn,vn)) p36,
444: decode(l.pval037,cn,nn,n(l.pval037)) p37,
445: decode(l.pval038,cn,nn,n(l.pval038)) p38,
446: decode(l.pval039,cn,vn,
447: hr_pump_get.gl(l.pval039,'PROPOSAL_REASON',dn,vn)) p39,

Line 447: hr_pump_get.gl(l.pval039,'PROPOSAL_REASON',dn,vn)) p39,

443: hr_pump_get.gl(l.pval036,'YES_NO',dn,vn)) p36,
444: decode(l.pval037,cn,nn,n(l.pval037)) p37,
445: decode(l.pval038,cn,nn,n(l.pval038)) p38,
446: decode(l.pval039,cn,vn,
447: hr_pump_get.gl(l.pval039,'PROPOSAL_REASON',dn,vn)) p39,
448: decode(l.pval040,cn,nn,vn,nn,n(l.pval040)) p40,
449: l.pval040 d40,
450: decode(l.pval041,cn,nn,vn,nn,n(l.pval041)) p41,
451: l.pval041 d41,

Line 453: hr_pump_get.gl(l.pval042,'YES_NO',dn,vn)) p42,

449: l.pval040 d40,
450: decode(l.pval041,cn,nn,vn,nn,n(l.pval041)) p41,
451: l.pval041 d41,
452: decode(l.pval042,cn,vn,
453: hr_pump_get.gl(l.pval042,'YES_NO',dn,vn)) p42,
454: decode(l.pval043,cn,nn,n(l.pval043)) p43,
455: decode(l.pval044,cn,nn,n(l.pval044)) p44,
456: decode(l.pval045,cn,vn,
457: hr_pump_get.gl(l.pval045,'PROPOSAL_REASON',dn,vn)) p45,

Line 457: hr_pump_get.gl(l.pval045,'PROPOSAL_REASON',dn,vn)) p45,

453: hr_pump_get.gl(l.pval042,'YES_NO',dn,vn)) p42,
454: decode(l.pval043,cn,nn,n(l.pval043)) p43,
455: decode(l.pval044,cn,nn,n(l.pval044)) p44,
456: decode(l.pval045,cn,vn,
457: hr_pump_get.gl(l.pval045,'PROPOSAL_REASON',dn,vn)) p45,
458: decode(l.pval046,cn,nn,vn,nn,n(l.pval046)) p46,
459: l.pval046 d46,
460: decode(l.pval047,cn,nn,vn,nn,n(l.pval047)) p47,
461: l.pval047 d47,

Line 463: hr_pump_get.gl(l.pval048,'YES_NO',dn,vn)) p48,

459: l.pval046 d46,
460: decode(l.pval047,cn,nn,vn,nn,n(l.pval047)) p47,
461: l.pval047 d47,
462: decode(l.pval048,cn,vn,
463: hr_pump_get.gl(l.pval048,'YES_NO',dn,vn)) p48,
464: decode(l.pval049,cn,nn,n(l.pval049)) p49,
465: decode(l.pval050,cn,nn,n(l.pval050)) p50,
466: decode(l.pval051,cn,vn,
467: hr_pump_get.gl(l.pval051,'PROPOSAL_REASON',dn,vn)) p51,

Line 467: hr_pump_get.gl(l.pval051,'PROPOSAL_REASON',dn,vn)) p51,

463: hr_pump_get.gl(l.pval048,'YES_NO',dn,vn)) p48,
464: decode(l.pval049,cn,nn,n(l.pval049)) p49,
465: decode(l.pval050,cn,nn,n(l.pval050)) p50,
466: decode(l.pval051,cn,vn,
467: hr_pump_get.gl(l.pval051,'PROPOSAL_REASON',dn,vn)) p51,
468: decode(l.pval052,cn,nn,vn,nn,n(l.pval052)) p52,
469: l.pval052 d52,
470: decode(l.pval053,cn,nn,vn,nn,n(l.pval053)) p53,
471: l.pval053 d53,

Line 473: hr_pump_get.gl(l.pval054,'YES_NO',dn,vn)) p54,

469: l.pval052 d52,
470: decode(l.pval053,cn,nn,vn,nn,n(l.pval053)) p53,
471: l.pval053 d53,
472: decode(l.pval054,cn,vn,
473: hr_pump_get.gl(l.pval054,'YES_NO',dn,vn)) p54,
474: decode(l.pval055,cn,nn,n(l.pval055)) p55,
475: decode(l.pval056,cn,nn,n(l.pval056)) p56,
476: decode(l.pval057,cn,vn,
477: hr_pump_get.gl(l.pval057,'PROPOSAL_REASON',dn,vn)) p57,

Line 477: hr_pump_get.gl(l.pval057,'PROPOSAL_REASON',dn,vn)) p57,

473: hr_pump_get.gl(l.pval054,'YES_NO',dn,vn)) p54,
474: decode(l.pval055,cn,nn,n(l.pval055)) p55,
475: decode(l.pval056,cn,nn,n(l.pval056)) p56,
476: decode(l.pval057,cn,vn,
477: hr_pump_get.gl(l.pval057,'PROPOSAL_REASON',dn,vn)) p57,
478: decode(l.pval058,cn,nn,vn,nn,n(l.pval058)) p58,
479: l.pval058 d58,
480: decode(l.pval059,cn,nn,vn,nn,n(l.pval059)) p59,
481: l.pval059 d59,

Line 483: hr_pump_get.gl(l.pval060,'YES_NO',dn,vn)) p60,

479: l.pval058 d58,
480: decode(l.pval059,cn,nn,vn,nn,n(l.pval059)) p59,
481: l.pval059 d59,
482: decode(l.pval060,cn,vn,
483: hr_pump_get.gl(l.pval060,'YES_NO',dn,vn)) p60,
484: decode(l.pval061,cn,nn,n(l.pval061)) p61,
485: decode(l.pval062,cn,nn,n(l.pval062)) p62,
486: decode(l.pval063,cn,vn,
487: hr_pump_get.gl(l.pval063,'PROPOSAL_REASON',dn,vn)) p63,

Line 487: hr_pump_get.gl(l.pval063,'PROPOSAL_REASON',dn,vn)) p63,

483: hr_pump_get.gl(l.pval060,'YES_NO',dn,vn)) p60,
484: decode(l.pval061,cn,nn,n(l.pval061)) p61,
485: decode(l.pval062,cn,nn,n(l.pval062)) p62,
486: decode(l.pval063,cn,vn,
487: hr_pump_get.gl(l.pval063,'PROPOSAL_REASON',dn,vn)) p63,
488: decode(l.pval064,cn,nn,vn,nn,n(l.pval064)) p64,
489: l.pval064 d64,
490: decode(l.pval065,cn,nn,vn,nn,n(l.pval065)) p65,
491: l.pval065 d65,

Line 493: hr_pump_get.gl(l.pval066,'YES_NO',dn,vn)) p66,

489: l.pval064 d64,
490: decode(l.pval065,cn,nn,vn,nn,n(l.pval065)) p65,
491: l.pval065 d65,
492: decode(l.pval066,cn,vn,
493: hr_pump_get.gl(l.pval066,'YES_NO',dn,vn)) p66,
494: decode(l.pval067,cn,nn,n(l.pval067)) p67,
495: decode(l.pval068,cn,nn,n(l.pval068)) p68,
496: l.pval069 p69,
497: l.pval070 p70,

Line 566: hr_pump_get.get_assignment_id

562: if c.p92 is null then
563: L_ASSIGNMENT_ID:=nn;
564: else
565: L_ASSIGNMENT_ID :=
566: hr_pump_get.get_assignment_id
567: (P_ASSIGNMENT_USER_KEY => c.p92);
568: end if;
569: --
570: hr_data_pump.api_trc_on;