APPS.IGS_AS_GEN_002 dependencies on IGS_AD_LOCATION

Line 46: -- This routine returns the default examination IGS_AD_LOCATION

42: FUNCTION assp_get_dflt_exloc (p_location_cd IN VARCHAR2)
43: RETURN VARCHAR2 IS
44: gv_other_detail VARCHAR2 (255);
45: BEGIN -- assp_get_dflt_exloc
46: -- This routine returns the default examination IGS_AD_LOCATION
47: -- for a nominated campus.
48: -- The default IGS_AD_LOCATION is signified by the dflt_ind being set in the
49: -- IGS_AD_LOCATION_REL table between the specified campus and an exam
50: -- IGS_AD_LOCATION.

Line 48: -- The default IGS_AD_LOCATION is signified by the dflt_ind being set in the

44: gv_other_detail VARCHAR2 (255);
45: BEGIN -- assp_get_dflt_exloc
46: -- This routine returns the default examination IGS_AD_LOCATION
47: -- for a nominated campus.
48: -- The default IGS_AD_LOCATION is signified by the dflt_ind being set in the
49: -- IGS_AD_LOCATION_REL table between the specified campus and an exam
50: -- IGS_AD_LOCATION.
51: DECLARE
52: CURSOR c_lr IS

Line 49: -- IGS_AD_LOCATION_REL table between the specified campus and an exam

45: BEGIN -- assp_get_dflt_exloc
46: -- This routine returns the default examination IGS_AD_LOCATION
47: -- for a nominated campus.
48: -- The default IGS_AD_LOCATION is signified by the dflt_ind being set in the
49: -- IGS_AD_LOCATION_REL table between the specified campus and an exam
50: -- IGS_AD_LOCATION.
51: DECLARE
52: CURSOR c_lr IS
53: SELECT lr.sub_location_cd

Line 50: -- IGS_AD_LOCATION.

46: -- This routine returns the default examination IGS_AD_LOCATION
47: -- for a nominated campus.
48: -- The default IGS_AD_LOCATION is signified by the dflt_ind being set in the
49: -- IGS_AD_LOCATION_REL table between the specified campus and an exam
50: -- IGS_AD_LOCATION.
51: DECLARE
52: CURSOR c_lr IS
53: SELECT lr.sub_location_cd
54: FROM igs_ad_location_rel lr,

Line 54: FROM igs_ad_location_rel lr,

50: -- IGS_AD_LOCATION.
51: DECLARE
52: CURSOR c_lr IS
53: SELECT lr.sub_location_cd
54: FROM igs_ad_location_rel lr,
55: igs_ad_location loc,
56: igs_ad_location_type lt
57: WHERE lr.location_cd = p_location_cd
58: AND NVL (lr.dflt_ind, 'N') = 'Y'

Line 55: igs_ad_location loc,

51: DECLARE
52: CURSOR c_lr IS
53: SELECT lr.sub_location_cd
54: FROM igs_ad_location_rel lr,
55: igs_ad_location loc,
56: igs_ad_location_type lt
57: WHERE lr.location_cd = p_location_cd
58: AND NVL (lr.dflt_ind, 'N') = 'Y'
59: AND NVL (loc.closed_ind, 'N') = 'N'

Line 56: igs_ad_location_type lt

52: CURSOR c_lr IS
53: SELECT lr.sub_location_cd
54: FROM igs_ad_location_rel lr,
55: igs_ad_location loc,
56: igs_ad_location_type lt
57: WHERE lr.location_cd = p_location_cd
58: AND NVL (lr.dflt_ind, 'N') = 'Y'
59: AND NVL (loc.closed_ind, 'N') = 'N'
60: AND lt.s_location_type = 'EXAM_CTR'

Line 63: v_sub_location_cd igs_ad_location_rel.location_cd%TYPE DEFAULT NULL;

59: AND NVL (loc.closed_ind, 'N') = 'N'
60: AND lt.s_location_type = 'EXAM_CTR'
61: AND loc.location_cd = lr.location_cd
62: AND loc.location_type = lt.location_type;
63: v_sub_location_cd igs_ad_location_rel.location_cd%TYPE DEFAULT NULL;
64: BEGIN
65: -- Search for the default exam IGS_AD_LOCATION
66: OPEN c_lr;
67: FETCH c_lr INTO v_sub_location_cd;

Line 65: -- Search for the default exam IGS_AD_LOCATION

61: AND loc.location_cd = lr.location_cd
62: AND loc.location_type = lt.location_type;
63: v_sub_location_cd igs_ad_location_rel.location_cd%TYPE DEFAULT NULL;
64: BEGIN
65: -- Search for the default exam IGS_AD_LOCATION
66: OPEN c_lr;
67: FETCH c_lr INTO v_sub_location_cd;
68: IF c_lr%NOTFOUND THEN
69: CLOSE c_lr;