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 HR_ALL_POSITIONS_F

Line 1217: FROM hr_all_positions_f hap,

1213: SELECT hap.position_id,
1214: hap.name,
1215: hap.business_group_id,
1216: hap.organization_id
1217: FROM hr_all_positions_f hap,
1218: per_all_assignments_f paa,
1219: per_employees_current_x pec
1220: WHERE pec.employee_id = p_emp_id
1221: AND NVL(pec.inactive_date,SYSDATE) >= SYSDATE

Line 1236: l_position_id hr_all_positions_f.position_id%TYPE;

1232: AND hap.date_effective <= SYSDATE
1233: AND NVL(hap.date_end, SYSDATE) >= SYSDATE
1234: AND NVL(UPPER(hap.status), 'VALID') NOT IN ('INVALID');
1235:
1236: l_position_id hr_all_positions_f.position_id%TYPE;
1237: l_position_name hr_all_positions_f.name%TYPE;
1238: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
1239: l_organization_id hr_all_positions_f.organization_id%TYPE;
1240: l_transmitter_emp_id per_employees_current_x.employee_id%TYPE;

Line 1237: l_position_name hr_all_positions_f.name%TYPE;

1233: AND NVL(hap.date_end, SYSDATE) >= SYSDATE
1234: AND NVL(UPPER(hap.status), 'VALID') NOT IN ('INVALID');
1235:
1236: l_position_id hr_all_positions_f.position_id%TYPE;
1237: l_position_name hr_all_positions_f.name%TYPE;
1238: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
1239: l_organization_id hr_all_positions_f.organization_id%TYPE;
1240: l_transmitter_emp_id per_employees_current_x.employee_id%TYPE;
1241:

Line 1238: l_business_group_id hr_all_positions_f.business_group_id%TYPE;

1234: AND NVL(UPPER(hap.status), 'VALID') NOT IN ('INVALID');
1235:
1236: l_position_id hr_all_positions_f.position_id%TYPE;
1237: l_position_name hr_all_positions_f.name%TYPE;
1238: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
1239: l_organization_id hr_all_positions_f.organization_id%TYPE;
1240: l_transmitter_emp_id per_employees_current_x.employee_id%TYPE;
1241:
1242: BEGIN

Line 1239: l_organization_id hr_all_positions_f.organization_id%TYPE;

1235:
1236: l_position_id hr_all_positions_f.position_id%TYPE;
1237: l_position_name hr_all_positions_f.name%TYPE;
1238: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
1239: l_organization_id hr_all_positions_f.organization_id%TYPE;
1240: l_transmitter_emp_id per_employees_current_x.employee_id%TYPE;
1241:
1242: BEGIN
1243:

Line 1406: l_business_group_id hr_all_positions_f.business_group_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;
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: --

Line 1414: p_business_group_id hr_all_positions_f.business_group_id%TYPE)

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
1418: WHERE position_structure_id = p_hierarchy_id

Line 1433: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE

1429: -- Find out NOCOPY if the position exists as a subordinate position in the current
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

Line 1447: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE

1443: -- Find out NOCOPY if the position exists as a parent position in the current
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

Line 1772: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE)

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
1776: WHERE pos_structure_version_id = p_pos_structure_version_id

Line 1784: l_business_group_id hr_all_positions_f.business_group_id%TYPE;

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';
1787:
1788: BEGIN

Line 2169: l_business_group_id hr_all_positions_f.business_group_id%TYPE;

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
2173: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE

Line 2170: l_organization_id hr_all_positions_f.organization_id%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
2173: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE
2174: ,p_organization_id hr_all_positions_f.organization_id%TYPE)

Line 2172: CURSOR c_user_list(p_position_id hr_all_positions_f.position_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
2173: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE
2174: ,p_organization_id hr_all_positions_f.organization_id%TYPE)
2175: IS
2176: SELECT fu.user_name

Line 2173: ,p_business_group_id hr_all_positions_f.business_group_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
2173: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE
2174: ,p_organization_id hr_all_positions_f.organization_id%TYPE)
2175: IS
2176: SELECT fu.user_name
2177: FROM hr_all_positions_f hap,

Line 2174: ,p_organization_id hr_all_positions_f.organization_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
2173: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE
2174: ,p_organization_id hr_all_positions_f.organization_id%TYPE)
2175: IS
2176: SELECT fu.user_name
2177: FROM hr_all_positions_f hap,
2178: per_all_assignments_f paa,

Line 2177: FROM hr_all_positions_f hap,

2173: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE
2174: ,p_organization_id hr_all_positions_f.organization_id%TYPE)
2175: IS
2176: SELECT fu.user_name
2177: FROM hr_all_positions_f hap,
2178: per_all_assignments_f paa,
2179: per_employees_current_x pec,
2180: fnd_user fu
2181: WHERE fu.start_date <= SYSDATE

Line 2794: l_current_position_id hr_all_positions_f.position_id%TYPE;

2790: WHERE position_id = p_position_id;
2791:
2792: l_authorizer_history_list VARCHAR2(1000);
2793: l_num NUMBER;
2794: l_current_position_id hr_all_positions_f.position_id%TYPE;
2795: l_return_allowed VARCHAR2(1);
2796:
2797: BEGIN
2798:

Line 3183: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE)

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
3187: WHERE pos_structure_version_id = p_pos_structure_version_id

Line 3191: l_current_position_id hr_all_positions_f.position_id%TYPE;

3187: WHERE pos_structure_version_id = p_pos_structure_version_id
3188: AND business_group_id = p_business_group_id
3189: AND parent_position_id = p_position_id;
3190:
3191: l_current_position_id hr_all_positions_f.position_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;

Line 3192: l_subord_position_id hr_all_positions_f.position_id%TYPE;

3188: AND business_group_id = p_business_group_id
3189: AND parent_position_id = p_position_id;
3190:
3191: l_current_position_id hr_all_positions_f.position_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;

Line 3193: l_subord_position_name hr_all_positions_f.name%TYPE;

3189: AND parent_position_id = p_position_id;
3190:
3191: l_current_position_id hr_all_positions_f.position_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;

Line 3194: l_transmitter_position_id hr_all_positions_f.position_id%TYPE;

3190:
3191: l_current_position_id hr_all_positions_f.position_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:

Line 3195: l_business_group_id hr_all_positions_f.business_group_id%TYPE;

3191: l_current_position_id hr_all_positions_f.position_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;

Line 3197: l_organization_id hr_all_positions_f.organization_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:
3201: BEGIN

Line 3310: FROM hr_all_positions_f

3306:
3307: -- Get the name of the subordinate position
3308: SELECT name
3309: INTO l_subord_position_name
3310: FROM hr_all_positions_f
3311: WHERE position_id = l_subord_position_id
3312: AND business_group_id = l_business_group_id
3313: AND organization_id = l_organization_id;
3314:

Line 5718: ,p_business_group_id hr_all_positions_f.business_group_id%TYPE)

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
5722: WHERE pos_structure_version_id = p_pos_structure_version_id

Line 5730: l_business_group_id hr_all_positions_f.business_group_id%TYPE;

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:
5733: BEGIN
5734:

Line 5836: FROM hr_all_positions_f

5832:
5833: -- Get the position name
5834: SELECT name
5835: INTO l_parent_pos_name
5836: FROM hr_all_positions_f
5837: WHERE position_id = l_parent_pos_id;
5838:
5839: -- =============== START DEBUG LOG ================
5840: DEBUG_LOG_STRING (l_proc_level, 'Get_parent_position.Msg10',