PACKAGE: APPS.IGS_AU_GEN_002

Source

1 PACKAGE IGS_AU_GEN_002 AS
2 /* $Header: IGSAU02S.pls 120.0 2005/06/02 00:23:11 appldev noship $ */
3 Function Audp_Get_Culh_Col(
4   p_unit_cd  IGS_PS_UNIT_LVL_HIST_ALL.unit_cd%TYPE ,
5   p_course_type  IGS_PS_UNIT_LVL_HIST_ALL.course_type%TYPE DEFAULT NULL,
6   p_version_number  IGS_PS_UNIT_LVL_HIST_ALL.version_number%TYPE ,
7   p_column_name  user_tab_columns.column_name%TYPE ,
8   p_hist_date  IGS_PS_UNIT_LVL_HIST_ALL.hist_start_dt%TYPE,
9   p_course_cd   IGS_PS_UNIT_LVL_HIST_ALL.course_cd%TYPE,
10   p_course_version_number   IGS_PS_UNIT_LVL_HIST_ALL.course_version_number%TYPE
11   )
12 RETURN VARCHAR2;
13 PRAGMA RESTRICT_REFERENCES(Audp_Get_Culh_Col, WNDS);
14 
15 Function Audp_Get_Cvh_Col(
16   p_course_cd  IGS_PS_VER_HIST_ALL.course_cd%TYPE ,
17   p_version_number  IGS_PS_VER_HIST_ALL.version_number%TYPE ,
18   p_column_name  user_tab_columns.column_name%TYPE ,
19   p_hist_date  IGS_PS_VER_HIST_ALL.hist_start_dt%TYPE )
20 RETURN VARCHAR2;
21 PRAGMA RESTRICT_REFERENCES(Audp_Get_Cvh_Col, WNDS);
22 
23 Function Audp_Get_Dh_Col(
24   p_column_name  user_tab_columns.column_name%TYPE ,
25   p_dscplne_grp_cd  IGS_PS_DSCP_HIST_ALL.discipline_group_cd%TYPE ,
26   p_hist_end_dt  IGS_PS_DSCP_HIST_ALL.hist_end_dt%TYPE )
27 RETURN VARCHAR2;
28 PRAGMA RESTRICT_REFERENCES(Audp_Get_Dh_Col, WNDS);
29 
30 Function Audp_Get_Fcflh_Col(
31   p_column_name IN user_tab_columns.column_name%TYPE ,
32   p_fee_cat IN IGS_FI_F_CAT_F_LBL_H_ALL.fee_cat%TYPE ,
33   p_fee_cal_type IN VARCHAR2 ,
34   p_fee_ci_sequence_number IN NUMBER ,
35   p_fee_type IN IGS_FI_F_CAT_F_LBL_H_ALL.fee_type%TYPE ,
36   p_hist_end_dt IN DATE )
37 RETURN VARCHAR2;
38 PRAGMA RESTRICT_REFERENCES(Audp_Get_Fcflh_Col, WNDS);
39 
40 Function Audp_Get_Fosh_Col(
41   p_column_name  user_tab_columns.column_name%TYPE ,
42   p_field_of_study  IGS_PS_FLD_STDY_HIST_ALL.field_of_study%TYPE ,
43   p_hist_end_dt  IGS_PS_FLD_STDY_HIST_ALL.hist_end_dt%TYPE )
44 RETURN VARCHAR2;
45 PRAGMA RESTRICT_REFERENCES(Audp_Get_Fosh_Col, WNDS);
46 
47 Function Audp_Get_Fsh_Col(
48   p_funding_source  IGS_FI_FUND_SRC_HIST_ALL.funding_source%TYPE ,
49   p_column_name  user_tab_columns.column_name%TYPE ,
50   p_hist_end_dt  IGS_FI_FUND_SRC_HIST_ALL.hist_end_dt%TYPE )
51 RETURN VARCHAR2;
52 PRAGMA RESTRICT_REFERENCES(Audp_Get_Fsh_Col, WNDS);
53 
54 Function Audp_Get_Fsrh_Col(
55   p_course_cd  IGS_FI_FD_SRC_RSTN_H_ALL.course_cd%TYPE ,
56   p_version_number  IGS_FI_FD_SRC_RSTN_H_ALL.version_number%TYPE ,
57   p_funding_source  IGS_FI_FD_SRC_RSTN_H_ALL.funding_source%TYPE ,
58   p_column_name  user_tab_columns.column_name%TYPE ,
59   p_hist_date  IGS_FI_FD_SRC_RSTN_H_ALL.hist_start_dt%TYPE )
60 RETURN VARCHAR2;
61 PRAGMA RESTRICT_REFERENCES(Audp_Get_Fsrh_Col, WNDS);
62 
63 Function Audp_Get_Ftcih_Col(
64   p_column_name IN user_tab_columns.column_name%TYPE ,
65   p_fee_type IN IGS_FI_FEE_TYPE_CI_H_ALL.fee_type%TYPE ,
66   p_fee_cal_type IN IGS_FI_FEE_TYPE_CI_H_ALL.fee_cal_type%TYPE ,
67   p_fee_ci_sequence_number IN NUMBER ,
68   p_hist_end_dt IN IGS_FI_FEE_TYPE_CI_H_ALL.hist_end_dt%TYPE )
69 RETURN VARCHAR2;
70 PRAGMA RESTRICT_REFERENCES(Audp_Get_Ftcih_Col, WNDS);
71 
72 END IGS_AU_GEN_002;