1 PACKAGE OKL_FE_WF AS
2 /* $Header: OKLFEWFS.pls 120.0 2005/08/04 12:47:54 viselvar noship $ */
3 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
4 G_CAT_ITEM CONSTANT VARCHAR2(30) := OKL_ITEM_RESIDUALS_PVT.G_CAT_ITEM;
5 G_CAT_ITEM_CAT CONSTANT VARCHAR2(30) := OKL_ITEM_RESIDUALS_PVT.G_CAT_ITEM_CAT;
6 G_CAT_RES_CAT CONSTANT VARCHAR2(30) := OKL_ITEM_RESIDUALS_PVT.G_CAT_RES_CAT;
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FE_WF';
8 G_API_TYPE CONSTANT VARCHAR2(200) := '_PVT';
9
10 -- subtypes used
11
12 SUBTYPE okl_pal_rec IS okl_pal_pvt.okl_pal_rec;
13
14 SUBTYPE okl_srv_rec IS okl_srv_pvt.okl_srv_rec;
15
16 SUBTYPE okl_eve_rec IS okl_eve_pvt.okl_eve_rec;
17
18 SUBTYPE okl_icpv_rec IS okl_icp_pvt.icpv_rec_type;
19
20 SUBTYPE okl_lrvv_rec IS okl_lrv_pvt.okl_lrvv_rec;
21
22 -- handles the approval process for Standard Rate Template
23
24 PROCEDURE handle_srt_approval(itemtype IN varchar2, itemkey IN varchar2,
25 actid IN number, funcmode IN varchar2,
26 resultout OUT NOCOPY varchar2);
27
28 -- handles the approval process for Pricing Adjustment Matrix
29
30 PROCEDURE handle_pam_approval(itemtype IN varchar2, itemkey IN varchar2,
31 actid IN number, funcmode IN varchar2,
32 resultout OUT NOCOPY varchar2);
33
34 -- handles the approval process for End of Term Options
35
36 PROCEDURE handle_eot_approval(itemtype IN varchar2, itemkey IN varchar2,
37 actid IN number, funcmode IN varchar2,
38 resultout OUT NOCOPY varchar2);
39
40 -- handles the approval process for Lease Rate Set
41
42 PROCEDURE handle_lrs_approval(itemtype IN varchar2, itemkey IN varchar2,
43 actid IN number, funcmode IN varchar2,
44 resultout OUT NOCOPY varchar2);
45
46 -- handles the approval process Item Residuals
47
48 PROCEDURE handle_irs_approval(itemtype IN varchar2, itemkey IN varchar2,
49 actid IN number, funcmode IN varchar2,
50 resultout OUT NOCOPY varchar2);
51
52 -- method to set the attributes that have to be set before calling AME
53
54 PROCEDURE adj_mat_ame(itemtype IN VARCHAR2, itemkey IN VARCHAR2,
55 actid IN NUMBER, funcmode IN VARCHAR2,
56 resultout OUT NOCOPY VARCHAR2);
57
58 -- method to set the messages and the message desciption for Adjustment Matrix
59
60 PROCEDURE adj_mat_wf(itemtype IN VARCHAR2, itemkey IN VARCHAR2,
61 actid IN NUMBER, funcmode IN VARCHAR2,
62 resultout OUT NOCOPY VARCHAR2);
63
64 -- method to set the messages and the message desciption for Standard Rate Template
65
66 PROCEDURE std_rate_tmpl_wf(itemtype IN VARCHAR2, itemkey IN VARCHAR2,
67 actid IN NUMBER, funcmode IN VARCHAR2,
68 resultout OUT NOCOPY VARCHAR2);
69
70 -- method to set the attributes that have to be set before calling AME
71
72 PROCEDURE std_rate_tmpl_ame(itemtype IN VARCHAR2, itemkey IN VARCHAR2,
73 actid IN NUMBER, funcmode IN VARCHAR2,
74 resultout OUT NOCOPY VARCHAR2);
75
76 -- method to set the messages and the message desciption for End of Term Options
77
78 PROCEDURE eo_term_wf(itemtype IN VARCHAR2, itemkey IN VARCHAR2,
79 actid IN NUMBER, funcmode IN VARCHAR2,
80 resultout OUT NOCOPY VARCHAR2);
81
82 -- method to set the attributes that have to be set before calling AME
83
84 PROCEDURE eo_term_ame(itemtype IN VARCHAR2, itemkey IN VARCHAR2,
85 actid IN NUMBER, funcmode IN VARCHAR2,
86 resultout OUT NOCOPY VARCHAR2);
87
88 -- method to set the messages and the message desciption for Item Residuals
89
90 PROCEDURE item_res_wf(itemtype IN VARCHAR2, itemkey IN VARCHAR2,
91 actid IN NUMBER, funcmode IN VARCHAR2,
92 resultout OUT NOCOPY VARCHAR2);
93
94 -- method to set the attributes that have to be set before calling AME
95
96 PROCEDURE item_res_ame(itemtype IN VARCHAR2, itemkey IN VARCHAR2,
97 actid IN NUMBER, funcmode IN VARCHAR2,
98 resultout OUT NOCOPY VARCHAR2);
99
100 -- method to set the messages and the message desciption for Lease Rate Sets
101
102 PROCEDURE lease_rate_set_wf(itemtype IN VARCHAR2, itemkey IN VARCHAR2,
103 actid IN NUMBER, funcmode IN VARCHAR2,
104 resultout OUT NOCOPY VARCHAR2);
105
106 -- method to set the attributes that have to be set before calling AME
107
108 PROCEDURE lease_rate_set_ame(itemtype IN VARCHAR2, itemkey IN VARCHAR2,
109 actid IN NUMBER, funcmode IN VARCHAR2,
110 resultout OUT NOCOPY VARCHAR2);
111
112 -- procedure to check the approval process
113
114 PROCEDURE check_approval_process(itemtype IN VARCHAR2,
115 itemkey IN VARCHAR2, actid IN NUMBER,
116 funcmode IN VARCHAR2,
117 resultout OUT NOCOPY VARCHAR2);
118
119 -- Get the message body for Pricing Adjustment Matrix
120
121 PROCEDURE get_pam_msg_doc(document_id IN VARCHAR2,
122 display_type IN VARCHAR2,
123 document IN OUT NOCOPY VARCHAR2,
124 document_type IN OUT NOCOPY VARCHAR2);
125
126 -- Get the message body for Standard Rate Template
127
128 PROCEDURE get_srt_msg_doc(document_id IN VARCHAR2,
129 display_type IN VARCHAR2,
130 document IN OUT NOCOPY VARCHAR2,
131 document_type IN OUT NOCOPY VARCHAR2);
132
133 -- Get the message body for End of Term Options
134
135 PROCEDURE get_eot_msg_doc(document_id IN VARCHAR2,
136 display_type IN VARCHAR2,
137 document IN OUT NOCOPY VARCHAR2,
138 document_type IN OUT NOCOPY VARCHAR2);
139
140 -- Get the message body for Item Residuals
141
142 PROCEDURE get_irs_msg_doc(document_id IN VARCHAR2,
143 display_type IN VARCHAR2,
144 document IN OUT NOCOPY VARCHAR2,
145 document_type IN OUT NOCOPY VARCHAR2);
146
147 -- Get the message body for Lease Rate Set
148
149 PROCEDURE get_lrs_msg_doc(document_id IN VARCHAR2,
150 display_type IN VARCHAR2,
151 document IN OUT NOCOPY VARCHAR2,
152 document_type IN OUT NOCOPY VARCHAR2);
153
154 END okl_fe_wf;