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_TCH_RSOV_HIST_ALL

Line 52: p_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.unit_cd%TYPE ,

48: END;
49: END audp_get_trh_col;
50:
51: Function Audp_Get_Troh_Col(
52: p_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.unit_cd%TYPE ,
53: p_version_number IGS_PS_TCH_RSOV_HIST_ALL.version_number%TYPE ,
54: p_cal_type IGS_PS_TCH_RSOV_HIST_ALL.cal_type%TYPE ,
55: p_ci_sequence_number IGS_PS_TCH_RSOV_HIST_ALL.ci_sequence_number%TYPE ,
56: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,

Line 53: p_version_number IGS_PS_TCH_RSOV_HIST_ALL.version_number%TYPE ,

49: END audp_get_trh_col;
50:
51: Function Audp_Get_Troh_Col(
52: p_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.unit_cd%TYPE ,
53: p_version_number IGS_PS_TCH_RSOV_HIST_ALL.version_number%TYPE ,
54: p_cal_type IGS_PS_TCH_RSOV_HIST_ALL.cal_type%TYPE ,
55: p_ci_sequence_number IGS_PS_TCH_RSOV_HIST_ALL.ci_sequence_number%TYPE ,
56: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,
57: p_unit_class IGS_PS_TCH_RSOV_HIST_ALL.unit_class%TYPE ,

Line 54: p_cal_type IGS_PS_TCH_RSOV_HIST_ALL.cal_type%TYPE ,

50:
51: Function Audp_Get_Troh_Col(
52: p_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.unit_cd%TYPE ,
53: p_version_number IGS_PS_TCH_RSOV_HIST_ALL.version_number%TYPE ,
54: p_cal_type IGS_PS_TCH_RSOV_HIST_ALL.cal_type%TYPE ,
55: p_ci_sequence_number IGS_PS_TCH_RSOV_HIST_ALL.ci_sequence_number%TYPE ,
56: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,
57: p_unit_class IGS_PS_TCH_RSOV_HIST_ALL.unit_class%TYPE ,
58: p_org_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.org_unit_cd%TYPE ,

Line 55: p_ci_sequence_number IGS_PS_TCH_RSOV_HIST_ALL.ci_sequence_number%TYPE ,

51: Function Audp_Get_Troh_Col(
52: p_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.unit_cd%TYPE ,
53: p_version_number IGS_PS_TCH_RSOV_HIST_ALL.version_number%TYPE ,
54: p_cal_type IGS_PS_TCH_RSOV_HIST_ALL.cal_type%TYPE ,
55: p_ci_sequence_number IGS_PS_TCH_RSOV_HIST_ALL.ci_sequence_number%TYPE ,
56: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,
57: p_unit_class IGS_PS_TCH_RSOV_HIST_ALL.unit_class%TYPE ,
58: p_org_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.org_unit_cd%TYPE ,
59: p_ou_start_dt IGS_PS_TCH_RSOV_HIST_ALL.ou_start_dt%TYPE ,

Line 56: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,

52: p_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.unit_cd%TYPE ,
53: p_version_number IGS_PS_TCH_RSOV_HIST_ALL.version_number%TYPE ,
54: p_cal_type IGS_PS_TCH_RSOV_HIST_ALL.cal_type%TYPE ,
55: p_ci_sequence_number IGS_PS_TCH_RSOV_HIST_ALL.ci_sequence_number%TYPE ,
56: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,
57: p_unit_class IGS_PS_TCH_RSOV_HIST_ALL.unit_class%TYPE ,
58: p_org_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.org_unit_cd%TYPE ,
59: p_ou_start_dt IGS_PS_TCH_RSOV_HIST_ALL.ou_start_dt%TYPE ,
60: p_hist_date IGS_PS_TCH_RSOV_HIST_ALL.hist_start_dt%TYPE )

Line 57: p_unit_class IGS_PS_TCH_RSOV_HIST_ALL.unit_class%TYPE ,

53: p_version_number IGS_PS_TCH_RSOV_HIST_ALL.version_number%TYPE ,
54: p_cal_type IGS_PS_TCH_RSOV_HIST_ALL.cal_type%TYPE ,
55: p_ci_sequence_number IGS_PS_TCH_RSOV_HIST_ALL.ci_sequence_number%TYPE ,
56: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,
57: p_unit_class IGS_PS_TCH_RSOV_HIST_ALL.unit_class%TYPE ,
58: p_org_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.org_unit_cd%TYPE ,
59: p_ou_start_dt IGS_PS_TCH_RSOV_HIST_ALL.ou_start_dt%TYPE ,
60: p_hist_date IGS_PS_TCH_RSOV_HIST_ALL.hist_start_dt%TYPE )
61: RETURN NUMBER AS

Line 58: p_org_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.org_unit_cd%TYPE ,

54: p_cal_type IGS_PS_TCH_RSOV_HIST_ALL.cal_type%TYPE ,
55: p_ci_sequence_number IGS_PS_TCH_RSOV_HIST_ALL.ci_sequence_number%TYPE ,
56: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,
57: p_unit_class IGS_PS_TCH_RSOV_HIST_ALL.unit_class%TYPE ,
58: p_org_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.org_unit_cd%TYPE ,
59: p_ou_start_dt IGS_PS_TCH_RSOV_HIST_ALL.ou_start_dt%TYPE ,
60: p_hist_date IGS_PS_TCH_RSOV_HIST_ALL.hist_start_dt%TYPE )
61: RETURN NUMBER AS
62:

Line 59: p_ou_start_dt IGS_PS_TCH_RSOV_HIST_ALL.ou_start_dt%TYPE ,

55: p_ci_sequence_number IGS_PS_TCH_RSOV_HIST_ALL.ci_sequence_number%TYPE ,
56: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,
57: p_unit_class IGS_PS_TCH_RSOV_HIST_ALL.unit_class%TYPE ,
58: p_org_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.org_unit_cd%TYPE ,
59: p_ou_start_dt IGS_PS_TCH_RSOV_HIST_ALL.ou_start_dt%TYPE ,
60: p_hist_date IGS_PS_TCH_RSOV_HIST_ALL.hist_start_dt%TYPE )
61: RETURN NUMBER AS
62:
63: BEGIN -- audp_get_troh_col

Line 60: p_hist_date IGS_PS_TCH_RSOV_HIST_ALL.hist_start_dt%TYPE )

56: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,
57: p_unit_class IGS_PS_TCH_RSOV_HIST_ALL.unit_class%TYPE ,
58: p_org_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.org_unit_cd%TYPE ,
59: p_ou_start_dt IGS_PS_TCH_RSOV_HIST_ALL.ou_start_dt%TYPE ,
60: p_hist_date IGS_PS_TCH_RSOV_HIST_ALL.hist_start_dt%TYPE )
61: RETURN NUMBER AS
62:
63: BEGIN -- audp_get_troh_col
64: -- get the oldest column value (after a given date) for the percentage column