APPS.IGI_EXP_APPROVAL_PKG dependencies on IGI_EXP_APPRV_PROFILES

Line 1403: l_pos_hierarchy_id igi_exp_apprv_profiles.pos_hierarchy_id%TYPE;

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;
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;

Line 1404: l_legal_num_pos_id igi_exp_apprv_profiles.legal_num_pos_id%TYPE;

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;
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;

Line 1405: l_final_apprv_pos_id igi_exp_apprv_profiles.final_apprv_pos_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;
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:

Line 1517: FROM igi_exp_apprv_profiles

1513: ,final_apprv_pos_id
1514: INTO l_pos_hierarchy_id
1515: ,l_legal_num_pos_id
1516: ,l_final_apprv_pos_id
1517: FROM igi_exp_apprv_profiles
1518: WHERE apprv_profile_id = l_apprv_profile_id;
1519:
1520: -- =============== START DEBUG LOG ================
1521: DEBUG_LOG_STRING (l_proc_level, 'Position_in_hierarchy.Msg6',

Line 1783: l_final_apprv_pos_id igi_exp_apprv_profiles.final_apprv_pos_id%TYPE;

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

Line 5118: l_legal_num_pos_id igi_exp_apprv_profiles.legal_num_pos_id%TYPE;

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

Line 5729: l_final_apprv_pos_id igi_exp_apprv_profiles.final_apprv_pos_id%TYPE;

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

Line 7869: l_final_apprv_pos_id igi_exp_apprv_profiles.final_apprv_pos_id%TYPE;

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:
7873: -- =============== START DEBUG LOG ================