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';

Line: 3061

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

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

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

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

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

    DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N'
    AND RECORD_ID=p_from_id AND ENTITY='CONTACT_POINTS';

Line: 3210

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line: 3996

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

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

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

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

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

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

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

Line: 4170

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

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

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

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

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

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

Line: 4282

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

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

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

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

   SELECT   primary_language_indicator,native_language
     FROM   HZ_PERSON_LANGUAGE
    WHERE   LANGUAGE_USE_REFERENCE_ID  = p_from_id;

Line: 4381

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

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

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

Line: 4441

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

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

Line: 4484

                       IS SELECT 1 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.SITE_USE_TYPE = p_site_use_type
			   AND    SU.PRIMARY_PER_TYPE = 'Y'
			   AND    SU.REQUEST_ID =p_request_id
			   AND    ROWNUM = 1;

Line: 4503

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

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

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

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

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

    DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N' AND ENTITY='CONTACTS'
    AND RECORD_ID=p_from_id;

Line: 4711

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

  SELECT org_contact_id
  FROM HZ_ORG_CONTACTS
  WHERE party_relationship_id = p_to_fk_id;

Line: 4747

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

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

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

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

    DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N' AND ENTITY='CONTACTS'
    AND RECORD_ID=p_from_id;

Line: 4915

	SELECT PARTY_USAGE_CODE INTO l_from_usage_code
	FROM hz_party_usg_assignments
	where party_usg_assignment_id = p_from_id;

Line: 4923

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

Line: 4933

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

Line: 4943

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

                 DELETE FROM hz_party_usg_assignments
                 WHERE party_usg_assignment_id = p_from_id;

Line: 5013

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

Line: 5042

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

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

Line: 5055

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

Line: 5061

  SELECT relationship_id, nvl(request_id,-1)
  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 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_code = (
         SELECT 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: 5148

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

    UPDATE HZ_RELATIONSHIPS
    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 relationship_id = p_from_id;

Line: 5175

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

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

Line: 5214

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

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

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

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

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

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

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

         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

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

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

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

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

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

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

Line: 5448

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

Line: 5454

  SELECT relationship_id, nvl(request_id,-1)
  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 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_code = (
         SELECT 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: 5542

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

    UPDATE HZ_RELATIONSHIPS
    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 relationship_id = p_from_id;

Line: 5570

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

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

Line: 5613

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

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

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

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

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

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

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

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

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

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

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

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

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

    UPDATE HZ_RELATIONSHIPS
    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 relationship_id = p_from_id;

Line: 5897

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

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

Line: 6006

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

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

  SELECT CONTENT_SOURCE_TYPE
  FROM HZ_PERSON_PROFILES
  WHERE person_profile_id = p_from_id;

Line: 6066

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

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

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

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

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

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

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

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

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

               UPDATE HZ_PARTY_SITES
                  SET LOCATION_ID   = to_party_loc_id
                WHERE PARTY_SITE_ID = p_from_id ;

Line: 6288

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

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

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

Line: 6336

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

Line: 6342

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

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

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

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

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

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

      DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE
      RECORD_ID=x_to_id and entity='PARTY_SITES' AND STAGED_FLAG='N';

Line: 6575

  DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE record_id = p_from_id
  AND ENTITY = 'PARTY_SITES' AND STAGED_FLAG='N';

Line: 6597

  SELECT party_type
  FROM HZ_PARTIES
  WHERE party_id = cp_party_id;

Line: 6602

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

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

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

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

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

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

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

        l_requested_product     VARCHAR2(100);

Line: 6766

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

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

END insert_request_log;

Line: 6850

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

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

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

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

Line: 6908

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

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

	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
		   );