[Home] [Help]
PACKAGE: APPS.LNS_OCM_ADP_PUB
Source
1 PACKAGE LNS_OCM_ADP_PUB AUTHID CURRENT_USER AS
2 /*$Header: LNS_ADP_PUBP_S.pls 120.0 2005/09/02 05:42:18 hikumar noship $ */
3
4
5 FUNCTION loan_request_amount(x_resultout OUT NOCOPY VARCHAR2,
6 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
7
8
9 FUNCTION is_secured_loan (x_resultout OUT NOCOPY VARCHAR2,
10 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
11
12
13 FUNCTION loan_collateral_percentage (x_resultout OUT NOCOPY VARCHAR2,
14 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
15
16
17 FUNCTION initial_intrest_rate (x_resultout OUT NOCOPY VARCHAR2,
18 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
19
20
21 FUNCTION number_of_coborrowers (x_resultout OUT NOCOPY VARCHAR2,
22 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
23
24 FUNCTION is_having_coborrowers (x_resultout OUT NOCOPY VARCHAR2,
25 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
26
27 FUNCTION number_of_guarantors (x_resultout OUT NOCOPY VARCHAR2,
28 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
29
30 FUNCTION is_having_guarantors (x_resultout OUT NOCOPY VARCHAR2,
31 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
32
33 FUNCTION required_collateral_amount (x_resultout OUT NOCOPY VARCHAR2,
34 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
35
36 FUNCTION total_collateral_amount (x_resultout OUT NOCOPY VARCHAR2,
37 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
38
39 FUNCTION deliquency_cond_amount (x_resultout OUT NOCOPY VARCHAR2,
40 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
41
42
43 FUNCTION total_assets_valuation_amt (x_resultout OUT NOCOPY VARCHAR2,
44 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
45
46 FUNCTION total_assets_pledged_amt (x_resultout OUT NOCOPY VARCHAR2,
47 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
48
49
50 FUNCTION total_assets_available_amt (x_resultout OUT NOCOPY VARCHAR2,
51 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
52
53
54 FUNCTION number_active_loans ( x_resultout OUT NOCOPY VARCHAR2,
55 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
56
57 FUNCTION balance_amt_active_loans ( x_resultout OUT NOCOPY VARCHAR2,
58 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
59
60 FUNCTION number_pending_loans ( x_resultout OUT NOCOPY VARCHAR2,
61 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
62
63 FUNCTION balance_amt_pending_loans ( x_resultout OUT NOCOPY VARCHAR2,
64 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
65
66 FUNCTION number_delinquent_loans ( x_resultout OUT NOCOPY VARCHAR2,
67 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
68
69 FUNCTION balance_amt_delinquent_loans ( x_resultout OUT NOCOPY VARCHAR2,
70 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
71
72 FUNCTION number_default_loans ( x_resultout OUT NOCOPY VARCHAR2,
73 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
74
75 FUNCTION balance_amt_default_loans ( x_resultout OUT NOCOPY VARCHAR2,
76 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
77
78
79 FUNCTION number_paidoff_loans ( x_resultout OUT NOCOPY VARCHAR2,
80 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
81
82 FUNCTION balance_amt_paidoff_loans ( x_resultout OUT NOCOPY VARCHAR2,
83 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
84
85
86 FUNCTION total_active_loans ( x_resultout OUT NOCOPY VARCHAR2,
87 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
88
89 FUNCTION total_bal_amt_active_loans ( x_resultout OUT NOCOPY VARCHAR2,
90 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
91
92 FUNCTION total_deliquent_loans ( x_resultout OUT NOCOPY VARCHAR2,
93 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
94
95 FUNCTION total_overdue_amt_active_loans ( x_resultout OUT NOCOPY VARCHAR2,
96 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
97
98 FUNCTION total_defaulted_loans ( x_resultout OUT NOCOPY VARCHAR2,
99 x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
100
101 END LNS_OCM_ADP_PUB ;