APPS.IGS_GR_GEN_002 dependencies on IGS_GR_AWD_CEREMONY

Line 1017: -- re-alloaction of graduands when IGS_GR_AWD_CEREMONY and

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
1021: -- graduands.

Line 1019: -- The process finds closed IGS_GR_AWD_CEREMONY records for the specified

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
1021: -- graduands.
1022: -- The process finds closed IGS_GR_AWD_CRM_US_GP records for the specified
1023: -- IGS_GR_CRMN_ROUND, calls GENP_PRC_ACUSG_CLOSE to re-allocate any associated

Line 1068: FROM IGS_GR_AWD_CEREMONY awc

1064: SELECT awc.ceremony_number,
1065: awc.award_course_cd,
1066: awc.award_crs_version_number,
1067: awc.award_cd
1068: FROM IGS_GR_AWD_CEREMONY awc
1069: WHERE awc.grd_cal_type = p_grd_cal_type AND
1070: awc.grd_ci_sequence_number = p_grd_ci_sequence_number AND
1071: awc.closed_ind = 'Y';
1072: CURSOR c_acusg IS

Line 1143: -- 2.1 Find any closed IGS_GR_AWD_CEREMONY records for the specified

1139: p_ignore_unit_sets_ind IS NULL THEN
1140: Fnd_Message.Set_Name('IGS', 'IGS_GE_INSUFFICIENT_PARAMETER');
1141: App_Exception.Raise_Exception;
1142: END IF;
1143: -- 2.1 Find any closed IGS_GR_AWD_CEREMONY records for the specified
1144: -- IGS_GR_CRMN_ROUND and loop through them.
1145: FOR v_awc_rec IN c_awc LOOP
1146: -- 2.2 Call GENP_PRC_AWC_CLOSE to process the graduands for the
1147: -- IGS_GR_AWD_CEREMONY record and then delete it.

Line 1147: -- IGS_GR_AWD_CEREMONY record and then delete it.

1143: -- 2.1 Find any closed IGS_GR_AWD_CEREMONY records for the specified
1144: -- IGS_GR_CRMN_ROUND and loop through them.
1145: FOR v_awc_rec IN c_awc LOOP
1146: -- 2.2 Call GENP_PRC_AWC_CLOSE to process the graduands for the
1147: -- IGS_GR_AWD_CEREMONY record and then delete it.
1148: IF IGS_GR_PRC_GAC.grdp_prc_awc_close(
1149: p_grd_cal_type,
1150: p_grd_ci_sequence_number,
1151: v_awc_rec.ceremony_number,

Line 1647: -- IGS_GR_AWD_CEREMONY.order_in_ceremony, IGS_GR_AWD_CRM_US_GP.order_in_award

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
1651: retcode:=0;

Line 1698: FROM IGS_GR_AWD_CEREMONY awc

1694: CURSOR c_awc (
1695: cp_ceremony_number IGS_GR_CRMN.ceremony_number%TYPE) IS
1696: SELECT /*+ INDEX(awc awc_uk*/
1697: 'X'
1698: FROM IGS_GR_AWD_CEREMONY awc
1699: WHERE awc.grd_cal_type = p_grd_cal_type AND
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

Line 1810: -- records linked to closed IGS_GR_AWD_CEREMONY records.

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
1814: --4. If any records are found raise an error.

Line 1921: 'IGS_GR_AWD_CEREMONY awc, ' ||

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, ' ||
1922: 'IGS_GR_AWD_CRM_US_GP acusg, '||
1923: 'IGS_GR_APRV_STAT gas ' ||
1924: 'WHERE gac.grd_cal_type=''' || p_grd_cal_type || ''' AND ' ||
1925: 'gac.grd_ci_sequence_number=' || TO_CHAR(p_grd_ci_sequence_number) || ' AND '||