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_VAL_GAC dependencies on IGS_GR_AWD_CRM_US_GP

Line 533: p_grd_cal_type IGS_GR_AWD_CRM_US_GP.grd_cal_type%TYPE ,

529: END grdp_val_gac_order;
530:
531: -- Validate if the award ceremony unit set group is closed
532: FUNCTION grdp_val_acusg_close(
533: p_grd_cal_type IGS_GR_AWD_CRM_US_GP.grd_cal_type%TYPE ,
534: p_grd_ci_sequence_number IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE ,
535: p_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE ,
536: p_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE ,
537: p_award_crs_version_number IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE ,

Line 534: p_grd_ci_sequence_number IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE ,

530:
531: -- Validate if the award ceremony unit set group is closed
532: FUNCTION grdp_val_acusg_close(
533: p_grd_cal_type IGS_GR_AWD_CRM_US_GP.grd_cal_type%TYPE ,
534: p_grd_ci_sequence_number IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE ,
535: p_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE ,
536: p_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE ,
537: p_award_crs_version_number IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE ,
538: p_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE ,

Line 535: p_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE ,

531: -- Validate if the award ceremony unit set group is closed
532: FUNCTION grdp_val_acusg_close(
533: p_grd_cal_type IGS_GR_AWD_CRM_US_GP.grd_cal_type%TYPE ,
534: p_grd_ci_sequence_number IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE ,
535: p_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE ,
536: p_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE ,
537: p_award_crs_version_number IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE ,
538: p_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE ,
539: p_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE ,

Line 536: p_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE ,

532: FUNCTION grdp_val_acusg_close(
533: p_grd_cal_type IGS_GR_AWD_CRM_US_GP.grd_cal_type%TYPE ,
534: p_grd_ci_sequence_number IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE ,
535: p_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE ,
536: p_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE ,
537: p_award_crs_version_number IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE ,
538: p_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE ,
539: p_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE ,
540: p_message_name OUT NOCOPY VARCHAR2 )

Line 537: p_award_crs_version_number IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE ,

533: p_grd_cal_type IGS_GR_AWD_CRM_US_GP.grd_cal_type%TYPE ,
534: p_grd_ci_sequence_number IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE ,
535: p_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE ,
536: p_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE ,
537: p_award_crs_version_number IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE ,
538: p_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE ,
539: p_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE ,
540: p_message_name OUT NOCOPY VARCHAR2 )
541: RETURN BOOLEAN AS

Line 538: p_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE ,

534: p_grd_ci_sequence_number IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE ,
535: p_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE ,
536: p_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE ,
537: p_award_crs_version_number IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE ,
538: p_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE ,
539: p_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE ,
540: p_message_name OUT NOCOPY VARCHAR2 )
541: RETURN BOOLEAN AS
542: BEGIN -- grdp_val_acusg_close

Line 539: p_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE ,

535: p_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE ,
536: p_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE ,
537: p_award_crs_version_number IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE ,
538: p_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE ,
539: p_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE ,
540: p_message_name OUT NOCOPY VARCHAR2 )
541: RETURN BOOLEAN AS
542: BEGIN -- grdp_val_acusg_close
543: -- Description: Validate if the award ceremony unit set group is closed

Line 545: v_acusg_rec IGS_GR_AWD_CRM_US_GP.closed_ind%TYPE;

541: RETURN BOOLEAN AS
542: BEGIN -- grdp_val_acusg_close
543: -- Description: Validate if the award ceremony unit set group is closed
544: DECLARE
545: v_acusg_rec IGS_GR_AWD_CRM_US_GP.closed_ind%TYPE;
546: CURSOR c_acusg IS
547: SELECT acusg.closed_ind
548: FROM IGS_GR_AWD_CRM_US_GP acusg
549: WHERE acusg.grd_cal_type = p_grd_cal_type and

Line 548: FROM IGS_GR_AWD_CRM_US_GP acusg

544: DECLARE
545: v_acusg_rec IGS_GR_AWD_CRM_US_GP.closed_ind%TYPE;
546: CURSOR c_acusg IS
547: SELECT acusg.closed_ind
548: FROM IGS_GR_AWD_CRM_US_GP acusg
549: WHERE acusg.grd_cal_type = p_grd_cal_type and
550: acusg.grd_ci_sequence_number = p_grd_ci_sequence_number and
551: acusg.ceremony_number = p_ceremony_number and
552: acusg.award_course_cd = p_award_course_cd and