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 4736: ld_challan_start_date := fnd_date.canonical_to_date(p_challan_Start_Date); --added by csahoo for bug#6158875

4732: /* Bug 13323753 -End */
4733: BEGIN
4734:
4735: l_prg_id:=FND_GLOBAL.CONC_PROGRAM_ID;
4736: ld_challan_start_date := fnd_date.canonical_to_date(p_challan_Start_Date); --added by csahoo for bug#6158875
4737: ld_challan_end_date := fnd_date.canonical_to_date(p_challan_End_Date); --added by csahoo for bug#6158875
4738:
4739: open c_prg_name(l_prg_id);
4740: fetch c_prg_name into l_prg_name;

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

4733: BEGIN
4734:
4735: l_prg_id:=FND_GLOBAL.CONC_PROGRAM_ID;
4736: ld_challan_start_date := fnd_date.canonical_to_date(p_challan_Start_Date); --added by csahoo for bug#6158875
4737: ld_challan_end_date := fnd_date.canonical_to_date(p_challan_End_Date); --added by csahoo for bug#6158875
4738:
4739: open c_prg_name(l_prg_id);
4740: fetch c_prg_name into l_prg_name;
4741: close c_prg_name;

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

4886: ld_challan_start_date DATE;
4887: ld_challan_end_date DATE;
4888: BEGIN
4889:
4890: ld_challan_start_date := fnd_date.canonical_to_date(p_challan_Start_Date); --added by csahoo for bug#6158875
4891: ld_challan_end_date := fnd_date.canonical_to_date(p_challan_End_Date); --added by csahoo for bug#6158875
4892: generate_etds_returns
4893: (
4894: p_err_buf => p_err_buf ,

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

4887: ld_challan_end_date DATE;
4888: BEGIN
4889:
4890: ld_challan_start_date := fnd_date.canonical_to_date(p_challan_Start_Date); --added by csahoo for bug#6158875
4891: ld_challan_end_date := fnd_date.canonical_to_date(p_challan_End_Date); --added by csahoo for bug#6158875
4892: generate_etds_returns
4893: (
4894: p_err_buf => p_err_buf ,
4895: p_ret_code => p_ret_code ,

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

4969: lv_prim_att_type CONSTANT VARCHAR2(30) := 'OTHERS' ; -- 'PRIMARY'; -- Harshita for Bug 4889272
4970: lv_pan_att_code CONSTANT VARCHAR2(30) := 'PAN NO';
4971:
4972: /* rallamse for bug# 4336482 */
4973: p_challan_Start_Date DATE; --File.Sql.35 Cbabu DEFAULT fnd_date.canonical_to_date(pv_challan_Start_Date);
4974: p_challan_End_Date DATE; --File.Sql.35 Cbabu DEFAULT fnd_date.canonical_to_date(pv_challan_End_Date);
4975:
4976: /*Update to get fin year info from regime definition for eTDS bug#16414088
4977: -- to get financial and assessment years

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

4970: lv_pan_att_code CONSTANT VARCHAR2(30) := 'PAN NO';
4971:
4972: /* rallamse for bug# 4336482 */
4973: p_challan_Start_Date DATE; --File.Sql.35 Cbabu DEFAULT fnd_date.canonical_to_date(pv_challan_Start_Date);
4974: p_challan_End_Date DATE; --File.Sql.35 Cbabu DEFAULT fnd_date.canonical_to_date(pv_challan_End_Date);
4975:
4976: /*Update to get fin year info from regime definition for eTDS bug#16414088
4977: -- to get financial and assessment years
4978: 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 6242: using fnd_date.canonical_to_date function.

6238: 8. 19/05/2005 rallamse for Bug#4336482, Version 116.2
6239: For SEED there is a change in concurrent to use FND_STANDARD_DATE with STANDARD_DATE format
6240: Procedure signature modified by converting DATE datatype
6241: to varchar2 datatype. The varchar2 values are converted to DATE fromat
6242: using fnd_date.canonical_to_date function.
6243:
6244: 9. 13/07/2007 CSahoo for bug#6158875, File Version 120.12
6245: replaced the AND with OR in the update statement.
6246:

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

6321: v_upload_type := 'R' ;
6322: v_file_creation_date := SYSDATE ;
6323: v_quarterlyOrYearly :='Y';
6324: v_conc_request_id := FND_PROFILE.value('CONC_REQUEST_ID') ;-- File.Sql.35 by Brathod
6325: p_challan_Start_Date := fnd_date.canonical_to_date(pv_challan_Start_Date);
6326: p_challan_End_Date := fnd_date.canonical_to_date(pv_challan_End_Date);
6327: v_line_number := 0;
6328: v_number_of_batches := 1;
6329: v_challan_cnt := 0;

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

6322: v_file_creation_date := SYSDATE ;
6323: v_quarterlyOrYearly :='Y';
6324: v_conc_request_id := FND_PROFILE.value('CONC_REQUEST_ID') ;-- File.Sql.35 by Brathod
6325: p_challan_Start_Date := fnd_date.canonical_to_date(pv_challan_Start_Date);
6326: p_challan_End_Date := fnd_date.canonical_to_date(pv_challan_End_Date);
6327: v_line_number := 0;
6328: v_number_of_batches := 1;
6329: v_challan_cnt := 0;
6330: v_deductee_cnt := 0;