1 PACKAGE LNS_PARTICIPANTS_PUB AUTHID CURRENT_USER AS
2 /* $Header: LNS_PART_PUBP_S.pls 120.8 2011/08/22 10:33:23 gparuchu ship $ */
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 ACCESS_LEVEL VARCHAR2(30)
42 );
43
44 procedure validateParticipant(p_loan_participant_rec IN loan_participant_rec_type,
45 p_mode IN VARCHAR2,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2);
49
50 PROCEDURE createParticipant(p_init_msg_list IN VARCHAR2,
51 p_validation_level IN NUMBER,
52 p_loan_participant_rec IN loan_participant_rec_type,
53 x_participant_id OUT NOCOPY NUMBER,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2);
57
58 PROCEDURE updateParticipant(p_init_msg_list IN VARCHAR2,
59 p_validation_level IN NUMBER,
60 p_loan_participant_rec IN loan_participant_rec_type,
61 x_object_version_number IN OUT NOCOPY NUMBER,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2);
65
66 ----------------------------------------------------------------
67 --This procedure changes all credit requests that have been created
68 --for the loan participants in SAVE status to SUBMIT status
69 --and changes the loan secondary status to IN_CREDIT_REVIEW
70 ----------------------------------------------------------------
71 PROCEDURE submitCreditRequest(p_loan_id IN NUMBER,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2);
75
76 ----------------------------------------------------------------
77 --This procedure changes resubmit/appeal the credit request that has been created
78 --for the primary borrower after the case folder has been closed and when loan secondary status is CREDIT_REVIEW_COMPLETE
79 --and changes the loan secondary status to null
80 ----------------------------------------------------------------
81 PROCEDURE createAppealCreditRequest(p_loan_id IN NUMBER,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2);
85
86 ----------------------------------------------------------------
87 -- This is function updates lns_participants with the case_folder_id
88 -- if credit management case folder has been submitted with recommendations
89 -- for the loan application that submitted credit request
90 -- This is called from workflow business event from credit management
91 -- and also from the approval page UI if the loan is currently IN_CREDIT_REVIEW secondary status
92 -- This function returns 'Y' for Successful update, 'N' for update failure/error and 'I' for invalid condition
93 -- 'I' is returned when the loan has already changed status and case_folder_id has already been updated before
94 ----------------------------------------------------------------
95 FUNCTION CASE_FOLDER_UPDATE(p_loan_id IN NUMBER) RETURN VARCHAR2;
96
97
98 ----------------------------------------------------------------
99 --This is rule function, that is subscribed to the Oracle Workflow
100 -- Business Event CreditRequest.Recommendation.implement
101 --to implement recomendations of the AR CRedit Management Review
102 ----------------------------------------------------------------
103 FUNCTION OCM_WORKFLOW_CREDIT_RECO_EVENT(p_subscription_guid IN RAW,
104 p_event IN OUT NOCOPY WF_EVENT_T) RETURN VARCHAR2;
105
106 END LNS_PARTICIPANTS_PUB;
[Home] [Help]