[Home] [Help]
PACKAGE: APPS.LNS_LOAN_HEADER_PUB
Source
1 PACKAGE LNS_LOAN_HEADER_PUB AS
2 /*$Header: LNS_LNHDR_PUBP_S.pls 120.8.12010000.2 2008/11/17 13:12:47 mbolli ship $ */
3
4 TYPE loan_header_rec_type IS RECORD(
5 LOAN_ID NUMBER,
6 ORG_ID NUMBER,
7 LOAN_NUMBER VARCHAR2(60),
8 LOAN_DESCRIPTION VARCHAR2(250),
9 LOAN_APPLICATION_DATE DATE,
10 END_DATE DATE,
11 INITIAL_LOAN_BALANCE NUMBER,
12 LAST_PAYMENT_DATE DATE,
13 LAST_PAYMENT_AMOUNT NUMBER,
14 LOAN_TERM NUMBER,
15 LOAN_TERM_PERIOD VARCHAR2(30),
16 AMORTIZED_TERM NUMBER,
17 AMORTIZED_TERM_PERIOD VARCHAR2(30),
18 LOAN_STATUS VARCHAR2(30),
19 LOAN_ASSIGNED_TO NUMBER,
20 LOAN_CURRENCY VARCHAR2(15),
21 LOAN_CLASS_CODE VARCHAR2(30),
22 LOAN_TYPE VARCHAR2(30),
23 LOAN_SUBTYPE VARCHAR2(30),
24 LOAN_PURPOSE_CODE VARCHAR2(30),
25 CUST_ACCOUNT_ID NUMBER,
26 BILL_TO_ACCT_SITE_ID NUMBER,
27 LOAN_MATURITY_DATE DATE,
28 LOAN_START_DATE DATE,
29 LOAN_CLOSING_DATE DATE,
30 REFERENCE_ID NUMBER,
31 REFERENCE_NUMBER VARCHAR2(60),
32 REFERENCE_DESCRIPTION VARCHAR2(250),
33 REFERENCE_AMOUNT NUMBER,
34 PRODUCT_FLAG VARCHAR2(1),
35 PRIMARY_BORROWER_ID NUMBER,
36 PRODUCT_ID NUMBER,
37 REQUESTED_AMOUNT NUMBER,
38 FUNDED_AMOUNT NUMBER,
39 LOAN_APPROVAL_DATE DATE,
40 LOAN_APPROVED_BY NUMBER,
41 ATTRIBUTE_CATEGORY VARCHAR2(30),
42 ATTRIBUTE1 VARCHAR2(150),
43 ATTRIBUTE2 VARCHAR2(150),
44 ATTRIBUTE3 VARCHAR2(150),
45 ATTRIBUTE4 VARCHAR2(150),
46 ATTRIBUTE5 VARCHAR2(150),
47 ATTRIBUTE6 VARCHAR2(150),
48 ATTRIBUTE7 VARCHAR2(150),
49 ATTRIBUTE8 VARCHAR2(150),
50 ATTRIBUTE9 VARCHAR2(150),
51 ATTRIBUTE10 VARCHAR2(150),
52 ATTRIBUTE11 VARCHAR2(150),
53 ATTRIBUTE12 VARCHAR2(150),
54 ATTRIBUTE13 VARCHAR2(150),
55 ATTRIBUTE14 VARCHAR2(150),
56 ATTRIBUTE15 VARCHAR2(150),
57 ATTRIBUTE16 VARCHAR2(150),
58 ATTRIBUTE17 VARCHAR2(150),
59 ATTRIBUTE18 VARCHAR2(150),
60 ATTRIBUTE19 VARCHAR2(150),
61 ATTRIBUTE20 VARCHAR2(150),
62 LAST_BILLED_DATE DATE,
63 CUSTOM_PAYMENTS_FLAG VARCHAR2(1),
64 BILLED_FLAG VARCHAR2(1),
65 REFERENCE_NAME VARCHAR2(60),
66 REFERENCE_TYPE VARCHAR2(30),
67 REFERENCE_TYPE_ID NUMBER,
68 USSGL_TRANSACTION_CODE VARCHAR2(30),
69 GL_DATE DATE,
70 REC_ADJUSTMENT_NUMBER VARCHAR2(20),
71 CONTACT_REL_PARTY_ID NUMBER,
72 CONTACT_PERS_PARTY_ID NUMBER,
73 CREDIT_REVIEW_FLAG VARCHAR2(1),
74 EXCHANGE_RATE_TYPE VARCHAR2(30),
75 EXCHANGE_DATE DATE,
76 EXCHANGE_RATE NUMBER,
77 COLLATERAL_PERCENT NUMBER,
78 LAST_PAYMENT_NUMBER NUMBER,
79 LAST_AMORTIZATION_ID NUMBER,
80 LEGAL_ENTITY_ID NUMBER,
81 OPEN_TO_TERM_FLAG VARCHAR2(1),
82 MULTIPLE_FUNDING_FLAG VARCHAR2(1),
83 LOAN_TYPE_ID NUMBER,
84 SECONDARY_STATUS VARCHAR2(30),
85 OPEN_TO_TERM_EVENT VARCHAR2(30),
86 BALLOON_PAYMENT_TYPE VARCHAR2(30),
87 BALLOON_PAYMENT_AMOUNT NUMBER,
88 CURRENT_PHASE VARCHAR2(30),
89 OPEN_LOAN_START_DATE DATE,
90 OPEN_LOAN_TERM NUMBER,
91 OPEN_LOAN_TERM_PERIOD VARCHAR2(30),
92 OPEN_MATURITY_DATE DATE,
93 FUNDS_RESERVED_FLAG VARCHAR2(1),
94 FUNDS_CHECK_DATE DATE,
95 SUBSIDY_RATE NUMBER,
96 APPLICATION_ID NUMBER,
97 CREATED_BY_MODULE VARCHAR2(150),
98 PARTY_TYPE VARCHAR2(30),
99 FORGIVENESS_FLAG VARCHAR2(1),
100 FORGIVENESS_PERCENT NUMBER
101 );
102 -------------------------------------------------------------------------
103
104 PROCEDURE create_loan (
105 p_init_msg_list IN VARCHAR2,
106 p_loan_header_rec IN LOAN_HEADER_REC_TYPE,
107 x_loan_id OUT NOCOPY NUMBER,
108 x_loan_number OUT NOCOPY VARCHAR2,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2
112 );
113
114 PROCEDURE update_loan (
115 p_init_msg_list IN VARCHAR2,
116 p_loan_header_rec IN LOAN_HEADER_REC_TYPE,
117 p_object_version_number IN OUT NOCOPY NUMBER,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2
121 );
122
123 PROCEDURE validate_loan (
124 p_init_msg_list IN VARCHAR2,
125 p_loan_header_rec IN LOAN_HEADER_REC_TYPE,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2
129 );
130
131 PROCEDURE get_loan_header_rec (
132 p_init_msg_list IN VARCHAR2,
133 p_loan_id IN NUMBER,
134 x_loan_header_rec OUT NOCOPY LOAN_HEADER_REC_TYPE,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2
138 );
139
140 END LNS_LOAN_HEADER_PUB;