APPS.GHR_PA_REQUESTS_PKG dependencies on PER_ADDRESSES

Line 904: PROCEDURE get_address_details (p_person_id IN per_addresses.person_id%TYPE

900: END get_SF52_loc_ddf_details;
901:
902:
903: --vms
904: PROCEDURE get_address_details (p_person_id IN per_addresses.person_id%TYPE
905: ,p_effective_date IN DATE
906: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE
907: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
908: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE

Line 906: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE

902:
903: --vms
904: PROCEDURE get_address_details (p_person_id IN per_addresses.person_id%TYPE
905: ,p_effective_date IN DATE
906: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE
907: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
908: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
909: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
910: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE

Line 907: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE

903: --vms
904: PROCEDURE get_address_details (p_person_id IN per_addresses.person_id%TYPE
905: ,p_effective_date IN DATE
906: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE
907: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
908: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
909: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
910: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE
911: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE

Line 908: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE

904: PROCEDURE get_address_details (p_person_id IN per_addresses.person_id%TYPE
905: ,p_effective_date IN DATE
906: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE
907: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
908: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
909: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
910: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE
911: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE
912: ,p_country OUT NOCOPY per_addresses.country%TYPE

Line 909: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE

905: ,p_effective_date IN DATE
906: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE
907: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
908: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
909: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
910: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE
911: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE
912: ,p_country OUT NOCOPY per_addresses.country%TYPE
913: ,p_territory_short_name OUT NOCOPY varchar2) IS

Line 910: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE

906: ,p_address_line1 OUT NOCOPY per_addresses.address_line1%TYPE
907: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
908: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
909: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
910: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE
911: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE
912: ,p_country OUT NOCOPY per_addresses.country%TYPE
913: ,p_territory_short_name OUT NOCOPY varchar2) IS
914: CURSOR cur_adr IS

Line 911: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE

907: ,p_address_line2 OUT NOCOPY per_addresses.address_line2%TYPE
908: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
909: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
910: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE
911: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE
912: ,p_country OUT NOCOPY per_addresses.country%TYPE
913: ,p_territory_short_name OUT NOCOPY varchar2) IS
914: CURSOR cur_adr IS
915: SELECT adr.address_line1

Line 912: ,p_country OUT NOCOPY per_addresses.country%TYPE

908: ,p_address_line3 OUT NOCOPY per_addresses.address_line3%TYPE
909: ,p_town_or_city OUT NOCOPY per_addresses.town_or_city%TYPE
910: ,p_region_2 OUT NOCOPY per_addresses.region_2%TYPE
911: ,p_postal_code OUT NOCOPY per_addresses.postal_code%TYPE
912: ,p_country OUT NOCOPY per_addresses.country%TYPE
913: ,p_territory_short_name OUT NOCOPY varchar2) IS
914: CURSOR cur_adr IS
915: SELECT adr.address_line1
916: ,adr.address_line2

Line 924: ,per_addresses adr

920: ,adr.postal_code
921: ,adr.country
922: ,ter.territory_short_name
923: FROM fnd_territories_vl ter
924: ,per_addresses adr
925: WHERE adr.person_id = p_person_id
926: AND adr.primary_flag = 'Y'
927: AND NVL(p_effective_date, TRUNC(sysdate))
928: BETWEEN adr.date_from AND NVL(adr.date_to,NVL(p_effective_date,TRUNC(sysdate)))