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

Line 2194: l_loc igs_ad_location.location_cd%TYPE;

2190: p_program_cd IN VARCHAR2,
2191: p_term_cal_type IN VARCHAR2,
2192: p_term_sequence_NUMBER IN NUMBER
2193: ) RETURN VARCHAR2 AS
2194: l_loc igs_ad_location.location_cd%TYPE;
2195: l_loc_desc igs_ad_location.description%TYPE;
2196: CURSOR c_loc_desc (cp_loc igs_ad_location.location_cd%TYPE) IS
2197: SELECT description
2198: FROM igs_ad_location

Line 2195: l_loc_desc igs_ad_location.description%TYPE;

2191: p_term_cal_type IN VARCHAR2,
2192: p_term_sequence_NUMBER IN NUMBER
2193: ) RETURN VARCHAR2 AS
2194: l_loc igs_ad_location.location_cd%TYPE;
2195: l_loc_desc igs_ad_location.description%TYPE;
2196: CURSOR c_loc_desc (cp_loc igs_ad_location.location_cd%TYPE) IS
2197: SELECT description
2198: FROM igs_ad_location
2199: WHERE location_cd = cp_loc;

Line 2196: CURSOR c_loc_desc (cp_loc igs_ad_location.location_cd%TYPE) IS

2192: p_term_sequence_NUMBER IN NUMBER
2193: ) RETURN VARCHAR2 AS
2194: l_loc igs_ad_location.location_cd%TYPE;
2195: l_loc_desc igs_ad_location.description%TYPE;
2196: CURSOR c_loc_desc (cp_loc igs_ad_location.location_cd%TYPE) IS
2197: SELECT description
2198: FROM igs_ad_location
2199: WHERE location_cd = cp_loc;
2200:

Line 2198: FROM igs_ad_location

2194: l_loc igs_ad_location.location_cd%TYPE;
2195: l_loc_desc igs_ad_location.description%TYPE;
2196: CURSOR c_loc_desc (cp_loc igs_ad_location.location_cd%TYPE) IS
2197: SELECT description
2198: FROM igs_ad_location
2199: WHERE location_cd = cp_loc;
2200:
2201: BEGIN
2202: l_loc := get_spat_location(