1 PACKAGE OKL_PRB_UPGRADE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRPRBS.pls 120.1 2011/03/29 07:12:07 rgooty noship $ */
3 ------------------------------------------------------------------------------
4 -- Global Variables
5 ------------------------------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PRB_UPGRADE_PVT ';
7 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_PRB_UPGRADE_PVT';
9 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
10 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
11 G_COMMIT_AFTER_RECORDS CONSTANT NUMBER := 500;
12 G_COMMIT_COUNT NUMBER := 0;
13 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
14 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
15 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
16 -- Constant Declaration
17 G_ESG_PRB_KHR_UPG_OBJ_TYPE CONSTANT VARCHAR2(30) := 'ESG_PRB_UPGRADE_CONTRACT';
18
19 -- Type Declarations
20 TYPE worker_load_rec IS RECORD (
21 worker_number NUMBER
22 ,worker_load NUMBER
23 ,used BOOLEAN
24 );
25 TYPE worker_load_tab IS TABLE OF worker_load_rec
26 INDEX BY BINARY_INTEGER;
27
28 ------------------------------------------------------------------------------
29 -- Start of comments
30 -- API name : eff_dated_rbk_upgrade
31 -- Pre-reqs : None
32 -- Description : API to request PRB Upgrade of an ESG Lease Contract
33 -- Parameters :
34 -- IN :
35 -- Workers ID Mandatory
36 -- History : Ravindranath Gooty created
37 -- Version : 1.0
38 -- End of comments
39 ------------------------------------------------------------------------------
40 PROCEDURE eff_dated_rbk_upgrade(
41 errbuf OUT NOCOPY VARCHAR2
42 ,retcode OUT NOCOPY NUMBER
43 ,p_worker_id IN VARCHAR2
44 );
45
46 ------------------------------------------------------------------------------
47 -- Start of comments
48 -- API name : eff_dated_rbk_upgrade_conc
49 -- Pre-reqs : None
50 -- Description : API to identify eligible contracts for ESG PRB Upgrade
51 -- based on the Criteria given and launch multiple workers
52 -- Parameters :
53 -- IN :
54 -- Operating Unit Mandatory
55 -- Criteria Set Mandatory [CONTRACT/REVISION]
56 -- Legal Entity Optional
57 -- Contract Number Optional
58 -- Book Classification Optional
59 -- Product Optional
60 -- Interest Calculation Method Optional
61 -- Revenue Recognition Method Optional
62 -- Start Date [Low] Optional
63 -- Start Date [High] Optional
64 -- End Date [Low] Optional
65 -- End Date [High] Optional
66 -- In-Transit Category Optional
67 -- Mode Optional [REVIEW/SUBMIT]
68 -- Tag Name Optional
69 -- # of Workers Optional
70 -- History : Ravindranath Gooty created
71 -- Version : 1.0
72 -- End of comments
73 ------------------------------------------------------------------------------
74 PROCEDURE eff_dated_rbk_upgrade_conc(
75 errbuf OUT NOCOPY VARCHAR2
76 ,retcode OUT NOCOPY NUMBER
77 ,p_org_id IN NUMBER
78 ,p_criteria_set IN VARCHAR2
79 ,p_dummy_crit_set_contract IN VARCHAR2
80 ,p_dummy_crit_set_revision IN VARCHAR2
81 ,p_le_id IN NUMBER
82 ,p_khr_id IN NUMBER
83 ,p_book_classification IN VARCHAR2
84 ,p_pdt_id IN NUMBER
85 ,p_int_calc_method IN VARCHAR2
86 ,p_rev_rec_method IN VARCHAR2
87 ,p_start_date_low IN VARCHAR2
88 ,p_start_date_high IN VARCHAR2
89 ,p_end_date_low IN VARCHAR2
90 ,p_end_date_high IN VARCHAR2
91 ,p_in_transit_category IN VARCHAR2
92 ,p_mode_of_run IN VARCHAR2
93 ,p_tag_name IN VARCHAR2
94 ,p_no_of_workers IN NUMBER
95 );
96
97 ------------------------------------------------------------------------------
98 -- Start of comments
99 -- API name : reamort_upgrade
100 -- Pre-reqs : None
101 -- Description : API to request Transaction State Upgrade of an ESG Lease Reamort Contract
102 -- Parameters :
103 -- IN :
104 -- Workers ID Mandatory
105 -- History : Ravindranath Gooty created
106 -- Version : 1.0
107 -- End of comments
108 ------------------------------------------------------------------------------
109 PROCEDURE reamort_upgrade(
110 errbuf OUT NOCOPY VARCHAR2
111 ,retcode OUT NOCOPY NUMBER
112 ,p_worker_id IN VARCHAR2
113 );
114
115 ------------------------------------------------------------------------------
116 -- Start of comments
117 -- API name : reamort_upgrade_conc
118 -- Pre-reqs : None
119 -- Description : API to identify eligible contracts for ESG Reamort Upgrade
120 -- based on the Criteria given and launch multiple workers
121 -- Parameters :
122 -- IN :
123 -- Operating Unit Mandatory
124 -- Criteria Set Mandatory [REAMORT]
125 -- Legal Entity Optional
126 -- Contract Number Optional
127 -- Product Optional
128 -- Start Date [Low] Optional
129 -- Start Date [High] Optional
130 -- End Date [Low] Optional
131 -- End Date [High] Optional
132 -- Mode Optional [REVIEW/SUBMIT]
133 -- Tag Name Optional
134 -- # of Workers Optional
135 -- History : Ravindranath Gooty created
136 -- Version : 1.0
137 -- End of comments
138 ------------------------------------------------------------------------------
139 PROCEDURE reamort_upgrade_conc(
140 errbuf OUT NOCOPY VARCHAR2
141 ,retcode OUT NOCOPY NUMBER
142 ,p_org_id IN NUMBER
143 ,p_criteria_set IN VARCHAR2
144 ,p_dummy_crit_set_contract IN VARCHAR2
145 ,p_le_id IN NUMBER
146 ,p_khr_id IN NUMBER
147 ,p_pdt_id IN NUMBER
148 ,p_start_date_low IN VARCHAR2
149 ,p_start_date_high IN VARCHAR2
150 ,p_end_date_low IN VARCHAR2
151 ,p_end_date_high IN VARCHAR2
152 ,p_mode_of_run IN VARCHAR2
153 ,p_tag_name IN VARCHAR2
154 ,p_no_of_workers IN NUMBER
155 );
156
157 END OKL_PRB_UPGRADE_PVT;