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_AZ_GEN_001 dependencies on IGS_AZ_ADVISORS

Line 92: FROM igs_az_advisors azs

88:
89: CURSOR cur_advr_to_be_updated(cp_group_name VARCHAR2,cp_advisor_person_id NUMBER) IS
90: SELECT azs.ROWID row_id,
91: azs.*
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

Line 118: || ' SELECT ADVISOR_PERSON_ID PERSON_ID FROM IGS_AZ_ADVISORS WHERE GROUP_NAME = :2 ';

114: l_stc_adv_to_add VARCHAR2 (2000)
115: := ' SELECT PERSON_ID FROM IGS_PE_PRSID_GRP_MEM_ALL WHERE GROUP_ID = :1 '
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: --

Line 124: := ' MINUS SELECT ADVISOR_PERSON_ID PERSON_ID FROM IGS_AZ_ADVISORS WHERE GROUP_NAME = :1 ';

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

Line 150: := ' SELECT ADVISOR_PERSON_ID PERSON_ID FROM IGS_AZ_ADVISORS WHERE GROUP_NAME = :1 '

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

Line 159: := ' SELECT ADVISOR_PERSON_ID PERSON_ID FROM IGS_AZ_ADVISORS WHERE GROUP_NAME = :1 MINUS ';

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

Line 190: || ' SELECT ADVISOR_PERSON_ID PERSON_ID FROM IGS_AZ_ADVISORS WHERE GROUP_NAME = :2 '

186: l_stc_adv_to_upd VARCHAR2 (2000)
187: := ' SELECT PERSON_ID FROM IGS_PE_PRSID_GRP_MEM_ALL WHERE GROUP_ID = :1 '
188: || ' AND trunc(START_DATE) <= trunc(SYSDATE) AND NVL(END_DATE, SYSDATE) >= SYSDATE '
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

Line 198: := ' MINUS SELECT ADVISOR_PERSON_ID PERSON_ID FROM IGS_AZ_ADVISORS WHERE GROUP_NAME = :1 '

194: -- has accept flag set to none
195: -- for the group for dynamic group id
196: --
197: l_dyn_adv_to_upd VARCHAR2 (2000)
198: := ' MINUS SELECT ADVISOR_PERSON_ID PERSON_ID FROM IGS_AZ_ADVISORS WHERE GROUP_NAME = :1 '
199: || ' AND ACCEPT_ADD_FLAG IS NOT NULL';
200:
201: --
202: -- Declare a variable to store the person_id that would be obtained from the above ref cursors

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 909: FROM igs_az_advisors adv, (SELECT group_advisor_id,

905: adv.end_date,
906: adv.max_students_num maximum_load,
907: NVL (rel.actual_load, 0) actual_load,
908: NVL (rel.actual_load, 0) / NVL (adv.max_students_num, 1) percent_load
909: FROM igs_az_advisors adv, (SELECT group_advisor_id,
910: COUNT(*) actual_load
911: FROM igs_az_advising_rels
912: WHERE group_name = p_group_name
913: GROUP BY group_advisor_id) rel

Line 940: FROM igs_az_advisors

936: -- anilk, Bug# 3032626, STUDENT/ADVISOR STILL ACTIVE ON THE END DATE
937: --
938: CURSOR cur_max_stu_num IS
939: SELECT SUM (max_students_num)
940: FROM igs_az_advisors
941: WHERE TRUNC (start_date) <= TRUNC (SYSDATE)
942: AND NVL (end_date, SYSDATE + 1) > SYSDATE
943: AND group_name = p_group_name;
944: --

Line 953: FROM igs_az_advisors adv

949: FROM igs_az_advising_rels rel
950: WHERE group_name = p_group_name
951: AND EXISTS
952: (SELECT 1
953: FROM igs_az_advisors adv
954: WHERE rel.group_advisor_id = adv.group_advisor_id
955: AND TRUNC (adv.start_date) <= TRUNC (SYSDATE)
956: AND NVL (adv.end_date, SYSDATE + 1) > SYSDATE
957: AND adv.group_name = p_group_name);

Line 1406: FROM igs_az_advisors aza, igs_az_groups azg, hz_parties p

1402: SELECT aza.ROWID AS row_id,
1403: aza.*,
1404: p.party_number,
1405: p.party_name
1406: FROM igs_az_advisors aza, igs_az_groups azg, hz_parties p
1407: WHERE aza.group_name = p_group_name
1408: AND aza.accept_add_flag = 'Y'
1409: AND aza.start_date IS NOT NULL
1410: AND aza.end_date IS NULL

Line 1424: FROM igs_az_advisors aza, igs_az_groups azg, hz_parties p

1420: SELECT aza.ROWID AS row_id,
1421: aza.*,
1422: p.party_number,
1423: p.party_name
1424: FROM igs_az_advisors aza, igs_az_groups azg, hz_parties p
1425: WHERE aza.group_name = p_group_name
1426: AND aza.accept_add_flag = 'Y'
1427: AND aza.start_date IS NOT NULL
1428: AND aza.notified_date IS NULL

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 1954: FROM igs_az_advisors aza

1950: --
1951: CURSOR cur_adv_upd IS
1952: SELECT aza.ROWID row_id,
1953: aza.*
1954: FROM igs_az_advisors aza
1955: WHERE aza.group_name = p_group_name
1956: AND aza.advisor_person_id = p_advisor_person_id
1957: AND NVL (aza.accept_add_flag, 'Y') = 'Y';
1958: --

Line 1965: FROM igs_az_advisors aza

1961: -- 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'?
1962: --
1963: CURSOR cur_adv_del IS
1964: SELECT aza.ROWID row_id
1965: FROM igs_az_advisors aza
1966: WHERE aza.group_name = p_group_name
1967: AND aza.advisor_person_id = p_advisor_person_id
1968: AND aza.accept_add_flag = 'N';
1969: --

Line 1976: FROM igs_az_advising_rels azr, igs_az_advisors aza

1972: --
1973: CURSOR cur_reln IS
1974: SELECT azr.ROWID row_id,
1975: azr.*
1976: FROM igs_az_advising_rels azr, igs_az_advisors aza
1977: WHERE azr.group_name = p_group_name
1978: AND azr.group_name = aza.group_name
1979: AND azr.group_advisor_id = aza.group_advisor_id
1980: AND aza.advisor_person_id = p_advisor_person_id

Line 1988: FROM igs_az_advising_rels azr, igs_az_advisors aza

1984: --
1985: --
1986: CURSOR cur_reln_del IS
1987: SELECT azr.ROWID row_id
1988: FROM igs_az_advising_rels azr, igs_az_advisors aza
1989: WHERE azr.group_name = p_group_name
1990: AND azr.group_name = aza.group_name
1991: AND azr.group_advisor_id = aza.group_advisor_id
1992: AND aza.advisor_person_id = p_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

Line 2552: FROM igs_az_advisors aza

2548: -- Advisors in the group
2549: --
2550: CURSOR cur_adv IS
2551: SELECT advisor_person_id
2552: FROM igs_az_advisors aza
2553: WHERE aza.group_name = p_group_name;
2554: --
2555: -- Students in the group
2556: --