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_GE_GEN_002 dependencies on IGS_AD_LOCATION

Line 517: -- Purpose: Function for returning formatted IGS_AD_LOCATION names and addresses

513: App_Exception.Raise_Exception ;
514: END genp_get_org_addr;
515: -------------------------------------------------------------------------------
516: -- Module: genp_get_loc_addr
517: -- Purpose: Function for returning formatted IGS_AD_LOCATION names and addresses
518: -- based on variations of the parameters passed
519: -- Notes:
520: -- p_phone_no is used to toggle the display of the phone number
521: -- Y populates the p_phone_line parameter with the phone number

Line 525: -- 'IGS_AD_LOCATION not found'

521: -- Y populates the p_phone_line parameter with the phone number
522: -- N populates the p_phone_line parameter with a null value
523: -- Exception Handlers
524: -- e_name_error: returns false and populates the p_name variable with
525: -- 'IGS_AD_LOCATION not found'
526: -- e_addr_error: returns false and populates p_line_1 with
527: -- 'No address record found'
528: -- Module History
529: -------------------------------------------------------------------------------

Line 548: -- cursor for selection of the IGS_AD_LOCATION name

544: p_line_5 OUT NOCOPY VARCHAR2,
545: p_phone_line OUT NOCOPY VARCHAR2)
546: RETURN BOOLEAN
547: AS
548: -- cursor for selection of the IGS_AD_LOCATION name
549: CURSOR c_loc_name (
550: cp_location_cd VARCHAR2)IS
551: SELECT loc.description loc_description
552: FROM IGS_AD_LOCATION loc

Line 552: FROM IGS_AD_LOCATION loc

548: -- cursor for selection of the IGS_AD_LOCATION name
549: CURSOR c_loc_name (
550: cp_location_cd VARCHAR2)IS
551: SELECT loc.description loc_description
552: FROM IGS_AD_LOCATION loc
553: WHERE loc.location_cd = cp_location_cd;
554: -- cursor for selection of the IGS_AD_LOCATION address when
555: -- only the loc_unit_cd is supplied
556: -- skpandey, Bug#3687111, Changed definition of cursor c_loc to optimize query

Line 554: -- cursor for selection of the IGS_AD_LOCATION address when

550: cp_location_cd VARCHAR2)IS
551: SELECT loc.description loc_description
552: FROM IGS_AD_LOCATION loc
553: WHERE loc.location_cd = cp_location_cd;
554: -- cursor for selection of the IGS_AD_LOCATION address when
555: -- only the loc_unit_cd is supplied
556: -- skpandey, Bug#3687111, Changed definition of cursor c_loc to optimize query
557: CURSOR c_loc(
558: cp_location_cd VARCHAR2)IS

Line 575: -- cursor for selection of the IGS_AD_LOCATION address when

571: AND LA.SOURCE_TYPE = 'L'
572: AND LA.LOCATION_VENUE_CD = cp_location_cd
573: AND LA.IDENTIFYING_ADDRESS_FLAG = 'Y' ;
574:
575: -- cursor for selection of the IGS_AD_LOCATION address when
576: -- only the location_cd and IGS_CO_ADDR_TYPE is supplied
577: -- skpandey, Bug#3687111, Changed definition of cursor c_loct to optimize query
578: CURSOR c_loct(
579: cp_location_cd VARCHAR2,

Line 604: e_addr_error EXCEPTION; -- IGS_AD_LOCATION address exception handler

600: v_name VARCHAR2(256) := NULL;
601: v_line_1 VARCHAR2(256) := NULL;
602: -- Local IGS_GE_EXCEPTIONS
603: e_name_error EXCEPTION; -- locationt name exception handler
604: e_addr_error EXCEPTION; -- IGS_AD_LOCATION address exception handler
605: BEGIN
606: -- test for open cursor, then loop and select the persons name
607: IF c_loc_name%ISOPEN THEN
608: CLOSE c_loc_name;