[Home] [Help]
PACKAGE: APPS.OKL_SEC_AGREEMENT_WF
Source
1 PACKAGE OKL_SEC_AGREEMENT_WF AUTHID CURRENT_USER AS
2 /* $Header: OKLRZWFS.pls 120.0 2007/12/24 10:42:04 ankushar noship $ */
3
4 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
5 G_PKG_NAME CONSTANT VARCHAR2(200) := 'okl_sec_agreement_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 SUBTYPE poxv_rec_type IS OKL_POX_PVT.poxv_rec_type;
11
12 --------------------------------------------------------------------------------------------------
13 ----------------------------------Raising Business Event ------------------------------------------
14 --------------------------------------------------------------------------------------------------
15 ---------------------------------------------------------------------------
16 -- PROCEDURE raise_add_khr_approval_event
17 ---------------------------------------------------------------------------
18 -- Start of comments
19 --
20 -- Procedure Name : raise_add_khr_approval_event
21 -- Description :
22 -- Business Rules : Raises the credit line approval event
23 -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
24 -- x_msg_data, p_agreement_id, p_pool_id.
25 -- Version : 1.0
26 -- End of comments
27 ---------------------------------------------------------------------------
28 PROCEDURE raise_add_khr_approval_event (p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2,
33 p_agreement_id IN OKC_K_HEADERS_B.ID%TYPE,
34 p_pool_id IN OKL_POOLS_ALL.ID%TYPE,
35 p_pool_trans_id IN OKL_POOL_TRANSACTIONS.ID%TYPE);
36
37 ---------------------------------------------------------------------------
38 -- PROCEDURE Set_Add_Khr_Attributes
39 ---------------------------------------------------------------------------
40 -- Start of comments
41 --
42 -- Procedure Name : Set_Add_Khr_Attributes
43 -- Description :
44 -- Business Rules : sets the parent attributes.
45 -- Parameters : itemtype, itemkey, actid, funcmode,resultout.
46 -- Version : 1.0
47 -- End of comments
48 ---------------------------------------------------------------------------
49 PROCEDURE Set_Add_Khr_Attributes(itemtype IN VARCHAR2,
50 itemkey IN VARCHAR2,
51 actid IN NUMBER,
52 funcmode IN VARCHAR2,
53 resultout OUT NOCOPY VARCHAR2);
54
55 --------------------------------------------------------------------------------------------------
56 ----------------------------------Main Approval Process ------------------------------------------
57 --------------------------------------------------------------------------------------------------
58 ---------------------------------------------------------------------------
59 -- PROCEDURE update_add_khr_apprv_sts
60 ---------------------------------------------------------------------------
61 -- Start of comments
62 --
63 -- Procedure Name : update_add_khr_apprv_sts
64 -- Description :
65 -- Business Rules : Updates the Add Contracts Request status from pending approval
66 -- to approved or approval rejected.
67 -- Parameters : itemtype, itemkey, actid, funcmode,resultout.
68 -- Version : 1.0
69 -- End of comments
70 ---------------------------------------------------------------------------
71 PROCEDURE update_add_khr_apprv_sts(itemtype IN VARCHAR2,
72 itemkey IN VARCHAR2,
73 actid IN NUMBER,
74 funcmode IN VARCHAR2,
75 resultout OUT NOCOPY VARCHAR2);
76
77 /*
78 -- This API is for IA Add Contracts Request Approval via WF
79 */
80 ---------------------------------------------------------------------------
81 -- PROCEDURE get_add_khr_approver
82 ---------------------------------------------------------------------------
83 -- Start of comments
84 --
85 -- Procedure Name : get_add_khr_approver
86 -- Description :
87 -- Business Rules : returns whether the approver is found or not.
88 -- Parameters : itemtype, itemkey, actid, funcmode,resultout.
89 -- Version : 1.0
90 -- End of comments
91 ---------------------------------------------------------------------------
92 PROCEDURE get_add_khr_approver(itemtype IN VARCHAR2,
93 itemkey IN VARCHAR2,
94 actid IN NUMBER,
95 funcmode IN VARCHAR2,
96 resultout OUT NOCOPY VARCHAR2);
97
98 ---------------------------------------------------------------------------
99 -- PROCEDURE pop_approval_doc
100 ---------------------------------------------------------------------------
101 -- Start of comments
102 --
103 -- Procedure Name : pop_approval_doc
104 -- Description :
105 -- Business Rules : This procedure is invoked dynamically by Workflow API's
106 -- in order to populate the message body item attribute
107 -- during notification submission.
108 -- Parameters : document_id, display_type, document, document_type.
109 -- Version : 1.0
110 -- End of comments
111 ---------------------------------------------------------------------------
112 PROCEDURE pop_approval_doc (document_id IN VARCHAR2,
113 display_type IN VARCHAR2,
114 document IN OUT NOCOPY VARCHAR2,
115 document_type IN OUT NOCOPY VARCHAR2);
116
117 ---------------------------------------------------------------------------
118 -- PROCEDURE check_add_khr_approval_process
119 ---------------------------------------------------------------------------
120 -- Start of comments
121 --
122 -- Procedure Name : check_add_khr_approval_process
123 -- Description :
124 -- Business Rules : Checks whether the profile option is set to WF or AME
125 -- and sets the parameter accordingly.
126 -- Parameters : itemtype, itemkey, actid, funcmode,resultout.
127 -- Version : 1.0
128 -- End of comments
129 ---------------------------------------------------------------------------
130 PROCEDURE check_add_apprv_process( itemtype IN VARCHAR2,
131 itemkey IN VARCHAR2,
132 actid IN NUMBER,
133 funcmode IN VARCHAR2,
134 resultout OUT NOCOPY VARCHAR2 );
135
136 ---------------------------------------------------------------------------
137 -- PROCEDURE wf_add_khr_approval_process
138 ---------------------------------------------------------------------------
139 -- Start of comments
140 --
141 -- Procedure Name : wf_add_khr_approval_process
142 -- Description :
143 -- Business Rules : This is raised when the profile option is WF.
144 -- Parameters : itemtype, itemkey, actid, funcmode,resultout.
145 -- Version : 1.0
146 -- End of comments
147 ---------------------------------------------------------------------------
148 PROCEDURE wf_add_khr_apprv_process( itemtype IN VARCHAR2,
149 itemkey IN VARCHAR2,
150 actid IN NUMBER,
151 funcmode IN VARCHAR2,
152 resultout OUT NOCOPY VARCHAR2 );
153
154 ---------------------------------------------------------------------------
155 -- PROCEDURE ame_add_khr_apprv_process
156 ---------------------------------------------------------------------------
157 -- Start of comments
158 --
159 -- Procedure Name : ame_add_khr_apprv_process
160 -- Description :
161 -- Business Rules : This is raised when the profile option is AME.
162 -- Parameters : itemtype, itemkey, actid, funcmode,resultout.
163 -- Version : 1.0
164 -- End of comments
165 ---------------------------------------------------------------------------
166 PROCEDURE ame_add_khr_apprv_process( itemtype IN VARCHAR2,
167 itemkey IN VARCHAR2,
168 actid IN NUMBER,
169 funcmode IN VARCHAR2,
170 resultout OUT NOCOPY VARCHAR2 );
171
172 END okl_sec_agreement_wf;
173