APPS.HZ_MERGE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 337

PROCEDURE insert_request_log(
        p_source_party_id       IN      NUMBER,
        p_destination_party_id  IN      NUMBER
);

Line: 640

       SELECT oc.ORG_CONTACT_ID
       FROM HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACTS soc
       WHERE oc.PARTY_RELATIONSHIP_ID = p_from_id
       AND SOC.ORG_CONTACT_ID=oc.ORG_CONTACT_ID) LOOP
      HZ_DQM_SYNC.stage_contact_merge(
        'HZ_STAGED_CONTACTS',
        ORG_CT.ORG_CONTACT_ID,l_dummy_id,
        ORG_CT.ORG_CONTACT_ID,ORG_CT.ORG_CONTACT_ID,
        'HZ_ORG_CONTACTS',
        p_batch_id,p_batch_party_id,x_return_status);

Line: 699

       SELECT oc.ORG_CONTACT_ID
       FROM HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACTS soc
       WHERE oc.PARTY_RELATIONSHIP_ID = p_from_id
       AND SOC.ORG_CONTACT_ID=oc.ORG_CONTACT_ID) LOOP
      HZ_DQM_SYNC.stage_contact_merge(
        'HZ_STAGED_CONTACTS',
        ORG_CT.ORG_CONTACT_ID,l_dummy_id,
        ORG_CT.ORG_CONTACT_ID,ORG_CT.ORG_CONTACT_ID,
        'HZ_ORG_CONTACTS',
        p_batch_id,p_batch_party_id,x_return_status);

Line: 798

       SELECT soc.ORG_CONTACT_ID
       FROM HZ_STAGED_CONTACTS soc
       WHERE SOC.ORG_CONTACT_ID= p_from_id) LOOP
      HZ_DQM_SYNC.stage_contact_merge(
        'HZ_STAGED_CONTACTS',
        ORG_CT.ORG_CONTACT_ID,l_dummy_id,
        ORG_CT.ORG_CONTACT_ID,ORG_CT.ORG_CONTACT_ID,
        'HZ_ORG_CONTACTS',
        p_batch_id,p_batch_party_id,x_return_status);

Line: 1009

      UPDATE HZ_CUST_ACCOUNTS
      SET
        selling_party_id = p_to_fk_id,
        last_update_date = hz_utility_pub.last_update_date,
        last_updated_by = hz_utility_pub.user_id,
        last_update_login = hz_utility_pub.last_update_login,
        request_id =  hz_utility_pub.request_id,
        program_application_id = hz_utility_pub.program_application_id,
        program_id = hz_utility_pub.program_id,
        program_update_date = sysdate
      WHERE cust_account_id = p_from_id;

Line: 1278

      SELECT CONTACT_POINT_ID FROM HZ_STAGED_CONTACT_POINTS
      WHERE CONTACT_POINT_ID=p_from_id) LOOP

        HZ_DQM_SYNC.stage_contact_point_merge(
          'HZ_STAGED_CONTACT_POINTS',
          p_from_id,l_dummy_id,p_from_id,p_from_id,
          'HZ_CONTACT_POINTS',
          p_batch_id,p_batch_party_id,x_return_status);

Line: 2388

      SELECT CONTACT_POINT_ID FROM HZ_STAGED_CONTACT_POINTS
      WHERE CONTACT_POINT_ID=p_from_id) LOOP

        HZ_DQM_SYNC.stage_contact_point_merge(
          'HZ_STAGED_CONTACT_POINTS',
          p_from_id,l_dummy_id,p_from_id,p_from_id,
          'HZ_CONTACT_POINTS',
          p_batch_id,p_batch_party_id,x_return_status);

Line: 2753

    UPDATE HZ_CUST_ACCOUNTS
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE cust_account_id = p_from_id;

Line: 2785

    UPDATE HZ_CUST_ACCOUNTS
    SET
      party_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE cust_account_id = p_from_id;

Line: 2820

SELECT cust_account_id,cust_acct_site_id
FROM   HZ_CUST_ACCOUNT_ROLES
WHERE  cust_account_role_id = p_from_id
--AND    party_id = p_from_fk_id
AND    NVL(STATUS,'A') = 'A';

Line: 2827

SELECT count(1)
FROM   HZ_CUST_ACCOUNT_ROLES
WHERE  party_id = p_to_fk_id
AND    cust_account_id = p_acct_id
AND    NVL(cust_acct_site_id,l_g_miss_num) = NVL(p_acct_site_id,l_g_miss_num)
AND    NVL(STATUS,'A') = 'A';

Line: 2844

    UPDATE HZ_CUST_ACCOUNT_ROLES
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE cust_account_role_id = p_from_id;

Line: 2896

    UPDATE HZ_CUST_ACCOUNT_ROLES
    SET
      party_id = p_to_fk_id,
      status   = l_status,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE cust_account_role_id = p_from_id;

Line: 2931

    UPDATE HZ_FINANCIAL_PROFILE
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE financial_profile_id = p_from_id;

Line: 2944

    UPDATE HZ_FINANCIAL_PROFILE
    SET
      party_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE financial_profile_id = p_from_id;

Line: 2997

SELECT contact_point_type,primary_flag, url, email_address,
       contact_point_purpose,phone_line_type, phone_country_code,
       phone_area_code,phone_number,phone_extension ,primary_by_purpose
FROM HZ_CONTACT_POINTS
WHERE owner_table_name = 'HZ_PARTIES'
      AND contact_point_id = p_from_id
      AND rownum=1;

Line: 3010

    UPDATE HZ_CONTACT_POINTS
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE contact_point_id = p_from_id;

Line: 3022

    DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N'
    AND RECORD_ID=p_from_id AND ENTITY='CONTACT_POINTS'
    AND OPERATION <> 'D';

Line: 3062

        SELECT 'Exists'
        INTO    l_exists
        FROM    HZ_CONTACT_POINTS
        WHERE   PRIMARY_BY_PURPOSE    = 'Y'
        AND     CONTACT_POINT_PURPOSE = l_contact_point_purpose
        AND     OWNER_TABLE_NAME      = 'HZ_PARTIES'
        AND     CONTACT_POINT_TYPE    = l_contact_point_type
        AND     OWNER_TABLE_ID        = p_to_fk_id
        AND     ROWNUM = 1;

Line: 3079

        SELECT 'Exists'
        INTO    l_exists
        FROM    HZ_CONTACT_POINTS
        WHERE   primary_flag      = 'Y'
        AND     OWNER_TABLE_NAME  = 'HZ_PARTIES'
        AND     CONTACT_POINT_TYPE= l_contact_point_type
        AND     OWNER_TABLE_ID    = p_to_fk_id
        AND     ROWNUM = 1;

Line: 3113

    UPDATE HZ_CONTACT_POINTS
    SET
      owner_table_id = p_to_fk_id,
      primary_flag = l_primary_flag,
      primary_by_purpose = l_pri_purpose_flag,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE contact_point_id = p_from_id;

Line: 3156

SELECT contact_point_type, contact_point_purpose,primary_flag,primary_by_purpose
FROM HZ_CONTACT_POINTS
WHERE owner_table_name = 'HZ_PARTY_SITES'
      AND contact_point_id = p_from_id
      AND rownum=1;

Line: 3168

    UPDATE HZ_CONTACT_POINTS
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE contact_point_id = p_from_id;

Line: 3180

    DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N'
    AND RECORD_ID=p_from_id AND ENTITY='CONTACT_POINTS'
    AND OPERATION <> 'D';

Line: 3212

        SELECT 'Exists'
        INTO l_exists
        FROM HZ_CONTACT_POINTS
        WHERE PRIMARY_BY_PURPOSE    = 'Y'
        AND   CONTACT_POINT_PURPOSE = l_contact_point_purpose
        AND   OWNER_TABLE_NAME      = 'HZ_PARTY_SITES'
        AND   CONTACT_POINT_TYPE    = l_contact_point_type
        AND   OWNER_TABLE_ID        = p_to_fk_id
        AND   ROWNUM = 1;

Line: 3230

        SELECT 'Exists'
          INTO l_exists
          FROM HZ_CONTACT_POINTS
         WHERE PRIMARY_FLAG        = 'Y'
           AND OWNER_TABLE_NAME    = 'HZ_PARTY_SITES'
           AND OWNER_TABLE_ID      = p_to_fk_id
           AND CONTACT_POINT_TYPE  = l_contact_point_type
           AND ROWNUM = 1;

Line: 3245

    UPDATE HZ_CONTACT_POINTS
    SET
      owner_table_id = p_to_fk_id,
      primary_flag = l_primary_flag,
      primary_by_purpose = l_pri_purpose_flag,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE contact_point_id = p_from_id;

Line: 3280

    UPDATE HZ_CONTACT_PREFERENCES
    SET
      status = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE contact_preference_id = p_from_id;

Line: 3293

    UPDATE HZ_CONTACT_PREFERENCES
    SET
      contact_level_table_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE contact_preference_id = p_from_id;

Line: 3327

    UPDATE HZ_REFERENCES
    SET
      status = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE reference_id = p_from_id;

Line: 3340

    UPDATE HZ_REFERENCES
    SET
      referenced_party_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE reference_id = p_from_id;

Line: 3374

    UPDATE HZ_CERTIFICATIONS
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE certification_id = p_from_id;

Line: 3387

    UPDATE HZ_CERTIFICATIONS
    SET
      party_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE certification_id = p_from_id;

Line: 3421

    UPDATE HZ_CREDIT_RATINGS
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE credit_rating_id = p_from_id;

Line: 3434

    UPDATE HZ_CREDIT_RATINGS
    SET
      party_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE credit_rating_id = p_from_id;

Line: 3468

    UPDATE HZ_SECURITY_ISSUED
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE security_issued_id = p_from_id;

Line: 3481

    UPDATE HZ_SECURITY_ISSUED
    SET
      party_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE security_issued_id = p_from_id;

Line: 3515

    UPDATE HZ_FINANCIAL_REPORTS
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE financial_report_id = p_from_id;

Line: 3528

    UPDATE HZ_FINANCIAL_REPORTS
    SET
      party_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE financial_report_id = p_from_id;

Line: 3562

    UPDATE HZ_ORGANIZATION_INDICATORS
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE organization_indicator_id = p_from_id;

Line: 3575

    UPDATE HZ_ORGANIZATION_INDICATORS
    SET
      party_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE organization_indicator_id = p_from_id;

Line: 3609

    UPDATE HZ_INDUSTRIAL_REFERENCE
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE industry_reference_id = p_from_id;

Line: 3622

    UPDATE HZ_INDUSTRIAL_REFERENCE
    SET
      party_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE industry_reference_id = p_from_id;

Line: 3656

    UPDATE HZ_PERSON_INTEREST
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE person_interest_id = p_from_id;

Line: 3669

    UPDATE HZ_PERSON_INTEREST
    SET
      party_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE person_interest_id = p_from_id;

Line: 3703

    UPDATE HZ_CITIZENSHIP
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE citizenship_id = p_from_id;

Line: 3716

    UPDATE HZ_CITIZENSHIP
    SET
      party_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE citizenship_id = p_from_id;

Line: 3750

    UPDATE HZ_EDUCATION
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE education_id = p_from_id;

Line: 3763

    UPDATE HZ_EDUCATION
    SET
      party_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE education_id = p_from_id;

Line: 3797

    UPDATE HZ_EDUCATION
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE education_id = p_from_id;

Line: 3810

    UPDATE HZ_EDUCATION
    SET
      school_party_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE education_id = p_from_id;

Line: 3845

    UPDATE HZ_EMPLOYMENT_HISTORY
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE employment_history_id = p_from_id;

Line: 3858

    UPDATE HZ_EMPLOYMENT_HISTORY
    SET
      party_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE employment_history_id = p_from_id;

Line: 3892

    UPDATE HZ_EMPLOYMENT_HISTORY
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE employment_history_id = p_from_id;

Line: 3905

    UPDATE HZ_EMPLOYMENT_HISTORY
    SET
      employed_by_party_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE employment_history_id = p_from_id;

Line: 3940

    UPDATE HZ_WORK_CLASS
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE work_class_id = p_from_id;

Line: 3953

    UPDATE HZ_WORK_CLASS
    SET
      employment_history_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE work_class_id = p_from_id;

Line: 3991

     SELECT role_type,primary_flag,primary_contact_per_role_type
       FROM HZ_ORG_CONTACT_ROLES
      WHERE ORG_CONTACT_ROLE_ID = p_from_id;

Line: 3998

    UPDATE HZ_ORG_CONTACT_ROLES
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE org_contact_role_id = p_from_id;

Line: 4039

        SELECT 'Exists'
        INTO l_exists
        FROM HZ_ORG_CONTACT_ROLES
        WHERE PRIMARY_FLAG    = 'Y'
        AND   ORG_CONTACT_ID  = p_to_fk_id
        AND   ROWNUM = 1;

Line: 4053

        SELECT 'Exists'
        INTO    l_exists
        FROM         HZ_RELATIONSHIPS PR,
                     HZ_ORG_CONTACTS OC,
                     HZ_ORG_CONTACT_ROLES OCR,
                     HZ_RELATIONSHIPS PR2,
                     HZ_ORG_CONTACTS OC2
              WHERE  OCR.PRIMARY_CONTACT_PER_ROLE_TYPE = 'Y'
              AND    OCR.ROLE_TYPE            = l_role_type
              AND    OCR.ORG_CONTACT_ID       = OC.ORG_CONTACT_ID
              AND    OC.PARTY_RELATIONSHIP_ID = PR.RELATIONSHIP_ID
              AND    PR.OBJECT_ID             = PR2.OBJECT_ID
              AND    PR2.RELATIONSHIP_ID      = OC2.PARTY_RELATIONSHIP_ID
              AND    OC2.ORG_CONTACT_ID       = p_to_fk_id
              AND    PR.SUBJECT_TABLE_NAME    = 'HZ_PARTIES'
              AND    PR.OBJECT_TABLE_NAME     = 'HZ_PARTIES'
              AND    PR.DIRECTIONAL_FLAG      = 'F'
              AND    PR2.SUBJECT_TABLE_NAME   = 'HZ_PARTIES'
              AND    PR2.OBJECT_TABLE_NAME    = 'HZ_PARTIES'
              AND    PR2.DIRECTIONAL_FLAG     = 'F'
              AND    ROWNUM = 1;

Line: 4081

    UPDATE HZ_ORG_CONTACT_ROLES
    SET
      org_contact_id = p_to_fk_id,
      primary_flag   = l_primary_flag,
      primary_contact_per_role_type  = l_primary_role_flag,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE org_contact_role_id = p_from_id;

Line: 4116

    UPDATE HZ_FINANCIAL_NUMBERS
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE financial_number_id = p_from_id;

Line: 4129

    UPDATE HZ_FINANCIAL_NUMBERS
    SET
      financial_report_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE financial_number_id = p_from_id;

Line: 4167

  SELECT CONTENT_SOURCE_TYPE,CLASS_CATEGORY,PRIMARY_FLAG,CLASS_CODE
  FROM HZ_CODE_ASSIGNMENTS
  WHERE code_assignment_id = p_from_id;

Line: 4172

SELECT 'Y'
FROM hz_class_categories cc, hz_code_assignments ca
WHERE ca.owner_table_id = p_to_fk_id
AND cc.class_category = ca.class_category
AND cc.allow_multi_assign_flag = 'N'
AND ca.class_category = l_class_category;

Line: 4193

    UPDATE HZ_CODE_ASSIGNMENTS
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login
--      request_id =  hz_utility_pub.request_id,
--      program_application_id = hz_utility_pub.program_application_id,
--      program_id = hz_utility_pub.program_id,
--      program_update_date = sysdate
    WHERE code_assignment_id = p_from_id;

Line: 4213

        SELECT 'Exists'
          INTO l_exists
          FROM HZ_CODE_ASSIGNMENTS
         WHERE primary_flag         = 'Y'
           AND OWNER_TABLE_NAME     = 'HZ_PARTIES'
           AND OWNER_TABLE_ID       = p_to_fk_id
           AND CLASS_CATEGORY       = l_class_category
           AND CONTENT_SOURCE_TYPE  = l_cont_src
           AND ROWNUM = 1;

Line: 4229

    UPDATE HZ_CODE_ASSIGNMENTS
    SET
      owner_table_id = p_to_fk_id,
      primary_flag =   l_primary_flag,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login
--      request_id =  hz_utility_pub.request_id,
--      program_application_id = hz_utility_pub.program_application_id,
--      program_id = hz_utility_pub.program_id,
--      program_update_date = sysdate
    WHERE code_assignment_id = p_from_id;

Line: 4245

	UPDATE hz_parties
	SET category_code = l_class_code,
	    last_update_date = hz_utility_pub.last_update_date,
            last_updated_by = hz_utility_pub.user_id,
            last_update_login = hz_utility_pub.last_update_login
        WHERE party_id = p_to_fk_id;

Line: 4279

  SELECT CONTENT_SOURCE_TYPE,CLASS_CATEGORY,PRIMARY_FLAG
  FROM HZ_CODE_ASSIGNMENTS
  WHERE code_assignment_id = p_from_id;

Line: 4284

SELECT 'Y'
FROM hz_class_categories cc, hz_code_assignments ca
WHERE ca.owner_table_id = p_to_fk_id
AND cc.class_category = ca.class_category
AND cc.allow_multi_assign_flag = 'N'
AND ca.class_category = l_class_category;

Line: 4304

    UPDATE HZ_CODE_ASSIGNMENTS
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login
--      request_id =  hz_utility_pub.request_id,
--      program_application_id = hz_utility_pub.program_application_id,
--      program_id = hz_utility_pub.program_id,
--      program_update_date = sysdate
    WHERE code_assignment_id = p_from_id;

Line: 4322

    SELECT 'Exists'
    INTO l_exists
    FROM HZ_CODE_ASSIGNMENTS
    WHERE PRIMARY_FLAG       = 'Y'
    AND OWNER_TABLE_NAME     = 'HZ_PARTY_SITES'
    AND OWNER_TABLE_ID       = p_to_fk_id
    AND CLASS_CATEGORY       = l_class_category
    AND CONTENT_SOURCE_TYPE  = l_cont_src
    AND ROWNUM = 1;

Line: 4339

    UPDATE HZ_CODE_ASSIGNMENTS
    SET
      owner_table_id = p_to_fk_id,
      primary_flag = l_primary_flag,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login
--      request_id =  hz_utility_pub.request_id,
--      program_application_id = hz_utility_pub.program_application_id,
--      program_id = hz_utility_pub.program_id,
--      program_update_date = sysdate
    WHERE code_assignment_id = p_from_id;

Line: 4376

   SELECT   primary_language_indicator,native_language
     FROM   HZ_PERSON_LANGUAGE
    WHERE   LANGUAGE_USE_REFERENCE_ID  = p_from_id;

Line: 4383

    UPDATE HZ_PERSON_LANGUAGE
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE language_use_reference_id = p_from_id;

Line: 4401

    SELECT 'Exists'
    INTO    l_exists
    FROM    HZ_PERSON_LANGUAGE
    WHERE   PRIMARY_LANGUAGE_INDICATOR = 'Y'
    AND     PARTY_ID = p_to_fk_id
    AND     ROWNUM = 1;

Line: 4415

    SELECT 'Exists'
    INTO    l_exists
    FROM    HZ_PERSON_LANGUAGE
    WHERE   NATIVE_LANGUAGE = 'Y'
    AND     PARTY_ID = p_to_fk_id
    AND     ROWNUM = 1;

Line: 4443

    UPDATE HZ_PERSON_LANGUAGE
    SET
      party_id = p_to_fk_id,
      primary_language_indicator = l_primary_lang_flag,
      native_language  = l_primary_nav_flag,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE language_use_reference_id = p_from_id;

Line: 4481

                SELECT PARTY_ID FROM HZ_PARTY_SITES
		WHERE  PARTY_SITE_ID = p_party_site_id
		AND ROWNUM =1;

Line: 4486

                       IS SELECT 1, request_id FROM HZ_PARTY_SITE_USES SU
			   WHERE  SU.PARTY_SITE_ID IN (
			      SELECT PS.PARTY_SITE_ID
			      FROM   HZ_PARTY_SITES PS
			      WHERE  PARTY_ID = p_party_id )
			   AND    SU.PARTY_SITE_ID <> p_party_site_id
			   AND    SU.PARTY_SITE_ID <> p_from_fk_id
			   AND    SU.SITE_USE_TYPE = p_site_use_type
			   AND    SU.PRIMARY_PER_TYPE = 'Y'
			  -- AND    SU.REQUEST_ID =p_request_id
			   AND    ROWNUM = 1;

Line: 4507

    UPDATE HZ_PARTY_SITE_USES
    SET
      ----Bug: 2619948 added setting status to 'M' here too
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE party_site_use_id = p_from_id;

Line: 4576

    UPDATE HZ_PARTY_SITE_USES
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE party_site_use_id = p_from_id;

Line: 4613

    UPDATE HZ_CUST_ACCT_SITES_ALL
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE cust_acct_site_id = p_from_id;

Line: 4646

    UPDATE HZ_CUST_ACCT_SITES_ALL
    SET
      party_site_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE cust_acct_site_id = p_from_id;

Line: 4681

    UPDATE HZ_ORG_CONTACTS
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE org_contact_id = p_from_id;

Line: 4693

    DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N' AND ENTITY='CONTACTS'
    AND RECORD_ID=p_from_id AND OPERATION <> 'D';

Line: 4717

    UPDATE HZ_ORG_CONTACTS
    SET
      party_site_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE org_contact_id = p_from_id;

Line: 4748

  SELECT org_contact_id
  FROM HZ_ORG_CONTACTS
  WHERE party_relationship_id = p_to_fk_id;

Line: 4753

	select
	   DEPARTMENT_CODE
	, DEPARTMENT
	, TITLE
	, JOB_TITLE
	, MAIL_STOP
	, CONTACT_KEY
	, DECISION_MAKER_FLAG
	, JOB_TITLE_CODE
	, MANAGED_BY
	, REFERENCE_USE_FLAG
	, RANK
	, NATIVE_LANGUAGE
	, OTHER_LANGUAGE_1
	, OTHER_LANGUAGE_2
	from hz_org_contacts
	where org_contact_id = cp_org_cnt_id;

Line: 4800

    UPDATE HZ_ORG_CONTACTS
    SET
      party_relationship_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE org_contact_id = p_from_id;

Line: 4834

    UPDATE HZ_ORG_CONTACTS
    SET
	DEPARTMENT_CODE = DECODE(DEPARTMENT_CODE, NULL, L_FROM_DEPARTMENT_CODE,DEPARTMENT_CODE),
	DEPARTMENT = DECODE(DEPARTMENT, NULL, L_FROM_DEPARTMENT,DEPARTMENT ),
	TITLE = DECODE(TITLE, NULL, L_FROM_TITLE,TITLE),
	JOB_TITLE = DECODE(JOB_TITLE, NULL, L_FROM_JOB_TITLE,JOB_TITLE),
	MAIL_STOP = DECODE(MAIL_STOP, NULL, L_FROM_MAIL_STOP,MAIL_STOP),
	CONTACT_KEY = DECODE(CONTACT_KEY, NULL, L_FROM_CONTACT_KEY,CONTACT_KEY),
	DECISION_MAKER_FLAG = DECODE(DECISION_MAKER_FLAG, NULL, L_FROM_DECISION_MAKER_FLAG,DECISION_MAKER_FLAG),
	JOB_TITLE_CODE = DECODE(JOB_TITLE_CODE, NULL, L_FROM_JOB_TITLE_CODE,JOB_TITLE_CODE),
	MANAGED_BY = DECODE(MANAGED_BY, NULL, L_FROM_MANAGED_BY,MANAGED_BY),
	REFERENCE_USE_FLAG = DECODE(REFERENCE_USE_FLAG, NULL, L_FROM_REFERENCE_USE_FLAG,REFERENCE_USE_FLAG),
	RANK = DECODE(RANK, NULL, L_FROM_RANK,RANK),
	NATIVE_LANGUAGE = DECODE(NATIVE_LANGUAGE, NULL, L_FROM_NATIVE_LANGUAGE,NATIVE_LANGUAGE),
	OTHER_LANGUAGE_1 = DECODE(OTHER_LANGUAGE_1, NULL, L_FROM_OTHER_LANGUAGE_1,OTHER_LANGUAGE_1),
	OTHER_LANGUAGE_2 = DECODE(OTHER_LANGUAGE_2, NULL, L_FROM_OTHER_LANGUAGE_2,OTHER_LANGUAGE_2)

    WHERE ORG_CONTACT_ID = l_to_orgcontact_id;

Line: 4854

    UPDATE HZ_ORG_CONTACTS
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE org_contact_id = p_from_id;

Line: 4866

    DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N' AND ENTITY='CONTACTS'
    AND RECORD_ID=p_from_id AND OPERATION <> 'D';

Line: 4921

	SELECT PARTY_USAGE_CODE INTO l_from_usage_code
	FROM hz_party_usg_assignments
	where party_usg_assignment_id = p_from_id;

Line: 4929

        UPDATE hz_party_usg_assignments
        SET status_flag = 'M',
        effective_end_date = TRUNC(sysdate)
        WHERE party_usg_assignment_id = p_from_id;

Line: 4939

                UPDATE hz_party_usg_assignments
                SET status_flag = 'M',
                effective_end_date = sysdate
                WHERE party_usg_assignment_id = p_from_id;

Line: 4949

                SELECT
                 party_usage_code,
                 effective_start_date,
                 effective_end_date,
                 comments,
                 owner_table_name,
                 owner_table_id,
                 created_by_module,
                 attribute_category,
                 attribute1,
                 attribute2,
                 attribute3,
                 attribute4,
                 attribute5,
                 attribute6,
                 attribute7,
                 attribute8,
                 attribute9,
                 attribute10,
                 attribute11,
                 attribute12,
                 attribute13,
                 attribute14,
                 attribute15,
                 attribute16,
                 attribute17,
                 attribute18,
                 attribute19,
                 attribute20
                INTO
                 p_party_usg_assignment_rec.party_usage_code,
                 p_party_usg_assignment_rec.effective_start_date,
                 p_party_usg_assignment_rec.effective_end_date,
                 p_party_usg_assignment_rec.comments,
                 p_party_usg_assignment_rec.owner_table_name,
                 p_party_usg_assignment_rec.owner_table_id,
                 p_party_usg_assignment_rec.created_by_module,
                 p_party_usg_assignment_rec.attribute_category,
                 p_party_usg_assignment_rec.attribute1,
                 p_party_usg_assignment_rec.attribute2,
                 p_party_usg_assignment_rec.attribute3,
                 p_party_usg_assignment_rec.attribute4,
                 p_party_usg_assignment_rec.attribute5,
                 p_party_usg_assignment_rec.attribute6,
                 p_party_usg_assignment_rec.attribute7,
                 p_party_usg_assignment_rec.attribute8,
                 p_party_usg_assignment_rec.attribute9,
                 p_party_usg_assignment_rec.attribute10,
                 p_party_usg_assignment_rec.attribute11,
                 p_party_usg_assignment_rec.attribute12,
                 p_party_usg_assignment_rec.attribute13,
                 p_party_usg_assignment_rec.attribute14,
                 p_party_usg_assignment_rec.attribute15,
                 p_party_usg_assignment_rec.attribute16,
                 p_party_usg_assignment_rec.attribute17,
                 p_party_usg_assignment_rec.attribute18,
                 p_party_usg_assignment_rec.attribute19,
                 p_party_usg_assignment_rec.attribute20
             FROM hz_party_usg_assignments
             WHERE party_usg_assignment_id = p_from_id;

Line: 5015

                 DELETE FROM hz_party_usg_assignments
                 WHERE party_usg_assignment_id = p_from_id;

Line: 5019

		 DELETE FROM hz_party_usg_assignments
                 WHERE party_id = p_to_fk_id
                 AND   party_usage_code = 'DEFAULT';

Line: 5048

  SELECT party_id
  FROM HZ_RELATIONSHIPS
  WHERE  relationship_id = cp_party_reln_id
  AND DIRECTIONAL_FLAG = 'F'
  and status in ('A','I'); -- bug 5094383

Line: 5055

  SELECT relationship_id
  FROM   HZ_RELATIONSHIPS
  WHERE  relationship_id = x_to_id
  FOR UPDATE NOWAIT;

Line: 5061

 SELECT start_date, nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')), actual_content_source, --5404244
         nvl(request_id , -1), NVL(status, 'A')
         FROM   HZ_RELATIONSHIPS
         WHERE  relationship_id = p_from_id
         AND DIRECTIONAL_FLAG='F';

Line: 5068

  SELECT relationship_id, nvl(request_id,-1), NVL(status, 'A')
  FROM   HZ_RELATIONSHIPS
  WHERE  object_id = p_to_fk_id
  AND actual_content_source = DECODE(from_cont_source_type, 'PURCHASED', from_cont_source, actual_content_source) --5404244
  AND actual_content_source <> 'DNB'
  AND subject_id = (
         SELECT SUBJECT_ID
         FROM   HZ_RELATIONSHIPS
         WHERE  relationship_id = p_from_id
         AND DIRECTIONAL_FLAG='F')
  AND subject_id NOT IN
  ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
  AND subject_id NOT IN
  ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
  AND relationship_type||relationship_code  = (
         SELECT relationship_type||relationship_code -- Bug No: 4571969
         FROM   HZ_RELATIONSHIPS
         WHERE  relationship_id = p_from_id
         AND DIRECTIONAL_FLAG='F')
  AND DIRECTIONAL_FLAG = 'F'
  AND ((start_date between from_start_date and from_end_date)
          or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
          or(start_datefrom_end_date))
  AND status IN ('A','I'); --bug 5260367

Line: 5160

      UPDATE HZ_RELATIONSHIPS
      SET
        party_id = l_from_party_id,
        last_update_date = hz_utility_pub.last_update_date,
        last_updated_by = hz_utility_pub.user_id,
        last_update_login = hz_utility_pub.last_update_login,
        request_id =  hz_utility_pub.request_id,
        program_application_id = hz_utility_pub.program_application_id,
        program_id = hz_utility_pub.program_id,
        program_update_date = sysdate
      WHERE relationship_id = x_to_id;

Line: 5174

    UPDATE HZ_RELATIONSHIPS
    SET
      STATUS = 'M',
      end_date =  sysdate,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE relationship_id = p_from_id;

Line: 5188

    UPDATE hz_party_usg_assignments
    SET status_flag = 'M',
        effective_end_date = trunc(sysdate)
    WHERE owner_table_id = p_from_id
    AND   owner_table_name = 'HZ_RELATIONSHIPS'
    AND   party_id = p_from_fk_id;

Line: 5212

    SELECT orig_system_type INTO from_cont_source_type --5404244
    FROM HZ_ORIG_SYSTEMS_B
    WHERE orig_system = from_cont_source;

Line: 5242

    UPDATE HZ_RELATIONSHIPS
    SET
      object_id = p_to_fk_id,
      status    = 'I',
      end_date = sysdate,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE relationship_id = p_from_id
    AND DIRECTIONAL_FLAG = 'F'
    RETURNING  subject_id, relationship_type, relationship_code,
               subject_type, object_type, party_id
    into l_subject_id, l_rel_type, l_rel_code,
         l_subject_type , l_object_type , l_rel_party_id;

Line: 5261

    UPDATE HZ_RELATIONSHIPS
    SET
      subject_id = p_to_fk_id,
      status    = 'I',
      end_date = sysdate,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE relationship_id = p_from_id
    AND DIRECTIONAL_FLAG = 'B';

Line: 5281

      select sub.party_name , obj.party_name , rel.party_number
      into l_subject_name , l_new_obj_party_name , l_rel_party_number
      from hz_parties sub , hz_parties obj , hz_parties rel
      where sub.party_id = l_subject_id
      and   obj.party_id = p_to_fk_id
      and   rel.party_id = l_rel_party_id;

Line: 5288

      UPDATE HZ_PARTIES
      SET PARTY_NAME = 	SUBSTRB(l_subject_name || '-' ||
                                l_new_obj_party_name  || '-' ||
                                l_rel_party_number, 1, 360)
      WHERE party_id = l_rel_party_id;

Line: 5304

    SELECT subject_id, relationship_type, relationship_code,subject_type,object_type,direction_code into l_subject_id, l_rel_type, l_rel_code,
           l_subject_type, l_object_type, l_direction_code
    FROM HZ_RELATIONSHIPS
    WHERE relationship_id = p_from_id
    AND   directional_flag = 'F';

Line: 5310

    SELECT allow_relate_to_self_flag
    INTO   l_self_rel_flag
    FROM   HZ_RELATIONSHIP_TYPES
    WHERE RELATIONSHIP_TYPE = l_rel_type
    AND FORWARD_REL_CODE = l_rel_code
    AND SUBJECT_TYPE = l_subject_type
    AND OBJECT_TYPE =  l_object_type;

Line: 5322

        SELECT 'Y' into l_par_exists
        FROM hz_hierarchy_nodes
        WHERE child_id = l_subject_id
        AND   parent_id = p_to_fk_id
        AND   l_direction_code = 'P'
        AND rownum = 1;

Line: 5346

    UPDATE HZ_RELATIONSHIPS
    SET
      object_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE relationship_id = p_from_id
    AND DIRECTIONAL_FLAG = 'F'
    RETURNING  subject_id, relationship_type, relationship_code,
               subject_type, object_type, party_id
    into l_subject_id, l_rel_type, l_rel_code,
         l_subject_type , l_object_type , l_rel_party_id;

Line: 5363

    UPDATE HZ_RELATIONSHIPS
    SET
      subject_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE relationship_id = p_from_id
    AND DIRECTIONAL_FLAG = 'B';

Line: 5381

      select sub.party_name , obj.party_name , rel.party_number
      into l_subject_name , l_new_obj_party_name , l_rel_party_number
      from hz_parties sub , hz_parties obj , hz_parties rel
      where sub.party_id = l_subject_id
      and   obj.party_id = p_to_fk_id
      and   rel.party_id = l_rel_party_id;

Line: 5388

      UPDATE HZ_PARTIES
      SET PARTY_NAME = 	SUBSTRB(l_subject_name || '-' ||
                                l_new_obj_party_name  || '-' ||
                                l_rel_party_number, 1, 360)
      WHERE party_id = l_rel_party_id;

Line: 5401

         UPDATE HZ_RELATIONSHIPS
         SET
         STATUS = 'I',
         END_DATE = sysdate,
         last_update_date = hz_utility_pub.last_update_date,
         last_updated_by = hz_utility_pub.user_id,
         last_update_login = hz_utility_pub.last_update_login,
         request_id =  hz_utility_pub.request_id,
         program_application_id = hz_utility_pub.program_application_id,
         program_id = hz_utility_pub.program_id,
         program_update_date = sysdate
         WHERE relationship_id = p_from_id;

Line: 5415

		 UPDATE HZ_PARTIES
		 SET STATUS = 'I',
		     last_update_date = hz_utility_pub.last_update_date,
		     last_updated_by = hz_utility_pub.user_id,
		     last_update_login = hz_utility_pub.last_update_login,
		     request_id =  hz_utility_pub.request_id,
		     program_application_id = hz_utility_pub.program_application_id,
		     program_id = hz_utility_pub.program_id,
		     program_update_date = sysdate
		 WHERE PARTY_ID = l_rel_party_id;

Line: 5439

		      UPDATE HZ_PARTIES
		      SET STATUS = 'M',
		          last_update_date = hz_utility_pub.last_update_date,
		          last_updated_by = hz_utility_pub.user_id,
		          last_update_login = hz_utility_pub.last_update_login,
		          request_id =  hz_utility_pub.request_id,
		          program_application_id = hz_utility_pub.program_application_id,
		          program_id = hz_utility_pub.program_id,
		          program_update_date = sysdate
		      WHERE PARTY_ID in (select party_id from hz_relationships where subject_id=p_to_fk_id
	      and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
        AND ((start_date between from_start_date and from_end_date)
        or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
        or(start_datefrom_end_date)));

Line: 5455

      	 UPDATE HZ_RELATIONSHIPS
         SET
         STATUS = 'M',
         END_DATE = sysdate,
         last_update_date = hz_utility_pub.last_update_date,
         last_updated_by = hz_utility_pub.user_id,
         last_update_login = hz_utility_pub.last_update_login,
         request_id =  hz_utility_pub.request_id,
         program_application_id = hz_utility_pub.program_application_id,
         program_id = hz_utility_pub.program_id,
         program_update_date = sysdate
         WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id
	      and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
        AND ((start_date between from_start_date and from_end_date)
        or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
        or(start_datefrom_end_date)));

Line: 5505

  SELECT party_id
  FROM HZ_RELATIONSHIPS
  WHERE  relationship_id = cp_party_reln_id
  AND DIRECTIONAL_FLAG = 'F'
  and status in ('A','I'); -- bug 5094383

Line: 5512

  SELECT relationship_id
  FROM   HZ_RELATIONSHIPS
  WHERE  relationship_id = x_to_id
  FOR UPDATE NOWAIT;

Line: 5518

 SELECT start_date, nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')), actual_content_source, --5404244
        nvl(request_id,-1),
        NVL(status, 'A')
         FROM   HZ_RELATIONSHIPS
         WHERE  relationship_id = p_from_id
         AND DIRECTIONAL_FLAG='F';

Line: 5526

  SELECT relationship_id, nvl(request_id,-1), NVL(status, 'A')
  FROM   HZ_RELATIONSHIPS
  WHERE  subject_id = p_to_fk_id
  AND actual_content_source = DECODE(from_cont_source_type, 'PURCHASED', from_cont_source, actual_content_source) --5404244
  AND actual_content_source <> 'DNB'
  AND object_id = (
         SELECT OBJECT_ID
         FROM   HZ_RELATIONSHIPS
         WHERE  relationship_id = p_from_id
         AND DIRECTIONAL_FLAG='F')
  AND  object_id NOT IN
  ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
  AND object_id NOT IN
  ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
  AND relationship_type||relationship_code  = (
         SELECT relationship_type||relationship_code  -- Bug No: 4571969
         FROM   HZ_RELATIONSHIPS
         WHERE  relationship_id = p_from_id
         AND DIRECTIONAL_FLAG='F')
  AND DIRECTIONAL_FLAG = 'F'
  AND ((start_date between from_start_date and from_end_date)
          or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
          or(start_datefrom_end_date))
  AND status IN ('A','I'); --bug 5260367

Line: 5619

      UPDATE HZ_RELATIONSHIPS
      SET
        party_id = l_from_party_id,
        last_update_date = hz_utility_pub.last_update_date,
        last_updated_by = hz_utility_pub.user_id,
        last_update_login = hz_utility_pub.last_update_login,
        request_id =  hz_utility_pub.request_id,
        program_application_id = hz_utility_pub.program_application_id,
        program_id = hz_utility_pub.program_id,
        program_update_date = sysdate
      WHERE relationship_id = x_to_id;

Line: 5633

    UPDATE HZ_RELATIONSHIPS
    SET
      STATUS = 'M',
      end_date = sysdate,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE relationship_id = p_from_id;

Line: 5648

    UPDATE hz_party_usg_assignments
    SET status_flag = 'M',
        effective_end_date = trunc(sysdate)
    WHERE owner_table_id = p_from_id
    AND   owner_table_name = 'HZ_RELATIONSHIPS'
    AND   party_id = p_from_fk_id;

Line: 5672

    SELECT orig_system_type INTO from_cont_source_type --5404244
    FROM HZ_ORIG_SYSTEMS_B
    WHERE orig_system = from_cont_source;

Line: 5704

    UPDATE HZ_RELATIONSHIPS
    SET
      subject_id = p_to_fk_id,
      status = 'I',
      end_date = sysdate,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE relationship_id = p_from_id
    AND DIRECTIONAL_FLAG = 'F'
    RETURNING  object_id, relationship_type, relationship_code ,
               subject_type, object_type, party_id
    into l_object_id, l_rel_type, l_rel_code,
         l_subject_type , l_object_type, l_rel_party_id;

Line: 5723

    UPDATE HZ_RELATIONSHIPS
    SET
      object_id = p_to_fk_id,
      status = 'I',
      end_date = sysdate,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE relationship_id = p_from_id
    AND DIRECTIONAL_FLAG = 'B';

Line: 5743

      select sub.party_name , obj.party_name , rel.party_number
      into l_new_subj_party_name , l_object_name , l_rel_party_number
      from hz_parties sub , hz_parties obj , hz_parties rel
      where sub.party_id = p_to_fk_id
      and   obj.party_id = l_object_id
      and   rel.party_id = l_rel_party_id;

Line: 5750

      UPDATE HZ_PARTIES
      SET PARTY_NAME = 	SUBSTRB(l_new_subj_party_name || '-' ||
                                l_object_name  || '-' ||
                                l_rel_party_number, 1, 360)
      WHERE party_id = l_rel_party_id;

Line: 5765

    SELECT object_id, relationship_type, relationship_code,subject_type,object_type,direction_code into l_object_id, l_rel_type, l_rel_code,
          l_subject_type, l_object_type, l_direction_code
    FROM HZ_RELATIONSHIPS
    WHERE relationship_id = p_from_id
    AND   directional_flag = 'F';

Line: 5774

          SELECT 'Y' into l_par_exists
          FROM hz_hierarchy_nodes
          WHERE child_id = l_object_id
          AND   parent_id = p_to_fk_id
          AND   l_direction_code = 'C'
          AND rownum = 1;

Line: 5785

    SELECT allow_relate_to_self_flag
    INTO   l_self_rel_flag
    FROM   HZ_RELATIONSHIP_TYPES
    WHERE RELATIONSHIP_TYPE = l_rel_type
    AND FORWARD_REL_CODE = l_rel_code
    AND SUBJECT_TYPE = l_subject_type
    AND OBJECT_TYPE =  l_object_type;

Line: 5805

    UPDATE HZ_RELATIONSHIPS
    SET
      subject_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE relationship_id = p_from_id
    AND DIRECTIONAL_FLAG = 'F'
    RETURNING  object_id, relationship_type, relationship_code ,
               subject_type, object_type, party_id
    into l_object_id, l_rel_type, l_rel_code,
         l_subject_type , l_object_type, l_rel_party_id;

Line: 5822

    UPDATE HZ_RELATIONSHIPS
    SET
      object_id = p_to_fk_id,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE relationship_id = p_from_id
    AND DIRECTIONAL_FLAG = 'B';

Line: 5840

      select sub.party_name , obj.party_name , rel.party_number
      into l_new_subj_party_name , l_object_name , l_rel_party_number
      from hz_parties sub , hz_parties obj , hz_parties rel
      where sub.party_id = p_to_fk_id
      and   obj.party_id = l_object_id
      and   rel.party_id = l_rel_party_id;

Line: 5847

      UPDATE HZ_PARTIES
      SET PARTY_NAME = 	SUBSTRB(l_new_subj_party_name || '-' ||
                                l_object_name  || '-' ||
                                l_rel_party_number, 1, 360)
      WHERE party_id = l_rel_party_id;

Line: 5860

         UPDATE HZ_RELATIONSHIPS
         SET
         STATUS = 'I',
         END_DATE = sysdate,
         last_update_date = hz_utility_pub.last_update_date,
         last_updated_by = hz_utility_pub.user_id,
         last_update_login = hz_utility_pub.last_update_login,
         request_id =  hz_utility_pub.request_id,
         program_application_id = hz_utility_pub.program_application_id,
         program_id = hz_utility_pub.program_id,
         program_update_date = sysdate
         WHERE relationship_id = p_from_id;

Line: 5875

		      UPDATE HZ_PARTIES
		      SET STATUS = 'I',
		          last_update_date = hz_utility_pub.last_update_date,
		          last_updated_by = hz_utility_pub.user_id,
		          last_update_login = hz_utility_pub.last_update_login,
		          request_id =  hz_utility_pub.request_id,
		          program_application_id = hz_utility_pub.program_application_id,
		          program_id = hz_utility_pub.program_id,
		          program_update_date = sysdate
		      WHERE PARTY_ID = l_rel_party_id;

Line: 5899

		        UPDATE HZ_PARTIES
		        SET STATUS = 'M',
		            last_update_date = hz_utility_pub.last_update_date,
		            last_updated_by = hz_utility_pub.user_id,
		            last_update_login = hz_utility_pub.last_update_login,
		            request_id =  hz_utility_pub.request_id,
		            program_application_id = hz_utility_pub.program_application_id,
		            program_id = hz_utility_pub.program_id,
		            program_update_date = sysdate
		        WHERE PARTY_ID IN (select party_id from hz_relationships where subject_id=p_to_fk_id
	              and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
                AND ((start_date between from_start_date and from_end_date)
          or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
          or(start_datefrom_end_date)));

Line: 5914

	        UPDATE HZ_RELATIONSHIPS
                SET
                STATUS = 'M',
                END_DATE = sysdate,
                last_update_date = hz_utility_pub.last_update_date,
                last_updated_by = hz_utility_pub.user_id,
                last_update_login = hz_utility_pub.last_update_login,
                request_id =  hz_utility_pub.request_id,
                program_application_id = hz_utility_pub.program_application_id,
                program_id = hz_utility_pub.program_id,
                program_update_date = sysdate
                WHERE relationship_id in (select relationship_id from hz_relationships where subject_id=p_to_fk_id
	              and object_id=p_to_fk_id and relationship_id <>p_from_id and status='A'
                AND ((start_date between from_start_date and from_end_date)
                or (nvl(end_date,to_date('12/31/4712','MM/DD/YYYY')) between from_start_date and from_end_date)
                or(start_datefrom_end_date)));

Line: 5962

  SELECT relationship_id
  FROM HZ_RELATIONSHIPS --4500011
  WHERE party_id = p_to_fk_id
  AND subject_table_name = 'HZ_PARTIES'
  AND object_table_name = 'HZ_PARTIES'
  AND directional_flag = 'F';

Line: 5985

    UPDATE HZ_RELATIONSHIPS
    SET
      STATUS = 'M',
      end_date = sysdate,
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE relationship_id = p_from_id;

Line: 6027

  SELECT organization_profile_id, last_update_date, duns_number_c
  FROM HZ_ORGANIZATION_PROFILES
  WHERE party_id = p_to_fk_id
  AND effective_end_date is null
  AND ACTUAL_CONTENT_SOURCE = cp_cont_source;

Line: 6034

  SELECT ACTUAL_CONTENT_SOURCE, last_update_date, duns_number_c
  FROM HZ_ORGANIZATION_PROFILES
  WHERE organization_profile_id = p_from_id;

Line: 6136

  UPDATE HZ_ORGANIZATION_PROFILES
  SET
      STATUS = 'M',
      effective_end_date = trunc(SYSDATE-1),
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
  WHERE organization_profile_id = p_from_id;

Line: 6166

  SELECT person_profile_id
  FROM HZ_PERSON_PROFILES
  WHERE party_id = p_to_fk_id
  AND effective_end_date is null
  AND content_source_type = cp_cont_source;

Line: 6173

  SELECT CONTENT_SOURCE_TYPE
  FROM HZ_PERSON_PROFILES
  WHERE person_profile_id = p_from_id;

Line: 6196

      UPDATE HZ_PERSON_PROFILES
      SET
        party_id  = p_to_fk_id,
        last_update_date = hz_utility_pub.last_update_date,
        last_updated_by = hz_utility_pub.user_id,
        last_update_login = hz_utility_pub.last_update_login,
        request_id =  hz_utility_pub.request_id,
        program_application_id = hz_utility_pub.program_application_id,
        program_id = hz_utility_pub.program_id,
        program_update_date = sysdate
      WHERE person_profile_id = p_from_id;

Line: 6211

    UPDATE HZ_PERSON_PROFILES
    SET
      STATUS = 'M',
      effective_end_date = trunc(SYSDATE-1),
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE person_profile_id = p_from_id;

Line: 6245

  SELECT l.CONTENT_SOURCE_TYPE, l.last_update_date, ps.party_id,
         ps.identifying_address_flag, ps.party_site_number
  FROM HZ_LOCATIONS l, HZ_PARTY_SITES ps
  WHERE ps.party_site_id = p_from_id
  AND ps.location_id = l.location_id;

Line: 6252

  SELECT ps.party_id, loc.content_source_type,loc.country,
         loc.address1, loc.address2, loc.address3, loc.address4,
	 loc.city, loc.postal_code, loc.state, loc.province,
	 loc.county,loc.location_id
  FROM HZ_LOCATIONS loc, HZ_PARTY_SITES ps
  WHERE ps.party_site_id = x_to_id
  AND   ps.location_id   = loc.location_id;

Line: 6261

   SELECT la.loc_id, la.org_id
   FROM   HZ_LOC_ASSIGNMENTS la, HZ_PARTY_SITES ps
   WHERE  ps.party_site_id = p_from_id
   AND  la.location_id = ps.location_id
   AND  la.org_id NOT IN ( SELECT DISTINCT la1.org_id
                           FROM  HZ_LOC_ASSIGNMENTS la1, HZ_PARTY_SITES ps1
                           WHERE ps1.party_site_id = x_to_id
                           AND la1.location_id = ps1.location_id
                         );

Line: 6272

 SELECT loc.location_id
   FROM HZ_PARTY_SITES ps,
        HZ_LOCATIONS   loc
  WHERE ps.location_id   = loc.location_id
   AND  ps.party_site_id = x_party_site_id;

Line: 6279

 SELECT party_type
  FROM  HZ_PARTY_SITES ps,
        HZ_PARTIES  p
  WHERE ps.party_id      = p.party_id
   AND  ps.party_site_id = p_from_id;

Line: 6352

       SELECT ps2.location_id INTO to_party_loc_id
        FROM  HZ_MERGE_PARTY_DETAILS mpd,
              HZ_PARTY_SITES         ps1,
              HZ_PARTY_SITES         ps2
       WHERE  ps1.party_site_id         =  mpd.merge_from_entity_id
         AND  ps2.party_site_id         =  mpd.merge_to_entity_id
         AND  mpd.merge_from_entity_id  <> nvl(mpd.merge_to_entity_id, -1)
         AND  ps1.location_id           =  l_from_location_id
         AND  merge_from_entity_id      <> p_from_id
         AND  mpd.batch_party_id        IN ( SELECT  batch_party_id
                                               FROM  hz_merge_parties mp,
                                                     hz_relationships r
                                               WHERE r.party_id       = p_from_fk_id
                                                AND  mp.from_party_id = r.object_id
                                                AND  mp.batch_id      = p_batch_id)
         AND  rownum                    =  1;

Line: 6371

          SELECT  party_site_id INTO map_ps_id
            FROM  HZ_PARTY_SITES
           WHERE  party_id    = p_to_fk_id
             AND  location_id = to_party_loc_id
             AND  rownum      = 1;

Line: 6382

               UPDATE HZ_PARTY_SITES
                  SET LOCATION_ID   = to_party_loc_id
                WHERE PARTY_SITE_ID = p_from_id ;

Line: 6418

       UPDATE HZ_PARTY_SITES
         SET  location_id = l_to_location_id
        WHERE party_site_id IN (
              SELECT psr.party_site_id
                FROM hz_parties       p,
                     hz_party_sites   psr,
                     hz_party_sites   pso,
                     hz_relationships r
              WHERE  pso.party_site_id = p_from_id
                AND  r.object_id       = pso.party_id
                AND  r.party_id        = p.party_id
                AND  p.party_id        = psr.party_id
                AND  psr.location_id   = l_from_location_id);

Line: 6446

           UPDATE hz_parties
           SET    country     = l_country,
                  address1    = l_address1,
                  address2    = l_address2,
                  address3    = l_address3,
                  address4    = l_address4,
                  city        = l_city,
                  postal_code = l_postal,
                  state       = l_state,
                  province    = l_province,
                  county      = l_county
           WHERE party_id     = l_to_party_id;

Line: 6461

		UPDATE HZ_PARTY_SITES
		SET
	   	identifying_address_flag = 'Y'
		WHERE party_site_id = x_to_id;

Line: 6466

		UPDATE HZ_PARTY_SITES
		SET
	   	identifying_address_flag = 'N'
		WHERE party_site_id = p_from_id;

Line: 6472

        UPDATE hz_parties
           SET    country     = l_country,
                  address1    = l_address1,
                  address2    = l_address2,
                  address3    = l_address3,
                  address4    = l_address4,
                  city        = l_city,
                  postal_code = l_postal,
                  state       = l_state,
                  province    = l_province,
                  county      = l_county
           WHERE party_id in
		   			   (select ps.party_id from hz_party_sites ps,hz_relationships pr
                        where ps.location_id = l_to_location_id
						and ps.identifying_address_flag(+)='Y'
						and ps.party_id = pr.party_id
                        and pr.object_id=l_to_party_id);

Line: 6498

  HZ_LOC_ASSIGNMENTS_PKG.Insert_Row (
                X_LOCATION_ID                           => l_location_id,
                X_LOC_ID                                => l_loc_id,
                X_ORG_ID                                => l_org_id,
                X_OBJECT_VERSION_NUMBER                 => 1,
                X_CREATED_BY_MODULE                     => 'PARTY_MERGE',
                X_APPLICATION_ID                        => 222
            );

Line: 6514

    UPDATE HZ_PARTY_SITES
    SET
      STATUS = 'M',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login,
      request_id =  hz_utility_pub.request_id,
      program_application_id = hz_utility_pub.program_application_id,
      program_id = hz_utility_pub.program_id,
      program_update_date = sysdate
    WHERE party_site_id = p_from_id;

Line: 6526

    UPDATE HZ_ORIG_SYS_REFERENCES
    SET
      STATUS = 'I',
      last_update_date = hz_utility_pub.last_update_date,
      last_updated_by = hz_utility_pub.user_id,
      last_update_login = hz_utility_pub.last_update_login
    WHERE owner_table_id = p_from_id and owner_table_name='HZ_PARTY_SITES';

Line: 6592

        UPDATE HZ_PARTY_SITES
        SET
          STATUS = 'M',
          party_site_number = l_party_site_number,
          last_update_date = hz_utility_pub.last_update_date,
          last_updated_by = hz_utility_pub.user_id,
          last_update_login = hz_utility_pub.last_update_login,
          request_id =  hz_utility_pub.request_id,
          program_application_id = hz_utility_pub.program_application_id,
          program_id = hz_utility_pub.program_id,
          program_update_date = sysdate
        WHERE party_site_id = p_from_id;

Line: 6684

    UPDATE hz_merge_party_details
    SET merge_to_entity_id = x_to_id
    WHERE batch_party_id IN (select batch_party_id from hz_merge_parties
                             where batch_id = p_batch_id)
    AND merge_to_entity_id = p_from_id
    AND entity_name = 'HZ_PARTY_SITES';

Line: 6703

  DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE record_id = p_from_id
  AND ENTITY = 'PARTY_SITES' AND STAGED_FLAG='N' AND OPERATION <> 'D';

Line: 6725

  SELECT party_type
  FROM HZ_PARTIES
  WHERE party_id = cp_party_id;

Line: 6730

  SELECT duns_number_c, last_update_date, organization_profile_id
  FROM HZ_ORGANIZATION_PROFILES
  WHERE party_id = p_from_id
  AND   EFFECTIVE_END_DATE IS NULL
  AND   actual_content_source = 'DNB'
  AND   nvl(status, 'A') = 'A';

Line: 6738

  SELECT duns_number_c , last_update_date, organization_profile_id
  FROM HZ_ORGANIZATION_PROFILES
  WHERE party_id = x_to_id
  AND   EFFECTIVE_END_DATE IS NULL
  AND   actual_content_source = 'DNB'
  AND   nvl(status, 'A') = 'A';

Line: 6746

   SELECT 1
   FROM HZ_RELATIONSHIPS   --4500011
   WHERE content_source_type = 'DNB'
   AND subject_id = p_from_id
   AND object_id = x_to_id
   AND RELATIONSHIP_CODE = 'HEADQUARTERS_OF'
   AND subject_table_name = 'HZ_PARTIES'
   AND object_table_name = 'HZ_PARTIES'
   AND directional_flag = 'F';

Line: 6806

  UPDATE HZ_PARTIES
  SET
    STATUS = 'M',
    last_update_date = hz_utility_pub.last_update_date,
    last_updated_by = hz_utility_pub.user_id,
    last_update_login = hz_utility_pub.last_update_login,
    request_id =  hz_utility_pub.request_id,
    program_application_id = hz_utility_pub.program_application_id,
    program_id = hz_utility_pub.program_id,
    program_update_date = sysdate
  WHERE party_id = p_from_id;

Line: 6818

  UPDATE HZ_DQM_SYNC_INTERFACE
  SET party_id = x_to_id WHERE STAGED_FLAG='N'
  AND PARTY_ID = p_from_id AND ENTITY<>'PARTY';

Line: 6861

  UPDATE HZ_ORGANIZATION_PROFILES
  SET
    displayed_duns_party_id = p_to_fk_id,
    last_update_date = hz_utility_pub.last_update_date,
    last_updated_by = hz_utility_pub.user_id,
    last_update_login = hz_utility_pub.last_update_login,
    request_id =  hz_utility_pub.request_id,
    program_application_id = hz_utility_pub.program_application_id,
    program_id = hz_utility_pub.program_id,
    program_update_date = sysdate
  WHERE organization_profile_id = p_from_id;

Line: 6883

PROCEDURE insert_request_log(
        p_source_party_id       IN      NUMBER,
        p_destination_party_id  IN      NUMBER
) IS

        l_requested_product     VARCHAR2(100);

Line: 6894

    SELECT requested_product, duns_number
    INTO   l_requested_product, l_duns_number
    FROM   hz_dnb_request_log
    WHERE  party_id = p_source_party_id
    AND    request_id = (
               SELECT MAX(request_id)
               FROM   hz_dnb_request_log
               WHERE  party_id = p_source_party_id
               AND    status = 'S' );

Line: 6904

    INSERT INTO hz_dnb_request_log(
       REQUEST_ID,
       PARTY_ID,
       REQUESTED_PRODUCT,
       DUNS_NUMBER,
       STATUS,
       CREATED_BY,
       CREATION_DATE,
       LAST_UPDATED_BY,
       LAST_UPDATE_DATE,
       LAST_UPDATE_LOGIN,
       COPIED_FROM_PARTY_ID )
    VALUES(
       HZ_DNB_REQUEST_LOG_S.nextval,
       p_destination_party_id,
       l_requested_product,
       l_duns_number,
       'S',
       hz_utility_pub.CREATED_BY,
       hz_utility_pub.CREATION_DATE,
       hz_utility_pub.LAST_UPDATED_BY,
       hz_utility_pub.LAST_UPDATE_DATE,
       hz_utility_pub.LAST_UPDATE_LOGIN,
       p_source_party_id );

Line: 6931

END insert_request_log;

Line: 6978

      UPDATE hz_parties
      SET    url		       = p_url,
             last_update_date          = hz_utility_v2pub.last_update_date,
	     last_updated_by           = hz_utility_v2pub.last_updated_by,
	     last_update_login         = hz_utility_v2pub.last_update_login,
	     request_id                = hz_utility_v2pub.request_id,
	     program_application_id    = hz_utility_v2pub.program_application_id,
	     program_id                = hz_utility_v2pub.program_id,
	     program_update_date       = sysdate
      WHERE  party_id = p_party_id;

Line: 6989

      UPDATE hz_parties
      SET    email_address	       = p_email_address,
             last_update_date          = hz_utility_v2pub.last_update_date,
	     last_updated_by           = hz_utility_v2pub.last_updated_by,
	     last_update_login         = hz_utility_v2pub.last_update_login,
	     request_id                = hz_utility_v2pub.request_id,
	     program_application_id    = hz_utility_v2pub.program_application_id,
	     program_id                = hz_utility_v2pub.program_id,
	     program_update_date       = sysdate
      WHERE  party_id = p_party_id;

Line: 7000

      UPDATE hz_parties
      SET    primary_phone_contact_pt_id       = p_phone_contact_pt_id,
             primary_phone_purpose             = p_phone_purpose,
	     primary_phone_line_type           = p_phone_line_type,
	     primary_phone_country_code        = p_phone_country_code,
	     primary_phone_area_code           = p_phone_area_code,
	     primary_phone_number              = p_phone_number,
	     primary_phone_extension           = p_phone_extension,
             last_update_date          = hz_utility_v2pub.last_update_date,
	     last_updated_by           = hz_utility_v2pub.last_updated_by,
	     last_update_login         = hz_utility_v2pub.last_update_login,
	     request_id                = hz_utility_v2pub.request_id,
	     program_application_id    = hz_utility_v2pub.program_application_id,
	     program_id                = hz_utility_v2pub.program_id,
	     program_update_date       = sysdate
      WHERE  party_id = p_party_id;

Line: 7030

  SELECT HIERARCHICAL_FLAG, MULTIPLE_PARENT_ALLOWED --5547536
  FROM   HZ_RELATIONSHIP_TYPES
  WHERE  RELATIONSHIP_TYPE = cp_rel_type
  AND    ROWNUM = 1;

Line: 7036

  SELECT relationship_type,subject_id,subject_table_name,subject_type,
         object_id,object_table_name,object_type,start_date,
	 direction_code,status,end_date
  FROM HZ_RELATIONSHIPS
  WHERE  relationship_id = cp_relship_id
  AND DIRECTIONAL_FLAG = 'F';

Line: 7046

   SELECT parent_id
   FROM hz_hierarchy_nodes
   WHERE child_id = cp_child_id
   AND   child_table_name = cp_table_name
   AND   child_object_type = cp_object_type
   AND   hierarchy_type = cp_rel_type
   AND   effective_end_date > sysdate --bug 6696774
   AND level_number = 1;

Line: 7098

    SELECT 'Y' INTO l_hier_exists
    FROM  hz_hierarchy_nodes
    WHERE (parent_id = l_object_id
    OR child_id = l_object_id)
    AND  hierarchy_type = l_rel_type
    AND   effective_end_date > SYSDATE
    AND   l_hierarchical_flag = 'Y'
    AND ROWNUM = 1;

Line: 7138

	  SELECT 'Y' INTO l_allow_child_merge
          FROM hz_merge_parties
          WHERE ((from_party_id = l_from_par_id AND to_party_id = l_to_par_id)
	  	  OR (from_party_id = l_to_par_id AND to_party_id = l_from_par_id))
          AND rownum = 1;

Line: 7174

	  SELECT 'Y' INTO l_allow_child_merge
          FROM hz_merge_parties
          WHERE ((from_party_id = l_from_par_id AND to_party_id = l_to_par_id)
	 	  OR (from_party_id = l_to_par_id AND to_party_id = l_from_par_id))
	  AND rownum = 1;

Line: 7228

	HZ_HIERARCHY_PUB.update_link(
		    p_init_msg_list           => FND_API.G_FALSE,
		    p_hierarchy_node_rec      => l_hierarchy_rec,
		    x_return_status           => x_return_status,
		    x_msg_count               => l_msg_count,
		    x_msg_data                => l_msg_data
		   );