DBA Data[Home] [Help]

APPS.IGS_AU_GEN_002 dependencies on USER_TAB_COLUMNS

Line 7: p_column_name user_tab_columns.column_name%TYPE ,

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: )

Line 18: p_column_name user_tab_columns.column_name%TYPE ,

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:

Line 24: p_column_name user_tab_columns.column_name%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);

Line 31: p_column_name IN user_tab_columns.column_name%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 ,

Line 41: p_column_name user_tab_columns.column_name%TYPE ,

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);

Line 49: p_column_name user_tab_columns.column_name%TYPE ,

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:

Line 58: p_column_name user_tab_columns.column_name%TYPE ,

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:

Line 64: p_column_name IN user_tab_columns.column_name%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 )