DBA Data[Home] [Help]

APPS.LNS_TERMS_PKG dependencies on LNS_TERMS_S

Line 150: DECODE( X_TERM_ID, FND_API.G_MISS_NUM, LNS_TERMS_S.NEXTVAL, NULL, LNS_TERMS_S.NEXTVAL, X_TERM_ID )

146: ,CAPITALIZE_INT
147: ,CALC_EARLY_PAY_CR
148: ,FLUCTUATE_EQ_PAY_AMOUNT
149: ) VALUES (
150: DECODE( X_TERM_ID, FND_API.G_MISS_NUM, LNS_TERMS_S.NEXTVAL, NULL, LNS_TERMS_S.NEXTVAL, X_TERM_ID )
151: ,DECODE( X_LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )
152: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
153: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
154: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

Line 308: UPDATE LNS_TERMS SET

304: p_primary_key_name => 'TERM_ID',
305: p_table_name => 'LNS_TERMS'
306: );
307:
308: UPDATE LNS_TERMS SET
309: TERM_ID = DECODE( X_TERM_ID, NULL, TERM_ID, FND_API.G_MISS_NUM, NULL, X_TERM_ID )
310: ,LOAN_ID = DECODE( X_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )
311: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
312: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY