[Home] [Help]
PACKAGE: APPS.LNS_LOAN_HEADER_PUB
Source
1 PACKAGE LNS_LOAN_HEADER_PUB AUTHID CURRENT_USER AS
2 /*$Header: LNS_LNHDR_PUBP_S.pls 120.13 2011/10/25 20:40:34 scherkas 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 DISABLE_BILLING_FLAG VARCHAR2(1),
102 ADD_REQUESTED_AMOUNT NUMBER,
103 DISABLE_INT_ACCRUAL_FLAG VARCHAR2(1),
104 BILL_ON_APPR_AMOUNT_FLAG VARCHAR2(1)
105 );
106 -------------------------------------------------------------------------
107
108 PROCEDURE create_loan (
109 p_init_msg_list IN VARCHAR2,
110 p_loan_header_rec IN LOAN_HEADER_REC_TYPE,
111 x_loan_id OUT NOCOPY NUMBER,
112 x_loan_number OUT NOCOPY VARCHAR2,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2
116 );
117
118 PROCEDURE update_loan (
119 p_init_msg_list IN VARCHAR2,
120 p_loan_header_rec IN LOAN_HEADER_REC_TYPE,
121 p_object_version_number IN OUT NOCOPY NUMBER,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2
125 );
126
127 PROCEDURE validate_loan (
128 p_init_msg_list IN VARCHAR2,
129 p_loan_header_rec IN LOAN_HEADER_REC_TYPE,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2
133 );
134
135 PROCEDURE get_loan_header_rec (
136 p_init_msg_list IN VARCHAR2,
137 p_loan_id IN NUMBER,
138 x_loan_header_rec OUT NOCOPY LOAN_HEADER_REC_TYPE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2
142 );
143
144 END LNS_LOAN_HEADER_PUB;