APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_AP_ETDS_REQUESTS

Line 52: added the who columns in the insert into tables JAI_AP_ETDS_REQUESTS and JAI_AP_ETDS_T.

48: 9. 17-Aug-2005 Ramananda for bug#4555466 during R12 Sanity Testing. File Version 120.2
49: Instead of fnd_common_lookups table, ja_lookups table is being referred
50:
51: 10 07/12/2005 Hjujjuru for the bug 4866533 File version 120.3
52: added the who columns in the insert into tables JAI_AP_ETDS_REQUESTS and JAI_AP_ETDS_T.
53: Dependencies Due to this bug:-
54: None
55:
56: 11 23/12/2005 Hjujjuru for Bug 4889272, File Version 120.4

Line 2624: v_req JAI_AP_ETDS_REQUESTS%rowtype;

2620: );
2621: END create_deductee_detail;
2622:
2623: PROCEDURE create_fh(p_batch_id IN NUMBER) IS
2624: v_req JAI_AP_ETDS_REQUESTS%rowtype;
2625: BEGIN
2626:
2627: -- File Header
2628: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;

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

2624: v_req JAI_AP_ETDS_REQUESTS%rowtype;
2625: BEGIN
2626:
2627: -- File Header
2628: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
2629:
2630: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
2631: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
2632: UTL_FILE.PUT_LINE(v_filehandle,

Line 2692: v_req JAI_AP_ETDS_REQUESTS%rowtype;

2688: p_RespPers_email IN VARCHAR2 , -- Bug 6030953
2689: p_RespPersAddrChange IN VARCHAR2
2690: )
2691: IS
2692: v_req JAI_AP_ETDS_REQUESTS%rowtype;
2693: BEGIN
2694: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
2695:
2696: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');

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

2690: )
2691: IS
2692: v_req JAI_AP_ETDS_REQUESTS%rowtype;
2693: BEGIN
2694: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
2695:
2696: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
2697: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
2698: UTL_FILE.PUT_LINE(v_filehandle,

Line 6451: INSERT INTO JAI_AP_ETDS_REQUESTS(

6447: FETCH c_split_phone_no INTO v_RespPerson_stdCode, v_RespPerson_ph_no;
6448: CLOSE c_split_phone_no;
6449: /*Bug 10315928 - End*/
6450: /*ETDS FVU3.1 Bug 11896260 END*/
6451: INSERT INTO JAI_AP_ETDS_REQUESTS(
6452: batch_id, request_id,/* legal_entity_id, operating_unit_id,*/ org_tan_number, financial_year,
6453: tax_authority_id, tax_authority_site_id, organization_id,
6454: deductor_name,
6455: deductor_state,