eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRDPP_UPDATE_IN_CWK_ASG dependencies on HR_PUMP_GET

Line 312: hr_pump_get.gl(l.pval003,'CWK_ASG_CATEGORY',d(l.pval001),l.pval064)) p3,

308: select l.rowid myrowid,
309: decode(l.pval001,cn,dn,d(l.pval001)) p1,
310: decode(l.pval002,cn,vn,l.pval002) p2,
311: decode(l.pval003,cn,vn,vn,vh,
312: hr_pump_get.gl(l.pval003,'CWK_ASG_CATEGORY',d(l.pval001),l.pval064)) p3,
313: l.pval003 d3,
314: decode(l.pval004,cn,vn,vn,vh,l.pval004) p4,
315: l.pval004 d4,
316: decode(l.pval005,cn,vn,vn,vh,

Line 317: hr_pump_get.gl(l.pval005,'CWK_ASSIGN_REASON',d(l.pval001),l.pval064)) p5,

313: l.pval003 d3,
314: decode(l.pval004,cn,vn,vn,vh,l.pval004) p4,
315: l.pval004 d4,
316: decode(l.pval005,cn,vn,vn,vh,
317: hr_pump_get.gl(l.pval005,'CWK_ASSIGN_REASON',d(l.pval001),l.pval064)) p5,
318: l.pval005 d5,
319: decode(l.pval006,cn,vn,vn,vh,l.pval006) p6,
320: l.pval006 d6,
321: decode(l.pval007,cn,vn,vn,vh,

Line 322: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval064)) p7,

318: l.pval005 d5,
319: decode(l.pval006,cn,vn,vn,vh,l.pval006) p6,
320: l.pval006 d6,
321: decode(l.pval007,cn,vn,vn,vh,
322: hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval064)) p7,
323: l.pval007 d7,
324: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
325: l.pval008 d8,
326: decode(l.pval009,cn,vn,vn,vh,

Line 327: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval064)) p9,

323: l.pval007 d7,
324: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
325: l.pval008 d8,
326: decode(l.pval009,cn,vn,vn,vh,
327: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval064)) p9,
328: l.pval009 d9,
329: decode(l.pval010,cn,vn,vn,vh,
330: hr_pump_get.gl(l.pval010,'YES_NO',d(l.pval001),l.pval064)) p10,
331: l.pval010 d10,

Line 330: hr_pump_get.gl(l.pval010,'YES_NO',d(l.pval001),l.pval064)) p10,

326: decode(l.pval009,cn,vn,vn,vh,
327: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval064)) p9,
328: l.pval009 d9,
329: decode(l.pval010,cn,vn,vn,vh,
330: hr_pump_get.gl(l.pval010,'YES_NO',d(l.pval001),l.pval064)) p10,
331: l.pval010 d10,
332: decode(l.pval011,cn,nn,vn,nh,n(l.pval011)) p11,
333: l.pval011 d11,
334: decode(l.pval012,cn,vn,vn,vh,l.pval012) p12,

Line 337: hr_pump_get.gl(l.pval013,'REC_TYPE',d(l.pval001),l.pval064)) p13,

333: l.pval011 d11,
334: decode(l.pval012,cn,vn,vn,vh,l.pval012) p12,
335: l.pval012 d12,
336: decode(l.pval013,cn,vn,vn,vh,
337: hr_pump_get.gl(l.pval013,'REC_TYPE',d(l.pval001),l.pval064)) p13,
338: l.pval013 d13,
339: decode(l.pval014,cn,vn,vn,vh,l.pval014) p14,
340: l.pval014 d14,
341: decode(l.pval015,cn,vn,vn,vh,l.pval015) p15,

Line 488: hr_pump_get.get_assignment_id

484: if c.p61 is null then
485: L_ASSIGNMENT_ID:=nn;
486: else
487: L_ASSIGNMENT_ID :=
488: hr_pump_get.get_assignment_id
489: (P_ASSIGNMENT_USER_KEY => c.p61);
490: end if;
491: --
492: if c.p61 is null or

Line 497: hr_pump_get.GET_ASG_OVN

493: c.p1 is null then
494: L_OBJECT_VERSION_NUMBER:=nn;
495: else
496: L_OBJECT_VERSION_NUMBER :=
497: hr_pump_get.GET_ASG_OVN
498: (P_ASSIGNMENT_USER_KEY => c.p61
499: ,P_EFFECTIVE_DATE => c.p1);
500: end if;
501: --

Line 508: hr_pump_get.get_default_code_comb_id

504: elsif c.d62 is null then
505: L_DEFAULT_CODE_COMB_ID:=nh;
506: else
507: L_DEFAULT_CODE_COMB_ID :=
508: hr_pump_get.get_default_code_comb_id
509: (P_DEFAULT_CODE_COMB_USER_KEY => c.p62);
510: end if;
511: --
512: if c.d63=cn or

Line 521: hr_pump_get.GET_ESTABLISHMENT_ORG_ID

517: c.d64 is null then
518: L_ESTABLISHMENT_ID:=nh;
519: else
520: L_ESTABLISHMENT_ID :=
521: hr_pump_get.GET_ESTABLISHMENT_ORG_ID
522: (P_ESTABLISHMENT_ORG_NAME => c.p63
523: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
524: ,P_EFFECTIVE_DATE => c.p1
525: ,P_LANGUAGE_CODE => c.p64);

Line 534: hr_pump_get.get_set_of_books_id

530: elsif c.d65 is null then
531: L_SET_OF_BOOKS_ID:=nh;
532: else
533: L_SET_OF_BOOKS_ID :=
534: hr_pump_get.get_set_of_books_id
535: (P_SET_OF_BOOKS_NAME => c.p65);
536: end if;
537: --
538: if c.d66=cn then

Line 544: hr_pump_get.get_supervisor_id

540: elsif c.d66 is null then
541: L_SUPERVISOR_ID:=nh;
542: else
543: L_SUPERVISOR_ID :=
544: hr_pump_get.get_supervisor_id
545: (P_SUPERVISOR_USER_KEY => c.p66);
546: end if;
547: --
548: if c.d67=cn then

Line 554: hr_pump_get.get_vendor_id

550: elsif c.d67 is null then
551: L_VENDOR_ID:=nh;
552: else
553: L_VENDOR_ID :=
554: hr_pump_get.get_vendor_id
555: (P_VENDOR_NAME => c.p67);
556: end if;
557: --
558: if c.d68=cn then

Line 596: hr_pump_get.get_assignment_status_type_id

592: c.d64 is null then
593: L_ASSIGNMENT_STATUS_TYPE_ID:=nh;
594: else
595: L_ASSIGNMENT_STATUS_TYPE_ID :=
596: hr_pump_get.get_assignment_status_type_id
597: (P_USER_STATUS => c.p71
598: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
599: ,P_LANGUAGE_CODE => c.p64);
600: end if;

Line 618: hr_pump_get.get_supervisor_assignment_id

614: elsif c.d73 is null then
615: L_SUPERVISOR_ASSIGNMENT_ID:=nh;
616: else
617: L_SUPERVISOR_ASSIGNMENT_ID :=
618: hr_pump_get.get_supervisor_assignment_id
619: (P_SVR_ASSIGNMENT_USER_KEY => c.p73);
620: end if;
621: --
622: hr_data_pump.api_trc_on;