DBA Data[Home] [Help]

APPS.IGS_RE_SPRVSR_PKG dependencies on IGS_AS_VAL_SUAAP

Line 7: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess

3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What
6: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_re_val_rsup.genp_val_sdtt_sess
7: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
8: -------------------------------------------------------------------------------------------
9: l_rowid VARCHAR2(25);
10: old_references IGS_RE_SPRVSR%RowType;
11: new_references IGS_RE_SPRVSR%RowType;

Line 101: IF igs_as_val_suaap.genp_val_sdtt_sess('ENRP_INS_CA_TRNSFR') THEN

97: p_legacy := 'N';
98:
99: -- Turn off trigger validation when performing insert of IGS_RE_CANDIDATURE details
100: -- as a result of IGS_PS_COURSE transfer
101: IF igs_as_val_suaap.genp_val_sdtt_sess('ENRP_INS_CA_TRNSFR') THEN
102: IF p_inserting OR
103: (p_updating AND
104: (new_references.start_dt <> old_references.start_dt) OR
105: (NVL(new_references.end_dt,igs_ge_date.igsdate('9999/01/01')) <>

Line 237: IF igs_as_val_suaap.genp_val_sdtt_sess('ENRP_INS_CA_TRNSFR') THEN

233: p_legacy := 'N';
234:
235: -- Turn off trigger validation when performing insert of IGS_RE_CANDIDATURE details
236: -- as a result of IGS_PS_COURSE transfer
237: IF igs_as_val_suaap.genp_val_sdtt_sess('ENRP_INS_CA_TRNSFR') THEN
238: IF p_inserting OR
239: p_updating THEN
240: -- Set rowid
241:

Line 310: IF igs_as_val_suaap.genp_val_sdtt_sess('RESP_VAL_RSUP_PERC') THEN

306: END IF;
307: END IF;
308:
309: -- Do not validate at database level if being updated via form RESF3250
310: IF igs_as_val_suaap.genp_val_sdtt_sess('RESP_VAL_RSUP_PERC') THEN
311: -- Validate supervision and funding percentage
312: IF p_inserting OR
313: (p_updating AND
314: (NEW_REFERENCES.start_dt <> OLD_REFERENCES.start_dt) OR

Line 351: IF igs_as_val_suaap.genp_val_sdtt_sess('RESP_VAL_RSUP_PERC') THEN

347:
348:
349: IF p_deleting THEN
350: -- Do not validate at database level if being updated via form RESF3250
351: IF igs_as_val_suaap.genp_val_sdtt_sess('RESP_VAL_RSUP_PERC') THEN
352: -- Validate supervision and funding percentage
353: /*
354: IF IGS_RE_VAL_RSUP.resp_val_rsup_perc(
355: OLD_REFERENCES.ca_person_id,