DBA Data[Home] [Help]

APPS.IGS_PR_MILESTONE_PKG dependencies on IGS_RE_VAL_MIL

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

2: /* $Header: IGSQI01B.pls 120.0 2005/07/05 11:51:29 appldev noship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What
6: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_re_val_mil.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_PR_MILESTONE_ALL%RowType;

Line 104: IF IGS_RE_VAL_MIL.resp_val_mil_mty( new_references.milestone_type,

100: IF igs_as_val_suaap.genp_val_sdtt_sess('ENRP_INS_CA_TRNSFR') THEN
101: IF p_inserting OR
102: ( p_updating AND
103: old_references.milestone_type <> new_references.milestone_type ) THEN
104: IF IGS_RE_VAL_MIL.resp_val_mil_mty( new_references.milestone_type,
105: v_message_name) = FALSE THEN
106: Fnd_Message.Set_Name('IGS',v_message_name);
107: IGS_GE_MSG_STACK.ADD;
108: App_Exception.Raise_Exception;

Line 115: IF IGS_RE_VAL_MIL.resp_val_mil_actual( new_references.milestone_status,

111: IF p_inserting OR
112: ( p_updating AND
113: NVL(old_references.actual_reached_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
114: NVL(new_references.actual_reached_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
115: IF IGS_RE_VAL_MIL.resp_val_mil_actual( new_references.milestone_status,
116: new_references.actual_reached_dt,
117: v_message_name) = FALSE THEN
118: Fnd_Message.Set_Name('IGS',v_message_name);
119: IGS_GE_MSG_STACK.ADD;

Line 131: IF IGS_RE_VAL_MIL.resp_val_mil_days( new_references.milestone_type,

127: NVL(old_references.ovrd_ntfctn_reminder_days,-1) <>
128: NVL(new_references.ovrd_ntfctn_reminder_days,-1) OR
129: NVL(old_references.ovrd_ntfctn_re_reminder_days,-1) <>
130: NVL(new_references.ovrd_ntfctn_re_reminder_days,-1)) THEN
131: IF IGS_RE_VAL_MIL.resp_val_mil_days( new_references.milestone_type,
132: new_references.milestone_status,
133: new_references.due_dt,
134: old_references.ovrd_ntfctn_imminent_days,
135: new_references.ovrd_ntfctn_imminent_days,

Line 148: IF IGS_RE_VAL_MIL.resp_val_mil_del( old_references.person_id,

144: END IF;
145: END IF;
146: END IF;
147: IF p_deleting THEN
148: IF IGS_RE_VAL_MIL.resp_val_mil_del( old_references.person_id,
149: old_references.ca_sequence_number,
150: old_references.sequence_number,
151: old_references.milestone_status,
152: v_message_name) = FALSE THEN

Line 268: IF IGS_RE_VAL_MIL.resp_val_mil_prcd( new_references.person_id,

264: -- as a result of IGS_PS_COURSE transfer
265: IF igs_as_val_suaap.genp_val_sdtt_sess('ENRP_INS_CA_TRNSFR') THEN
266:
267: -- Validate preceeding details.
268: IF IGS_RE_VAL_MIL.resp_val_mil_prcd( new_references.person_id,
269: new_references.ca_sequence_number,
270: new_references.sequence_number,
271: new_references.due_dt,
272: new_references.preced_sequence_number,

Line 279: IF IGS_RE_VAL_MIL.resp_val_mil_mst(new_references.person_id,

275: IGS_GE_MSG_STACK.ADD;
276: App_Exception.Raise_Exception;
277: END IF;
278: -- Validate milestone status.
279: IF IGS_RE_VAL_MIL.resp_val_mil_mst(new_references.person_id,
280: new_references.ca_sequence_number,
281: new_references.preced_sequence_number,
282: old_references.milestone_status,
283: new_references.milestone_status,

Line 293: IF IGS_RE_VAL_MIL.resp_val_mil_due(new_references.person_id,

289: IGS_GE_MSG_STACK.ADD;
290: App_Exception.Raise_Exception;
291: END IF;
292: -- Validate milestone due date.
293: IF IGS_RE_VAL_MIL.resp_val_mil_due(new_references.person_id,
294: new_references.ca_sequence_number,
295: new_references.sequence_number,
296: old_references.milestone_status,
297: new_references.milestone_status,