eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_APPROVAL_ACTION_PUB SQL Statements

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

Line: 36


PROCEDURE do_update_approval_action (
    p_approval_action_rec    IN OUT NOCOPY APPROVAL_ACTION_REC_TYPE
   ,p_object_version_number  IN OUT NOCOPY NUMBER
   ,x_return_status          IN OUT NOCOPY VARCHAR2
);

Line: 42


PROCEDURE do_delete_approval_action (
    p_action_id        IN NUMBER
   ,x_return_status    IN OUT NOCOPY VARCHAR2
);

Line: 95


            SELECT 'Y'
            INTO   l_dummy
            FROM   LNS_APPROVAL_ACTIONS
            WHERE  action_id = l_action_id;

Line: 111


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Insert_Row');

Line: 114


    LNS_APPROVAL_ACTIONS_PKG.Insert_Row(X_ACTION_ID		          => p_approval_action_rec.action_id
																			 ,P_OBJECT_VERSION_NUMBER	=> 1
																			 ,P_LOAN_ID               => p_approval_action_rec.loan_id
																			 ,P_ACTION_TYPE           => p_approval_action_rec.action_type
																			 ,P_AMOUNT                => p_approval_action_rec.amount
																			 ,P_REASON_CODE           => p_approval_action_rec.reason_code
																			 ,P_ATTRIBUTE_CATEGORY    => p_approval_action_rec.attribute_category
																			 ,P_ATTRIBUTE1						=> p_approval_action_rec.attribute1
																			 ,P_ATTRIBUTE2						=> p_approval_action_rec.attribute2
																			 ,P_ATTRIBUTE3						=> p_approval_action_rec.attribute3
																			 ,P_ATTRIBUTE4						=> p_approval_action_rec.attribute4
																			 ,P_ATTRIBUTE5						=> p_approval_action_rec.attribute5
																			 ,P_ATTRIBUTE6						=> p_approval_action_rec.attribute6
																			 ,P_ATTRIBUTE7						=> p_approval_action_rec.attribute7
																			 ,P_ATTRIBUTE8						=> p_approval_action_rec.attribute8
																			 ,P_ATTRIBUTE9						=> p_approval_action_rec.attribute9
																			 ,P_ATTRIBUTE10						=> p_approval_action_rec.attribute10
																			 ,P_ATTRIBUTE11						=> p_approval_action_rec.attribute11
																			 ,P_ATTRIBUTE12						=> p_approval_action_rec.attribute12
																			 ,P_ATTRIBUTE13						=> p_approval_action_rec.attribute13
																			 ,P_ATTRIBUTE14						=> p_approval_action_rec.attribute14
																			 ,P_ATTRIBUTE15						=> p_approval_action_rec.attribute15
																			 ,P_ATTRIBUTE16						=> p_approval_action_rec.attribute16
																			 ,P_ATTRIBUTE17						=> p_approval_action_rec.attribute17
																			 ,P_ATTRIBUTE18						=> p_approval_action_rec.attribute18
																			 ,P_ATTRIBUTE19						=> p_approval_action_rec.attribute19
																			 ,P_ATTRIBUTE20						=> p_approval_action_rec.attribute20);

Line: 144


	  logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_approval_action procedure: After call to LNS_APPROVAL_ACTION.Insert_Row');

Line: 150


 |              do_update_approval_action
 |
 | DESCRIPTION
 |              Updates approval action.
 |
 | SCOPE - PRIVATE
 |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
 |
 | ARGUMENTS  : IN:
 |              OUT:
 |              IN/OUT:
 |                    p_approval_action_rec
 |		      p_object_version_number
 |                    x_return_status
 |
 | RETURNS    : NONE
 |
 | NOTES
 |
 | MODIFICATION HISTORY
 |
 |   22-Jan-2004     Bernice Lam       Created.
 +===========================================================================*/

PROCEDURE do_update_approval_action(
     p_approval_action_rec     IN OUT NOCOPY APPROVAL_ACTION_REC_TYPE
    ,p_object_version_number   IN OUT NOCOPY NUMBER
    ,x_return_status           IN OUT NOCOPY VARCHAR2) IS

    l_object_version_number         NUMBER;

Line: 186


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_update_approval_action procedure');

Line: 190


        SELECT OBJECT_VERSION_NUMBER,
               ROWID
        INTO   l_object_version_number,
               l_rowid
        FROM   LNS_APPROVAL_ACTIONS
        WHERE  ACTION_ID = p_approval_action_rec.action_id
        FOR UPDATE OF ACTION_ID NOWAIT;

Line: 224


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Update_Row');

Line: 232


    LNS_APPROVAL_ACTIONS_PKG.Update_Row (X_ACTION_ID		          => p_approval_action_rec.action_id
																			  ,P_OBJECT_VERSION_NUMBER	=> p_OBJECT_VERSION_NUMBER
                                        ,P_LOAN_ID                => p_approval_action_rec.LOAN_ID
                                        ,P_ACTION_TYPE            => p_approval_action_rec.ACTION_TYPE
                                        ,P_AMOUNT                 => p_approval_action_rec.AMOUNT
                                        ,P_REASON_CODE            => p_approval_action_rec.REASON_CODE
                                        ,P_ATTRIBUTE_CATEGORY     => p_approval_action_rec.attribute_category
                                        ,P_ATTRIBUTE1             => p_approval_action_rec.attribute1
                                        ,P_ATTRIBUTE2             => p_approval_action_rec.attribute2
                                        ,P_ATTRIBUTE3             => p_approval_action_rec.attribute3
                                        ,P_ATTRIBUTE4             => p_approval_action_rec.attribute4
                                        ,P_ATTRIBUTE5             => p_approval_action_rec.attribute5
                                        ,P_ATTRIBUTE6             => p_approval_action_rec.attribute6
                                        ,P_ATTRIBUTE7             => p_approval_action_rec.attribute7
                                        ,P_ATTRIBUTE8             => p_approval_action_rec.attribute8
                                        ,P_ATTRIBUTE9             => p_approval_action_rec.attribute9
                                        ,P_ATTRIBUTE10            => p_approval_action_rec.attribute10
                                        ,P_ATTRIBUTE11            => p_approval_action_rec.attribute11
                                        ,P_ATTRIBUTE12            => p_approval_action_rec.attribute12
                                        ,P_ATTRIBUTE13            => p_approval_action_rec.attribute13
                                        ,P_ATTRIBUTE14            => p_approval_action_rec.attribute14
                                        ,P_ATTRIBUTE15            => p_approval_action_rec.attribute15
                                        ,P_ATTRIBUTE16            => p_approval_action_rec.attribute16
                                        ,P_ATTRIBUTE17            => p_approval_action_rec.attribute17
                                        ,P_ATTRIBUTE18            => p_approval_action_rec.attribute18
                                        ,P_ATTRIBUTE19            => p_approval_action_rec.attribute19
                                        ,P_ATTRIBUTE20            => p_approval_action_rec.attribute20);

Line: 267


      logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_update_approval_action procedure: After call to LNS_APPROVAL_ACTIONS_PKG.Update_Row');

Line: 269


END do_update_approval_action;

Line: 273


 |              do_delete_approval_action
 |
 | DESCRIPTION
 |              Deletes approval action.
 |
 | SCOPE - PRIVATE
 |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
 |
 | ARGUMENTS  : IN:
 |              OUT:
 |              IN/OUT:
 |                    p_action_id
 |		      p_object_version_number
 |                    x_return_status
 |
 | RETURNS    : NONE
 |
 | NOTES
 |
 | MODIFICATION HISTORY
 |
 |   22-Jan-2004     Bernice Lam       Created.
 +===========================================================================*/

PROCEDURE do_delete_approval_action(
    p_action_id           NUMBER,
    x_return_status           IN OUT NOCOPY VARCHAR2
) IS

    l_dummy                 VARCHAR2(1);

Line: 306


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_delete_approval_action procedure');

Line: 313


        SELECT 'Y'
        INTO   l_dummy
        FROM   LNS_APPROVAL_ACTIONS
        WHERE  ACTION_ID = p_action_id;

Line: 328


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_approval_action procedure: Before call to LNS_APPROVAL_ACTIONS_PKG.Delete_Row');

Line: 331


    LNS_APPROVAL_ACTIONS_PKG.Delete_Row (P_ACTION_ID  => p_action_id);

Line: 333


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_delete_approval_action procedure: After call to LNS_APPROVAL_ACTIONS_PKG.Delete_Row');

Line: 335


END do_delete_approval_action;

Line: 344


	SELECT 'X'
	FROM LNS_FEE_ASSIGNMENTS
	WHERE loan_id = X_LOAN_ID
	AND end_installment_number > x_install_num;

Line: 459


    SELECT H.OBJECT_VERSION_NUMBER
          ,H.LOAN_STATUS
          ,H.LOAN_CURRENCY
          ,H.LOAN_NUMBER
          ,H.LOAN_CLASS_CODE
          ,H.LOAN_TYPE
          ,H.GL_DATE
          ,H.REQUESTED_AMOUNT
          ,H.REFERENCE_TYPE
          ,H.REFERENCE_ID
          ,H.CURRENT_PHASE
          ,H.MULTIPLE_FUNDING_FLAG
          ,H.OPEN_TO_TERM_FLAG
          ,NVL(P.BDGT_REQ_FOR_APPR_FLAG, 'N') BDGT_REQ_FOR_APPR_FLAG
          ,NVL(P.LOAN_APPR_REQ_FLAG, 'Y') LOAN_APPR_REQ_FLAG
		  ,H.SECONDARY_STATUS
          ,nvl(custom_payments_flag, 'N')
    FROM LNS_LOAN_HEADERS_ALL H,
	LNS_LOAN_PRODUCTS_ALL P
    WHERE H.LOAN_ID = X_Loan_Id
      and H.product_id = P.loan_product_id(+);

Line: 482


    SELECT RESOURCE_ID
      FROM JTF_RS_RESOURCE_EXTNS
     WHERE USER_ID = X_USER_ID;

Line: 487


    select DISTRIBUTION_ID
          ,CODE_COMBINATION_ID
          ,DISTRIBUTION_PERCENT
      from lns_distributions
     where LOAN_ID = x_loan_id
       and account_type = x_acct_type
       and account_name = x_acct_name
       and line_type = x_line_type
       and distribution_type = 'ORIGINATION';

Line: 498


    select so.set_of_books_id
      from lns_system_options sb,
           gl_sets_of_books so
     where sb.set_of_books_id = so.set_of_books_id;

Line: 505


        select TERM_ID
              ,OBJECT_VERSION_NUMBER
        from LNS_TERMS
        where LOAN_ID = P_LOAN_ID;

Line: 511


    select OBJECT_VERSION_NUMBER
      from LNS_LOAN_HEADERS
     where LOAN_ID = P_LOAN_ID;

Line: 517


        select old_value
        from lns_loan_histories_h
        where table_name = 'LNS_LOAN_HEADERS_ALL' and
            column_name = 'SECONDARY_STATUS' and
            new_value = 'PENDING_CANCELLATION' and
            loan_id = P_LOAN_ID and
            loan_history_id =
                (select max(loan_history_id)
                from lns_loan_histories_h
                where table_name = 'LNS_LOAN_HEADERS_ALL' and
                column_name = 'SECONDARY_STATUS' and
                loan_id = P_LOAN_ID);

Line: 554


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to LNS_LOAN_HEADER_PUB.update_loan proc');

Line: 724


            /* setting term data for do term update */
            l_term_rec.TERM_ID := l_TERM_ID;

Line: 736


            LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_TERM_VERSION_NUMBER
	                                   ,p_init_msg_list 				=> FND_API.G_FALSE
	                                   ,p_loan_term_rec 				=> l_term_rec
	                                   ,X_RETURN_STATUS 				=> x_return_status
	                                   ,X_MSG_COUNT 						=> x_msg_count
	                                   ,X_MSG_DATA 							=> x_msg_data);

Line: 746


                logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully update LNS_TERMS');

Line: 750


                logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - LNS_TERMS_PUB.update_term failed with message: ' || FND_MSG_PUB.Get(p_encoded => 'F'));

Line: 751


                l_last_api_called := 'LNS_TERMS_PUB.update_term';

Line: 755


            /* setting data for future loan update */
            l_loan_header_rec.LOAN_START_DATE       := l_loan_details.loan_start_date;

Line: 763


            logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Data to Update loan header with during conversion...');

Line: 937


                select term_id, object_version_number into l_term_id, l_object_version_number
                from lns_terms
                where loan_id = l_loan_header_rec.loan_id;

Line: 950


                LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_object_version_number,
                                        p_init_msg_list => FND_API.G_FALSE,
                                        p_loan_term_rec => l_term_rec,
                                        X_RETURN_STATUS => x_return_status,
                                        X_MSG_COUNT => x_msg_count,
                                        X_MSG_DATA => x_msg_data);

Line: 962


                    logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_TERMS');

Line: 1010


        logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before call to LNS_LOAN_HEADER_PUB.update_loan');

Line: 1011


        LNS_LOAN_HEADER_PUB.update_loan(p_init_msg_list         => FND_API.G_FALSE
                                       ,p_loan_header_rec       => l_loan_header_rec
                                       ,p_object_version_number => l_object_version_number
                                       ,x_return_status         => x_return_status
                                       ,x_msg_count             => x_msg_count
                                       ,x_msg_data              => x_msg_data);

Line: 1017


        logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'After call to LNS_LOAN_HEADER_PUB.update_loan');

Line: 1020


            logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_LOAN_HEADER_PUB.update_loan failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));

Line: 1021


            l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';

Line: 1024


        logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to LNS_LOAN_HEADER_PUB.update_loan proc');

Line: 1035


            SELECT
              lower(iso_language),iso_territory
            INTO
              l_iso_language,l_iso_territory
            FROM
              FND_LANGUAGES
            WHERE
              language_code = USERENV('LANG');

Line: 1116


 |              update_approval_action
 |
 | DESCRIPTION
 |              Updates approval action.
 |
 | SCOPE - PUBLIC
 |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
 |
 | ARGUMENTS  : IN:
 |                    p_init_msg_list
 |                    p_approval_action_rec
 |              OUT:
 |                    x_return_status
 |                    x_msg_count
 |                    x_msg_data
 |              IN/OUT:
 |		      p_object_version_number
 |
 | RETURNS    : NONE
 |
 | NOTES
 |
 | MODIFICATION HISTORY
 |   22-Jan-2004     Bernice Lam		Created
 +===========================================================================*/

PROCEDURE update_approval_action (
    p_init_msg_list         IN      VARCHAR2,
    p_approval_action_rec        IN      APPROVAL_ACTION_REC_TYPE,
    p_object_version_number IN OUT NOCOPY  NUMBER,
    x_return_status         OUT NOCOPY     VARCHAR2,
    x_msg_count             OUT NOCOPY     NUMBER,
    x_msg_data              OUT NOCOPY     VARCHAR2
) IS

    l_api_name            CONSTANT VARCHAR2(30) := 'update_approval_action';

Line: 1157


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Update_approval_action procedure');

Line: 1160


    SAVEPOINT update_approval_action;

Line: 1184


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_approval_action procedure: Before call to do_update_approval_action proc');

Line: 1187


    do_update_approval_action(
                   l_approval_action_rec,
                   p_object_version_number,
                   x_return_status);

Line: 1192


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Update_approval_action procedure: After call to do_update_approval_action proc');

Line: 1196


        ROLLBACK TO update_approval_action;

Line: 1203


        ROLLBACK TO update_approval_action;

Line: 1210


        ROLLBACK TO update_approval_action;

Line: 1219


      logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Update_approval_action procedure');

Line: 1221


END update_approval_action;

Line: 1225


 |              delete_approval_action
 |
 | DESCRIPTION
 |              Deletes approval action
 |
 | SCOPE - PUBLIC
 |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
 |
 | ARGUMENTS  : IN:
 |                    p_init_msg_list
 |                    p_action_id
 |              OUT:
 |                    x_return_status
 |                    x_msg_count
 |                    x_msg_data
 |              IN/OUT:
 |
 | RETURNS    : NONE
 |
 | NOTES
 |
 | MODIFICATION HISTORY
 |   06-Jan-2004     Bernice Lam       Created.
 +===========================================================================*/

PROCEDURE delete_approval_action (
    p_init_msg_list   IN      VARCHAR2,
    p_action_id         IN     NUMBER,
    x_return_status   OUT NOCOPY     VARCHAR2,
    x_msg_count       OUT NOCOPY     NUMBER,
    x_msg_data        OUT NOCOPY     VARCHAR2
) IS

    l_api_name        CONSTANT VARCHAR2(30) := 'delete_approval_action';

Line: 1264


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin Delete_approval_action procedure');

Line: 1267


    SAVEPOINT delete_approval_action;

Line: 1277


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Delete_approval_action procedure: Before call to do_delete_approval_action proc');

Line: 1280


    do_delete_approval_action(
                   l_action_id,
                   x_return_status);

Line: 1284


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In Delete_approval_action procedure: After call to do_delete_approval_action proc');

Line: 1288


        ROLLBACK TO delete_approval_action;

Line: 1295


        ROLLBACK TO delete_approval_action;

Line: 1302


        ROLLBACK TO delete_approval_action;

Line: 1311


        logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Delete_approval_action procedure');

Line: 1313


END delete_approval_action;