APPS.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on IGS_AD_ADDRUSAGE_INT_ALL

Line 357: P_ADDR_USAGE_CD IN IGS_AD_ADDRUSAGE_INT_ALL.SITE_USE_CODE%type)

353: p_Reporting_Year IN IGS_AD_ACT_ASSESSMENTS.REPORTING_YEAR%type,
354: p_Test_Type IN IGS_AD_ACT_ASSESSMENTS.TEST_TYPE%type,
355: p_Test_Date IN IGS_AD_ACT_ASSESSMENTS.TEST_DATE_TXT%type,
356: p_ACT_Id IN IGS_AD_ACT_ASSESSMENTS.act_identifier%type,
357: P_ADDR_USAGE_CD IN IGS_AD_ADDRUSAGE_INT_ALL.SITE_USE_CODE%type)
358:
359: AS
360:
361: /*----------------------------------------------------------------------------------

Line 542: ------> IGS_AD_ADDRUSAGE_INT_ALL -- akadam Bug# 4352471

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
546: ------> IGS_AD_TEST_SEGS_INT

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 677: INSERT INTO igs_ad_addrusage_int_all (

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,
679: interface_addr_id,
680: site_use_code,
681: status,