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

987: );
988: END create_deductee_detail;
989:
990: PROCEDURE create_fh(p_batch_id IN NUMBER) IS
991: v_req JAI_AP_ETDS_REQUESTS%rowtype;
992: BEGIN
993:
994: -- File Header
995: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;

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

991: v_req JAI_AP_ETDS_REQUESTS%rowtype;
992: BEGIN
993:
994: -- File Header
995: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
996:
997: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
998: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
999: UTL_FILE.PUT_LINE(v_filehandle,

Line 1059: v_req JAI_AP_ETDS_REQUESTS%rowtype;

1055: p_RespPers_email IN VARCHAR2 , -- Bug 6030953
1056: p_RespPersAddrChange IN VARCHAR2
1057: )
1058: IS
1059: v_req JAI_AP_ETDS_REQUESTS%rowtype;
1060: BEGIN
1061: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
1062:
1063: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');

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

1057: )
1058: IS
1059: v_req JAI_AP_ETDS_REQUESTS%rowtype;
1060: BEGIN
1061: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
1062:
1063: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
1064: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
1065: UTL_FILE.PUT_LINE(v_filehandle,

Line 3885: INSERT INTO JAI_AP_ETDS_REQUESTS(

3881: FND_FILE.put_line(FND_FILE.log, 'Tan Number length is greater than 10 characters');
3882: RAISE_APPLICATION_ERROR(-20014, 'Tan Number length is greater than 10 characters', true);
3883: END IF;
3884:
3885: INSERT INTO JAI_AP_ETDS_REQUESTS(
3886: batch_id, request_id,/* legal_entity_id, operating_unit_id,*/ org_tan_number, financial_year,
3887: tax_authority_id, tax_authority_site_id, organization_id,
3888: deductor_name, deductor_state, addr_changed_since_last_ret, deductor_status,
3889: person_resp_for_deduction, designation_of_pers_resp, challan_start_date,