APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_UNT_CRCLM_ALL

Line 322: SELECT igs_ps_unt_crclm_all_s.NEXTVAL

318: FROM igs_ps_rpt_fmly
319: WHERE repeat_code=cp_repeat_code;
320:
321: CURSOR c_curriculum_seq_num IS
322: SELECT igs_ps_unt_crclm_all_s.NEXTVAL
323: FROM DUAL;
324:
325:
326: l_d_start_date DATE;

Line 1332: --If curriculum description is not null then insert a record into igs_ps_unt_crclm_all

1328:
1329: END IF;
1330:
1331:
1332: --If curriculum description is not null then insert a record into igs_ps_unt_crclm_all
1333: IF p_unit_ver_rec.curriculum_description IS NOT NULL THEN
1334: INSERT INTO igs_ps_unt_crclm_all
1335: (
1336: curriculum_id,

Line 1334: INSERT INTO igs_ps_unt_crclm_all

1330:
1331:
1332: --If curriculum description is not null then insert a record into igs_ps_unt_crclm_all
1333: IF p_unit_ver_rec.curriculum_description IS NOT NULL THEN
1334: INSERT INTO igs_ps_unt_crclm_all
1335: (
1336: curriculum_id,
1337: description,
1338: closed_ind,

Line 1360: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.rec_inserted_igs_ps_unt_crclm_all',

1356: g_n_login_id
1357: );
1358:
1359: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1360: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.rec_inserted_igs_ps_unt_crclm_all',
1361: 'Unit code:'||p_unit_ver_rec.unit_cd||' '||'Version number:'||p_unit_ver_rec.version_number||' '||
1362: 'curriculum_id:'||p_unit_ver_rec.curriculum_id||' '||'Status:'||p_unit_ver_rec.status);
1363: END IF;
1364: END IF;