APPS.LNS_PAYOFF_PUB dependencies on LNS_LOAN_CANCELLATIONS_S

Line 2394: select LNS_LOAN_CANCELLATIONS_S.NEXTVAL into p_LOAN_CANCELLATION_ID from dual;

2390: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_description = ' || l_description);
2391:
2392: if p_action = 'INSERT' then
2393: if p_LOAN_CANCELLATION_ID is null then
2394: select LNS_LOAN_CANCELLATIONS_S.NEXTVAL into p_LOAN_CANCELLATION_ID from dual;
2395: end if;
2396:
2397: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Inserting into LNS_LOAN_CANCELLATIONS...');
2398: insert into LNS_LOAN_CANCELLATIONS

Line 2429: update LNS_LOAN_CANCELLATIONS set

2425: ,lns_utility_pub.LAST_UPDATE_LOGIN);
2426: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
2427: else
2428: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating into LNS_LOAN_CANCELLATIONS...');
2429: update LNS_LOAN_CANCELLATIONS set
2430: DESCRIPTION = l_description
2431: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
2432: ,LAST_UPDATE_DATE = sysdate
2433: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

Line 3097: update LNS_LOAN_CANCELLATIONS set

3093: end loop;
3094:
3095: -- update cancellation record
3096: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');
3097: update LNS_LOAN_CANCELLATIONS set
3098: STATUS = 'APPROVED'
3099: ,APPR_REJECT_DATE = sysdate
3100: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID
3101: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1

Line 3226: update LNS_LOAN_CANCELLATIONS set

3222: ,p_action => 'REJECT');
3223:
3224: -- update cancellation record
3225: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCELLATIONS...');
3226: update LNS_LOAN_CANCELLATIONS set
3227: STATUS = 'REJECTED'
3228: ,APPR_REJECT_DATE = sysdate
3229: ,APPR_REJECT_BY = LNS_UTILITY_PUB.USER_ID
3230: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1