DBA Data[Home] [Help]

PACKAGE: APPS.LNS_LOAN_COLLATERAL_PUB

Source


1 PACKAGE LNS_LOAN_COLLATERAL_PUB AS
2 /* $Header: LNS_LNCOL_PUBP_S.pls 120.0 2005/05/31 18:45:07 appldev noship $ */
3 
4 /*
5  This procedure is used to end-date collaterals pledged to a loan
6  upon certain status changes in the loan
7  If the collateral is acquired for the loan in question, then the asset
8  also gets end-dated
9 */
10 procedure Release_Collaterals(p_loan_id NUMBER);
11 
12 -- function used to check if any asset assignment exists for a specific asset
13 -- if so, disallow deletion of that asset
14 FUNCTION IS_EXIST_ASSET_ASSIGNMENT (
15     p_asset_id			 NUMBER
16 ) RETURN VARCHAR2;
17 
18 END LNS_LOAN_COLLATERAL_PUB;