APPS.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on IGS_AD_ADDR_INT_ALL

Line 455: l_interface_addr_id igs_ad_addr_int_all.interface_addr_id%type;

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;
459: l_Interface_Transcript_Id igs_ad_txcpt_int.interface_transcript_id%type;

Line 541: --> IGS_AD_ADDR_INT_ALL

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
545: --> IGS_AD_TEST_INT

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 636: INTO IGS_AD_ADDR_INT_ALL

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,
639: INTERFACE_ID ,
640: ADDR_LINE_1 ,

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

670: FND_GLOBAL.LOGIN_ID
671: )returning INTERFACE_ADDR_ID into l_interface_addr_id;
672:
673: -- akadam Included the below logic for Bug# 4352471
674: --Inserting the Latest Record in to the Child (IGS_AD_ADDRUSAGE_INT_ALL) of Interface Table (IGS_AD_ADDR_INT_ALL).
675:
676: IF P_ADDR_USAGE_CD IS NOT NULL THEN
677: INSERT INTO igs_ad_addrusage_int_all (
678: interface_addrusage_id,

Line 691: l_interface_addr_id, -- interfaced Id populated in igs_ad_addr_int_all.

687: )
688: VALUES
689: (
690: igs_ad_addrusage_int_s.NEXTVAL,
691: l_interface_addr_id, -- interfaced Id populated in igs_ad_addr_int_all.
692: p_addr_usage_cd,
693: '2',
694: fnd_global.user_id,
695: sysdate,