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_GR_GEN_002 dependencies on IGS_GR_AWD_CRMN

Line 1016: -- ceremonies by creating IGS_GR_AWD_CRMN records and the

1012: p_graduand_status IGS_GR_STAT.GRADUAND_STATUS%TYPE;
1013:
1014: BEGIN -- grdp_prc_gac
1015: -- This process manages the initial allocation of IGS_GR_GRADUAND records to
1016: -- ceremonies by creating IGS_GR_AWD_CRMN records and the
1017: -- re-alloaction of graduands when IGS_GR_AWD_CEREMONY and
1018: -- IGS_GR_AWD_CRM_US_GP records are closed.
1019: -- The process finds closed IGS_GR_AWD_CEREMONY records for the specified
1020: -- IGS_GR_CRMN_ROUND, calls GENP_PRC_AWC_CLOSE to re-allocate any associated

Line 1027: -- IGS_GR_AWD_CRMN record and calls GENP_INS_GAC to determine if a

1023: -- IGS_GR_CRMN_ROUND, calls GENP_PRC_ACUSG_CLOSE to re-allocate any associated
1024: -- graduands.
1025: -- The process finds any IGS_GR_GRADUAND records for the specified IGS_GR_CRMN_ROUND,
1026: -- location_cd, and IGS_GR_STAT which do not have an existing
1027: -- IGS_GR_AWD_CRMN record and calls GENP_INS_GAC to determine if a
1028: -- ceremony exists suitable for the IGS_GR_GRADUAND and if one is suitable create
1029: -- a IGS_GR_AWD_CRMN record linking the IGS_GR_GRADUAND to it.
1030:
1031: --

Line 1029: -- a IGS_GR_AWD_CRMN record linking the IGS_GR_GRADUAND to it.

1025: -- The process finds any IGS_GR_GRADUAND records for the specified IGS_GR_CRMN_ROUND,
1026: -- location_cd, and IGS_GR_STAT which do not have an existing
1027: -- IGS_GR_AWD_CRMN record and calls GENP_INS_GAC to determine if a
1028: -- ceremony exists suitable for the IGS_GR_GRADUAND and if one is suitable create
1029: -- a IGS_GR_AWD_CRMN record linking the IGS_GR_GRADUAND to it.
1030:
1031: --
1032: -- Change History :
1033: -- Who When What

Line 1104: FROM IGS_GR_AWD_CRMN gac

1100: gr.course_cd = sca.course_cd AND
1101: sca.location_cd like p_location_cd AND
1102: NOT EXISTS
1103: (SELECT 'X'
1104: FROM IGS_GR_AWD_CRMN gac
1105: WHERE gac.person_id = gr.person_id AND
1106: gac.create_dt = gr.create_dt);
1107: --
1108: -- sepalani Bug# 5074150

Line 1184: -- IGS_GR_AWD_CRMN record and loop through them.

1180: END IF;
1181: END LOOP; -- c_acusg
1182: -- 4.1 Find any IGS_GR_GRADUAND records matching the IGS_GR_CRMN_ROUND, location_cd
1183: -- and IGS_GR_STAT specified which do not have an existing
1184: -- IGS_GR_AWD_CRMN record and loop through them.
1185: FOR v_gr_rec IN c_gr LOOP
1186: SAVEPOINT sp_prc_gac;
1187: -- 4.2 If the IGS_GR_GRADUAND has been deferred into this IGS_GR_CRMN_ROUND update the
1188: -- s_graduand_type from DEFERRED to UNKOWN. DO NOT COMMIT THIS UPDATE.

Line 1195: -- 3.Delete the existing IGS_GR_AWD_CRMN record

1191: OPEN c_gr_upd(
1192: v_gr_rec.person_id,
1193: v_gr_rec.create_dt);
1194: FETCH c_gr_upd INTO v_gr_del;
1195: -- 3.Delete the existing IGS_GR_AWD_CRMN record
1196: IF (c_gr_upd%FOUND) THEN
1197: IGS_GR_GRADUAND_PKG.UPDATE_ROW(
1198: X_ROWID => v_gr_del.rowid,
1199: X_PERSON_ID => v_gr_del.person_id,

Line 1258: -- create a IGS_GR_AWD_CRMN record allocating it to an appropriate

1254: RAISE;
1255: END;
1256: END IF;
1257: -- 4.3 Call GENP_PRC_GAC_CRMNY for each IGS_GR_GRADUAND record found which will
1258: -- create a IGS_GR_AWD_CRMN record allocating it to an appropriate
1259: -- ceremony if one is available.
1260: IF IGS_GR_PRC_GAC.grdp_ins_gac(
1261: v_gr_rec.person_id,
1262: v_gr_rec.create_dt ,

Line 1285: -- IGS_GR_AWD_CRMN record.

1281: -- 4.4 If the IGS_GR_GRADUAND has been deferred into this IGS_GR_CRMN_ROUND and they
1282: -- have not been placed in a ceremony, ROLLBACK the change to the
1283: -- s_graduand_type to DEFERRED. If they were placed in a ceremony round
1284: -- this change would have been commited on the insert of the
1285: -- IGS_GR_AWD_CRMN record.
1286: IF v_gr_rec.s_graduand_type = cst_deferred THEN
1287: ROLLBACK;
1288: END IF;
1289: END LOOP; -- c_gr

Line 1646: -- Set the IGS_GR_AWD_CRMN.order_in_presentation based on the

1642: l_msg_text varchar2(200);
1643: l_message_name VARCHAR2(200);
1644:
1645: BEGIN -- grdp_upd_gac_order
1646: -- Set the IGS_GR_AWD_CRMN.order_in_presentation based on the
1647: -- IGS_GR_AWD_CEREMONY.order_in_ceremony, IGS_GR_AWD_CRM_US_GP.order_in_award
1648: -- and the parameters passed.
1649:
1650: --Block for Parameter Validation/Splitting of Parameters

Line 1678: person_id IGS_GR_AWD_CRMN.person_id%TYPE,

1674: v_gac_upd_c_handle INTEGER;
1675: v_gac_upd_c_exe_result INTEGER;
1676: -- Record declaration for Dynamic SQL
1677: TYPE gac_upd_rectype IS RECORD (
1678: person_id IGS_GR_AWD_CRMN.person_id%TYPE,
1679: create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
1680: award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE,
1681: award_crs_version_number
1682: IGS_GR_AWD_CRMN.award_crs_version_number%TYPE,

Line 1679: create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,

1675: v_gac_upd_c_exe_result INTEGER;
1676: -- Record declaration for Dynamic SQL
1677: TYPE gac_upd_rectype IS RECORD (
1678: person_id IGS_GR_AWD_CRMN.person_id%TYPE,
1679: create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
1680: award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE,
1681: award_crs_version_number
1682: IGS_GR_AWD_CRMN.award_crs_version_number%TYPE,
1683: award_cd IGS_GR_AWD_CRMN.award_cd%TYPE,

Line 1680: award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE,

1676: -- Record declaration for Dynamic SQL
1677: TYPE gac_upd_rectype IS RECORD (
1678: person_id IGS_GR_AWD_CRMN.person_id%TYPE,
1679: create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
1680: award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE,
1681: award_crs_version_number
1682: IGS_GR_AWD_CRMN.award_crs_version_number%TYPE,
1683: award_cd IGS_GR_AWD_CRMN.award_cd%TYPE,
1684: grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,

Line 1682: IGS_GR_AWD_CRMN.award_crs_version_number%TYPE,

1678: person_id IGS_GR_AWD_CRMN.person_id%TYPE,
1679: create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
1680: award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE,
1681: award_crs_version_number
1682: IGS_GR_AWD_CRMN.award_crs_version_number%TYPE,
1683: award_cd IGS_GR_AWD_CRMN.award_cd%TYPE,
1684: grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
1685: grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
1686: ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE);

Line 1683: award_cd IGS_GR_AWD_CRMN.award_cd%TYPE,

1679: create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
1680: award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE,
1681: award_crs_version_number
1682: IGS_GR_AWD_CRMN.award_crs_version_number%TYPE,
1683: award_cd IGS_GR_AWD_CRMN.award_cd%TYPE,
1684: grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
1685: grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
1686: ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE);
1687: v_gac_upd_rec gac_upd_rectype;

Line 1684: grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,

1680: award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE,
1681: award_crs_version_number
1682: IGS_GR_AWD_CRMN.award_crs_version_number%TYPE,
1683: award_cd IGS_GR_AWD_CRMN.award_cd%TYPE,
1684: grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
1685: grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
1686: ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE);
1687: v_gac_upd_rec gac_upd_rectype;
1688: CURSOR c_gc IS

Line 1685: grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,

1681: award_crs_version_number
1682: IGS_GR_AWD_CRMN.award_crs_version_number%TYPE,
1683: award_cd IGS_GR_AWD_CRMN.award_cd%TYPE,
1684: grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
1685: grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
1686: ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE);
1687: v_gac_upd_rec gac_upd_rectype;
1688: CURSOR c_gc IS
1689: SELECT gc.ceremony_number

Line 1686: ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE);

1682: IGS_GR_AWD_CRMN.award_crs_version_number%TYPE,
1683: award_cd IGS_GR_AWD_CRMN.award_cd%TYPE,
1684: grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
1685: grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
1686: ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE);
1687: v_gac_upd_rec gac_upd_rectype;
1688: CURSOR c_gc IS
1689: SELECT gc.ceremony_number
1690: FROM IGS_GR_CRMN gc

Line 1704: FROM IGS_GR_AWD_CRMN gac

1700: awc.grd_ci_sequence_number = p_grd_ci_sequence_number AND
1701: awc.ceremony_number = cp_ceremony_number AND
1702: awc.closed_ind = 'Y' AND
1703: EXISTS (SELECT 'X'
1704: FROM IGS_GR_AWD_CRMN gac
1705: WHERE gac.grd_cal_type = awc.grd_cal_type AND
1706: gac.grd_ci_sequence_number = awc.grd_ci_sequence_number AND
1707: gac.ceremony_number = awc.ceremony_number AND
1708: ((gac.award_course_cd IS NULL AND

Line 1728: FROM IGS_GR_AWD_CRMN gac

1724: acusg.ceremony_number = cp_ceremony_number AND
1725: acusg.closed_ind = 'Y' AND
1726: EXISTS
1727: (SELECT 'X'
1728: FROM IGS_GR_AWD_CRMN gac
1729: WHERE gac.grd_cal_type = acusg.grd_cal_type AND
1730: gac.grd_ci_sequence_number = acusg.grd_ci_sequence_number AND
1731: gac.ceremony_number = acusg.ceremony_number AND
1732: gac.award_course_cd = acusg.award_course_cd AND

Line 1740: FROM IGS_GR_AWD_CRMN gac

1736: v_acusg_exists VARCHAR2(1);
1737: CURSOR c_gac_del(
1738: cp_ceremony_number IGS_GR_CRMN.ceremony_number%TYPE) IS
1739: SELECT rowid, gac.*
1740: FROM IGS_GR_AWD_CRMN gac
1741: WHERE gac.grd_cal_type = p_grd_cal_type AND
1742: gac.grd_ci_sequence_number = p_grd_ci_sequence_number AND
1743: gac.ceremony_number = cp_ceremony_number
1744: FOR UPDATE OF gac.order_in_presentation NOWAIT;

Line 1747: cp_person_id IGS_GR_AWD_CRMN.person_id%TYPE,

1743: gac.ceremony_number = cp_ceremony_number
1744: FOR UPDATE OF gac.order_in_presentation NOWAIT;
1745: CURSOR c_existing_order(
1746: cp_ceremony_number IGS_GR_CRMN.ceremony_number%TYPE,
1747: cp_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
1748: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
1749: cp_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE,
1750: cp_award_crs_version_number
1751: IGS_GR_AWD_CRMN.award_crs_version_number%TYPE,

Line 1748: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,

1744: FOR UPDATE OF gac.order_in_presentation NOWAIT;
1745: CURSOR c_existing_order(
1746: cp_ceremony_number IGS_GR_CRMN.ceremony_number%TYPE,
1747: cp_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
1748: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
1749: cp_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE,
1750: cp_award_crs_version_number
1751: IGS_GR_AWD_CRMN.award_crs_version_number%TYPE,
1752: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS

Line 1749: cp_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE,

1745: CURSOR c_existing_order(
1746: cp_ceremony_number IGS_GR_CRMN.ceremony_number%TYPE,
1747: cp_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
1748: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
1749: cp_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE,
1750: cp_award_crs_version_number
1751: IGS_GR_AWD_CRMN.award_crs_version_number%TYPE,
1752: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
1753: SELECT gac.order_in_presentation

Line 1751: IGS_GR_AWD_CRMN.award_crs_version_number%TYPE,

1747: cp_person_id IGS_GR_AWD_CRMN.person_id%TYPE,
1748: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
1749: cp_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE,
1750: cp_award_crs_version_number
1751: IGS_GR_AWD_CRMN.award_crs_version_number%TYPE,
1752: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
1753: SELECT gac.order_in_presentation
1754: FROM IGS_GR_AWD_CRMN gac
1755: WHERE gac.person_id = cp_person_id AND

Line 1752: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS

1748: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE,
1749: cp_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE,
1750: cp_award_crs_version_number
1751: IGS_GR_AWD_CRMN.award_crs_version_number%TYPE,
1752: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
1753: SELECT gac.order_in_presentation
1754: FROM IGS_GR_AWD_CRMN gac
1755: WHERE gac.person_id = cp_person_id AND
1756: gac.grd_cal_type = p_grd_cal_type AND

Line 1754: FROM IGS_GR_AWD_CRMN gac

1750: cp_award_crs_version_number
1751: IGS_GR_AWD_CRMN.award_crs_version_number%TYPE,
1752: cp_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE) IS
1753: SELECT gac.order_in_presentation
1754: FROM IGS_GR_AWD_CRMN gac
1755: WHERE gac.person_id = cp_person_id AND
1756: gac.grd_cal_type = p_grd_cal_type AND
1757: gac.grd_ci_sequence_number = p_grd_ci_sequence_number AND
1758: gac.ceremony_number = cp_ceremony_number AND

Line 1774: FROM igs_gr_awd_crmn

1770: -- pradhakr; 14-Sep-2002;
1771:
1772: CURSOR c_max_ord_num IS
1773: SELECT max(order_in_presentation)
1774: FROM igs_gr_awd_crmn
1775: WHERE grd_cal_type = p_grd_cal_type
1776: AND grd_ci_sequence_number = p_grd_ci_sequence_number
1777: AND ceremony_number = p_ceremony_number;
1778:

Line 1779: v_existing_order IGS_GR_AWD_CRMN.order_in_presentation%TYPE;

1775: WHERE grd_cal_type = p_grd_cal_type
1776: AND grd_ci_sequence_number = p_grd_ci_sequence_number
1777: AND ceremony_number = p_ceremony_number;
1778:
1779: v_existing_order IGS_GR_AWD_CRMN.order_in_presentation%TYPE;
1780: BEGIN
1781: --
1782: --Log the Parameters value in the log file. This is to fix Bug# 2690151
1783: --

Line 1809: --3. Check if the IGS_GR_CRMN has any related IGS_GR_AWD_CRMN

1805: END IF;
1806: --2. Loop through all of the IGS_GR_CRMN records
1807: -- which match the specifed parameters.
1808: FOR v_gc_rec IN c_gc LOOP
1809: --3. Check if the IGS_GR_CRMN has any related IGS_GR_AWD_CRMN
1810: -- records linked to closed IGS_GR_AWD_CEREMONY records.
1811: OPEN c_awc(v_gc_rec.ceremony_number);
1812: FETCH c_awc INTO v_awc_exists;
1813: IF c_awc%FOUND THEN

Line 1836: --7. Clear the order_in_presentation for all of the IGS_GR_AWD_CRMN

1832: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get); --Added as per bug# 2691809
1833: RETURN;
1834: END IF;
1835: CLOSE c_acusg;
1836: --7. Clear the order_in_presentation for all of the IGS_GR_AWD_CRMN
1837: -- records related to this IGS_GR_CRMN.
1838:
1839: -- If the concurrent process is executed in 'Reallocate' mode then update
1840: -- all the order in presentation column to NULL. This will allows to

Line 1853: IGS_GR_AWD_CRMN_PKG.UPDATE_ROW(

1849:
1850: FOR v_gac_del_rec IN c_gac_del(
1851: v_gc_rec.ceremony_number) LOOP
1852:
1853: IGS_GR_AWD_CRMN_PKG.UPDATE_ROW(
1854: X_ROWID =>v_gac_del_rec.rowid,
1855: X_GAC_ID =>v_gac_del_rec.GAC_ID,
1856: X_GRADUAND_SEAT_NUMBER =>v_gac_del_rec.graduand_seat_number,
1857: X_NAME_PRONUNCIATION =>v_gac_del_rec.name_pronunciation,

Line 1917: 'FROM IGS_GR_AWD_CRMN gac, ' ||

1913: 'gac.award_cd, ' ||
1914: 'gac.grd_cal_type, ' ||
1915: 'gac.grd_ci_sequence_number, '||
1916: 'gac.ceremony_number ' ||
1917: 'FROM IGS_GR_AWD_CRMN gac, ' ||
1918: 'IGS_GR_GRADUAND gr, ' ||
1919: 'IGS_GR_STAT gst, ' ||
1920: 'IGS_PE_PERSON pe, ' ||
1921: 'IGS_GR_AWD_CEREMONY awc, ' ||

Line 2013: --8. Find all of the IGS_GR_AWD_CRMN records for

2009: ELSE
2010: v_order_count := 1;
2011: END IF;
2012:
2013: --8. Find all of the IGS_GR_AWD_CRMN records for
2014: -- this IGS_GR_CRMN.
2015: --9. Loop through the IGS_GR_AWD_CRMN records setting the
2016: -- order_in_presentation.
2017: LOOP -- Dynamic Cursor associated with handle 'v_gac_upd_c_handle'

Line 2015: --9. Loop through the IGS_GR_AWD_CRMN records setting the

2011: END IF;
2012:
2013: --8. Find all of the IGS_GR_AWD_CRMN records for
2014: -- this IGS_GR_CRMN.
2015: --9. Loop through the IGS_GR_AWD_CRMN records setting the
2016: -- order_in_presentation.
2017: LOOP -- Dynamic Cursor associated with handle 'v_gac_upd_c_handle'
2018: Exit WHEN DBMS_SQL.FETCH_ROWS(v_gac_upd_c_handle) = 0;
2019: -- Retrieve the data associated with the Dynamic SQL cursor

Line 2048: FROM IGS_GR_AWD_CRMN gac

2044: CLOSE c_existing_order;
2045: DECLARE
2046: CURSOR cur_gac IS
2047: SELECT rowid, gac.*
2048: FROM IGS_GR_AWD_CRMN gac
2049: WHERE person_id = v_gac_upd_rec.person_id AND
2050: create_dt = v_gac_upd_rec.create_dt AND
2051: NVL(award_course_cd, 'NULL' )
2052: = NVL(v_gac_upd_rec.award_course_cd, 'NULL') AND

Line 2063: IGS_GR_AWD_CRMN_PKG.UPDATE_ROW(

2059: BEGIN
2060: for gac_rec in cur_gac loop
2061: BEGIN
2062: gac_rec.order_in_presentation := v_existing_order;
2063: IGS_GR_AWD_CRMN_PKG.UPDATE_ROW(
2064: X_ROWID =>gac_rec.rowid,
2065: X_GAC_ID =>gac_rec.GAC_ID,
2066: X_GRADUAND_SEAT_NUMBER =>gac_rec.graduand_seat_number,
2067: X_NAME_PRONUNCIATION =>gac_rec.name_pronunciation,

Line 2107: FROM IGS_GR_AWD_CRMN gac

2103: CLOSE c_existing_order;
2104: DECLARE
2105: CURSOR cur_gac IS
2106: SELECT rowid, gac.*
2107: FROM IGS_GR_AWD_CRMN gac
2108: WHERE person_id = v_gac_upd_rec.person_id AND
2109: create_dt = v_gac_upd_rec.create_dt AND
2110: NVL(award_course_cd, 'NULL' )
2111: = NVL(v_gac_upd_rec.award_course_cd, 'NULL') AND

Line 2122: IGS_GR_AWD_CRMN_PKG.UPDATE_ROW(

2118: BEGIN
2119: for gac_rec in cur_gac loop
2120: BEGIN
2121: gac_rec.order_in_presentation := v_order_count;
2122: IGS_GR_AWD_CRMN_PKG.UPDATE_ROW(
2123: X_ROWID =>gac_rec.rowid,
2124: X_GAC_ID =>gac_rec.GAC_ID,
2125: X_GRADUAND_SEAT_NUMBER =>gac_rec.graduand_seat_number,
2126: X_NAME_PRONUNCIATION =>gac_rec.name_pronunciation,

Line 2168: FROM IGS_GR_AWD_CRMN gac

2164: ELSE
2165: DECLARE
2166: CURSOR cur_gac IS
2167: SELECT rowid, gac.*
2168: FROM IGS_GR_AWD_CRMN gac
2169: WHERE person_id = v_gac_upd_rec.person_id AND
2170: create_dt = v_gac_upd_rec.create_dt AND
2171: NVL(award_course_cd, 'NULL' )
2172: = NVL(v_gac_upd_rec.award_course_cd, 'NULL') AND

Line 2183: IGS_GR_AWD_CRMN_PKG.UPDATE_ROW(

2179:
2180: BEGIN
2181: for gac_rec in cur_gac loop
2182: gac_rec.order_in_presentation := v_order_count;
2183: IGS_GR_AWD_CRMN_PKG.UPDATE_ROW(
2184: X_ROWID =>gac_rec.rowid,
2185: X_GAC_ID =>gac_rec.GAC_ID,
2186: X_GRADUAND_SEAT_NUMBER =>gac_rec.graduand_seat_number,
2187: X_NAME_PRONUNCIATION =>gac_rec.name_pronunciation,