eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_UNIT_SUBTITLE

Line 177: CURSOR c_subtitle(cp_unit_cd igs_ps_unit_subtitle.unit_cd%TYPE,

173: smvk 27-feb-2003 Bug #2770598. Added the validation "re-enrollment for credit('Repeatable_Ind') is not allowed
174: then the max_repeats_for_credit maximum repeats credit points and max_repeats_for_funding should be null.
175: smvk 26-Dec-2002 Bug # 2721495. Using the function to validate_staff_person instead of igs_en_gen_003.get_staff_ind.
176: ***********************************************************************************************/
177: CURSOR c_subtitle(cp_unit_cd igs_ps_unit_subtitle.unit_cd%TYPE,
178: cp_version_number igs_ps_unit_subtitle.version_number%TYPE) IS
179: SELECT 'X'
180: FROM igs_ps_unit_subtitle
181: WHERE closed_ind='N'

Line 178: cp_version_number igs_ps_unit_subtitle.version_number%TYPE) IS

174: then the max_repeats_for_credit maximum repeats credit points and max_repeats_for_funding should be null.
175: smvk 26-Dec-2002 Bug # 2721495. Using the function to validate_staff_person instead of igs_en_gen_003.get_staff_ind.
176: ***********************************************************************************************/
177: CURSOR c_subtitle(cp_unit_cd igs_ps_unit_subtitle.unit_cd%TYPE,
178: cp_version_number igs_ps_unit_subtitle.version_number%TYPE) IS
179: SELECT 'X'
180: FROM igs_ps_unit_subtitle
181: WHERE closed_ind='N'
182: AND approved_ind='Y'

Line 180: FROM igs_ps_unit_subtitle

176: ***********************************************************************************************/
177: CURSOR c_subtitle(cp_unit_cd igs_ps_unit_subtitle.unit_cd%TYPE,
178: cp_version_number igs_ps_unit_subtitle.version_number%TYPE) IS
179: SELECT 'X'
180: FROM igs_ps_unit_subtitle
181: WHERE closed_ind='N'
182: AND approved_ind='Y'
183: AND unit_cd=cp_unit_cd
184: AND version_number=cp_version_number;

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 1420: FROM igs_ps_unit_subtitle

1416: ********************************************************************************************** */
1417: CURSOR c_subtitle ( cp_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
1418: cp_ver_num igs_ps_unit_ver_all.version_number%TYPE) IS
1419: SELECT 1
1420: FROM igs_ps_unit_subtitle
1421: WHERE closed_ind = 'N'
1422: AND approved_ind = 'Y'
1423: AND unit_cd = cp_unit_cd
1424: AND version_number = cp_ver_num;

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 1431: cp_approved_ind igs_ps_unit_subtitle.approved_ind%TYPE) IS

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'
1435: AND approved_ind = cp_approved_ind

Line 1433: FROM igs_ps_unit_subtitle

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'
1435: AND approved_ind = cp_approved_ind
1436: AND unit_cd = cp_unit_cd
1437: AND version_number = cp_ver_num

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 1462: FROM igs_ps_unit_subtitle

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
1465: AND version_number = cp_ver_num
1466: AND subtitle = cp_subtitle ;

Line 1502: INSERT INTO igs_ps_unit_subtitle

1498: FETCH c_subtitle_closed INTO l_c_var;
1499: IF c_subtitle_closed%NOTFOUND THEN
1500: -- Subtitle is not null and there is no approved or un-approved subtitle exist
1501: -- then insert the passed subtitle into table
1502: INSERT INTO igs_ps_unit_subtitle
1503: (subtitle_id,
1504: unit_cd,
1505: version_number,
1506: subtitle,

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',