1 PACKAGE LNS_SUBMIT_FOR_APPROVAL_PUB AUTHID CURRENT_USER as
2 /* $Header: LNS_SUBMIT_FOR_APPROVAL_PUB_S.pls 120.0.12000000.3 2007/05/09 11:32:53 mbolli noship $ */
3 /*#
4 * Start of Comments
5 * Package name : LNS_SUBMIT_FOR_APPROVAL_PUB
6 * Purpose : Creates request for Loan Approval
7 * History :
8 */
9 -- * @rep:scope public
10 -- * @rep:product LNS
11 -- * @rep:displayname Request For Loan Approval
12 -- * @rep:lifecycle active
13 -- * @rep:compatibility S
14 -- * @rep:category BUSINESS_ENTITY LOAN_APPROVAL_REQUEST
15
16
17 /*=======================================================================+
18 | Declare PUBLIC Data Types and Variables
19 +=======================================================================*/
20 /*
21 In the Comments below FK stands for Foreign Key. This type is passed as a
22 parameter to Submit_For_Approval API.
23 */
24 TYPE Loan_Sub_For_Appr_err_type IS TABLE OF LNS_LOAN_CREATE_ERRORS_GT%ROWTYPE;
25
26
27 /*========================================================================
28 | PUBLIC PROCEDURE SUBMIT_FOR_APPROVAL
29 |
30 | DESCRIPTION
31 | This process
32 |
33 | PSEUDO CODE/LOGIC
34 |
35 | PARAMETERS
36 | P_API_VERSION - API Version
37 | P_COMMIT - Passing 'Y' will result in an explicit commit
38 | being issued in the API.
39 | P_Loan_id - Loan_id of the loan for which we are requresting
40 | for approval.
41 | X_RETURN_STATUS - Returns 'S' for success and 'F' for Failure.
42 | X_MSG_COUNT - Returns number of Errors.The errors are inserted
43 | in the Global temporary table
44 | LNS_LOAN_CREATE_ERRORS_GT.
45 | KNOWN ISSUES
46 | None
47 |
48 | NOTES
49 |
50 | MODIFICATION HISTORY
51 | Date Author Description of Changes
52 | 29-Mar-2007 MBOLLI Created
53 |
54 *=======================================================================*/
55
56 /*#
57 * Creates a Approval Request for a Loan
58 * @param P_API_VERSION API Version Number
59 * @param P_COMMIT Commit flag
60 * @param P_APPROVAL_ACTION_REC Details about the request
61 * @param P_AUTO_FUNDING_FLAG Funding Advice generation
62 * @param X_ACTION_ID action ID of the created request
63 * @param X_RETURN_STATUS API return status
64 * @param X_MSG_COUNT Number of error messages
65 */
66 -- * @rep:scope internal
67 -- * @rep:displayname Submit Request for Loan Approval
68 -- * @rep:lifecycle active
69 -- * @rep:compatibility S
70
71
72 PROCEDURE SUBMIT_FOR_APPROVAL(
73 P_API_VERSION IN NUMBER,
74 P_COMMIT IN VARCHAR2,
75 P_APPROVAL_ACTION_REC IN LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE,
76 P_AUTO_FUNDING_FLAG IN VARCHAR2,
77 X_ACTION_ID OUT NOCOPY NUMBER,
78 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
79 X_MSG_COUNT OUT NOCOPY NUMBER);
80
81 END LNS_SUBMIT_FOR_APPROVAL_PUB;