[Home] [Help]
PACKAGE: APPS.OKL_CREDIT_LINE_WF
Source
1 PACKAGE okl_credit_line_wf AUTHID CURRENT_USER AS
2 /* $Header: OKLRDWFS.pls 120.0 2005/11/30 17:17:46 stmathew noship $ */
3
4 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
5 G_PKG_NAME CONSTANT VARCHAR2(200) := 'okl_credit_line_wf';
6 G_LEVEL CONSTANT VARCHAR2(4) := '_PVT';
7 l_api_version CONSTANT NUMBER := 1;
8 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
9
10 ---------------------------------------------------------------------------
11 -- PROCEDURE raise_approval_event
12 ---------------------------------------------------------------------------
13 -- Start of comments
14 --
15 -- Procedure Name : raise_approval_event
16 -- Description :
17 -- Business Rules : Raises the credit line approval event
18 -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
19 -- x_msg_data, p_contract_id.
20 -- Version : 1.0
21 -- End of comments
22 ---------------------------------------------------------------------------
23 PROCEDURE raise_approval_event (p_api_version IN NUMBER,
24 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2,
28 p_contract_id IN OKC_K_HEADERS_B.ID%TYPE);
29
30 ---------------------------------------------------------------------------
31 -- PROCEDURE Set_Parent_Attributes
32 ---------------------------------------------------------------------------
33 -- Start of comments
34 --
35 -- Procedure Name : Set_Parent_Attributes
36 -- Description :
37 -- Business Rules : sets the parent attributes.
38 -- Parameters : itemtype, itemkey, actid, funcmode,resultout.
39 -- Version : 1.0
40 -- End of comments
41 ---------------------------------------------------------------------------
42 PROCEDURE Set_Parent_Attributes(itemtype IN VARCHAR2,
43 itemkey IN VARCHAR2,
44 actid IN NUMBER,
45 funcmode IN VARCHAR2,
46 resultout OUT NOCOPY VARCHAR2);
47
48 ---------------------------------------------------------------------------
49 -- PROCEDURE update_approval_status
50 ---------------------------------------------------------------------------
51 -- Start of comments
52 --
53 -- Procedure Name : update_approval_status
54 -- Description :
55 -- Business Rules : Updates the credit line status from pending approval
56 -- to approved or declined.
57 -- Parameters : itemtype, itemkey, actid, funcmode,resultout.
58 -- Version : 1.0
59 -- End of comments
60 ---------------------------------------------------------------------------
61 PROCEDURE update_approval_status(itemtype IN VARCHAR2,
62 itemkey IN VARCHAR2,
63 actid IN NUMBER,
64 funcmode IN VARCHAR2,
65 resultout OUT NOCOPY VARCHAR2);
66
67 ---------------------------------------------------------------------------
68 -- PROCEDURE get_credit_line_approver
69 ---------------------------------------------------------------------------
70 -- Start of comments
71 --
72 -- Procedure Name : get_credit_line_approver
73 -- Description :
74 -- Business Rules : returns whether the approver is found or not.
75 -- Parameters : itemtype, itemkey, actid, funcmode,resultout.
76 -- Version : 1.0
77 -- End of comments
78 ---------------------------------------------------------------------------
79 PROCEDURE get_credit_line_approver (itemtype IN VARCHAR2,
80 itemkey IN VARCHAR2,
81 actid IN NUMBER,
82 funcmode IN VARCHAR2,
83 resultout OUT NOCOPY VARCHAR2);
84
85 ---------------------------------------------------------------------------
86 -- PROCEDURE pop_approval_doc
87 ---------------------------------------------------------------------------
88 -- Start of comments
89 --
90 -- Procedure Name : pop_approval_doc
91 -- Description :
92 -- Business Rules : This procedure is invoked dynamically by Workflow API's
93 -- in order to populate the message body item attribute
94 -- during notification submission.
95 -- Parameters : document_id, display_type, document, document_type.
96 -- Version : 1.0
97 -- End of comments
98 ---------------------------------------------------------------------------
99 PROCEDURE pop_approval_doc (document_id IN VARCHAR2,
100 display_type IN VARCHAR2,
101 document IN OUT NOCOPY VARCHAR2,
102 document_type IN OUT NOCOPY VARCHAR2);
103
104 ---------------------------------------------------------------------------
105 -- PROCEDURE check_approval_process
106 ---------------------------------------------------------------------------
107 -- Start of comments
108 --
109 -- Procedure Name : check_approval_process
110 -- Description :
111 -- Business Rules : Checks whether the profile option is set to WF or AME
112 -- and sets the parameter accordingly.
113 -- Parameters : itemtype, itemkey, actid, funcmode,resultout.
114 -- Version : 1.0
115 -- End of comments
116 ---------------------------------------------------------------------------
117 PROCEDURE check_approval_process( itemtype IN VARCHAR2,
118 itemkey IN VARCHAR2,
119 actid IN NUMBER,
120 funcmode IN VARCHAR2,
121 resultout OUT NOCOPY VARCHAR2 );
122
123 ---------------------------------------------------------------------------
124 -- PROCEDURE wf_approval_process
125 ---------------------------------------------------------------------------
126 -- Start of comments
127 --
128 -- Procedure Name : wf_approval_process
129 -- Description :
130 -- Business Rules : This is raised when the profile option is WF.
131 -- Parameters : itemtype, itemkey, actid, funcmode,resultout.
132 -- Version : 1.0
133 -- End of comments
134 ---------------------------------------------------------------------------
135 PROCEDURE wf_approval_process( itemtype IN VARCHAR2,
136 itemkey IN VARCHAR2,
137 actid IN NUMBER,
138 funcmode IN VARCHAR2,
139 resultout OUT NOCOPY VARCHAR2 );
140
141 ---------------------------------------------------------------------------
142 -- PROCEDURE ame_approval_process
143 ---------------------------------------------------------------------------
144 -- Start of comments
145 --
146 -- Procedure Name : ame_approval_process
147 -- Description :
148 -- Business Rules : This is raised when the profile option is AME.
149 -- Parameters : itemtype, itemkey, actid, funcmode,resultout.
150 -- Version : 1.0
151 -- End of comments
152 ---------------------------------------------------------------------------
153 PROCEDURE ame_approval_process( itemtype IN VARCHAR2,
154 itemkey IN VARCHAR2,
155 actid IN NUMBER,
156 funcmode IN VARCHAR2,
157 resultout OUT NOCOPY VARCHAR2 );
158
159 END okl_credit_line_wf;