APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_UNIT_SUBTITLE

Line 577: IF igs_ps_unit_subtitle_pkg.get_uk_for_validation(p_unit_ver_rec.unit_cd,

573: END IF;
574: END IF;
575:
576: --Check UK for validations
577: IF igs_ps_unit_subtitle_pkg.get_uk_for_validation(p_unit_ver_rec.unit_cd,
578: p_unit_ver_rec.version_number,
579: p_unit_ver_rec.subtitle) THEN
580: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS','SUBTITLE','LEGACY_TOKENS',FALSE);
581: p_unit_ver_rec.status:='W';

Line 1292: --If subtitle is not null then insert a record into igs_ps_unit_subtitle

1288: END IF;
1289:
1290: CLOSE cur_check;
1291:
1292: --If subtitle is not null then insert a record into igs_ps_unit_subtitle
1293: IF p_unit_ver_rec.subtitle IS NOT NULL THEN
1294: INSERT INTO igs_ps_unit_subtitle
1295: (
1296: subtitle_id,

Line 1294: INSERT INTO igs_ps_unit_subtitle

1290: CLOSE cur_check;
1291:
1292: --If subtitle is not null then insert a record into igs_ps_unit_subtitle
1293: IF p_unit_ver_rec.subtitle IS NOT NULL THEN
1294: INSERT INTO igs_ps_unit_subtitle
1295: (
1296: subtitle_id,
1297: unit_cd,
1298: version_number,

Line 1310: igs_ps_unit_subtitle_s.NEXTVAL,

1306: last_update_login
1307: )
1308: VALUES
1309: (
1310: igs_ps_unit_subtitle_s.NEXTVAL,
1311: p_unit_ver_rec.unit_cd,
1312: p_unit_ver_rec.version_number,
1313: p_unit_ver_rec.subtitle,
1314: p_unit_ver_rec.subtitle_approved_ind,

Line 1324: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.rec_inserted_igs_ps_unit_subtitle',

1320: g_n_login_id
1321: ) RETURNING subtitle_id INTO l_n_subtitle_id;
1322:
1323: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1324: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.rec_inserted_igs_ps_unit_subtitle',
1325: 'Unit code:'||p_unit_ver_rec.unit_cd||' '||'Version number:'||p_unit_ver_rec.version_number||' '||
1326: 'Subtitle_id:'||l_n_subtitle_id||' '||'Status:'||p_unit_ver_rec.status);
1327: END IF;
1328:

Line 2366: l_n_subtitle_id igs_ps_unit_subtitle.subtitle_id%TYPE;

2362: l_n_unit_contact_id igs_pe_person_base_v.person_id%TYPE;
2363: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
2364: l_n_sup_uoo_id igs_ps_unit_ofr_opt_all.sup_uoo_id%TYPE;
2365: l_c_relation_type igs_ps_unit_ofr_opt_all.relation_type%TYPE;
2366: l_n_subtitle_id igs_ps_unit_subtitle.subtitle_id%TYPE;
2367: l_b_uop_deleted BOOLEAN;
2368:
2369:
2370: /* Private Procedures for create_unit_section */