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.PAY_FR_PTO_PKG dependencies on FND_NUMBER

Line 802: select sum(fnd_number.canonical_to_number(pevm.screen_entry_value))

798: ,p_type_s_iv_id number
799: ,p_type_c_iv_id number
800: ,p_type_y_iv_id number
801: ,p_type_accrual_date_iv_id number ) is
802: select sum(fnd_number.canonical_to_number(pevm.screen_entry_value))
803: ,sum(fnd_number.canonical_to_number(pevp.screen_entry_value))
804: ,sum(fnd_number.canonical_to_number(pevc.screen_entry_value))
805: ,sum(fnd_number.canonical_to_number(pevs.screen_entry_value))
806: ,sum(fnd_number.canonical_to_number(pevy.screen_entry_value))

Line 803: ,sum(fnd_number.canonical_to_number(pevp.screen_entry_value))

799: ,p_type_c_iv_id number
800: ,p_type_y_iv_id number
801: ,p_type_accrual_date_iv_id number ) is
802: select sum(fnd_number.canonical_to_number(pevm.screen_entry_value))
803: ,sum(fnd_number.canonical_to_number(pevp.screen_entry_value))
804: ,sum(fnd_number.canonical_to_number(pevc.screen_entry_value))
805: ,sum(fnd_number.canonical_to_number(pevs.screen_entry_value))
806: ,sum(fnd_number.canonical_to_number(pevy.screen_entry_value))
807: from pay_element_entry_values_f pevm

Line 804: ,sum(fnd_number.canonical_to_number(pevc.screen_entry_value))

800: ,p_type_y_iv_id number
801: ,p_type_accrual_date_iv_id number ) is
802: select sum(fnd_number.canonical_to_number(pevm.screen_entry_value))
803: ,sum(fnd_number.canonical_to_number(pevp.screen_entry_value))
804: ,sum(fnd_number.canonical_to_number(pevc.screen_entry_value))
805: ,sum(fnd_number.canonical_to_number(pevs.screen_entry_value))
806: ,sum(fnd_number.canonical_to_number(pevy.screen_entry_value))
807: from pay_element_entry_values_f pevm
808: ,pay_element_entry_values_f pevp

Line 805: ,sum(fnd_number.canonical_to_number(pevs.screen_entry_value))

801: ,p_type_accrual_date_iv_id number ) is
802: select sum(fnd_number.canonical_to_number(pevm.screen_entry_value))
803: ,sum(fnd_number.canonical_to_number(pevp.screen_entry_value))
804: ,sum(fnd_number.canonical_to_number(pevc.screen_entry_value))
805: ,sum(fnd_number.canonical_to_number(pevs.screen_entry_value))
806: ,sum(fnd_number.canonical_to_number(pevy.screen_entry_value))
807: from pay_element_entry_values_f pevm
808: ,pay_element_entry_values_f pevp
809: ,pay_element_entry_values_f pevc

Line 806: ,sum(fnd_number.canonical_to_number(pevy.screen_entry_value))

802: select sum(fnd_number.canonical_to_number(pevm.screen_entry_value))
803: ,sum(fnd_number.canonical_to_number(pevp.screen_entry_value))
804: ,sum(fnd_number.canonical_to_number(pevc.screen_entry_value))
805: ,sum(fnd_number.canonical_to_number(pevs.screen_entry_value))
806: ,sum(fnd_number.canonical_to_number(pevy.screen_entry_value))
807: from pay_element_entry_values_f pevm
808: ,pay_element_entry_values_f pevp
809: ,pay_element_entry_values_f pevc
810: ,pay_element_entry_values_f pevs

Line 2159: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

2155: --
2156: -- Cursor to fetch plan type
2157: --
2158: CURSOR csr_get_assignment_action (l_assignment_id number) is
2159: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2160: paa.assignment_action_id),16))
2161: from pay_assignment_actions paa,
2162: pay_payroll_actions ppa
2163: where paa.assignment_id = l_assignment_id

Line 2184: Select nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)

2180: -- Modified for bug 3730069
2181: -- Substituted get_fr_plan_info.accrual_year_start
2182: -- in sub-query.
2183: CURSOR csr_get_balance_value is
2184: Select nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
2185: from
2186: pay_run_result_values TARGET
2187: ,pay_balance_feeds_f FEED
2188: ,pay_run_results RR

Line 2691: scr_valuetbl(l_index) := fnd_number.number_to_canonical(p_plan_id);

2687: -- The Accrual Plan ID will always be present
2688: --
2689: l_index := l_index + 1;
2690: inp_value_id_tbl(l_index) := l_type_acp_iv_id;
2691: scr_valuetbl(l_index) := fnd_number.number_to_canonical(p_plan_id);
2692: --
2693: -- The Main will always exist
2694: --
2695: l_index := l_index + 1;

Line 2987: l_fr_plan_info.accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);

2983: open csr_plan_info(p_accrual_plan_id);
2984: fetch csr_plan_info into rec_plan_info;
2985: close csr_plan_info;
2986: l_fr_plan_info.accrual_plan_id := p_accrual_plan_id;
2987: l_fr_plan_info.accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);
2988: l_fr_plan_info.entitlement_offset := fnd_number.canonical_to_number(rec_plan_info.entitlement_offset);
2989: l_fr_plan_info.entitlement_duration := fnd_number.canonical_to_number(rec_plan_info.entitlement_duration);
2990: l_fr_plan_info.working_days := fnd_number.canonical_to_number(rec_plan_info.working_days);
2991: l_fr_plan_info.protected_days := fnd_number.canonical_to_number(rec_plan_info.protected_days);

Line 2988: l_fr_plan_info.entitlement_offset := fnd_number.canonical_to_number(rec_plan_info.entitlement_offset);

2984: fetch csr_plan_info into rec_plan_info;
2985: close csr_plan_info;
2986: l_fr_plan_info.accrual_plan_id := p_accrual_plan_id;
2987: l_fr_plan_info.accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);
2988: l_fr_plan_info.entitlement_offset := fnd_number.canonical_to_number(rec_plan_info.entitlement_offset);
2989: l_fr_plan_info.entitlement_duration := fnd_number.canonical_to_number(rec_plan_info.entitlement_duration);
2990: l_fr_plan_info.working_days := fnd_number.canonical_to_number(rec_plan_info.working_days);
2991: l_fr_plan_info.protected_days := fnd_number.canonical_to_number(rec_plan_info.protected_days);
2992: l_fr_plan_info.accounting_method := rec_plan_info.accounting_method;

Line 2989: l_fr_plan_info.entitlement_duration := fnd_number.canonical_to_number(rec_plan_info.entitlement_duration);

2985: close csr_plan_info;
2986: l_fr_plan_info.accrual_plan_id := p_accrual_plan_id;
2987: l_fr_plan_info.accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);
2988: l_fr_plan_info.entitlement_offset := fnd_number.canonical_to_number(rec_plan_info.entitlement_offset);
2989: l_fr_plan_info.entitlement_duration := fnd_number.canonical_to_number(rec_plan_info.entitlement_duration);
2990: l_fr_plan_info.working_days := fnd_number.canonical_to_number(rec_plan_info.working_days);
2991: l_fr_plan_info.protected_days := fnd_number.canonical_to_number(rec_plan_info.protected_days);
2992: l_fr_plan_info.accounting_method := rec_plan_info.accounting_method;
2993: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);

Line 2990: l_fr_plan_info.working_days := fnd_number.canonical_to_number(rec_plan_info.working_days);

2986: l_fr_plan_info.accrual_plan_id := p_accrual_plan_id;
2987: l_fr_plan_info.accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);
2988: l_fr_plan_info.entitlement_offset := fnd_number.canonical_to_number(rec_plan_info.entitlement_offset);
2989: l_fr_plan_info.entitlement_duration := fnd_number.canonical_to_number(rec_plan_info.entitlement_duration);
2990: l_fr_plan_info.working_days := fnd_number.canonical_to_number(rec_plan_info.working_days);
2991: l_fr_plan_info.protected_days := fnd_number.canonical_to_number(rec_plan_info.protected_days);
2992: l_fr_plan_info.accounting_method := rec_plan_info.accounting_method;
2993: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
2994: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);

Line 2991: l_fr_plan_info.protected_days := fnd_number.canonical_to_number(rec_plan_info.protected_days);

2987: l_fr_plan_info.accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);
2988: l_fr_plan_info.entitlement_offset := fnd_number.canonical_to_number(rec_plan_info.entitlement_offset);
2989: l_fr_plan_info.entitlement_duration := fnd_number.canonical_to_number(rec_plan_info.entitlement_duration);
2990: l_fr_plan_info.working_days := fnd_number.canonical_to_number(rec_plan_info.working_days);
2991: l_fr_plan_info.protected_days := fnd_number.canonical_to_number(rec_plan_info.protected_days);
2992: l_fr_plan_info.accounting_method := rec_plan_info.accounting_method;
2993: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
2994: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
2995: l_fr_plan_info.ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_m_iv_id);

Line 2993: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);

2989: l_fr_plan_info.entitlement_duration := fnd_number.canonical_to_number(rec_plan_info.entitlement_duration);
2990: l_fr_plan_info.working_days := fnd_number.canonical_to_number(rec_plan_info.working_days);
2991: l_fr_plan_info.protected_days := fnd_number.canonical_to_number(rec_plan_info.protected_days);
2992: l_fr_plan_info.accounting_method := rec_plan_info.accounting_method;
2993: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
2994: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
2995: l_fr_plan_info.ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_m_iv_id);
2996: l_fr_plan_info.ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_p_iv_id);
2997: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);

Line 2994: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);

2990: l_fr_plan_info.working_days := fnd_number.canonical_to_number(rec_plan_info.working_days);
2991: l_fr_plan_info.protected_days := fnd_number.canonical_to_number(rec_plan_info.protected_days);
2992: l_fr_plan_info.accounting_method := rec_plan_info.accounting_method;
2993: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
2994: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
2995: l_fr_plan_info.ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_m_iv_id);
2996: l_fr_plan_info.ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_p_iv_id);
2997: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);
2998: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);

Line 2995: l_fr_plan_info.ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_m_iv_id);

2991: l_fr_plan_info.protected_days := fnd_number.canonical_to_number(rec_plan_info.protected_days);
2992: l_fr_plan_info.accounting_method := rec_plan_info.accounting_method;
2993: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
2994: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
2995: l_fr_plan_info.ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_m_iv_id);
2996: l_fr_plan_info.ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_p_iv_id);
2997: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);
2998: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);
2999: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);

Line 2996: l_fr_plan_info.ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_p_iv_id);

2992: l_fr_plan_info.accounting_method := rec_plan_info.accounting_method;
2993: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
2994: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
2995: l_fr_plan_info.ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_m_iv_id);
2996: l_fr_plan_info.ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_p_iv_id);
2997: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);
2998: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);
2999: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);
3000: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);

Line 2997: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);

2993: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
2994: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
2995: l_fr_plan_info.ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_m_iv_id);
2996: l_fr_plan_info.ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_p_iv_id);
2997: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);
2998: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);
2999: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);
3000: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);
3001: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);

Line 2998: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);

2994: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
2995: l_fr_plan_info.ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_m_iv_id);
2996: l_fr_plan_info.ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_p_iv_id);
2997: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);
2998: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);
2999: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);
3000: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);
3001: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);
3002: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);

Line 2999: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);

2995: l_fr_plan_info.ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_m_iv_id);
2996: l_fr_plan_info.ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_p_iv_id);
2997: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);
2998: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);
2999: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);
3000: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);
3001: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);
3002: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);
3003: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);

Line 3000: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);

2996: l_fr_plan_info.ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_p_iv_id);
2997: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);
2998: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);
2999: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);
3000: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);
3001: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);
3002: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);
3003: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);
3004: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);

Line 3001: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);

2997: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);
2998: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);
2999: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);
3000: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);
3001: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);
3002: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);
3003: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);
3004: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);
3005: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);

Line 3002: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);

2998: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);
2999: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);
3000: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);
3001: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);
3002: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);
3003: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);
3004: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);
3005: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);
3006: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);

Line 3003: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);

2999: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);
3000: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);
3001: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);
3002: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);
3003: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);
3004: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);
3005: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);
3006: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);
3007: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);

Line 3004: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);

3000: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);
3001: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);
3002: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);
3003: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);
3004: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);
3005: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);
3006: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);
3007: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);
3008: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);

Line 3005: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);

3001: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);
3002: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);
3003: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);
3004: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);
3005: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);
3006: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);
3007: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);
3008: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);
3009: l_fr_plan_info.adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_c_iv_id);

Line 3006: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);

3002: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);
3003: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);
3004: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);
3005: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);
3006: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);
3007: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);
3008: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);
3009: l_fr_plan_info.adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_c_iv_id);
3010: l_fr_plan_info.adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_s_iv_id);

Line 3007: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);

3003: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);
3004: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);
3005: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);
3006: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);
3007: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);
3008: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);
3009: l_fr_plan_info.adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_c_iv_id);
3010: l_fr_plan_info.adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_s_iv_id);
3011: l_fr_plan_info.adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_y_iv_id);

Line 3008: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);

3004: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);
3005: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);
3006: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);
3007: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);
3008: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);
3009: l_fr_plan_info.adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_c_iv_id);
3010: l_fr_plan_info.adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_s_iv_id);
3011: l_fr_plan_info.adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_y_iv_id);
3012: l_fr_plan_info.main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info.main_holiday_acc_plan_id);

Line 3009: l_fr_plan_info.adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_c_iv_id);

3005: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);
3006: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);
3007: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);
3008: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);
3009: l_fr_plan_info.adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_c_iv_id);
3010: l_fr_plan_info.adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_s_iv_id);
3011: l_fr_plan_info.adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_y_iv_id);
3012: l_fr_plan_info.main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info.main_holiday_acc_plan_id);
3013: l_fr_plan_info.holiday_element_id := rec_plan_info.holiday_element_id;

Line 3010: l_fr_plan_info.adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_s_iv_id);

3006: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);
3007: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);
3008: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);
3009: l_fr_plan_info.adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_c_iv_id);
3010: l_fr_plan_info.adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_s_iv_id);
3011: l_fr_plan_info.adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_y_iv_id);
3012: l_fr_plan_info.main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info.main_holiday_acc_plan_id);
3013: l_fr_plan_info.holiday_element_id := rec_plan_info.holiday_element_id;
3014: l_fr_plan_info.business_group_id := rec_plan_info.business_Group_id;

Line 3011: l_fr_plan_info.adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_y_iv_id);

3007: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);
3008: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);
3009: l_fr_plan_info.adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_c_iv_id);
3010: l_fr_plan_info.adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_s_iv_id);
3011: l_fr_plan_info.adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_y_iv_id);
3012: l_fr_plan_info.main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info.main_holiday_acc_plan_id);
3013: l_fr_plan_info.holiday_element_id := rec_plan_info.holiday_element_id;
3014: l_fr_plan_info.business_group_id := rec_plan_info.business_Group_id;
3015: l_fr_plan_info.accrual_plan_element_id := rec_plan_info.accrual_plan_element_id;

Line 3012: l_fr_plan_info.main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info.main_holiday_acc_plan_id);

3008: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);
3009: l_fr_plan_info.adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_c_iv_id);
3010: l_fr_plan_info.adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_s_iv_id);
3011: l_fr_plan_info.adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_y_iv_id);
3012: l_fr_plan_info.main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info.main_holiday_acc_plan_id);
3013: l_fr_plan_info.holiday_element_id := rec_plan_info.holiday_element_id;
3014: l_fr_plan_info.business_group_id := rec_plan_info.business_Group_id;
3015: l_fr_plan_info.accrual_plan_element_id := rec_plan_info.accrual_plan_element_id;
3016: l_fr_plan_info.working_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.working_days_iv_id);

Line 3016: l_fr_plan_info.working_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.working_days_iv_id);

3012: l_fr_plan_info.main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info.main_holiday_acc_plan_id);
3013: l_fr_plan_info.holiday_element_id := rec_plan_info.holiday_element_id;
3014: l_fr_plan_info.business_group_id := rec_plan_info.business_Group_id;
3015: l_fr_plan_info.accrual_plan_element_id := rec_plan_info.accrual_plan_element_id;
3016: l_fr_plan_info.working_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.working_days_iv_id);
3017: l_fr_plan_info.protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.protected_days_iv_id);
3018: l_fr_plan_info.ent_element_id := rec_plan_info.ENT_element_id;
3019: l_fr_plan_info.obs_element_id := rec_plan_info.OBS_element_id;
3020: l_fr_plan_info.adj_element_id := rec_plan_info.ADJ_element_id;

Line 3017: l_fr_plan_info.protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.protected_days_iv_id);

3013: l_fr_plan_info.holiday_element_id := rec_plan_info.holiday_element_id;
3014: l_fr_plan_info.business_group_id := rec_plan_info.business_Group_id;
3015: l_fr_plan_info.accrual_plan_element_id := rec_plan_info.accrual_plan_element_id;
3016: l_fr_plan_info.working_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.working_days_iv_id);
3017: l_fr_plan_info.protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.protected_days_iv_id);
3018: l_fr_plan_info.ent_element_id := rec_plan_info.ENT_element_id;
3019: l_fr_plan_info.obs_element_id := rec_plan_info.OBS_element_id;
3020: l_fr_plan_info.adj_element_id := rec_plan_info.ADJ_element_id;
3021: l_fr_plan_info.term_element_id := rec_plan_info.term_element_id;

Line 3022: l_fr_plan_info.term_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_accrual_date_iv_id);

3018: l_fr_plan_info.ent_element_id := rec_plan_info.ENT_element_id;
3019: l_fr_plan_info.obs_element_id := rec_plan_info.OBS_element_id;
3020: l_fr_plan_info.adj_element_id := rec_plan_info.ADJ_element_id;
3021: l_fr_plan_info.term_element_id := rec_plan_info.term_element_id;
3022: l_fr_plan_info.term_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_accrual_date_iv_id);
3023: l_fr_plan_info.term_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_days_iv_id);
3024: temp_ent_accrual_date_iv_id:= fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
3025: temp_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);
3026: ELSE

Line 3023: l_fr_plan_info.term_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_days_iv_id);

3019: l_fr_plan_info.obs_element_id := rec_plan_info.OBS_element_id;
3020: l_fr_plan_info.adj_element_id := rec_plan_info.ADJ_element_id;
3021: l_fr_plan_info.term_element_id := rec_plan_info.term_element_id;
3022: l_fr_plan_info.term_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_accrual_date_iv_id);
3023: l_fr_plan_info.term_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_days_iv_id);
3024: temp_ent_accrual_date_iv_id:= fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
3025: temp_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);
3026: ELSE
3027: open csr_plan_info_ee(p_element_entry_id);

Line 3024: temp_ent_accrual_date_iv_id:= fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);

3020: l_fr_plan_info.adj_element_id := rec_plan_info.ADJ_element_id;
3021: l_fr_plan_info.term_element_id := rec_plan_info.term_element_id;
3022: l_fr_plan_info.term_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_accrual_date_iv_id);
3023: l_fr_plan_info.term_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_days_iv_id);
3024: temp_ent_accrual_date_iv_id:= fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
3025: temp_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);
3026: ELSE
3027: open csr_plan_info_ee(p_element_entry_id);
3028: fetch csr_plan_info_ee into rec_plan_info_ee;

Line 3025: temp_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);

3021: l_fr_plan_info.term_element_id := rec_plan_info.term_element_id;
3022: l_fr_plan_info.term_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_accrual_date_iv_id);
3023: l_fr_plan_info.term_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_days_iv_id);
3024: temp_ent_accrual_date_iv_id:= fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
3025: temp_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);
3026: ELSE
3027: open csr_plan_info_ee(p_element_entry_id);
3028: fetch csr_plan_info_ee into rec_plan_info_ee;
3029: close csr_plan_info_ee;

Line 3030: l_fr_plan_info.accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);

3026: ELSE
3027: open csr_plan_info_ee(p_element_entry_id);
3028: fetch csr_plan_info_ee into rec_plan_info_ee;
3029: close csr_plan_info_ee;
3030: l_fr_plan_info.accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);
3031: l_fr_plan_info.entitlement_offset := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_offset);
3032: l_fr_plan_info.entitlement_duration := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_duration);
3033: l_fr_plan_info.working_days := fnd_number.canonical_to_number(rec_plan_info_ee.working_days);
3034: l_fr_plan_info.protected_days := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days);

Line 3031: l_fr_plan_info.entitlement_offset := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_offset);

3027: open csr_plan_info_ee(p_element_entry_id);
3028: fetch csr_plan_info_ee into rec_plan_info_ee;
3029: close csr_plan_info_ee;
3030: l_fr_plan_info.accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);
3031: l_fr_plan_info.entitlement_offset := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_offset);
3032: l_fr_plan_info.entitlement_duration := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_duration);
3033: l_fr_plan_info.working_days := fnd_number.canonical_to_number(rec_plan_info_ee.working_days);
3034: l_fr_plan_info.protected_days := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days);
3035: l_fr_plan_info.accounting_method := rec_plan_info_ee.accounting_method;

Line 3032: l_fr_plan_info.entitlement_duration := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_duration);

3028: fetch csr_plan_info_ee into rec_plan_info_ee;
3029: close csr_plan_info_ee;
3030: l_fr_plan_info.accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);
3031: l_fr_plan_info.entitlement_offset := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_offset);
3032: l_fr_plan_info.entitlement_duration := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_duration);
3033: l_fr_plan_info.working_days := fnd_number.canonical_to_number(rec_plan_info_ee.working_days);
3034: l_fr_plan_info.protected_days := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days);
3035: l_fr_plan_info.accounting_method := rec_plan_info_ee.accounting_method;
3036: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);

Line 3033: l_fr_plan_info.working_days := fnd_number.canonical_to_number(rec_plan_info_ee.working_days);

3029: close csr_plan_info_ee;
3030: l_fr_plan_info.accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);
3031: l_fr_plan_info.entitlement_offset := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_offset);
3032: l_fr_plan_info.entitlement_duration := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_duration);
3033: l_fr_plan_info.working_days := fnd_number.canonical_to_number(rec_plan_info_ee.working_days);
3034: l_fr_plan_info.protected_days := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days);
3035: l_fr_plan_info.accounting_method := rec_plan_info_ee.accounting_method;
3036: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
3037: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);

Line 3034: l_fr_plan_info.protected_days := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days);

3030: l_fr_plan_info.accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);
3031: l_fr_plan_info.entitlement_offset := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_offset);
3032: l_fr_plan_info.entitlement_duration := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_duration);
3033: l_fr_plan_info.working_days := fnd_number.canonical_to_number(rec_plan_info_ee.working_days);
3034: l_fr_plan_info.protected_days := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days);
3035: l_fr_plan_info.accounting_method := rec_plan_info_ee.accounting_method;
3036: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
3037: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
3038: l_fr_plan_info.ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_m_iv_id);

Line 3036: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);

3032: l_fr_plan_info.entitlement_duration := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_duration);
3033: l_fr_plan_info.working_days := fnd_number.canonical_to_number(rec_plan_info_ee.working_days);
3034: l_fr_plan_info.protected_days := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days);
3035: l_fr_plan_info.accounting_method := rec_plan_info_ee.accounting_method;
3036: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
3037: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
3038: l_fr_plan_info.ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_m_iv_id);
3039: l_fr_plan_info.ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_p_iv_id);
3040: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);

Line 3037: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);

3033: l_fr_plan_info.working_days := fnd_number.canonical_to_number(rec_plan_info_ee.working_days);
3034: l_fr_plan_info.protected_days := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days);
3035: l_fr_plan_info.accounting_method := rec_plan_info_ee.accounting_method;
3036: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
3037: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
3038: l_fr_plan_info.ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_m_iv_id);
3039: l_fr_plan_info.ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_p_iv_id);
3040: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);
3041: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);

Line 3038: l_fr_plan_info.ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_m_iv_id);

3034: l_fr_plan_info.protected_days := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days);
3035: l_fr_plan_info.accounting_method := rec_plan_info_ee.accounting_method;
3036: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
3037: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
3038: l_fr_plan_info.ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_m_iv_id);
3039: l_fr_plan_info.ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_p_iv_id);
3040: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);
3041: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);
3042: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);

Line 3039: l_fr_plan_info.ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_p_iv_id);

3035: l_fr_plan_info.accounting_method := rec_plan_info_ee.accounting_method;
3036: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
3037: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
3038: l_fr_plan_info.ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_m_iv_id);
3039: l_fr_plan_info.ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_p_iv_id);
3040: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);
3041: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);
3042: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);
3043: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);

Line 3040: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);

3036: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
3037: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
3038: l_fr_plan_info.ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_m_iv_id);
3039: l_fr_plan_info.ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_p_iv_id);
3040: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);
3041: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);
3042: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);
3043: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);
3044: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);

Line 3041: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);

3037: l_fr_plan_info.ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
3038: l_fr_plan_info.ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_m_iv_id);
3039: l_fr_plan_info.ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_p_iv_id);
3040: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);
3041: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);
3042: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);
3043: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);
3044: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);
3045: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);

Line 3042: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);

3038: l_fr_plan_info.ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_m_iv_id);
3039: l_fr_plan_info.ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_p_iv_id);
3040: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);
3041: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);
3042: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);
3043: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);
3044: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);
3045: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);
3046: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);

Line 3043: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);

3039: l_fr_plan_info.ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_p_iv_id);
3040: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);
3041: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);
3042: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);
3043: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);
3044: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);
3045: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);
3046: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);
3047: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);

Line 3044: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);

3040: l_fr_plan_info.ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);
3041: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);
3042: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);
3043: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);
3044: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);
3045: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);
3046: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);
3047: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);
3048: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);

Line 3045: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);

3041: l_fr_plan_info.ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);
3042: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);
3043: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);
3044: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);
3045: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);
3046: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);
3047: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);
3048: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);
3049: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);

Line 3046: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);

3042: l_fr_plan_info.ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);
3043: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);
3044: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);
3045: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);
3046: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);
3047: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);
3048: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);
3049: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);
3050: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);

Line 3047: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);

3043: l_fr_plan_info.obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);
3044: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);
3045: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);
3046: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);
3047: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);
3048: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);
3049: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);
3050: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);
3051: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);

Line 3048: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);

3044: l_fr_plan_info.obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);
3045: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);
3046: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);
3047: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);
3048: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);
3049: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);
3050: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);
3051: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);
3052: l_fr_plan_info.adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_c_iv_id);

Line 3049: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);

3045: l_fr_plan_info.obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);
3046: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);
3047: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);
3048: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);
3049: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);
3050: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);
3051: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);
3052: l_fr_plan_info.adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_c_iv_id);
3053: l_fr_plan_info.adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_s_iv_id);

Line 3050: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);

3046: l_fr_plan_info.obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);
3047: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);
3048: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);
3049: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);
3050: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);
3051: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);
3052: l_fr_plan_info.adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_c_iv_id);
3053: l_fr_plan_info.adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_s_iv_id);
3054: l_fr_plan_info.adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_y_iv_id);

Line 3051: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);

3047: l_fr_plan_info.obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);
3048: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);
3049: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);
3050: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);
3051: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);
3052: l_fr_plan_info.adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_c_iv_id);
3053: l_fr_plan_info.adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_s_iv_id);
3054: l_fr_plan_info.adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_y_iv_id);
3055: l_fr_plan_info.main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info_ee.main_holiday_acc_plan_id);

Line 3052: l_fr_plan_info.adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_c_iv_id);

3048: l_fr_plan_info.obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);
3049: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);
3050: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);
3051: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);
3052: l_fr_plan_info.adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_c_iv_id);
3053: l_fr_plan_info.adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_s_iv_id);
3054: l_fr_plan_info.adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_y_iv_id);
3055: l_fr_plan_info.main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info_ee.main_holiday_acc_plan_id);
3056: l_fr_plan_info.holiday_element_id := rec_plan_info_ee.holiday_element_id;

Line 3053: l_fr_plan_info.adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_s_iv_id);

3049: l_fr_plan_info.adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);
3050: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);
3051: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);
3052: l_fr_plan_info.adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_c_iv_id);
3053: l_fr_plan_info.adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_s_iv_id);
3054: l_fr_plan_info.adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_y_iv_id);
3055: l_fr_plan_info.main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info_ee.main_holiday_acc_plan_id);
3056: l_fr_plan_info.holiday_element_id := rec_plan_info_ee.holiday_element_id;
3057: l_fr_plan_info.business_group_id := rec_plan_info_ee.business_Group_id;

Line 3054: l_fr_plan_info.adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_y_iv_id);

3050: l_fr_plan_info.adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);
3051: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);
3052: l_fr_plan_info.adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_c_iv_id);
3053: l_fr_plan_info.adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_s_iv_id);
3054: l_fr_plan_info.adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_y_iv_id);
3055: l_fr_plan_info.main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info_ee.main_holiday_acc_plan_id);
3056: l_fr_plan_info.holiday_element_id := rec_plan_info_ee.holiday_element_id;
3057: l_fr_plan_info.business_group_id := rec_plan_info_ee.business_Group_id;
3058: l_fr_plan_info.accrual_plan_id := rec_plan_info_ee.accrual_plan_id;

Line 3055: l_fr_plan_info.main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info_ee.main_holiday_acc_plan_id);

3051: l_fr_plan_info.adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);
3052: l_fr_plan_info.adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_c_iv_id);
3053: l_fr_plan_info.adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_s_iv_id);
3054: l_fr_plan_info.adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_y_iv_id);
3055: l_fr_plan_info.main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info_ee.main_holiday_acc_plan_id);
3056: l_fr_plan_info.holiday_element_id := rec_plan_info_ee.holiday_element_id;
3057: l_fr_plan_info.business_group_id := rec_plan_info_ee.business_Group_id;
3058: l_fr_plan_info.accrual_plan_id := rec_plan_info_ee.accrual_plan_id;
3059: l_fr_plan_info.accrual_plan_element_id := rec_plan_info_ee.accrual_plan_element_id;

Line 3060: l_fr_plan_info.working_days_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.working_days_iv_id);

3056: l_fr_plan_info.holiday_element_id := rec_plan_info_ee.holiday_element_id;
3057: l_fr_plan_info.business_group_id := rec_plan_info_ee.business_Group_id;
3058: l_fr_plan_info.accrual_plan_id := rec_plan_info_ee.accrual_plan_id;
3059: l_fr_plan_info.accrual_plan_element_id := rec_plan_info_ee.accrual_plan_element_id;
3060: l_fr_plan_info.working_days_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.working_days_iv_id);
3061: l_fr_plan_info.ent_element_id := rec_plan_info_ee.ENT_element_id;
3062: l_fr_plan_info.obs_element_id := rec_plan_info_ee.OBS_element_id;
3063: l_fr_plan_info.adj_element_id := rec_plan_info_ee.ADJ_element_id;
3064: l_fr_plan_info.protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days_iv_id);

Line 3064: l_fr_plan_info.protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days_iv_id);

3060: l_fr_plan_info.working_days_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.working_days_iv_id);
3061: l_fr_plan_info.ent_element_id := rec_plan_info_ee.ENT_element_id;
3062: l_fr_plan_info.obs_element_id := rec_plan_info_ee.OBS_element_id;
3063: l_fr_plan_info.adj_element_id := rec_plan_info_ee.ADJ_element_id;
3064: l_fr_plan_info.protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days_iv_id);
3065: l_fr_plan_info.term_element_id := rec_plan_info.term_element_id;
3066: l_fr_plan_info.term_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_accrual_date_iv_id);
3067: l_fr_plan_info.term_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_days_iv_id);
3068: temp_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);

Line 3066: l_fr_plan_info.term_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_accrual_date_iv_id);

3062: l_fr_plan_info.obs_element_id := rec_plan_info_ee.OBS_element_id;
3063: l_fr_plan_info.adj_element_id := rec_plan_info_ee.ADJ_element_id;
3064: l_fr_plan_info.protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days_iv_id);
3065: l_fr_plan_info.term_element_id := rec_plan_info.term_element_id;
3066: l_fr_plan_info.term_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_accrual_date_iv_id);
3067: l_fr_plan_info.term_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_days_iv_id);
3068: temp_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
3069: temp_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);
3070: END IF;

Line 3067: l_fr_plan_info.term_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_days_iv_id);

3063: l_fr_plan_info.adj_element_id := rec_plan_info_ee.ADJ_element_id;
3064: l_fr_plan_info.protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days_iv_id);
3065: l_fr_plan_info.term_element_id := rec_plan_info.term_element_id;
3066: l_fr_plan_info.term_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_accrual_date_iv_id);
3067: l_fr_plan_info.term_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_days_iv_id);
3068: temp_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
3069: temp_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);
3070: END IF;
3071:

Line 3068: temp_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);

3064: l_fr_plan_info.protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days_iv_id);
3065: l_fr_plan_info.term_element_id := rec_plan_info.term_element_id;
3066: l_fr_plan_info.term_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_accrual_date_iv_id);
3067: l_fr_plan_info.term_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_days_iv_id);
3068: temp_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
3069: temp_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);
3070: END IF;
3071:
3072: open csr_temp_swap_rate(l_fr_plan_info.term_element_id);

Line 3069: temp_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);

3065: l_fr_plan_info.term_element_id := rec_plan_info.term_element_id;
3066: l_fr_plan_info.term_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_accrual_date_iv_id);
3067: l_fr_plan_info.term_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.term_days_iv_id);
3068: temp_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
3069: temp_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);
3070: END IF;
3071:
3072: open csr_temp_swap_rate(l_fr_plan_info.term_element_id);
3073: fetch csr_temp_swap_rate into l_fr_plan_info.term_days_iv_id;

Line 3391: p_total_accrued_pto := fnd_number.canonical_to_number(l_outputs(1).value);

3387: p_inputs => l_inputs,
3388: p_outputs => l_outputs);
3389:
3390:
3391: p_total_accrued_pto := fnd_number.canonical_to_number(l_outputs(1).value);
3392: p_effective_start_date := fnd_date.canonical_to_date(l_outputs(2).value);
3393: p_effective_end_date := fnd_date.canonical_to_date(l_outputs(3).value);
3394: p_accrual_end_date := fnd_date.canonical_to_date(l_outputs(4).value);
3395: P_total_Accrued_protected := per_formula_functions.get_number('TOTAL_ACCRUED_PTO_PROTECTED');

Line 4183: select sum(fnd_number.canonical_to_number(pevn.screen_entry_value)),

4179: l_unused_number Number;
4180: l_proc VARCHAR2(72) := g_package||' get_reference_entitlement ';
4181: --
4182: CURSOR csr_ref_entitlement (p_sal_input_id in number,p_day_input_id in number,p_date_input_id in number) is
4183: select sum(fnd_number.canonical_to_number(pevn.screen_entry_value)),
4184: sum(fnd_number.canonical_to_number(pevs.screen_entry_value))
4185: from pay_element_entry_values_f pevn
4186: ,pay_element_entry_values_f pevd
4187: ,pay_element_entry_values_f pevs

Line 4184: sum(fnd_number.canonical_to_number(pevs.screen_entry_value))

4180: l_proc VARCHAR2(72) := g_package||' get_reference_entitlement ';
4181: --
4182: CURSOR csr_ref_entitlement (p_sal_input_id in number,p_day_input_id in number,p_date_input_id in number) is
4183: select sum(fnd_number.canonical_to_number(pevn.screen_entry_value)),
4184: sum(fnd_number.canonical_to_number(pevs.screen_entry_value))
4185: from pay_element_entry_values_f pevn
4186: ,pay_element_entry_values_f pevd
4187: ,pay_element_entry_values_f pevs
4188: ,pay_element_entries_f pee

Line 4641: p_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);

4637: IF p_accrual_plan_id is not null THEN
4638: open csr_plan_info(p_accrual_plan_id);
4639: fetch csr_plan_info into rec_plan_info;
4640: close csr_plan_info;
4641: p_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);
4642: p_entitlement_offset := fnd_number.canonical_to_number(rec_plan_info.entitlement_offset);
4643: p_entitlement_duration := fnd_number.canonical_to_number(rec_plan_info.entitlement_duration);
4644: p_working_days := fnd_number.canonical_to_number(rec_plan_info.working_days);
4645: p_protected_days := fnd_number.canonical_to_number(rec_plan_info.protected_days);

Line 4642: p_entitlement_offset := fnd_number.canonical_to_number(rec_plan_info.entitlement_offset);

4638: open csr_plan_info(p_accrual_plan_id);
4639: fetch csr_plan_info into rec_plan_info;
4640: close csr_plan_info;
4641: p_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);
4642: p_entitlement_offset := fnd_number.canonical_to_number(rec_plan_info.entitlement_offset);
4643: p_entitlement_duration := fnd_number.canonical_to_number(rec_plan_info.entitlement_duration);
4644: p_working_days := fnd_number.canonical_to_number(rec_plan_info.working_days);
4645: p_protected_days := fnd_number.canonical_to_number(rec_plan_info.protected_days);
4646: p_accounting_method := rec_plan_info.accounting_method;

Line 4643: p_entitlement_duration := fnd_number.canonical_to_number(rec_plan_info.entitlement_duration);

4639: fetch csr_plan_info into rec_plan_info;
4640: close csr_plan_info;
4641: p_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);
4642: p_entitlement_offset := fnd_number.canonical_to_number(rec_plan_info.entitlement_offset);
4643: p_entitlement_duration := fnd_number.canonical_to_number(rec_plan_info.entitlement_duration);
4644: p_working_days := fnd_number.canonical_to_number(rec_plan_info.working_days);
4645: p_protected_days := fnd_number.canonical_to_number(rec_plan_info.protected_days);
4646: p_accounting_method := rec_plan_info.accounting_method;
4647: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);

Line 4644: p_working_days := fnd_number.canonical_to_number(rec_plan_info.working_days);

4640: close csr_plan_info;
4641: p_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);
4642: p_entitlement_offset := fnd_number.canonical_to_number(rec_plan_info.entitlement_offset);
4643: p_entitlement_duration := fnd_number.canonical_to_number(rec_plan_info.entitlement_duration);
4644: p_working_days := fnd_number.canonical_to_number(rec_plan_info.working_days);
4645: p_protected_days := fnd_number.canonical_to_number(rec_plan_info.protected_days);
4646: p_accounting_method := rec_plan_info.accounting_method;
4647: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
4648: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);

Line 4645: p_protected_days := fnd_number.canonical_to_number(rec_plan_info.protected_days);

4641: p_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);
4642: p_entitlement_offset := fnd_number.canonical_to_number(rec_plan_info.entitlement_offset);
4643: p_entitlement_duration := fnd_number.canonical_to_number(rec_plan_info.entitlement_duration);
4644: p_working_days := fnd_number.canonical_to_number(rec_plan_info.working_days);
4645: p_protected_days := fnd_number.canonical_to_number(rec_plan_info.protected_days);
4646: p_accounting_method := rec_plan_info.accounting_method;
4647: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
4648: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
4649: p_ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_m_iv_id);

Line 4647: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);

4643: p_entitlement_duration := fnd_number.canonical_to_number(rec_plan_info.entitlement_duration);
4644: p_working_days := fnd_number.canonical_to_number(rec_plan_info.working_days);
4645: p_protected_days := fnd_number.canonical_to_number(rec_plan_info.protected_days);
4646: p_accounting_method := rec_plan_info.accounting_method;
4647: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
4648: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
4649: p_ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_m_iv_id);
4650: p_ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_p_iv_id);
4651: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);

Line 4648: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);

4644: p_working_days := fnd_number.canonical_to_number(rec_plan_info.working_days);
4645: p_protected_days := fnd_number.canonical_to_number(rec_plan_info.protected_days);
4646: p_accounting_method := rec_plan_info.accounting_method;
4647: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
4648: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
4649: p_ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_m_iv_id);
4650: p_ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_p_iv_id);
4651: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);
4652: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);

Line 4649: p_ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_m_iv_id);

4645: p_protected_days := fnd_number.canonical_to_number(rec_plan_info.protected_days);
4646: p_accounting_method := rec_plan_info.accounting_method;
4647: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
4648: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
4649: p_ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_m_iv_id);
4650: p_ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_p_iv_id);
4651: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);
4652: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);
4653: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);

Line 4650: p_ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_p_iv_id);

4646: p_accounting_method := rec_plan_info.accounting_method;
4647: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
4648: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
4649: p_ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_m_iv_id);
4650: p_ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_p_iv_id);
4651: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);
4652: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);
4653: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);
4654: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);

Line 4651: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);

4647: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
4648: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
4649: p_ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_m_iv_id);
4650: p_ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_p_iv_id);
4651: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);
4652: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);
4653: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);
4654: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);
4655: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);

Line 4652: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);

4648: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
4649: p_ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_m_iv_id);
4650: p_ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_p_iv_id);
4651: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);
4652: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);
4653: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);
4654: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);
4655: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);
4656: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);

Line 4653: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);

4649: p_ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_m_iv_id);
4650: p_ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_p_iv_id);
4651: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);
4652: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);
4653: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);
4654: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);
4655: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);
4656: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);
4657: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);

Line 4654: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);

4650: p_ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_p_iv_id);
4651: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);
4652: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);
4653: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);
4654: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);
4655: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);
4656: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);
4657: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);
4658: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);

Line 4655: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);

4651: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_c_iv_id);
4652: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);
4653: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);
4654: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);
4655: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);
4656: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);
4657: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);
4658: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);
4659: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);

Line 4656: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);

4652: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_s_iv_id);
4653: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);
4654: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);
4655: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);
4656: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);
4657: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);
4658: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);
4659: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);
4660: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);

Line 4657: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);

4653: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.ent_y_iv_id);
4654: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);
4655: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);
4656: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);
4657: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);
4658: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);
4659: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);
4660: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);
4661: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);

Line 4658: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);

4654: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_accrual_date_iv_id);
4655: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);
4656: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);
4657: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);
4658: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);
4659: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);
4660: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);
4661: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);
4662: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);

Line 4659: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);

4655: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_m_iv_id);
4656: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);
4657: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);
4658: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);
4659: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);
4660: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);
4661: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);
4662: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);
4663: p_adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_c_iv_id);

Line 4660: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);

4656: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_p_iv_id);
4657: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);
4658: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);
4659: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);
4660: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);
4661: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);
4662: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);
4663: p_adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_c_iv_id);
4664: p_adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_s_iv_id);

Line 4661: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);

4657: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_c_iv_id);
4658: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);
4659: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);
4660: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);
4661: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);
4662: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);
4663: p_adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_c_iv_id);
4664: p_adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_s_iv_id);
4665: p_adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_y_iv_id);

Line 4662: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);

4658: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_s_iv_id);
4659: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);
4660: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);
4661: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);
4662: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);
4663: p_adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_c_iv_id);
4664: p_adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_s_iv_id);
4665: p_adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_y_iv_id);
4666: p_main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info.main_holiday_acc_plan_id);

Line 4663: p_adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_c_iv_id);

4659: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.obs_y_iv_id);
4660: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);
4661: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);
4662: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);
4663: p_adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_c_iv_id);
4664: p_adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_s_iv_id);
4665: p_adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_y_iv_id);
4666: p_main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info.main_holiday_acc_plan_id);
4667: p_holiday_element_id := rec_plan_info.holiday_element_id;

Line 4664: p_adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_s_iv_id);

4660: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_accrual_date_iv_id);
4661: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);
4662: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);
4663: p_adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_c_iv_id);
4664: p_adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_s_iv_id);
4665: p_adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_y_iv_id);
4666: p_main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info.main_holiday_acc_plan_id);
4667: p_holiday_element_id := rec_plan_info.holiday_element_id;
4668: p_business_group_id := rec_plan_info.business_Group_id;

Line 4665: p_adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_y_iv_id);

4661: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_m_iv_id);
4662: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);
4663: p_adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_c_iv_id);
4664: p_adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_s_iv_id);
4665: p_adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_y_iv_id);
4666: p_main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info.main_holiday_acc_plan_id);
4667: p_holiday_element_id := rec_plan_info.holiday_element_id;
4668: p_business_group_id := rec_plan_info.business_Group_id;
4669: temp_ent_accrual_date_iv_id:= fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);

Line 4666: p_main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info.main_holiday_acc_plan_id);

4662: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_p_iv_id);
4663: p_adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_c_iv_id);
4664: p_adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_s_iv_id);
4665: p_adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_y_iv_id);
4666: p_main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info.main_holiday_acc_plan_id);
4667: p_holiday_element_id := rec_plan_info.holiday_element_id;
4668: p_business_group_id := rec_plan_info.business_Group_id;
4669: temp_ent_accrual_date_iv_id:= fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
4670: p_accrual_plan_element_id := rec_plan_info.accrual_plan_element_id;

Line 4669: temp_ent_accrual_date_iv_id:= fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);

4665: p_adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info.adj_y_iv_id);
4666: p_main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info.main_holiday_acc_plan_id);
4667: p_holiday_element_id := rec_plan_info.holiday_element_id;
4668: p_business_group_id := rec_plan_info.business_Group_id;
4669: temp_ent_accrual_date_iv_id:= fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
4670: p_accrual_plan_element_id := rec_plan_info.accrual_plan_element_id;
4671: p_working_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.working_days_iv_id);
4672: p_protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.protected_days_iv_id);
4673: p_ent_element_id := rec_plan_info.ENT_element_id;

Line 4671: p_working_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.working_days_iv_id);

4667: p_holiday_element_id := rec_plan_info.holiday_element_id;
4668: p_business_group_id := rec_plan_info.business_Group_id;
4669: temp_ent_accrual_date_iv_id:= fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
4670: p_accrual_plan_element_id := rec_plan_info.accrual_plan_element_id;
4671: p_working_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.working_days_iv_id);
4672: p_protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.protected_days_iv_id);
4673: p_ent_element_id := rec_plan_info.ENT_element_id;
4674: p_obs_element_id := rec_plan_info.OBS_element_id;
4675: p_adj_element_id := rec_plan_info.ADJ_element_id;

Line 4672: p_protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.protected_days_iv_id);

4668: p_business_group_id := rec_plan_info.business_Group_id;
4669: temp_ent_accrual_date_iv_id:= fnd_number.canonical_to_number(rec_plan_info.ent_accrual_date_iv_id);
4670: p_accrual_plan_element_id := rec_plan_info.accrual_plan_element_id;
4671: p_working_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.working_days_iv_id);
4672: p_protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.protected_days_iv_id);
4673: p_ent_element_id := rec_plan_info.ENT_element_id;
4674: p_obs_element_id := rec_plan_info.OBS_element_id;
4675: p_adj_element_id := rec_plan_info.ADJ_element_id;
4676: temp_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);

Line 4676: temp_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);

4672: p_protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info.protected_days_iv_id);
4673: p_ent_element_id := rec_plan_info.ENT_element_id;
4674: p_obs_element_id := rec_plan_info.OBS_element_id;
4675: p_adj_element_id := rec_plan_info.ADJ_element_id;
4676: temp_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info.accrual_start_month);
4677: ELSE
4678: open csr_plan_info_ee(p_element_entry_id);
4679: fetch csr_plan_info_ee into rec_plan_info_ee;
4680: close csr_plan_info_ee;

Line 4681: p_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);

4677: ELSE
4678: open csr_plan_info_ee(p_element_entry_id);
4679: fetch csr_plan_info_ee into rec_plan_info_ee;
4680: close csr_plan_info_ee;
4681: p_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);
4682: p_entitlement_offset := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_offset);
4683: p_entitlement_duration := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_duration);
4684: p_working_days := fnd_number.canonical_to_number(rec_plan_info_ee.working_days);
4685: p_protected_days := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days);

Line 4682: p_entitlement_offset := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_offset);

4678: open csr_plan_info_ee(p_element_entry_id);
4679: fetch csr_plan_info_ee into rec_plan_info_ee;
4680: close csr_plan_info_ee;
4681: p_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);
4682: p_entitlement_offset := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_offset);
4683: p_entitlement_duration := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_duration);
4684: p_working_days := fnd_number.canonical_to_number(rec_plan_info_ee.working_days);
4685: p_protected_days := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days);
4686: p_accounting_method := rec_plan_info_ee.accounting_method;

Line 4683: p_entitlement_duration := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_duration);

4679: fetch csr_plan_info_ee into rec_plan_info_ee;
4680: close csr_plan_info_ee;
4681: p_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);
4682: p_entitlement_offset := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_offset);
4683: p_entitlement_duration := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_duration);
4684: p_working_days := fnd_number.canonical_to_number(rec_plan_info_ee.working_days);
4685: p_protected_days := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days);
4686: p_accounting_method := rec_plan_info_ee.accounting_method;
4687: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);

Line 4684: p_working_days := fnd_number.canonical_to_number(rec_plan_info_ee.working_days);

4680: close csr_plan_info_ee;
4681: p_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);
4682: p_entitlement_offset := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_offset);
4683: p_entitlement_duration := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_duration);
4684: p_working_days := fnd_number.canonical_to_number(rec_plan_info_ee.working_days);
4685: p_protected_days := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days);
4686: p_accounting_method := rec_plan_info_ee.accounting_method;
4687: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
4688: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);

Line 4685: p_protected_days := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days);

4681: p_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);
4682: p_entitlement_offset := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_offset);
4683: p_entitlement_duration := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_duration);
4684: p_working_days := fnd_number.canonical_to_number(rec_plan_info_ee.working_days);
4685: p_protected_days := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days);
4686: p_accounting_method := rec_plan_info_ee.accounting_method;
4687: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
4688: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
4689: p_ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_m_iv_id);

Line 4687: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);

4683: p_entitlement_duration := fnd_number.canonical_to_number(rec_plan_info_ee.entitlement_duration);
4684: p_working_days := fnd_number.canonical_to_number(rec_plan_info_ee.working_days);
4685: p_protected_days := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days);
4686: p_accounting_method := rec_plan_info_ee.accounting_method;
4687: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
4688: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
4689: p_ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_m_iv_id);
4690: p_ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_p_iv_id);
4691: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);

Line 4688: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);

4684: p_working_days := fnd_number.canonical_to_number(rec_plan_info_ee.working_days);
4685: p_protected_days := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days);
4686: p_accounting_method := rec_plan_info_ee.accounting_method;
4687: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
4688: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
4689: p_ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_m_iv_id);
4690: p_ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_p_iv_id);
4691: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);
4692: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);

Line 4689: p_ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_m_iv_id);

4685: p_protected_days := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days);
4686: p_accounting_method := rec_plan_info_ee.accounting_method;
4687: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
4688: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
4689: p_ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_m_iv_id);
4690: p_ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_p_iv_id);
4691: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);
4692: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);
4693: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);

Line 4690: p_ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_p_iv_id);

4686: p_accounting_method := rec_plan_info_ee.accounting_method;
4687: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
4688: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
4689: p_ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_m_iv_id);
4690: p_ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_p_iv_id);
4691: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);
4692: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);
4693: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);
4694: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);

Line 4691: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);

4687: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
4688: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
4689: p_ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_m_iv_id);
4690: p_ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_p_iv_id);
4691: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);
4692: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);
4693: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);
4694: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);
4695: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);

Line 4692: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);

4688: p_ent_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
4689: p_ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_m_iv_id);
4690: p_ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_p_iv_id);
4691: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);
4692: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);
4693: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);
4694: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);
4695: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);
4696: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);

Line 4693: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);

4689: p_ent_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_m_iv_id);
4690: p_ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_p_iv_id);
4691: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);
4692: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);
4693: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);
4694: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);
4695: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);
4696: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);
4697: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);

Line 4694: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);

4690: p_ent_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_p_iv_id);
4691: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);
4692: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);
4693: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);
4694: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);
4695: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);
4696: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);
4697: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);
4698: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);

Line 4695: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);

4691: p_ent_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_c_iv_id);
4692: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);
4693: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);
4694: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);
4695: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);
4696: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);
4697: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);
4698: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);
4699: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);

Line 4696: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);

4692: p_ent_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_s_iv_id);
4693: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);
4694: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);
4695: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);
4696: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);
4697: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);
4698: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);
4699: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);
4700: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);

Line 4697: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);

4693: p_ent_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.ent_y_iv_id);
4694: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);
4695: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);
4696: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);
4697: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);
4698: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);
4699: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);
4700: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);
4701: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);

Line 4698: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);

4694: p_obs_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_accrual_date_iv_id);
4695: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);
4696: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);
4697: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);
4698: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);
4699: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);
4700: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);
4701: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);
4702: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);

Line 4699: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);

4695: p_obs_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_m_iv_id);
4696: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);
4697: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);
4698: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);
4699: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);
4700: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);
4701: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);
4702: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);
4703: p_adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_c_iv_id);

Line 4700: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);

4696: p_obs_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_p_iv_id);
4697: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);
4698: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);
4699: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);
4700: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);
4701: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);
4702: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);
4703: p_adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_c_iv_id);
4704: p_adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_s_iv_id);

Line 4701: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);

4697: p_obs_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_c_iv_id);
4698: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);
4699: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);
4700: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);
4701: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);
4702: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);
4703: p_adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_c_iv_id);
4704: p_adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_s_iv_id);
4705: p_adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_y_iv_id);

Line 4702: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);

4698: p_obs_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_s_iv_id);
4699: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);
4700: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);
4701: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);
4702: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);
4703: p_adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_c_iv_id);
4704: p_adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_s_iv_id);
4705: p_adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_y_iv_id);
4706: p_main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info_ee.main_holiday_acc_plan_id);

Line 4703: p_adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_c_iv_id);

4699: p_obs_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.obs_y_iv_id);
4700: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);
4701: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);
4702: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);
4703: p_adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_c_iv_id);
4704: p_adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_s_iv_id);
4705: p_adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_y_iv_id);
4706: p_main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info_ee.main_holiday_acc_plan_id);
4707: p_holiday_element_id := rec_plan_info_ee.holiday_element_id;

Line 4704: p_adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_s_iv_id);

4700: p_adj_accrual_date_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_accrual_date_iv_id);
4701: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);
4702: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);
4703: p_adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_c_iv_id);
4704: p_adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_s_iv_id);
4705: p_adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_y_iv_id);
4706: p_main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info_ee.main_holiday_acc_plan_id);
4707: p_holiday_element_id := rec_plan_info_ee.holiday_element_id;
4708: p_business_group_id := rec_plan_info.business_Group_id;

Line 4705: p_adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_y_iv_id);

4701: p_adj_m_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_m_iv_id);
4702: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);
4703: p_adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_c_iv_id);
4704: p_adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_s_iv_id);
4705: p_adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_y_iv_id);
4706: p_main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info_ee.main_holiday_acc_plan_id);
4707: p_holiday_element_id := rec_plan_info_ee.holiday_element_id;
4708: p_business_group_id := rec_plan_info.business_Group_id;
4709: p_accrual_plan_id := rec_plan_info_ee.accrual_plan_id;

Line 4706: p_main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info_ee.main_holiday_acc_plan_id);

4702: p_adj_p_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_p_iv_id);
4703: p_adj_c_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_c_iv_id);
4704: p_adj_s_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_s_iv_id);
4705: p_adj_y_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.adj_y_iv_id);
4706: p_main_holiday_acc_plan_id := fnd_number.canonical_to_number(rec_plan_info_ee.main_holiday_acc_plan_id);
4707: p_holiday_element_id := rec_plan_info_ee.holiday_element_id;
4708: p_business_group_id := rec_plan_info.business_Group_id;
4709: p_accrual_plan_id := rec_plan_info_ee.accrual_plan_id;
4710: p_accrual_plan_element_id := rec_plan_info_ee.accrual_plan_element_id;

Line 4711: p_working_days_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.working_days_iv_id);

4707: p_holiday_element_id := rec_plan_info_ee.holiday_element_id;
4708: p_business_group_id := rec_plan_info.business_Group_id;
4709: p_accrual_plan_id := rec_plan_info_ee.accrual_plan_id;
4710: p_accrual_plan_element_id := rec_plan_info_ee.accrual_plan_element_id;
4711: p_working_days_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.working_days_iv_id);
4712: p_ent_element_id := rec_plan_info.ENT_element_id;
4713: p_obs_element_id := rec_plan_info.OBS_element_id;
4714: p_adj_element_id := rec_plan_info.ADJ_element_id;
4715: p_protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days_iv_id);

Line 4715: p_protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days_iv_id);

4711: p_working_days_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.working_days_iv_id);
4712: p_ent_element_id := rec_plan_info.ENT_element_id;
4713: p_obs_element_id := rec_plan_info.OBS_element_id;
4714: p_adj_element_id := rec_plan_info.ADJ_element_id;
4715: p_protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days_iv_id);
4716: temp_ent_accrual_date_iv_id:= fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
4717: temp_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);
4718: END IF;
4719: --

Line 4716: temp_ent_accrual_date_iv_id:= fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);

4712: p_ent_element_id := rec_plan_info.ENT_element_id;
4713: p_obs_element_id := rec_plan_info.OBS_element_id;
4714: p_adj_element_id := rec_plan_info.ADJ_element_id;
4715: p_protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days_iv_id);
4716: temp_ent_accrual_date_iv_id:= fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
4717: temp_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);
4718: END IF;
4719: --
4720: open csr_reference_inputs (temp_ent_accrual_date_iv_id);

Line 4717: temp_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);

4713: p_obs_element_id := rec_plan_info.OBS_element_id;
4714: p_adj_element_id := rec_plan_info.ADJ_element_id;
4715: p_protected_days_iv_id := fnd_number.canonical_to_number(rec_plan_info_ee.protected_days_iv_id);
4716: temp_ent_accrual_date_iv_id:= fnd_number.canonical_to_number(rec_plan_info_ee.ent_accrual_date_iv_id);
4717: temp_accrual_start_month := fnd_number.canonical_to_number(rec_plan_info_ee.accrual_start_month);
4718: END IF;
4719: --
4720: open csr_reference_inputs (temp_ent_accrual_date_iv_id);
4721: fetch csr_reference_inputs into rec_reference_inputs;

Line 6200: decode(con.ctr_information12,'HOUR', fnd_number.canonical_to_number(con.ctr_information11), asg.normal_hours) hours,

6196: l_cipdz_catg varchar2(3);
6197: --
6198: Cursor csr_get_time_catg is
6199: Select decode(con.ctr_information12,'HOUR', con.ctr_information13, asg.frequency) frequency,
6200: decode(con.ctr_information12,'HOUR', fnd_number.canonical_to_number(con.ctr_information11), asg.normal_hours) hours,
6201: substr(hruserdt.get_table_value(p_business_group_id, 'FR_CIPDZ', 'CIPDZ',nvl(asg.employment_category,'FR'),p_effective_date),1,1) cipdz_catg
6202: from per_all_assignments_f asg,
6203: per_contracts_f con
6204: where asg.assignment_id = p_assignment_id