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_AU_GEN_004 dependencies on IGS_PS_UNIT_REF_HIST

Line 175: p_unit_cd IGS_PS_UNIT_REF_HIST_ALL.unit_cd%TYPE ,

171: END;
172: END audp_get_uiclh_col;
173:
174: Function Audp_Get_Urch_Col(
175: p_unit_cd IGS_PS_UNIT_REF_HIST_ALL.unit_cd%TYPE ,
176: p_version_number IGS_PS_UNIT_REF_HIST_ALL.version_number%TYPE ,
177: p_reference_cd_type IGS_PS_UNIT_REF_HIST_ALL.reference_cd_type%TYPE ,
178: p_reference_cd IGS_PS_UNIT_REF_HIST_ALL.reference_cd%TYPE ,
179: p_hist_date IGS_PS_UNIT_REF_HIST_ALL.hist_start_dt%TYPE )

Line 176: p_version_number IGS_PS_UNIT_REF_HIST_ALL.version_number%TYPE ,

172: END audp_get_uiclh_col;
173:
174: Function Audp_Get_Urch_Col(
175: p_unit_cd IGS_PS_UNIT_REF_HIST_ALL.unit_cd%TYPE ,
176: p_version_number IGS_PS_UNIT_REF_HIST_ALL.version_number%TYPE ,
177: p_reference_cd_type IGS_PS_UNIT_REF_HIST_ALL.reference_cd_type%TYPE ,
178: p_reference_cd IGS_PS_UNIT_REF_HIST_ALL.reference_cd%TYPE ,
179: p_hist_date IGS_PS_UNIT_REF_HIST_ALL.hist_start_dt%TYPE )
180: RETURN VARCHAR2 AS

Line 177: p_reference_cd_type IGS_PS_UNIT_REF_HIST_ALL.reference_cd_type%TYPE ,

173:
174: Function Audp_Get_Urch_Col(
175: p_unit_cd IGS_PS_UNIT_REF_HIST_ALL.unit_cd%TYPE ,
176: p_version_number IGS_PS_UNIT_REF_HIST_ALL.version_number%TYPE ,
177: p_reference_cd_type IGS_PS_UNIT_REF_HIST_ALL.reference_cd_type%TYPE ,
178: p_reference_cd IGS_PS_UNIT_REF_HIST_ALL.reference_cd%TYPE ,
179: p_hist_date IGS_PS_UNIT_REF_HIST_ALL.hist_start_dt%TYPE )
180: RETURN VARCHAR2 AS
181:

Line 178: p_reference_cd IGS_PS_UNIT_REF_HIST_ALL.reference_cd%TYPE ,

174: Function Audp_Get_Urch_Col(
175: p_unit_cd IGS_PS_UNIT_REF_HIST_ALL.unit_cd%TYPE ,
176: p_version_number IGS_PS_UNIT_REF_HIST_ALL.version_number%TYPE ,
177: p_reference_cd_type IGS_PS_UNIT_REF_HIST_ALL.reference_cd_type%TYPE ,
178: p_reference_cd IGS_PS_UNIT_REF_HIST_ALL.reference_cd%TYPE ,
179: p_hist_date IGS_PS_UNIT_REF_HIST_ALL.hist_start_dt%TYPE )
180: RETURN VARCHAR2 AS
181:
182: BEGIN -- audp_get_urch_col

Line 179: p_hist_date IGS_PS_UNIT_REF_HIST_ALL.hist_start_dt%TYPE )

175: p_unit_cd IGS_PS_UNIT_REF_HIST_ALL.unit_cd%TYPE ,
176: p_version_number IGS_PS_UNIT_REF_HIST_ALL.version_number%TYPE ,
177: p_reference_cd_type IGS_PS_UNIT_REF_HIST_ALL.reference_cd_type%TYPE ,
178: p_reference_cd IGS_PS_UNIT_REF_HIST_ALL.reference_cd%TYPE ,
179: p_hist_date IGS_PS_UNIT_REF_HIST_ALL.hist_start_dt%TYPE )
180: RETURN VARCHAR2 AS
181:
182: BEGIN -- audp_get_urch_col
183: -- Get the oldest column value(after a given date) for a given unit_cd,

Line 186: v_column_value igs_ps_unit_ref_hist.description%TYPE := NULL;

182: BEGIN -- audp_get_urch_col
183: -- Get the oldest column value(after a given date) for a given unit_cd,
184: -- version_number, reference_type and reference_cd
185: DECLARE
186: v_column_value igs_ps_unit_ref_hist.description%TYPE := NULL;
187: CURSOR c_urch IS
188: SELECT urch.description
189: FROM IGS_PS_UNIT_REF_HIST urch
190: WHERE urch.unit_cd = p_unit_cd AND

Line 189: FROM IGS_PS_UNIT_REF_HIST urch

185: DECLARE
186: v_column_value igs_ps_unit_ref_hist.description%TYPE := NULL;
187: CURSOR c_urch IS
188: SELECT urch.description
189: FROM IGS_PS_UNIT_REF_HIST urch
190: WHERE urch.unit_cd = p_unit_cd AND
191: urch.version_number = p_version_number AND
192: urch.reference_cd_type = p_reference_cd_type AND
193: urch.reference_cd = p_reference_cd AND