APPS.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on IGS_AD_INTERFACE_ALL

Line 454: l_interface_id igs_ad_interface_all.interface_id%type;

450:
451:
452: l_Batch_Id igs_ad_imp_batch_det.batch_id%type;
453: l_Batch_Desc igs_ad_imp_batch_det.batch_desc%type;
454: l_interface_id igs_ad_interface_all.interface_id%type;
455: l_interface_addr_id igs_ad_addr_int_all.interface_addr_id%type;
456: l_interface_test_id igs_ad_test_int.interface_test_id%type;
457: l_admission_test_type igs_ad_test_int.admission_test_type%type;
458: l_interface_acadhis_id igs_ad_acadhis_int_all.interface_acadhis_id%type;

Line 467: l_Interface_Id_exist igs_ad_interface_all.Interface_Id%type;

463: l_rec_count NUMBER;
464: l_rec_fail_count NUMBER;
465: l_ERRBUF VARCHAR2(1000);
466: l_RETCODE NUMBER;
467: l_Interface_Id_exist igs_ad_interface_all.Interface_Id%type;
468: l_High_School_Code igs_Ad_Act_Assessments.High_School_Code%type;
469: l_High_School_Graduation igs_Ad_Act_Assessments.High_School_Graduation%type;
470:
471: l_test_segment_id igs_ad_test_segs_int.test_segment_id%type;

Line 540: IGS_AD_INTERFACE_ALL

536: BEGIN -- Loading the Data to Interface Tables.
537:
538: /*---------------------------------------------------------------------------------------------------------
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

Line 589: -- Inserting the Latest Record in to the Main Interface Table (IGS_AD_INTERFACE_ALL)

585:
586: --debug
587: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside IF of loop : l_ACT Exist ' || l_ACT_Exist);
588:
589: -- Inserting the Latest Record in to the Main Interface Table (IGS_AD_INTERFACE_ALL)
590: INSERT
591: INTO IGS_AD_INTERFACE_ALL
592: (
593: INTERFACE_ID ,

Line 591: INTO IGS_AD_INTERFACE_ALL

587: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside IF of loop : l_ACT Exist ' || l_ACT_Exist);
588:
589: -- Inserting the Latest Record in to the Main Interface Table (IGS_AD_INTERFACE_ALL)
590: INSERT
591: INTO IGS_AD_INTERFACE_ALL
592: (
593: INTERFACE_ID ,
594: BATCH_ID ,
595: SOURCE_TYPE_ID ,

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

630:
631: --debug
632: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interface Id : 1' || l_interface_id);
633:
634: -- Inserting the Latest Record in to the Child (IGS_AD_ADDR_INT_ALL) of Interface Table (IGS_AD_INTERFACE_ALL).
635: INSERT
636: INTO IGS_AD_ADDR_INT_ALL
637: (
638: INTERFACE_ADDR_ID,

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: (