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 316: /* Bug : 3318756 - Replaced to_date with fnd_date.chardate_to_date in the select

312: FROM DUAL
313: WHERE rownum=1;
314:
315: /* Bug : 2601218 - Cursor to get the tax detail field value from parameters passed */
316: /* Bug : 3318756 - Replaced to_date with fnd_date.chardate_to_date in the select
317: statement for p_declaration_signed_date parameter */
318: CURSOR get_passed_tax_field_values( p_australian_resident_flag VARCHAR2
319: ,p_tax_free_threshold_flag VARCHAR2
320: ,p_fta_claim_flag VARCHAR2

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

349: 'YC','C',
350: 'X'),
351: decode(p_hecs_sfss_flag,'Y','Y','N','N','YY','Y','NY','N',Null) ,
352: decode(p_hecs_sfss_flag,'YY','Y','NY','Y','N') ,
353: fnd_date.date_to_canonical(fnd_date.chardate_to_date(p_declaration_signed_date)) ,
354: decode(decode(p_spouse_mls_flag,'Y','Y','N','N','YY','Y','NY','N','N'),'Y','Y',decode(p_savings_rebate_flag,'Y','Y','N')) ,
355: p_tax_file_number
356: FROM DUAL
357: WHERE rownum=1;

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

644: l_curr_tax_file_number <> l_prev_tax_file_number or
645: l_prev_record_exists = 'N' ) THEN
646:
647: l_entry_information_category := 'AU_TAX DEDUCTIONS';
648: l_entry_information1 := fnd_date.date_to_canonical(sysdate);
649: ELSE
650: l_entry_information_category := 'AU_TAX DEDUCTIONS';
651: l_entry_information1 := l_prev_entry_information1;
652: END IF;

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

931: ,p_business_group_id => p_business_group_id
932: ,p_element_entry_id => l_paye_element_entry_id
933: ,p_object_version_number => l_paye_object_version_number
934: ,p_entry_information_category => 'AU_TAX_DEDUCTIONS'
935: ,p_entry_information1 => fnd_date.date_to_canonical(sysdate)
936: ,p_override_user_ent_chk => 'Y'
937: ,p_effective_start_date => l_paye_effective_start_date
938: ,p_effective_end_date => l_paye_effective_end_date
939: ,p_update_warning => p_update_warning);

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

1564: ,p_attribute18 => p_attribute18
1565: ,p_attribute19 => p_attribute19
1566: ,p_attribute20 => p_attribute20
1567: ,p_entry_information_category => 'AU_TAX DEDUCTIONS'
1568: ,p_entry_information1 => fnd_date.date_to_canonical(sysdate)
1569: ,p_australian_resident_flag => p_australian_resident_flag
1570: ,p_tax_free_threshold_flag => p_tax_free_threshold_flag
1571: ,p_rebate_amount => p_rebate_amount
1572: ,p_fta_claim_flag => p_fta_claim_flag

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

1986: ,p_session_date => p_hire_date
1987: ,p_mode => 'CORRECTION'
1988: ,p_business_group_id => p_business_group_id
1989: ,p_entry_information_category => 'AU_TAX DEDUCTIONS'
1990: ,p_entry_information1 => fnd_date.date_to_canonical(sysdate)
1991: ,p_australian_resident_flag => l_australian_resident_flag
1992: ,p_tax_free_threshold_flag => p_tax_free_threshold
1993: ,p_rebate_amount => p_rebate_amount
1994: ,p_fta_claim_flag => l_fta_claim_flag