APPS.JTF_TASK_PARTY_MERGE_PKG SQL Statements

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

Line: 41

select  merge_reason_code
from    hz_merge_batch
where   batch_id = p_batch_id;

Line: 84

    UPDATE  jtf_tasks_b
    SET customer_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,
        object_version_number = object_version_number + 1
    WHERE customer_id = p_from_fk_id; -- just to make sure it is the right one

Line: 125

select  merge_reason_code
from    hz_merge_batch
where   batch_id = p_batch_id;

Line: 168

    UPDATE  jtf_task_audits_b
    SET new_customer_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,
        object_version_number = object_version_number + 1
    WHERE new_customer_id = p_from_fk_id; -- just to make sure it is the right one

Line: 208

select  merge_reason_code
from    hz_merge_batch
where   batch_id = p_batch_id;

Line: 251

    UPDATE  jtf_task_audits_b
    SET old_customer_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,
        object_version_number = object_version_number + 1
    WHERE old_customer_id = p_from_fk_id; -- just to make sure it is the right one

Line: 289

select  merge_reason_code
from    hz_merge_batch
where   batch_id = p_batch_id;

Line: 303

select  select_name
from    jtf_objects_vl
where   object_code = 'PARTY'
and nvl(start_date_active, sysdate) <= sysdate
and nvl(end_date_active, sysdate)   >= sysdate;

Line: 309

l_name          jtf_objects_vl.select_name%TYPE;

Line: 310

l_select_stat   varchar2(1000);

Line: 358

    l_select_stat :=
           'UPDATE jtf_tasks_b'
        || '   SET source_object_id = :1'
        ||     ' , source_object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_parties WHERE party_id = :3)'
        ||     ' , 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'
        ||     ' , object_version_number = object_version_number + 1'
        || ' WHERE source_object_id = :4'
        || '   AND source_object_type_code = ''PARTY''';

Line: 372

if l_select_stat is not NULL then
-- Modified by SBARAT on 23/12/2005 for SQL Literal issue, bug# 4614088
    EXECUTE IMMEDIATE l_select_stat
            USING to_char(p_to_fk_id) ,
                  l_name ,
                  to_char(p_to_fk_id) ,
                  to_char(p_from_fk_id);

Line: 380

    fnd_message.set_name('JTF', 'JTF_TASK_DYNAMYC_SELECT');

Line: 414

select  merge_reason_code
from    hz_merge_batch
where   batch_id = p_batch_id;

Line: 428

select  select_name
from    jtf_objects_vl
where   object_code = 'PARTY'
and nvl(start_date_active, sysdate) <= sysdate
and nvl(end_date_active, sysdate)   >= sysdate;

Line: 434

l_name      jtf_objects_vl.select_name%TYPE;

Line: 435

l_select_stat   varchar2(1000);

Line: 481

    l_select_stat := 'UPDATE jtf_task_audits_b '
            ||          'SET new_source_object_id = :1'
            ||           ' , new_source_object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_parties WHERE party_id = :3)'
            ||           ' , 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'
            ||           ' , object_version_number = object_version_number + 1'
            ||       ' WHERE new_source_object_id = :4'
            ||       '   AND new_source_object_type_code = ''PARTY''';

Line: 492

if l_select_stat is not NULL then
-- Modified by SBARAT on 23/12/2005 for SQL Literal issue, bug# 4614088
    EXECUTE IMMEDIATE l_select_stat
            USING to_char(p_to_fk_id) ,
                  l_name ,
                  to_char(p_to_fk_id) ,
                  to_char(p_from_fk_id);

Line: 500

    fnd_message.set_name('JTF', 'JTF_TASK_DYNAMYC_SELECT');

Line: 536

select  merge_reason_code
from    hz_merge_batch
where   batch_id = p_batch_id;

Line: 550

select  select_name
from    jtf_objects_vl
where   object_code = 'PARTY'
and nvl(start_date_active, sysdate) <= sysdate
and nvl(end_date_active, sysdate)   >= sysdate;

Line: 556

l_name      jtf_objects_vl.select_name%TYPE;

Line: 557

l_select_stat   varchar2(1000);

Line: 604

    l_select_stat := 'UPDATE jtf_task_audits_b'
            ||         ' SET old_source_object_id = :1'
            ||           ' , old_source_object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_parties WHERE party_id = :3 )'
            ||           ' , 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'
            ||           ' , object_version_number = object_version_number + 1'
            ||       ' WHERE old_source_object_id = :4'
            ||         ' AND old_source_object_type_code = ''PARTY''';

Line: 616

if l_select_stat is not NULL then
-- Modified by SBARAT on 23/12/2005 for SQL Literal issue, bug# 4614088
    EXECUTE IMMEDIATE l_select_stat
            USING to_char(p_to_fk_id) ,
                  l_name ,
                  to_char(p_to_fk_id) ,
                  to_char(p_from_fk_id);

Line: 624

    fnd_message.set_name('JTF', 'JTF_TASK_DYNAMYC_SELECT');

Line: 661

select  merge_reason_code
from    hz_merge_batch
where   batch_id = p_batch_id;

Line: 675

select  select_name
from    jtf_objects_vl
where   object_code = 'PARTY'
and nvl(start_date_active, sysdate) <= sysdate
and nvl(end_date_active, sysdate)   >= sysdate;

Line: 681

l_name      jtf_objects_vl.select_name%TYPE;

Line: 682

l_select_stat   varchar2(1000);

Line: 730

    l_select_stat := 'UPDATE jtf_task_references_b'
            ||         ' SET object_id = :1'
            ||           ' , object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_parties WHERE party_id = :3 )'
            ||           ' , 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'
            ||           ' , object_version_number = object_version_number + 1'
            ||       ' WHERE object_id = :4'
            ||         ' AND object_type_code = ''PARTY''';

Line: 741

if l_select_stat is not NULL then
-- Modified by SBARAT on 23/12/2005 for SQL Literal issue, bug# 4614088
    EXECUTE IMMEDIATE l_select_stat
            USING to_char(p_to_fk_id) ,
                  l_name ,
                  to_char(p_to_fk_id) ,
                  to_char(p_from_fk_id);

Line: 750

    fnd_message.set_name('JTF', 'JTF_TASK_DYNAMYC_SELECT');

Line: 785

select  merge_reason_code
from    hz_merge_batch
where   batch_id = p_batch_id;

Line: 799

select  select_name
from    jtf_objects_vl
where   object_code = 'SITE'
and nvl(start_date_active, sysdate) <= sysdate
and nvl(end_date_active, sysdate)   >= sysdate;

Line: 805

l_name      jtf_objects_vl.select_name%TYPE;

Line: 806

l_select_stat   varchar2(1000);

Line: 857

    l_select_stat := 'UPDATE jtf_task_references_b'
            ||         ' SET object_id = :1'
            ||           ' , object_name = (SELECT jtf_task_utl.check_truncation(:2) FROM hz_party_sites WHERE party_site_id = :3 )'
            ||           ' , 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'
            ||           ' , object_version_number = object_version_number + 1'
            ||       ' WHERE object_id = :4'
            ||         ' AND object_type_code = ''SITE''';

Line: 868

if l_select_stat is not NULL then
-- Modified by SBARAT on 23/12/2005 for SQL Literal issue, bug# 4614088
    EXECUTE IMMEDIATE l_select_stat
            USING to_char(p_to_fk_id) ,
                  l_name ,
                  to_char(p_to_fk_id) ,
                  to_char(p_from_fk_id);

Line: 876

    fnd_message.set_name('JTF', 'JTF_TASK_DYNAMYC_SELECT');

Line: 913

select  merge_reason_code
from    hz_merge_batch
where   batch_id = p_batch_id;

Line: 957

    UPDATE  jtf_tasks_b
    SET address_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,
        object_version_number = object_version_number + 1
    WHERE   --task_id = p_from_id
    --AND
          address_id = p_from_fk_id; -- just to make sure it is the right one

Line: 998

select  merge_reason_code
from    hz_merge_batch
where   batch_id = p_batch_id;

Line: 1042

    UPDATE  jtf_task_audits_b
    SET new_address_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,
        object_version_number = object_version_number + 1
    WHERE   --task_audit_id  = p_from_id
    --AND
        new_address_id = p_from_fk_id; -- just to make sure it is the right one

Line: 1083

select  merge_reason_code
from    hz_merge_batch
where   batch_id = p_batch_id;

Line: 1127

    UPDATE  jtf_task_audits_b
    SET old_address_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,
        object_version_number = object_version_number + 1
    WHERE   --task_audit_id  = p_from_id
    --AND
         old_address_id = p_from_fk_id; -- just to make sure it is the right one

Line: 1168

select  merge_reason_code
from    hz_merge_batch
where   batch_id = p_batch_id;

Line: 1211

    UPDATE  jtf_task_contacts
    SET contact_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,
        object_version_number = object_version_number + 1
    WHERE  --task_contact_id = p_from_id
        contact_type_code = 'CUST'
    AND contact_id = p_from_fk_id; --just to make sure it is the right one

Line: 1254

select  merge_reason_code
from    hz_merge_batch
where   batch_id = p_batch_id;

Line: 1296

    UPDATE  jtf_task_phones
    SET phone_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,
        object_version_number = object_version_number + 1
    WHERE   --task_phone_id = p_from_id
    --AND
        phone_id = p_from_fk_id; --just to make sure it is the right one

Line: 1340

select  merge_reason_code
from    hz_merge_batch
where   batch_id = p_batch_id;

Line: 1359

SELECT party_number
FROM hz_parties
WHERE party_id = p_to_fk_id;

Line: 1417

    UPDATE  jtf_perz_query_param
    -- Fix bug 3738509
        SET parameter_value  = l_customer_new_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
    WHERE   --query_param_id = l_query_customer_name_id
        query_param_id IN (SELECT param.query_param_id
                             FROM jtf_perz_query_param param
                                , (SELECT q.query_id
                                     FROM jtf_perz_query q
                                        , jtf_perz_query_param p
                                    WHERE q.query_type = 'JTF_TASK'
                                      AND q.application_id = 690
                                      AND p.query_id = q.query_id
                                      AND p.parameter_name = 'CUSTOMER'
                                      AND p.parameter_value = 'NUMBER') query
                            WHERE param.query_id = query.query_id
                              AND param.parameter_name = 'CUSTOMER_NAME'
                              AND EXISTS (SELECT 1
                                            FROM jtf_perz_query_param pm
                                           WHERE pm.query_id = param.query_id
                                             AND pm.parameter_name = 'CUSTOMER_ID'
                                             AND pm.parameter_value = to_char(p_from_fk_id))
                           );

Line: 1445

    UPDATE  jtf_perz_query_param p
    SET parameter_value  = to_char(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
    WHERE   --query_param_id = p_from_id
        query_param_id IN (SELECT param.query_param_id
                             FROM jtf_perz_query_param param
                                , (SELECT q.query_id
                                     FROM jtf_perz_query q
                                        , jtf_perz_query_param p
                                    WHERE q.query_type = 'JTF_TASK'
                                      AND q.application_id = 690
                                      AND p.query_id = q.query_id
                                      AND p.parameter_name = 'CUSTOMER'
                                      AND p.parameter_value = 'NUMBER') query
                            WHERE param.query_id = query.query_id
                              AND param.parameter_name = 'CUSTOMER_ID'
                              AND param.parameter_value = to_char(p_from_fk_id));

Line: 1500

select  merge_reason_code
from    hz_merge_batch
where   batch_id = p_batch_id;

Line: 1519

SELECT party_name
FROM hz_parties
WHERE party_id = p_to_fk_id;

Line: 1595

    UPDATE  jtf_perz_query_param
    SET parameter_value  = l_customer_new_name,
        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   --query_param_id = l_query_customer_name_id
        query_param_id IN (SELECT param.query_param_id
                             FROM jtf_perz_query_param param
                                , (SELECT q.query_id
                                     FROM jtf_perz_query q
                                        , jtf_perz_query_param p
                                    WHERE q.query_type = 'JTF_TASK'
                                      AND q.application_id = 690
                                      AND p.query_id = q.query_id
                                      AND p.parameter_name = 'CUSTOMER'
                                      AND p.parameter_value = 'NAME') query
                            WHERE param.query_id = query.query_id
                              AND param.parameter_name = 'CUSTOMER_NAME'
                              AND EXISTS (SELECT 1
                                            FROM jtf_perz_query_param pm
                                           WHERE pm.query_id = param.query_id
                                             AND pm.parameter_name = 'CUSTOMER_ID'
                                             AND pm.parameter_value = to_char(p_from_fk_id))
                           );

Line: 1622

    UPDATE  jtf_perz_query_param p
    SET parameter_value  = to_char(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
    WHERE   --query_param_id = p_from_id
        query_param_id IN (SELECT param.query_param_id
                             FROM jtf_perz_query_param param
                                , (SELECT q.query_id
                                     FROM jtf_perz_query q
                                        , jtf_perz_query_param p
                                    WHERE q.query_type = 'JTF_TASK'
                                      AND q.application_id = 690
                                      AND p.query_id = q.query_id
                                      AND p.parameter_name = 'CUSTOMER'
                                      AND p.parameter_value = 'NAME') query
                            WHERE param.query_id = query.query_id
                              AND param.parameter_name = 'CUSTOMER_ID'
                              AND param.parameter_value = to_char(p_from_fk_id));

Line: 1676

select  merge_reason_code
from    hz_merge_batch
where   batch_id = p_batch_id;

Line: 1681

SELECT party_type
  FROM hz_parties
 WHERE party_id = p_from_fk_id;

Line: 1723

   UPDATE jtf_task_assignments
      SET resource_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,
          object_version_number = object_version_number + 1
    WHERE resource_id = p_from_fk_id
      AND resource_type_code IN (SELECT object_code
                                  FROM jtf_objects_b
                                 WHERE LTRIM(RTRIM(UPPER(from_table))) = 'HZ_PARTIES'
                                   AND RTRIM(LTRIM(UPPER(select_id))) = 'PARTY_ID');