APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_PS_USEC_X_GRPMEM

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 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 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;