APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_UNIT_SUBTITLE_S

Line 1404: p_n_subtitle_id OUT NOCOPY igs_ps_unit_subtitle.subtitle_id%TYPE,

1400: END validate_cps;
1401:
1402: -- Validate Unit Section Referece Records before inserting them
1403: PROCEDURE validate_ref ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
1404: p_n_subtitle_id OUT NOCOPY igs_ps_unit_subtitle.subtitle_id%TYPE,
1405: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
1406: p_insert_update VARCHAR2)
1407: AS
1408: /***********************************************************************************************

Line 1430: cp_subtitle igs_ps_unit_subtitle.subtitle%TYPE,

1426:
1427: CURSOR c_subtitle_id (
1428: cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
1429: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE,
1430: cp_subtitle igs_ps_unit_subtitle.subtitle%TYPE,
1431: cp_approved_ind igs_ps_unit_subtitle.approved_ind%TYPE) IS
1432: SELECT subtitle_id
1433: FROM igs_ps_unit_subtitle
1434: WHERE closed_ind = 'N'

Line 1460: cp_subtitle igs_ps_unit_subtitle.subtitle%TYPE ) IS

1456:
1457: CURSOR c_subtitle_closed (
1458: cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
1459: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE,
1460: cp_subtitle igs_ps_unit_subtitle.subtitle%TYPE ) IS
1461: SELECT 'X'
1462: FROM igs_ps_unit_subtitle
1463: WHERE closed_ind = 'Y'
1464: AND unit_cd = cp_unit_cd

Line 1516: (igs_ps_unit_subtitle_s.NEXTVAL,

1512: last_update_date,
1513: last_update_login
1514: )
1515: VALUES
1516: (igs_ps_unit_subtitle_s.NEXTVAL,
1517: p_usec_rec.unit_cd,
1518: p_usec_rec.version_number,
1519: p_usec_rec.reference_subtitle,
1520: 'N',