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_NL_ABP_ARCHIVE dependencies on FND_DATE

Line 142: AND fnd_date.canonical_to_date (prmtr_09) BETWEEN c_start_date

138: ,new_val1 new_date
139: FROM ben_ext_chg_evt_log
140: WHERE person_id = c_person_id
141: AND chg_evt_cd = 'COPOS'
142: AND fnd_date.canonical_to_date (prmtr_09) BETWEEN c_start_date
143: AND c_end_date
144: ORDER BY ext_chg_evt_log_id DESC;
145:
146: -- =============================================================================

Line 284: AND c_effective_date = fnd_date.canonical_to_date(pai.action_information4)

280: WHERE pai.action_information_category = 'NL_ABP_PENSION_INFO'
281: AND pai.action_context_type = 'AAP'
282: AND pai.assignment_id = c_assignment_id
283: AND pai.action_information1 = c_pension_type
284: AND c_effective_date = fnd_date.canonical_to_date(pai.action_information4)
285: ORDER BY pai.action_context_id DESC;
286:
287: -- =====================================================
288: -- Cursor to get the prev reported hire info

Line 298: AND c_effective_date = fnd_date.canonical_to_date(pai.action_information3);

294: FROM pay_action_information pai
295: WHERE pai.assignment_id = c_asg_id
296: AND pai.action_information_category = 'NL_ABP_ASG_INFO'
297: AND pai.action_context_type = 'AAP'
298: AND c_effective_date = fnd_date.canonical_to_date(pai.action_information3);
299:
300:
301: --BUG 14793405
302: -- =====================================================

Line 927: AND c_effective_date BETWEEN trunc (fnd_date.canonical_to_date (aei_information1))

923: FROM per_assignment_extra_info
924: WHERE assignment_id = c_assignment_id
925: AND information_type = 'NL_ABP_PAR_INFO'
926: AND aei_information_category = 'NL_ABP_PAR_INFO'
927: AND c_effective_date BETWEEN trunc (fnd_date.canonical_to_date (aei_information1))
928: AND trunc (nvl (fnd_date.canonical_to_date (aei_information2)
929: ,hr_general.end_of_time))
930: AND aei_information6 IS NOT NULL;
931:

Line 928: AND trunc (nvl (fnd_date.canonical_to_date (aei_information2)

924: WHERE assignment_id = c_assignment_id
925: AND information_type = 'NL_ABP_PAR_INFO'
926: AND aei_information_category = 'NL_ABP_PAR_INFO'
927: AND c_effective_date BETWEEN trunc (fnd_date.canonical_to_date (aei_information1))
928: AND trunc (nvl (fnd_date.canonical_to_date (aei_information2)
929: ,hr_general.end_of_time))
930: AND aei_information6 IS NOT NULL;
931:
932: l_override_value NUMBER := 0;

Line 1170: SELECT fnd_date.canonical_to_date (peev.screen_entry_value) start_date

1166: ,c_ele_type_id NUMBER
1167: ,c_start_dt_id NUMBER
1168: ,c_end_dt_id NUMBER
1169: ,c_asg_id NUMBER) IS
1170: SELECT fnd_date.canonical_to_date (peev.screen_entry_value) start_date
1171: ,fnd_date.canonical_to_date (peev1.screen_entry_value) end_date
1172: FROM pay_element_entries_f peef
1173: ,pay_element_links_f pelf
1174: ,pay_element_entry_values_f peev

Line 1171: ,fnd_date.canonical_to_date (peev1.screen_entry_value) end_date

1167: ,c_start_dt_id NUMBER
1168: ,c_end_dt_id NUMBER
1169: ,c_asg_id NUMBER) IS
1170: SELECT fnd_date.canonical_to_date (peev.screen_entry_value) start_date
1171: ,fnd_date.canonical_to_date (peev1.screen_entry_value) end_date
1172: FROM pay_element_entries_f peef
1173: ,pay_element_links_f pelf
1174: ,pay_element_entry_values_f peev
1175: ,pay_element_entry_values_f peev1

Line 1817: -- substr(fnd_date.date_to_canonical(l_end_new_st),1,10);

1813: ,p_assignment_action_id => act_rec.assignment_action_id);
1814: hr_utility.trace('defined bal id used :'||l_contr_basis(i).defined_bal_id);
1815:
1816: p_contr_basis_values(k).date_earned := l_beg_new_st;
1817: -- substr(fnd_date.date_to_canonical(l_end_new_st),1,10);
1818:
1819: OPEN csr_prev_basis_amt (p_assignment_id,l_beg_new_st,l_contr_basis(i).pension_type);
1820: FETCH csr_prev_basis_amt INTO l_prev_basis_amt;
1821: IF csr_prev_basis_amt%FOUND THEN

Line 1847: -- substr(fnd_date.date_to_canonical(l_end_new_st),1,10);

1843: p_contr_basis_values(k).pension_type := l_contr_basis(i).pension_type;
1844: p_contr_basis_values(k).pension_type_variant := NULL;
1845: p_contr_basis_values(k).contr_base := -1 * l_prev_basis_amt;
1846: p_contr_basis_values(k).date_earned := l_beg_new_st;
1847: -- substr(fnd_date.date_to_canonical(l_end_new_st),1,10);
1848: k := k + 1;
1849: END IF;
1850: CLOSE csr_prev_basis_amt;
1851: END LOOP;

Line 1897: AND c_effective_date = fnd_date.canonical_to_date(pai.action_information4)

1893: AND pai.action_context_type = 'AAP'
1894: AND pai.assignment_id = c_assignment_id
1895: AND pai.action_information1 = c_pension_type
1896: AND pai.action_information2 = c_pension_type_variant
1897: AND c_effective_date = fnd_date.canonical_to_date(pai.action_information4)
1898: ORDER BY pai.action_context_id DESC;
1899: --=========================================================================
1900:
1901: l_new_start DATE;

Line 2801: AND c_effective_date BETWEEN fnd_date.canonical_to_date (aei_information1)

2797: FROM per_assignment_extra_info
2798: WHERE information_type = 'NL_ABP_PAR_INFO'
2799: AND aei_information_category = 'NL_ABP_PAR_INFO'
2800: AND assignment_id = c_assignment_id
2801: AND c_effective_date BETWEEN fnd_date.canonical_to_date (aei_information1)
2802: AND nvl (fnd_date.canonical_to_date(aei_information2)
2803: ,hr_general.end_of_time);*/
2804:
2805: CURSOR csr_part_details(c_assignment_id IN NUMBER

Line 2802: AND nvl (fnd_date.canonical_to_date(aei_information2)

2798: WHERE information_type = 'NL_ABP_PAR_INFO'
2799: AND aei_information_category = 'NL_ABP_PAR_INFO'
2800: AND assignment_id = c_assignment_id
2801: AND c_effective_date BETWEEN fnd_date.canonical_to_date (aei_information1)
2802: AND nvl (fnd_date.canonical_to_date(aei_information2)
2803: ,hr_general.end_of_time);*/
2804:
2805: CURSOR csr_part_details(c_assignment_id IN NUMBER
2806: ,c_eff_start_date IN DATE

Line 2810: , fnd_date.canonical_to_date (aei_information1) kop_start_date

2806: ,c_eff_start_date IN DATE
2807: ,c_eff_end_date IN DATE) IS
2808: SELECT aei_information4 kop
2809: , least (fnd_number.canonical_to_number (aei_information5), 1) * 100 vop
2810: , fnd_date.canonical_to_date (aei_information1) kop_start_date
2811: , nvl (fnd_date.canonical_to_date (aei_information2), c_eff_end_date) kop_end_date
2812: FROM per_assignment_extra_info
2813: WHERE information_type = 'NL_ABP_PAR_INFO'
2814: AND aei_information_category = 'NL_ABP_PAR_INFO'

Line 2811: , nvl (fnd_date.canonical_to_date (aei_information2), c_eff_end_date) kop_end_date

2807: ,c_eff_end_date IN DATE) IS
2808: SELECT aei_information4 kop
2809: , least (fnd_number.canonical_to_number (aei_information5), 1) * 100 vop
2810: , fnd_date.canonical_to_date (aei_information1) kop_start_date
2811: , nvl (fnd_date.canonical_to_date (aei_information2), c_eff_end_date) kop_end_date
2812: FROM per_assignment_extra_info
2813: WHERE information_type = 'NL_ABP_PAR_INFO'
2814: AND aei_information_category = 'NL_ABP_PAR_INFO'
2815: AND assignment_id = c_assignment_id

Line 2816: AND fnd_date.canonical_to_date (aei_information1) <= c_eff_end_date

2812: FROM per_assignment_extra_info
2813: WHERE information_type = 'NL_ABP_PAR_INFO'
2814: AND aei_information_category = 'NL_ABP_PAR_INFO'
2815: AND assignment_id = c_assignment_id
2816: AND fnd_date.canonical_to_date (aei_information1) <= c_eff_end_date
2817: AND nvl (fnd_date.canonical_to_date (aei_information2), hr_general.end_of_time) >= c_eff_start_date
2818: ORDER BY fnd_date.canonical_to_date (kop_start_date);
2819: --=========================================================================
2820: --All Participation Details

Line 2817: AND nvl (fnd_date.canonical_to_date (aei_information2), hr_general.end_of_time) >= c_eff_start_date

2813: WHERE information_type = 'NL_ABP_PAR_INFO'
2814: AND aei_information_category = 'NL_ABP_PAR_INFO'
2815: AND assignment_id = c_assignment_id
2816: AND fnd_date.canonical_to_date (aei_information1) <= c_eff_end_date
2817: AND nvl (fnd_date.canonical_to_date (aei_information2), hr_general.end_of_time) >= c_eff_start_date
2818: ORDER BY fnd_date.canonical_to_date (kop_start_date);
2819: --=========================================================================
2820: --All Participation Details
2821: CURSOR csr_all_part_details(c_ass_act_id IN NUMBER

Line 2818: ORDER BY fnd_date.canonical_to_date (kop_start_date);

2814: AND aei_information_category = 'NL_ABP_PAR_INFO'
2815: AND assignment_id = c_assignment_id
2816: AND fnd_date.canonical_to_date (aei_information1) <= c_eff_end_date
2817: AND nvl (fnd_date.canonical_to_date (aei_information2), hr_general.end_of_time) >= c_eff_start_date
2818: ORDER BY fnd_date.canonical_to_date (kop_start_date);
2819: --=========================================================================
2820: --All Participation Details
2821: CURSOR csr_all_part_details(c_ass_act_id IN NUMBER
2822: ,c_assignment_id IN NUMBER) IS

Line 2846: ORDER BY fnd_date.canonical_to_date (start_date);

2842: AND pai.action_information_category = 'NL_ABP_PAY_PERIOD_INFO'
2843: AND pai.assignment_id = c_assignment_id
2844: AND action_information3 = 'WNE'
2845: )
2846: ORDER BY fnd_date.canonical_to_date (start_date);
2847: --=========================================================================
2848: -- Employee Data
2849: CURSOR csr_get_person_info(c_person_id IN NUMBER
2850: ,c_bg_id IN NUMBER

Line 3005: AND trunc (c_effective_date) BETWEEN fnd_date.canonical_to_date (aei_information1)

3001: ,NULL) obj_cd
3002: FROM per_assignment_extra_info
3003: WHERE assignment_id = c_assignment_id
3004: AND information_type = 'NL_USZO_INFO'
3005: AND trunc (c_effective_date) BETWEEN fnd_date.canonical_to_date (aei_information1)
3006: AND nvl (fnd_date.canonical_to_date (aei_information2)
3007: ,hr_general.end_of_time)
3008: AND rownum = 1; -- Added in case of multiple valid rows
3009: --=========================================================================

Line 3006: AND nvl (fnd_date.canonical_to_date (aei_information2)

3002: FROM per_assignment_extra_info
3003: WHERE assignment_id = c_assignment_id
3004: AND information_type = 'NL_USZO_INFO'
3005: AND trunc (c_effective_date) BETWEEN fnd_date.canonical_to_date (aei_information1)
3006: AND nvl (fnd_date.canonical_to_date (aei_information2)
3007: ,hr_general.end_of_time)
3008: AND rownum = 1; -- Added in case of multiple valid rows
3009: --=========================================================================
3010: -- Income Code

Line 3126: SELECT distinct fnd_date.canonical_to_date(pai1.action_information7) start_date

3122: --Assignment Termination Details previously reported
3123: --current term date less than previous
3124: CURSOR csr_get_prev_asg_info(c_asg_id IN NUMBER)
3125: IS
3126: SELECT distinct fnd_date.canonical_to_date(pai1.action_information7) start_date
3127: ,fnd_date.canonical_to_date(pai1.action_information4) term_date
3128: FROM pay_action_information pai1
3129: WHERE pai1.assignment_id = c_asg_id
3130: AND pai1.action_information_category = 'NL_ABP_ASG_INFO'

Line 3127: ,fnd_date.canonical_to_date(pai1.action_information4) term_date

3123: --current term date less than previous
3124: CURSOR csr_get_prev_asg_info(c_asg_id IN NUMBER)
3125: IS
3126: SELECT distinct fnd_date.canonical_to_date(pai1.action_information7) start_date
3127: ,fnd_date.canonical_to_date(pai1.action_information4) term_date
3128: FROM pay_action_information pai1
3129: WHERE pai1.assignment_id = c_asg_id
3130: AND pai1.action_information_category = 'NL_ABP_ASG_INFO'
3131: AND pai1.action_context_type = 'AAP'

Line 3133: ORDER BY fnd_date.canonical_to_date(pai1.action_information7) DESC;

3129: WHERE pai1.assignment_id = c_asg_id
3130: AND pai1.action_information_category = 'NL_ABP_ASG_INFO'
3131: AND pai1.action_context_type = 'AAP'
3132: --AND pai1.action_information4 IS NOT NULL
3133: ORDER BY fnd_date.canonical_to_date(pai1.action_information7) DESC;
3134: --=========================================================================
3135: --Assignment Termination Details previously reported
3136: --current term date greater than previous
3137: --or termination reversed (term date is NULL)

Line 3140: SELECT distinct fnd_date.canonical_to_date(pai1.action_information7) start_date

3136: --current term date greater than previous
3137: --or termination reversed (term date is NULL)
3138: CURSOR csr_get_prev_asg_info2(c_asg_id IN NUMBER)
3139: IS
3140: SELECT distinct fnd_date.canonical_to_date(pai1.action_information7) start_date
3141: ,fnd_date.canonical_to_date(pai1.action_information4) term_date
3142: FROM pay_action_information pai1
3143: WHERE pai1.assignment_id = c_asg_id
3144: AND pai1.action_information_category = 'NL_ABP_ASG_INFO'

Line 3141: ,fnd_date.canonical_to_date(pai1.action_information4) term_date

3137: --or termination reversed (term date is NULL)
3138: CURSOR csr_get_prev_asg_info2(c_asg_id IN NUMBER)
3139: IS
3140: SELECT distinct fnd_date.canonical_to_date(pai1.action_information7) start_date
3141: ,fnd_date.canonical_to_date(pai1.action_information4) term_date
3142: FROM pay_action_information pai1
3143: WHERE pai1.assignment_id = c_asg_id
3144: AND pai1.action_information_category = 'NL_ABP_ASG_INFO'
3145: AND pai1.action_context_type = 'AAP'

Line 3147: ORDER BY fnd_date.canonical_to_date(pai1.action_information7) DESC;

3143: WHERE pai1.assignment_id = c_asg_id
3144: AND pai1.action_information_category = 'NL_ABP_ASG_INFO'
3145: AND pai1.action_context_type = 'AAP'
3146: AND pai1.action_information4 IS NOT NULL
3147: ORDER BY fnd_date.canonical_to_date(pai1.action_information7) DESC;
3148: --=========================================================================
3149: --Assignment Reversal Termination Details previously reported
3150: CURSOR csr_get_prev_asg_info3(c_asg_id IN NUMBER)
3151: IS

Line 3152: SELECT DISTINCT fnd_date.canonical_to_date (pai.action_information7) start_date

3148: --=========================================================================
3149: --Assignment Reversal Termination Details previously reported
3150: CURSOR csr_get_prev_asg_info3(c_asg_id IN NUMBER)
3151: IS
3152: SELECT DISTINCT fnd_date.canonical_to_date (pai.action_information7) start_date
3153: , fnd_date.canonical_to_date (pai.action_information4) term_date
3154: FROM pay_action_information pai
3155: WHERE pai.assignment_id = c_asg_id
3156: AND pai.action_information_category = 'NL_ABP_ASG_INFO'

Line 3153: , fnd_date.canonical_to_date (pai.action_information4) term_date

3149: --Assignment Reversal Termination Details previously reported
3150: CURSOR csr_get_prev_asg_info3(c_asg_id IN NUMBER)
3151: IS
3152: SELECT DISTINCT fnd_date.canonical_to_date (pai.action_information7) start_date
3153: , fnd_date.canonical_to_date (pai.action_information4) term_date
3154: FROM pay_action_information pai
3155: WHERE pai.assignment_id = c_asg_id
3156: AND pai.action_information_category = 'NL_ABP_ASG_INFO'
3157: AND pai.action_context_type = 'AAP'

Line 3164: AND fnd_date.canonical_to_date (pai1.action_information3) = fnd_date.canonical_to_date (pai.action_information3)

3160: (
3161: SELECT 1
3162: FROM pay_action_information pai1
3163: WHERE pai.assignment_id = pai1.assignment_id
3164: AND fnd_date.canonical_to_date (pai1.action_information3) = fnd_date.canonical_to_date (pai.action_information3)
3165: AND pai1.action_information_category = 'NL_ABP_ASG_INFO'
3166: AND pai1.action_context_type = 'AAP'
3167: AND pai1.action_information4 IS NULL
3168: )

Line 3169: ORDER BY fnd_date.canonical_to_date (pai.action_information7) DESC;

3165: AND pai1.action_information_category = 'NL_ABP_ASG_INFO'
3166: AND pai1.action_context_type = 'AAP'
3167: AND pai1.action_information4 IS NULL
3168: )
3169: ORDER BY fnd_date.canonical_to_date (pai.action_information7) DESC;
3170: --=========================================================================
3171: --Bug 16301893
3172: -- Cursor to get the pay periods
3173: CURSOR csr_pay_periods (c_assignment_id IN Number

Line 3205: SELECT fnd_date.canonical_to_date (evt.prmtr_01) start_date

3201: UNION
3202: -- to find Kind of Participation changes for previous periods
3203: SELECT distinct last_day (add_months (start_date, level-1)) date_earned
3204: FROM (
3205: SELECT fnd_date.canonical_to_date (evt.prmtr_01) start_date
3206: , fnd_date.canonical_to_date (NVL(evt.prmtr_02,evt.prmtr_09)) end_date
3207: FROM ben_ext_chg_evt_log evt
3208: WHERE evt.prmtr_10 = to_char (c_assignment_id)
3209: AND evt.person_id = c_person_id

Line 3206: , fnd_date.canonical_to_date (NVL(evt.prmtr_02,evt.prmtr_09)) end_date

3202: -- to find Kind of Participation changes for previous periods
3203: SELECT distinct last_day (add_months (start_date, level-1)) date_earned
3204: FROM (
3205: SELECT fnd_date.canonical_to_date (evt.prmtr_01) start_date
3206: , fnd_date.canonical_to_date (NVL(evt.prmtr_02,evt.prmtr_09)) end_date
3207: FROM ben_ext_chg_evt_log evt
3208: WHERE evt.prmtr_10 = to_char (c_assignment_id)
3209: AND evt.person_id = c_person_id
3210: AND evt.chg_evt_cd = 'COAPKOP'

Line 3211: AND fnd_date.canonical_to_date (evt.prmtr_09)

3207: FROM ben_ext_chg_evt_log evt
3208: WHERE evt.prmtr_10 = to_char (c_assignment_id)
3209: AND evt.person_id = c_person_id
3210: AND evt.chg_evt_cd = 'COAPKOP'
3211: AND fnd_date.canonical_to_date (evt.prmtr_09)
3212: BETWEEN c_start_date
3213: AND last_day (c_end_date)
3214: )
3215: CONNECT BY level <= months_between (trunc (end_date, 'MM'), trunc (start_date, 'MM'))+1

Line 3220: SELECT fnd_date.canonical_to_date (evt.prmtr_02) start_date

3216: UNION
3217: -- to find change in ABP Annual Pension Salary
3218: SELECT DISTINCT last_day (add_months (start_date, level - 1)) date_earned
3219: FROM (
3220: SELECT fnd_date.canonical_to_date (evt.prmtr_02) start_date
3221: , last_day (c_end_date) end_date
3222: FROM ben_ext_chg_evt_log evt
3223: WHERE evt.ext_chg_evt_log_id =
3224: (

Line 3230: AND fnd_date.canonical_to_date (evt.prmtr_02) <= last_day (c_end_date)

3226: FROM ben_ext_chg_evt_log evt
3227: WHERE evt.prmtr_01 = to_char (c_assignment_id)
3228: AND evt.person_id = c_person_id
3229: AND evt.chg_evt_cd = 'COAPS'
3230: AND fnd_date.canonical_to_date (evt.prmtr_02) <= last_day (c_end_date)
3231: AND trunc (evt.chg_actl_dt, 'MM') = trunc (c_end_date,'MM')
3232: )
3233: )
3234: CONNECT BY level <= months_between (trunc (end_date, 'MM'), trunc (start_date, 'MM')) + 1

Line 3255: AND fnd_date.canonical_to_date (evt.prmtr_09)

3251: , max (ext_chg_evt_log_id) max_chg_evt_log_id
3252: FROM ben_ext_chg_evt_log evt
3253: WHERE evt.person_id = c_person_id
3254: AND evt.chg_evt_cd = 'COPOS'
3255: AND fnd_date.canonical_to_date (evt.prmtr_09)
3256: BETWEEN c_start_date
3257: AND last_day (c_end_date)
3258: ) evt2
3259: WHERE evt.ext_chg_evt_log_id = evt2.min_chg_evt_log_id

Line 3503: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

3499: , p_source_text => NULL
3500: , p_tax_unit_id => l_org_id
3501: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
3502: , p_action_information4 => fnd_message.get
3503: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3504: , p_action_information6 => 'Kind of Participation is null'
3505: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3506: , p_action_information8 => to_char(l_asg_num));
3507: ELSIF l_kop_invalid = 'Y' AND l_part_details.kop IN ('VLF','WVP') THEN

Line 3525: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

3521: , p_source_text => NULL
3522: , p_tax_unit_id => l_org_id
3523: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
3524: , p_action_information4 => fnd_message.get
3525: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3526: , p_action_information6 => 'Invalid Kind of Participation'
3527: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3528: , p_action_information8 => to_char(l_asg_num));
3529: END IF;

Line 3581: , p_action_information1 => fnd_date.date_to_canonical(l_wne_start_date)

3577: , p_effective_date => p_effective_date
3578: , p_source_id => NULL
3579: , p_source_text => NULL
3580: , p_action_information_category => 'NL_ABP_PAY_PERIOD_INFO'
3581: , p_action_information1 => fnd_date.date_to_canonical(l_wne_start_date)
3582: , p_action_information2 => fnd_date.date_to_canonical(l_wne_end_date)
3583: , p_action_information3 => 'WNE'
3584: , p_action_information4 => l_income_code
3585: , p_action_information5 => fnd_number.number_to_canonical(round(lv_ptp,2)/100)

Line 3582: , p_action_information2 => fnd_date.date_to_canonical(l_wne_end_date)

3578: , p_source_id => NULL
3579: , p_source_text => NULL
3580: , p_action_information_category => 'NL_ABP_PAY_PERIOD_INFO'
3581: , p_action_information1 => fnd_date.date_to_canonical(l_wne_start_date)
3582: , p_action_information2 => fnd_date.date_to_canonical(l_wne_end_date)
3583: , p_action_information3 => 'WNE'
3584: , p_action_information4 => l_income_code
3585: , p_action_information5 => fnd_number.number_to_canonical(round(lv_ptp,2)/100)
3586: , p_action_information6 => l_empty_pay_period

Line 3607: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

3603: , p_source_text => NULL
3604: , p_tax_unit_id => l_org_id
3605: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
3606: , p_action_information4 => fnd_message.get
3607: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3608: , p_action_information6 => 'Kind of Participation is null'
3609: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3610: , p_action_information8 => to_char(l_asg_num));
3611: END IF;

Line 3640: , p_action_information1 => fnd_date.date_to_canonical(greatest(lv_start_date,l_asg_start_date,l_kop_start_date))

3636: , p_effective_date => p_effective_date
3637: , p_source_id => NULL
3638: , p_source_text => NULL
3639: , p_action_information_category => 'NL_ABP_PAY_PERIOD_INFO'
3640: , p_action_information1 => fnd_date.date_to_canonical(greatest(lv_start_date,l_asg_start_date,l_kop_start_date))
3641: , p_action_information2 => fnd_date.date_to_canonical(lv_spl_date)
3642: , p_action_information3 => nvl(l_part_details.kop,'WNE')
3643: , p_action_information4 => l_income_code
3644: , p_action_information5 => fnd_number.number_to_canonical(round(lv_ptp,2)/100)

Line 3641: , p_action_information2 => fnd_date.date_to_canonical(lv_spl_date)

3637: , p_source_id => NULL
3638: , p_source_text => NULL
3639: , p_action_information_category => 'NL_ABP_PAY_PERIOD_INFO'
3640: , p_action_information1 => fnd_date.date_to_canonical(greatest(lv_start_date,l_asg_start_date,l_kop_start_date))
3641: , p_action_information2 => fnd_date.date_to_canonical(lv_spl_date)
3642: , p_action_information3 => nvl(l_part_details.kop,'WNE')
3643: , p_action_information4 => l_income_code
3644: , p_action_information5 => fnd_number.number_to_canonical(round(lv_ptp,2)/100)
3645: , p_action_information6 => l_empty_pay_period

Line 3671: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

3667: , p_source_text => NULL
3668: , p_tax_unit_id => l_org_id
3669: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
3670: , p_action_information4 => fnd_message.get
3671: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3672: , p_action_information6 => 'Kind of Participation is null'
3673: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3674: , p_action_information8 => to_char(l_asg_num));
3675: END IF;

Line 3699: , p_action_information1 => fnd_date.date_to_canonical(greatest(lv_start_date,l_asg_start_date,l_temp_date))

3695: , p_effective_date => p_effective_date
3696: , p_source_id => NULL
3697: , p_source_text => NULL
3698: , p_action_information_category => 'NL_ABP_PAY_PERIOD_INFO'
3699: , p_action_information1 => fnd_date.date_to_canonical(greatest(lv_start_date,l_asg_start_date,l_temp_date))
3700: , p_action_information2 => fnd_date.date_to_canonical(l_wne_end_date)
3701: , p_action_information3 => 'WNE'
3702: , p_action_information4 => l_income_code
3703: , p_action_information5 => fnd_number.number_to_canonical(round(lv_ptp,2)/100)

Line 3700: , p_action_information2 => fnd_date.date_to_canonical(l_wne_end_date)

3696: , p_source_id => NULL
3697: , p_source_text => NULL
3698: , p_action_information_category => 'NL_ABP_PAY_PERIOD_INFO'
3699: , p_action_information1 => fnd_date.date_to_canonical(greatest(lv_start_date,l_asg_start_date,l_temp_date))
3700: , p_action_information2 => fnd_date.date_to_canonical(l_wne_end_date)
3701: , p_action_information3 => 'WNE'
3702: , p_action_information4 => l_income_code
3703: , p_action_information5 => fnd_number.number_to_canonical(round(lv_ptp,2)/100)
3704: , p_action_information6 => l_empty_pay_period

Line 3728: IF TRUNC(l_all_contr_amt_values(i).date_earned,'MM')=TRUNC(fnd_date.canonical_to_date(l_all_part_details.start_date),'MM') THEN

3724:
3725: IF l_all_contr_amt_values.count > 0 THEN
3726: FOR i in l_all_contr_amt_values.FIRST..l_all_contr_amt_values.LAST LOOP
3727: FOR l_all_part_details IN csr_all_part_details(l_child_aa_id,l_assignment_id) LOOP
3728: IF TRUNC(l_all_contr_amt_values(i).date_earned,'MM')=TRUNC(fnd_date.canonical_to_date(l_all_part_details.start_date),'MM') THEN
3729:
3730: IF TRUNC(l_all_contr_amt_values(i).date_earned,'MM')=TRUNC(l_asg_start_date,'MM') THEN
3731: l_pension_st_date := l_asg_start_date;
3732: ELSE

Line 3749: , p_action_information3 => fnd_date.date_to_canonical(l_pension_st_date)

3745: , p_source_text => NULL
3746: , p_action_information_category => 'NL_ABP_PENSION_INFO'
3747: , p_action_information1 => l_all_contr_amt_values(i).pension_type
3748: , p_action_information2 => l_all_contr_amt_values(i).pension_type_variant
3749: , p_action_information3 => fnd_date.date_to_canonical(l_pension_st_date)
3750: , p_action_information4 => fnd_date.date_to_canonical(l_all_contr_amt_values(i).date_earned)
3751: , p_action_information5 => 'R'
3752: , p_action_information6 => fnd_number.number_to_canonical(round(l_pension_salary,2))
3753: , p_action_information7 => fnd_number.number_to_canonical(round(l_all_contr_amt_values(i).contr_base,2))

Line 3750: , p_action_information4 => fnd_date.date_to_canonical(l_all_contr_amt_values(i).date_earned)

3746: , p_action_information_category => 'NL_ABP_PENSION_INFO'
3747: , p_action_information1 => l_all_contr_amt_values(i).pension_type
3748: , p_action_information2 => l_all_contr_amt_values(i).pension_type_variant
3749: , p_action_information3 => fnd_date.date_to_canonical(l_pension_st_date)
3750: , p_action_information4 => fnd_date.date_to_canonical(l_all_contr_amt_values(i).date_earned)
3751: , p_action_information5 => 'R'
3752: , p_action_information6 => fnd_number.number_to_canonical(round(l_pension_salary,2))
3753: , p_action_information7 => fnd_number.number_to_canonical(round(l_all_contr_amt_values(i).contr_base,2))
3754: , p_action_information8 => fnd_number.number_to_canonical(round(l_all_contr_amt_values(i).contr_amt,2))

Line 3757: , p_action_information11 => fnd_date.date_to_canonical(l_asg_end_date)

3753: , p_action_information7 => fnd_number.number_to_canonical(round(l_all_contr_amt_values(i).contr_base,2))
3754: , p_action_information8 => fnd_number.number_to_canonical(round(l_all_contr_amt_values(i).contr_amt,2))
3755: , p_action_information9 => l_all_part_details.vop
3756: , p_action_information10 => l_all_part_details.start_date
3757: , p_action_information11 => fnd_date.date_to_canonical(l_asg_end_date)
3758: );
3759: END IF;
3760: END LOOP;
3761: END LOOP;

Line 3782: , p_action_information3 => fnd_date.date_to_canonical(rec_wth_old_start.date_earned)

3778: , p_source_text => NULL
3779: , p_action_information_category => 'NL_ABP_WITHDRAWAL_INFO'
3780: , p_action_information1 => l_person_info.employee_number
3781: , p_action_information2 => to_char(l_asg_seq)
3782: , p_action_information3 => fnd_date.date_to_canonical(rec_wth_old_start.date_earned)
3783: , p_action_information4 => l_person_info.sofi_number
3784: , p_action_information5 => l_code_withdrawal
3785: );
3786: END LOOP;

Line 3934: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

3930: , p_source_text => NULL
3931: , p_tax_unit_id => l_org_id
3932: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
3933: , p_action_information4 => fnd_message.get
3934: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3935: , p_action_information6 => 'Invalid Initials for the employee'
3936: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3937: , p_action_information8 => to_char(l_asg_num));
3938: ELSIF length(l_person_info.init) > 6 THEN

Line 3956: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

3952: , p_source_text => NULL
3953: , p_tax_unit_id => l_org_id
3954: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
3955: , p_action_information4 => fnd_message.get
3956: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3957: , p_action_information6 => 'Invalid Employee Number'
3958: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3959: , p_action_information8 => to_char(l_asg_num));
3960: END IF;

Line 3978: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

3974: , p_source_text => NULL
3975: , p_tax_unit_id => l_org_id
3976: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
3977: , p_action_information4 => fnd_message.get
3978: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
3979: , p_action_information6 => 'Employee Number missing'
3980: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
3981: , p_action_information8 => to_char(l_asg_num));
3982: ELSIF length(l_person_info.employee_number) > 15 THEN

Line 4000: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

3996: , p_source_text => NULL
3997: , p_tax_unit_id => l_org_id
3998: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
3999: , p_action_information4 => fnd_message.get
4000: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4001: , p_action_information6 => 'Invalid Employee Number'
4002: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4003: , p_action_information8 => to_char(l_asg_num));
4004: ELSE

Line 4026: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

4022: , p_source_text => NULL
4023: , p_tax_unit_id => l_org_id
4024: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4025: , p_action_information4 => fnd_message.get
4026: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4027: , p_action_information6 => 'BSN/Sofi Number missing'
4028: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4029: , p_action_information8 => to_char(l_asg_num));
4030: ELSIF length(l_person_info.sofi_number) > 9 THEN

Line 4048: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

4044: , p_source_text => NULL
4045: , p_tax_unit_id => l_org_id
4046: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4047: , p_action_information4 => fnd_message.get
4048: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4049: , p_action_information6 => 'Invalid BSN/Sofi Number'
4050: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4051: , p_action_information8 => to_char(l_asg_num));
4052: END IF;

Line 4097: , p_action_information3 => fnd_date.date_to_canonical(l_prev_asg_info.start_date)

4093: , p_source_text => NULL
4094: , p_action_information_category => 'NL_ABP_WITHDRAWAL_INFO'
4095: , p_action_information1 => l_person_info.employee_number
4096: , p_action_information2 => to_char(l_asg_seq)
4097: , p_action_information3 => fnd_date.date_to_canonical(l_prev_asg_info.start_date)
4098: , p_action_information4 => l_person_info.sofi_number
4099: , p_action_information5 => fnd_date.date_to_canonical(l_start_date)
4100: , p_action_information6 => fnd_date.date_to_canonical(l_end_date)
4101: );

Line 4099: , p_action_information5 => fnd_date.date_to_canonical(l_start_date)

4095: , p_action_information1 => l_person_info.employee_number
4096: , p_action_information2 => to_char(l_asg_seq)
4097: , p_action_information3 => fnd_date.date_to_canonical(l_prev_asg_info.start_date)
4098: , p_action_information4 => l_person_info.sofi_number
4099: , p_action_information5 => fnd_date.date_to_canonical(l_start_date)
4100: , p_action_information6 => fnd_date.date_to_canonical(l_end_date)
4101: );
4102: IF l_prev_asg_info.start_date <= l_asg_end_date THEN
4103: hr_utility.trace('Termination Less : Entry for '||l_prev_asg_info.start_date);

Line 4100: , p_action_information6 => fnd_date.date_to_canonical(l_end_date)

4096: , p_action_information2 => to_char(l_asg_seq)
4097: , p_action_information3 => fnd_date.date_to_canonical(l_prev_asg_info.start_date)
4098: , p_action_information4 => l_person_info.sofi_number
4099: , p_action_information5 => fnd_date.date_to_canonical(l_start_date)
4100: , p_action_information6 => fnd_date.date_to_canonical(l_end_date)
4101: );
4102: IF l_prev_asg_info.start_date <= l_asg_end_date THEN
4103: hr_utility.trace('Termination Less : Entry for '||l_prev_asg_info.start_date);
4104: pay_period_data(l_pay_period_count) := l_prev_asg_info.start_date;

Line 4170: , p_action_information3 => fnd_date.date_to_canonical(l_asg_start_date)

4166: , p_source_text => NULL
4167: , p_action_information_category => 'NL_ABP_ASG_INFO'
4168: , p_action_information1 => l_person_info.employee_number
4169: , p_action_information2 => to_char(l_asg_seq)
4170: , p_action_information3 => fnd_date.date_to_canonical(l_asg_start_date)
4171: , p_action_information4 => fnd_date.date_to_canonical(l_asg_end_date)
4172: , p_action_information5 => l_term_reason
4173: , p_action_information6 => l_kind_emp
4174: , p_action_information7 => fnd_date.date_to_canonical(l_start_date)

Line 4171: , p_action_information4 => fnd_date.date_to_canonical(l_asg_end_date)

4167: , p_action_information_category => 'NL_ABP_ASG_INFO'
4168: , p_action_information1 => l_person_info.employee_number
4169: , p_action_information2 => to_char(l_asg_seq)
4170: , p_action_information3 => fnd_date.date_to_canonical(l_asg_start_date)
4171: , p_action_information4 => fnd_date.date_to_canonical(l_asg_end_date)
4172: , p_action_information5 => l_term_reason
4173: , p_action_information6 => l_kind_emp
4174: , p_action_information7 => fnd_date.date_to_canonical(l_start_date)
4175: , p_action_information8 => fnd_date.date_to_canonical(l_end_date)

Line 4174: , p_action_information7 => fnd_date.date_to_canonical(l_start_date)

4170: , p_action_information3 => fnd_date.date_to_canonical(l_asg_start_date)
4171: , p_action_information4 => fnd_date.date_to_canonical(l_asg_end_date)
4172: , p_action_information5 => l_term_reason
4173: , p_action_information6 => l_kind_emp
4174: , p_action_information7 => fnd_date.date_to_canonical(l_start_date)
4175: , p_action_information8 => fnd_date.date_to_canonical(l_end_date)
4176: );
4177:
4178: --to determine if person data to be reported.

Line 4175: , p_action_information8 => fnd_date.date_to_canonical(l_end_date)

4171: , p_action_information4 => fnd_date.date_to_canonical(l_asg_end_date)
4172: , p_action_information5 => l_term_reason
4173: , p_action_information6 => l_kind_emp
4174: , p_action_information7 => fnd_date.date_to_canonical(l_start_date)
4175: , p_action_information8 => fnd_date.date_to_canonical(l_end_date)
4176: );
4177:
4178: --to determine if person data to be reported.
4179: --In case of multiple asgs, person data required only once.

Line 4251: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

4247: , p_source_text => NULL
4248: , p_tax_unit_id => l_org_id
4249: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4250: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_STREET')
4251: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4252: , p_action_information6 => 'Street name missing in the address'
4253: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4254: , p_action_information8 => to_char(l_asg_num));
4255: END IF;

Line 4274: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

4270: , p_source_text => NULL
4271: , p_tax_unit_id => l_org_id
4272: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4273: , p_action_information4 => fnd_message.get
4274: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4275: , p_action_information6 => 'House Number missing in address'
4276: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4277: , p_action_information8 => to_char(l_asg_num));
4278: END IF;

Line 4295: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

4291: , p_source_text => NULL
4292: , p_tax_unit_id => l_org_id
4293: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4294: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_CITY')
4295: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4296: , p_action_information6 => 'City name missing in the address'
4297: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4298: , p_action_information8 => to_char(l_asg_num));
4299: END IF;

Line 4319: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

4315: , p_source_text => NULL
4316: , p_tax_unit_id => l_org_id
4317: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4318: , p_action_information4 => fnd_message.get
4319: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4320: , p_action_information6 => 'Postal Code missing in address'
4321: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4322: , p_action_information8 => to_char(l_asg_num));
4323: END IF;

Line 4341: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

4337: , p_source_text => NULL
4338: , p_tax_unit_id => l_org_id
4339: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4340: , p_action_information4 => fnd_message.get
4341: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4342: , p_action_information6 => 'ISO Country code missing in address'
4343: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4344: , p_action_information8 => to_char(l_asg_num));
4345: END IF;

Line 4366: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

4362: , p_source_text => NULL
4363: , p_tax_unit_id => l_org_id
4364: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4365: , p_action_information4 => fnd_message.get
4366: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4367: , p_action_information6 => 'Invalid Nationality for the employee'
4368: , p_action_information7 => l_person_info.prefix ||' '|| l_person_info.last_name ||' '|| l_person_info.init
4369: , p_action_information8 => to_char(l_asg_num));
4370: END IF;

Line 4396: , p_action_information7 => fnd_date.date_to_canonical(l_person_info.date_of_birth)

4392: , p_action_information3 => l_person_info.sofi_number
4393: , p_action_information4 => l_person_info.last_name
4394: , p_action_information5 => l_person_info.init
4395: , p_action_information6 => l_person_info.prefix
4396: , p_action_information7 => fnd_date.date_to_canonical(l_person_info.date_of_birth)
4397: , p_action_information8 => l_nationality
4398: , p_action_information9 => l_person_info.gender
4399: , p_action_information10 => fnd_date.date_to_canonical(l_person_info.date_of_death)
4400: , p_action_information11 => l_partner_details.last_name

Line 4399: , p_action_information10 => fnd_date.date_to_canonical(l_person_info.date_of_death)

4395: , p_action_information6 => l_person_info.prefix
4396: , p_action_information7 => fnd_date.date_to_canonical(l_person_info.date_of_birth)
4397: , p_action_information8 => l_nationality
4398: , p_action_information9 => l_person_info.gender
4399: , p_action_information10 => fnd_date.date_to_canonical(l_person_info.date_of_death)
4400: , p_action_information11 => l_partner_details.last_name
4401: , p_action_information12 => l_partner_details.prefix
4402: , p_action_information13 => l_partner_details.init
4403: , p_action_information14 => l_street

Line 4413: , p_action_information24 => fnd_date.date_to_canonical(l_start_date_ms)

4409: , p_action_information20 => l_region
4410: , p_action_information21 => l_iso
4411: , p_action_information22 => l_person_addr.style
4412: , p_action_information23 => l_marital_status
4413: , p_action_information24 => fnd_date.date_to_canonical(l_start_date_ms)
4414: , p_action_information25 => l_individual_exem
4415: , p_action_information26 => fnd_date.date_to_canonical(l_start_date)
4416: , p_action_information27 => fnd_date.date_to_canonical(nvl(l_asg_end_date,l_end_date))
4417: , p_action_information28 => l_person_data

Line 4415: , p_action_information26 => fnd_date.date_to_canonical(l_start_date)

4411: , p_action_information22 => l_person_addr.style
4412: , p_action_information23 => l_marital_status
4413: , p_action_information24 => fnd_date.date_to_canonical(l_start_date_ms)
4414: , p_action_information25 => l_individual_exem
4415: , p_action_information26 => fnd_date.date_to_canonical(l_start_date)
4416: , p_action_information27 => fnd_date.date_to_canonical(nvl(l_asg_end_date,l_end_date))
4417: , p_action_information28 => l_person_data
4418: );
4419:

Line 4416: , p_action_information27 => fnd_date.date_to_canonical(nvl(l_asg_end_date,l_end_date))

4412: , p_action_information23 => l_marital_status
4413: , p_action_information24 => fnd_date.date_to_canonical(l_start_date_ms)
4414: , p_action_information25 => l_individual_exem
4415: , p_action_information26 => fnd_date.date_to_canonical(l_start_date)
4416: , p_action_information27 => fnd_date.date_to_canonical(nvl(l_asg_end_date,l_end_date))
4417: , p_action_information28 => l_person_data
4418: );
4419:
4420:

Line 4509: , p_action_information3 => fnd_date.date_to_canonical(l_wth_prd_start_date)

4505: , p_source_text => NULL
4506: , p_action_information_category => 'NL_ABP_COMP_WITHDRAWAL_INFO'
4507: , p_action_information1 => l_person_info.employee_number
4508: , p_action_information2 => to_char(l_asg_seq)
4509: , p_action_information3 => fnd_date.date_to_canonical(l_wth_prd_start_date)
4510: , p_action_information4 => l_person_info.sofi_number
4511: , p_action_information5 => l_code_withdrawal
4512: );
4513: l_wth_prd_start_date := add_months(l_wth_prd_start_date,1);

Line 4593: ,fnd_date.date_to_displaydate(fnd_date.canonical_to_date(pai_p.action_information5)) Dt

4589: WHERE organization_id = p_org_id;
4590: --=========================================================================
4591: CURSOR csr_get_PA_exception_info(p_payroll_action_id IN NUMBER) IS
4592: SELECT pai_p.action_information4 Message
4593: ,fnd_date.date_to_displaydate(fnd_date.canonical_to_date(pai_p.action_information5)) Dt
4594: ,pai_p.action_information6 Description
4595: ,substr(pai_p.action_information7,1,30) E_Name
4596: ,pai_p.action_context_type cxt
4597: FROM pay_action_information pai_p

Line 4604: ,fnd_date.date_to_displaydate(fnd_date.canonical_to_date(pai_p.action_information5)) Dt

4600: AND pai_p.action_context_type = 'PA';
4601: --=========================================================================
4602: CURSOR csr_get_AAP_exception_info(p_payroll_action_id IN NUMBER) IS
4603: SELECT pai_p.action_information4 Message
4604: ,fnd_date.date_to_displaydate(fnd_date.canonical_to_date(pai_p.action_information5)) Dt
4605: ,pai_p.action_information6 Description
4606: ,substr(pai_p.action_information7,1,45) E_Name
4607: ,substr(pai_p.action_information8,1,30) E_Number
4608: ,pai_p.action_context_type cxt

Line 4620: ,fnd_date.date_to_displaydate (fnd_date.canonical_to_date (pai_p.action_information5)) dt

4616: --=========================================================================
4617: -- Bug 14793405
4618: CURSOR csr_get_tech_exception_info(p_payroll_action_id IN number) IS
4619: SELECT pai_p.action_information4 message
4620: ,fnd_date.date_to_displaydate (fnd_date.canonical_to_date (pai_p.action_information5)) dt
4621: ,pai_p.action_information6 description
4622: ,substr (pai_p.action_information7, 1, 30) e_name
4623: ,pai_p.action_context_type cxt
4624: FROM pay_action_information pai_p

Line 4694: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

4690: , p_source_text => NULL
4691: , p_tax_unit_id => l_org_id
4692: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4693: , p_action_information4 => fnd_message.get
4694: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4695: , p_action_information6 => 'ABP Registration Number Sender is null'
4696: , p_action_information7 => substr(l_er_name,1,200));
4697: END IF;
4698: IF l_sender_details.prod_test IS NULL THEN

Line 4714: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

4710: , p_source_text => NULL
4711: , p_tax_unit_id => l_org_id
4712: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4713: , p_action_information4 => fnd_message.get
4714: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4715: , p_action_information6 => 'Test Environment Flag is null'
4716: , p_action_information7 => substr(l_er_name,1,200));
4717: END IF;
4718: ELSE

Line 4734: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

4730: , p_source_text => NULL
4731: , p_tax_unit_id => l_org_id
4732: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4733: , p_action_information4 => fnd_message.get
4734: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4735: , p_action_information6 => 'ABP Registration Number Sender is null'
4736: , p_action_information7 => substr(l_er_name,1,200));
4737:
4738: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');

Line 4753: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

4749: , p_source_text => NULL
4750: , p_tax_unit_id => l_org_id
4751: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4752: , p_action_information4 => fnd_message.get
4753: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4754: , p_action_information6 => 'Test Environment Flag is null'
4755: , p_action_information7 => substr(l_er_name,1,200));
4756: END IF;
4757: CLOSE csr_get_sender_details;

Line 4775: , p_action_information2 => fnd_date.date_to_canonical(l_start_date)

4771: , p_source_id => NULL
4772: , p_source_text => NULL
4773: , p_action_information_category => 'NL_ABP_SENDER_INFO'
4774: , p_action_information1 => l_sender_details.reg_num_sender
4775: , p_action_information2 => fnd_date.date_to_canonical(l_start_date)
4776: , p_action_information3 => nvl(l_seq_num,1)
4777: , p_action_information4 => 'APG02.01.01'
4778: , p_action_information5 => to_char (systimestamp,'RRRR-MM-DD"T"HH24:MI:SSTZR')
4779: , p_action_information6 => l_report_type

Line 4783: , p_action_information10 => fnd_date.date_to_canonical(l_start_date)

4779: , p_action_information6 => l_report_type
4780: , p_action_information7 => l_sender_details.prod_test
4781: , p_action_information8 => l_sender_details.name_sender
4782: , p_action_information9 => l_get_app_ver.release_name
4783: , p_action_information10 => fnd_date.date_to_canonical(l_start_date)
4784: );
4785:
4786: OPEN csr_get_er_details(l_org_id);
4787: FETCH csr_get_er_details INTO l_er_num,l_freq,l_ref_er;

Line 4846: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

4842: , p_source_text => NULL
4843: , p_tax_unit_id => l_org_id
4844: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4845: , p_action_information4 => fnd_message.get_string('PER','HR_NL_INVALID_TAX_NO')
4846: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4847: , p_action_information6 => 'Tax Registration Number is null'
4848: , p_action_information7 => substr(l_er_name,1,200)
4849: , p_action_information8 => substr(l_er_num,1,12));
4850: END IF;

Line 4868: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)

4864: , p_source_text => NULL
4865: , p_tax_unit_id => l_org_id
4866: , p_action_information_category => 'NL_ABP_EXCEPTION_REPORT'
4867: , p_action_information4 => fnd_message.get
4868: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
4869: , p_action_information6 => 'Frequency is null'
4870: , p_action_information7 => substr(l_er_name,1,200)
4871: , p_action_information8 => substr(l_er_num,1,12));
4872: END IF;

Line 4887: , p_action_information3 => fnd_date.date_to_canonical(l_start_date)

4883: , p_source_text => NULL
4884: , p_action_information_category => 'NL_ABP_EMPLOYER_INFO'
4885: , p_action_information1 => l_er_num
4886: , p_action_information2 => l_freq
4887: , p_action_information3 => fnd_date.date_to_canonical(l_start_date)
4888: , p_action_information4 => fnd_date.date_to_canonical(l_end_date)
4889: , p_action_information5 => l_ref_er
4890: , p_action_information6 => l_org_id
4891: );

Line 4888: , p_action_information4 => fnd_date.date_to_canonical(l_end_date)

4884: , p_action_information_category => 'NL_ABP_EMPLOYER_INFO'
4885: , p_action_information1 => l_er_num
4886: , p_action_information2 => l_freq
4887: , p_action_information3 => fnd_date.date_to_canonical(l_start_date)
4888: , p_action_information4 => fnd_date.date_to_canonical(l_end_date)
4889: , p_action_information5 => l_ref_er
4890: , p_action_information6 => l_org_id
4891: );
4892: