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_UNT_DSCP_HIST

Line 98: p_unit_cd IGS_PS_UNT_DSCP_HIST_ALL.unit_cd%TYPE ,

94: END;
95: END audp_get_troh_col;
96:
97: Function Audp_Get_Udh_Col(
98: p_unit_cd IGS_PS_UNT_DSCP_HIST_ALL.unit_cd%TYPE ,
99: p_version_number IGS_PS_UNT_DSCP_HIST_ALL.version_number%TYPE ,
100: p_discipline_group_cd IGS_PS_UNT_DSCP_HIST_ALL.discipline_group_cd%TYPE ,
101: p_hist_date IGS_PS_UNT_DSCP_HIST_ALL.hist_start_dt%TYPE )
102: RETURN NUMBER AS

Line 99: p_version_number IGS_PS_UNT_DSCP_HIST_ALL.version_number%TYPE ,

95: END audp_get_troh_col;
96:
97: Function Audp_Get_Udh_Col(
98: p_unit_cd IGS_PS_UNT_DSCP_HIST_ALL.unit_cd%TYPE ,
99: p_version_number IGS_PS_UNT_DSCP_HIST_ALL.version_number%TYPE ,
100: p_discipline_group_cd IGS_PS_UNT_DSCP_HIST_ALL.discipline_group_cd%TYPE ,
101: p_hist_date IGS_PS_UNT_DSCP_HIST_ALL.hist_start_dt%TYPE )
102: RETURN NUMBER AS
103:

Line 100: p_discipline_group_cd IGS_PS_UNT_DSCP_HIST_ALL.discipline_group_cd%TYPE ,

96:
97: Function Audp_Get_Udh_Col(
98: p_unit_cd IGS_PS_UNT_DSCP_HIST_ALL.unit_cd%TYPE ,
99: p_version_number IGS_PS_UNT_DSCP_HIST_ALL.version_number%TYPE ,
100: p_discipline_group_cd IGS_PS_UNT_DSCP_HIST_ALL.discipline_group_cd%TYPE ,
101: p_hist_date IGS_PS_UNT_DSCP_HIST_ALL.hist_start_dt%TYPE )
102: RETURN NUMBER AS
103:
104: BEGIN -- audp_get_udh_col

Line 101: p_hist_date IGS_PS_UNT_DSCP_HIST_ALL.hist_start_dt%TYPE )

97: Function Audp_Get_Udh_Col(
98: p_unit_cd IGS_PS_UNT_DSCP_HIST_ALL.unit_cd%TYPE ,
99: p_version_number IGS_PS_UNT_DSCP_HIST_ALL.version_number%TYPE ,
100: p_discipline_group_cd IGS_PS_UNT_DSCP_HIST_ALL.discipline_group_cd%TYPE ,
101: p_hist_date IGS_PS_UNT_DSCP_HIST_ALL.hist_start_dt%TYPE )
102: RETURN NUMBER AS
103:
104: BEGIN -- audp_get_udh_col
105: -- Get the oldest column value (after a given date) for the percentage

Line 108: v_column_value igs_ps_unt_dscp_hist.percentage%TYPE := NULL;

104: BEGIN -- audp_get_udh_col
105: -- Get the oldest column value (after a given date) for the percentage
106: -- column, unit_cd, version_number and discipline_group_cd.
107: DECLARE
108: v_column_value igs_ps_unt_dscp_hist.percentage%TYPE := NULL;
109: CURSOR c_udh IS
110: SELECT udh.percentage
111: FROM igs_ps_unt_dscp_hist udh
112: WHERE udh.unit_cd = p_unit_cd AND

Line 111: FROM igs_ps_unt_dscp_hist udh

107: DECLARE
108: v_column_value igs_ps_unt_dscp_hist.percentage%TYPE := NULL;
109: CURSOR c_udh IS
110: SELECT udh.percentage
111: FROM igs_ps_unt_dscp_hist udh
112: WHERE udh.unit_cd = p_unit_cd AND
113: udh.version_number = p_version_number AND
114: udh.discipline_group_cd = p_discipline_group_cd AND
115: udh.hist_start_dt >= p_hist_date AND