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.

[Home] [Help]

APPS.IGS_AZ_GEN_001 dependencies on IGS_AZ_STUDENTS

Line 85: FROM igs_az_students azs

81:
82: CURSOR cur_stdt_to_be_updated(cp_group_name VARCHAR2,cp_student_person_id NUMBER) IS
83: SELECT azs.ROWID row_id,
84: azs.*
85: FROM igs_az_students azs
86: where GROUP_NAME = cp_group_name
87: AND STUDENT_PERSON_ID = cp_student_person_id;
88:
89: CURSOR cur_advr_to_be_updated(cp_group_name VARCHAR2,cp_advisor_person_id NUMBER) IS

Line 96: -- Variable to store select the Students in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table

92: FROM igs_az_advisors azs
93: where GROUP_NAME = cp_group_name
94: AND ADVISOR_PERSON_ID = cp_advisor_person_id;
95: --
96: -- Variable to store select the Students in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table
97: -- for the group for static group id
98: --
99: l_stc_std_to_add VARCHAR2 (2000)
100: := ' SELECT PERSON_ID FROM IGS_PE_PRSID_GRP_MEM_ALL WHERE GROUP_ID = :1 '

Line 103: || ' SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :2 ';

99: l_stc_std_to_add VARCHAR2 (2000)
100: := ' SELECT PERSON_ID FROM IGS_PE_PRSID_GRP_MEM_ALL WHERE GROUP_ID = :1 '
101: || ' AND trunc(START_DATE) <= trunc(SYSDATE) AND NVL(END_DATE, SYSDATE) >= SYSDATE '
102: || ' MINUS '
103: || ' SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :2 ';
104: --
105: -- Variable to store select the Students in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table
106: -- for the group for dynamic group id
107: --

Line 105: -- Variable to store select the Students in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table

101: || ' AND trunc(START_DATE) <= trunc(SYSDATE) AND NVL(END_DATE, SYSDATE) >= SYSDATE '
102: || ' MINUS '
103: || ' SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :2 ';
104: --
105: -- Variable to store select the Students in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table
106: -- for the group for dynamic group id
107: --
108: l_dyn_std_to_add VARCHAR2 (2000)
109: := ' MINUS SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :1 ';

Line 109: := ' MINUS SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :1 ';

105: -- Variable to store select the Students in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table
106: -- for the group for dynamic group id
107: --
108: l_dyn_std_to_add VARCHAR2 (2000)
109: := ' MINUS SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :1 ';
110: --
111: -- Variable to store to select the ADVISORS in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table
112: -- for the group for static group id
113: --

Line 111: -- Variable to store to select the ADVISORS in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table

107: --
108: l_dyn_std_to_add VARCHAR2 (2000)
109: := ' MINUS SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :1 ';
110: --
111: -- Variable to store to select the ADVISORS in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table
112: -- for the group for static group id
113: --
114: l_stc_adv_to_add VARCHAR2 (2000)
115: := ' SELECT PERSON_ID FROM IGS_PE_PRSID_GRP_MEM_ALL WHERE GROUP_ID = :1 '

Line 120: -- variable to store to select the ADVISORS in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table

116: || ' AND trunc(START_DATE) <= trunc(SYSDATE) AND NVL(END_DATE, SYSDATE) >= SYSDATE '
117: || ' MINUS '
118: || ' SELECT ADVISOR_PERSON_ID PERSON_ID FROM IGS_AZ_ADVISORS WHERE GROUP_NAME = :2 ';
119: --
120: -- variable to store to select the ADVISORS in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table
121: -- for the group for dynamic group id
122: --
123: l_dyn_adv_to_add VARCHAR2 (2000)
124: := ' MINUS SELECT ADVISOR_PERSON_ID PERSON_ID FROM IGS_AZ_ADVISORS WHERE GROUP_NAME = :1 ';

Line 126: -- Variable to store to select the Students existing inthe IGS_AZ_STUDENTS table MINUS

122: --
123: l_dyn_adv_to_add VARCHAR2 (2000)
124: := ' MINUS SELECT ADVISOR_PERSON_ID PERSON_ID FROM IGS_AZ_ADVISORS WHERE GROUP_NAME = :1 ';
125: --
126: -- Variable to store to select the Students existing inthe IGS_AZ_STUDENTS table MINUS
127: -- those in the student person ID group for static group id
128: --
129: l_stc_std_to_del VARCHAR2 (2000)
130: := ' SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :1 '

Line 130: := ' SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :1 '

126: -- Variable to store to select the Students existing inthe IGS_AZ_STUDENTS table MINUS
127: -- those in the student person ID group for static group id
128: --
129: l_stc_std_to_del VARCHAR2 (2000)
130: := ' SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :1 '
131: || ' AND NVL(ACCEPT_DELETE_FLAG, ''N'') = ''N'' '
132: || ' MINUS '
133: || ' SELECT PERSON_ID FROM IGS_PE_PRSID_GRP_MEM_ALL WHERE GROUP_ID = :2 '
134: || ' AND NVL(END_DATE, SYSDATE) >= SYSDATE AND trunc(START_DATE) <= trunc(SYSDATE) ';

Line 139: -- Variable to store to select the Students existing inthe IGS_AZ_STUDENTS table MINUS

135: --
136: -- To do see the effective date in person ID group
137: --
138: --
139: -- Variable to store to select the Students existing inthe IGS_AZ_STUDENTS table MINUS
140: -- those in the student person ID group for dynamic group id
141: --
142: l_dyn_std_to_del VARCHAR2 (2000)
143: := ' SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :1 '

Line 143: := ' SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :1 '

139: -- Variable to store to select the Students existing inthe IGS_AZ_STUDENTS table MINUS
140: -- those in the student person ID group for dynamic group id
141: --
142: l_dyn_std_to_del VARCHAR2 (2000)
143: := ' SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :1 '
144: || ' AND NVL(ACCEPT_DELETE_FLAG, ''N'') = ''N'' MINUS ';
145: --
146: -- Variable to store to select the advisors existing inthe IGS_AZ_STUDENTS table MINUS
147: -- those in the advisor person ID group for static group id

Line 146: -- Variable to store to select the advisors existing inthe IGS_AZ_STUDENTS table MINUS

142: l_dyn_std_to_del VARCHAR2 (2000)
143: := ' SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :1 '
144: || ' AND NVL(ACCEPT_DELETE_FLAG, ''N'') = ''N'' MINUS ';
145: --
146: -- Variable to store to select the advisors existing inthe IGS_AZ_STUDENTS table MINUS
147: -- those in the advisor person ID group for static group id
148: --
149: l_stc_adv_to_del VARCHAR2 (2000)
150: := ' SELECT ADVISOR_PERSON_ID PERSON_ID FROM IGS_AZ_ADVISORS WHERE GROUP_NAME = :1 '

Line 155: -- Variable to store to select the advisors existing inthe IGS_AZ_STUDENTS table MINUS

151: || ' MINUS '
152: || ' SELECT PERSON_ID FROM IGS_PE_PRSID_GRP_MEM_ALL WHERE GROUP_ID = :2 '
153: || ' AND NVL(END_DATE, SYSDATE) >= SYSDATE AND trunc(START_DATE) <= trunc(SYSDATE) ';
154: --
155: -- Variable to store to select the advisors existing inthe IGS_AZ_STUDENTS table MINUS
156: -- those in the advisor person ID group for dynamic group id
157: --
158: l_dyn_adv_to_del VARCHAR2 (2000)
159: := ' SELECT ADVISOR_PERSON_ID PERSON_ID FROM IGS_AZ_ADVISORS WHERE GROUP_NAME = :1 MINUS ';

Line 163: -- Variable to store select the Students in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table who

159: := ' SELECT ADVISOR_PERSON_ID PERSON_ID FROM IGS_AZ_ADVISORS WHERE GROUP_NAME = :1 MINUS ';
160:
161: -- sepalani For Bug # 5188499
162: --
163: -- Variable to store select the Students in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table who
164: -- has accept flag set to none
165: -- for the group for static group id
166: --
167: l_stc_std_to_upd VARCHAR2 (2000)

Line 171: || ' SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :2 '

167: l_stc_std_to_upd VARCHAR2 (2000)
168: := ' SELECT PERSON_ID FROM IGS_PE_PRSID_GRP_MEM_ALL WHERE GROUP_ID = :1 '
169: || ' AND trunc(START_DATE) <= trunc(SYSDATE) AND NVL(END_DATE, SYSDATE) >= SYSDATE '
170: || ' MINUS '
171: || ' SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :2 '
172: || ' AND ACCEPT_ADD_FLAG IS NOT NULL';
173: --
174: -- Variable to store select the Students in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table who
175: -- has accept flag set to none

Line 174: -- Variable to store select the Students in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table who

170: || ' MINUS '
171: || ' SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :2 '
172: || ' AND ACCEPT_ADD_FLAG IS NOT NULL';
173: --
174: -- Variable to store select the Students in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table who
175: -- has accept flag set to none
176: -- for the group for dynamic group id
177: --
178: l_dyn_std_to_upd VARCHAR2 (2000)

Line 179: := ' MINUS SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :1 '

175: -- has accept flag set to none
176: -- for the group for dynamic group id
177: --
178: l_dyn_std_to_upd VARCHAR2 (2000)
179: := ' MINUS SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :1 '
180: || ' AND ACCEPT_ADD_FLAG IS NOT NULL';
181: --
182: -- Variable to store to select the ADVISORS in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table who
183: -- has accept flag set to none

Line 182: -- Variable to store to select the ADVISORS in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table who

178: l_dyn_std_to_upd VARCHAR2 (2000)
179: := ' MINUS SELECT STUDENT_PERSON_ID PERSON_ID FROM IGS_AZ_STUDENTS WHERE GROUP_NAME = :1 '
180: || ' AND ACCEPT_ADD_FLAG IS NOT NULL';
181: --
182: -- Variable to store to select the ADVISORS in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table who
183: -- has accept flag set to none
184: -- for the group for static group id
185: --
186: l_stc_adv_to_upd VARCHAR2 (2000)

Line 193: -- variable to store to select the ADVISORS in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table who

189: || ' MINUS '
190: || ' SELECT ADVISOR_PERSON_ID PERSON_ID FROM IGS_AZ_ADVISORS WHERE GROUP_NAME = :2 '
191: || ' AND ACCEPT_ADD_FLAG IS NOT NULL';
192: --
193: -- variable to store to select the ADVISORS in the existing Student PID grop minus that one for the IGS_AZ_STUDENTS table who
194: -- has accept flag set to none
195: -- for the group for dynamic group id
196: --
197: l_dyn_adv_to_upd VARCHAR2 (2000)

Line 227: lvStdRowID VARCHAR2 (25); -- ROWID to be passed as parameter to IGS_AZ_STUDENTS_PKG.INSERT_ROW(An out parameter)

223: lvcNotifErbuf VARCHAR2 (1000); -- Err buf code for making a call to send notification (its out parameter)
224: lvNotifRtCode VARCHAR2 (100);
225: lvcApplHldErbuf VARCHAR2 (1000); -- Err buf code for making a call to apply hold (its out parameter)
226: lvApplHldrtcode VARCHAR2 (100);
227: lvStdRowID VARCHAR2 (25); -- ROWID to be passed as parameter to IGS_AZ_STUDENTS_PKG.INSERT_ROW(An out parameter)
228: lnGrpStdID igs_az_students.group_student_id%TYPE; -- Group Student ID to be passed as parameter to IGS_AZ_STUDENTS_PKG.INSERT_ROW(An out parameter)
229: lvAdvRowID VARCHAR2 (25); -- ROWID to be passed as parameter to IGS_AZ_ADVISORS_PKG.INSERT_ROW(An out parameter)
230: lnGrpadvID igs_az_students.group_student_id%TYPE; -- Group Student ID to be passed as parameter to IGS_AZ_ADVISORS_PKG.INSERT_ROW(An out parameter)
231: lvReturnStatus VARCHAR2 (1); -- Parameter to be passed to the procedures which have RETURN_STATUS as an out paramere

Line 228: lnGrpStdID igs_az_students.group_student_id%TYPE; -- Group Student ID to be passed as parameter to IGS_AZ_STUDENTS_PKG.INSERT_ROW(An out parameter)

224: lvNotifRtCode VARCHAR2 (100);
225: lvcApplHldErbuf VARCHAR2 (1000); -- Err buf code for making a call to apply hold (its out parameter)
226: lvApplHldrtcode VARCHAR2 (100);
227: lvStdRowID VARCHAR2 (25); -- ROWID to be passed as parameter to IGS_AZ_STUDENTS_PKG.INSERT_ROW(An out parameter)
228: lnGrpStdID igs_az_students.group_student_id%TYPE; -- Group Student ID to be passed as parameter to IGS_AZ_STUDENTS_PKG.INSERT_ROW(An out parameter)
229: lvAdvRowID VARCHAR2 (25); -- ROWID to be passed as parameter to IGS_AZ_ADVISORS_PKG.INSERT_ROW(An out parameter)
230: lnGrpadvID igs_az_students.group_student_id%TYPE; -- Group Student ID to be passed as parameter to IGS_AZ_ADVISORS_PKG.INSERT_ROW(An out parameter)
231: lvReturnStatus VARCHAR2 (1); -- Parameter to be passed to the procedures which have RETURN_STATUS as an out paramere
232: lvMsgData VARCHAR2 (1000); -- Parameter to be passed to the procedures which have MSG_DATA as an out paramere

Line 230: lnGrpadvID igs_az_students.group_student_id%TYPE; -- Group Student ID to be passed as parameter to IGS_AZ_ADVISORS_PKG.INSERT_ROW(An out parameter)

226: lvApplHldrtcode VARCHAR2 (100);
227: lvStdRowID VARCHAR2 (25); -- ROWID to be passed as parameter to IGS_AZ_STUDENTS_PKG.INSERT_ROW(An out parameter)
228: lnGrpStdID igs_az_students.group_student_id%TYPE; -- Group Student ID to be passed as parameter to IGS_AZ_STUDENTS_PKG.INSERT_ROW(An out parameter)
229: lvAdvRowID VARCHAR2 (25); -- ROWID to be passed as parameter to IGS_AZ_ADVISORS_PKG.INSERT_ROW(An out parameter)
230: lnGrpadvID igs_az_students.group_student_id%TYPE; -- Group Student ID to be passed as parameter to IGS_AZ_ADVISORS_PKG.INSERT_ROW(An out parameter)
231: lvReturnStatus VARCHAR2 (1); -- Parameter to be passed to the procedures which have RETURN_STATUS as an out paramere
232: lvMsgData VARCHAR2 (1000); -- Parameter to be passed to the procedures which have MSG_DATA as an out paramere
233: lnMsgCount NUMBER; -- Parameter to be passed to the procedures which have MSG_COUNT as an out paramere
234: -- sepalani

Line 375: igs_az_students_pkg.insert_row (

371: -- Get the nextvalue from the sequence ..
372: --
373: -- Now call insert row
374: --
375: igs_az_students_pkg.insert_row (
376: x_rowid => lvStdRowID,
377: x_group_student_id => lnGrpStdID,
378: x_group_name => grp_rec.group_name,
379: x_student_person_id => l_person_id,

Line 444: igs_az_students_pkg.update_row (

440: IF lvAutoStdAddInd IS NULL THEN
441: lvAutoStdAddInd := p_student_rec.accept_add_flag;
442: END IF;
443:
444: igs_az_students_pkg.update_row (
445: x_rowid => p_student_rec.row_id,
446: x_group_student_id => p_student_rec.group_student_id,
447: x_group_name => p_student_rec.group_name,
448: x_student_person_id => p_student_rec.student_person_id,

Line 889: FROM igs_az_students stu

885: --
886: CURSOR cur_students_to_match IS
887: SELECT stu.group_student_id,
888: stu.end_date
889: FROM igs_az_students stu
890: WHERE TRUNC (stu.start_date) <= TRUNC (SYSDATE)
891: AND NVL (stu.end_date, SYSDATE + 1) > SYSDATE
892: AND stu.group_name = p_group_name
893: AND NOT EXISTS

Line 926: FROM igs_az_students st

922: -- anilk, Bug# 3032626, STUDENT/ADVISOR STILL ACTIVE ON THE END DATE
923: --
924: CURSOR cur_find_count IS
925: SELECT COUNT (group_student_id)
926: FROM igs_az_students st
927: WHERE TRUNC (start_date) <= SYSDATE
928: AND NVL (end_date, SYSDATE + 1) > SYSDATE
929: AND group_name = p_group_name
930: AND NOT EXISTS

Line 1113: FROM igs_az_students azs ,

1109: SELECT azs.ROWID row_id,
1110: azs.*,
1111: p.party_number,
1112: p.party_name
1113: FROM igs_az_students azs ,
1114: hz_parties p
1115: WHERE azs.group_name = cp_group_name
1116: AND azs.advising_hold_type IS NULL
1117: AND azs.hold_start_date IS NULL

Line 1145: cp_student_person_id igs_az_students.student_person_id%TYPE,

1141: --
1142: --
1143: --
1144: CURSOR cur_az_holds_upd (
1145: cp_student_person_id igs_az_students.student_person_id%TYPE,
1146: cp_group_name igs_az_students.group_name%TYPE) IS
1147: SELECT start_date
1148: FROM igs_az_students
1149: WHERE student_person_id = cp_student_person_id

Line 1146: cp_group_name igs_az_students.group_name%TYPE) IS

1142: --
1143: --
1144: CURSOR cur_az_holds_upd (
1145: cp_student_person_id igs_az_students.student_person_id%TYPE,
1146: cp_group_name igs_az_students.group_name%TYPE) IS
1147: SELECT start_date
1148: FROM igs_az_students
1149: WHERE student_person_id = cp_student_person_id
1150: AND group_name = cp_group_name;

Line 1148: FROM igs_az_students

1144: CURSOR cur_az_holds_upd (
1145: cp_student_person_id igs_az_students.student_person_id%TYPE,
1146: cp_group_name igs_az_students.group_name%TYPE) IS
1147: SELECT start_date
1148: FROM igs_az_students
1149: WHERE student_person_id = cp_student_person_id
1150: AND group_name = cp_group_name;
1151: --
1152: -- Local Variables here

Line 1283: igs_az_students_pkg.update_row (

1279: END IF;
1280: --
1281: -- Now update the advising student table with the HOLD_APPLIED and start Date.
1282: --
1283: igs_az_students_pkg.update_row (
1284: x_rowid => std_rec.row_id,
1285: x_group_student_id => std_rec.group_student_id,
1286: x_group_name => std_rec.group_name,
1287: x_student_person_id => std_rec.student_person_id,

Line 1376: FROM igs_az_students azs, hz_parties p

1372: SELECT azs.ROWID AS row_id,
1373: azs.*,
1374: p.party_number,
1375: p.party_name
1376: FROM igs_az_students azs, hz_parties p
1377: WHERE azs.group_name = p_group_name
1378: AND azs.accept_add_flag = 'Y'
1379: AND azs.start_date IS NOT NULL
1380: AND azs.end_date IS NULL

Line 1391: FROM igs_az_students azs, hz_parties p

1387: SELECT azs.ROWID AS row_id,
1388: azs.*,
1389: p.party_number,
1390: p.party_name
1391: FROM igs_az_students azs, hz_parties p
1392: WHERE azs.group_name = p_group_name
1393: AND azs.accept_add_flag = 'Y'
1394: AND azs.notified_date IS NULL
1395: AND azs.start_date IS NOT NULL

Line 1486: -- Now since the student is slated to be notified, updated the IGS_AZ_STUDENTS table with NOTIFIED_DATE = sysdate.

1482: fnd_message.set_name('IGS', 'IGS_AZ_STU_LIST_ADD');
1483: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
1484: END IF;
1485: --
1486: -- Now since the student is slated to be notified, updated the IGS_AZ_STUDENTS table with NOTIFIED_DATE = sysdate.
1487: --
1488: igs_az_students_pkg.update_row(
1489: x_rowid => add_std_rec.row_id,
1490: x_group_student_id => add_std_rec.group_student_id,

Line 1488: igs_az_students_pkg.update_row(

1484: END IF;
1485: --
1486: -- Now since the student is slated to be notified, updated the IGS_AZ_STUDENTS table with NOTIFIED_DATE = sysdate.
1487: --
1488: igs_az_students_pkg.update_row(
1489: x_rowid => add_std_rec.row_id,
1490: x_group_student_id => add_std_rec.group_student_id,
1491: x_group_name => add_std_rec.group_name,
1492: x_student_person_id => add_std_rec.student_person_id,

Line 1581: -- Now since the student is slated to be notified. updated the IGS_AZ_STUDENTS table with NOTIFIED_DATE = sysdate.

1577: fnd_msg_pub.initialize;
1578: --
1579: FOR del_std_rec IN cur_std_del LOOP
1580: --
1581: -- Now since the student is slated to be notified. updated the IGS_AZ_STUDENTS table with NOTIFIED_DATE = sysdate.
1582: --
1583: igs_az_students_pkg.update_row(
1584: x_rowid => del_std_rec.row_id,
1585: x_group_student_id => del_std_rec.group_student_id,

Line 1583: igs_az_students_pkg.update_row(

1579: FOR del_std_rec IN cur_std_del LOOP
1580: --
1581: -- Now since the student is slated to be notified. updated the IGS_AZ_STUDENTS table with NOTIFIED_DATE = sysdate.
1582: --
1583: igs_az_students_pkg.update_row(
1584: x_rowid => del_std_rec.row_id,
1585: x_group_student_id => del_std_rec.group_student_id,
1586: x_group_name => del_std_rec.group_name,
1587: x_student_person_id => del_std_rec.student_person_id,

Line 1666: -- Now since the advisor is slated to be notified for being added to the group , updated the IGS_AZ_STUDENTS table with NOTIFIED_DATE = sysdate.

1662: FOR add_adv_rec IN cur_adv_add LOOP
1663: --
1664: lvcpersonids := lvcpersonids || ',' || add_adv_rec.advisor_person_id; -- To do See here I am using student_person_id inplace of Froup_student_ID(seq gen PK) as mentioned in FD.
1665: --
1666: -- Now since the advisor is slated to be notified for being added to the group , updated the IGS_AZ_STUDENTS table with NOTIFIED_DATE = sysdate.
1667: --
1668: igs_az_advisors_pkg.update_row(
1669: x_rowid => add_adv_rec.row_id,
1670: x_group_advisor_id => add_adv_rec.group_advisor_id,

Line 1741: -- Now since the advisor is slated to be notified about removal from group, updated the IGS_AZ_STUDENTS table with NOTIFIED_DATE = sysdate.

1737: lvMsgData := NULL;
1738: lnMsgCount := NULL;
1739: lvcpersonids := lvcpersonids || ',' || del_adv_rec.advisor_person_id; -- To do See here I am using advisor_person_id inplace of Group_advisor_ID(seq gen PK) as mentioned in FD.
1740: --
1741: -- Now since the advisor is slated to be notified about removal from group, updated the IGS_AZ_STUDENTS table with NOTIFIED_DATE = sysdate.
1742: --
1743: igs_az_advisors_pkg.update_row(
1744: x_rowid => del_adv_rec.row_id,
1745: x_group_advisor_id => del_adv_rec.group_advisor_id,

Line 2133: FROM igs_az_students azs

2129: --
2130: CURSOR cur_std_upd IS
2131: SELECT azs.ROWID row_id,
2132: azs.*
2133: FROM igs_az_students azs
2134: WHERE azs.group_name = p_group_name
2135: AND azs.student_person_id = p_student_person_id
2136: AND NVL (azs.accept_add_flag, 'Y') = 'Y';
2137: --

Line 2144: FROM igs_az_students azs

2140: -- Advisor person_id Passed.. To do .. Can this happen from SS Screen? Can I have a record with ACCEPT_ADD_FLAG = 'Y' and again make that to 'N'?
2141: --
2142: CURSOR cur_std_del IS
2143: SELECT azs.ROWID row_id
2144: FROM igs_az_students azs
2145: WHERE azs.group_name = p_group_name
2146: AND azs.student_person_id = p_student_person_id
2147: AND azs.accept_add_flag = 'N';
2148: --

Line 2155: FROM igs_az_advising_rels azr, igs_az_students azs

2151: --
2152: CURSOR cur_reln IS
2153: SELECT azr.ROWID row_id,
2154: azr.*
2155: FROM igs_az_advising_rels azr, igs_az_students azs
2156: WHERE azr.group_name = p_group_name
2157: AND azr.group_name = azs.group_name
2158: AND azr.group_student_id = azs.group_student_id
2159: AND azs.student_person_id = p_student_person_id

Line 2174: FROM igs_az_advising_rels azr, igs_az_students azs

2170: --
2171: --
2172: CURSOR cur_reln_del IS
2173: SELECT azr.ROWID row_id
2174: FROM igs_az_advising_rels azr, igs_az_students azs
2175: WHERE azr.group_name = p_group_name
2176: AND azr.group_name = azs.group_name
2177: AND azr.group_student_id = azs.group_student_id
2178: AND azs.student_person_id = p_student_person_id

Line 2244: igs_az_students_pkg.update_row (

2240: -- Update the advising record
2241: --
2242: FOR std_upd_rec IN cur_std_upd LOOP
2243: IF p_calling_mod = 'C' THEN -- This is because from the ss pages, there will already be call to update row for this table.
2244: igs_az_students_pkg.update_row (
2245: x_rowid => std_upd_rec.row_id,
2246: x_group_student_id => std_upd_rec.group_student_id,
2247: x_group_name => std_upd_rec.group_name,
2248: x_student_person_id => std_upd_rec.student_person_id,

Line 2274: igs_az_students_pkg.delete_row (

2270: --
2271: -- See if the record has to be deleted
2272: --
2273: FOR std_del_rec IN cur_std_del LOOP
2274: igs_az_students_pkg.delete_row (
2275: std_del_rec.row_id,
2276: lvReturnStatus,
2277: lvMsgData,
2278: lnMsgCount

Line 2297: FROM igs_az_students azs

2293: --
2294: CURSOR cur_std_hold IS
2295: SELECT azs.ROWID row_id,
2296: azs.*
2297: FROM igs_az_students azs
2298: WHERE azs.group_name = p_group_name AND azs.student_person_id = p_person_id;
2299: --
2300: -- Cursor to get all the advising holds of the students that were applied as part of this group and which are not yet end dated.
2301: --

Line 2559: FROM igs_az_students azs

2555: -- Students in the group
2556: --
2557: CURSOR cur_stud IS
2558: SELECT student_person_id
2559: FROM igs_az_students azs
2560: WHERE azs.group_name = p_group_name;
2561: --
2562: grp_rec cur_grp%ROWTYPE;
2563: l_return_status VARCHAR2 (1);