[Home] [Help]
72: --
73: CURSOR cur_grp_to_be_processed IS
74: SELECT azg.ROWID row_id,
75: azg.*
76: FROM igs_az_groups azg
77: WHERE (azg.group_name = p_group_name
78: AND azg.delivery_method_code <> 'SELF')
79: OR (p_group_name IS NULL
80: AND azg.auto_refresh_flag = 'Y');
782: -- to do error handling and loggin
783: --
784: END IF; -- End Apply Hold
785: --
786: -- Now update the IGS_AZ_GROUPS table for last_auto_refres_dt with SYSDATE.
787: --
788: igs_az_groups_pkg.update_row (
789: x_rowid => grp_rec.row_id,
790: x_group_name => grp_rec.group_name,
784: END IF; -- End Apply Hold
785: --
786: -- Now update the IGS_AZ_GROUPS table for last_auto_refres_dt with SYSDATE.
787: --
788: igs_az_groups_pkg.update_row (
789: x_rowid => grp_rec.row_id,
790: x_group_name => grp_rec.group_name,
791: x_group_desc => grp_rec.group_desc,
792: x_advising_code => grp_rec.advising_code,
877: -- Cursor to detremine whether Match is to start dated automatically:
878: --
879: CURSOR auto_match_cur IS
880: SELECT auto_match_flag
881: FROM igs_az_groups
882: WHERE group_name = p_group_name;
883: --
884: -- anilk, Bug# 3032626, STUDENT/ADVISOR STILL ACTIVE ON THE END DATE
885: --
1089: -- Cursor to get the hold Type defined for the group
1090: --
1091: CURSOR cur_hold_Type IS
1092: SELECT advising_hold_type
1093: FROM igs_az_groups
1094: WHERE group_name = p_group_name;
1095: --
1096: -- Cursor to get all the default hold effect associated with the Hold Type
1097: --
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
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
1995: --
1996: --
1997: CURSOR cur_grp IS
1998: SELECT auto_advisor_remove_flag
1999: FROM igs_az_groups azg
2000: WHERE azg.group_name = p_group_name;
2001: --
2002: -- Local variables:
2003: --
2163: --
2164: --
2165: CURSOR cur_grp IS
2166: SELECT auto_stdnt_remove_flag
2167: FROM igs_az_groups azg
2168: WHERE azg.group_name = p_group_name;
2169: --
2170: --
2171: --
2375: --
2376: --
2377: --
2378: PROCEDURE submit_maintain_group_job (
2379: p_group_name IN igs_az_groups.group_name%TYPE,
2380: p_return_status OUT NOCOPY VARCHAR2,
2381: p_message_data OUT NOCOPY VARCHAR2,
2382: p_message_count OUT NOCOPY NUMBER,
2383: p_request_id OUT NOCOPY NUMBER
2541: --
2542: CURSOR cur_grp IS
2543: SELECT azg.ROWID row_id,
2544: azg.*
2545: FROM igs_az_groups azg
2546: WHERE azg.group_name = p_group_name;
2547: --
2548: -- Advisors in the group
2549: --
2569: OPEN cur_grp;
2570: FETCH cur_grp INTO grp_rec;
2571: CLOSE cur_grp;
2572: --
2573: igs_az_groups_pkg.update_row (
2574: x_rowid => grp_rec.row_id,
2575: x_group_name => grp_rec.group_name,
2576: x_group_desc => grp_rec.group_desc,
2577: x_advising_code => grp_rec.advising_code,
2662: --
2663: CURSOR cur_grp IS
2664: SELECT azg.ROWID row_id,
2665: azg.*
2666: FROM igs_az_groups azg
2667: WHERE azg.group_name = p_group_name;
2668: --
2669: grp_rec cur_grp%ROWTYPE;
2670: l_return_status VARCHAR2 (1);
2676: OPEN cur_grp;
2677: FETCH cur_grp INTO grp_rec;
2678: CLOSE cur_grp;
2679: --
2680: igs_az_groups_pkg.update_row (
2681: x_rowid => grp_rec.row_id,
2682: x_group_name => grp_rec.group_name,
2683: x_group_desc => grp_rec.group_desc,
2684: x_advising_code => grp_rec.advising_code,