APPS.IGS_AS_UNITASS_ITEM_PKG dependencies on IGS_AS_VAL_UAI

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

2: /* $Header: IGSDI31B.pls 120.1 2006/09/20 07:29:23 sepalani noship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What
6: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to IGS_AS_VAL_UAI.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_as_unitass_item_all%ROWTYPE;

Line 127: IF igs_as_val_uai.assp_val_ai_exists (

123: IF p_inserting
124: OR p_updating THEN
125: --
126: -- Validate assessment item exists
127: IF igs_as_val_uai.assp_val_ai_exists (
128: new_references.ass_id,
129: v_message_name
130: ) = FALSE THEN
131: fnd_message.set_name ('IGS', v_message_name);

Line 154: IF igs_as_val_uai.crsp_val_crs_ci (

150: --
151: -- If calendar instance is inactive, then prevent inserts, updates and
152: -- deletes. As deletes are logical, they are equiv to updates and delete
153: -- trigger is not required.
154: IF igs_as_val_uai.crsp_val_crs_ci (
155: new_references.cal_type,
156: new_references.ci_sequence_number,
157: v_message_name
158: ) = FALSE THEN

Line 184: IF igs_as_val_uai.assp_val_uai_cal (

180: --
181: -- Validate the examination calendar type/sequence number if they have
182: -- been specified.
183: IF new_references.exam_cal_type IS NOT NULL THEN
184: IF igs_as_val_uai.assp_val_uai_cal (
185: new_references.exam_cal_type,
186: new_references.exam_ci_sequence_number,
187: new_references.cal_type,
188: new_references.ci_sequence_number,

Line 200: IF igs_as_val_uai.crsp_val_uo_cal_type (

196: --<>
197: IF p_inserting THEN
198: --
199: -- If calendar type is closed, then prevent inserts.
200: IF igs_as_val_uai.crsp_val_uo_cal_type (
201: new_references.cal_type,
202: v_message_name
203: ) = FALSE THEN
204: fnd_message.set_name ('IGS', v_message_name);

Line 291: IF igs_as_val_uai.assp_val_uai_uniqref (

287: v_message_name
288: ) = TRUE THEN
289: --
290: -- Validate that the reference number id unique within a UOP
291: IF igs_as_val_uai.assp_val_uai_uniqref (
292: new_references.unit_cd,
293: new_references.version_number,
294: new_references.cal_type,
295: new_references.ci_sequence_number,

Line 313: IF igs_as_val_uai.assp_val_uai_opt_ref (

309: new_references.logical_delete_dt,
310: igs_ge_date.igsdate ('1900/01/01')
311: ) = igs_ge_date.igsdate ('1900/01/01') THEN
312: -- Validate that the reference number id unique within a UOP
313: IF igs_as_val_uai.assp_val_uai_opt_ref (
314: new_references.unit_cd,
315: new_references.version_number,
316: new_references.cal_type,
317: new_references.ci_sequence_number,