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.PQP_PENSION_EXTRACTS dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 2796: FROM per_assignment_extra_info aei

2792:
2793: CURSOR csr_aei (c_assignment_id IN NUMBER
2794: ,c_information_type IN VARCHAR2) IS
2795: SELECT aei.assignment_extra_info_id
2796: FROM per_assignment_extra_info aei
2797: WHERE aei.assignment_id = c_assignment_id
2798: AND aei.information_type = c_information_type;
2799:
2800: CURSOR csr_asg_mult_occur(c_information_type IN VARCHAR2) IS

Line 2866: |Extra Assignment Information |Assignment Developer DF |PER_ASSIGNMENT_EXTRA_INFO |

2862: /*
2863: +=============================+=========================+============================+
2864: |DDF/DF Title | p_flex_name |TABLE |
2865: +=============================+=========================+============================+
2866: |Extra Assignment Information |Assignment Developer DF |PER_ASSIGNMENT_EXTRA_INFO |
2867: |Assignment Extra Information |PER_ASSIGNMENT_EXTRA_INFO| -DO- |
2868: |Extra Person Information |Extra Person Info DDF |PER_PEOPLE_EXTRA_INFO |
2869: |Extra Person Info. Details |PER_PEOPLE_EXTRA_INFO | -DO- |
2870: |Org Developer DF |Org Developer DF |HR_ORGANIZATION_INFORMATION |

Line 2867: |Assignment Extra Information |PER_ASSIGNMENT_EXTRA_INFO| -DO- |

Line 2927: 'PER_ASSIGNMENT_EXTRA_INFO') THEN

2923: RETURN l_return_value;
2924: END IF;
2925:
2926: ELSIF p_flex_name IN('Assignment Developer DF',
2927: 'PER_ASSIGNMENT_EXTRA_INFO') THEN
2928: Hr_Utility.set_location('..p_flex_name = '||p_flex_name, 7);
2929: OPEN csr_asg_mult_occur(c_information_type => p_flex_context);
2930: FETCH csr_asg_mult_occur INTO l_mult_occur;
2931: CLOSE csr_asg_mult_occur;

Line 2944: l_tab_name := 'PER_ASSIGNMENT_EXTRA_INFO';

2940:
2941: Hr_Utility.set_location('..p_flex_name = '||p_flex_name, 7);
2942: Hr_Utility.set_location('..l_key_val = '||l_key_val, 7);
2943: l_key_col := 'ASSIGNMENT_EXTRA_INFO_ID';
2944: l_tab_name := 'PER_ASSIGNMENT_EXTRA_INFO';
2945: ELSE
2946: p_error_code := '-20001';
2947: p_err_message := 'Contexts :'||p_flex_context ||
2948: ' can have multiple occurances';

Line 3026: ELSIF p_flex_name IN ('PER_ASSIGNMENT_EXTRA_INFO',

3022: l_return_value := l_ddf_seg_value;
3023:
3024: Hr_Utility.set_location('..get_ddf_value ='||l_return_value, 10);
3025:
3026: ELSIF p_flex_name IN ('PER_ASSIGNMENT_EXTRA_INFO',
3027: 'PER_PEOPLE_EXTRA_INFO') THEN
3028: Hr_Utility.set_location('..Calling pqp_utilities.get_df_value', 9);
3029: l_df_seg_value:= Pqp_Utilities.get_df_value
3030: (p_flex_name => p_flex_name

Line 3057: PER_ASSIGNMENT_EXTRA_INFO,

3053: WHEN Invaild_DDF_or_DF THEN
3054: p_error_code := '-20001';
3055: p_err_message := 'Currently Supported DDF/DFs :Assignment Developer DF,'||
3056: 'Extra Person Info DDF,
3057: PER_ASSIGNMENT_EXTRA_INFO,
3058: PER_ASSIGNMENT_EXTRA_INFO';
3059:
3060: l_return_value := 'EXT_ERR_WARNING';
3061: IF csr_pei%ISOPEN THEN CLOSE csr_pei; END IF;

Line 3058: PER_ASSIGNMENT_EXTRA_INFO';

3054: p_error_code := '-20001';
3055: p_err_message := 'Currently Supported DDF/DFs :Assignment Developer DF,'||
3056: 'Extra Person Info DDF,
3057: PER_ASSIGNMENT_EXTRA_INFO,
3058: PER_ASSIGNMENT_EXTRA_INFO';
3059:
3060: l_return_value := 'EXT_ERR_WARNING';
3061: IF csr_pei%ISOPEN THEN CLOSE csr_pei; END IF;
3062: IF csr_aei%ISOPEN THEN CLOSE csr_aei; END IF;