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_GENERIC_PKG dependencies on IGS_PS_USEC_X_GRP

Line 645: FROM igs_ps_usec_x_grpmem

641: AND unit_attempt_status='WAITLISTED';
642:
643: CURSOR c_x_grpmem(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
644: SELECT 'X'
645: FROM igs_ps_usec_x_grpmem
646: WHERE uoo_id=cp_uoo_id;
647:
648: c_x_grpmem_rec c_x_grpmem%ROWTYPE;
649:

Line 1419: FROM igs_ps_usec_x_grpmem

1415: Who When What
1416: ********************************************************************************************** */
1417: CURSOR c_parent(cp_usec_x_listed_group_id NUMBER) IS
1418: SELECT count (ROWID) cnt
1419: FROM igs_ps_usec_x_grpmem
1420: WHERE parent = 'Y'
1421: AND usec_x_listed_group_id =cp_usec_x_listed_group_id;
1422:
1423: c_parent_rec c_parent%ROWTYPE;

Line 1425: CURSOR c_x_grp(cp_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS

1421: AND usec_x_listed_group_id =cp_usec_x_listed_group_id;
1422:
1423: c_parent_rec c_parent%ROWTYPE;
1424:
1425: CURSOR c_x_grp(cp_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS
1426: SELECT *
1427: FROM igs_ps_usec_x_grp
1428: WHERE usec_x_listed_group_id = cp_usec_x_listed_group_id;
1429:

Line 1427: FROM igs_ps_usec_x_grp

1423: c_parent_rec c_parent%ROWTYPE;
1424:
1425: CURSOR c_x_grp(cp_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS
1426: SELECT *
1427: FROM igs_ps_usec_x_grp
1428: WHERE usec_x_listed_group_id = cp_usec_x_listed_group_id;
1429:
1430: c_x_grp_rec c_x_grp%ROWTYPE;
1431:

Line 1433: CURSOR c_sum_enract(cp_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS

1429:
1430: c_x_grp_rec c_x_grp%ROWTYPE;
1431:
1432:
1433: CURSOR c_sum_enract(cp_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS
1434: SELECT SUM(enrollment_actual) sum_enrollment_actual
1435: FROM igs_ps_usec_x_grpmem_v
1436: WHERE usec_x_listed_group_id = cp_usec_x_listed_group_id;
1437:

Line 1435: FROM igs_ps_usec_x_grpmem_v

1431:
1432:
1433: CURSOR c_sum_enract(cp_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS
1434: SELECT SUM(enrollment_actual) sum_enrollment_actual
1435: FROM igs_ps_usec_x_grpmem_v
1436: WHERE usec_x_listed_group_id = cp_usec_x_listed_group_id;
1437:
1438:
1439: c_sum_enract_rec c_sum_enract%ROWTYPE;

Line 1441: CURSOR c_usec_enr(cp_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS

1437:
1438:
1439: c_sum_enract_rec c_sum_enract%ROWTYPE;
1440:
1441: CURSOR c_usec_enr(cp_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS
1442: SELECT *
1443: FROM igs_ps_usec_x_grpmem_v
1444: WHERE usec_x_listed_group_id = cp_usec_x_listed_group_id ;
1445:

Line 1443: FROM igs_ps_usec_x_grpmem_v

1439: c_sum_enract_rec c_sum_enract%ROWTYPE;
1440:
1441: CURSOR c_usec_enr(cp_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS
1442: SELECT *
1443: FROM igs_ps_usec_x_grpmem_v
1444: WHERE usec_x_listed_group_id = cp_usec_x_listed_group_id ;
1445:
1446: c_usec_enr_rec c_usec_enr%ROWTYPE;
1447:

Line 1448: CURSOR cur_usec (cp_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE,

1444: WHERE usec_x_listed_group_id = cp_usec_x_listed_group_id ;
1445:
1446: c_usec_enr_rec c_usec_enr%ROWTYPE;
1447:
1448: CURSOR cur_usec (cp_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE,
1449: cp_usec_status igs_ps_unit_ofr_opt.unit_section_status%TYPE
1450: ) IS
1451: SELECT uoo.uoo_id
1452: FROM igs_ps_usec_x_grpmem usm,

Line 1452: FROM igs_ps_usec_x_grpmem usm,

1448: CURSOR cur_usec (cp_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE,
1449: cp_usec_status igs_ps_unit_ofr_opt.unit_section_status%TYPE
1450: ) IS
1451: SELECT uoo.uoo_id
1452: FROM igs_ps_usec_x_grpmem usm,
1453: igs_ps_unit_ofr_opt uoo
1454: WHERE usm.usec_x_listed_group_id = cp_usec_x_listed_group_id
1455: AND usm.uoo_id=uoo.uoo_id
1456: AND uoo.unit_section_status NOT IN (cp_usec_status,'PLANNED','CANCELLED','NOT_OFFERED');

Line 1460: FROM igs_ps_usec_x_grp a, igs_ca_inst_all b

1456: AND uoo.unit_section_status NOT IN (cp_usec_status,'PLANNED','CANCELLED','NOT_OFFERED');
1457:
1458: CURSOR cur_group_id (cp_group_name VARCHAR2, cp_alternate_cd VARCHAR2) IS
1459: SELECT a.usec_x_listed_group_id
1460: FROM igs_ps_usec_x_grp a, igs_ca_inst_all b
1461: WHERE a.usec_x_listed_group_name = cp_group_name
1462: AND a.cal_type = b.cal_type
1463: AND a.ci_sequence_number =b.sequence_number
1464: AND b.alternate_code=cp_alternate_cd;

Line 1570: UPDATE igs_ps_usec_x_grp

1566: max_ovr_group_temp:=l_new_sum;
1567: END IF;
1568:
1569: --Update the maximum enrollment/ovrride group
1570: UPDATE igs_ps_usec_x_grp
1571: SET max_enr_group=max_enr_group_temp,
1572: max_ovr_group=max_ovr_group_temp,
1573: last_updated_by = g_n_user_id,
1574: last_update_date = SYSDATE,

Line 1678: FROM igs_ps_usec_x_grp

1674: Who When What
1675: ********************************************************************************************** */
1676: CURSOR c_usec_x_grp(cp_xgrp_name VARCHAR2) IS
1677: SELECT 'X'
1678: FROM igs_ps_usec_x_grp
1679: WHERE usec_x_listed_group_name =cp_xgrp_name;
1680:
1681: c_usec_x_grp_rec c_usec_x_grp%ROWTYPE;
1682:

Line 1686: FROM igs_ps_usec_x_grp

1682:
1683:
1684: CURSOR c_val_enr(cp_x_name VARCHAR2,cp_cal_type VARCHAR2,cp_sequence_number NUMBER) IS
1685: SELECT *
1686: FROM igs_ps_usec_x_grp
1687: WHERE usec_x_listed_group_name =cp_x_name
1688: AND Cal_type=cp_cal_type
1689: AND ci_sequence_number=cp_sequence_number;
1690:

Line 1694: SELECT * FROM igs_ps_usec_x_grp

1690:
1691: c_val_enr_rec c_val_enr%ROWTYPE;
1692:
1693: CURSOR c_old_cmgrp(cp_x_name VARCHAR2,cp_cal_type VARCHAR2,cp_seq_no NUMBER) IS
1694: SELECT * FROM igs_ps_usec_x_grp
1695: WHERE usec_x_listed_group_name =cp_x_name
1696: AND cal_type=cp_cal_type
1697: AND ci_sequence_number=cp_seq_no;
1698:

Line 1701: CURSOR cur_usecs_in_group(cp_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS

1697: AND ci_sequence_number=cp_seq_no;
1698:
1699: c_old_cmgrp_rec c_old_cmgrp%ROWTYPE;
1700:
1701: CURSOR cur_usecs_in_group(cp_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS
1702: SELECT uoo_id
1703: FROM igs_ps_usec_x_grpmem
1704: WHERE usec_x_listed_group_id = cp_usec_x_listed_group_id;
1705:

Line 1703: FROM igs_ps_usec_x_grpmem

1699: c_old_cmgrp_rec c_old_cmgrp%ROWTYPE;
1700:
1701: CURSOR cur_usecs_in_group(cp_usec_x_listed_group_id igs_ps_usec_x_grpmem.usec_x_listed_group_id%TYPE) IS
1702: SELECT uoo_id
1703: FROM igs_ps_usec_x_grpmem
1704: WHERE usec_x_listed_group_id = cp_usec_x_listed_group_id;
1705:
1706: l_message_name fnd_new_messages.message_name%TYPE;
1707: l_request_id igs_ps_sch_hdr_int.request_id%TYPE;