APPS.IGS_PS_VAL_UV dependencies on IGS_LOOKUPS_VIEW

Line 69: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%TYPE;

65: FUNCTION crsp_val_uv_cp_desc(
66: P_CREDIT_POINT_DESCRIPTOR IN VARCHAR2,
67: P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
68: RETURN BOOLEAN AS
69: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%TYPE;
70: CURSOR c_cp_desc_closed_ind IS
71: SELECT closed_ind
72: FROM IGS_LOOKUPS_VIEW
73: WHERE lookup_code = p_credit_point_descriptor AND

Line 72: FROM IGS_LOOKUPS_VIEW

68: RETURN BOOLEAN AS
69: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%TYPE;
70: CURSOR c_cp_desc_closed_ind IS
71: SELECT closed_ind
72: FROM IGS_LOOKUPS_VIEW
73: WHERE lookup_code = p_credit_point_descriptor AND
74: closed_ind = 'Y' AND
75: lookup_type = 'CREDIT_POINT_DSCR';
76: BEGIN

Line 1108: IGS_LOOKUPS_VIEW.Lookup_Code%TYPE := 'ENROLLED';

1104: -- Perform checks required prior to the 'ending' of a IGS_PS_UNIT version, being
1105: -- - no 'enrolled' attempts can be linked to the version.
1106: DECLARE
1107: cst_enrolled CONSTANT
1108: IGS_LOOKUPS_VIEW.Lookup_Code%TYPE := 'ENROLLED';
1109: cst_unconfirm CONSTANT
1110: IGS_LOOKUPS_VIEW.Lookup_Code%TYPE := 'UNCONFIRM';
1111: cst_invalid CONSTANT
1112: IGS_LOOKUPS_VIEW.Lookup_Code%TYPE := 'INVALID';

Line 1110: IGS_LOOKUPS_VIEW.Lookup_Code%TYPE := 'UNCONFIRM';

1106: DECLARE
1107: cst_enrolled CONSTANT
1108: IGS_LOOKUPS_VIEW.Lookup_Code%TYPE := 'ENROLLED';
1109: cst_unconfirm CONSTANT
1110: IGS_LOOKUPS_VIEW.Lookup_Code%TYPE := 'UNCONFIRM';
1111: cst_invalid CONSTANT
1112: IGS_LOOKUPS_VIEW.Lookup_Code%TYPE := 'INVALID';
1113: cst_error CONSTANT VARCHAR2(1) := 'E';
1114: cst_warning CONSTANT VARCHAR2(1) := 'W';

Line 1112: IGS_LOOKUPS_VIEW.Lookup_Code%TYPE := 'INVALID';

1108: IGS_LOOKUPS_VIEW.Lookup_Code%TYPE := 'ENROLLED';
1109: cst_unconfirm CONSTANT
1110: IGS_LOOKUPS_VIEW.Lookup_Code%TYPE := 'UNCONFIRM';
1111: cst_invalid CONSTANT
1112: IGS_LOOKUPS_VIEW.Lookup_Code%TYPE := 'INVALID';
1113: cst_error CONSTANT VARCHAR2(1) := 'E';
1114: cst_warning CONSTANT VARCHAR2(1) := 'W';
1115: v_sua_enrolled BOOLEAN := FALSE;
1116: v_sua_inv_unc BOOLEAN := FALSE;