DBA Data[Home] [Help]

APPS.IGS_AU_GEN_004 dependencies on IGS_PS_TCH_RESP_HIST_ALL

Line 5: p_unit_cd IGS_PS_TCH_RESP_HIST_ALL.unit_cd%TYPE ,

1: PACKAGE IGS_AU_GEN_004 AS
2: /* $Header: IGSAU04S.pls 120.0 2005/06/01 22:21:57 appldev noship $ */
3:
4: Function Audp_Get_Trh_Col(
5: p_unit_cd IGS_PS_TCH_RESP_HIST_ALL.unit_cd%TYPE ,
6: p_version_number IGS_PS_TCH_RESP_HIST_ALL.version_number%TYPE ,
7: p_org_unit_cd IGS_PS_TCH_RESP_HIST_ALL.org_unit_cd%TYPE ,
8: p_ou_start_dt IGS_PS_TCH_RESP_HIST_ALL.ou_start_dt%TYPE ,
9: p_hist_date IGS_PS_TCH_RESP_HIST_ALL.hist_start_dt%TYPE )

Line 6: p_version_number IGS_PS_TCH_RESP_HIST_ALL.version_number%TYPE ,

2: /* $Header: IGSAU04S.pls 120.0 2005/06/01 22:21:57 appldev noship $ */
3:
4: Function Audp_Get_Trh_Col(
5: p_unit_cd IGS_PS_TCH_RESP_HIST_ALL.unit_cd%TYPE ,
6: p_version_number IGS_PS_TCH_RESP_HIST_ALL.version_number%TYPE ,
7: p_org_unit_cd IGS_PS_TCH_RESP_HIST_ALL.org_unit_cd%TYPE ,
8: p_ou_start_dt IGS_PS_TCH_RESP_HIST_ALL.ou_start_dt%TYPE ,
9: p_hist_date IGS_PS_TCH_RESP_HIST_ALL.hist_start_dt%TYPE )
10: RETURN NUMBER;

Line 7: p_org_unit_cd IGS_PS_TCH_RESP_HIST_ALL.org_unit_cd%TYPE ,

3:
4: Function Audp_Get_Trh_Col(
5: p_unit_cd IGS_PS_TCH_RESP_HIST_ALL.unit_cd%TYPE ,
6: p_version_number IGS_PS_TCH_RESP_HIST_ALL.version_number%TYPE ,
7: p_org_unit_cd IGS_PS_TCH_RESP_HIST_ALL.org_unit_cd%TYPE ,
8: p_ou_start_dt IGS_PS_TCH_RESP_HIST_ALL.ou_start_dt%TYPE ,
9: p_hist_date IGS_PS_TCH_RESP_HIST_ALL.hist_start_dt%TYPE )
10: RETURN NUMBER;
11: PRAGMA RESTRICT_REFERENCES(Audp_Get_Trh_Col, WNDS);

Line 8: p_ou_start_dt IGS_PS_TCH_RESP_HIST_ALL.ou_start_dt%TYPE ,

4: Function Audp_Get_Trh_Col(
5: p_unit_cd IGS_PS_TCH_RESP_HIST_ALL.unit_cd%TYPE ,
6: p_version_number IGS_PS_TCH_RESP_HIST_ALL.version_number%TYPE ,
7: p_org_unit_cd IGS_PS_TCH_RESP_HIST_ALL.org_unit_cd%TYPE ,
8: p_ou_start_dt IGS_PS_TCH_RESP_HIST_ALL.ou_start_dt%TYPE ,
9: p_hist_date IGS_PS_TCH_RESP_HIST_ALL.hist_start_dt%TYPE )
10: RETURN NUMBER;
11: PRAGMA RESTRICT_REFERENCES(Audp_Get_Trh_Col, WNDS);
12:

Line 9: p_hist_date IGS_PS_TCH_RESP_HIST_ALL.hist_start_dt%TYPE )

5: p_unit_cd IGS_PS_TCH_RESP_HIST_ALL.unit_cd%TYPE ,
6: p_version_number IGS_PS_TCH_RESP_HIST_ALL.version_number%TYPE ,
7: p_org_unit_cd IGS_PS_TCH_RESP_HIST_ALL.org_unit_cd%TYPE ,
8: p_ou_start_dt IGS_PS_TCH_RESP_HIST_ALL.ou_start_dt%TYPE ,
9: p_hist_date IGS_PS_TCH_RESP_HIST_ALL.hist_start_dt%TYPE )
10: RETURN NUMBER;
11: PRAGMA RESTRICT_REFERENCES(Audp_Get_Trh_Col, WNDS);
12:
13: Function Audp_Get_Troh_Col(