eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_RE_SPRVSR_PKG dependencies on IGS_RE_VAL_RSUP

Line 6: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_re_val_rsup.genp_val_sdtt_sess

2: /* $Header: IGSRI13B.pls 120.1 2005/07/04 00:42:01 appldev ship $ */
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;

Line 120: || Changed the reference of "IGS_RE_VAL_RSUP.RESP_VAL_CA_CHILDUPD" to program unit "IGS_RE_VAL_CAH.RESP_VAL_CA_CHILDUPD". -- kdande

116: NVL(old_references.replaced_person_id,-1))) THEN
117: -- Validate changes are allowed to be made
118: /*
119: || Bug ID 1956374 - Removal of Duplicate Program Units from OSS.
120: || Changed the reference of "IGS_RE_VAL_RSUP.RESP_VAL_CA_CHILDUPD" to program unit "IGS_RE_VAL_CAH.RESP_VAL_CA_CHILDUPD". -- kdande
121: */
122: IF IGS_RE_VAL_CAH.resp_val_ca_childupd(
123: new_references.ca_person_id,
124: new_references.ca_sequence_number,

Line 133: IF IGS_RE_VAL_RSUP.resp_val_rsup_person(

129: END IF;
130: END IF;
131: IF p_inserting THEN
132: -- Validate IGS_PE_PERSON
133: IF IGS_RE_VAL_RSUP.resp_val_rsup_person(
134: new_references.ca_person_id,
135: new_references.person_id,
136: p_legacy,
137: v_message_name) = FALSE THEN

Line 149: IF IGS_RE_VAL_RSUP.resp_val_rst_closed (

145: -- Validate that research supervisor type
146: IF p_inserting OR
147: (p_updating AND
148: new_references.research_supervisor_type <> old_references.research_supervisor_type) THEN
149: IF IGS_RE_VAL_RSUP.resp_val_rst_closed (
150: new_references.research_supervisor_type,
151: v_message_name) = FALSE THEN
152: Fnd_Message.Set_Name ('IGS', v_message_name);
153: IGS_GE_MSG_STACK.ADD;

Line 163: IF IGS_RE_VAL_RSUP.resp_val_rsup_fund(

159: (p_updating AND
160: ((NVL(new_references.funding_percentage,-1) <> NVL(old_references.funding_percentage,-1)) OR
161: new_references.org_unit_cd IS NULL)) THEN
162: /*
163: IF IGS_RE_VAL_RSUP.resp_val_rsup_fund(
164: new_references.person_id,
165: new_references.org_unit_cd,
166: new_references.ou_start_dt,
167: new_references.funding_percentage,

Line 190: IF IGS_RE_VAL_RSUP.resp_val_rsup_ou(

186: ((NVL(new_references.org_unit_cd,'NULL') <> NVL(old_references.org_unit_cd,'NULL')) OR
187: (NVL(new_references.ou_start_dt,igs_ge_date.igsdate('9999/01/01')) <>
188: NVL(old_references.ou_start_dt,igs_ge_date.igsdate('9999/01/01'))))) THEN
189:
190: IF IGS_RE_VAL_RSUP.resp_val_rsup_ou(
191: new_references.person_id,
192: new_references.org_unit_cd,
193: new_references.ou_start_dt,
194: NULL, -- staff member indicator

Line 209: || Changed the reference of "IGS_RE_VAL_RSUP.RESP_VAL_CA_CHILDUPD" to program unit "IGS_RE_VAL_CAH.RESP_VAL_CA_CHILDUPD". -- kdande

205: IF p_deleting THEN
206: -- Validate deletes are allowed
207: /*
208: || Bug ID 1956374 - Removal of Duplicate Program Units from OSS.
209: || Changed the reference of "IGS_RE_VAL_RSUP.RESP_VAL_CA_CHILDUPD" to program unit "IGS_RE_VAL_CAH.RESP_VAL_CA_CHILDUPD". -- kdande
210: */
211: IF IGS_RE_VAL_CAH.resp_val_ca_childupd(
212: old_references.ca_person_id,
213: old_references.ca_sequence_number,

Line 247: IF IGS_RE_VAL_RSUP.resp_val_rsup_end_dt(

243: --Validate research supervisor end date
244: IF (NVL( NEW_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01')) <>
245: NVL(OLD_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01')))
246: THEN
247: IF IGS_RE_VAL_RSUP.resp_val_rsup_end_dt(
248: NEW_REFERENCES.ca_person_id,
249: NEW_REFERENCES.ca_sequence_number,
250: NEW_REFERENCES.person_id,
251: NEW_REFERENCES.sequence_number,

Line 269: IF IGS_RE_VAL_RSUP.resp_val_rsup_ovrlp(

265: (NEW_REFERENCES.start_dt <> OLD_REFERENCES.start_dt) OR
266: (NVL(NEW_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01')) <>
267: NVL(OLD_REFERENCES.end_dt,igs_ge_date.igsdate('9999/01/01'))))
268: THEN
269: IF IGS_RE_VAL_RSUP.resp_val_rsup_ovrlp(
270: NEW_REFERENCES.ca_person_id,
271: NEW_REFERENCES.ca_sequence_number,
272: NEW_REFERENCES.person_id,
273: NEW_REFERENCES.sequence_number,

Line 293: IF IGS_RE_VAL_RSUP.resp_val_rsup_repl(

289: NVL(OLD_REFERENCES.replaced_person_id,0)) OR
290: (NEW_REFERENCES.replaced_sequence_number <>
291: NVL(OLD_REFERENCES.replaced_sequence_number,0)) OR
292: (NEW_REFERENCES.start_dt <> OLD_REFERENCES.start_dt)) THEN
293: IF IGS_RE_VAL_RSUP.resp_val_rsup_repl(
294: NEW_REFERENCES.ca_person_id,
295: NEW_REFERENCES.ca_sequence_number,
296: NEW_REFERENCES.person_id,
297: NEW_REFERENCES.start_dt,

Line 323: IF IGS_RE_VAL_RSUP.resp_val_rsup_perc(

319: NVL(OLD_REFERENCES.supervision_percentage,-1)) OR
320: (NVL(NEW_REFERENCES.funding_percentage,-1) <>
321: NVL(OLD_REFERENCES.funding_percentage,-1))) THEN
322: /*
323: IF IGS_RE_VAL_RSUP.resp_val_rsup_perc(
324: NEW_REFERENCES.ca_person_id,
325: NEW_REFERENCES.ca_sequence_number,
326: NULL, -- sca_course_cd
327: NULL, -- acai_admission_appl_number

Line 354: IF IGS_RE_VAL_RSUP.resp_val_rsup_perc(

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,
356: OLD_REFERENCES.ca_sequence_number,
357: NULL, -- sca_course_cd
358: NULL, -- acai_admission_appl_number