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.

[Home] [Help]

APPS.IGS_OR_INST_IMP_003_PKG dependencies on IGS_OR_ADR_INT

Line 1496: p_interface_id IN igs_or_adr_int.interface_id%TYPE,

1492:
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

Line 1536: CURSOR cur_get_int_addr(cp_interface_id igs_or_adr_int.interface_id%TYPE,

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';
1535: --Cursor to fetch the Interface Address Master Records for the Interface Identifier
1536: CURSOR cur_get_int_addr(cp_interface_id igs_or_adr_int.interface_id%TYPE,
1537: cp_status igs_or_adr_int.status%TYPE) IS
1538: SELECT *
1539: FROM igs_or_adr_int
1540: WHERE interface_id =cp_interface_id

Line 1537: cp_status igs_or_adr_int.status%TYPE) IS

1533: l_location_ovn hz_locations.object_version_number%TYPE;
1534: l_addr_warning VARCHAR2(1) := 'N';
1535: --Cursor to fetch the Interface Address Master Records for the Interface Identifier
1536: CURSOR cur_get_int_addr(cp_interface_id igs_or_adr_int.interface_id%TYPE,
1537: cp_status igs_or_adr_int.status%TYPE) IS
1538: SELECT *
1539: FROM igs_or_adr_int
1540: WHERE interface_id =cp_interface_id
1541: AND status = cp_status ;

Line 1539: FROM igs_or_adr_int

1535: --Cursor to fetch the Interface Address Master Records for the Interface Identifier
1536: CURSOR cur_get_int_addr(cp_interface_id igs_or_adr_int.interface_id%TYPE,
1537: cp_status igs_or_adr_int.status%TYPE) IS
1538: SELECT *
1539: FROM igs_or_adr_int
1540: WHERE interface_id =cp_interface_id
1541: AND status = cp_status ;
1542:
1543: --Cursor to get the Count of Address Usages from the Interface for an Address ID

Line 1544: CURSOR cur_get_usage_count(p_int_addr_id igs_or_adr_int.interface_addr_id%TYPE,

1540: WHERE interface_id =cp_interface_id
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

Line 1552: CURSOR cur_get_addr_usage(p_int_addr_id igs_or_adr_int.interface_addr_id%TYPE,

1548: WHERE interface_addr_id = p_int_addr_id
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

Line 1560: CURSOR cur_get_oss_addr(p_int_addr_rec igs_or_adr_int%ROWTYPE,cp_party_id hz_parties.party_id%TYPE) IS

1556: WHERE interface_addr_id = p_int_addr_id
1557: AND status = cp_status;
1558:
1559: --Cursor to check the Duplicate Address
1560: CURSOR cur_get_oss_addr(p_int_addr_rec igs_or_adr_int%ROWTYPE,cp_party_id hz_parties.party_id%TYPE) IS
1561: SELECT party_site_id
1562: FROM hz_party_sites hp,
1563: hz_locations addr
1564: WHERE hp.location_id = addr.location_id

Line 1586: CURSOR c_adr_val(p_country igs_or_adr_int.country%TYPE) IS

1582: WHERE party_site_id = cp_party_site_id
1583: AND site_use_type = cp_addr_usage;
1584:
1585: --cursor added to validate country field in address interface table
1586: CURSOR c_adr_val(p_country igs_or_adr_int.country%TYPE) IS
1587: SELECT 'X'
1588: FROM fnd_territories
1589: WHERE territory_code= p_country;
1590:

Line 1594: PROCEDURE update_address_int(p_interface_id igs_or_adr_int.interface_id%TYPE,

1590:
1591: c_adr_val_rec c_adr_val%ROWTYPE;
1592:
1593: --Procedure to update the Interface Address Status
1594: PROCEDURE update_address_int(p_interface_id igs_or_adr_int.interface_id%TYPE,
1595: p_addr_id igs_or_adr_int.interface_addr_id%TYPE,
1596: p_status igs_or_adr_int.status%TYPE,
1597: p_err_cd igs_or_adr_int.error_code%TYPE,
1598: p_err_txt igs_or_adr_int.error_text%TYPE,

Line 1595: p_addr_id igs_or_adr_int.interface_addr_id%TYPE,

1591: c_adr_val_rec c_adr_val%ROWTYPE;
1592:
1593: --Procedure to update the Interface Address Status
1594: PROCEDURE update_address_int(p_interface_id igs_or_adr_int.interface_id%TYPE,
1595: p_addr_id igs_or_adr_int.interface_addr_id%TYPE,
1596: p_status igs_or_adr_int.status%TYPE,
1597: p_err_cd igs_or_adr_int.error_code%TYPE,
1598: p_err_txt igs_or_adr_int.error_text%TYPE,
1599: p_which_tab VARCHAR2)

Line 1596: p_status igs_or_adr_int.status%TYPE,

1592:
1593: --Procedure to update the Interface Address Status
1594: PROCEDURE update_address_int(p_interface_id igs_or_adr_int.interface_id%TYPE,
1595: p_addr_id igs_or_adr_int.interface_addr_id%TYPE,
1596: p_status igs_or_adr_int.status%TYPE,
1597: p_err_cd igs_or_adr_int.error_code%TYPE,
1598: p_err_txt igs_or_adr_int.error_text%TYPE,
1599: p_which_tab VARCHAR2)
1600: AS

Line 1597: p_err_cd igs_or_adr_int.error_code%TYPE,

1593: --Procedure to update the Interface Address Status
1594: PROCEDURE update_address_int(p_interface_id igs_or_adr_int.interface_id%TYPE,
1595: p_addr_id igs_or_adr_int.interface_addr_id%TYPE,
1596: p_status igs_or_adr_int.status%TYPE,
1597: p_err_cd igs_or_adr_int.error_code%TYPE,
1598: p_err_txt igs_or_adr_int.error_text%TYPE,
1599: p_which_tab VARCHAR2)
1600: AS
1601:

Line 1598: p_err_txt igs_or_adr_int.error_text%TYPE,

1594: PROCEDURE update_address_int(p_interface_id igs_or_adr_int.interface_id%TYPE,
1595: p_addr_id igs_or_adr_int.interface_addr_id%TYPE,
1596: p_status igs_or_adr_int.status%TYPE,
1597: p_err_cd igs_or_adr_int.error_code%TYPE,
1598: p_err_txt igs_or_adr_int.error_text%TYPE,
1599: p_which_tab VARCHAR2)
1600: AS
1601:
1602: BEGIN

Line 1605: UPDATE igs_or_adr_int

1601:
1602: BEGIN
1603: --Update the status of address record
1604: IF p_which_tab IN ('adr','both')THEN
1605: UPDATE igs_or_adr_int
1606: SET status = p_status ,
1607: error_code = p_err_cd ,
1608: error_text = p_err_txt
1609: WHERE interface_id = p_interface_id

Line 1650: PROCEDURE insert_addr_usage(p_interface_id igs_or_adr_int.interface_id%TYPE,

1646:
1647: END update_address_int;
1648:
1649: --Procedure to Insert the Address Usage for the address
1650: PROCEDURE insert_addr_usage(p_interface_id igs_or_adr_int.interface_id%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

Line 1651: p_int_addr_id igs_or_adr_int.interface_addr_id%TYPE)

1647: END update_address_int;
1648:
1649: --Procedure to Insert the Address Usage for the address
1650: PROCEDURE insert_addr_usage(p_interface_id igs_or_adr_int.interface_id%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,