APPS.IGS_AD_IMP_008 dependencies on HZ_PARTY_SITE_USES

Line 746: FROM HZ_PARTY_SITE_USES

742: --Check to see if for this address these two site usages exist.
743: CURSOR site_c (p_party_site_id igs_pe_addr_v.party_site_id%TYPE,
744: p_site_use_code igs_ad_reladdr_int.site_use_code_1%TYPE ) IS
745: SELECT site_use_type,party_site_use_id,last_update_date
746: FROM HZ_PARTY_SITE_USES
747: WHERE PARTY_SITE_ID = p_party_site_id
748: AND site_use_type = p_site_use_code;
749:
750:

Line 757: l_party_site_use_id HZ_PARTY_SITE_USES.PARTY_SITE_USE_ID%TYPE;

753: p_api_version NUMBER(15);
754: site_c_rec site_c%ROWTYPE;
755: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
756: l_party_site_number VARCHAR2(2000);
757: l_party_site_use_id HZ_PARTY_SITE_USES.PARTY_SITE_USE_ID%TYPE;
758: l_site1 igs_ad_reladdr_int.site_use_code_1%TYPE;
759: l_site2 igs_ad_reladdr_int.site_use_code_2%TYPE;
760: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;
761: l_msg_count NUMBER;

Line 781: FROM hz_party_site_uses

777: --Check to see if for this address these two site usages exist.
778: CURSOR site_c (p_party_site_id igs_pe_addr_v.party_site_id%TYPE,
779: p_site_use_code igs_ad_reladdr_int.site_use_code_1%TYPE ) IS
780: SELECT site_use_type,party_site_use_id,last_update_date
781: FROM hz_party_site_uses
782: WHERE party_site_id = p_party_site_id AND
783: site_use_type = p_site_use_code;
784: l_flag_check_status VARCHAR2(1);
785: site_c_rec site_c%ROWTYPE;

Line 788: l_party_site_use_id HZ_PARTY_SITE_USES.PARTY_SITE_USE_ID%TYPE;

784: l_flag_check_status VARCHAR2(1);
785: site_c_rec site_c%ROWTYPE;
786: l_location_id HZ_LOCATIONS.LOCATION_ID%TYPE;
787: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
788: l_party_site_use_id HZ_PARTY_SITE_USES.PARTY_SITE_USE_ID%TYPE;
789: l_row_id VARCHAR2(30);
790: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;
791: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;
792: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;

Line 908: IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK(

904: IF site_c%NOTFOUND THEN
905: l_party_site_use_id := NULL;
906: l_object_version_number := NULL;
907: -- call to create party site uses for site use code 1
908: IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK(
909: p_action => 'INSERT',
910: p_rowid => l_row_id,
911: p_party_site_use_id => l_party_site_use_id,
912: p_party_site_id => l_party_site_id,

Line 961: IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK(

957: IF site_c%NOTFOUND THEN
958: l_party_site_use_id := NULL;
959: l_object_version_number := NULL;
960: -- call to create party site uses for site use code 2
961: IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK(
962: p_action => 'INSERT',
963: p_rowid => l_row_id,
964: p_party_site_use_id => l_party_site_use_id,
965: p_party_site_id => l_party_site_id,

Line 1450: IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK(

1446: -- code to create part site use if site use code1 is not null
1447: IF (reladdr_rec.site_use_code_1 IS NOT NULL) AND l_flag_check_status = 'Y' THEN
1448: l_party_site_use_id := NULL;
1449: l_object_version_number := NULL;
1450: IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK(
1451: p_action => 'INSERT',
1452: p_rowid => l_row_id,
1453: p_party_site_use_id => l_party_site_use_id,
1454: p_party_site_id => l_party_site_id,

Line 1495: IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK(

1491: -- code to create part site use if site use code2 is not null
1492: IF (reladdr_rec.site_use_code_2 IS NOT NULL) AND l_flag_check_status = 'Y' THEN
1493: l_party_site_use_id := NULL;
1494: l_object_version_number := NULL;
1495: IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK(
1496: p_action => 'INSERT',
1497: p_rowid => l_row_id,
1498: p_party_site_use_id => l_party_site_use_id,
1499: p_party_site_id => l_party_site_id,