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_CANDIDATURE_PKG dependencies on IGS_RE_VAL_CA

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

2: /* $Header: IGSRI01B.pls 120.1 2005/07/04 00:40:40 appldev ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What
6: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_re_val_ca.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_CANDIDATURE_ALL%RowType;

Line 139: IF IGS_RE_VAL_CA.resp_val_ca_sca_acai (

135: (NVL(old_references.acai_nominated_course_cd,'NULL') <>
136: NVL(new_references.acai_nominated_course_cd,'NULL')) OR
137: (NVL(old_references.acai_sequence_number,0) <>
138: NVL(new_references.acai_sequence_number,0))) THEN
139: IF IGS_RE_VAL_CA.resp_val_ca_sca_acai (
140: new_references.person_id,
141: new_references.sca_course_cd,
142: new_references.acai_admission_appl_number,
143: new_references.acai_nominated_course_cd,

Line 154: IF IGS_RE_VAL_CA.resp_val_ca_upd(

150: END IF;
151: IF p_updating AND
152: new_references.sca_course_cd IS NOT NULL THEN
153: -- Validate that updates are allowed
154: IF IGS_RE_VAL_CA.resp_val_ca_upd(
155: new_references.person_id,
156: new_references.sca_course_cd,
157: v_message_name) = FALSE THEN
158: Fnd_Message.Set_Name ('IGS', v_message_name);

Line 180: IF IGS_RE_VAL_CA.resp_val_ca_minsbmsn (

176: new_references.min_submission_dt IS NOT NULL) OR
177: (p_updating AND
178: NVL(old_references.min_submission_dt,igs_ge_date.igsdate('1900/01/01')) <>
179: NVL(new_references.min_submission_dt,igs_ge_date.igsdate('1900/01/01')) ) THEN
180: IF IGS_RE_VAL_CA.resp_val_ca_minsbmsn (
181: new_references.person_id,
182: new_references.sca_course_cd,
183: new_references.acai_admission_appl_number,
184: new_references.acai_nominated_course_cd,

Line 203: IF IGS_RE_VAL_CA.resp_val_ca_maxsbmsn (

199: new_references.max_submission_dt IS NOT NULL) OR
200: (p_updating AND
201: NVL(old_references.max_submission_dt,igs_ge_date.igsdate('1900/01/01')) <>
202: NVL(new_references.max_submission_dt,igs_ge_date.igsdate('1900/01/01')) ) THEN
203: IF IGS_RE_VAL_CA.resp_val_ca_maxsbmsn (
204: new_references.person_id,
205: new_references.sca_course_cd,
206: new_references.acai_admission_appl_number,
207: new_references.acai_nominated_course_cd,

Line 227: IF IGS_RE_VAL_CA.resp_val_gtcc_closed (

223: new_references.govt_type_of_activity_cd IS NOT NULL) OR
224: (p_updating AND
225: NVL(old_references.govt_type_of_activity_cd,'NULL') <>
226: NVL(new_references.govt_type_of_activity_cd,'NULL')) THEN
227: IF IGS_RE_VAL_CA.resp_val_gtcc_closed (
228: new_references.govt_type_of_activity_cd,
229: v_message_name) = FALSE THEN
230: Fnd_Message.Set_Name ('IGS', v_message_name);
231: IGS_GE_MSG_STACK.ADD;

Line 239: IF IGS_RE_VAL_CA.resp_val_ca_topic (

235: -- Validate research topic
236: IF p_inserting OR
237: (p_updating AND
238: NVL(old_references.research_topic,'NULL') <> NVL(new_references.research_topic,'NULL')) THEN
239: IF IGS_RE_VAL_CA.resp_val_ca_topic (
240: new_references.person_id,
241: new_references.sca_course_cd,
242: new_references.acai_admission_appl_number,
243: new_references.acai_nominated_course_cd,

Line 257: IF IGS_RE_VAL_CA.resp_val_ca_sca_del (

253: END IF;
254:
255: IF p_deleting THEN
256: -- Validate SCA link.
257: IF IGS_RE_VAL_CA.resp_val_ca_sca_del (
258: old_references.person_id,
259: old_references.sca_course_cd,
260: v_message_name) = FALSE THEN
261: Fnd_Message.Set_Name ('IGS', v_message_name);

Line 266: IF IGS_RE_VAL_CA.resp_val_ca_acai_del (

262: IGS_GE_MSG_STACK.ADD;
263: App_Exception.Raise_Exception;
264: END IF;
265: -- Validate ACAI link.
266: IF IGS_RE_VAL_CA.resp_val_ca_acai_del (
267: old_references.person_id,
268: old_references.acai_admission_appl_number,
269: old_references.acai_nominated_course_cd,
270: old_references.acai_sequence_number,

Line 413: IF IGS_RE_VAL_CA.resp_val_ca_minsbmsn (

409: END IF;
410: IF p_updating THEN
411: IF New_References.min_submission_dt IS NULL THEN
412: -- Validate derived minimum submission date
413: IF IGS_RE_VAL_CA.resp_val_ca_minsbmsn (
414: New_References.person_id,
415: New_References.sca_course_cd,
416: New_References.acai_admission_appl_number,
417: New_References.acai_nominated_course_cd,

Line 432: IF IGS_RE_VAL_CA.resp_val_ca_maxsbmsn (

428: END IF;
429: END IF;
430: IF New_References.max_submission_dt IS NULL THEN
431: -- Validate derived maximum submission date
432: IF IGS_RE_VAL_CA.resp_val_ca_maxsbmsn (
433: New_References.person_id,
434: New_References.sca_course_cd,
435: New_References.acai_admission_appl_number,
436: New_References.acai_nominated_course_cd,

Line 459: IF IGS_RE_VAL_CA.resp_val_ca_sca(

455: IF p_inserting OR
456: (p_updating AND
457: NVL(Old_References.sca_course_cd,'NULL') <>
458: NVL(New_References.sca_course_cd,'NULL')) THEN
459: IF IGS_RE_VAL_CA.resp_val_ca_sca(
460: New_References.person_id,
461: New_References.sequence_number,
462: Old_References.sca_course_cd,
463: New_References.sca_course_cd,

Line 482: IF IGS_RE_VAL_CA.resp_val_ca_acai(

478: (NVL(Old_References.acai_nominated_course_cd,'NULL') <>
479: NVL(New_References.acai_nominated_course_cd,'NULL')) OR
480: (NVL(Old_References.acai_sequence_number,0) <>
481: NVL(New_References.acai_sequence_number,0))) THEN
482: IF IGS_RE_VAL_CA.resp_val_ca_acai(
483: New_References.person_id,
484: New_References.sequence_number,
485: New_References.sca_course_cd,
486: Old_References.acai_admission_appl_number,