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.IBY_FD_EXTRACT_GEN_PVT dependencies on IBY_FD_EXTRACT_GEN_PVT

Line 1: PACKAGE BODY IBY_FD_EXTRACT_GEN_PVT AS

1: PACKAGE BODY IBY_FD_EXTRACT_GEN_PVT AS
2: /* $Header: ibyfdxgb.pls 120.139.12020000.5 2013/03/04 11:34:10 jnallam ship $ */
3:
4:
5: --============================================================================

Line 395: IBY_FD_EXTRACT_GEN_PVT.G_FORMAT_TYPE := p_format_type;

391: iby_debug_pub.add(debug_msg => 'The extract mode is set to: G_EXTRACT_MODE_AMEX_REM',
392: debug_level => G_LEVEL_STATEMENT,
393: module => l_Debug_Module);
394: END IF;
395: IBY_FD_EXTRACT_GEN_PVT.G_FORMAT_TYPE := p_format_type;
396: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
397: iby_debug_pub.add(debug_msg => 'Format Type global variable is set to: AMEX_REMITTANCE_FILE',
398: debug_level => G_LEVEL_STATEMENT,
399: module => l_Debug_Module);

Line 4964: IBY_FD_EXTRACT_GEN_PVT.format_hz_address(hz_loc.location_id),

4960: CURSOR l_hz_addr_csr (p_location_id IN NUMBER) IS
4961: SELECT hz_loc.location_id , hz_loc.address1 , hz_loc.address2,
4962: hz_loc.address3 , hz_loc.address4 , hz_loc.city, hz_loc.county, hz_loc.state,
4963: hz_loc.province, hz_loc.country, te.iso_territory_code, te.territory_short_name, hz_loc.postal_code,
4964: IBY_FD_EXTRACT_GEN_PVT.format_hz_address(hz_loc.location_id),
4965: IBY_FD_EXTRACT_GEN_PVT.format_hz_address(hz_loc.location_id, 'POSTAL_ADDR')
4966: FROM hz_locations hz_loc,
4967: fnd_territories_vl te
4968: WHERE hz_loc.country = te.territory_code

Line 4965: IBY_FD_EXTRACT_GEN_PVT.format_hz_address(hz_loc.location_id, 'POSTAL_ADDR')

4961: SELECT hz_loc.location_id , hz_loc.address1 , hz_loc.address2,
4962: hz_loc.address3 , hz_loc.address4 , hz_loc.city, hz_loc.county, hz_loc.state,
4963: hz_loc.province, hz_loc.country, te.iso_territory_code, te.territory_short_name, hz_loc.postal_code,
4964: IBY_FD_EXTRACT_GEN_PVT.format_hz_address(hz_loc.location_id),
4965: IBY_FD_EXTRACT_GEN_PVT.format_hz_address(hz_loc.location_id, 'POSTAL_ADDR')
4966: FROM hz_locations hz_loc,
4967: fnd_territories_vl te
4968: WHERE hz_loc.country = te.territory_code
4969: AND location_id = p_location_id;

Line 5102: IBY_FD_EXTRACT_GEN_PVT.format_hz_address(hz_loc.location_id),

5098: CURSOR l_hz_addr_csr (p_location_id IN NUMBER) IS
5099: SELECT hz_loc.location_id , hz_loc.address1 , hz_loc.address2,
5100: hz_loc.address3 , hz_loc.address4 , hz_loc.city, hz_loc.county, hz_loc.state,
5101: hz_loc.province, hz_loc.country, te.iso_territory_code, te.territory_short_name, hz_loc.postal_code,
5102: IBY_FD_EXTRACT_GEN_PVT.format_hz_address(hz_loc.location_id),
5103: IBY_FD_EXTRACT_GEN_PVT.format_hz_address(hz_loc.location_id, 'POSTAL_ADDR')
5104: FROM hz_locations hz_loc,
5105: fnd_territories_vl te
5106: WHERE hz_loc.country = te.territory_code

Line 5103: IBY_FD_EXTRACT_GEN_PVT.format_hz_address(hz_loc.location_id, 'POSTAL_ADDR')

5099: SELECT hz_loc.location_id , hz_loc.address1 , hz_loc.address2,
5100: hz_loc.address3 , hz_loc.address4 , hz_loc.city, hz_loc.county, hz_loc.state,
5101: hz_loc.province, hz_loc.country, te.iso_territory_code, te.territory_short_name, hz_loc.postal_code,
5102: IBY_FD_EXTRACT_GEN_PVT.format_hz_address(hz_loc.location_id),
5103: IBY_FD_EXTRACT_GEN_PVT.format_hz_address(hz_loc.location_id, 'POSTAL_ADDR')
5104: FROM hz_locations hz_loc,
5105: fnd_territories_vl te
5106: WHERE hz_loc.country = te.territory_code
5107: AND location_id = p_location_id;

Line 5269: IBY_FD_EXTRACT_GEN_PVT.format_hr_address(hr_loc.location_id),

5265: SELECT hr_loc.location_id, hr_loc.address_line_1, hr_loc.address_line_2, hr_loc.address_line_3,
5266: hr_loc.town_or_city, DECODE(hr_loc.country, 'CA', NULL, hr_loc.region_1),
5267: DECODE(hr_loc.country, 'CA', NULL, hr_loc.region_2), hr_loc.country,
5268: te.iso_territory_code, te.territory_short_name, hr_loc.postal_code,
5269: IBY_FD_EXTRACT_GEN_PVT.format_hr_address(hr_loc.location_id),
5270: IBY_FD_EXTRACT_GEN_PVT.format_hr_address(hr_loc.location_id, 'POSTAL_ADDR'),
5271: hr_loc.location_code
5272: FROM hr_locations_all hr_loc, fnd_territories_vl te
5273: WHERE hr_loc.country = te.territory_code(+)

Line 5270: IBY_FD_EXTRACT_GEN_PVT.format_hr_address(hr_loc.location_id, 'POSTAL_ADDR'),

5266: hr_loc.town_or_city, DECODE(hr_loc.country, 'CA', NULL, hr_loc.region_1),
5267: DECODE(hr_loc.country, 'CA', NULL, hr_loc.region_2), hr_loc.country,
5268: te.iso_territory_code, te.territory_short_name, hr_loc.postal_code,
5269: IBY_FD_EXTRACT_GEN_PVT.format_hr_address(hr_loc.location_id),
5270: IBY_FD_EXTRACT_GEN_PVT.format_hr_address(hr_loc.location_id, 'POSTAL_ADDR'),
5271: hr_loc.location_code
5272: FROM hr_locations_all hr_loc, fnd_territories_vl te
5273: WHERE hr_loc.country = te.territory_code(+)
5274: AND location_id = p_location_id;

Line 5984: END IBY_FD_EXTRACT_GEN_PVT;

5980: FOR i in 1..32 LOOP
5981: l_conc_invalid_chars :=l_conc_invalid_chars||fnd_global.local_chr(i-1);
5982: l_conc_replacement_chars :=l_conc_replacement_chars||' ';
5983: END LOOP;
5984: END IBY_FD_EXTRACT_GEN_PVT;
5985: