DBA Data[Home] [Help]

APPS.IGS_GR_VAL_ACUS dependencies on IGS_GR_AWD_CRM_US_GP

Line 6: p_grd_cal_type IGS_GR_AWD_CRM_US_GP.grd_cal_type%TYPE ,

2: /* $Header: IGSGR03S.pls 115.4 2002/11/29 00:39:57 nsidana ship $ */
3: --
4: -- Validate if the award ceremony unit set group is closed
5: FUNCTION grdp_val_acusg_close(
6: p_grd_cal_type IGS_GR_AWD_CRM_US_GP.grd_cal_type%TYPE ,
7: p_grd_ci_sequence_number IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE ,
8: p_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE ,
9: p_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE ,
10: p_award_crs_version_number IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE ,

Line 7: p_grd_ci_sequence_number IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE ,

3: --
4: -- Validate if the award ceremony unit set group is closed
5: FUNCTION grdp_val_acusg_close(
6: p_grd_cal_type IGS_GR_AWD_CRM_US_GP.grd_cal_type%TYPE ,
7: p_grd_ci_sequence_number IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE ,
8: p_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE ,
9: p_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE ,
10: p_award_crs_version_number IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE ,
11: p_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE ,

Line 8: p_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE ,

4: -- Validate if the award ceremony unit set group is closed
5: FUNCTION grdp_val_acusg_close(
6: p_grd_cal_type IGS_GR_AWD_CRM_US_GP.grd_cal_type%TYPE ,
7: p_grd_ci_sequence_number IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE ,
8: p_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE ,
9: p_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE ,
10: p_award_crs_version_number IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE ,
11: p_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE ,
12: p_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE ,

Line 9: p_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE ,

5: FUNCTION grdp_val_acusg_close(
6: p_grd_cal_type IGS_GR_AWD_CRM_US_GP.grd_cal_type%TYPE ,
7: p_grd_ci_sequence_number IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE ,
8: p_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE ,
9: p_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE ,
10: p_award_crs_version_number IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE ,
11: p_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE ,
12: p_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE ,
13: p_message_name OUT NOCOPY VARCHAR2 )

Line 10: p_award_crs_version_number IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE ,

6: p_grd_cal_type IGS_GR_AWD_CRM_US_GP.grd_cal_type%TYPE ,
7: p_grd_ci_sequence_number IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE ,
8: p_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE ,
9: p_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE ,
10: p_award_crs_version_number IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE ,
11: p_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE ,
12: p_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE ,
13: p_message_name OUT NOCOPY VARCHAR2 )
14: RETURN BOOLEAN;

Line 11: p_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE ,

7: p_grd_ci_sequence_number IGS_GR_AWD_CRM_US_GP.grd_ci_sequence_number%TYPE ,
8: p_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE ,
9: p_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE ,
10: p_award_crs_version_number IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE ,
11: p_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE ,
12: p_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE ,
13: p_message_name OUT NOCOPY VARCHAR2 )
14: RETURN BOOLEAN;
15: --

Line 12: p_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE ,

8: p_ceremony_number IGS_GR_AWD_CRM_US_GP.ceremony_number%TYPE ,
9: p_award_course_cd IGS_GR_AWD_CRM_US_GP.award_course_cd%TYPE ,
10: p_award_crs_version_number IGS_GR_AWD_CRM_US_GP.award_crs_version_number%TYPE ,
11: p_award_cd IGS_GR_AWD_CRM_US_GP.award_cd%TYPE ,
12: p_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE ,
13: p_message_name OUT NOCOPY VARCHAR2 )
14: RETURN BOOLEAN;
15: --
16: -- Validate the award ceremony unit set has related unit set attempts