1 PACKAGE OKL_LEASE_APP_WF AUTHID CURRENT_USER AS
2 /* $Header: OKLLAWFS.pls 120.0 2005/11/23 11:30:45 viselvar noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_LEASE_APP_WF';
8
9 G_STATUS_NEW CONSTANT VARCHAR2(100) := 'NEW';
10 ---------------------------------------------------------------------------
11 SUBTYPE lavv_rec_type IS OKL_LAV_PVT.lavv_rec_type;
12
13 -- Start of comments
14 --
15 -- Procedure Name : check_approval_process
16 -- Description : Procedure to check if the Approval Process is Workflow driven
17 -- or through AME.
18 -- Business Rules : Checks the Frontend profile and directs the approval flow
19 -- accordingly
20 -- Parameters :
21 -- Version : 1.0
22 -- End of comments
23
24 PROCEDURE check_approval_process(itemtype IN VARCHAR2,
25 itemkey IN VARCHAR2, actid IN NUMBER,
26 funcmode IN VARCHAR2,
27 resultout OUT NOCOPY VARCHAR2);
28 -- Start of comments
29 --
30 -- Procedure Name : get_lat_ver_details
31 -- Description : Gets the details of the Lease Application Template version
32 -- Business Rules :
33 -- Parameters :
34 -- Version : 1.0
35 -- End of comments
36
37 PROCEDURE get_lat_ver_details (itemtype IN VARCHAR2,
38 itemkey IN VARCHAR2,
39 actid IN NUMBER,
40 funcmode IN VARCHAR2,
41 resultout OUT NOCOPY VARCHAR2);
42
43 -- Start of comments
44 --
45 -- Procedure Name : get_lat_msg_doc
46 -- Description : Sets the message document for notification for Lease
47 -- Application template
48 -- Business Rules :
49 -- Parameters :
50 -- Version : 1.0
51 -- End of comments
52 PROCEDURE get_lat_msg_doc(document_id IN VARCHAR2,
53 display_type IN VARCHAR2,
54 document IN OUT NOCOPY VARCHAR2,
55 document_type IN OUT NOCOPY VARCHAR2);
56
57 -- Start of comments
58 --
59 -- Procedure Name : get_la_withdraw_msg_doc
60 -- Description : Sets the message document for notification for Lease
61 -- Application withdrawal
62 -- Business Rules :
63 -- Parameters :
64 -- Version : 1.0
65 -- End of comments
66 PROCEDURE get_la_withdraw_msg_doc(document_id IN VARCHAR2,
67 display_type IN VARCHAR2,
68 document IN OUT NOCOPY VARCHAR2,
69 document_type IN OUT NOCOPY VARCHAR2);
70
71 -- Start of comments
72 --
73 -- Procedure Name : handle_lat_approval
74 -- Description : Handles the process after the process is approved or rejected
75 -- Business Rules : If Approved, call the API to activate the LAT
76 -- Else change the version status of LAT to NEW
77 -- Parameters :
78 -- Version : 1.0
79 -- End of comments
80
81 PROCEDURE handle_lat_approval (itemtype IN VARCHAR2,
82 itemkey IN VARCHAR2,
83 actid IN NUMBER,
84 funcmode IN VARCHAR2,
85 resultout OUT NOCOPY VARCHAR2) ;
86
87 -- Start of comments
88 --
89 -- Procedure Name : check_la_credit_status
90 -- Description : Procedure to check if credit processing has been done on the
91 -- Lease Application.
92 -- Business Rules : Checks if the Lease Application is in CR-APPROVED or CR-REJECTED
93 -- Parameters :
94 -- Version : 1.0
95 -- End of comments
96 PROCEDURE check_la_credit_status(itemtype IN VARCHAR2,
97 itemkey IN VARCHAR2,
98 actid IN NUMBER,
99 funcmode IN VARCHAR2,
100 resultout OUT NOCOPY VARCHAR2);
101 -- Start of comments
102 --
103 -- Procedure Name : get_la_withdraw_details
104 -- Description : Gets the details of the Lease Application details and
105 -- Sets the message for this operation
106 -- Business Rules :
107 -- Parameters :
108 -- Version : 1.0
109 -- End of comments
110
111 PROCEDURE get_la_withdraw_details (itemtype IN VARCHAR2,
112 itemkey IN VARCHAR2,
113 actid IN NUMBER,
114 funcmode IN VARCHAR2,
115 resultout OUT NOCOPY VARCHAR2);
116
117 -- Start of comments
118 --
119 -- Procedure Name : handle_la_withdraw_approval
120 -- Description : Handles the process after the Lease Application withdrawal
121 -- is approved or rejected by Credit Analyst.
122 -- Business Rules : If Approved, call the API to withdraw the Lease Application
123 -- Else the Lease Application status is not changed.
124 -- Parameters :
125 -- Version : 1.0
126 -- End of comments
127
128 PROCEDURE handle_la_withdraw_approval (itemtype IN VARCHAR2,
129 itemkey IN VARCHAR2,
130 actid IN NUMBER,
131 funcmode IN VARCHAR2,
132 resultout OUT NOCOPY VARCHAR2);
133 END OKL_LEASE_APP_WF;