APPS.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on IGS_AD_CONTACTS_INT_ALL

Line 543: --> IGS_AD_CONTACTS_INT_ALL

539: Loading the Data into Interface Tables in the Following Hierarchy:
540: IGS_AD_INTERFACE_ALL
541: --> IGS_AD_ADDR_INT_ALL
542: ------> IGS_AD_ADDRUSAGE_INT_ALL -- akadam Bug# 4352471
543: --> IGS_AD_CONTACTS_INT_ALL
544: --> IGS_AD_API_INT_ALL
545: --> IGS_AD_TEST_INT
546: ------> IGS_AD_TEST_SEGS_INT
547: --> IGS_AD_ACADHIS_INT_ALL

Line 703: -- Inserting the Latest Record in to the Child (IGS_AD_CONTACTS_INT_ALL) of Interface Table (IGS_AD_INTERFACE_ALL).

699: );
700: END IF;
701:
702:
703: -- Inserting the Latest Record in to the Child (IGS_AD_CONTACTS_INT_ALL) of Interface Table (IGS_AD_INTERFACE_ALL).
704: IF (LENGTH(RTRIM(LTRIM(Act_Assessment_rec.home_phone,' '),' ')) = 10) THEN
705: INSERT
706: INTO IGS_AD_CONTACTS_INT_ALL
707: (

Line 706: INTO IGS_AD_CONTACTS_INT_ALL

702:
703: -- Inserting the Latest Record in to the Child (IGS_AD_CONTACTS_INT_ALL) of Interface Table (IGS_AD_INTERFACE_ALL).
704: IF (LENGTH(RTRIM(LTRIM(Act_Assessment_rec.home_phone,' '),' ')) = 10) THEN
705: INSERT
706: INTO IGS_AD_CONTACTS_INT_ALL
707: (
708: INTERFACE_CONTACTS_ID ,
709: INTERFACE_ID ,
710: CONTACT_POINT_TYPE ,

Line 739: INTO IGS_AD_CONTACTS_INT_ALL

735: );
736: ELSE
737: IF (Act_Assessment_rec.home_phone IS NOT NULL) THEN
738: INSERT
739: INTO IGS_AD_CONTACTS_INT_ALL
740: (
741: INTERFACE_CONTACTS_ID ,
742: INTERFACE_ID ,
743: CONTACT_POINT_TYPE ,