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 5126: l_current_pos_id per_all_positions.position_id%TYPE;

5122: funcmode IN VARCHAR2,
5123: result OUT NOCOPY VARCHAR2) IS
5124:
5125: l_legal_num_pos_id igi_exp_apprv_profiles.legal_num_pos_id%TYPE;
5126: l_current_pos_id per_all_positions.position_id%TYPE;
5127:
5128: BEGIN
5129:
5130: -- =============== START DEBUG LOG ================

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

5719: actid IN NUMBER,
5720: funcmode IN VARCHAR2,
5721: result OUT NOCOPY VARCHAR2) IS
5722:
5723: CURSOR c_get_parent_position(p_position_id per_all_positions.position_id%TYPE
5724: ,p_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE
5725: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE)
5726: IS
5727: SELECT parent_position_id

Line 5733: l_position_id per_all_positions.position_id%TYPE;

5729: WHERE pos_structure_version_id = p_pos_structure_version_id
5730: AND business_group_id = p_business_group_id
5731: AND subordinate_position_id = p_position_id;
5732:
5733: l_position_id per_all_positions.position_id%TYPE;
5734: l_parent_pos_id per_all_positions.position_id%TYPE;
5735: l_parent_pos_name per_all_positions.name%TYPE;
5736: l_final_apprv_pos_id igi_exp_apprv_profiles.final_apprv_pos_id%TYPE;
5737: l_business_group_id hr_all_positions_f.business_group_id%TYPE;

Line 5734: l_parent_pos_id per_all_positions.position_id%TYPE;

5730: AND business_group_id = p_business_group_id
5731: AND subordinate_position_id = p_position_id;
5732:
5733: l_position_id per_all_positions.position_id%TYPE;
5734: l_parent_pos_id per_all_positions.position_id%TYPE;
5735: l_parent_pos_name per_all_positions.name%TYPE;
5736: l_final_apprv_pos_id igi_exp_apprv_profiles.final_apprv_pos_id%TYPE;
5737: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
5738: l_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;

Line 5735: l_parent_pos_name per_all_positions.name%TYPE;

5731: AND subordinate_position_id = p_position_id;
5732:
5733: l_position_id per_all_positions.position_id%TYPE;
5734: l_parent_pos_id per_all_positions.position_id%TYPE;
5735: l_parent_pos_name per_all_positions.name%TYPE;
5736: l_final_apprv_pos_id igi_exp_apprv_profiles.final_apprv_pos_id%TYPE;
5737: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
5738: l_pos_structure_version_id per_pos_structure_versions.pos_structure_version_id%TYPE;
5739:

Line 7871: l_transmitter_position_id per_all_positions.position_id%TYPE;

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