5673: -- used variables
5674: --v_vendor_name PO_VENDORS.vendor_name%TYPE;
5675: v_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
5676: v_error_message VARCHAR2(100);
5677: v_conc_request_id NUMBER(15); -- := FND_PROFILE.value('CONC_REQUEST_ID'); File.Sql.35 by Brathod
5678: v_statement_id VARCHAR2(3) ; --:= '0'; File.Sql.35 by Brathod
5679:
5680: v_start_date DATE;
5681: v_end_date DATE;
6320:
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;
6468: p_addrChangedSinceLastRet,
6469: --p_deductor_status, /*Bug 8880543 - Commented for eTDS/eTCS FVU Changes*/
6470: p_persRespForDeduction, p_desgOfPersResponsible,
6471: p_challan_Start_Date, p_challan_End_Date, p_file_path, p_filename,
6472: fnd_profile.value('PROG_APPL_ID'), fnd_profile.value('CONC_PROGRAM_ID'), fnd_profile.value('CONC_LOGIN_ID'),
6473: -- added, Harshita for Bug 4866533
6474: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate
6475: );
6476: