APPS.IGS_AU_GEN_004 dependencies on IGS_PS_TCH_RSOV_HIST

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

Line 68: v_column_value IGS_PS_TCH_RSOV_HIST.percentage%TYPE := NULL;

64: -- get the oldest column value (after a given date) for the percentage column
65: -- and a given unit_cd, version_number, cal_type, ci_sequence-number,
66: -- location_cd, unit_class, org_unit_cd and ou_start_dt.
67: DECLARE
68: v_column_value IGS_PS_TCH_RSOV_HIST.percentage%TYPE := NULL;
69: CURSOR c_troh IS
70: SELECT troh.percentage
71: FROM IGS_PS_TCH_RSOV_HIST troh
72: WHERE troh.unit_cd = p_unit_cd AND

Line 71: FROM IGS_PS_TCH_RSOV_HIST troh

67: DECLARE
68: v_column_value IGS_PS_TCH_RSOV_HIST.percentage%TYPE := NULL;
69: CURSOR c_troh IS
70: SELECT troh.percentage
71: FROM IGS_PS_TCH_RSOV_HIST troh
72: WHERE troh.unit_cd = p_unit_cd AND
73: troh.version_number = p_version_number AND
74: troh.cal_type = p_cal_type AND
75: troh.ci_sequence_number = p_ci_sequence_number AND