1 PACKAGE LNS_PARTICIPANTS_PUB AS
2 /* $Header: LNS_PART_PUBP_S.pls 120.6 2006/01/18 20:29:00 karamach noship $ */
3
4 TYPE loan_participant_rec_type IS RECORD(
5 PARTICIPANT_ID NUMBER,
6 LOAN_ID NUMBER,
7 HZ_PARTY_ID NUMBER,
8 LOAN_PARTICIPANT_TYPE VARCHAR2(30),
9 START_DATE_ACTIVE DATE,
10 END_DATE_ACTIVE DATE,
11 CUST_ACCOUNT_ID NUMBER,
12 BILL_TO_ACCT_SITE_ID NUMBER,
13 OBJECT_VERSION_NUMBER NUMBER,
14 ATTRIBUTE_CATEGORY VARCHAR2(30),
15 ATTRIBUTE1 VARCHAR2(150),
16 ATTRIBUTE2 VARCHAR2(150),
17 ATTRIBUTE3 VARCHAR2(150),
18 ATTRIBUTE4 VARCHAR2(150),
19 ATTRIBUTE5 VARCHAR2(150),
20 ATTRIBUTE6 VARCHAR2(150),
21 ATTRIBUTE7 VARCHAR2(150),
22 ATTRIBUTE8 VARCHAR2(150),
23 ATTRIBUTE9 VARCHAR2(150),
24 ATTRIBUTE10 VARCHAR2(150),
25 ATTRIBUTE11 VARCHAR2(150),
26 ATTRIBUTE12 VARCHAR2(150),
27 ATTRIBUTE13 VARCHAR2(150),
28 ATTRIBUTE14 VARCHAR2(150),
29 ATTRIBUTE15 VARCHAR2(150),
30 ATTRIBUTE16 VARCHAR2(150),
31 ATTRIBUTE17 VARCHAR2(150),
32 ATTRIBUTE18 VARCHAR2(150),
33 ATTRIBUTE19 VARCHAR2(150),
34 ATTRIBUTE20 VARCHAR2(150),
35 CONTACT_REL_PARTY_ID NUMBER,
36 CONTACT_PERS_PARTY_ID NUMBER,
37 CREDIT_REQUEST_ID NUMBER,
38 CASE_FOLDER_ID NUMBER,
39 REVIEW_TYPE VARCHAR2(30),
40 CREDIT_CLASSIFICATION VARCHAR2(30)
41 );
42
43 procedure validateParticipant(p_loan_participant_rec IN loan_participant_rec_type,
44 p_mode IN VARCHAR2,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2);
48
49 PROCEDURE createParticipant(p_init_msg_list IN VARCHAR2,
50 p_validation_level IN NUMBER,
51 p_loan_participant_rec IN loan_participant_rec_type,
52 x_participant_id OUT NOCOPY NUMBER,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2);
56
57 PROCEDURE updateParticipant(p_init_msg_list IN VARCHAR2,
58 p_validation_level IN NUMBER,
59 p_loan_participant_rec IN loan_participant_rec_type,
60 x_object_version_number IN OUT NOCOPY NUMBER,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2);
64
65 ----------------------------------------------------------------
66 --This procedure changes all credit requests that have been created
67 --for the loan participants in SAVE status to SUBMIT status
68 --and changes the loan secondary status to IN_CREDIT_REVIEW
69 ----------------------------------------------------------------
70 PROCEDURE submitCreditRequest(p_loan_id IN NUMBER,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2);
74
75 ----------------------------------------------------------------
76 --This procedure changes resubmit/appeal the credit request that has been created
77 --for the primary borrower after the case folder has been closed and when loan secondary status is CREDIT_REVIEW_COMPLETE
78 --and changes the loan secondary status to null
79 ----------------------------------------------------------------
80 PROCEDURE createAppealCreditRequest(p_loan_id IN NUMBER,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2);
84
85 ----------------------------------------------------------------
86 -- This is function updates lns_participants with the case_folder_id
87 -- if credit management case folder has been submitted with recommendations
88 -- for the loan application that submitted credit request
89 -- This is called from workflow business event from credit management
90 -- and also from the approval page UI if the loan is currently IN_CREDIT_REVIEW secondary status
91 -- This function returns 'Y' for Successful update, 'N' for update failure/error and 'I' for invalid condition
92 -- 'I' is returned when the loan has already changed status and case_folder_id has already been updated before
93 ----------------------------------------------------------------
94 FUNCTION CASE_FOLDER_UPDATE(p_loan_id IN NUMBER) RETURN VARCHAR2;
95
96
97 ----------------------------------------------------------------
98 --This is rule function, that is subscribed to the Oracle Workflow
99 -- Business Event CreditRequest.Recommendation.implement
100 --to implement recomendations of the AR CRedit Management Review
101 ----------------------------------------------------------------
102 FUNCTION OCM_WORKFLOW_CREDIT_RECO_EVENT(p_subscription_guid IN RAW,
103 p_event IN OUT NOCOPY WF_EVENT_T) RETURN VARCHAR2;
104
105 END LNS_PARTICIPANTS_PUB;