APPS.IGS_RE_VAL_SCH dependencies on IGS_RE_SCHOLARSHIP

Line 16: -- Validate the IGS_RE_SCHOLARSHIP type closed indicator

12: p_scholarship_type IN VARCHAR2 ,
13: p_message_name OUT NOCOPY VARCHAR2 )
14: RETURN BOOLEAN AS
15: BEGIN -- resp_val_scht_closed
16: -- Validate the IGS_RE_SCHOLARSHIP type closed indicator
17: DECLARE
18: v_scht_found VARCHAR2(1);
19: CURSOR c_scht IS
20: SELECT 'x'

Line 50: -- To validate IGS_RE_SCHOLARSHIP date overlaps

46: IGS_GE_MSG_STACK.ADD;
47: App_Exception.Raise_Exception;
48: END resp_val_scht_closed;
49: --
50: -- To validate IGS_RE_SCHOLARSHIP date overlaps
51: FUNCTION RESP_VAL_SCH_OVRLP(
52: p_person_id IN NUMBER ,
53: p_ca_sequence_number IN NUMBER ,
54: p_scholarship_type IN VARCHAR2 ,

Line 64: v_end_dt IGS_RE_SCHOLARSHIP.end_dt%TYPE;

60: -- Validate that the scolarship record being created or updated
61: -- does not overlap with an existing scolarship record of the
62: -- same scolarship_type.
63: DECLARE
64: v_end_dt IGS_RE_SCHOLARSHIP.end_dt%TYPE;
65: v_high_dt IGS_RE_SCHOLARSHIP.end_dt%TYPE;
66: v_exit_loop BOOLEAN DEFAULT FALSE;
67: CURSOR c_sch IS
68: SELECT sch.start_dt,

Line 65: v_high_dt IGS_RE_SCHOLARSHIP.end_dt%TYPE;

61: -- does not overlap with an existing scolarship record of the
62: -- same scolarship_type.
63: DECLARE
64: v_end_dt IGS_RE_SCHOLARSHIP.end_dt%TYPE;
65: v_high_dt IGS_RE_SCHOLARSHIP.end_dt%TYPE;
66: v_exit_loop BOOLEAN DEFAULT FALSE;
67: CURSOR c_sch IS
68: SELECT sch.start_dt,
69: sch.end_dt

Line 70: FROM IGS_RE_SCHOLARSHIP sch

66: v_exit_loop BOOLEAN DEFAULT FALSE;
67: CURSOR c_sch IS
68: SELECT sch.start_dt,
69: sch.end_dt
70: FROM IGS_RE_SCHOLARSHIP sch
71: WHERE sch.person_id = p_person_id AND
72: sch.ca_sequence_number = p_ca_sequence_number AND
73: sch.scholarship_type = p_scholarship_type AND
74: sch.start_dt <> p_start_dt;