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.IGS_OR_INST_IMP_003_PKG dependencies on IGS_OR_ADRUSGE_INT

Line 1497: p_addr_usage IN igs_or_adrusge_int.site_use_code%TYPE,

1493:
1494: --Procedure to process the Institution Addresses
1495: PROCEDURE process_institution_address (
1496: p_interface_id IN igs_or_adr_int.interface_id%TYPE,
1497: p_addr_usage IN igs_or_adrusge_int.site_use_code%TYPE,
1498: p_party_id IN hz_parties.party_id%TYPE)
1499: /***************************************************************
1500: Created By : mesriniv
1501: Date Created By : 2001/07/12

Line 1514: l_addr_usage igs_or_adrusge_int.site_use_code%TYPE;

1510: pkpatel 15-MAR-2002 Bug no.2238946 :Added the parameter p_status in the call to igs_pe_party_site_use_pkg
1511: asbala 12-nov-03 3227107: address changes - signature of igs_pe_person_addr_pkg.insert_row changed
1512: ***************************************************************/
1513: AS
1514: l_addr_usage igs_or_adrusge_int.site_use_code%TYPE;
1515: l_existing_usage igs_or_adrusge_int.site_use_code%TYPE;
1516: l_location_id hz_locations.location_id%TYPE;
1517: l_date DATE;
1518: l_addr_success BOOLEAN;

Line 1515: l_existing_usage igs_or_adrusge_int.site_use_code%TYPE;

1511: asbala 12-nov-03 3227107: address changes - signature of igs_pe_person_addr_pkg.insert_row changed
1512: ***************************************************************/
1513: AS
1514: l_addr_usage igs_or_adrusge_int.site_use_code%TYPE;
1515: l_existing_usage igs_or_adrusge_int.site_use_code%TYPE;
1516: l_location_id hz_locations.location_id%TYPE;
1517: l_date DATE;
1518: l_addr_success BOOLEAN;
1519: l_addr_process BOOLEAN := FALSE;

Line 1530: l_party_site_use_id igs_or_adrusge_int.interface_addrusage_id%TYPE;

1526: l_msg_data VARCHAR2(1000);
1527: l_addr_row_id VARCHAR2(25);
1528: l_usage_row_id VARCHAR2(25);
1529: l_party_site_id hz_party_sites.party_site_id%TYPE;
1530: l_party_site_use_id igs_or_adrusge_int.interface_addrusage_id%TYPE;
1531: SKIP_ADDR EXCEPTION;
1532: l_party_site_ovn hz_party_sites.object_version_number%TYPE;
1533: l_location_ovn hz_locations.object_version_number%TYPE;
1534: l_addr_warning VARCHAR2(1) := 'N';

Line 1545: cp_status igs_or_adrusge_int.status%TYPE) IS

1541: AND status = cp_status ;
1542:
1543: --Cursor to get the Count of Address Usages from the Interface for an Address ID
1544: CURSOR cur_get_usage_count(p_int_addr_id igs_or_adr_int.interface_addr_id%TYPE,
1545: cp_status igs_or_adrusge_int.status%TYPE) IS
1546: SELECT COUNT(interface_addrusage_id)
1547: FROM igs_or_adrusge_int
1548: WHERE interface_addr_id = p_int_addr_id
1549: AND status = cp_status;

Line 1547: FROM igs_or_adrusge_int

1543: --Cursor to get the Count of Address Usages from the Interface for an Address ID
1544: CURSOR cur_get_usage_count(p_int_addr_id igs_or_adr_int.interface_addr_id%TYPE,
1545: cp_status igs_or_adrusge_int.status%TYPE) IS
1546: SELECT COUNT(interface_addrusage_id)
1547: FROM igs_or_adrusge_int
1548: WHERE interface_addr_id = p_int_addr_id
1549: AND status = cp_status;
1550:
1551: --Cursor to fetch the Address Usage

Line 1553: cp_status igs_or_adrusge_int.status%TYPE) IS

1549: AND status = cp_status;
1550:
1551: --Cursor to fetch the Address Usage
1552: CURSOR cur_get_addr_usage(p_int_addr_id igs_or_adr_int.interface_addr_id%TYPE,
1553: cp_status igs_or_adrusge_int.status%TYPE) IS
1554: SELECT UPPER(site_use_code)
1555: FROM igs_or_adrusge_int
1556: WHERE interface_addr_id = p_int_addr_id
1557: AND status = cp_status;

Line 1555: FROM igs_or_adrusge_int

1551: --Cursor to fetch the Address Usage
1552: CURSOR cur_get_addr_usage(p_int_addr_id igs_or_adr_int.interface_addr_id%TYPE,
1553: cp_status igs_or_adrusge_int.status%TYPE) IS
1554: SELECT UPPER(site_use_code)
1555: FROM igs_or_adrusge_int
1556: WHERE interface_addr_id = p_int_addr_id
1557: AND status = cp_status;
1558:
1559: --Cursor to check the Duplicate Address

Line 1579: cp_addr_usage igs_or_adrusge_int.site_use_code%TYPE) IS

1575: AND NVL(addr.postal_code,' ') = NVL(p_int_addr_rec.postcode,' ');
1576:
1577: --Cursor to fetch the existing address usage
1578: CURSOR cur_get_usage(cp_party_site_id hz_party_sites.party_site_id%TYPE,
1579: cp_addr_usage igs_or_adrusge_int.site_use_code%TYPE) IS
1580: SELECT site_use_type
1581: FROM hz_party_site_uses
1582: WHERE party_site_id = cp_party_site_id
1583: AND site_use_type = cp_addr_usage;

Line 1628: UPDATE igs_or_adrusge_int

1624: END IF;
1625:
1626: --Update the status of address usage record
1627: IF p_which_tab IN ('adr_usg','both')THEN
1628: UPDATE igs_or_adrusge_int
1629: SET status = p_status , error_code = p_err_cd , error_text = p_err_txt
1630: WHERE interface_addr_id= p_addr_id;
1631:
1632: --put this information about the failed record in the log file too

Line 1655: CURSOR c_val_addr_usage(p_site_use_code igs_or_adrusge_int.site_use_code%TYPE,

1651: p_int_addr_id igs_or_adr_int.interface_addr_id%TYPE)
1652: AS
1653:
1654: --cursor added to validate if the site use code in interface table is present in fnd_lookups
1655: CURSOR c_val_addr_usage(p_site_use_code igs_or_adrusge_int.site_use_code%TYPE,
1656: cp_lookup_typ fnd_lookup_values.lookup_type%TYPE,
1657: cp_enabled_flag fnd_lookup_values.enabled_flag%TYPE) IS
1658: SELECT 'X'
1659: FROM fnd_lookup_values