APPS.IGIDOSL dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 646: l_pos_struct_element_id per_pos_structure_elements.pos_structure_element_id%TYPE

642: := Wf_Engine.GetItemAttrText (itemtype => itemtype,
643: itemkey => itemkey,
644: aname => 'INITIAL_ENTRY_FLAG');
645:
646: l_pos_struct_element_id per_pos_structure_elements.pos_structure_element_id%TYPE
647: := Wf_Engine.GetItemAttrNumber (itemtype => itemtype,
648: itemkey => itemkey,
649: aname => 'POS_STRUCTURE_ELEMENT_ID');
650:

Line 660: l_structure_element_id per_pos_structure_elements.pos_structure_element_id%TYPE ;

656: l_picked_role wf_notifications.responder%TYPE;
657: l_error VARCHAR2(1000) ;
658: l_position_structure_id per_position_structures.position_structure_id%TYPE ;
659: l_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE ;
660: l_structure_element_id per_pos_structure_elements.pos_structure_element_id%TYPE ;
661: l_parent_position_id per_positions.position_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;

Line 751: (p_pos_structure_ver_id per_pos_structure_elements.pos_structure_version_id%TYPE,

747: /* FETCH top position in hierarchy */
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

Line 755: FROM per_pos_structure_elements ppse

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
757: AND business_group_id = p_business_group_id
758: AND ppse.parent_position_id NOT IN
759: (SELECT subordinate_position_id

Line 760: FROM per_pos_structure_elements

756: WHERE ppse.pos_structure_version_id = p_pos_structure_ver_id
757: AND business_group_id = p_business_group_id
758: AND ppse.parent_position_id NOT IN
759: (SELECT subordinate_position_id
760: FROM per_pos_structure_elements
761: WHERE pos_structure_version_id = p_pos_structure_ver_id
762: AND business_group_id = p_business_group_id);
763:
764: /****************************/

Line 774: FROM per_pos_structure_elements

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
776: AND business_group_id = p_business_group_id
777: AND subordinate_position_id = p_position_id;
778:

Line 2943: per_pos_structure_elements.pos_structure_element_id%TYPE;

2939: per_position_structures.position_structure_id%TYPE;
2940: l_hierarchy_version_id
2941: per_pos_structure_versions.pos_structure_version_id%TYPE;
2942: l_pos_structure_element_id
2943: per_pos_structure_elements.pos_structure_element_id%TYPE;
2944:
2945: -- Cursor to FETCH position hierarchy
2946: CURSOR c_pos_hier (p_dossier_id igi_dos_doc_types.dossier_id%TYPE) IS
2947: SELECT hierarchy_id

Line 2972: per_pos_structure_elements.pos_structure_version_id%TYPE,

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
2975: FROM per_pos_structure_elements
2976: WHERE pos_structure_version_id = p_pos_structure_ver_id

Line 2975: FROM per_pos_structure_elements

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
2975: FROM per_pos_structure_elements
2976: WHERE pos_structure_version_id = p_pos_structure_ver_id
2977: AND business_group_id = p_business_group_id
2978: AND (subordinate_position_id = p_position_id OR
2979: parent_position_id = p_position_id);