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

Line 277: p_unit_cd IGS_PS_UNIT_VER_HIST_ALL.unit_cd%TYPE ,

273: -- Added auditable_ind, audit_permission_ind and max_auditors_allowed
274: -- parameters in SELECT statement as per Bug# 2636716 by shtatiko.
275:
276: Function Audp_Get_Uvh_Col(
277: p_unit_cd IGS_PS_UNIT_VER_HIST_ALL.unit_cd%TYPE ,
278: p_version_number IGS_PS_UNIT_VER_HIST_ALL.version_number%TYPE ,
279: p_column_name user_tab_columns.column_name%TYPE ,
280: p_hist_date IGS_PS_UNIT_VER_HIST_ALL.hist_end_dt%TYPE )
281: RETURN VARCHAR2 AS

Line 278: p_version_number IGS_PS_UNIT_VER_HIST_ALL.version_number%TYPE ,

274: -- parameters in SELECT statement as per Bug# 2636716 by shtatiko.
275:
276: Function Audp_Get_Uvh_Col(
277: p_unit_cd IGS_PS_UNIT_VER_HIST_ALL.unit_cd%TYPE ,
278: p_version_number IGS_PS_UNIT_VER_HIST_ALL.version_number%TYPE ,
279: p_column_name user_tab_columns.column_name%TYPE ,
280: p_hist_date IGS_PS_UNIT_VER_HIST_ALL.hist_end_dt%TYPE )
281: RETURN VARCHAR2 AS
282:

Line 280: p_hist_date IGS_PS_UNIT_VER_HIST_ALL.hist_end_dt%TYPE )

276: Function Audp_Get_Uvh_Col(
277: p_unit_cd IGS_PS_UNIT_VER_HIST_ALL.unit_cd%TYPE ,
278: p_version_number IGS_PS_UNIT_VER_HIST_ALL.version_number%TYPE ,
279: p_column_name user_tab_columns.column_name%TYPE ,
280: p_hist_date IGS_PS_UNIT_VER_HIST_ALL.hist_end_dt%TYPE )
281: RETURN VARCHAR2 AS
282:
283: BEGIN -- audp_get_uvh_col
284: -- get the oldest column value (after a given date) for a