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 3106: ,p_eei_information2 => fnd_number.number_to_canonical (

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

Line 3109: ,p_eei_information3 => fnd_number.number_to_canonical (

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

Line 3126: ,p_eei_information16 => fnd_number.number_to_canonical (

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

Line 3129: ,p_eei_information17 => fnd_number.number_to_canonical (

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

Line 3232: ,p_eei_information2 => fnd_number.number_to_canonical (

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

Line 3235: ,p_eei_information3 => fnd_number.number_to_canonical (

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

Line 3247: ,p_eei_information12 => fnd_number.number_to_canonical (

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

Line 3250: ,p_eei_information16 => fnd_number.number_to_canonical (

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

Line 3253: ,p_eei_information17 => fnd_number.number_to_canonical (

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

Line 3259: ,p_eei_information21 => fnd_number.number_to_canonical (

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

Line 3262: ,p_eei_information22 => fnd_number.number_to_canonical (

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

Line 3402: SELECT fnd_number.canonical_to_number (eei_information17)

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