APPS.HR_AU_TAX_API dependencies on FND_DATE

Line 35: to use fnd_date.chardate_to_date instead of to_date

31: kaverma 26-NOV-2002 115.19 Bug 2601218 - Changed maintain_paye_tax_info and
32: maintain_super_info procedures.
33: kaverma 04-DEC-2002 115.20 Added nocopy for parameters
34: vgsriniv 17-DEC-2003 115.21 Bug:3318756. Modified cursor get_passed_tax_field_values
35: to use fnd_date.chardate_to_date instead of to_date
36: srrajago 07-JUN-2004 115.22 Bug: 3648796 - Performance Fix to remove FTS.Assigned the correct element name to the variable
37: g_paye_element(as in seed).In the cursors csr_paye_element,csr_paye_tax_element(in the procedures
38: maintain_paye_tax_info and maintain_SUPER_info),removed UPPER function on element_name.Value
39: assigned to the element_name is also corrected (as in seed).Removed GSCC warnings(File.Sql.35).

Line 339: /* Bug : 3318756 - Replaced to_date with fnd_date.chardate_to_date in the select

335: FROM DUAL
336: WHERE rownum=1;
337:
338: /* Bug : 2601218 - Cursor to get the tax detail field value from parameters passed */
339: /* Bug : 3318756 - Replaced to_date with fnd_date.chardate_to_date in the select
340: statement for p_declaration_signed_date parameter */
341: /* 12570937 - Added flood_levy changes to cursor */
342: CURSOR get_passed_tax_field_values( p_australian_resident_flag VARCHAR2
343: ,p_tax_free_threshold_flag VARCHAR2

Line 378: fnd_date.date_to_canonical(fnd_date.chardate_to_date(p_declaration_signed_date)) ,

374: 'YC','C',
375: 'X'),
376: decode(p_hecs_sfss_flag,'Y','Y','N','N','YY','Y','NY','N',Null) ,
377: decode(p_hecs_sfss_flag,'YY','Y','NY','Y','N') ,
378: fnd_date.date_to_canonical(fnd_date.chardate_to_date(p_declaration_signed_date)) ,
379: decode(decode(p_spouse_mls_flag,'Y','Y','N','N','YY','Y','NY','N','NYA','N','NYB','N','NYC','N','YYA','Y','YYB','Y','YYC','Y','N'),'Y','Y',decode(p_savings_rebate_flag,'Y','Y','N')) ,
380: p_tax_file_number,
381: p_exem_flood_levy_flag
382: FROM DUAL

Line 684: l_entry_information1 := fnd_date.date_to_canonical(sysdate);

680: l_curr_exempt_flood_levy_flag <> l_prev_exempt_flood_levy_flag or
681: l_prev_record_exists = 'N' ) THEN
682:
683: l_entry_information_category := 'AU_TAX DEDUCTIONS';
684: l_entry_information1 := fnd_date.date_to_canonical(sysdate);
685: ELSE
686: l_entry_information_category := 'AU_TAX DEDUCTIONS';
687: l_entry_information1 := l_prev_entry_information1;
688: END IF;

Line 974: ,p_entry_information1 => fnd_date.date_to_canonical(sysdate)

970: ,p_business_group_id => p_business_group_id
971: ,p_element_entry_id => l_paye_element_entry_id
972: ,p_object_version_number => l_paye_object_version_number
973: ,p_entry_information_category => 'AU_TAX_DEDUCTIONS'
974: ,p_entry_information1 => fnd_date.date_to_canonical(sysdate)
975: ,p_override_user_ent_chk => 'Y'
976: ,p_effective_start_date => l_paye_effective_start_date
977: ,p_effective_end_date => l_paye_effective_end_date
978: ,p_update_warning => p_update_warning);

Line 1607: ,p_entry_information1 => fnd_date.date_to_canonical(sysdate)

1603: ,p_attribute18 => p_attribute18
1604: ,p_attribute19 => p_attribute19
1605: ,p_attribute20 => p_attribute20
1606: ,p_entry_information_category => 'AU_TAX DEDUCTIONS'
1607: ,p_entry_information1 => fnd_date.date_to_canonical(sysdate)
1608: ,p_australian_resident_flag => p_australian_resident_flag
1609: ,p_tax_free_threshold_flag => p_tax_free_threshold_flag
1610: ,p_rebate_amount => p_rebate_amount
1611: ,p_fta_claim_flag => p_fta_claim_flag

Line 2065: ,p_entry_information1 => fnd_date.date_to_canonical(sysdate)

2061: ,p_session_date => l_date
2062: ,p_mode => 'CORRECTION'
2063: ,p_business_group_id => p_business_group_id
2064: ,p_entry_information_category => 'AU_TAX DEDUCTIONS'
2065: ,p_entry_information1 => fnd_date.date_to_canonical(sysdate)
2066: ,p_australian_resident_flag => l_australian_resident_flag
2067: ,p_tax_free_threshold_flag => p_tax_free_threshold
2068: ,p_rebate_amount => p_rebate_amount
2069: ,p_fta_claim_flag => l_fta_claim_flag