APPS.IGS_AZ_GEN_001 dependencies on IGS_AZ_STUDENTS_PKG

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