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.

[Home] [Help]

APPS.IGS_GR_VAL_GR dependencies on IGS_GR_AWD_CRMN

Line 172: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,

168: END grdp_val_gr_sca;
169: --
170: -- Validate Graduand Ceremony Round calendar instance.
171: FUNCTION grdp_val_gr_crd_ci(
172: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
173: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
174: p_message_name OUT NOCOPY VARCHAR2 )
175: RETURN BOOLEAN AS
176: BEGIN -- grdp_val_gr_crd_ci

Line 173: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,

169: --
170: -- Validate Graduand Ceremony Round calendar instance.
171: FUNCTION grdp_val_gr_crd_ci(
172: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
173: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
174: p_message_name OUT NOCOPY VARCHAR2 )
175: RETURN BOOLEAN AS
176: BEGIN -- grdp_val_gr_crd_ci
177: -- Validate that the graduand is linked

Line 380: FROM IGS_GR_AWD_CRMN gac

376: SELECT gac.grd_cal_type,
377: gac.grd_ci_sequence_number,
378: gac.ceremony_number,
379: gac.us_group_number
380: FROM IGS_GR_AWD_CRMN gac
381: WHERE gac.person_id = p_person_id AND
382: gac.create_dt = p_create_dt AND
383: gac.award_course_cd = p_award_course_cd AND
384: gac.award_crs_version_number

Line 668: FROM IGS_GR_AWD_CRMN gac

664: FROM IGS_GR_STAT gst
665: WHERE gst.graduand_status = p_graduand_status;
666: CURSOR c_gac IS
667: SELECT 'x'
668: FROM IGS_GR_AWD_CRMN gac
669: WHERE gac.person_id = p_person_id AND
670: gac.create_dt = p_create_dt;
671: CURSOR c_gac2 IS
672: SELECT gac.grd_cal_type,

Line 679: FROM IGS_GR_AWD_CRMN gac

675: gac.award_course_cd,
676: gac.award_crs_version_number,
677: gac.award_cd,
678: gac.us_group_number
679: FROM IGS_GR_AWD_CRMN gac
680: WHERE gac.person_id = p_person_id AND
681: gac.create_dt = p_create_dt;
682: v_gac_exists VARCHAR2(1);
683: BEGIN

Line 973: FROM IGS_GR_AWD_CRMN gac

969: CURSOR c_gac IS
970: SELECT gac.grd_cal_type,
971: gac.grd_ci_sequence_number,
972: gac.ceremony_number
973: FROM IGS_GR_AWD_CRMN gac
974: WHERE gac.person_id = p_person_id AND
975: gac.create_dt = p_create_dt AND
976: gac.award_cd = p_award_cd AND
977: NVL(gac.award_course_cd, 'NULL') = NVL(p_award_course_cd,'NULL') AND

Line 981: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,

977: NVL(gac.award_course_cd, 'NULL') = NVL(p_award_course_cd,'NULL') AND
978: NVL(gac.award_crs_version_number,0) = NVL(p_award_crs_version_number,0);
979: v_gac_rec c_gac%ROWTYPE;
980: CURSOR c_gc(
981: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
982: cp_grd_ci_sequence_number
983: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
984: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE) IS
985: SELECT gc.ceremony_dt_alias,

Line 983: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,

979: v_gac_rec c_gac%ROWTYPE;
980: CURSOR c_gc(
981: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
982: cp_grd_ci_sequence_number
983: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
984: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE) IS
985: SELECT gc.ceremony_dt_alias,
986: gc.ceremony_dai_sequence_number,
987: gc.closing_dt_alias,

Line 984: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE) IS

980: CURSOR c_gc(
981: cp_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE,
982: cp_grd_ci_sequence_number
983: IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE,
984: cp_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE) IS
985: SELECT gc.ceremony_dt_alias,
986: gc.ceremony_dai_sequence_number,
987: gc.closing_dt_alias,
988: gc.closing_dai_sequence_number

Line 1053: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,

1049: END grdp_val_gr_upd;
1050: --
1051: -- Validate inserting or updating a graduand.
1052: FUNCTION grdp_val_gr_iu(
1053: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
1054: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
1055: p_message_name OUT NOCOPY VARCHAR2 )
1056: RETURN BOOLEAN AS
1057: BEGIN -- grdp_val_gac_iu

Line 1054: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,

1050: --
1051: -- Validate inserting or updating a graduand.
1052: FUNCTION grdp_val_gr_iu(
1053: p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
1054: p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
1055: p_message_name OUT NOCOPY VARCHAR2 )
1056: RETURN BOOLEAN AS
1057: BEGIN -- grdp_val_gac_iu
1058: -- Validate that the insert or update of a graduand record