eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_TDS_ETDS_PKG dependencies on FND_GLOBAL

Line 538: fnd_global.user_id,

534: 1,
535: a.check_id,
536: base_invoices.invoice_date,
537: -- added, Harshita for Bug 4866533
538: fnd_global.user_id,
539: sysdate,
540: fnd_global.user_id,
541: sysdate
542: from JAI_AP_TDS_INV_PAYMENTS a, ap_invoices_all base_invoices, ap_invoices_all tds_invoices

Line 540: fnd_global.user_id,

536: base_invoices.invoice_date,
537: -- added, Harshita for Bug 4866533
538: fnd_global.user_id,
539: sysdate,
540: fnd_global.user_id,
541: sysdate
542: from JAI_AP_TDS_INV_PAYMENTS a, ap_invoices_all base_invoices, ap_invoices_all tds_invoices
543: where a.parent_invoice_id = base_invoices.invoice_id
544: and a.invoice_id = tds_invoices.invoice_id

Line 1000: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)

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,
1000: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
1001: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
1002: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
1003: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
1004: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)

Line 1001: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)

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,
1000: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
1001: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
1002: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
1003: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
1004: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
1005: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)

Line 1002: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)

998: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
999: UTL_FILE.PUT_LINE(v_filehandle,
1000: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
1001: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
1002: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
1003: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
1004: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
1005: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
1006: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)

Line 1003: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)

999: UTL_FILE.PUT_LINE(v_filehandle,
1000: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
1001: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
1002: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
1003: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
1004: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
1005: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
1006: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
1007: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)

Line 1004: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)

1000: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
1001: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
1002: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
1003: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
1004: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
1005: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
1006: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
1007: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
1008: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)

Line 1005: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)

1001: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
1002: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
1003: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
1004: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
1005: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
1006: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
1007: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
1008: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
1009: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)

Line 1006: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)

1002: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
1003: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
1004: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
1005: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
1006: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
1007: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
1008: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
1009: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
1010: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)

Line 1007: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)

1003: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
1004: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
1005: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
1006: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
1007: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
1008: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
1009: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
1010: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
1011: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)

Line 1008: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)

1004: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
1005: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
1006: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
1007: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
1008: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
1009: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
1010: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
1011: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
1012: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)

Line 1009: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)

1005: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
1006: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
1007: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
1008: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
1009: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
1010: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
1011: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
1012: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
1013: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)

Line 1010: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)

1006: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
1007: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
1008: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
1009: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
1010: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
1011: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
1012: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
1013: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
1014: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)

Line 1011: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)

1007: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
1008: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
1009: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
1010: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
1011: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
1012: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
1013: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
1014: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
1015: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)

Line 1012: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)

1008: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
1009: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
1010: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
1011: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
1012: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
1013: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
1014: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
1015: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
1016: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)

Line 1013: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)

1009: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
1010: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
1011: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
1012: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
1013: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
1014: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
1015: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
1016: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
1017: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)

Line 1014: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)

1010: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
1011: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
1012: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
1013: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
1014: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
1015: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
1016: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
1017: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
1018: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)

Line 1015: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)

1011: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
1012: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
1013: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
1014: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
1015: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
1016: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
1017: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
1018: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
1019: );

Line 1016: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)

1012: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
1013: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
1014: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
1015: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
1016: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
1017: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
1018: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
1019: );
1020:

Line 1017: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)

1013: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
1014: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
1015: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
1016: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
1017: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
1018: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
1019: );
1020:
1021:

Line 1018: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)

1014: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
1015: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
1016: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
1017: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
1018: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
1019: );
1020:
1021:
1022: UTL_FILE.PUT_LINE(v_filehandle,

Line 1141: UTL_FILE.PUT_LINE(v_filehandle, fnd_global.local_chr(10) );

1137: PROCEDURE create_bh IS
1138: BEGIN
1139:
1140: -- Batch Header
1141: UTL_FILE.PUT_LINE(v_filehandle, fnd_global.local_chr(10) );
1142: UTL_FILE.PUT_LINE(v_filehandle,
1143: LPAD('LineNo', s_line_number, v_pad_char)
1144: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
1145: ||v_pad_char||LPAD('BNo', s_batch_number, v_pad_char)

Line 1491: UTL_FILE.PUT_LINE(v_filehandle, fnd_global.local_chr(10) );

1487: PROCEDURE create_cd IS
1488: BEGIN
1489:
1490: -- Challan Detail
1491: UTL_FILE.PUT_LINE(v_filehandle, fnd_global.local_chr(10) );
1492: UTL_FILE.PUT_LINE(v_filehandle,
1493: LPAD('LineNo', s_line_number, v_pad_char)
1494: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
1495: ||v_pad_char||LPAD('B.No', s_batch_number, v_pad_char)

Line 2852: l_prg_id:=FND_GLOBAL.CONC_PROGRAM_ID;

2848: ld_challan_start_date DATE; --added by csahoo for bug#6158875
2849: ld_challan_end_date DATE; --added by csahoo for bug#6158875
2850: BEGIN
2851:
2852: l_prg_id:=FND_GLOBAL.CONC_PROGRAM_ID;
2853: ld_challan_start_date := fnd_date.canonical_to_date(p_challan_Start_Date); --added by csahoo for bug#6158875
2854: ld_challan_end_date := fnd_date.canonical_to_date(p_challan_End_Date); --added by csahoo for bug#6158875
2855:
2856: open c_prg_name(l_prg_id);

Line 3902: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate

3898: p_persRespForDeduction, p_desgOfPersResponsible, p_challan_Start_Date,
3899: p_challan_End_Date, p_file_path, p_filename,
3900: fnd_profile.value('PROG_APPL_ID'), fnd_profile.value('CONC_PROGRAM_ID'), fnd_profile.value('CONC_LOGIN_ID'),
3901: -- added, Harshita for Bug 4866533
3902: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate
3903: );
3904:
3905: FOR k IN c_organization_id(p_tan_number) LOOP
3906: