APPS.IGS_PS_VER_PKG dependencies on IGS_GE_REF_CD_TYPE_ALL

Line 2119: CURSOR c_igs_ge_ref_cd_type_all

2115: Known limitations, enhancements or remarks:
2116: Change History :
2117: Who When What
2118: *************************************************************************/
2119: CURSOR c_igs_ge_ref_cd_type_all
2120: IS
2121: SELECT
2122: reference_cd_type,
2123: mandatory_flag,

Line 2127: igs_ge_ref_cd_type_all

2123: mandatory_flag,
2124: program_flag,
2125: closed_ind
2126: FROM
2127: igs_ge_ref_cd_type_all
2128: WHERE
2129: mandatory_flag ='Y'
2130: AND
2131: program_flag ='Y'

Line 2149: FOR cur_igs_ge_ref_cd_type_all IN c_igs_ge_ref_cd_type_all

2145: reference_cd_type = p_c_reference_cd_type
2146: AND default_flag = 'Y';
2147: l_c_rowid VARCHAR2(25) := NULL;
2148: BEGIN
2149: FOR cur_igs_ge_ref_cd_type_all IN c_igs_ge_ref_cd_type_all
2150: LOOP
2151: FOR cur_igs_ge_ref_cd IN c_igs_ge_ref_cd(cur_igs_ge_ref_cd_type_all.reference_cd_type)
2152: LOOP
2153: -- insert a value in igs_ps_ref_cd for every value of course_cd and version_number having

Line 2151: FOR cur_igs_ge_ref_cd IN c_igs_ge_ref_cd(cur_igs_ge_ref_cd_type_all.reference_cd_type)

2147: l_c_rowid VARCHAR2(25) := NULL;
2148: BEGIN
2149: FOR cur_igs_ge_ref_cd_type_all IN c_igs_ge_ref_cd_type_all
2150: LOOP
2151: FOR cur_igs_ge_ref_cd IN c_igs_ge_ref_cd(cur_igs_ge_ref_cd_type_all.reference_cd_type)
2152: LOOP
2153: -- insert a value in igs_ps_ref_cd for every value of course_cd and version_number having
2154: -- a applicable program level defined as mandatory and a default reference code
2155: BEGIN

Line 2161: X_REFERENCE_CD_TYPE => cur_igs_ge_ref_cd_type_all.reference_cd_type ,

2157: igs_ps_ref_cd_pkg.INSERT_ROW (
2158: X_ROWID => l_c_rowid,
2159: X_COURSE_CD => p_course_cd,
2160: X_VERSION_NUMBER => p_version_number,
2161: X_REFERENCE_CD_TYPE => cur_igs_ge_ref_cd_type_all.reference_cd_type ,
2162: X_REFERENCE_CD => cur_igs_ge_ref_cd.reference_cd ,
2163: X_DESCRIPTION => cur_igs_ge_ref_cd.description ,
2164: X_MODE => 'R'
2165: );