DBA Data[Home] [Help]

APPS.LNS_TERMS_PKG dependencies on LNS_TERMS_S

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

130: ,PRIN_PAYMENT_FREQUENCY
131: ,PENAL_INT_RATE
132: ,PENAL_INT_GRACE_DAYS
133: ) VALUES (
134: DECODE( X_TERM_ID, FND_API.G_MISS_NUM, LNS_TERMS_S.NEXTVAL, NULL, LNS_TERMS_S.NEXTVAL, X_TERM_ID )
135: ,DECODE( X_LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )
136: ,LNS_UTILITY_PUB.LAST_UPDATE_DATE
137: ,LNS_UTILITY_PUB.LAST_UPDATED_BY
138: ,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

Line 276: UPDATE LNS_TERMS SET

272: p_primary_key_name => 'TERM_ID',
273: p_table_name => 'LNS_TERMS'
274: );
275:
276: UPDATE LNS_TERMS SET
277: TERM_ID = DECODE( X_TERM_ID, NULL, TERM_ID, FND_API.G_MISS_NUM, NULL, X_TERM_ID )
278: ,LOAN_ID = DECODE( X_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )
279: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
280: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY