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_CRMN_ROUND

Line 40: p_grd_cal_type IGS_GR_CRMN_ROUND.grd_cal_type%TYPE ;

36: -- iJeddy The Fourth of July, 2005 Bug 4473024, added a join on award_cd to the Cursor c_crd_sca
37: -- sepalani 19-Apr-2006 Modified Cursor c_gr_upd on procedure GRDP_PRC_GAC for Bug# 5074150
38: -------------------------------------------------------
39:
40: p_grd_cal_type IGS_GR_CRMN_ROUND.grd_cal_type%TYPE ;
41: p_grd_ci_sequence_number IGS_GR_CRMN_ROUND.grd_ci_sequence_number%TYPE;
42: lv_param_values VARCHAR2(1080);
43: l_org_id NUMBER(15);
44: BEGIN

Line 41: p_grd_ci_sequence_number IGS_GR_CRMN_ROUND.grd_ci_sequence_number%TYPE;

37: -- sepalani 19-Apr-2006 Modified Cursor c_gr_upd on procedure GRDP_PRC_GAC for Bug# 5074150
38: -------------------------------------------------------
39:
40: p_grd_cal_type IGS_GR_CRMN_ROUND.grd_cal_type%TYPE ;
41: p_grd_ci_sequence_number IGS_GR_CRMN_ROUND.grd_ci_sequence_number%TYPE;
42: lv_param_values VARCHAR2(1080);
43: l_org_id NUMBER(15);
44: BEGIN
45: -- grdp_ins_graduand

Line 127: igs_gr_crmn_round crd ,

123: spaa.award_cd
124: FROM igs_en_stdnt_ps_att sca ,
125: igs_en_spa_awd_aim spaa,
126: igs_ps_ver crv ,
127: igs_gr_crmn_round crd ,
128: igs_gr_crm_round_prd crdp,
129: igs_ca_da_inst_v dai1,
130: igs_ca_da_inst_v dai2
131: WHERE (p_grd_cal_type IS NULL OR

Line 318: p_grd_cal_type igs_gr_crmn_round.grd_cal_type%TYPE,

314: PROCEDURE grdpl_ins_new_graduand(
315: p_person_id igs_en_stdnt_ps_att.person_id%TYPE,
316: p_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
317: p_version_number igs_en_stdnt_ps_att.version_number%TYPE,
318: p_grd_cal_type igs_gr_crmn_round.grd_cal_type%TYPE,
319: p_grd_ci_sequence_number igs_gr_crmn_round.grd_ci_sequence_number%TYPE,
320: p_award_cd igs_en_spa_awd_aim.award_cd%TYPE,
321: p_message_name IN OUT NOCOPY VARCHAR2) AS
322: --

Line 319: p_grd_ci_sequence_number igs_gr_crmn_round.grd_ci_sequence_number%TYPE,

315: p_person_id igs_en_stdnt_ps_att.person_id%TYPE,
316: p_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
317: p_version_number igs_en_stdnt_ps_att.version_number%TYPE,
318: p_grd_cal_type igs_gr_crmn_round.grd_cal_type%TYPE,
319: p_grd_ci_sequence_number igs_gr_crmn_round.grd_ci_sequence_number%TYPE,
320: p_award_cd igs_en_spa_awd_aim.award_cd%TYPE,
321: p_message_name IN OUT NOCOPY VARCHAR2) AS
322: --
323: -- Change History :

Line 1020: -- IGS_GR_CRMN_ROUND, calls GENP_PRC_AWC_CLOSE to re-allocate any associated

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

Line 1023: -- IGS_GR_CRMN_ROUND, calls GENP_PRC_ACUSG_CLOSE to re-allocate any associated

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

Line 1025: -- The process finds any IGS_GR_GRADUAND records for the specified IGS_GR_CRMN_ROUND,

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
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.

Line 1144: -- IGS_GR_CRMN_ROUND and loop through them.

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.
1148: IF IGS_GR_PRC_GAC.grdp_prc_awc_close(

Line 1163: -- IGS_GR_CRMN_ROUND and loop through them.

1159: App_Exception.Raise_Exception;
1160: END IF;
1161: END LOOP; -- c_awc
1162: -- 3.1 Find closed IGS_GR_AWD_CRM_US_GP records for the specified
1163: -- IGS_GR_CRMN_ROUND and loop through them.
1164: FOR v_acusg_rec IN c_acusg LOOP
1165: -- 3.2 Call GENP_PRC_ACUSG_CLOSE to process the graduands for the
1166: -- IGS_GR_AWD_CRM_US_GP record and then delete it.
1167: IF IGS_GR_PRC_GAC.grdp_prc_acusg_close(

Line 1182: -- 4.1 Find any IGS_GR_GRADUAND records matching the IGS_GR_CRMN_ROUND, location_cd

1178: Fnd_Message.Set_Name('IGS', v_message_name);
1179: App_Exception.Raise_Exception;
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;

Line 1187: -- 4.2 If the IGS_GR_GRADUAND has been deferred into this IGS_GR_CRMN_ROUND update the

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.
1189: IF v_gr_rec.s_graduand_type = cst_deferred THEN
1190: BEGIN
1191: OPEN c_gr_upd(

Line 1281: -- 4.4 If the IGS_GR_GRADUAND has been deferred into this IGS_GR_CRMN_ROUND and they

1277: v_message_name) = FALSE THEN
1278: Fnd_Message.Set_Name('IGS', v_message_name);
1279: App_Exception.Raise_Exception;
1280: END IF;
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.

Line 1637: p_grd_cal_type IGS_GR_CRMN_ROUND.grd_cal_type%type;

1633: --
1634: -- Nalin Kumar 18-DEC-2002 Modified this procedure to fix Bug# 2690151.
1635: -- Added the code to log the parameters value in the log file.
1636: --
1637: p_grd_cal_type IGS_GR_CRMN_ROUND.grd_cal_type%type;
1638: p_grd_ci_sequence_number IGS_GR_CRMN_ROUND.grd_ci_sequence_number%type;
1639: p_ceremony_number IGS_GR_CRMN.ceremony_number%type;
1640: l_index NUMBER;
1641: l_app_name VARCHAR2(30) := 'IGS';

Line 1638: p_grd_ci_sequence_number IGS_GR_CRMN_ROUND.grd_ci_sequence_number%type;

1634: -- Nalin Kumar 18-DEC-2002 Modified this procedure to fix Bug# 2690151.
1635: -- Added the code to log the parameters value in the log file.
1636: --
1637: p_grd_cal_type IGS_GR_CRMN_ROUND.grd_cal_type%type;
1638: p_grd_ci_sequence_number IGS_GR_CRMN_ROUND.grd_ci_sequence_number%type;
1639: p_ceremony_number IGS_GR_CRMN.ceremony_number%type;
1640: l_index NUMBER;
1641: l_app_name VARCHAR2(30) := 'IGS';
1642: l_msg_text varchar2(200);