APPS.IGIDOSL dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 661: l_pos_struct_element_id per_pos_structure_elements.pos_structure_element_id%TYPE

657: := Wf_Engine.GetItemAttrText (itemtype => itemtype,
658: itemkey => itemkey,
659: aname => 'INITIAL_ENTRY_FLAG');
660:
661: l_pos_struct_element_id per_pos_structure_elements.pos_structure_element_id%TYPE
662: := Wf_Engine.GetItemAttrNumber (itemtype => itemtype,
663: itemkey => itemkey,
664: aname => 'POS_STRUCTURE_ELEMENT_ID');
665:

Line 675: l_structure_element_id per_pos_structure_elements.pos_structure_element_id%TYPE ;

671: l_picked_role wf_notifications.responder%TYPE;
672: l_error VARCHAR2(1000) ;
673: l_position_structure_id per_position_structures.position_structure_id%TYPE ;
674: l_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE ;
675: l_structure_element_id per_pos_structure_elements.pos_structure_element_id%TYPE ;
676: l_parent_position_id per_positions.position_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;

Line 766: (p_pos_structure_ver_id per_pos_structure_elements.pos_structure_version_id%TYPE,

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

Line 770: FROM per_pos_structure_elements ppse

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
772: AND business_group_id = p_business_group_id
773: AND ppse.parent_position_id NOT IN
774: (SELECT subordinate_position_id

Line 775: FROM per_pos_structure_elements

771: WHERE ppse.pos_structure_version_id = p_pos_structure_ver_id
772: AND business_group_id = p_business_group_id
773: AND ppse.parent_position_id NOT IN
774: (SELECT subordinate_position_id
775: FROM per_pos_structure_elements
776: WHERE pos_structure_version_id = p_pos_structure_ver_id
777: AND business_group_id = p_business_group_id);
778:
779: /****************************/

Line 789: FROM per_pos_structure_elements

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
791: AND business_group_id = p_business_group_id
792: AND subordinate_position_id = p_position_id;
793:

Line 3077: per_pos_structure_elements.pos_structure_element_id%TYPE;

3073: per_position_structures.position_structure_id%TYPE;
3074: l_hierarchy_version_id
3075: per_pos_structure_versions.pos_structure_version_id%TYPE;
3076: l_pos_structure_element_id
3077: per_pos_structure_elements.pos_structure_element_id%TYPE;
3078:
3079: -- Cursor to FETCH position hierarchy
3080: CURSOR c_pos_hier (p_dossier_id igi_dos_doc_types.dossier_id%TYPE) IS
3081: SELECT hierarchy_id

Line 3106: per_pos_structure_elements.pos_structure_version_id%TYPE,

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
3109: FROM per_pos_structure_elements
3110: WHERE pos_structure_version_id = p_pos_structure_ver_id

Line 3109: FROM per_pos_structure_elements

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
3109: FROM per_pos_structure_elements
3110: WHERE pos_structure_version_id = p_pos_structure_ver_id
3111: AND business_group_id = p_business_group_id
3112: AND (subordinate_position_id = p_position_id OR
3113: parent_position_id = p_position_id);