PACKAGE: APPS.IGS_AU_GEN_004

Source

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 )
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 ,
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(
27   p_unit_cd  IGS_PS_UNT_DSCP_HIST_ALL.unit_cd%TYPE ,
28   p_version_number  IGS_PS_UNT_DSCP_HIST_ALL.version_number%TYPE ,
29   p_discipline_group_cd  IGS_PS_UNT_DSCP_HIST_ALL.discipline_group_cd%TYPE ,
30   p_hist_date  IGS_PS_UNT_DSCP_HIST_ALL.hist_start_dt%TYPE )
31 RETURN NUMBER;
32 PRAGMA RESTRICT_REFERENCES(Audp_Get_Udh_Col, WNDS);
33 
34 Function Audp_Get_Uiclh_Col(
35   p_column_name  user_tab_columns.column_name%TYPE ,
36   p_unit_int_course_level_cd  IGS_PS_UNT_INLV_HIST_ALL.unit_int_course_level_cd%TYPE ,
37   p_hist_end_dt  IGS_PS_UNT_INLV_HIST_ALL.hist_end_dt%TYPE )
38 RETURN VARCHAR2;
39 PRAGMA RESTRICT_REFERENCES(Audp_Get_Uiclh_Col, WNDS);
40 
41 Function Audp_Get_Urch_Col(
42   p_unit_cd  IGS_PS_UNIT_REF_HIST_ALL.unit_cd%TYPE ,
43   p_version_number  IGS_PS_UNIT_REF_HIST_ALL.version_number%TYPE ,
44   p_reference_cd_type  IGS_PS_UNIT_REF_HIST_ALL.reference_cd_type%TYPE ,
45   p_reference_cd  IGS_PS_UNIT_REF_HIST_ALL.reference_cd%TYPE ,
46   p_hist_date  IGS_PS_UNIT_REF_HIST_ALL.hist_start_dt%TYPE )
47 RETURN VARCHAR2;
48 PRAGMA RESTRICT_REFERENCES(Audp_Get_Urch_Col, WNDS);
49 
50 Function Audp_Get_Ush_Col(
51   p_unit_set_cd  IGS_EN_UNIT_SET_HIST_ALL.unit_set_cd%TYPE ,
52   p_version_number  IGS_EN_UNIT_SET_HIST_ALL.version_number%TYPE ,
53   p_column_name  user_tab_columns.column_name%TYPE ,
54   p_hist_end_dt  IGS_EN_UNIT_SET_HIST_ALL.hist_end_dt%TYPE )
55 RETURN VARCHAR2;
56 PRAGMA RESTRICT_REFERENCES(Audp_Get_Ush_Col, WNDS);
57 
58 Function Audp_Get_Uvh_Col(
59   p_unit_cd  IGS_PS_UNIT_VER_HIST_ALL.unit_cd%TYPE ,
60   p_version_number  IGS_PS_UNIT_VER_HIST_ALL.version_number%TYPE ,
61   p_column_name  user_tab_columns.column_name%TYPE ,
62   p_hist_date  IGS_PS_UNIT_VER_HIST_ALL.hist_end_dt%TYPE )
63 RETURN VARCHAR2;
64 PRAGMA RESTRICT_REFERENCES(Audp_Get_Uvh_Col, WNDS);
65 
66 END IGS_AU_GEN_004;