eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKI_UTL_PVT dependencies on OKI_UTL_PUB

Line 88: AND oki_utl_pub.g_contract_limit

84: AND shd.end_date >= p_start_date
85: AND ( shd.date_terminated IS NULL
86: OR shd.date_terminated > p_start_date )
87: AND shd.base_contract_amount BETWEEN 0
88: AND oki_utl_pub.g_contract_limit
89: ;
90:
91: -- Retrieve the total active contracts by organization
92: CURSOR g_tactk_by_org_csr

Line 111: AND oki_utl_pub.g_contract_limit

107: AND shd.end_date >= p_start_date
108: AND ( shd.date_terminated IS NULL
109: OR shd.date_terminated > p_start_date )
110: AND shd.base_contract_amount BETWEEN 0
111: AND oki_utl_pub.g_contract_limit
112: AND shd.authoring_org_id = p_authoring_org_id
113: GROUP BY shd.authoring_org_id
114: ORDER BY value
115: ;

Line 130: AND oki_utl_pub.g_contract_limit

126: AND shd.is_new_yn IS NULL
127: AND shd.date_signed IS NULL
128: AND shd.date_canceled IS NULL
129: AND shd.contract_amount BETWEEN 0
130: AND oki_utl_pub.g_contract_limit
131: ;
132:
133:
134: -- Retrieve the renewal opportunity by organization

Line 148: AND oki_utl_pub.g_contract_limit

144: AND shd.is_new_yn IS NULL
145: AND shd.date_signed IS NULL
146: AND shd.date_canceled IS NULL
147: AND shd.contract_amount BETWEEN 0
148: AND oki_utl_pub.g_contract_limit
149: AND shd.authoring_org_id = p_authoring_org_id
150: GROUP BY shd.authoring_org_id
151: ORDER BY value
152: ;

Line 168: AND oki_utl_pub.g_contract_limit

164: AND shd.date_approved <= p_qtr_end_date
165: AND shd.end_date BETWEEN p_qtr_start_date AND p_qtr_end_date
166: AND shd.date_terminated IS NULL
167: AND shd.base_contract_amount BETWEEN 0
168: AND oki_utl_pub.g_contract_limit
169: ;
170:
171: -- Retrieve contracts that are expiring in the quarter
172: CURSOR g_k_exp_in_qtr_by_org_csr

Line 186: AND oki_utl_pub.g_contract_limit

182: AND shd.date_approved <= p_qtr_end_date
183: AND shd.end_date BETWEEN p_qtr_start_date AND p_qtr_end_date
184: AND shd.date_terminated IS NULL
185: AND shd.base_contract_amount BETWEEN 0
186: AND oki_utl_pub.g_contract_limit
187: AND shd.authoring_org_id = p_authoring_org_id
188: ;
189: /*
190: -- Contracts that have been renewed in the quarter

Line 206: AND oki_utl_pub.g_contract_limit

202: AND shd.date_signed IS NOT NULL
203: AND shd.start_date BETWEEN p_qtr_start_date AND p_qtr_end_date
204: AND GREATEST(shd.date_signed, shd.date_approved) <= p_qtr_end_date
205: AND shd.base_contract_amount BETWEEN 0
206: AND oki_utl_pub.g_contract_limit
207: AND shd.authoring_org_id = p_authoring_org_id
208: ;
209: */
210:

Line 250: oki_utl_pub.g_summary_build_date BETWEEN glpr.start_date

246: gl_periods glpr
247: , gl_sets_of_books sob
248: , hr_organization_information oin
249: WHERE
250: oki_utl_pub.g_summary_build_date BETWEEN glpr.start_date
251: AND glpr.end_date
252: AND glpr.period_set_name = sob.period_set_name
253: AND glpr.period_type = sob.accounted_period_type
254: AND glpr.adjustment_period_flag = 'N'

Line 266: oki_utl_pub.g_glpr_start_date := rec_l_gl_period_csr.start_date ;

262: OPEN l_gl_period_csr ;
263: FETCH l_gl_period_csr INTO rec_l_gl_period_csr ;
264: IF l_gl_period_csr%FOUND THEN
265: -- Set current year start / end information
266: oki_utl_pub.g_glpr_start_date := rec_l_gl_period_csr.start_date ;
267: oki_utl_pub.g_glpr_end_date := rec_l_gl_period_csr.end_date ;
268: oki_utl_pub.g_glpr_qtr_start_date := rec_l_gl_period_csr.quarter_start_date ;
269: oki_utl_pub.g_glpr_qtr_end_date :=
270: ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, 3 ) - 1 ;

Line 267: oki_utl_pub.g_glpr_end_date := rec_l_gl_period_csr.end_date ;

263: FETCH l_gl_period_csr INTO rec_l_gl_period_csr ;
264: IF l_gl_period_csr%FOUND THEN
265: -- Set current year start / end information
266: oki_utl_pub.g_glpr_start_date := rec_l_gl_period_csr.start_date ;
267: oki_utl_pub.g_glpr_end_date := rec_l_gl_period_csr.end_date ;
268: oki_utl_pub.g_glpr_qtr_start_date := rec_l_gl_period_csr.quarter_start_date ;
269: oki_utl_pub.g_glpr_qtr_end_date :=
270: ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, 3 ) - 1 ;
271: oki_utl_pub.g_glpr_qtr_num := rec_l_gl_period_csr.quarter_num ;

Line 268: oki_utl_pub.g_glpr_qtr_start_date := rec_l_gl_period_csr.quarter_start_date ;

264: IF l_gl_period_csr%FOUND THEN
265: -- Set current year start / end information
266: oki_utl_pub.g_glpr_start_date := rec_l_gl_period_csr.start_date ;
267: oki_utl_pub.g_glpr_end_date := rec_l_gl_period_csr.end_date ;
268: oki_utl_pub.g_glpr_qtr_start_date := rec_l_gl_period_csr.quarter_start_date ;
269: oki_utl_pub.g_glpr_qtr_end_date :=
270: ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, 3 ) - 1 ;
271: oki_utl_pub.g_glpr_qtr_num := rec_l_gl_period_csr.quarter_num ;
272: oki_utl_pub.g_glpr_year_start_date := rec_l_gl_period_csr.year_start_date ;

Line 269: oki_utl_pub.g_glpr_qtr_end_date :=

265: -- Set current year start / end information
266: oki_utl_pub.g_glpr_start_date := rec_l_gl_period_csr.start_date ;
267: oki_utl_pub.g_glpr_end_date := rec_l_gl_period_csr.end_date ;
268: oki_utl_pub.g_glpr_qtr_start_date := rec_l_gl_period_csr.quarter_start_date ;
269: oki_utl_pub.g_glpr_qtr_end_date :=
270: ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, 3 ) - 1 ;
271: oki_utl_pub.g_glpr_qtr_num := rec_l_gl_period_csr.quarter_num ;
272: oki_utl_pub.g_glpr_year_start_date := rec_l_gl_period_csr.year_start_date ;
273: oki_utl_pub.g_glpr_year_end_date :=

Line 270: ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, 3 ) - 1 ;

266: oki_utl_pub.g_glpr_start_date := rec_l_gl_period_csr.start_date ;
267: oki_utl_pub.g_glpr_end_date := rec_l_gl_period_csr.end_date ;
268: oki_utl_pub.g_glpr_qtr_start_date := rec_l_gl_period_csr.quarter_start_date ;
269: oki_utl_pub.g_glpr_qtr_end_date :=
270: ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, 3 ) - 1 ;
271: oki_utl_pub.g_glpr_qtr_num := rec_l_gl_period_csr.quarter_num ;
272: oki_utl_pub.g_glpr_year_start_date := rec_l_gl_period_csr.year_start_date ;
273: oki_utl_pub.g_glpr_year_end_date :=
274: ADD_MONTHS(TRUNC(oki_utl_pub.g_glpr_year_start_date,'YYYY' ), 12 ) -1 ;

Line 271: oki_utl_pub.g_glpr_qtr_num := rec_l_gl_period_csr.quarter_num ;

267: oki_utl_pub.g_glpr_end_date := rec_l_gl_period_csr.end_date ;
268: oki_utl_pub.g_glpr_qtr_start_date := rec_l_gl_period_csr.quarter_start_date ;
269: oki_utl_pub.g_glpr_qtr_end_date :=
270: ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, 3 ) - 1 ;
271: oki_utl_pub.g_glpr_qtr_num := rec_l_gl_period_csr.quarter_num ;
272: oki_utl_pub.g_glpr_year_start_date := rec_l_gl_period_csr.year_start_date ;
273: oki_utl_pub.g_glpr_year_end_date :=
274: ADD_MONTHS(TRUNC(oki_utl_pub.g_glpr_year_start_date,'YYYY' ), 12 ) -1 ;
275: oki_utl_pub.g_period_year := rec_l_gl_period_csr.period_year ;

Line 272: oki_utl_pub.g_glpr_year_start_date := rec_l_gl_period_csr.year_start_date ;

268: oki_utl_pub.g_glpr_qtr_start_date := rec_l_gl_period_csr.quarter_start_date ;
269: oki_utl_pub.g_glpr_qtr_end_date :=
270: ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, 3 ) - 1 ;
271: oki_utl_pub.g_glpr_qtr_num := rec_l_gl_period_csr.quarter_num ;
272: oki_utl_pub.g_glpr_year_start_date := rec_l_gl_period_csr.year_start_date ;
273: oki_utl_pub.g_glpr_year_end_date :=
274: ADD_MONTHS(TRUNC(oki_utl_pub.g_glpr_year_start_date,'YYYY' ), 12 ) -1 ;
275: oki_utl_pub.g_period_year := rec_l_gl_period_csr.period_year ;
276: oki_utl_pub.g_week_start_date := ( oki_utl_pub.g_summary_build_date -

Line 273: oki_utl_pub.g_glpr_year_end_date :=

269: oki_utl_pub.g_glpr_qtr_end_date :=
270: ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, 3 ) - 1 ;
271: oki_utl_pub.g_glpr_qtr_num := rec_l_gl_period_csr.quarter_num ;
272: oki_utl_pub.g_glpr_year_start_date := rec_l_gl_period_csr.year_start_date ;
273: oki_utl_pub.g_glpr_year_end_date :=
274: ADD_MONTHS(TRUNC(oki_utl_pub.g_glpr_year_start_date,'YYYY' ), 12 ) -1 ;
275: oki_utl_pub.g_period_year := rec_l_gl_period_csr.period_year ;
276: oki_utl_pub.g_week_start_date := ( oki_utl_pub.g_summary_build_date -
277: TO_NUMBER(TO_CHAR(oki_utl_pub.g_summary_build_date,'D' )) -1) ;

Line 274: ADD_MONTHS(TRUNC(oki_utl_pub.g_glpr_year_start_date,'YYYY' ), 12 ) -1 ;

270: ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, 3 ) - 1 ;
271: oki_utl_pub.g_glpr_qtr_num := rec_l_gl_period_csr.quarter_num ;
272: oki_utl_pub.g_glpr_year_start_date := rec_l_gl_period_csr.year_start_date ;
273: oki_utl_pub.g_glpr_year_end_date :=
274: ADD_MONTHS(TRUNC(oki_utl_pub.g_glpr_year_start_date,'YYYY' ), 12 ) -1 ;
275: oki_utl_pub.g_period_year := rec_l_gl_period_csr.period_year ;
276: oki_utl_pub.g_week_start_date := ( oki_utl_pub.g_summary_build_date -
277: TO_NUMBER(TO_CHAR(oki_utl_pub.g_summary_build_date,'D' )) -1) ;
278:

Line 275: oki_utl_pub.g_period_year := rec_l_gl_period_csr.period_year ;

271: oki_utl_pub.g_glpr_qtr_num := rec_l_gl_period_csr.quarter_num ;
272: oki_utl_pub.g_glpr_year_start_date := rec_l_gl_period_csr.year_start_date ;
273: oki_utl_pub.g_glpr_year_end_date :=
274: ADD_MONTHS(TRUNC(oki_utl_pub.g_glpr_year_start_date,'YYYY' ), 12 ) -1 ;
275: oki_utl_pub.g_period_year := rec_l_gl_period_csr.period_year ;
276: oki_utl_pub.g_week_start_date := ( oki_utl_pub.g_summary_build_date -
277: TO_NUMBER(TO_CHAR(oki_utl_pub.g_summary_build_date,'D' )) -1) ;
278:
279: -- Set prior year start / end information

Line 276: oki_utl_pub.g_week_start_date := ( oki_utl_pub.g_summary_build_date -

272: oki_utl_pub.g_glpr_year_start_date := rec_l_gl_period_csr.year_start_date ;
273: oki_utl_pub.g_glpr_year_end_date :=
274: ADD_MONTHS(TRUNC(oki_utl_pub.g_glpr_year_start_date,'YYYY' ), 12 ) -1 ;
275: oki_utl_pub.g_period_year := rec_l_gl_period_csr.period_year ;
276: oki_utl_pub.g_week_start_date := ( oki_utl_pub.g_summary_build_date -
277: TO_NUMBER(TO_CHAR(oki_utl_pub.g_summary_build_date,'D' )) -1) ;
278:
279: -- Set prior year start / end information
280: oki_utl_pub.g_py_summary_build_date

Line 277: TO_NUMBER(TO_CHAR(oki_utl_pub.g_summary_build_date,'D' )) -1) ;

273: oki_utl_pub.g_glpr_year_end_date :=
274: ADD_MONTHS(TRUNC(oki_utl_pub.g_glpr_year_start_date,'YYYY' ), 12 ) -1 ;
275: oki_utl_pub.g_period_year := rec_l_gl_period_csr.period_year ;
276: oki_utl_pub.g_week_start_date := ( oki_utl_pub.g_summary_build_date -
277: TO_NUMBER(TO_CHAR(oki_utl_pub.g_summary_build_date,'D' )) -1) ;
278:
279: -- Set prior year start / end information
280: oki_utl_pub.g_py_summary_build_date
281: := ADD_MONTHS(oki_utl_pub.g_summary_build_date, -12) ;

Line 280: oki_utl_pub.g_py_summary_build_date

276: oki_utl_pub.g_week_start_date := ( oki_utl_pub.g_summary_build_date -
277: TO_NUMBER(TO_CHAR(oki_utl_pub.g_summary_build_date,'D' )) -1) ;
278:
279: -- Set prior year start / end information
280: oki_utl_pub.g_py_summary_build_date
281: := ADD_MONTHS(oki_utl_pub.g_summary_build_date, -12) ;
282: oki_utl_pub.g_py_glpr_start_date
283: := ADD_MONTHS(oki_utl_pub.g_glpr_start_date, -12 ) ;
284: oki_utl_pub.g_py_glpr_end_date

Line 281: := ADD_MONTHS(oki_utl_pub.g_summary_build_date, -12) ;

277: TO_NUMBER(TO_CHAR(oki_utl_pub.g_summary_build_date,'D' )) -1) ;
278:
279: -- Set prior year start / end information
280: oki_utl_pub.g_py_summary_build_date
281: := ADD_MONTHS(oki_utl_pub.g_summary_build_date, -12) ;
282: oki_utl_pub.g_py_glpr_start_date
283: := ADD_MONTHS(oki_utl_pub.g_glpr_start_date, -12 ) ;
284: oki_utl_pub.g_py_glpr_end_date
285: := ADD_MONTHS(oki_utl_pub.g_glpr_end_date, -12) ;

Line 282: oki_utl_pub.g_py_glpr_start_date

278:
279: -- Set prior year start / end information
280: oki_utl_pub.g_py_summary_build_date
281: := ADD_MONTHS(oki_utl_pub.g_summary_build_date, -12) ;
282: oki_utl_pub.g_py_glpr_start_date
283: := ADD_MONTHS(oki_utl_pub.g_glpr_start_date, -12 ) ;
284: oki_utl_pub.g_py_glpr_end_date
285: := ADD_MONTHS(oki_utl_pub.g_glpr_end_date, -12) ;
286: oki_utl_pub.g_py_glpr_qtr_start_date

Line 283: := ADD_MONTHS(oki_utl_pub.g_glpr_start_date, -12 ) ;

279: -- Set prior year start / end information
280: oki_utl_pub.g_py_summary_build_date
281: := ADD_MONTHS(oki_utl_pub.g_summary_build_date, -12) ;
282: oki_utl_pub.g_py_glpr_start_date
283: := ADD_MONTHS(oki_utl_pub.g_glpr_start_date, -12 ) ;
284: oki_utl_pub.g_py_glpr_end_date
285: := ADD_MONTHS(oki_utl_pub.g_glpr_end_date, -12) ;
286: oki_utl_pub.g_py_glpr_qtr_start_date
287: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, -12 ) ;

Line 284: oki_utl_pub.g_py_glpr_end_date

280: oki_utl_pub.g_py_summary_build_date
281: := ADD_MONTHS(oki_utl_pub.g_summary_build_date, -12) ;
282: oki_utl_pub.g_py_glpr_start_date
283: := ADD_MONTHS(oki_utl_pub.g_glpr_start_date, -12 ) ;
284: oki_utl_pub.g_py_glpr_end_date
285: := ADD_MONTHS(oki_utl_pub.g_glpr_end_date, -12) ;
286: oki_utl_pub.g_py_glpr_qtr_start_date
287: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, -12 ) ;
288: oki_utl_pub.g_py_glpr_qtr_end_date

Line 285: := ADD_MONTHS(oki_utl_pub.g_glpr_end_date, -12) ;

281: := ADD_MONTHS(oki_utl_pub.g_summary_build_date, -12) ;
282: oki_utl_pub.g_py_glpr_start_date
283: := ADD_MONTHS(oki_utl_pub.g_glpr_start_date, -12 ) ;
284: oki_utl_pub.g_py_glpr_end_date
285: := ADD_MONTHS(oki_utl_pub.g_glpr_end_date, -12) ;
286: oki_utl_pub.g_py_glpr_qtr_start_date
287: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, -12 ) ;
288: oki_utl_pub.g_py_glpr_qtr_end_date
289: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_end_date, -12 ) ;

Line 286: oki_utl_pub.g_py_glpr_qtr_start_date

282: oki_utl_pub.g_py_glpr_start_date
283: := ADD_MONTHS(oki_utl_pub.g_glpr_start_date, -12 ) ;
284: oki_utl_pub.g_py_glpr_end_date
285: := ADD_MONTHS(oki_utl_pub.g_glpr_end_date, -12) ;
286: oki_utl_pub.g_py_glpr_qtr_start_date
287: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, -12 ) ;
288: oki_utl_pub.g_py_glpr_qtr_end_date
289: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_end_date, -12 ) ;
290: oki_utl_pub.g_py_glpr_qtr_num

Line 287: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, -12 ) ;

283: := ADD_MONTHS(oki_utl_pub.g_glpr_start_date, -12 ) ;
284: oki_utl_pub.g_py_glpr_end_date
285: := ADD_MONTHS(oki_utl_pub.g_glpr_end_date, -12) ;
286: oki_utl_pub.g_py_glpr_qtr_start_date
287: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, -12 ) ;
288: oki_utl_pub.g_py_glpr_qtr_end_date
289: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_end_date, -12 ) ;
290: oki_utl_pub.g_py_glpr_qtr_num
291: := oki_utl_pub.g_glpr_qtr_num ;

Line 288: oki_utl_pub.g_py_glpr_qtr_end_date

284: oki_utl_pub.g_py_glpr_end_date
285: := ADD_MONTHS(oki_utl_pub.g_glpr_end_date, -12) ;
286: oki_utl_pub.g_py_glpr_qtr_start_date
287: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, -12 ) ;
288: oki_utl_pub.g_py_glpr_qtr_end_date
289: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_end_date, -12 ) ;
290: oki_utl_pub.g_py_glpr_qtr_num
291: := oki_utl_pub.g_glpr_qtr_num ;
292: oki_utl_pub.g_py_glpr_year_start_date

Line 289: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_end_date, -12 ) ;

285: := ADD_MONTHS(oki_utl_pub.g_glpr_end_date, -12) ;
286: oki_utl_pub.g_py_glpr_qtr_start_date
287: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, -12 ) ;
288: oki_utl_pub.g_py_glpr_qtr_end_date
289: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_end_date, -12 ) ;
290: oki_utl_pub.g_py_glpr_qtr_num
291: := oki_utl_pub.g_glpr_qtr_num ;
292: oki_utl_pub.g_py_glpr_year_start_date
293: := ADD_MONTHS(oki_utl_pub.g_glpr_year_start_date, -12 ) ;

Line 290: oki_utl_pub.g_py_glpr_qtr_num

286: oki_utl_pub.g_py_glpr_qtr_start_date
287: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, -12 ) ;
288: oki_utl_pub.g_py_glpr_qtr_end_date
289: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_end_date, -12 ) ;
290: oki_utl_pub.g_py_glpr_qtr_num
291: := oki_utl_pub.g_glpr_qtr_num ;
292: oki_utl_pub.g_py_glpr_year_start_date
293: := ADD_MONTHS(oki_utl_pub.g_glpr_year_start_date, -12 ) ;
294: oki_utl_pub.g_py_glpr_year_end_date

Line 291: := oki_utl_pub.g_glpr_qtr_num ;

287: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_start_date, -12 ) ;
288: oki_utl_pub.g_py_glpr_qtr_end_date
289: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_end_date, -12 ) ;
290: oki_utl_pub.g_py_glpr_qtr_num
291: := oki_utl_pub.g_glpr_qtr_num ;
292: oki_utl_pub.g_py_glpr_year_start_date
293: := ADD_MONTHS(oki_utl_pub.g_glpr_year_start_date, -12 ) ;
294: oki_utl_pub.g_py_glpr_year_end_date
295: := ADD_MONTHS(oki_utl_pub.g_glpr_year_end_date, -12 ) ;

Line 292: oki_utl_pub.g_py_glpr_year_start_date

288: oki_utl_pub.g_py_glpr_qtr_end_date
289: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_end_date, -12 ) ;
290: oki_utl_pub.g_py_glpr_qtr_num
291: := oki_utl_pub.g_glpr_qtr_num ;
292: oki_utl_pub.g_py_glpr_year_start_date
293: := ADD_MONTHS(oki_utl_pub.g_glpr_year_start_date, -12 ) ;
294: oki_utl_pub.g_py_glpr_year_end_date
295: := ADD_MONTHS(oki_utl_pub.g_glpr_year_end_date, -12 ) ;
296: oki_utl_pub.g_py_period_year

Line 293: := ADD_MONTHS(oki_utl_pub.g_glpr_year_start_date, -12 ) ;

289: := ADD_MONTHS(oki_utl_pub.g_glpr_qtr_end_date, -12 ) ;
290: oki_utl_pub.g_py_glpr_qtr_num
291: := oki_utl_pub.g_glpr_qtr_num ;
292: oki_utl_pub.g_py_glpr_year_start_date
293: := ADD_MONTHS(oki_utl_pub.g_glpr_year_start_date, -12 ) ;
294: oki_utl_pub.g_py_glpr_year_end_date
295: := ADD_MONTHS(oki_utl_pub.g_glpr_year_end_date, -12 ) ;
296: oki_utl_pub.g_py_period_year
297: := oki_utl_pub.g_period_year -1 ;

Line 294: oki_utl_pub.g_py_glpr_year_end_date

290: oki_utl_pub.g_py_glpr_qtr_num
291: := oki_utl_pub.g_glpr_qtr_num ;
292: oki_utl_pub.g_py_glpr_year_start_date
293: := ADD_MONTHS(oki_utl_pub.g_glpr_year_start_date, -12 ) ;
294: oki_utl_pub.g_py_glpr_year_end_date
295: := ADD_MONTHS(oki_utl_pub.g_glpr_year_end_date, -12 ) ;
296: oki_utl_pub.g_py_period_year
297: := oki_utl_pub.g_period_year -1 ;
298: oki_utl_pub.g_py_week_start_date

Line 295: := ADD_MONTHS(oki_utl_pub.g_glpr_year_end_date, -12 ) ;

291: := oki_utl_pub.g_glpr_qtr_num ;
292: oki_utl_pub.g_py_glpr_year_start_date
293: := ADD_MONTHS(oki_utl_pub.g_glpr_year_start_date, -12 ) ;
294: oki_utl_pub.g_py_glpr_year_end_date
295: := ADD_MONTHS(oki_utl_pub.g_glpr_year_end_date, -12 ) ;
296: oki_utl_pub.g_py_period_year
297: := oki_utl_pub.g_period_year -1 ;
298: oki_utl_pub.g_py_week_start_date
299: := ADD_MONTHS(oki_utl_pub.g_week_start_date, -12 ) ;

Line 296: oki_utl_pub.g_py_period_year

292: oki_utl_pub.g_py_glpr_year_start_date
293: := ADD_MONTHS(oki_utl_pub.g_glpr_year_start_date, -12 ) ;
294: oki_utl_pub.g_py_glpr_year_end_date
295: := ADD_MONTHS(oki_utl_pub.g_glpr_year_end_date, -12 ) ;
296: oki_utl_pub.g_py_period_year
297: := oki_utl_pub.g_period_year -1 ;
298: oki_utl_pub.g_py_week_start_date
299: := ADD_MONTHS(oki_utl_pub.g_week_start_date, -12 ) ;
300: END IF ;

Line 297: := oki_utl_pub.g_period_year -1 ;

293: := ADD_MONTHS(oki_utl_pub.g_glpr_year_start_date, -12 ) ;
294: oki_utl_pub.g_py_glpr_year_end_date
295: := ADD_MONTHS(oki_utl_pub.g_glpr_year_end_date, -12 ) ;
296: oki_utl_pub.g_py_period_year
297: := oki_utl_pub.g_period_year -1 ;
298: oki_utl_pub.g_py_week_start_date
299: := ADD_MONTHS(oki_utl_pub.g_week_start_date, -12 ) ;
300: END IF ;
301: CLOSE l_gl_period_csr ;

Line 298: oki_utl_pub.g_py_week_start_date

294: oki_utl_pub.g_py_glpr_year_end_date
295: := ADD_MONTHS(oki_utl_pub.g_glpr_year_end_date, -12 ) ;
296: oki_utl_pub.g_py_period_year
297: := oki_utl_pub.g_period_year -1 ;
298: oki_utl_pub.g_py_week_start_date
299: := ADD_MONTHS(oki_utl_pub.g_week_start_date, -12 ) ;
300: END IF ;
301: CLOSE l_gl_period_csr ;
302: END get_gl_period_date ;

Line 299: := ADD_MONTHS(oki_utl_pub.g_week_start_date, -12 ) ;

295: := ADD_MONTHS(oki_utl_pub.g_glpr_year_end_date, -12 ) ;
296: oki_utl_pub.g_py_period_year
297: := oki_utl_pub.g_period_year -1 ;
298: oki_utl_pub.g_py_week_start_date
299: := ADD_MONTHS(oki_utl_pub.g_week_start_date, -12 ) ;
300: END IF ;
301: CLOSE l_gl_period_csr ;
302: END get_gl_period_date ;
303: