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.IGIDOSL dependencies on HR_ALL_POSITIONS_F

Line 666: l_business_group_id hr_all_positions_f.business_group_id%TYPE;

662: l_position_id per_all_positions.position_id%TYPE;
663: l_top_position_id per_all_positions.position_id%TYPE ;
664: l_hierarchy_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;
665: l_hierarchy_id per_position_structures.position_structure_id%TYPE;
666: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
667: l_organization_id hr_all_positions_f.organization_id%TYPE;
668: l_current_user_name fnd_user.user_name%TYPE;
669:
670: cur_pos_not_found EXCEPTION ;

Line 667: l_organization_id hr_all_positions_f.organization_id%TYPE;

663: l_top_position_id per_all_positions.position_id%TYPE ;
664: l_hierarchy_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;
665: l_hierarchy_id per_position_structures.position_structure_id%TYPE;
666: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
667: l_organization_id hr_all_positions_f.organization_id%TYPE;
668: l_current_user_name fnd_user.user_name%TYPE;
669:
670: cur_pos_not_found EXCEPTION ;
671: pos_hier_not_found EXCEPTION ;

Line 686: FROM hr_all_positions_f hap,

682: SELECT hap.position_id,
683: hap.business_group_id,
684: hap.organization_id,
685: fu.user_name
686: FROM hr_all_positions_f hap,
687: per_all_assignments_f paa,
688: fnd_user fu ,
689: per_people_f p,
690: per_periods_of_service b

Line 732: p_business_group_id hr_all_positions_f.business_group_id%TYPE)

728: /* FETCH current version of position hierarchy */
729: /***********************************************/
730:
731: CURSOR c_pos_hier_ver(p_hierarchy_id igi_dos_doc_types.hierarchy_id%TYPE,
732: p_business_group_id hr_all_positions_f.business_group_id%TYPE)
733: IS
734: SELECT pos_structure_version_id
735: FROM per_pos_structure_versions
736: WHERE position_structure_id = p_hierarchy_id

Line 752: p_business_group_id hr_all_positions_f.business_group_id%TYPE)

748: /***********************************/
749:
750: CURSOR c_get_top_position
751: (p_pos_structure_ver_id per_pos_structure_elements.pos_structure_version_id%TYPE,
752: p_business_group_id hr_all_positions_f.business_group_id%TYPE)
753: IS
754: SELECT ppse.parent_position_id
755: FROM per_pos_structure_elements ppse
756: WHERE ppse.pos_structure_version_id = p_pos_structure_ver_id

Line 771: p_business_group_id hr_all_positions_f.business_group_id%TYPE)

767:
768: CURSOR c_par_pos_id
769: (p_hier_ver_id per_pos_structure_versions.pos_structure_version_id%TYPE,
770: p_position_id per_all_positions.position_id%TYPE,
771: p_business_group_id hr_all_positions_f.business_group_id%TYPE)
772: IS
773: SELECT parent_position_id
774: FROM per_pos_structure_elements
775: WHERE pos_structure_version_id = p_hier_ver_id

Line 1709: l_business_group_id hr_all_positions_f.business_group_id%TYPE

1705: := Wf_Engine.GetItemAttrText (itemtype => ItemType,
1706: itemkey => ItemKey,
1707: aname => 'PARENT_POSITION_ID');
1708:
1709: l_business_group_id hr_all_positions_f.business_group_id%TYPE
1710: := Wf_Engine.GetItemAttrText( itemtype => itemtype,
1711: itemkey => itemkey,
1712: aname => 'BUSINESS_GROUP_ID');
1713:

Line 1714: l_organization_id hr_all_positions_f.organization_id%TYPE

1710: := Wf_Engine.GetItemAttrText( itemtype => itemtype,
1711: itemkey => itemkey,
1712: aname => 'BUSINESS_GROUP_ID');
1713:
1714: l_organization_id hr_all_positions_f.organization_id%TYPE
1715: := Wf_Engine.GetItemAttrText( itemtype => itemtype,
1716: itemkey => itemkey,
1717: aname => 'ORGANIZATION_ID');
1718:

Line 1722: FROM hr_all_positions_f hap,

1718:
1719: CURSOR c_user_list
1720: IS
1721: select fu.user_name user_name
1722: FROM hr_all_positions_f hap,
1723: per_all_assignments_f paa,
1724: fnd_user fu ,
1725: per_people_f p,
1726: per_periods_of_service b

Line 1884: l_parent_position_id hr_all_positions_f.position_id%TYPE

1880: aname => 'USER_LIST');
1881:
1882: l_next_position per_positions.name%TYPE;
1883:
1884: l_parent_position_id hr_all_positions_f.position_id%TYPE
1885: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1886: itemkey => itemkey,
1887: aname => 'PARENT_POSITION_ID');
1888:

Line 2779: hr_all_positions_f hap,

2775: hap.name,
2776: hap.business_group_id,
2777: hap.organization_id
2778: FROM
2779: hr_all_positions_f hap,
2780: per_all_assignments_f paa,
2781: per_people_f p,
2782: per_periods_of_service b
2783: WHERE

Line 2803: l_position_id hr_all_positions_f.position_id%TYPE;

2799: and NVL(hap.date_end, SYSDATE) >= SYSDATE
2800: and NVL(UPPER(hap.status), 'VALID') NOT IN ('INVALID') ;
2801:
2802:
2803: l_position_id hr_all_positions_f.position_id%TYPE;
2804: l_position_name hr_all_positions_f.name%TYPE;
2805: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
2806: l_organization_id hr_all_positions_f.organization_id%TYPE;
2807:

Line 2804: l_position_name hr_all_positions_f.name%TYPE;

2800: and NVL(UPPER(hap.status), 'VALID') NOT IN ('INVALID') ;
2801:
2802:
2803: l_position_id hr_all_positions_f.position_id%TYPE;
2804: l_position_name hr_all_positions_f.name%TYPE;
2805: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
2806: l_organization_id hr_all_positions_f.organization_id%TYPE;
2807:
2808: l_emp_id NUMBER(15) := Wf_Engine.GetItemAttrText

Line 2805: l_business_group_id hr_all_positions_f.business_group_id%TYPE;

2801:
2802:
2803: l_position_id hr_all_positions_f.position_id%TYPE;
2804: l_position_name hr_all_positions_f.name%TYPE;
2805: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
2806: l_organization_id hr_all_positions_f.organization_id%TYPE;
2807:
2808: l_emp_id NUMBER(15) := Wf_Engine.GetItemAttrText
2809: ( itemtype => itemtype,

Line 2806: l_organization_id hr_all_positions_f.organization_id%TYPE;

2802:
2803: l_position_id hr_all_positions_f.position_id%TYPE;
2804: l_position_name hr_all_positions_f.name%TYPE;
2805: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
2806: l_organization_id hr_all_positions_f.organization_id%TYPE;
2807:
2808: l_emp_id NUMBER(15) := Wf_Engine.GetItemAttrText
2809: ( itemtype => itemtype,
2810: itemkey => itemkey,

Line 2916: l_position_id hr_all_positions_f.position_id%TYPE :=

2912: actid IN NUMBER,
2913: funcmode IN VARCHAR2,
2914: result OUT NOCOPY VARCHAR2 ) IS
2915:
2916: l_position_id hr_all_positions_f.position_id%TYPE :=
2917: Wf_Engine.GetItemAttrText (itemtype => ItemType,
2918: itemkey => ItemKey,
2919: aname => 'CURRENT_POSITION_ID');
2920:

Line 2921: l_business_group_id hr_all_positions_f.business_group_id%TYPE :=

2917: Wf_Engine.GetItemAttrText (itemtype => ItemType,
2918: itemkey => ItemKey,
2919: aname => 'CURRENT_POSITION_ID');
2920:
2921: l_business_group_id hr_all_positions_f.business_group_id%TYPE :=
2922: Wf_Engine.GetItemAttrText (itemtype => ItemType,
2923: itemkey => ItemKey,
2924: aname => 'BUSINESS_GROUP_ID');
2925:

Line 2926: l_organization_id hr_all_positions_f.organization_id%TYPE :=

2922: Wf_Engine.GetItemAttrText (itemtype => ItemType,
2923: itemkey => ItemKey,
2924: aname => 'BUSINESS_GROUP_ID');
2925:
2926: l_organization_id hr_all_positions_f.organization_id%TYPE :=
2927: Wf_Engine.GetItemAttrText (itemtype => ItemType,
2928: itemkey => ItemKey,
2929: aname => 'ORGANIZATION_ID');
2930:

Line 2954: p_business_group_id hr_all_positions_f.business_group_id%TYPE) IS

2950:
2951: -- Cursor to FETCH current version of position hierarchy
2952: CURSOR c_pos_hier_ver
2953: (p_hierarchy_id igi_dos_doc_types.hierarchy_id%TYPE,
2954: p_business_group_id hr_all_positions_f.business_group_id%TYPE) IS
2955: SELECT pos_structure_version_id
2956: FROM per_pos_structure_versions
2957: WHERE position_structure_id = p_hierarchy_id
2958: AND SYSDATE BETWEEN date_FROM AND NVL(date_to, SYSDATE)

Line 2970: hr_all_positions_f.business_group_id%TYPE,

2966:
2967: -- Cursor to FETCH current version of position hierarchy
2968: CURSOR c_is_pos_in_hier
2969: (p_business_group_id
2970: hr_all_positions_f.business_group_id%TYPE,
2971: p_pos_structure_ver_id
2972: per_pos_structure_elements.pos_structure_version_id%TYPE,
2973: p_position_id per_all_positions.position_id%TYPE) IS
2974: SELECT pos_structure_element_id