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_AD_VAL_ASE dependencies on IGS_AD_AUS_SEC_EDU

Line 12: -- Validate that if the IGS_AD_AUS_SEC_EDU.result_obtained_yr is

8: p_message_name OUT NOCOPY VARCHAR2 )
9: RETURN BOOLEAN IS
10: gv_other_detail VARCHAR2(255);
11: BEGIN -- admp_val_ase_scoreat
12: -- Validate that if the IGS_AD_AUS_SEC_EDU.result_obtained_yr is
13: -- not null then the IGS_AD_AUS_SEC_EDU.score and
14: -- IGS_AD_AUS_SEC_EDU.aus_scndry_edu_ass_type are also not null.
15: DECLARE
16: BEGIN

Line 13: -- not null then the IGS_AD_AUS_SEC_EDU.score and

9: RETURN BOOLEAN IS
10: gv_other_detail VARCHAR2(255);
11: BEGIN -- admp_val_ase_scoreat
12: -- Validate that if the IGS_AD_AUS_SEC_EDU.result_obtained_yr is
13: -- not null then the IGS_AD_AUS_SEC_EDU.score and
14: -- IGS_AD_AUS_SEC_EDU.aus_scndry_edu_ass_type are also not null.
15: DECLARE
16: BEGIN
17: p_message_name := Null;

Line 14: -- IGS_AD_AUS_SEC_EDU.aus_scndry_edu_ass_type are also not null.

10: gv_other_detail VARCHAR2(255);
11: BEGIN -- admp_val_ase_scoreat
12: -- Validate that if the IGS_AD_AUS_SEC_EDU.result_obtained_yr is
13: -- not null then the IGS_AD_AUS_SEC_EDU.score and
14: -- IGS_AD_AUS_SEC_EDU.aus_scndry_edu_ass_type are also not null.
15: DECLARE
16: BEGIN
17: p_message_name := Null;
18: IF p_result_obtained_yr IS NOT NULL THEN

Line 43: -- Validate that the IGS_AD_AUS_SEC_EDU.state_cd is the same as the

39: p_message_name OUT NOCOPY VARCHAR2 )
40: RETURN BOOLEAN IS
41: gv_other_detail VARCHAR2(255);
42: BEGIN -- admp_val_ase_atstate
43: -- Validate that the IGS_AD_AUS_SEC_EDU.state_cd is the same as the
44: -- IGS_AD_AUSE_ED_AS_TY.state_cd or that the
45: -- IGS_AD_AUSE_ED_AS_TY.state_cd is null.
46: DECLARE
47: v_state_cd IGS_AD_AUS_SEC_EDU.state_cd%TYPE DEFAULT NULL;

Line 47: v_state_cd IGS_AD_AUS_SEC_EDU.state_cd%TYPE DEFAULT NULL;

43: -- Validate that the IGS_AD_AUS_SEC_EDU.state_cd is the same as the
44: -- IGS_AD_AUSE_ED_AS_TY.state_cd or that the
45: -- IGS_AD_AUSE_ED_AS_TY.state_cd is null.
46: DECLARE
47: v_state_cd IGS_AD_AUS_SEC_EDU.state_cd%TYPE DEFAULT NULL;
48: CURSOR c_aseat IS
49: SELECT state_cd
50: FROM IGS_AD_AUSE_ED_AS_TY
51: WHERE aus_scndry_edu_ass_type = p_aus_scndry_edu_ass_type;

Line 81: -- Validate that the IGS_AD_AUS_SEC_EDU.state_cd is the same as the

77: p_message_name OUT NOCOPY VARCHAR2 )
78: RETURN BOOLEAN IS
79: gv_other_detail VARCHAR2(255);
80: BEGIN -- admp_val_ase_scstate
81: -- Validate that the IGS_AD_AUS_SEC_EDU.state_cd is the same as the
82: -- IGS_AD_AUS_SEC_ED_SC.state_cd.
83: DECLARE
84: v_state_cd IGS_AD_AUS_SEC_EDU.state_cd%TYPE DEFAULT NULL;
85: CURSOR c_ases IS

Line 84: v_state_cd IGS_AD_AUS_SEC_EDU.state_cd%TYPE DEFAULT NULL;

80: BEGIN -- admp_val_ase_scstate
81: -- Validate that the IGS_AD_AUS_SEC_EDU.state_cd is the same as the
82: -- IGS_AD_AUS_SEC_ED_SC.state_cd.
83: DECLARE
84: v_state_cd IGS_AD_AUS_SEC_EDU.state_cd%TYPE DEFAULT NULL;
85: CURSOR c_ases IS
86: SELECT state_cd
87: FROM IGS_AD_AUS_SEC_ED_SC
88: WHERE secondary_school_cd = p_secondary_school_cd;