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_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: IGSGR03B.pls 115.4 2002/11/29 00:39:50 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 AS

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 AS
15: BEGIN -- grdp_val_acusg_close

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 AS
15: BEGIN -- grdp_val_acusg_close
16: -- Description: Validate if the award ceremony unit set group is closed

Line 18: v_acusg_rec IGS_GR_AWD_CRM_US_GP.closed_ind%TYPE;

14: RETURN BOOLEAN AS
15: BEGIN -- grdp_val_acusg_close
16: -- Description: Validate if the award ceremony unit set group is closed
17: DECLARE
18: v_acusg_rec IGS_GR_AWD_CRM_US_GP.closed_ind%TYPE;
19: CURSOR c_acusg IS
20: SELECT acusg.closed_ind
21: FROM IGS_GR_AWD_CRM_US_GP acusg
22: WHERE acusg.grd_cal_type = p_grd_cal_type and

Line 21: FROM IGS_GR_AWD_CRM_US_GP acusg

17: DECLARE
18: v_acusg_rec IGS_GR_AWD_CRM_US_GP.closed_ind%TYPE;
19: CURSOR c_acusg IS
20: SELECT acusg.closed_ind
21: FROM IGS_GR_AWD_CRM_US_GP acusg
22: WHERE acusg.grd_cal_type = p_grd_cal_type and
23: acusg.grd_ci_sequence_number = p_grd_ci_sequence_number and
24: acusg.ceremony_number = p_ceremony_number and
25: acusg.award_course_cd = p_award_course_cd and