APPS.IGS_RE_VAL_TPM dependencies on IGS_RE_THS_PNL_MBR

Line 31: FROM IGS_RE_THS_PNL_MBR tpm

27: FROM IGS_RE_THS_PNL_TYPE tpt
28: WHERE thesis_panel_type = p_thesis_panel_type;
29: CURSOR c_tpm IS
30: SELECT count('x')
31: FROM IGS_RE_THS_PNL_MBR tpm
32: WHERE ca_person_id = p_person_id AND
33: ca_sequence_number = p_ca_sequence_number AND
34: the_sequence_number = p_the_sequence_number AND
35: creation_dt = p_creation_dt AND

Line 100: FROM IGS_RE_THS_PNL_MBR tpm,

96: DECLARE
97: v_loop_bool BOOLEAN DEFAULT FALSE;
98: CURSOR c_tpm_tpmpt IS
99: SELECT 'X'
100: FROM IGS_RE_THS_PNL_MBR tpm,
101: IGS_RE_THS_PNL_MR_TP tpmpt
102: WHERE tpm.ca_person_id = p_ca_person_id AND
103: tpm.ca_sequence_number = p_ca_sequence_number AND
104: tpm.the_sequence_number = p_the_sequence_number AND

Line 145: -- Description: Validate the IGS_RE_THS_PNL_MBR.paid_dt, checking for:

141: p_confirmed_dt IN DATE ,
142: p_message_name OUT NOCOPY VARCHAR2 )
143: RETURN BOOLEAN AS
144: BEGIN -- resp_val_tpm_paid
145: -- Description: Validate the IGS_RE_THS_PNL_MBR.paid_dt, checking for:
146: -- * Cannot set if confirmed_dt is null
147: -- * Cannot be a future date
148: -- * Cannot be prior to confirmed_dt
149: DECLARE

Line 183: -- Validate the IGS_RE_THS_PNL_MBR.confirmed_dt, checking for :

179: p_declined_dt IN DATE ,
180: p_message_name OUT NOCOPY VARCHAR2 )
181: RETURN BOOLEAN AS
182: BEGIN -- resp_val_tpm_cnfrm
183: -- Validate the IGS_RE_THS_PNL_MBR.confirmed_dt, checking for :
184: -- Cannot unset if thesis_result_cd has been set
185: -- Cannot unset if paid_dt has been set
186: -- Cannot be a future date
187: -- Cannot set if declined_dt is set

Line 230: -- Validate the IGS_RE_THS_PNL_MBR.declined_dt, checking for :

226: p_confirmed_dt IN DATE ,
227: p_message_name OUT NOCOPY VARCHAR2 )
228: RETURN BOOLEAN AS
229: BEGIN -- resp_val_tpm_dcln
230: -- Validate the IGS_RE_THS_PNL_MBR.declined_dt, checking for :
231: -- Cannot be set if the confirmed_dt is set
232: -- Cannot be a future date
233: DECLARE
234: BEGIN

Line 265: -- Validate the IGS_RE_THS_PNL_MBR.person_id, checking for :

261: p_person_id IN NUMBER ,
262: p_message_name OUT NOCOPY VARCHAR2 )
263: RETURN BOOLEAN AS
264: BEGIN -- resp_val_tpm_pe
265: -- Validate the IGS_RE_THS_PNL_MBR.person_id, checking for :
266: -- Warn if the person is a current student
267: -- person cannot be a panel member for themselves
268: -- Warn if the person is a supervisor of the candidate
269: DECLARE

Line 364: -- Description: Validate the IGS_RE_THS_PNL_MBR.thesis_result_cd

360: p_confirmed_dt IN DATE ,
361: p_message_name OUT NOCOPY VARCHAR2 )
362: RETURN BOOLEAN AS
363: BEGIN -- resp_val_tpm_thr
364: -- Description: Validate the IGS_RE_THS_PNL_MBR.thesis_result_cd
365: -- recommendation_summary fields, checking for :
366: -- * Cannot be a closed IGS_RE_THESIS result code
367: -- * Cannot set if parent thesis_examination has not been submitted
368: -- * Cannot set if panel member has not confirmed

Line 440: -- Description: Validate the IGS_RE_THS_PNL_MBR.panel_member_type, checking

436: p_panel_member_type IN VARCHAR2 ,
437: p_message_name OUT NOCOPY VARCHAR2 )
438: RETURN BOOLEAN AS
439: BEGIN -- resp_val_tpm_tpmt
440: -- Description: Validate the IGS_RE_THS_PNL_MBR.panel_member_type, checking
441: -- for: Closed type.
442: DECLARE
443: v_tpmt_rec IGS_RE_THS_PNL_MR_TP.closed_ind%TYPE;
444: CURSOR c_tpmt IS

Line 492: -- Validate whether IGS_RE_THS_PNL_MBR update transactions are possible

488: p_new_confirmed_dt IN DATE ,
489: p_message_name OUT NOCOPY VARCHAR2 )
490: RETURN BOOLEAN AS
491: BEGIN -- resp_val_tpm_upd
492: -- Validate whether IGS_RE_THS_PNL_MBR update transactions are possible
493: -- (insert,update and delete), checking for :
494: -- Can only insert or delete records when parent
495: -- thesis_examination.thesis_result_cd is not set
496: -- Cannot update thesis_result_cd, panel_member_type, confirmed_dt if parent