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.JAI_AP_TDS_ETDS_PKG dependencies on FND_DATE

Line 95: added the call to the function Fnd_date.canoncical_to_date.

91: Hence, implemented this change.
92:
93: 14. 28-jun-2007 CSahoo for bug#6158875
94: modified the num of input parameters to yearly_returns procedure.
95: added the call to the function Fnd_date.canoncical_to_date.
96:
97: 15. 02-Jul-2007 CSahoo for bug#6158875, file version 120.10
98: modified the num of input parameters to querterly_returns procedure.
99: added the call to the function Fnd_date.canoncical_to_date.

Line 99: added the call to the function Fnd_date.canoncical_to_date.

95: added the call to the function Fnd_date.canoncical_to_date.
96:
97: 15. 02-Jul-2007 CSahoo for bug#6158875, file version 120.10
98: modified the num of input parameters to querterly_returns procedure.
99: added the call to the function Fnd_date.canoncical_to_date.
100:
101:
102: 16. 03/07/2007 CSAHOO FOR BUG#6158875, File Version 120.11
103: modified the following cursors c_tds_payment_check_id,c_base_payment_check_id,c_check_dtls.

Line 2853: ld_challan_start_date := fnd_date.canonical_to_date(p_challan_Start_Date); --added by csahoo for bug#6158875

2849: ld_challan_end_date DATE; --added by csahoo for bug#6158875
2850: BEGIN
2851:
2852: l_prg_id:=FND_GLOBAL.CONC_PROGRAM_ID;
2853: ld_challan_start_date := fnd_date.canonical_to_date(p_challan_Start_Date); --added by csahoo for bug#6158875
2854: ld_challan_end_date := fnd_date.canonical_to_date(p_challan_End_Date); --added by csahoo for bug#6158875
2855:
2856: open c_prg_name(l_prg_id);
2857: fetch c_prg_name into l_prg_name;

Line 2854: ld_challan_end_date := fnd_date.canonical_to_date(p_challan_End_Date); --added by csahoo for bug#6158875

2850: BEGIN
2851:
2852: l_prg_id:=FND_GLOBAL.CONC_PROGRAM_ID;
2853: ld_challan_start_date := fnd_date.canonical_to_date(p_challan_Start_Date); --added by csahoo for bug#6158875
2854: ld_challan_end_date := fnd_date.canonical_to_date(p_challan_End_Date); --added by csahoo for bug#6158875
2855:
2856: open c_prg_name(l_prg_id);
2857: fetch c_prg_name into l_prg_name;
2858: close c_prg_name;

Line 2986: ld_challan_start_date := fnd_date.canonical_to_date(p_challan_Start_Date); --added by csahoo for bug#6158875

2982: ld_challan_start_date DATE;
2983: ld_challan_end_date DATE;
2984: BEGIN
2985:
2986: ld_challan_start_date := fnd_date.canonical_to_date(p_challan_Start_Date); --added by csahoo for bug#6158875
2987: ld_challan_end_date := fnd_date.canonical_to_date(p_challan_End_Date); --added by csahoo for bug#6158875
2988: generate_etds_returns
2989: (
2990: p_err_buf => p_err_buf ,

Line 2987: ld_challan_end_date := fnd_date.canonical_to_date(p_challan_End_Date); --added by csahoo for bug#6158875

2983: ld_challan_end_date DATE;
2984: BEGIN
2985:
2986: ld_challan_start_date := fnd_date.canonical_to_date(p_challan_Start_Date); --added by csahoo for bug#6158875
2987: ld_challan_end_date := fnd_date.canonical_to_date(p_challan_End_Date); --added by csahoo for bug#6158875
2988: generate_etds_returns
2989: (
2990: p_err_buf => p_err_buf ,
2991: p_ret_code => p_ret_code ,

Line 3063: p_challan_Start_Date DATE; --File.Sql.35 Cbabu DEFAULT fnd_date.canonical_to_date(pv_challan_Start_Date);

3059: lv_prim_att_type CONSTANT VARCHAR2(30) := 'OTHERS' ; -- 'PRIMARY'; -- Harshita for Bug 4889272
3060: lv_pan_att_code CONSTANT VARCHAR2(30) := 'PAN NO';
3061:
3062: /* rallamse for bug# 4336482 */
3063: p_challan_Start_Date DATE; --File.Sql.35 Cbabu DEFAULT fnd_date.canonical_to_date(pv_challan_Start_Date);
3064: p_challan_End_Date DATE; --File.Sql.35 Cbabu DEFAULT fnd_date.canonical_to_date(pv_challan_End_Date);
3065:
3066: -- to get financial and assessment years
3067: CURSOR c_fin_year(p_tan_number /*p_legal_entity_id*/ IN VARCHAR2, p_fin_year IN NUMBER, p_organization_id IN NUMBER ) IS

Line 3064: p_challan_End_Date DATE; --File.Sql.35 Cbabu DEFAULT fnd_date.canonical_to_date(pv_challan_End_Date);

3060: lv_pan_att_code CONSTANT VARCHAR2(30) := 'PAN NO';
3061:
3062: /* rallamse for bug# 4336482 */
3063: p_challan_Start_Date DATE; --File.Sql.35 Cbabu DEFAULT fnd_date.canonical_to_date(pv_challan_Start_Date);
3064: p_challan_End_Date DATE; --File.Sql.35 Cbabu DEFAULT fnd_date.canonical_to_date(pv_challan_End_Date);
3065:
3066: -- to get financial and assessment years
3067: CURSOR c_fin_year(p_tan_number /*p_legal_entity_id*/ IN VARCHAR2, p_fin_year IN NUMBER, p_organization_id IN NUMBER ) IS
3068: SELECT start_date, end_date

Line 3758: using fnd_date.canonical_to_date function.

3754: 8. 19/05/2005 rallamse for Bug#4336482, Version 116.2
3755: For SEED there is a change in concurrent to use FND_STANDARD_DATE with STANDARD_DATE format
3756: Procedure signature modified by converting DATE datatype
3757: to varchar2 datatype. The varchar2 values are converted to DATE fromat
3758: using fnd_date.canonical_to_date function.
3759:
3760: 9. 13/07/2007 CSahoo for bug#6158875, File Version 120.12
3761: replaced the AND with OR in the update statement.
3762:

Line 3832: p_challan_Start_Date := fnd_date.canonical_to_date(pv_challan_Start_Date);

3828: v_upload_type := 'R' ;
3829: v_file_creation_date := SYSDATE ;
3830: v_quarterlyOrYearly :='Y';
3831: v_conc_request_id := FND_PROFILE.value('CONC_REQUEST_ID') ;-- File.Sql.35 by Brathod
3832: p_challan_Start_Date := fnd_date.canonical_to_date(pv_challan_Start_Date);
3833: p_challan_End_Date := fnd_date.canonical_to_date(pv_challan_End_Date);
3834: v_line_number := 0;
3835: v_number_of_batches := 1;
3836: v_challan_cnt := 0;

Line 3833: p_challan_End_Date := fnd_date.canonical_to_date(pv_challan_End_Date);

3829: v_file_creation_date := SYSDATE ;
3830: v_quarterlyOrYearly :='Y';
3831: v_conc_request_id := FND_PROFILE.value('CONC_REQUEST_ID') ;-- File.Sql.35 by Brathod
3832: p_challan_Start_Date := fnd_date.canonical_to_date(pv_challan_Start_Date);
3833: p_challan_End_Date := fnd_date.canonical_to_date(pv_challan_End_Date);
3834: v_line_number := 0;
3835: v_number_of_batches := 1;
3836: v_challan_cnt := 0;
3837: v_deductee_cnt := 0;