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_LOAD_RBK_PVT dependencies on OKI_UTL_PVT

Line 236: rec_l_tactk_by_org_csr oki_utl_pvt.g_tactk_by_org_csr_row ;

232:
233: l_bin_code_meaning VARCHAR2(240) := NULL ;
234: l_bin_code_seq NUMBER := NULL ;
235:
236: rec_l_tactk_by_org_csr oki_utl_pvt.g_tactk_by_org_csr_row ;
237: rec_l_k_exp_in_qtr_by_org_csr oki_utl_pvt.g_k_exp_in_qtr_by_org_csr_row ;
238: rec_l_bin_disp_lkup_csr oki_utl_pvt.g_bin_disp_lkup_csr_row ;
239:
240: -- Holds the current measure values for the renewal bookings bin

Line 237: rec_l_k_exp_in_qtr_by_org_csr oki_utl_pvt.g_k_exp_in_qtr_by_org_csr_row ;

233: l_bin_code_meaning VARCHAR2(240) := NULL ;
234: l_bin_code_seq NUMBER := NULL ;
235:
236: rec_l_tactk_by_org_csr oki_utl_pvt.g_tactk_by_org_csr_row ;
237: rec_l_k_exp_in_qtr_by_org_csr oki_utl_pvt.g_k_exp_in_qtr_by_org_csr_row ;
238: rec_l_bin_disp_lkup_csr oki_utl_pvt.g_bin_disp_lkup_csr_row ;
239:
240: -- Holds the current measure values for the renewal bookings bin
241: l_curr_b_act_k NUMBER := 0 ;

Line 238: rec_l_bin_disp_lkup_csr oki_utl_pvt.g_bin_disp_lkup_csr_row ;

234: l_bin_code_seq NUMBER := NULL ;
235:
236: rec_l_tactk_by_org_csr oki_utl_pvt.g_tactk_by_org_csr_row ;
237: rec_l_k_exp_in_qtr_by_org_csr oki_utl_pvt.g_k_exp_in_qtr_by_org_csr_row ;
238: rec_l_bin_disp_lkup_csr oki_utl_pvt.g_bin_disp_lkup_csr_row ;
239:
240: -- Holds the current measure values for the renewal bookings bin
241: l_curr_b_act_k NUMBER := 0 ;
242: l_curr_k_exp_in_qtr NUMBER := 0 ;

Line 383: FOR rec_g_org_csr IN oki_utl_pvt.g_org_csr LOOP

379:
380: << g_org_csr_loop >>
381: -- Loop through all the organizations to calculate the
382: -- appropriate amounts
383: FOR rec_g_org_csr IN oki_utl_pvt.g_org_csr LOOP
384:
385: --
386: -- Process Beginning Active Contracts record
387: --

Line 394: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

390:
391: -- Get the bin display lookup values
392: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
393: l_measure_type || '.' ;
394: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
395: , oki_load_rbk_pvt.g_b_act_k_code ) ;
396: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
397: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
398: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 396: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

392: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
393: l_measure_type || '.' ;
394: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
395: , oki_load_rbk_pvt.g_b_act_k_code ) ;
396: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
397: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
398: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
399: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
400: ELSE

Line 397: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

393: l_measure_type || '.' ;
394: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
395: , oki_load_rbk_pvt.g_b_act_k_code ) ;
396: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
397: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
398: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
399: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
400: ELSE
401: RAISE NO_DATA_FOUND ;

Line 403: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

399: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
400: ELSE
401: RAISE NO_DATA_FOUND ;
402: END IF ;
403: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
404:
405: -- Get the current value
406: l_loc := 'Opening cursor to determine current ' ||
407: l_measure_type || '.' ;

Line 408: OPEN oki_utl_pvt.g_tactk_by_org_csr (

404:
405: -- Get the current value
406: l_loc := 'Opening cursor to determine current ' ||
407: l_measure_type || '.' ;
408: OPEN oki_utl_pvt.g_tactk_by_org_csr (
409: oki_utl_pub.g_glpr_qtr_start_date
410: , rec_g_org_csr.authoring_org_id ) ;
411: FETCH oki_utl_pvt.g_tactk_by_org_csr INTO rec_l_tactk_by_org_csr ;
412: IF oki_utl_pvt.g_tactk_by_org_csr%FOUND THEN

Line 411: FETCH oki_utl_pvt.g_tactk_by_org_csr INTO rec_l_tactk_by_org_csr ;

407: l_measure_type || '.' ;
408: OPEN oki_utl_pvt.g_tactk_by_org_csr (
409: oki_utl_pub.g_glpr_qtr_start_date
410: , rec_g_org_csr.authoring_org_id ) ;
411: FETCH oki_utl_pvt.g_tactk_by_org_csr INTO rec_l_tactk_by_org_csr ;
412: IF oki_utl_pvt.g_tactk_by_org_csr%FOUND THEN
413: l_curr_b_act_k := rec_l_tactk_by_org_csr.value ;
414: END IF ;
415: CLOSE oki_utl_pvt.g_tactk_by_org_csr ;

Line 412: IF oki_utl_pvt.g_tactk_by_org_csr%FOUND THEN

408: OPEN oki_utl_pvt.g_tactk_by_org_csr (
409: oki_utl_pub.g_glpr_qtr_start_date
410: , rec_g_org_csr.authoring_org_id ) ;
411: FETCH oki_utl_pvt.g_tactk_by_org_csr INTO rec_l_tactk_by_org_csr ;
412: IF oki_utl_pvt.g_tactk_by_org_csr%FOUND THEN
413: l_curr_b_act_k := rec_l_tactk_by_org_csr.value ;
414: END IF ;
415: CLOSE oki_utl_pvt.g_tactk_by_org_csr ;
416:

Line 415: CLOSE oki_utl_pvt.g_tactk_by_org_csr ;

411: FETCH oki_utl_pvt.g_tactk_by_org_csr INTO rec_l_tactk_by_org_csr ;
412: IF oki_utl_pvt.g_tactk_by_org_csr%FOUND THEN
413: l_curr_b_act_k := rec_l_tactk_by_org_csr.value ;
414: END IF ;
415: CLOSE oki_utl_pvt.g_tactk_by_org_csr ;
416:
417: -- Get the previous value
418: l_loc := 'Opening Cursor to determine previous ' ||
419: l_measure_type || '.' ;

Line 420: OPEN oki_utl_pvt.g_tactk_by_org_csr (

416:
417: -- Get the previous value
418: l_loc := 'Opening Cursor to determine previous ' ||
419: l_measure_type || '.' ;
420: OPEN oki_utl_pvt.g_tactk_by_org_csr (
421: oki_utl_pub.g_py_glpr_qtr_start_date,
422: rec_g_org_csr.authoring_org_id ) ;
423: FETCH oki_utl_pvt.g_tactk_by_org_csr INTO rec_l_tactk_by_org_csr ;
424: IF oki_utl_pvt.g_tactk_by_org_csr%FOUND THEN

Line 423: FETCH oki_utl_pvt.g_tactk_by_org_csr INTO rec_l_tactk_by_org_csr ;

419: l_measure_type || '.' ;
420: OPEN oki_utl_pvt.g_tactk_by_org_csr (
421: oki_utl_pub.g_py_glpr_qtr_start_date,
422: rec_g_org_csr.authoring_org_id ) ;
423: FETCH oki_utl_pvt.g_tactk_by_org_csr INTO rec_l_tactk_by_org_csr ;
424: IF oki_utl_pvt.g_tactk_by_org_csr%FOUND THEN
425: l_prev_b_act_k := rec_l_tactk_by_org_csr.value ;
426: END IF ;
427: CLOSE oki_utl_pvt.g_tactk_by_org_csr ;

Line 424: IF oki_utl_pvt.g_tactk_by_org_csr%FOUND THEN

420: OPEN oki_utl_pvt.g_tactk_by_org_csr (
421: oki_utl_pub.g_py_glpr_qtr_start_date,
422: rec_g_org_csr.authoring_org_id ) ;
423: FETCH oki_utl_pvt.g_tactk_by_org_csr INTO rec_l_tactk_by_org_csr ;
424: IF oki_utl_pvt.g_tactk_by_org_csr%FOUND THEN
425: l_prev_b_act_k := rec_l_tactk_by_org_csr.value ;
426: END IF ;
427: CLOSE oki_utl_pvt.g_tactk_by_org_csr ;
428:

Line 427: CLOSE oki_utl_pvt.g_tactk_by_org_csr ;

423: FETCH oki_utl_pvt.g_tactk_by_org_csr INTO rec_l_tactk_by_org_csr ;
424: IF oki_utl_pvt.g_tactk_by_org_csr%FOUND THEN
425: l_prev_b_act_k := rec_l_tactk_by_org_csr.value ;
426: END IF ;
427: CLOSE oki_utl_pvt.g_tactk_by_org_csr ;
428:
429: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
430: -- Determine if the record is a new one or an existing one
431: OPEN oki_load_rbk_pvt.g_rbk_csr (

Line 487: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

483:
484: -- Get the bin display lookup values
485: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
486: l_measure_type || '.' ;
487: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
488: , oki_load_rbk_pvt.g_exp_in_qtr_code ) ;
489: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
490: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
491: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 489: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

485: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
486: l_measure_type || '.' ;
487: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
488: , oki_load_rbk_pvt.g_exp_in_qtr_code ) ;
489: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
490: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
491: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
492: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
493: ELSE

Line 490: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

486: l_measure_type || '.' ;
487: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
488: , oki_load_rbk_pvt.g_exp_in_qtr_code ) ;
489: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
490: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
491: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
492: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
493: ELSE
494: RAISE NO_DATA_FOUND ;

Line 496: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

492: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
493: ELSE
494: RAISE NO_DATA_FOUND ;
495: END IF ;
496: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
497:
498: -- Get the current value
499: l_loc := 'Opening cursor to determine current ' ||
500: l_measure_type || '.' ;

Line 501: OPEN oki_utl_pvt.g_k_exp_in_qtr_by_org_csr (

497:
498: -- Get the current value
499: l_loc := 'Opening cursor to determine current ' ||
500: l_measure_type || '.' ;
501: OPEN oki_utl_pvt.g_k_exp_in_qtr_by_org_csr (
502: oki_utl_pub.g_glpr_qtr_start_date
503: , oki_utl_pub.g_glpr_qtr_end_date
504: , rec_g_org_csr.authoring_org_id ) ;
505: FETCH oki_utl_pvt.g_k_exp_in_qtr_by_org_csr INTO

Line 505: FETCH oki_utl_pvt.g_k_exp_in_qtr_by_org_csr INTO

501: OPEN oki_utl_pvt.g_k_exp_in_qtr_by_org_csr (
502: oki_utl_pub.g_glpr_qtr_start_date
503: , oki_utl_pub.g_glpr_qtr_end_date
504: , rec_g_org_csr.authoring_org_id ) ;
505: FETCH oki_utl_pvt.g_k_exp_in_qtr_by_org_csr INTO
506: rec_l_k_exp_in_qtr_by_org_csr ;
507: IF oki_utl_pvt.g_k_exp_in_qtr_by_org_csr%FOUND THEN
508: l_curr_k_exp_in_qtr := rec_l_k_exp_in_qtr_by_org_csr.value ;
509: END IF ;

Line 507: IF oki_utl_pvt.g_k_exp_in_qtr_by_org_csr%FOUND THEN

503: , oki_utl_pub.g_glpr_qtr_end_date
504: , rec_g_org_csr.authoring_org_id ) ;
505: FETCH oki_utl_pvt.g_k_exp_in_qtr_by_org_csr INTO
506: rec_l_k_exp_in_qtr_by_org_csr ;
507: IF oki_utl_pvt.g_k_exp_in_qtr_by_org_csr%FOUND THEN
508: l_curr_k_exp_in_qtr := rec_l_k_exp_in_qtr_by_org_csr.value ;
509: END IF ;
510: CLOSE oki_utl_pvt.g_k_exp_in_qtr_by_org_csr ;
511:

Line 510: CLOSE oki_utl_pvt.g_k_exp_in_qtr_by_org_csr ;

506: rec_l_k_exp_in_qtr_by_org_csr ;
507: IF oki_utl_pvt.g_k_exp_in_qtr_by_org_csr%FOUND THEN
508: l_curr_k_exp_in_qtr := rec_l_k_exp_in_qtr_by_org_csr.value ;
509: END IF ;
510: CLOSE oki_utl_pvt.g_k_exp_in_qtr_by_org_csr ;
511:
512: -- Get the previous value
513: l_loc := 'Opening Cursor to determine previous ' ||
514: l_measure_type || '.' ;

Line 515: OPEN oki_utl_pvt.g_k_exp_in_qtr_by_org_csr (

511:
512: -- Get the previous value
513: l_loc := 'Opening Cursor to determine previous ' ||
514: l_measure_type || '.' ;
515: OPEN oki_utl_pvt.g_k_exp_in_qtr_by_org_csr (
516: oki_utl_pub.g_py_glpr_qtr_start_date
517: , oki_utl_pub.g_py_glpr_qtr_end_date
518: , rec_g_org_csr.authoring_org_id ) ;
519: FETCH oki_utl_pvt.g_k_exp_in_qtr_by_org_csr INTO

Line 519: FETCH oki_utl_pvt.g_k_exp_in_qtr_by_org_csr INTO

515: OPEN oki_utl_pvt.g_k_exp_in_qtr_by_org_csr (
516: oki_utl_pub.g_py_glpr_qtr_start_date
517: , oki_utl_pub.g_py_glpr_qtr_end_date
518: , rec_g_org_csr.authoring_org_id ) ;
519: FETCH oki_utl_pvt.g_k_exp_in_qtr_by_org_csr INTO
520: rec_l_k_exp_in_qtr_by_org_csr ;
521: IF oki_utl_pvt.g_k_exp_in_qtr_by_org_csr%FOUND THEN
522: l_prev_k_exp_in_qtr := rec_l_k_exp_in_qtr_by_org_csr.value ;
523: END IF ;

Line 521: IF oki_utl_pvt.g_k_exp_in_qtr_by_org_csr%FOUND THEN

517: , oki_utl_pub.g_py_glpr_qtr_end_date
518: , rec_g_org_csr.authoring_org_id ) ;
519: FETCH oki_utl_pvt.g_k_exp_in_qtr_by_org_csr INTO
520: rec_l_k_exp_in_qtr_by_org_csr ;
521: IF oki_utl_pvt.g_k_exp_in_qtr_by_org_csr%FOUND THEN
522: l_prev_k_exp_in_qtr := rec_l_k_exp_in_qtr_by_org_csr.value ;
523: END IF ;
524: CLOSE oki_utl_pvt.g_k_exp_in_qtr_by_org_csr ;
525:

Line 524: CLOSE oki_utl_pvt.g_k_exp_in_qtr_by_org_csr ;

520: rec_l_k_exp_in_qtr_by_org_csr ;
521: IF oki_utl_pvt.g_k_exp_in_qtr_by_org_csr%FOUND THEN
522: l_prev_k_exp_in_qtr := rec_l_k_exp_in_qtr_by_org_csr.value ;
523: END IF ;
524: CLOSE oki_utl_pvt.g_k_exp_in_qtr_by_org_csr ;
525:
526: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
527: -- Determine if the record is a new one or an existing one
528: OPEN oki_load_rbk_pvt.g_rbk_csr (

Line 584: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

580:
581: -- Get the bin display lookup values
582: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
583: l_measure_type || '.' ;
584: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
585: , oki_load_rbk_pvt.g_bklg_k_to_rnw_code ) ;
586: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
587: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
588: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 586: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

582: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
583: l_measure_type || '.' ;
584: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
585: , oki_load_rbk_pvt.g_bklg_k_to_rnw_code ) ;
586: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
587: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
588: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
589: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
590: ELSE

Line 587: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

583: l_measure_type || '.' ;
584: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
585: , oki_load_rbk_pvt.g_bklg_k_to_rnw_code ) ;
586: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
587: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
588: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
589: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
590: ELSE
591: RAISE NO_DATA_FOUND ;

Line 593: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

589: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
590: ELSE
591: RAISE NO_DATA_FOUND ;
592: END IF ;
593: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
594:
595: -- Get the current value
596: l_loc := 'Opening cursor to determine current ' ||
597: l_measure_type || '.' ;

Line 673: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

669:
670: -- Get the bin display lookup values
671: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
672: l_measure_type || '.' ;
673: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
674: , oki_load_rbk_pvt.g_b_rnwl_oppty_code ) ;
675: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
676: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
677: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 675: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

671: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
672: l_measure_type || '.' ;
673: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
674: , oki_load_rbk_pvt.g_b_rnwl_oppty_code ) ;
675: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
676: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
677: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
678: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
679: ELSE

Line 676: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

672: l_measure_type || '.' ;
673: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
674: , oki_load_rbk_pvt.g_b_rnwl_oppty_code ) ;
675: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
676: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
677: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
678: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
679: ELSE
680: RAISE NO_DATA_FOUND ;

Line 682: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

678: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
679: ELSE
680: RAISE NO_DATA_FOUND ;
681: END IF ;
682: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
683:
684: l_curr_b_rnwl_oppty := l_curr_k_exp_in_qtr + l_curr_bklg_k_to_rnw ;
685: l_prev_b_rnwl_oppty := l_prev_k_exp_in_qtr + l_prev_bklg_k_to_rnw ;
686:

Line 743: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

739:
740: -- Get the bin display lookup values
741: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
742: l_measure_type || '.' ;
743: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
744: , oki_load_rbk_pvt.g_bklg_k_rnwed_code ) ;
745: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
746: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
747: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 745: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

741: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
742: l_measure_type || '.' ;
743: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
744: , oki_load_rbk_pvt.g_bklg_k_rnwed_code ) ;
745: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
746: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
747: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
748: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
749: ELSE

Line 746: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

742: l_measure_type || '.' ;
743: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
744: , oki_load_rbk_pvt.g_bklg_k_rnwed_code ) ;
745: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
746: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
747: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
748: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
749: ELSE
750: RAISE NO_DATA_FOUND ;

Line 752: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

748: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
749: ELSE
750: RAISE NO_DATA_FOUND ;
751: END IF ;
752: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
753:
754: -- Get the current value
755: l_loc := 'Opening cursor to determine current ' ||
756: l_measure_type || '.' ;

Line 834: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

830:
831: -- Get the bin display lookup values
832: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
833: l_measure_type || '.' ;
834: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
835: , oki_load_rbk_pvt.g_k_rnwed_code ) ;
836: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
837: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
838: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 836: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

832: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
833: l_measure_type || '.' ;
834: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
835: , oki_load_rbk_pvt.g_k_rnwed_code ) ;
836: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
837: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
838: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
839: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
840: ELSE

Line 837: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

833: l_measure_type || '.' ;
834: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
835: , oki_load_rbk_pvt.g_k_rnwed_code ) ;
836: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
837: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
838: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
839: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
840: ELSE
841: RAISE NO_DATA_FOUND ;

Line 843: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

839: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
840: ELSE
841: RAISE NO_DATA_FOUND ;
842: END IF ;
843: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
844:
845: -- Get the current value
846: l_loc := 'Opening cursor to determine current ' ||
847: l_measure_type || '.' ;

Line 925: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

921:
922: -- Get the bin display lookup values
923: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
924: l_measure_type || '.' ;
925: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
926: , oki_load_rbk_pvt.g_new_bsn_code ) ;
927: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
928: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
929: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 927: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

923: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
924: l_measure_type || '.' ;
925: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
926: , oki_load_rbk_pvt.g_new_bsn_code ) ;
927: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
928: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
929: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
930: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
931: ELSE

Line 928: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

924: l_measure_type || '.' ;
925: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
926: , oki_load_rbk_pvt.g_new_bsn_code ) ;
927: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
928: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
929: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
930: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
931: ELSE
932: RAISE NO_DATA_FOUND ;

Line 934: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

930: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
931: ELSE
932: RAISE NO_DATA_FOUND ;
933: END IF ;
934: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
935:
936: -- Get the current value
937: l_loc := 'Opening cursor to determine current ' ||
938: l_measure_type || '.' ;

Line 1016: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

1012:
1013: -- Get the bin display lookup values
1014: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1015: l_measure_type || '.' ;
1016: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1017: , oki_load_rbk_pvt.g_trmn_k_code ) ;
1018: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1019: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1020: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 1018: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

1014: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1015: l_measure_type || '.' ;
1016: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1017: , oki_load_rbk_pvt.g_trmn_k_code ) ;
1018: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1019: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1020: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1021: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1022: ELSE

Line 1019: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

1015: l_measure_type || '.' ;
1016: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1017: , oki_load_rbk_pvt.g_trmn_k_code ) ;
1018: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1019: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1020: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1021: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1022: ELSE
1023: RAISE NO_DATA_FOUND ;

Line 1025: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

1021: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1022: ELSE
1023: RAISE NO_DATA_FOUND ;
1024: END IF ;
1025: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
1026:
1027: -- Get the current value
1028: l_loc := 'Opening cursor to determine current ' ||
1029: l_measure_type || '.' ;

Line 1107: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

1103:
1104: -- Get the bin display lookup values
1105: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1106: l_measure_type || '.' ;
1107: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1108: , oki_load_rbk_pvt.g_e_act_k_code ) ;
1109: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1110: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1111: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 1109: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

1105: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1106: l_measure_type || '.' ;
1107: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1108: , oki_load_rbk_pvt.g_e_act_k_code ) ;
1109: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1110: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1111: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1112: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1113: ELSE

Line 1110: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

1106: l_measure_type || '.' ;
1107: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1108: , oki_load_rbk_pvt.g_e_act_k_code ) ;
1109: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1110: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1111: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1112: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1113: ELSE
1114: RAISE NO_DATA_FOUND ;

Line 1116: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

1112: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1113: ELSE
1114: RAISE NO_DATA_FOUND ;
1115: END IF ;
1116: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
1117:
1118: -- Get the current value
1119: l_curr_e_act_k := ( l_curr_b_act_k + l_curr_bklg_k_rwned +
1120: l_curr_k_rnwed + l_curr_new_bus ) -

Line 1264: rec_l_tactk_all_csr oki_utl_pvt.g_tactk_all_csr_row ;

1260:
1261: l_bin_code_meaning VARCHAR2(240) := NULL ;
1262: l_bin_code_seq NUMBER := NULL ;
1263:
1264: rec_l_tactk_all_csr oki_utl_pvt.g_tactk_all_csr_row ;
1265: rec_l_k_exp_in_qtr_all_csr oki_utl_pvt.g_k_exp_in_qtr_all_csr_row ;
1266: rec_l_bin_disp_lkup_csr oki_utl_pvt.g_bin_disp_lkup_csr_row ;
1267:
1268: -- Holds the current measure values for the renewal bookings bin

Line 1265: rec_l_k_exp_in_qtr_all_csr oki_utl_pvt.g_k_exp_in_qtr_all_csr_row ;

1261: l_bin_code_meaning VARCHAR2(240) := NULL ;
1262: l_bin_code_seq NUMBER := NULL ;
1263:
1264: rec_l_tactk_all_csr oki_utl_pvt.g_tactk_all_csr_row ;
1265: rec_l_k_exp_in_qtr_all_csr oki_utl_pvt.g_k_exp_in_qtr_all_csr_row ;
1266: rec_l_bin_disp_lkup_csr oki_utl_pvt.g_bin_disp_lkup_csr_row ;
1267:
1268: -- Holds the current measure values for the renewal bookings bin
1269: l_curr_b_act_k NUMBER := 0 ;

Line 1266: rec_l_bin_disp_lkup_csr oki_utl_pvt.g_bin_disp_lkup_csr_row ;

1262: l_bin_code_seq NUMBER := NULL ;
1263:
1264: rec_l_tactk_all_csr oki_utl_pvt.g_tactk_all_csr_row ;
1265: rec_l_k_exp_in_qtr_all_csr oki_utl_pvt.g_k_exp_in_qtr_all_csr_row ;
1266: rec_l_bin_disp_lkup_csr oki_utl_pvt.g_bin_disp_lkup_csr_row ;
1267:
1268: -- Holds the current measure values for the renewal bookings bin
1269: l_curr_b_act_k NUMBER := 0 ;
1270: l_curr_k_exp_in_qtr NUMBER := 0 ;

Line 1406: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

1402:
1403: -- Get the bin display lookup values
1404: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1405: l_measure_type || '.' ;
1406: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1407: , oki_load_rbk_pvt.g_b_act_k_code ) ;
1408: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1409: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1410: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 1408: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

1404: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1405: l_measure_type || '.' ;
1406: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1407: , oki_load_rbk_pvt.g_b_act_k_code ) ;
1408: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1409: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1410: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1411: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1412: ELSE

Line 1409: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

1405: l_measure_type || '.' ;
1406: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1407: , oki_load_rbk_pvt.g_b_act_k_code ) ;
1408: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1409: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1410: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1411: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1412: ELSE
1413: RAISE NO_DATA_FOUND ;

Line 1415: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

1411: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1412: ELSE
1413: RAISE NO_DATA_FOUND ;
1414: END IF ;
1415: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
1416:
1417:
1418: -- Get the current value
1419: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;

Line 1420: OPEN oki_utl_pvt.g_tactk_all_csr ( oki_utl_pub.g_glpr_qtr_start_date ) ;

1416:
1417:
1418: -- Get the current value
1419: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1420: OPEN oki_utl_pvt.g_tactk_all_csr ( oki_utl_pub.g_glpr_qtr_start_date ) ;
1421: FETCH oki_utl_pvt.g_tactk_all_csr INTO rec_l_tactk_all_csr ;
1422: IF oki_utl_pvt.g_tactk_all_csr%FOUND THEN
1423: l_curr_b_act_k := rec_l_tactk_all_csr.value ;
1424: END IF ;

Line 1421: FETCH oki_utl_pvt.g_tactk_all_csr INTO rec_l_tactk_all_csr ;

1417:
1418: -- Get the current value
1419: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1420: OPEN oki_utl_pvt.g_tactk_all_csr ( oki_utl_pub.g_glpr_qtr_start_date ) ;
1421: FETCH oki_utl_pvt.g_tactk_all_csr INTO rec_l_tactk_all_csr ;
1422: IF oki_utl_pvt.g_tactk_all_csr%FOUND THEN
1423: l_curr_b_act_k := rec_l_tactk_all_csr.value ;
1424: END IF ;
1425: CLOSE oki_utl_pvt.g_tactk_all_csr ;

Line 1422: IF oki_utl_pvt.g_tactk_all_csr%FOUND THEN

1418: -- Get the current value
1419: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1420: OPEN oki_utl_pvt.g_tactk_all_csr ( oki_utl_pub.g_glpr_qtr_start_date ) ;
1421: FETCH oki_utl_pvt.g_tactk_all_csr INTO rec_l_tactk_all_csr ;
1422: IF oki_utl_pvt.g_tactk_all_csr%FOUND THEN
1423: l_curr_b_act_k := rec_l_tactk_all_csr.value ;
1424: END IF ;
1425: CLOSE oki_utl_pvt.g_tactk_all_csr ;
1426:

Line 1425: CLOSE oki_utl_pvt.g_tactk_all_csr ;

1421: FETCH oki_utl_pvt.g_tactk_all_csr INTO rec_l_tactk_all_csr ;
1422: IF oki_utl_pvt.g_tactk_all_csr%FOUND THEN
1423: l_curr_b_act_k := rec_l_tactk_all_csr.value ;
1424: END IF ;
1425: CLOSE oki_utl_pvt.g_tactk_all_csr ;
1426:
1427: -- Get the previous value
1428: l_loc := 'Opening Cursor to determine previous ' || l_measure_type || '.' ;
1429: OPEN oki_utl_pvt.g_tactk_all_csr ( oki_utl_pub.g_py_glpr_qtr_start_date ) ;

Line 1429: OPEN oki_utl_pvt.g_tactk_all_csr ( oki_utl_pub.g_py_glpr_qtr_start_date ) ;

1425: CLOSE oki_utl_pvt.g_tactk_all_csr ;
1426:
1427: -- Get the previous value
1428: l_loc := 'Opening Cursor to determine previous ' || l_measure_type || '.' ;
1429: OPEN oki_utl_pvt.g_tactk_all_csr ( oki_utl_pub.g_py_glpr_qtr_start_date ) ;
1430: FETCH oki_utl_pvt.g_tactk_all_csr INTO rec_l_tactk_all_csr ;
1431: IF oki_utl_pvt.g_tactk_all_csr%FOUND THEN
1432: l_prev_b_act_k := rec_l_tactk_all_csr.value ;
1433: END IF ;

Line 1430: FETCH oki_utl_pvt.g_tactk_all_csr INTO rec_l_tactk_all_csr ;

1426:
1427: -- Get the previous value
1428: l_loc := 'Opening Cursor to determine previous ' || l_measure_type || '.' ;
1429: OPEN oki_utl_pvt.g_tactk_all_csr ( oki_utl_pub.g_py_glpr_qtr_start_date ) ;
1430: FETCH oki_utl_pvt.g_tactk_all_csr INTO rec_l_tactk_all_csr ;
1431: IF oki_utl_pvt.g_tactk_all_csr%FOUND THEN
1432: l_prev_b_act_k := rec_l_tactk_all_csr.value ;
1433: END IF ;
1434: CLOSE oki_utl_pvt.g_tactk_all_csr ;

Line 1431: IF oki_utl_pvt.g_tactk_all_csr%FOUND THEN

1427: -- Get the previous value
1428: l_loc := 'Opening Cursor to determine previous ' || l_measure_type || '.' ;
1429: OPEN oki_utl_pvt.g_tactk_all_csr ( oki_utl_pub.g_py_glpr_qtr_start_date ) ;
1430: FETCH oki_utl_pvt.g_tactk_all_csr INTO rec_l_tactk_all_csr ;
1431: IF oki_utl_pvt.g_tactk_all_csr%FOUND THEN
1432: l_prev_b_act_k := rec_l_tactk_all_csr.value ;
1433: END IF ;
1434: CLOSE oki_utl_pvt.g_tactk_all_csr ;
1435:

Line 1434: CLOSE oki_utl_pvt.g_tactk_all_csr ;

1430: FETCH oki_utl_pvt.g_tactk_all_csr INTO rec_l_tactk_all_csr ;
1431: IF oki_utl_pvt.g_tactk_all_csr%FOUND THEN
1432: l_prev_b_act_k := rec_l_tactk_all_csr.value ;
1433: END IF ;
1434: CLOSE oki_utl_pvt.g_tactk_all_csr ;
1435:
1436: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1437: -- Determine if the record is a new one or an existing one
1438: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date

Line 1492: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

1488:
1489: -- Get the bin display lookup values
1490: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1491: l_measure_type || '.' ;
1492: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1493: , oki_load_rbk_pvt.g_exp_in_qtr_code ) ;
1494: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1495: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1496: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 1494: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

1490: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1491: l_measure_type || '.' ;
1492: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1493: , oki_load_rbk_pvt.g_exp_in_qtr_code ) ;
1494: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1495: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1496: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1497: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1498: ELSE

Line 1495: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

1491: l_measure_type || '.' ;
1492: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1493: , oki_load_rbk_pvt.g_exp_in_qtr_code ) ;
1494: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1495: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1496: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1497: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1498: ELSE
1499: RAISE NO_DATA_FOUND ;

Line 1501: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

1497: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1498: ELSE
1499: RAISE NO_DATA_FOUND ;
1500: END IF ;
1501: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
1502:
1503: -- Get the current value
1504: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1505: OPEN oki_utl_pvt.g_k_exp_in_qtr_all_csr (

Line 1505: OPEN oki_utl_pvt.g_k_exp_in_qtr_all_csr (

1501: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
1502:
1503: -- Get the current value
1504: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1505: OPEN oki_utl_pvt.g_k_exp_in_qtr_all_csr (
1506: oki_utl_pub.g_glpr_qtr_start_date,
1507: oki_utl_pub.g_glpr_qtr_end_date ) ;
1508: FETCH oki_utl_pvt.g_k_exp_in_qtr_all_csr INTO rec_l_k_exp_in_qtr_all_csr ;
1509: IF oki_utl_pvt.g_k_exp_in_qtr_all_csr%FOUND THEN

Line 1508: FETCH oki_utl_pvt.g_k_exp_in_qtr_all_csr INTO rec_l_k_exp_in_qtr_all_csr ;

1504: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1505: OPEN oki_utl_pvt.g_k_exp_in_qtr_all_csr (
1506: oki_utl_pub.g_glpr_qtr_start_date,
1507: oki_utl_pub.g_glpr_qtr_end_date ) ;
1508: FETCH oki_utl_pvt.g_k_exp_in_qtr_all_csr INTO rec_l_k_exp_in_qtr_all_csr ;
1509: IF oki_utl_pvt.g_k_exp_in_qtr_all_csr%FOUND THEN
1510: l_curr_k_exp_in_qtr := rec_l_k_exp_in_qtr_all_csr.value ;
1511: END IF ;
1512: CLOSE oki_utl_pvt.g_k_exp_in_qtr_all_csr ;

Line 1509: IF oki_utl_pvt.g_k_exp_in_qtr_all_csr%FOUND THEN

1505: OPEN oki_utl_pvt.g_k_exp_in_qtr_all_csr (
1506: oki_utl_pub.g_glpr_qtr_start_date,
1507: oki_utl_pub.g_glpr_qtr_end_date ) ;
1508: FETCH oki_utl_pvt.g_k_exp_in_qtr_all_csr INTO rec_l_k_exp_in_qtr_all_csr ;
1509: IF oki_utl_pvt.g_k_exp_in_qtr_all_csr%FOUND THEN
1510: l_curr_k_exp_in_qtr := rec_l_k_exp_in_qtr_all_csr.value ;
1511: END IF ;
1512: CLOSE oki_utl_pvt.g_k_exp_in_qtr_all_csr ;
1513:

Line 1512: CLOSE oki_utl_pvt.g_k_exp_in_qtr_all_csr ;

1508: FETCH oki_utl_pvt.g_k_exp_in_qtr_all_csr INTO rec_l_k_exp_in_qtr_all_csr ;
1509: IF oki_utl_pvt.g_k_exp_in_qtr_all_csr%FOUND THEN
1510: l_curr_k_exp_in_qtr := rec_l_k_exp_in_qtr_all_csr.value ;
1511: END IF ;
1512: CLOSE oki_utl_pvt.g_k_exp_in_qtr_all_csr ;
1513:
1514: -- Get the previous value
1515: l_loc := 'Opening cursor to determine previous ' || l_measure_type || '.' ;
1516: OPEN oki_utl_pvt.g_k_exp_in_qtr_all_csr (

Line 1516: OPEN oki_utl_pvt.g_k_exp_in_qtr_all_csr (

1512: CLOSE oki_utl_pvt.g_k_exp_in_qtr_all_csr ;
1513:
1514: -- Get the previous value
1515: l_loc := 'Opening cursor to determine previous ' || l_measure_type || '.' ;
1516: OPEN oki_utl_pvt.g_k_exp_in_qtr_all_csr (
1517: oki_utl_pub.g_py_glpr_qtr_start_date,
1518: oki_utl_pub.g_py_glpr_qtr_end_date ) ;
1519: FETCH oki_utl_pvt.g_k_exp_in_qtr_all_csr INTO rec_l_k_exp_in_qtr_all_csr ;
1520: IF oki_utl_pvt.g_k_exp_in_qtr_all_csr%FOUND THEN

Line 1519: FETCH oki_utl_pvt.g_k_exp_in_qtr_all_csr INTO rec_l_k_exp_in_qtr_all_csr ;

1515: l_loc := 'Opening cursor to determine previous ' || l_measure_type || '.' ;
1516: OPEN oki_utl_pvt.g_k_exp_in_qtr_all_csr (
1517: oki_utl_pub.g_py_glpr_qtr_start_date,
1518: oki_utl_pub.g_py_glpr_qtr_end_date ) ;
1519: FETCH oki_utl_pvt.g_k_exp_in_qtr_all_csr INTO rec_l_k_exp_in_qtr_all_csr ;
1520: IF oki_utl_pvt.g_k_exp_in_qtr_all_csr%FOUND THEN
1521: l_prev_k_exp_in_qtr := rec_l_k_exp_in_qtr_all_csr.value ;
1522: END IF ;
1523: CLOSE oki_utl_pvt.g_k_exp_in_qtr_all_csr ;

Line 1520: IF oki_utl_pvt.g_k_exp_in_qtr_all_csr%FOUND THEN

1516: OPEN oki_utl_pvt.g_k_exp_in_qtr_all_csr (
1517: oki_utl_pub.g_py_glpr_qtr_start_date,
1518: oki_utl_pub.g_py_glpr_qtr_end_date ) ;
1519: FETCH oki_utl_pvt.g_k_exp_in_qtr_all_csr INTO rec_l_k_exp_in_qtr_all_csr ;
1520: IF oki_utl_pvt.g_k_exp_in_qtr_all_csr%FOUND THEN
1521: l_prev_k_exp_in_qtr := rec_l_k_exp_in_qtr_all_csr.value ;
1522: END IF ;
1523: CLOSE oki_utl_pvt.g_k_exp_in_qtr_all_csr ;
1524:

Line 1523: CLOSE oki_utl_pvt.g_k_exp_in_qtr_all_csr ;

1519: FETCH oki_utl_pvt.g_k_exp_in_qtr_all_csr INTO rec_l_k_exp_in_qtr_all_csr ;
1520: IF oki_utl_pvt.g_k_exp_in_qtr_all_csr%FOUND THEN
1521: l_prev_k_exp_in_qtr := rec_l_k_exp_in_qtr_all_csr.value ;
1522: END IF ;
1523: CLOSE oki_utl_pvt.g_k_exp_in_qtr_all_csr ;
1524:
1525: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1526: -- Determine if the record is a new one or an existing one
1527: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date

Line 1581: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

1577:
1578: -- Get the bin display lookup values
1579: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1580: l_measure_type || '.' ;
1581: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1582: , oki_load_rbk_pvt.g_bklg_k_to_rnw_code ) ;
1583: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1584: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1585: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 1583: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

1579: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1580: l_measure_type || '.' ;
1581: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1582: , oki_load_rbk_pvt.g_bklg_k_to_rnw_code ) ;
1583: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1584: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1585: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1586: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1587: ELSE

Line 1584: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

1580: l_measure_type || '.' ;
1581: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1582: , oki_load_rbk_pvt.g_bklg_k_to_rnw_code ) ;
1583: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1584: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1585: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1586: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1587: ELSE
1588: RAISE NO_DATA_FOUND ;

Line 1590: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

1586: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1587: ELSE
1588: RAISE NO_DATA_FOUND ;
1589: END IF ;
1590: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
1591:
1592: -- Get the current value
1593: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1594: OPEN l_bklg_k_to_rnw_csr ( oki_utl_pub.g_glpr_qtr_start_date ) ;

Line 1666: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

1662:
1663: -- Get the bin display lookup values
1664: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1665: l_measure_type || '.' ;
1666: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1667: , oki_load_rbk_pvt.g_b_rnwl_oppty_code ) ;
1668: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1669: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1670: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 1668: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

1664: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1665: l_measure_type || '.' ;
1666: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1667: , oki_load_rbk_pvt.g_b_rnwl_oppty_code ) ;
1668: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1669: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1670: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1671: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1672: ELSE

Line 1669: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

1665: l_measure_type || '.' ;
1666: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1667: , oki_load_rbk_pvt.g_b_rnwl_oppty_code ) ;
1668: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1669: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1670: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1671: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1672: ELSE
1673: RAISE NO_DATA_FOUND ;

Line 1675: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

1671: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1672: ELSE
1673: RAISE NO_DATA_FOUND ;
1674: END IF ;
1675: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
1676:
1677: l_curr_b_rnwl_oppty := l_curr_k_exp_in_qtr + l_curr_bklg_k_to_rnw ;
1678: l_prev_b_rnwl_oppty := l_prev_k_exp_in_qtr + l_prev_bklg_k_to_rnw ;
1679:

Line 1735: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

1731:
1732: -- Get the bin display lookup values
1733: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1734: l_measure_type || '.' ;
1735: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1736: , oki_load_rbk_pvt.g_qtr_actvty_code ) ;
1737: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1738: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1739: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 1737: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

1733: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1734: l_measure_type || '.' ;
1735: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1736: , oki_load_rbk_pvt.g_qtr_actvty_code ) ;
1737: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1738: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1739: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1740: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1741: ELSE

Line 1738: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

1734: l_measure_type || '.' ;
1735: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1736: , oki_load_rbk_pvt.g_qtr_actvty_code ) ;
1737: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1738: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1739: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1740: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1741: ELSE
1742: RAISE NO_DATA_FOUND ;

Line 1744: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

1740: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1741: ELSE
1742: RAISE NO_DATA_FOUND ;
1743: END IF ;
1744: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
1745:
1746: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1747: -- Determine if the record is a new one or an existing one
1748: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date,

Line 1801: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

1797:
1798: -- Get the bin display lookup values
1799: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1800: l_measure_type || '.' ;
1801: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1802: , oki_load_rbk_pvt.g_bklg_k_rnwed_code ) ;
1803: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1804: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1805: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 1803: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

1799: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1800: l_measure_type || '.' ;
1801: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1802: , oki_load_rbk_pvt.g_bklg_k_rnwed_code ) ;
1803: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1804: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1805: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1806: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1807: ELSE

Line 1804: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

1800: l_measure_type || '.' ;
1801: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1802: , oki_load_rbk_pvt.g_bklg_k_rnwed_code ) ;
1803: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1804: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1805: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1806: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1807: ELSE
1808: RAISE NO_DATA_FOUND ;

Line 1810: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

1806: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1807: ELSE
1808: RAISE NO_DATA_FOUND ;
1809: END IF ;
1810: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
1811:
1812: -- Get the current value
1813: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1814: OPEN l_bklg_k_rwned_csr( oki_utl_pub.g_summary_build_date,

Line 1887: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

1883:
1884: -- Get the bin display lookup values
1885: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1886: l_measure_type || '.' ;
1887: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1888: , oki_load_rbk_pvt.g_k_rnwed_code ) ;
1889: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1890: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1891: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 1889: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

1885: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1886: l_measure_type || '.' ;
1887: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1888: , oki_load_rbk_pvt.g_k_rnwed_code ) ;
1889: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1890: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1891: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1892: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1893: ELSE

Line 1890: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

1886: l_measure_type || '.' ;
1887: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1888: , oki_load_rbk_pvt.g_k_rnwed_code ) ;
1889: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1890: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1891: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1892: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1893: ELSE
1894: RAISE NO_DATA_FOUND ;

Line 1896: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

1892: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1893: ELSE
1894: RAISE NO_DATA_FOUND ;
1895: END IF ;
1896: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
1897:
1898: -- Get the current value
1899: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1900: OPEN l_k_rnwed_csr( oki_utl_pub.g_glpr_qtr_start_date,

Line 1973: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

1969:
1970: -- Get the bin display lookup values
1971: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1972: l_measure_type || '.' ;
1973: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1974: , oki_load_rbk_pvt.g_new_bsn_code ) ;
1975: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1976: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1977: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 1975: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

1971: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
1972: l_measure_type || '.' ;
1973: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1974: , oki_load_rbk_pvt.g_new_bsn_code ) ;
1975: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1976: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1977: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1978: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1979: ELSE

Line 1976: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

1972: l_measure_type || '.' ;
1973: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
1974: , oki_load_rbk_pvt.g_new_bsn_code ) ;
1975: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
1976: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
1977: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
1978: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1979: ELSE
1980: RAISE NO_DATA_FOUND ;

Line 1982: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

1978: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
1979: ELSE
1980: RAISE NO_DATA_FOUND ;
1981: END IF ;
1982: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
1983:
1984: -- Get the current value
1985: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1986: OPEN l_new_bus_csr( oki_utl_pub.g_summary_build_date,

Line 2060: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

2056:
2057: -- Get the bin display lookup values
2058: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
2059: l_measure_type || '.' ;
2060: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
2061: , oki_load_rbk_pvt.g_trmn_k_code ) ;
2062: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
2063: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
2064: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 2062: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

2058: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
2059: l_measure_type || '.' ;
2060: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
2061: , oki_load_rbk_pvt.g_trmn_k_code ) ;
2062: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
2063: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
2064: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
2065: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
2066: ELSE

Line 2063: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

2059: l_measure_type || '.' ;
2060: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
2061: , oki_load_rbk_pvt.g_trmn_k_code ) ;
2062: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
2063: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
2064: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
2065: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
2066: ELSE
2067: RAISE NO_DATA_FOUND ;

Line 2069: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

2065: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
2066: ELSE
2067: RAISE NO_DATA_FOUND ;
2068: END IF ;
2069: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
2070:
2071: -- Get the current value
2072: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
2073: OPEN l_trmn_k_csr( oki_utl_pub.g_summary_build_date,

Line 2145: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

2141:
2142: -- Get the bin display lookup values
2143: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
2144: l_measure_type || '.' ;
2145: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
2146: , oki_load_rbk_pvt.g_e_act_k_code ) ;
2147: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
2148: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
2149: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;

Line 2147: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;

2143: l_loc := 'Opening cursor to retrieve bin display lookup values for ' ||
2144: l_measure_type || '.' ;
2145: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
2146: , oki_load_rbk_pvt.g_e_act_k_code ) ;
2147: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
2148: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
2149: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
2150: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
2151: ELSE

Line 2148: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN

2144: l_measure_type || '.' ;
2145: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id
2146: , oki_load_rbk_pvt.g_e_act_k_code ) ;
2147: FETCH oki_utl_pvt.g_bin_disp_lkup_csr INTO rec_l_bin_disp_lkup_csr ;
2148: IF oki_utl_pvt.g_bin_disp_lkup_csr%FOUND THEN
2149: l_bin_code_meaning := rec_l_bin_disp_lkup_csr.bin_code_meaning ;
2150: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
2151: ELSE
2152: RAISE NO_DATA_FOUND ;

Line 2154: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;

2150: l_bin_code_seq := rec_l_bin_disp_lkup_csr.bin_code_seq ;
2151: ELSE
2152: RAISE NO_DATA_FOUND ;
2153: END IF ;
2154: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
2155:
2156: l_measure_type := 'Ending Active Contracts' ;
2157:
2158: l_curr_e_act_k := ( l_curr_b_act_k + l_curr_bklg_k_rwned +

Line 2329: oki_utl_pvt.get_gl_period_date (

2325:
2326: oki_utl_pub.g_summary_build_date := l_summary_build_date ;
2327:
2328: -- Get the GL periods start / end date
2329: oki_utl_pvt.get_gl_period_date (
2330: x_retcode => l_retcode ) ;
2331:
2332: IF l_retcode = '2' THEN
2333: -- Load failed, exit immediately.