APPS.IGS_AZ_GEN_001 dependencies on IGS_AZ_ADVISORS_PKG

Line 229: lvAdvRowID VARCHAR2 (25); -- ROWID to be passed as parameter to IGS_AZ_ADVISORS_PKG.INSERT_ROW(An out parameter)

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
233: lnMsgCount NUMBER; -- Parameter to be passed to the procedures which have MSG_COUNT 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 521: igs_az_advisors_pkg.insert_row (

517: -- auto accept and start dates properly
518: --
519: -- Make a call to insert row for the group advisor
520: --
521: igs_az_advisors_pkg.insert_row (
522: x_rowid => lvAdvRowID,
523: x_group_advisor_id => lnGrpadvID,
524: x_group_name => grp_rec.group_name,
525: x_advisor_person_id => l_person_id,

Line 588: igs_az_advisors_pkg.update_row(

584: lvAutoAdvAddInd := p_advisor_rec.accept_add_flag;
585: END IF;
586:
587:
588: igs_az_advisors_pkg.update_row(
589: x_rowid => p_advisor_rec.row_id,
590: x_group_advisor_id => p_advisor_rec.group_advisor_id,
591: x_group_name => p_advisor_rec.group_name,
592: x_advisor_person_id => p_advisor_rec.advisor_person_id,

Line 1668: igs_az_advisors_pkg.update_row(

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,
1671: x_group_name => add_adv_rec.group_name,
1672: x_advisor_person_id => add_adv_rec.advisor_person_id,

Line 1743: igs_az_advisors_pkg.update_row(

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,
1746: x_group_name => del_adv_rec.group_name,
1747: x_advisor_person_id => del_adv_rec.advisor_person_id,

Line 2065: igs_az_advisors_pkg.update_row (

2061: -- Update the advising record
2062: --
2063: FOR adv_upd_rec IN cur_adv_upd LOOP
2064: IF p_calling_mod = 'C' THEN
2065: igs_az_advisors_pkg.update_row (
2066: x_rowid => adv_upd_rec.row_id,
2067: x_group_advisor_id => adv_upd_rec.group_advisor_id,
2068: x_group_name => adv_upd_rec.group_name,
2069: x_advisor_person_id => adv_upd_rec.advisor_person_id,

Line 2086: igs_az_advisors_pkg.delete_row (

2082: --
2083: -- See if the record has to be deleted
2084: --
2085: FOR adv_del_rec IN cur_adv_del LOOP
2086: igs_az_advisors_pkg.delete_row (
2087: adv_del_rec.row_id,
2088: lvReturnStatus,
2089: lvMsgData,
2090: lnMsgCount