DBA Data[Home] [Help]

APPS.IGS_AU_GEN_004 dependencies on IGS_PS_TCH_RSOV_HIST_ALL

Line 14: p_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.unit_cd%TYPE ,

10: RETURN NUMBER;
11: PRAGMA RESTRICT_REFERENCES(Audp_Get_Trh_Col, WNDS);
12:
13: Function Audp_Get_Troh_Col(
14: p_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.unit_cd%TYPE ,
15: p_version_number IGS_PS_TCH_RSOV_HIST_ALL.version_number%TYPE ,
16: p_cal_type IGS_PS_TCH_RSOV_HIST_ALL.cal_type%TYPE ,
17: p_ci_sequence_number IGS_PS_TCH_RSOV_HIST_ALL.ci_sequence_number%TYPE ,
18: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,

Line 15: p_version_number IGS_PS_TCH_RSOV_HIST_ALL.version_number%TYPE ,

11: PRAGMA RESTRICT_REFERENCES(Audp_Get_Trh_Col, WNDS);
12:
13: Function Audp_Get_Troh_Col(
14: p_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.unit_cd%TYPE ,
15: p_version_number IGS_PS_TCH_RSOV_HIST_ALL.version_number%TYPE ,
16: p_cal_type IGS_PS_TCH_RSOV_HIST_ALL.cal_type%TYPE ,
17: p_ci_sequence_number IGS_PS_TCH_RSOV_HIST_ALL.ci_sequence_number%TYPE ,
18: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,
19: p_unit_class IGS_PS_TCH_RSOV_HIST_ALL.unit_class%TYPE ,

Line 16: p_cal_type IGS_PS_TCH_RSOV_HIST_ALL.cal_type%TYPE ,

12:
13: Function Audp_Get_Troh_Col(
14: p_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.unit_cd%TYPE ,
15: p_version_number IGS_PS_TCH_RSOV_HIST_ALL.version_number%TYPE ,
16: p_cal_type IGS_PS_TCH_RSOV_HIST_ALL.cal_type%TYPE ,
17: p_ci_sequence_number IGS_PS_TCH_RSOV_HIST_ALL.ci_sequence_number%TYPE ,
18: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,
19: p_unit_class IGS_PS_TCH_RSOV_HIST_ALL.unit_class%TYPE ,
20: p_org_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.org_unit_cd%TYPE ,

Line 17: p_ci_sequence_number IGS_PS_TCH_RSOV_HIST_ALL.ci_sequence_number%TYPE ,

13: Function Audp_Get_Troh_Col(
14: p_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.unit_cd%TYPE ,
15: p_version_number IGS_PS_TCH_RSOV_HIST_ALL.version_number%TYPE ,
16: p_cal_type IGS_PS_TCH_RSOV_HIST_ALL.cal_type%TYPE ,
17: p_ci_sequence_number IGS_PS_TCH_RSOV_HIST_ALL.ci_sequence_number%TYPE ,
18: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,
19: p_unit_class IGS_PS_TCH_RSOV_HIST_ALL.unit_class%TYPE ,
20: p_org_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.org_unit_cd%TYPE ,
21: p_ou_start_dt IGS_PS_TCH_RSOV_HIST_ALL.ou_start_dt%TYPE ,

Line 18: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,

14: p_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.unit_cd%TYPE ,
15: p_version_number IGS_PS_TCH_RSOV_HIST_ALL.version_number%TYPE ,
16: p_cal_type IGS_PS_TCH_RSOV_HIST_ALL.cal_type%TYPE ,
17: p_ci_sequence_number IGS_PS_TCH_RSOV_HIST_ALL.ci_sequence_number%TYPE ,
18: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,
19: p_unit_class IGS_PS_TCH_RSOV_HIST_ALL.unit_class%TYPE ,
20: p_org_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.org_unit_cd%TYPE ,
21: p_ou_start_dt IGS_PS_TCH_RSOV_HIST_ALL.ou_start_dt%TYPE ,
22: p_hist_date IGS_PS_TCH_RSOV_HIST_ALL.hist_start_dt%TYPE )

Line 19: p_unit_class IGS_PS_TCH_RSOV_HIST_ALL.unit_class%TYPE ,

15: p_version_number IGS_PS_TCH_RSOV_HIST_ALL.version_number%TYPE ,
16: p_cal_type IGS_PS_TCH_RSOV_HIST_ALL.cal_type%TYPE ,
17: p_ci_sequence_number IGS_PS_TCH_RSOV_HIST_ALL.ci_sequence_number%TYPE ,
18: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,
19: p_unit_class IGS_PS_TCH_RSOV_HIST_ALL.unit_class%TYPE ,
20: p_org_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.org_unit_cd%TYPE ,
21: p_ou_start_dt IGS_PS_TCH_RSOV_HIST_ALL.ou_start_dt%TYPE ,
22: p_hist_date IGS_PS_TCH_RSOV_HIST_ALL.hist_start_dt%TYPE )
23: RETURN NUMBER;

Line 20: p_org_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.org_unit_cd%TYPE ,

16: p_cal_type IGS_PS_TCH_RSOV_HIST_ALL.cal_type%TYPE ,
17: p_ci_sequence_number IGS_PS_TCH_RSOV_HIST_ALL.ci_sequence_number%TYPE ,
18: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,
19: p_unit_class IGS_PS_TCH_RSOV_HIST_ALL.unit_class%TYPE ,
20: p_org_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.org_unit_cd%TYPE ,
21: p_ou_start_dt IGS_PS_TCH_RSOV_HIST_ALL.ou_start_dt%TYPE ,
22: p_hist_date IGS_PS_TCH_RSOV_HIST_ALL.hist_start_dt%TYPE )
23: RETURN NUMBER;
24: PRAGMA RESTRICT_REFERENCES(Audp_Get_Troh_Col, WNDS);

Line 21: p_ou_start_dt IGS_PS_TCH_RSOV_HIST_ALL.ou_start_dt%TYPE ,

17: p_ci_sequence_number IGS_PS_TCH_RSOV_HIST_ALL.ci_sequence_number%TYPE ,
18: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,
19: p_unit_class IGS_PS_TCH_RSOV_HIST_ALL.unit_class%TYPE ,
20: p_org_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.org_unit_cd%TYPE ,
21: p_ou_start_dt IGS_PS_TCH_RSOV_HIST_ALL.ou_start_dt%TYPE ,
22: p_hist_date IGS_PS_TCH_RSOV_HIST_ALL.hist_start_dt%TYPE )
23: RETURN NUMBER;
24: PRAGMA RESTRICT_REFERENCES(Audp_Get_Troh_Col, WNDS);
25:

Line 22: p_hist_date IGS_PS_TCH_RSOV_HIST_ALL.hist_start_dt%TYPE )

18: p_location_cd IGS_PS_TCH_RSOV_HIST_ALL.location_cd%TYPE ,
19: p_unit_class IGS_PS_TCH_RSOV_HIST_ALL.unit_class%TYPE ,
20: p_org_unit_cd IGS_PS_TCH_RSOV_HIST_ALL.org_unit_cd%TYPE ,
21: p_ou_start_dt IGS_PS_TCH_RSOV_HIST_ALL.ou_start_dt%TYPE ,
22: p_hist_date IGS_PS_TCH_RSOV_HIST_ALL.hist_start_dt%TYPE )
23: RETURN NUMBER;
24: PRAGMA RESTRICT_REFERENCES(Audp_Get_Troh_Col, WNDS);
25:
26: Function Audp_Get_Udh_Col(