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;