APPS.LNS_MERGE_PKG SQL Statements

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

Line: 141

    UPDATE LNS_LOAN_HEADERS_ALL
    SET PRIMARY_BORROWER_ID    = p_To_FK_id,
        last_update_date       = HZ_UTILITY_V2PUB.last_update_date,
        last_updated_by        = HZ_UTILITY_V2PUB.user_id,
        last_update_login      = HZ_UTILITY_V2PUB.last_update_login,
        request_id             = HZ_UTILITY_V2PUB.request_id,
        program_id             = HZ_UTILITY_V2PUB.program_id
    WHERE PRIMARY_BORROWER_ID = p_from_fk_id;

Line: 151

    UPDATE LNS_LOAN_HEADERS_ALL
    SET CONTACT_PERS_PARTY_ID  = p_To_FK_id,
        last_update_date       = HZ_UTILITY_V2PUB.last_update_date,
        last_updated_by        = HZ_UTILITY_V2PUB.user_id,
        last_update_login      = HZ_UTILITY_V2PUB.last_update_login,
        request_id             = HZ_UTILITY_V2PUB.request_id,
        program_id             = HZ_UTILITY_V2PUB.program_id
    WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;

Line: 161

    UPDATE LNS_LOAN_HEADERS_ALL
    SET CONTACT_REL_PARTY_ID   = p_To_FK_id,
        last_update_date       = HZ_UTILITY_V2PUB.last_update_date,
        last_updated_by        = HZ_UTILITY_V2PUB.user_id,
        last_update_login      = HZ_UTILITY_V2PUB.last_update_login,
        request_id             = HZ_UTILITY_V2PUB.request_id,
        program_id             = HZ_UTILITY_V2PUB.program_id
    WHERE CONTACT_REL_PARTY_ID = p_from_fk_id;

Line: 216

    UPDATE LNS_PARTICIPANTS
    SET HZ_PARTY_ID            = p_To_FK_id,
        last_update_date       = HZ_UTILITY_V2PUB.last_update_date,
        last_updated_by        = HZ_UTILITY_V2PUB.user_id,
        last_update_login      = HZ_UTILITY_V2PUB.last_update_login
    WHERE HZ_PARTY_ID = p_from_fk_id;

Line: 224

    UPDATE LNS_PARTICIPANTS
    SET CONTACT_PERS_PARTY_ID  = p_To_FK_id,
        last_update_date       = HZ_UTILITY_V2PUB.last_update_date,
        last_updated_by        = HZ_UTILITY_V2PUB.user_id,
        last_update_login      = HZ_UTILITY_V2PUB.last_update_login
    WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;

Line: 232

    UPDATE LNS_PARTICIPANTS
    SET CONTACT_REL_PARTY_ID   = p_To_FK_id,
        last_update_date       = HZ_UTILITY_V2PUB.last_update_date,
        last_updated_by        = HZ_UTILITY_V2PUB.user_id,
        last_update_login      = HZ_UTILITY_V2PUB.last_update_login
    WHERE CONTACT_REL_PARTY_ID = p_from_fk_id;

Line: 283

        SELECT distinct CUSTOMER_MERGE_HEADER_ID
              ,LOAN_ID
              ,CUST_ACCOUNT_ID
         FROM LNS_LOAN_HEADERS yt, ra_customer_merges m
         WHERE
            (yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID)
            AND    m.process_flag = 'N'
            AND    m.request_id = req_id
            AND    m.set_number = set_num;

Line: 294

        SELECT distinct CUSTOMER_MERGE_HEADER_ID
              ,LOAN_ID
              ,CUSTOMER_ADDRESS_ID
         FROM LNS_LOAN_HEADERS yt, ra_customer_merges m
         WHERE
            (yt.BILL_TO_ACCT_SITE_ID = m.DUPLICATE_ADDRESS_ID)
            AND    m.process_flag = 'N'
            AND    m.request_id = req_id
            AND    m.set_number = set_num;

Line: 352

	LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting into HZ_CUSTOMER_MERGE_LOG...');

Line: 355

         INSERT INTO HZ_CUSTOMER_MERGE_LOG (
            MERGE_LOG_ID,
            TABLE_NAME,
            MERGE_HEADER_ID,
            PRIMARY_KEY_ID1,
            NUM_COL1_ORIG,
            NUM_COL1_NEW,
            ACTION_FLAG,
            REQUEST_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATE_LOGIN,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY)
         VALUES
            (HZ_CUSTOMER_MERGE_LOG_s.nextval,
            'LNS_LOAN_HEADERS',
            MERGE_HEADER_ID_LIST(I),
            PRIMARY_KEY_ID1_LIST(I),
            NUM_COL1_ORIG_LIST(I),
            NUM_COL1_NEW_LIST(I),
            'U',
            req_id,
            hz_utility_pub.CREATED_BY,
            hz_utility_pub.CREATION_DATE,
            hz_utility_pub.LAST_UPDATE_LOGIN,
            hz_utility_pub.LAST_UPDATE_DATE,
            hz_utility_pub.LAST_UPDATED_BY);

Line: 386

      LogMessage(FND_LOG.LEVEL_STATEMENT,'Insertion Completed');

Line: 391

      UPDATE LNS_LOAN_HEADERS yt SET
           CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
          , LAST_UPDATE_DATE=SYSDATE
          , last_updated_by=arp_standard.profile.user_id
          , last_update_login=arp_standard.profile.last_update_login
          , REQUEST_ID=req_id
          , PROGRAM_ID=arp_standard.profile.program_id
      WHERE LOAN_ID=PRIMARY_KEY_ID1_LIST(I);

Line: 410

    arp_message.set_name('AR','AR_ROWS_UPDATED');

Line: 416

    MERGE_HEADER_ID_LIST.delete;

Line: 417

    PRIMARY_KEY_ID1_LIST.delete;

Line: 446

	LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting CustActSites into HZ_CUSTOMER_MERGE_LOG...');

Line: 449

         INSERT INTO HZ_CUSTOMER_MERGE_LOG (
            MERGE_LOG_ID,
            TABLE_NAME,
            MERGE_HEADER_ID,
            PRIMARY_KEY_ID1,
            NUM_COL1_ORIG,
            NUM_COL1_NEW,
            ACTION_FLAG,
            REQUEST_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATE_LOGIN,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY)
         VALUES
            (HZ_CUSTOMER_MERGE_LOG_s.nextval,
            'LNS_LOAN_HEADERS',
            MERGE_HEADER_ID_LIST(I),
            PRIMARY_KEY_ID1_LIST(I),
            NUM_COL2_ORIG_LIST(I),
            NUM_COL2_NEW_LIST(I),
            'U',
            req_id,
            hz_utility_pub.CREATED_BY,
            hz_utility_pub.CREATION_DATE,
            hz_utility_pub.LAST_UPDATE_LOGIN,
            hz_utility_pub.LAST_UPDATE_DATE,
            hz_utility_pub.LAST_UPDATED_BY);

Line: 480

      LogMessage(FND_LOG.LEVEL_STATEMENT,'Insertion of custAcctSites Completed');

Line: 485

      UPDATE LNS_LOAN_HEADERS yt SET
           BILL_TO_ACCT_SITE_ID=NUM_COL2_NEW_LIST(I)
          , LAST_UPDATE_DATE=SYSDATE
          , last_updated_by=arp_standard.profile.user_id
          , last_update_login=arp_standard.profile.last_update_login
          , REQUEST_ID=req_id
          , PROGRAM_ID=arp_standard.profile.program_id
      WHERE LOAN_ID=PRIMARY_KEY_ID1_LIST(I);

Line: 504

    arp_message.set_name('AR','AR_ROWS_UPDATED');

Line: 550

        SELECT distinct CUSTOMER_MERGE_HEADER_ID
              ,PARTICIPANT_ID
              ,CUST_ACCOUNT_ID
         FROM LNS_PARTICIPANTS yt, ra_customer_merges m
         WHERE (
            yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
         ) AND    m.process_flag = 'N'
         AND    m.request_id = req_id
         AND    m.set_number = set_num;

Line: 561

        SELECT distinct CUSTOMER_MERGE_HEADER_ID
              ,PARTICIPANT_ID
              ,CUSTOMER_ADDRESS_ID
         FROM LNS_PARTICIPANTS yt, ra_customer_merges m
         WHERE
            (yt.BILL_TO_ACCT_SITE_ID = m.DUPLICATE_ADDRESS_ID)
            AND    m.process_flag = 'N'
            AND    m.request_id = req_id
            AND    m.set_number = set_num;

Line: 617

	LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting into HZ_CUSTOMER_MERGE_LOG...');

Line: 620

         INSERT INTO HZ_CUSTOMER_MERGE_LOG (
           MERGE_LOG_ID,
           TABLE_NAME,
           MERGE_HEADER_ID,
           PRIMARY_KEY_ID1,
           NUM_COL1_ORIG,
           NUM_COL1_NEW,
           ACTION_FLAG,
           REQUEST_ID,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATE_LOGIN,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY
          ) VALUES (
            HZ_CUSTOMER_MERGE_LOG_s.nextval,
            'LNS_PARTICIPANTS',
            MERGE_HEADER_ID_LIST(I),
            PRIMARY_KEY_ID1_LIST(I),
            NUM_COL1_ORIG_LIST(I),
            NUM_COL1_NEW_LIST(I),
            'U',
            req_id,
            hz_utility_pub.CREATED_BY,
            hz_utility_pub.CREATION_DATE,
            hz_utility_pub.LAST_UPDATE_LOGIN,
            hz_utility_pub.LAST_UPDATE_DATE,
            hz_utility_pub.LAST_UPDATED_BY
          );

Line: 652

      LogMessage(FND_LOG.LEVEL_STATEMENT,'Insertion Completed');

Line: 658

      UPDATE LNS_PARTICIPANTS yt SET
           CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
          , LAST_UPDATE_DATE=SYSDATE
          , last_updated_by=arp_standard.profile.user_id
          , last_update_login=arp_standard.profile.last_update_login
      WHERE PARTICIPANT_ID=PRIMARY_KEY_ID1_LIST(I);

Line: 675

    arp_message.set_name('AR','AR_ROWS_UPDATED');

Line: 682

    MERGE_HEADER_ID_LIST.delete;

Line: 683

    PRIMARY_KEY_ID1_LIST.delete;

Line: 712

	LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting CustActSites into HZ_CUSTOMER_MERGE_LOG...');

Line: 715

         INSERT INTO HZ_CUSTOMER_MERGE_LOG (
            MERGE_LOG_ID,
            TABLE_NAME,
            MERGE_HEADER_ID,
            PRIMARY_KEY_ID1,
            NUM_COL1_ORIG,
            NUM_COL1_NEW,
            ACTION_FLAG,
            REQUEST_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATE_LOGIN,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY)
         VALUES
            (HZ_CUSTOMER_MERGE_LOG_s.nextval,
            'LNS_PARTICIPANTS',
            MERGE_HEADER_ID_LIST(I),
            PRIMARY_KEY_ID1_LIST(I),
            NUM_COL2_ORIG_LIST(I),
            NUM_COL2_NEW_LIST(I),
            'U',
            req_id,
            hz_utility_pub.CREATED_BY,
            hz_utility_pub.CREATION_DATE,
            hz_utility_pub.LAST_UPDATE_LOGIN,
            hz_utility_pub.LAST_UPDATE_DATE,
            hz_utility_pub.LAST_UPDATED_BY);

Line: 746

      LogMessage(FND_LOG.LEVEL_STATEMENT,'Insertion of custAcctSites Completed');

Line: 751

      UPDATE LNS_PARTICIPANTS yt SET
           BILL_TO_ACCT_SITE_ID=NUM_COL2_NEW_LIST(I)
          , LAST_UPDATE_DATE=SYSDATE
          , last_updated_by=arp_standard.profile.user_id
          , last_update_login=arp_standard.profile.last_update_login
      WHERE PARTICIPANT_ID=PRIMARY_KEY_ID1_LIST(I);

Line: 768

    arp_message.set_name('AR','AR_ROWS_UPDATED');