APPS.IGS_HE_EXTRACT2_PKG dependencies on IGS_HE_USR_RT_CL_FLD

Line 44: TYPE fldnum IS TABLE OF igs_he_usr_rt_cl_fld.field_number%TYPE

40: -- PL/SQL table to hold award conferral dates for a submission
41: g_awd_table igs_he_extract_fields_pkg.awd_table;
42:
43: -- Index Table to hold the field definitions.
44: TYPE fldnum IS TABLE OF igs_he_usr_rt_cl_fld.field_number%TYPE
45: INDEX BY binary_integer;
46: TYPE constval IS TABLE OF igs_he_usr_rt_cl_fld.constant_val%TYPE
47: INDEX BY binary_integer;
48: TYPE defval IS TABLE OF igs_he_usr_rt_cl_fld.default_val%TYPE

Line 46: TYPE constval IS TABLE OF igs_he_usr_rt_cl_fld.constant_val%TYPE

42:
43: -- Index Table to hold the field definitions.
44: TYPE fldnum IS TABLE OF igs_he_usr_rt_cl_fld.field_number%TYPE
45: INDEX BY binary_integer;
46: TYPE constval IS TABLE OF igs_he_usr_rt_cl_fld.constant_val%TYPE
47: INDEX BY binary_integer;
48: TYPE defval IS TABLE OF igs_he_usr_rt_cl_fld.default_val%TYPE
49: INDEX BY binary_integer;
50: TYPE reportnullflag IS TABLE OF igs_he_usr_rt_cl_fld.report_null_flag%TYPE

Line 48: TYPE defval IS TABLE OF igs_he_usr_rt_cl_fld.default_val%TYPE

44: TYPE fldnum IS TABLE OF igs_he_usr_rt_cl_fld.field_number%TYPE
45: INDEX BY binary_integer;
46: TYPE constval IS TABLE OF igs_he_usr_rt_cl_fld.constant_val%TYPE
47: INDEX BY binary_integer;
48: TYPE defval IS TABLE OF igs_he_usr_rt_cl_fld.default_val%TYPE
49: INDEX BY binary_integer;
50: TYPE reportnullflag IS TABLE OF igs_he_usr_rt_cl_fld.report_null_flag%TYPE
51: INDEX BY binary_integer;
52: TYPE value IS TABLE OF igs_he_ex_rn_dat_fd.value%TYPE

Line 50: TYPE reportnullflag IS TABLE OF igs_he_usr_rt_cl_fld.report_null_flag%TYPE

46: TYPE constval IS TABLE OF igs_he_usr_rt_cl_fld.constant_val%TYPE
47: INDEX BY binary_integer;
48: TYPE defval IS TABLE OF igs_he_usr_rt_cl_fld.default_val%TYPE
49: INDEX BY binary_integer;
50: TYPE reportnullflag IS TABLE OF igs_he_usr_rt_cl_fld.report_null_flag%TYPE
51: INDEX BY binary_integer;
52: TYPE value IS TABLE OF igs_he_ex_rn_dat_fd.value%TYPE
53: INDEX BY binary_integer;
54:

Line 588: (p_usr_return_subclass igs_he_usr_rt_cl_fld.user_return_subclass%TYPE) IS

584: AND a.User_Return_Subclass = b.user_return_subclass
585: AND a.submission_name = c.submission_name;
586:
587: CURSOR c_fld_defn
588: (p_usr_return_subclass igs_he_usr_rt_cl_fld.user_return_subclass%TYPE) IS
589: SELECT hefld.field_number,
590: hefld.constant_val,
591: hefld.default_val,
592: hefld.report_null_flag

Line 593: FROM igs_he_usr_rt_cl_fld hefld,

589: SELECT hefld.field_number,
590: hefld.constant_val,
591: hefld.default_val,
592: hefld.report_null_flag
593: FROM igs_he_usr_rt_cl_fld hefld,
594: igs_he_usr_rtn_clas hecls
595: WHERE hefld.user_return_subclass = p_usr_return_subclass
596: AND hefld.user_return_subclass = hecls.user_return_subclass
597: AND hefld.include_flag = 'Y';