APPS.LNS_MERGE_PKG SQL Statements

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

Line: 38

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

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

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

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

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

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

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

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

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

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

Line: 301

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

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

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

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