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_ALL_POSITIONS

Line 1401: l_position_id per_all_positions.position_id%TYPE;

1397: funcmode IN VARCHAR2,
1398: result OUT NOCOPY VARCHAR2) IS
1399:
1400: l_tu_id igi_exp_tus.tu_id%TYPE;
1401: l_position_id per_all_positions.position_id%TYPE;
1402: l_apprv_profile_id igi_exp_tus.apprv_profile_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;

Line 1434: ,p_position_id per_all_positions.position_id%TYPE)

1430: -- version of the position hierarchy
1431: --
1432: CURSOR c_is_pos_subord(p_pos_structure_ver_id per_pos_structure_elements.pos_structure_version_id%TYPE
1433: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE
1434: ,p_position_id per_all_positions.position_id%TYPE)
1435: IS
1436: SELECT pos_structure_element_id
1437: FROM per_pos_structure_elements
1438: WHERE pos_structure_version_id = p_pos_structure_ver_id

Line 1448: ,p_position_id per_all_positions.position_id%TYPE)

1444: -- version of the position hierarchy
1445: --
1446: CURSOR c_is_pos_parent(p_pos_structure_ver_id per_pos_structure_elements.pos_structure_version_id%TYPE
1447: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE
1448: ,p_position_id per_all_positions.position_id%TYPE)
1449: IS
1450: SELECT pos_structure_element_id
1451: FROM per_pos_structure_elements
1452: WHERE pos_structure_version_id = p_pos_structure_ver_id

Line 1770: CURSOR c_get_parent_position(p_position_id per_all_positions.position_id%TYPE

1766: actid IN NUMBER,
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

Line 1780: l_position_id per_all_positions.position_id%TYPE;

1776: WHERE pos_structure_version_id = p_pos_structure_version_id
1777: AND business_group_id = p_business_group_id
1778: AND subordinate_position_id = p_position_id;
1779:
1780: l_position_id per_all_positions.position_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;

Line 1781: l_transmitter_position_id per_all_positions.position_id%TYPE;

1777: AND business_group_id = p_business_group_id
1778: AND subordinate_position_id = p_position_id;
1779:
1780: l_position_id per_all_positions.position_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;

Line 1782: l_parent_pos_id per_all_positions.position_id%TYPE;

1778: AND subordinate_position_id = p_position_id;
1779:
1780: l_position_id per_all_positions.position_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';

Line 2168: l_current_position_id per_all_positions.position_id%TYPE;

2164: l_user_list VARCHAR2(1000);
2165: l_user_name fnd_user.user_name%TYPE;
2166: l_user_id fnd_user.user_id%TYPE;
2167: l_tu_id igi_exp_tus.tu_id%TYPE;
2168: l_current_position_id per_all_positions.position_id%TYPE;
2169: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
2170: l_organization_id hr_all_positions_f.organization_id%TYPE;
2171:
2172: CURSOR c_user_list(p_position_id hr_all_positions_f.position_id%TYPE

Line 2438: l_current_position_id per_all_positions.position_id%TYPE;

2434:
2435: l_nid NUMBER; -- notification id
2436: l_user_or_pos VARCHAR2(30);
2437: l_picked_authorizer VARCHAR2(240);
2438: l_current_position_id per_all_positions.position_id%TYPE;
2439: l_role_name VARCHAR2(240);
2440:
2441: e_wrong_user EXCEPTION;
2442:

Line 2575: l_current_position_id per_all_positions.position_id%TYPE;

2571: actid IN NUMBER,
2572: funcmode IN VARCHAR2,
2573: result OUT NOCOPY VARCHAR2) IS
2574:
2575: l_current_position_id per_all_positions.position_id%TYPE;
2576: l_current_auth_role VARCHAR2(240);
2577: l_tu_id igi_exp_tus.tu_id%TYPE;
2578:
2579: BEGIN

Line 3181: CURSOR c_get_subord_pos(p_position_id per_all_positions.position_id%TYPE

3177: actid IN NUMBER,
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

Line 5119: l_current_pos_id per_all_positions.position_id%TYPE;

5115: funcmode IN VARCHAR2,
5116: result OUT NOCOPY VARCHAR2) IS
5117:
5118: l_legal_num_pos_id igi_exp_apprv_profiles.legal_num_pos_id%TYPE;
5119: l_current_pos_id per_all_positions.position_id%TYPE;
5120:
5121: BEGIN
5122:
5123: -- =============== START DEBUG LOG ================

Line 5716: CURSOR c_get_parent_position(p_position_id per_all_positions.position_id%TYPE

5712: actid IN NUMBER,
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

Line 5726: l_position_id per_all_positions.position_id%TYPE;

5722: WHERE pos_structure_version_id = p_pos_structure_version_id
5723: AND business_group_id = p_business_group_id
5724: AND subordinate_position_id = p_position_id;
5725:
5726: l_position_id per_all_positions.position_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;

Line 5727: l_parent_pos_id per_all_positions.position_id%TYPE;

5723: AND business_group_id = p_business_group_id
5724: AND subordinate_position_id = p_position_id;
5725:
5726: l_position_id per_all_positions.position_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;

Line 5728: l_parent_pos_name per_all_positions.name%TYPE;

5724: AND subordinate_position_id = p_position_id;
5725:
5726: l_position_id per_all_positions.position_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:

Line 7868: l_transmitter_position_id per_all_positions.position_id%TYPE;

7864: actid IN NUMBER,
7865: funcmode IN VARCHAR2,
7866: result OUT NOCOPY VARCHAR2) IS
7867:
7868: l_transmitter_position_id per_all_positions.position_id%TYPE;
7869: l_final_apprv_pos_id igi_exp_apprv_profiles.final_apprv_pos_id%TYPE;
7870:
7871: BEGIN
7872: