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 95: v_req JAI_AP_ETDS_REQUESTS%rowtype;

91: p_RespPersState IN VARCHAR2,
92: p_RespPersPin IN NUMBER,
93: p_RespPersAddrChange IN VARCHAR2
94: ) IS
95: v_req JAI_AP_ETDS_REQUESTS%rowtype;
96: BEGIN
97:
98: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
99: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');

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

94: ) IS
95: v_req JAI_AP_ETDS_REQUESTS%rowtype;
96: BEGIN
97:
98: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
99: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
100: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
101: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
102: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)

Line 1670: v_req JAI_AP_ETDS_REQUESTS%rowtype;

1666: END create_dd;
1667:
1668:
1669: PROCEDURE create_fh(p_batch_id IN NUMBER) IS
1670: v_req JAI_AP_ETDS_REQUESTS%rowtype;
1671: BEGIN
1672:
1673: -- File Header
1674: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;

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

1670: v_req JAI_AP_ETDS_REQUESTS%rowtype;
1671: BEGIN
1672:
1673: -- File Header
1674: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
1675:
1676: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
1677: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
1678: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

Line 2724: INSERT INTO JAI_AP_ETDS_REQUESTS(

2720:
2721: -- Date 26/05/2007 by sacsethi for bug 6153881
2722: -- Mark Legal_Entity_id as null
2723:
2724: INSERT INTO JAI_AP_ETDS_REQUESTS(
2725: batch_id, request_id, legal_entity_id , org_tan_number, financial_year,
2726: tax_authority_id, tax_authority_site_id, organization_id,
2727: deductor_name, deductor_state, addr_changed_since_last_ret, deductor_status,
2728: person_resp_for_deduction, designation_of_pers_resp, challan_start_date,