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 681: l_business_group_id hr_all_positions_f.business_group_id%TYPE;

677: l_position_id per_all_positions.position_id%TYPE;
678: l_top_position_id per_all_positions.position_id%TYPE ;
679: l_hierarchy_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;
680: l_hierarchy_id per_position_structures.position_structure_id%TYPE;
681: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
682: l_organization_id hr_all_positions_f.organization_id%TYPE;
683: l_current_user_name fnd_user.user_name%TYPE;
684:
685: cur_pos_not_found EXCEPTION ;

Line 682: l_organization_id hr_all_positions_f.organization_id%TYPE;

678: l_top_position_id per_all_positions.position_id%TYPE ;
679: l_hierarchy_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;
680: l_hierarchy_id per_position_structures.position_structure_id%TYPE;
681: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
682: l_organization_id hr_all_positions_f.organization_id%TYPE;
683: l_current_user_name fnd_user.user_name%TYPE;
684:
685: cur_pos_not_found EXCEPTION ;
686: pos_hier_not_found EXCEPTION ;

Line 701: FROM hr_all_positions_f hap,

697: SELECT hap.position_id,
698: hap.business_group_id,
699: hap.organization_id,
700: fu.user_name
701: FROM hr_all_positions_f hap,
702: per_all_assignments_f paa,
703: fnd_user fu ,
704: per_people_f p,
705: per_periods_of_service b

Line 747: p_business_group_id hr_all_positions_f.business_group_id%TYPE)

743: /* FETCH current version of position hierarchy */
744: /***********************************************/
745:
746: CURSOR c_pos_hier_ver(p_hierarchy_id igi_dos_doc_types.hierarchy_id%TYPE,
747: p_business_group_id hr_all_positions_f.business_group_id%TYPE)
748: IS
749: SELECT pos_structure_version_id
750: FROM per_pos_structure_versions
751: WHERE position_structure_id = p_hierarchy_id

Line 767: p_business_group_id hr_all_positions_f.business_group_id%TYPE)

763: /***********************************/
764:
765: CURSOR c_get_top_position
766: (p_pos_structure_ver_id per_pos_structure_elements.pos_structure_version_id%TYPE,
767: p_business_group_id hr_all_positions_f.business_group_id%TYPE)
768: IS
769: SELECT ppse.parent_position_id
770: FROM per_pos_structure_elements ppse
771: WHERE ppse.pos_structure_version_id = p_pos_structure_ver_id

Line 786: p_business_group_id hr_all_positions_f.business_group_id%TYPE)

782:
783: CURSOR c_par_pos_id
784: (p_hier_ver_id per_pos_structure_versions.pos_structure_version_id%TYPE,
785: p_position_id per_all_positions.position_id%TYPE,
786: p_business_group_id hr_all_positions_f.business_group_id%TYPE)
787: IS
788: SELECT parent_position_id
789: FROM per_pos_structure_elements
790: WHERE pos_structure_version_id = p_hier_ver_id

Line 1780: l_business_group_id hr_all_positions_f.business_group_id%TYPE

1776: := Wf_Engine.GetItemAttrText (itemtype => ItemType,
1777: itemkey => ItemKey,
1778: aname => 'PARENT_POSITION_ID');
1779:
1780: l_business_group_id hr_all_positions_f.business_group_id%TYPE
1781: := Wf_Engine.GetItemAttrText( itemtype => itemtype,
1782: itemkey => itemkey,
1783: aname => 'BUSINESS_GROUP_ID');
1784:

Line 1785: l_organization_id hr_all_positions_f.organization_id%TYPE

1781: := Wf_Engine.GetItemAttrText( itemtype => itemtype,
1782: itemkey => itemkey,
1783: aname => 'BUSINESS_GROUP_ID');
1784:
1785: l_organization_id hr_all_positions_f.organization_id%TYPE
1786: := Wf_Engine.GetItemAttrText( itemtype => itemtype,
1787: itemkey => itemkey,
1788: aname => 'ORGANIZATION_ID');
1789:

Line 1793: FROM hr_all_positions_f hap,

1789:
1790: CURSOR c_user_list
1791: IS
1792: select fu.user_name user_name
1793: FROM hr_all_positions_f hap,
1794: per_all_assignments_f paa,
1795: fnd_user fu ,
1796: per_people_f p,
1797: per_periods_of_service b

Line 1955: l_parent_position_id hr_all_positions_f.position_id%TYPE

1951: aname => 'USER_LIST');
1952:
1953: l_next_position per_positions.name%TYPE;
1954:
1955: l_parent_position_id hr_all_positions_f.position_id%TYPE
1956: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1957: itemkey => itemkey,
1958: aname => 'PARENT_POSITION_ID');
1959:

Line 2913: hr_all_positions_f hap,

2909: hap.name,
2910: hap.business_group_id,
2911: hap.organization_id
2912: FROM
2913: hr_all_positions_f hap,
2914: per_all_assignments_f paa,
2915: per_people_f p,
2916: per_periods_of_service b
2917: WHERE

Line 2937: l_position_id hr_all_positions_f.position_id%TYPE;

2933: and NVL(hap.date_end, SYSDATE) >= SYSDATE
2934: and NVL(UPPER(hap.status), 'VALID') NOT IN ('INVALID') ;
2935:
2936:
2937: l_position_id hr_all_positions_f.position_id%TYPE;
2938: l_position_name hr_all_positions_f.name%TYPE;
2939: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
2940: l_organization_id hr_all_positions_f.organization_id%TYPE;
2941:

Line 2938: l_position_name hr_all_positions_f.name%TYPE;

2934: and NVL(UPPER(hap.status), 'VALID') NOT IN ('INVALID') ;
2935:
2936:
2937: l_position_id hr_all_positions_f.position_id%TYPE;
2938: l_position_name hr_all_positions_f.name%TYPE;
2939: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
2940: l_organization_id hr_all_positions_f.organization_id%TYPE;
2941:
2942: l_emp_id NUMBER(15) := Wf_Engine.GetItemAttrText

Line 2939: l_business_group_id hr_all_positions_f.business_group_id%TYPE;

2935:
2936:
2937: l_position_id hr_all_positions_f.position_id%TYPE;
2938: l_position_name hr_all_positions_f.name%TYPE;
2939: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
2940: l_organization_id hr_all_positions_f.organization_id%TYPE;
2941:
2942: l_emp_id NUMBER(15) := Wf_Engine.GetItemAttrText
2943: ( itemtype => itemtype,

Line 2940: l_organization_id hr_all_positions_f.organization_id%TYPE;

2936:
2937: l_position_id hr_all_positions_f.position_id%TYPE;
2938: l_position_name hr_all_positions_f.name%TYPE;
2939: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
2940: l_organization_id hr_all_positions_f.organization_id%TYPE;
2941:
2942: l_emp_id NUMBER(15) := Wf_Engine.GetItemAttrText
2943: ( itemtype => itemtype,
2944: itemkey => itemkey,

Line 3050: l_position_id hr_all_positions_f.position_id%TYPE :=

3046: actid IN NUMBER,
3047: funcmode IN VARCHAR2,
3048: result OUT NOCOPY VARCHAR2 ) IS
3049:
3050: l_position_id hr_all_positions_f.position_id%TYPE :=
3051: Wf_Engine.GetItemAttrText (itemtype => ItemType,
3052: itemkey => ItemKey,
3053: aname => 'CURRENT_POSITION_ID');
3054:

Line 3055: l_business_group_id hr_all_positions_f.business_group_id%TYPE :=

3051: Wf_Engine.GetItemAttrText (itemtype => ItemType,
3052: itemkey => ItemKey,
3053: aname => 'CURRENT_POSITION_ID');
3054:
3055: l_business_group_id hr_all_positions_f.business_group_id%TYPE :=
3056: Wf_Engine.GetItemAttrText (itemtype => ItemType,
3057: itemkey => ItemKey,
3058: aname => 'BUSINESS_GROUP_ID');
3059:

Line 3060: l_organization_id hr_all_positions_f.organization_id%TYPE :=

3056: Wf_Engine.GetItemAttrText (itemtype => ItemType,
3057: itemkey => ItemKey,
3058: aname => 'BUSINESS_GROUP_ID');
3059:
3060: l_organization_id hr_all_positions_f.organization_id%TYPE :=
3061: Wf_Engine.GetItemAttrText (itemtype => ItemType,
3062: itemkey => ItemKey,
3063: aname => 'ORGANIZATION_ID');
3064:

Line 3088: p_business_group_id hr_all_positions_f.business_group_id%TYPE) IS

3084:
3085: -- Cursor to FETCH current version of position hierarchy
3086: CURSOR c_pos_hier_ver
3087: (p_hierarchy_id igi_dos_doc_types.hierarchy_id%TYPE,
3088: p_business_group_id hr_all_positions_f.business_group_id%TYPE) IS
3089: SELECT pos_structure_version_id
3090: FROM per_pos_structure_versions
3091: WHERE position_structure_id = p_hierarchy_id
3092: AND SYSDATE BETWEEN date_FROM AND NVL(date_to, SYSDATE)

Line 3104: hr_all_positions_f.business_group_id%TYPE,

3100:
3101: -- Cursor to FETCH current version of position hierarchy
3102: CURSOR c_is_pos_in_hier
3103: (p_business_group_id
3104: hr_all_positions_f.business_group_id%TYPE,
3105: p_pos_structure_ver_id
3106: per_pos_structure_elements.pos_structure_version_id%TYPE,
3107: p_position_id per_all_positions.position_id%TYPE) IS
3108: SELECT pos_structure_element_id