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_GB_PENSION_SCHEME_TEMPLATE dependencies on FND_NUMBER

Line 3108: ,p_eei_information2 => fnd_number.number_to_canonical (

3104: p_element_type_id => l_base_element_type_id
3105: ,p_information_type => 'PQP_GB_PENSION_SCHEME_INFO'
3106: ,p_eei_information_category => 'PQP_GB_PENSION_SCHEME_INFO'
3107: ,p_eei_information1 => p_pension_scheme_name -- pension scheme name
3108: ,p_eei_information2 => fnd_number.number_to_canonical (
3109: p_pension_provider_id
3110: ) -- pension provider
3111: ,p_eei_information3 => fnd_number.number_to_canonical (
3112: p_pension_type_id

Line 3111: ,p_eei_information3 => fnd_number.number_to_canonical (

3107: ,p_eei_information1 => p_pension_scheme_name -- pension scheme name
3108: ,p_eei_information2 => fnd_number.number_to_canonical (
3109: p_pension_provider_id
3110: ) -- pension provider
3111: ,p_eei_information3 => fnd_number.number_to_canonical (
3112: p_pension_type_id
3113: ) -- pension type
3114: ,p_eei_information4 => p_pension_category -- pension category
3115: ,p_eei_information5 => fnd_date.date_to_canonical (

Line 3128: ,p_eei_information16 => fnd_number.number_to_canonical (

3124: ,p_eei_information12 => NULL -- Base pension scheme
3125: ,p_eei_information13 => p_additional_contribution -- Additional Contributions
3126: ,p_eei_information14 => p_added_years -- Added Years
3127: ,p_eei_information15 => p_family_widower -- Family or Widower Benefit
3128: ,p_eei_information16 => fnd_number.number_to_canonical (
3129: p_associated_ocp_ele_id
3130: ) -- Associated OCP Scheme
3131: ,p_eei_information17 => fnd_number.number_to_canonical (
3132: l_pensionable_sal_bal_id

Line 3131: ,p_eei_information17 => fnd_number.number_to_canonical (

3127: ,p_eei_information15 => p_family_widower -- Family or Widower Benefit
3128: ,p_eei_information16 => fnd_number.number_to_canonical (
3129: p_associated_ocp_ele_id
3130: ) -- Associated OCP Scheme
3131: ,p_eei_information17 => fnd_number.number_to_canonical (
3132: l_pensionable_sal_bal_id
3133: ) -- Pensionable Salary Balance
3134: ,p_eei_information18 => p_ele_base_name -- Scheme Prefix
3135: ,p_eei_information19 => p_econ_number -- ECON ( BUG 4108320 )

Line 3234: ,p_eei_information2 => fnd_number.number_to_canonical (

3230: p_element_type_id => l_eei_element_type_id
3231: ,p_information_type => 'PQP_GB_PENSION_SCHEME_INFO'
3232: ,p_eei_information_category => 'PQP_GB_PENSION_SCHEME_INFO'
3233: ,p_eei_information1 => p_pension_scheme_name -- pension scheme name
3234: ,p_eei_information2 => fnd_number.number_to_canonical (
3235: p_pension_provider_id
3236: ) -- pension provider
3237: ,p_eei_information3 => fnd_number.number_to_canonical (
3238: p_pension_type_id

Line 3237: ,p_eei_information3 => fnd_number.number_to_canonical (

3233: ,p_eei_information1 => p_pension_scheme_name -- pension scheme name
3234: ,p_eei_information2 => fnd_number.number_to_canonical (
3235: p_pension_provider_id
3236: ) -- pension provider
3237: ,p_eei_information3 => fnd_number.number_to_canonical (
3238: p_pension_type_id
3239: ) -- pension type
3240: ,p_eei_information4 => p_pension_category -- pension category
3241: ,p_eei_information5 => fnd_date.date_to_canonical (

Line 3249: ,p_eei_information12 => fnd_number.number_to_canonical (

3245: ,p_eei_information7 => p_eer_deduction_method -- employer deduction method
3246: ,p_eei_information9 => p_scon_number -- SCON
3247: ,p_eei_information10 => p_scheme_reference_no -- Scheme Number
3248: ,p_eei_information11 => p_employer_reference_no -- Employer Reference Number
3249: ,p_eei_information12 => fnd_number.number_to_canonical (
3250: l_base_element_type_id
3251: ) -- Base pension scheme
3252: ,p_eei_information16 => fnd_number.number_to_canonical (
3253: p_associated_ocp_ele_id

Line 3252: ,p_eei_information16 => fnd_number.number_to_canonical (

3248: ,p_eei_information11 => p_employer_reference_no -- Employer Reference Number
3249: ,p_eei_information12 => fnd_number.number_to_canonical (
3250: l_base_element_type_id
3251: ) -- Base pension scheme
3252: ,p_eei_information16 => fnd_number.number_to_canonical (
3253: p_associated_ocp_ele_id
3254: ) -- Associated OCP Scheme
3255: ,p_eei_information17 => fnd_number.number_to_canonical (
3256: l_pensionable_sal_bal_id

Line 3255: ,p_eei_information17 => fnd_number.number_to_canonical (

3251: ) -- Base pension scheme
3252: ,p_eei_information16 => fnd_number.number_to_canonical (
3253: p_associated_ocp_ele_id
3254: ) -- Associated OCP Scheme
3255: ,p_eei_information17 => fnd_number.number_to_canonical (
3256: l_pensionable_sal_bal_id
3257: ) -- Pensionable Salary Balance
3258: ,p_eei_information18 => p_ele_base_name -- Scheme Prefix
3259: ,p_eei_information19 => p_econ_number -- ECON ( BUG 4108320 )

Line 3261: ,p_eei_information21 => fnd_number.number_to_canonical (

3257: ) -- Pensionable Salary Balance
3258: ,p_eei_information18 => p_ele_base_name -- Scheme Prefix
3259: ,p_eei_information19 => p_econ_number -- ECON ( BUG 4108320 )
3260: ,p_eei_information20 => p_fwc_added_years -- Family Widower Added Years
3261: ,p_eei_information21 => fnd_number.number_to_canonical (
3262: l_base_fwc_element_type_id
3263: ) -- Family Widower base element type_id :5128634
3264: ,p_eei_information22 => fnd_number.number_to_canonical (
3265: l_base_fwc_element_type_id_fix

Line 3264: ,p_eei_information22 => fnd_number.number_to_canonical (

3260: ,p_eei_information20 => p_fwc_added_years -- Family Widower Added Years
3261: ,p_eei_information21 => fnd_number.number_to_canonical (
3262: l_base_fwc_element_type_id
3263: ) -- Family Widower base element type_id :5128634
3264: ,p_eei_information22 => fnd_number.number_to_canonical (
3265: l_base_fwc_element_type_id_fix
3266: ) -- Family Widower base element type_id :5128634
3267:
3268: ,p_element_type_extra_info_id => l_eei_info_id

Line 3404: SELECT fnd_number.canonical_to_number (eei_information17)

3400:
3401: -- Cursor to get pensionable salary balance information
3402: CURSOR csr_get_pens_bal_id (c_element_type_id NUMBER)
3403: IS
3404: SELECT fnd_number.canonical_to_number (eei_information17)
3405: FROM pay_element_type_extra_info
3406: WHERE element_type_id = c_element_type_id
3407: AND information_type = 'PQP_GB_PENSION_SCHEME_INFO';
3408: