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_CREATE_IN_SECONDARY_CWK_ dependencies on HR_PUMP_GET

Line 415: hr_pump_get.gl(l.pval003,'CWK_ASG_CATEGORY',d(l.pval001),l.pval095)) p3,

411: select l.rowid myrowid,
412: decode(l.pval001,cn,dn,d(l.pval001)) p1,
413: decode(l.pval002,cn,vn,l.pval002) p2,
414: decode(l.pval003,cn,vn,vn,vn,
415: hr_pump_get.gl(l.pval003,'CWK_ASG_CATEGORY',d(l.pval001),l.pval095)) p3,
416: l.pval003 d3,
417: decode(l.pval004,cn,vn,vn,vn,
418: hr_pump_get.gl(l.pval004,'CWK_ASSIGN_REASON',d(l.pval001),l.pval095)) p4,
419: l.pval004 d4,

Line 418: hr_pump_get.gl(l.pval004,'CWK_ASSIGN_REASON',d(l.pval001),l.pval095)) p4,

414: decode(l.pval003,cn,vn,vn,vn,
415: hr_pump_get.gl(l.pval003,'CWK_ASG_CATEGORY',d(l.pval001),l.pval095)) p3,
416: l.pval003 d3,
417: decode(l.pval004,cn,vn,vn,vn,
418: hr_pump_get.gl(l.pval004,'CWK_ASSIGN_REASON',d(l.pval001),l.pval095)) p4,
419: l.pval004 d4,
420: decode(l.pval005,cn,vn,vn,vn,l.pval005) p5,
421: l.pval005 d5,
422: decode(l.pval006,cn,vn,vn,vn,

Line 423: hr_pump_get.gl(l.pval006,'FREQUENCY',d(l.pval001),l.pval095)) p6,

419: l.pval004 d4,
420: decode(l.pval005,cn,vn,vn,vn,l.pval005) p5,
421: l.pval005 d5,
422: decode(l.pval006,cn,vn,vn,vn,
423: hr_pump_get.gl(l.pval006,'FREQUENCY',d(l.pval001),l.pval095)) p6,
424: l.pval006 d6,
425: decode(l.pval007,cn,vn,vn,vn,l.pval007) p7,
426: l.pval007 d7,
427: decode(l.pval008,cn,vn,vn,'N',

Line 428: hr_pump_get.gl(l.pval008,'YES_NO',d(l.pval001),l.pval095)) p8,

424: l.pval006 d6,
425: decode(l.pval007,cn,vn,vn,vn,l.pval007) p7,
426: l.pval007 d7,
427: decode(l.pval008,cn,vn,vn,'N',
428: hr_pump_get.gl(l.pval008,'YES_NO',d(l.pval001),l.pval095)) p8,
429: l.pval008 d8,
430: decode(l.pval009,cn,vn,vn,vn,
431: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval095)) p9,
432: l.pval009 d9,

Line 431: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval095)) p9,

427: decode(l.pval008,cn,vn,vn,'N',
428: hr_pump_get.gl(l.pval008,'YES_NO',d(l.pval001),l.pval095)) p8,
429: l.pval008 d8,
430: decode(l.pval009,cn,vn,vn,vn,
431: hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval095)) p9,
432: l.pval009 d9,
433: decode(l.pval010,cn,nn,vn,nn,n(l.pval010)) p10,
434: l.pval010 d10,
435: decode(l.pval011,cn,vn,vn,vn,l.pval011) p11,

Line 438: hr_pump_get.gl(l.pval012,'REC_TYPE',d(l.pval001),l.pval095)) p12,

434: l.pval010 d10,
435: decode(l.pval011,cn,vn,vn,vn,l.pval011) p11,
436: l.pval011 d11,
437: decode(l.pval012,cn,vn,vn,vn,
438: hr_pump_get.gl(l.pval012,'REC_TYPE',d(l.pval001),l.pval095)) p12,
439: l.pval012 d12,
440: decode(l.pval013,cn,vn,vn,vn,l.pval013) p13,
441: l.pval013 d13,
442: decode(l.pval014,cn,vn,vn,vn,l.pval014) p14,

Line 664: hr_pump_get.get_person_id

660: if c.p93 is null then
661: L_PERSON_ID:=nn;
662: else
663: L_PERSON_ID :=
664: hr_pump_get.get_person_id
665: (P_PERSON_USER_KEY => c.p93);
666: end if;
667: --
668: if c.p94 is null or

Line 674: hr_pump_get.get_organization_id

670: c.p95 is null then
671: L_ORGANIZATION_ID:=nn;
672: else
673: L_ORGANIZATION_ID :=
674: hr_pump_get.get_organization_id
675: (P_ORGANIZATION_NAME => c.p94
676: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
677: ,P_EFFECTIVE_DATE => c.p1
678: ,P_LANGUAGE_CODE => c.p95);

Line 686: hr_pump_get.get_assignment_status_type_id

682: c.p95 is null then
683: L_ASSIGNMENT_STATUS_TYPE_ID:=nn;
684: else
685: L_ASSIGNMENT_STATUS_TYPE_ID :=
686: hr_pump_get.get_assignment_status_type_id
687: (P_USER_STATUS => c.p96
688: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
689: ,P_LANGUAGE_CODE => c.p95);
690: end if;

Line 696: hr_pump_get.get_default_code_comb_id

692: if c.p97 is null then
693: L_DEFAULT_CODE_COMB_ID:=nn;
694: else
695: L_DEFAULT_CODE_COMB_ID :=
696: hr_pump_get.get_default_code_comb_id
697: (P_DEFAULT_CODE_COMB_USER_KEY => c.p97);
698: end if;
699: --
700: if c.p98 is null or

Line 706: hr_pump_get.GET_ESTABLISHMENT_ORG_ID

702: c.p95 is null then
703: L_ESTABLISHMENT_ID:=nn;
704: else
705: L_ESTABLISHMENT_ID :=
706: hr_pump_get.GET_ESTABLISHMENT_ORG_ID
707: (P_ESTABLISHMENT_ORG_NAME => c.p98
708: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
709: ,P_EFFECTIVE_DATE => c.p1
710: ,P_LANGUAGE_CODE => c.p95);

Line 718: hr_pump_get.get_job_id

714: c.p1 is null then
715: L_JOB_ID:=nn;
716: else
717: L_JOB_ID :=
718: hr_pump_get.get_job_id
719: (P_JOB_NAME => c.p99
720: ,P_EFFECTIVE_DATE => c.p1
721: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
722: end if;

Line 729: hr_pump_get.get_location_id

725: c.p95 is null then
726: L_LOCATION_ID:=nn;
727: else
728: L_LOCATION_ID :=
729: hr_pump_get.get_location_id
730: (P_LOCATION_CODE => c.p100
731: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
732: ,P_LANGUAGE_CODE => c.p95);
733: end if;

Line 740: hr_pump_get.get_position_id

736: c.p1 is null then
737: L_POSITION_ID:=nn;
738: else
739: L_POSITION_ID :=
740: hr_pump_get.get_position_id
741: (P_POSITION_NAME => c.p101
742: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
743: ,P_EFFECTIVE_DATE => c.p1);
744: end if;

Line 751: hr_pump_get.get_grade_id

747: c.p1 is null then
748: L_GRADE_ID:=nn;
749: else
750: L_GRADE_ID :=
751: hr_pump_get.get_grade_id
752: (P_GRADE_NAME => c.p102
753: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
754: ,P_EFFECTIVE_DATE => c.p1);
755: end if;

Line 761: hr_pump_get.get_set_of_books_id

757: if c.p103 is null then
758: L_SET_OF_BOOKS_ID:=nn;
759: else
760: L_SET_OF_BOOKS_ID :=
761: hr_pump_get.get_set_of_books_id
762: (P_SET_OF_BOOKS_NAME => c.p103);
763: end if;
764: --
765: if c.p104 is null then

Line 769: hr_pump_get.get_supervisor_id

765: if c.p104 is null then
766: L_SUPERVISOR_ID:=nn;
767: else
768: L_SUPERVISOR_ID :=
769: hr_pump_get.get_supervisor_id
770: (P_SUPERVISOR_USER_KEY => c.p104);
771: end if;
772: --
773: if c.p105 is null then

Line 777: hr_pump_get.get_vendor_id

773: if c.p105 is null then
774: L_VENDOR_ID:=nn;
775: else
776: L_VENDOR_ID :=
777: hr_pump_get.get_vendor_id
778: (P_VENDOR_NAME => c.p105);
779: end if;
780: --
781: if c.p106 is null then

Line 817: hr_pump_get.get_supervisor_assignment_id

813: if c.p110 is null then
814: L_SUPERVISOR_ASSIGNMENT_ID:=nn;
815: else
816: L_SUPERVISOR_ASSIGNMENT_ID :=
817: hr_pump_get.get_supervisor_assignment_id
818: (P_SVR_ASSIGNMENT_USER_KEY => c.p110);
819: end if;
820: --
821: hr_data_pump.api_trc_on;