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.IGI_EXP_APPROVAL_PKG dependencies on PER_POS_STRUCTURE_VERSIONS

Line 1407: l_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;

1403: l_pos_hierarchy_id igi_exp_apprv_profiles.pos_hierarchy_id%TYPE;
1404: l_legal_num_pos_id igi_exp_apprv_profiles.legal_num_pos_id%TYPE;
1405: l_final_apprv_pos_id igi_exp_apprv_profiles.final_apprv_pos_id%TYPE;
1406: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
1407: l_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;
1408: l_pos_structure_element_id per_pos_structure_elements.pos_structure_element_id%TYPE;
1409:
1410: --
1411: -- Find the current version of the position hierarchy

Line 1413: CURSOR c_get_pos_hier_ver(p_hierarchy_id per_pos_structure_versions.position_structure_id%TYPE,

1409:
1410: --
1411: -- Find the current version of the position hierarchy
1412: --
1413: CURSOR c_get_pos_hier_ver(p_hierarchy_id per_pos_structure_versions.position_structure_id%TYPE,
1414: p_business_group_id hr_all_positions_f.business_group_id%TYPE)
1415: IS
1416: SELECT pos_structure_version_id
1417: FROM per_pos_structure_versions

Line 1417: FROM per_pos_structure_versions

1413: CURSOR c_get_pos_hier_ver(p_hierarchy_id per_pos_structure_versions.position_structure_id%TYPE,
1414: p_business_group_id hr_all_positions_f.business_group_id%TYPE)
1415: IS
1416: SELECT pos_structure_version_id
1417: FROM per_pos_structure_versions
1418: WHERE position_structure_id = p_hierarchy_id
1419: AND sysdate BETWEEN date_from AND NVL(date_to, sysdate)
1420: AND business_group_id = p_business_group_id
1421: AND version_number =

Line 1423: FROM per_pos_structure_versions

1419: AND sysdate BETWEEN date_from AND NVL(date_to, sysdate)
1420: AND business_group_id = p_business_group_id
1421: AND version_number =
1422: (SELECT MAX(version_number)
1423: FROM per_pos_structure_versions
1424: WHERE position_structure_id = p_hierarchy_id
1425: AND sysdate BETWEEN date_from AND NVL(date_to,sysdate)
1426: AND business_group_id = p_business_group_id);
1427:

Line 1771: ,p_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE

1767: funcmode IN VARCHAR2,
1768: result OUT NOCOPY VARCHAR2) IS
1769:
1770: CURSOR c_get_parent_position(p_position_id per_all_positions.position_id%TYPE
1771: ,p_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE
1772: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE)
1773: IS
1774: SELECT parent_position_id
1775: FROM per_pos_structure_elements

Line 1785: l_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;

1781: l_transmitter_position_id per_all_positions.position_id%TYPE;
1782: l_parent_pos_id per_all_positions.position_id%TYPE;
1783: l_final_apprv_pos_id igi_exp_apprv_profiles.final_apprv_pos_id%TYPE;
1784: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
1785: l_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;
1786: l_final_apprv_found VARCHAR2(1) := 'N';
1787:
1788: BEGIN
1789:

Line 3182: ,p_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE

3178: funcmode IN VARCHAR2,
3179: result OUT NOCOPY VARCHAR2) IS
3180:
3181: CURSOR c_get_subord_pos(p_position_id per_all_positions.position_id%TYPE
3182: ,p_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE
3183: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE)
3184: IS
3185: SELECT subordinate_position_id
3186: FROM per_pos_structure_elements

Line 3196: l_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;

3192: l_subord_position_id hr_all_positions_f.position_id%TYPE;
3193: l_subord_position_name hr_all_positions_f.name%TYPE;
3194: l_transmitter_position_id hr_all_positions_f.position_id%TYPE;
3195: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
3196: l_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;
3197: l_organization_id hr_all_positions_f.organization_id%TYPE;
3198:
3199: e_no_subord_pos EXCEPTION;
3200:

Line 5717: ,p_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE

5713: funcmode IN VARCHAR2,
5714: result OUT NOCOPY VARCHAR2) IS
5715:
5716: CURSOR c_get_parent_position(p_position_id per_all_positions.position_id%TYPE
5717: ,p_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE
5718: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE)
5719: IS
5720: SELECT parent_position_id
5721: FROM per_pos_structure_elements

Line 5731: l_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;

5727: l_parent_pos_id per_all_positions.position_id%TYPE;
5728: l_parent_pos_name per_all_positions.name%TYPE;
5729: l_final_apprv_pos_id igi_exp_apprv_profiles.final_apprv_pos_id%TYPE;
5730: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
5731: l_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;
5732:
5733: BEGIN
5734:
5735: -- =============== START DEBUG LOG ================