DBA Data[Home] [Help]

APPS.IGS_PE_PERSON_ALIAS_PKG dependencies on IGS_AS_VAL_SUAAP

Line 9: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess

5: --Who When What
6: --smadathi 28-AUG-2001 Bug No. 1956374. The Call to igs_as_val_pal.genp_val_strt_end_dt
7: -- is replaced by igs_ad_val_edtl.genp_val_strt_end_dt
8: --smadathi 24-AUG-2001 Bug No. 1956374. The call to igs_en_val_pal.genp_val_sdtt_sess
9: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
10: --skpandey 01-JUL-2005 Bug No. 4327807
11: -- Added an additional condition in "BeforeRowInsertUpdate1" prodecure
12: -- to check that the Effective start date must not be earlier than the person's year of birth.
13: -------------------------------------------------------------------------------------------

Line 106: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_PE_PERSON_ALIAS') THEN

102: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
103: v_message_name varchar2(30);
104: BEGIN
105: -- If trigger has not been disabled, perform required processing
106: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_PE_PERSON_ALIAS') THEN
107: -- Validate START DATE AND END DATE.
108: -- Validate that if end date is specified, then start date is also specified.
109: IF (new_references.end_dt IS NOT NULL) AND
110: ((p_inserting OR p_updating) OR