APPS.JAI_ETCS_PKG dependencies on JAI_AP_ETDS_REQUESTS

Line 40: 1. Table insertion JAI_AP_ETDS_REQUESTS , Missing Data related to WHO Columns

36: R12RUP03-ST1:ETCS REPORT RUNS INTO ERROR
37:
38: Code Fix -
39:
40: 1. Table insertion JAI_AP_ETDS_REQUESTS , Missing Data related to WHO Columns
41: 2. cursor c_pan_number is changed to get pan no .
42: 3. Cursor c_fin_year , Tan_number datatype changed from number to varchar2
43: 4. Cursor c_check_dtls ,c_bank_branch_code is changed
44:

Line 319: v_req JAI_AP_ETDS_REQUESTS%rowtype;

315: p_RespPersState IN VARCHAR2,
316: p_RespPersPin IN NUMBER,
317: p_RespPersAddrChange IN VARCHAR2
318: ) IS
319: v_req JAI_AP_ETDS_REQUESTS%rowtype;
320: BEGIN
321:
322: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
323: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');

Line 322: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;

318: ) IS
319: v_req JAI_AP_ETDS_REQUESTS%rowtype;
320: BEGIN
321:
322: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
323: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
324: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
325: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
326: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)

Line 2101: v_req JAI_AP_ETDS_REQUESTS%rowtype;

2097: END create_dd;
2098:
2099:
2100: PROCEDURE create_fh(p_batch_id IN NUMBER) IS
2101: v_req JAI_AP_ETDS_REQUESTS%rowtype;
2102: BEGIN
2103:
2104: -- File Header
2105: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;

Line 2105: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;

2101: v_req JAI_AP_ETDS_REQUESTS%rowtype;
2102: BEGIN
2103:
2104: -- File Header
2105: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
2106:
2107: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
2108: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
2109: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

Line 3230: INSERT INTO JAI_AP_ETDS_REQUESTS(

3226:
3227: -- Date 26/05/2007 by sacsethi for bug 6153881
3228: -- Mark Legal_Entity_id as null
3229:
3230: INSERT INTO JAI_AP_ETDS_REQUESTS(
3231: batch_id, request_id, legal_entity_id , org_tan_number, financial_year,
3232: tax_authority_id, tax_authority_site_id, organization_id,
3233: deductor_name, deductor_state, addr_changed_since_last_ret,
3234: --deductor_status, /*Bug 8880543 - Commented Deductor Status for eTDS/eTCS FVU Changes*/