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_ETR_PVT dependencies on OKI_UTL_PUB

Line 285: AND oki_utl_pub.g_contract_limit

281: AND p_summary_build_date
282: AND ( shd.date_terminated IS NULL
283: OR shd.date_terminated > p_summary_build_date )
284: AND shd.base_contract_amount BETWEEN 0
285: AND oki_utl_pub.g_contract_limit
286: AND shd.authoring_org_id = p_authoring_org_id ) expiredtilldate
287: , ( SELECT count(shd.chr_id) value
288: FROM oki_sales_k_hdrs shd
289: WHERE shd.is_new_yn IS NULL

Line 294: BETWEEN 0 AND oki_utl_pub.g_contract_limit

290: AND shd.date_signed IS NOT NULL
291: AND shd.date_signed BETWEEN p_qtr_start_date
292: AND p_summary_build_date
293: AND shd.base_contract_amount
294: BETWEEN 0 AND oki_utl_pub.g_contract_limit
295: AND shd.authoring_org_id = p_authoring_org_id ) rnwinqtr;
296:
297:
298: /*

Line 313: BETWEEN 0 AND oki_utl_pub.g_contract_limit

309: AND p_summary_build_date
310: AND GREATEST(shd.date_signed, shd.date_approved) <=
311: p_summary_build_date
312: AND shd.base_contract_amount
313: BETWEEN 0 AND oki_utl_pub.g_contract_limit
314: AND shd.authoring_org_id = p_authoring_org_id
315: ) k_rnw_qtd
316: , ( SELECT COUNT(shd.chr_id) value
317: FROM oki_sales_k_hdrs shd

Line 325: BETWEEN 0 AND oki_utl_pub.g_contract_limit

321: AND shd.start_date < p_qtr_start_date
322: AND GREATEST(shd.date_signed, shd.date_approved )
323: BETWEEN p_qtr_start_date AND p_summary_build_date
324: AND shd.base_contract_amount
325: BETWEEN 0 AND oki_utl_pub.g_contract_limit
326: AND shd.authoring_org_id = p_authoring_org_id
327: ) all_bklg_qsd
328: , ( SELECT COUNT(shd.chr_id) value
329: FROM oki_sales_k_hdrs shd

Line 336: BETWEEN 0 AND oki_utl_pub.g_contract_limit

332: AND shd.end_date
333: BETWEEN p_qtr_start_date AND p_summary_build_date
334: AND shd.date_terminated IS NULL
335: AND shd.base_contract_amount
336: BETWEEN 0 AND oki_utl_pub.g_contract_limit
337: AND shd.authoring_org_id = p_authoring_org_id
338: ) k_exp_qtd
339: , ( SELECT COUNT(shd.chr_id) value
340: FROM oki_sales_k_hdrs shd

Line 348: BETWEEN 0 AND oki_utl_pub.g_contract_limit

344: AND ( shd.date_signed IS NULL
345: OR shd.date_signed >= p_qtr_start_date )
346: AND shd.start_date < p_qtr_start_date
347: AND shd.base_contract_amount
348: BETWEEN 0 AND oki_utl_pub.g_contract_limit
349: AND shd.authoring_org_id = p_authoring_org_id
350: ) bklg_k_qsd ;
351: */
352: rec_l_rnwl_rate_csr l_rnwl_rate_csr%ROWTYPE ;

Line 366: AND oki_utl_pub.g_contract_limit

362: AND shd.is_new_yn IS NULL
363: AND shd.date_signed IS NULL
364: AND shd.date_canceled IS NULL
365: AND shd.contract_amount BETWEEN 0
366: AND oki_utl_pub.g_contract_limit
367: ;
368: rec_l_rnwl_oppty_csr l_rnwl_oppty_csr%ROWTYPE ;
369:
370: BEGIN

Line 409: oki_utl_pub.g_summary_build_date

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_summary_build_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_tactk_value := rec_l_tactk_by_org_csr.value ;

Line 422: oki_utl_pub.g_py_summary_build_date

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

Line 450: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date

446: END IF ;
447:
448: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
449: -- Determine if the record is a new one or an existing one
450: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
451: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
452: , oki_utl_pub.g_all_k_category_code
453: , oki_load_etr_pvt.g_tactk_code ) ;
454: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;

Line 451: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id

447:
448: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
449: -- Determine if the record is a new one or an existing one
450: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
451: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
452: , oki_utl_pub.g_all_k_category_code
453: , oki_load_etr_pvt.g_tactk_code ) ;
454: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
455: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN

Line 452: , oki_utl_pub.g_all_k_category_code

448: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
449: -- Determine if the record is a new one or an existing one
450: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
451: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
452: , oki_utl_pub.g_all_k_category_code
453: , oki_load_etr_pvt.g_tactk_code ) ;
454: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
455: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
456: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 459: p_summary_build_date => oki_utl_pub.g_summary_build_date

455: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
456: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
457: -- Insert the new record
458: oki_load_etr_pvt.ins_exp_to_rnwl(
459: p_summary_build_date => oki_utl_pub.g_summary_build_date
460: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
461: , p_organization_name => rec_g_org_csr.organization_name
462: , p_customer_party_id => oki_utl_pub.g_all_customer_id
463: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 462: , p_customer_party_id => oki_utl_pub.g_all_customer_id

458: oki_load_etr_pvt.ins_exp_to_rnwl(
459: p_summary_build_date => oki_utl_pub.g_summary_build_date
460: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
461: , p_organization_name => rec_g_org_csr.organization_name
462: , p_customer_party_id => oki_utl_pub.g_all_customer_id
463: , p_customer_name => oki_utl_pub.g_all_customer_name
464: , p_scs_code => oki_utl_pub.g_all_k_category_code
465: , p_measure_code => oki_load_etr_pvt.g_tactk_code
466: , p_measure_code_meaning => l_bin_code_meaning

Line 463: , p_customer_name => oki_utl_pub.g_all_customer_name

459: p_summary_build_date => oki_utl_pub.g_summary_build_date
460: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
461: , p_organization_name => rec_g_org_csr.organization_name
462: , p_customer_party_id => oki_utl_pub.g_all_customer_id
463: , p_customer_name => oki_utl_pub.g_all_customer_name
464: , p_scs_code => oki_utl_pub.g_all_k_category_code
465: , p_measure_code => oki_load_etr_pvt.g_tactk_code
466: , p_measure_code_meaning => l_bin_code_meaning
467: , p_bin_code_seq => l_bin_code_seq

Line 464: , p_scs_code => oki_utl_pub.g_all_k_category_code

460: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
461: , p_organization_name => rec_g_org_csr.organization_name
462: , p_customer_party_id => oki_utl_pub.g_all_customer_id
463: , p_customer_name => oki_utl_pub.g_all_customer_name
464: , p_scs_code => oki_utl_pub.g_all_k_category_code
465: , p_measure_code => oki_load_etr_pvt.g_tactk_code
466: , p_measure_code_meaning => l_bin_code_meaning
467: , p_bin_code_seq => l_bin_code_seq
468: , p_measure_value1 => l_curr_value

Line 474: RAISE oki_utl_pub.g_excp_exit_immediate ;

470: , p_measure_value3 => l_status_icon
471: , x_retcode => l_retcode ) ;
472: IF l_retcode = '2' THEN
473: -- Load failed, exit immediately.
474: RAISE oki_utl_pub.g_excp_exit_immediate ;
475: END IF ;
476: ELSE
477: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
478: -- Update the existing record

Line 487: , p_customer_name => oki_utl_pub.g_all_customer_name

483: , p_measure_value3 => l_status_icon
484: , p_measure_code_meaning => l_bin_code_meaning
485: , p_bin_code_seq => l_bin_code_seq
486: , p_organization_name => rec_g_org_csr.organization_name
487: , p_customer_name => oki_utl_pub.g_all_customer_name
488: , p_etr_rowid => rec_g_etr_csr.rowid
489: , x_retcode => l_retcode ) ;
490:
491: IF l_retcode = '2' THEN

Line 493: RAISE oki_utl_pub.g_excp_exit_immediate ;

489: , x_retcode => l_retcode ) ;
490:
491: IF l_retcode = '2' THEN
492: -- Load failed, exit immediately.
493: RAISE oki_utl_pub.g_excp_exit_immediate ;
494: END IF ;
495: END IF ;
496: CLOSE oki_load_etr_pvt.g_etr_csr ;
497:

Line 525: OPEN l_rnwl_rate_csr ( oki_utl_pub.g_summary_build_date,

521:
522: -- Get the current value
523: l_loc := 'Opening cursor to determine current ' ||
524: l_measure_type || '.' ;
525: OPEN l_rnwl_rate_csr ( oki_utl_pub.g_summary_build_date,
526: oki_utl_pub.g_glpr_qtr_start_date,
527: rec_g_org_csr.authoring_org_id ) ;
528: FETCH l_rnwl_rate_csr INTO rec_l_rnwl_rate_csr ;
529: IF l_rnwl_rate_csr%FOUND THEN

Line 526: oki_utl_pub.g_glpr_qtr_start_date,

522: -- Get the current value
523: l_loc := 'Opening cursor to determine current ' ||
524: l_measure_type || '.' ;
525: OPEN l_rnwl_rate_csr ( oki_utl_pub.g_summary_build_date,
526: oki_utl_pub.g_glpr_qtr_start_date,
527: rec_g_org_csr.authoring_org_id ) ;
528: FETCH l_rnwl_rate_csr INTO rec_l_rnwl_rate_csr ;
529: IF l_rnwl_rate_csr%FOUND THEN
530: l_curr_value := rec_l_rnwl_rate_csr.value ;

Line 537: OPEN l_rnwl_rate_csr ( oki_utl_pub.g_py_summary_build_date,

533:
534: -- Get the previous value
535: l_loc := 'Opening cursor to determine previous ' ||
536: l_measure_type || '.' ;
537: OPEN l_rnwl_rate_csr ( oki_utl_pub.g_py_summary_build_date,
538: oki_utl_pub.g_py_glpr_qtr_start_date,
539: rec_g_org_csr.authoring_org_id ) ;
540: FETCH l_rnwl_rate_csr INTO rec_l_rnwl_rate_csr ;
541: IF l_rnwl_rate_csr%FOUND THEN

Line 538: oki_utl_pub.g_py_glpr_qtr_start_date,

534: -- Get the previous value
535: l_loc := 'Opening cursor to determine previous ' ||
536: l_measure_type || '.' ;
537: OPEN l_rnwl_rate_csr ( oki_utl_pub.g_py_summary_build_date,
538: oki_utl_pub.g_py_glpr_qtr_start_date,
539: rec_g_org_csr.authoring_org_id ) ;
540: FETCH l_rnwl_rate_csr INTO rec_l_rnwl_rate_csr ;
541: IF l_rnwl_rate_csr%FOUND THEN
542: l_prev_value := rec_l_rnwl_rate_csr.value ;

Line 566: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date

562: END IF ;
563:
564: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
565: -- Determine if the record is a new one or an existing one
566: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
567: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
568: , oki_utl_pub.g_all_k_category_code
569: , oki_load_etr_pvt.g_rnwl_rate_code ) ;
570: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;

Line 567: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id

563:
564: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
565: -- Determine if the record is a new one or an existing one
566: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
567: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
568: , oki_utl_pub.g_all_k_category_code
569: , oki_load_etr_pvt.g_rnwl_rate_code ) ;
570: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
571: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN

Line 568: , oki_utl_pub.g_all_k_category_code

564: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
565: -- Determine if the record is a new one or an existing one
566: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
567: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
568: , oki_utl_pub.g_all_k_category_code
569: , oki_load_etr_pvt.g_rnwl_rate_code ) ;
570: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
571: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
572: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 575: p_summary_build_date => oki_utl_pub.g_summary_build_date

571: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
572: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
573: -- Insert the new record
574: oki_load_etr_pvt.ins_exp_to_rnwl(
575: p_summary_build_date => oki_utl_pub.g_summary_build_date
576: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
577: , p_organization_name => rec_g_org_csr.organization_name
578: , p_customer_party_id => oki_utl_pub.g_all_customer_id
579: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 578: , p_customer_party_id => oki_utl_pub.g_all_customer_id

574: oki_load_etr_pvt.ins_exp_to_rnwl(
575: p_summary_build_date => oki_utl_pub.g_summary_build_date
576: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
577: , p_organization_name => rec_g_org_csr.organization_name
578: , p_customer_party_id => oki_utl_pub.g_all_customer_id
579: , p_customer_name => oki_utl_pub.g_all_customer_name
580: , p_scs_code => oki_utl_pub.g_all_k_category_code
581: , p_measure_code => oki_load_etr_pvt.g_rnwl_rate_code
582: , p_measure_code_meaning => l_bin_code_meaning

Line 579: , p_customer_name => oki_utl_pub.g_all_customer_name

575: p_summary_build_date => oki_utl_pub.g_summary_build_date
576: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
577: , p_organization_name => rec_g_org_csr.organization_name
578: , p_customer_party_id => oki_utl_pub.g_all_customer_id
579: , p_customer_name => oki_utl_pub.g_all_customer_name
580: , p_scs_code => oki_utl_pub.g_all_k_category_code
581: , p_measure_code => oki_load_etr_pvt.g_rnwl_rate_code
582: , p_measure_code_meaning => l_bin_code_meaning
583: , p_bin_code_seq => l_bin_code_seq

Line 580: , p_scs_code => oki_utl_pub.g_all_k_category_code

576: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
577: , p_organization_name => rec_g_org_csr.organization_name
578: , p_customer_party_id => oki_utl_pub.g_all_customer_id
579: , p_customer_name => oki_utl_pub.g_all_customer_name
580: , p_scs_code => oki_utl_pub.g_all_k_category_code
581: , p_measure_code => oki_load_etr_pvt.g_rnwl_rate_code
582: , p_measure_code_meaning => l_bin_code_meaning
583: , p_bin_code_seq => l_bin_code_seq
584: , p_measure_value1 => l_curr_value

Line 590: RAISE oki_utl_pub.g_excp_exit_immediate ;

586: , p_measure_value3 => l_status_icon
587: , x_retcode => l_retcode ) ;
588: IF l_retcode = '2' THEN
589: -- Load failed, exit immediately.
590: RAISE oki_utl_pub.g_excp_exit_immediate ;
591: END IF ;
592: ELSE
593: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
594: -- Update the existing record

Line 602: , p_customer_name => oki_utl_pub.g_all_customer_name

598: , p_measure_value3 => l_status_icon
599: , p_measure_code_meaning => l_bin_code_meaning
600: , p_bin_code_seq => l_bin_code_seq
601: , p_organization_name => rec_g_org_csr.organization_name
602: , p_customer_name => oki_utl_pub.g_all_customer_name
603: , p_etr_rowid => rec_g_etr_csr.rowid
604: , x_retcode => l_retcode ) ;
605:
606: IF l_retcode = '2' THEN

Line 608: RAISE oki_utl_pub.g_excp_exit_immediate ;

604: , x_retcode => l_retcode ) ;
605:
606: IF l_retcode = '2' THEN
607: -- Load failed, exit immediately.
608: RAISE oki_utl_pub.g_excp_exit_immediate ;
609: END IF ;
610: END IF ;
611: CLOSE oki_load_etr_pvt.g_etr_csr ;
612:

Line 642: oki_utl_pub.g_glpr_qtr_start_date

638: l_loc := 'Opening cursor to determine current' ||
639: l_measure_type || '.' ;
640: -- Get the active contracts as of the start of the quarter
641: OPEN oki_utl_pvt.g_tactk_by_org_csr (
642: oki_utl_pub.g_glpr_qtr_start_date
643: , rec_g_org_csr.authoring_org_id ) ;
644: FETCH oki_utl_pvt.g_tactk_by_org_csr INTO rec_l_tactk_by_org_csr ;
645: IF oki_utl_pvt.g_tactk_by_org_csr%FOUND THEN
646: l_qsd_tactk_value := rec_l_tactk_by_org_csr.value ;

Line 666: oki_utl_pub.g_py_glpr_qtr_start_date

662: l_loc := 'Opening cursor to determine previous ' ||
663: l_measure_type || '.' ;
664: -- Get the active contracts as of the start of the quarter
665: OPEN oki_utl_pvt.g_tactk_by_org_csr (
666: oki_utl_pub.g_py_glpr_qtr_start_date
667: , rec_g_org_csr.authoring_org_id ) ;
668: FETCH oki_utl_pvt.g_tactk_by_org_csr INTO rec_l_tactk_by_org_csr ;
669: IF oki_utl_pvt.g_tactk_by_org_csr%FOUND THEN
670: l_py_qsd_tactk_value := rec_l_tactk_by_org_csr.value ;

Line 706: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date

702: END IF ;
703:
704: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
705: -- Determine if the record is a new one or an existing one
706: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
707: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
708: , oki_utl_pub.g_all_k_category_code
709: , oki_load_etr_pvt.g_seq_grw_rate_code ) ;
710: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;

Line 707: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id

703:
704: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
705: -- Determine if the record is a new one or an existing one
706: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
707: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
708: , oki_utl_pub.g_all_k_category_code
709: , oki_load_etr_pvt.g_seq_grw_rate_code ) ;
710: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
711: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN

Line 708: , oki_utl_pub.g_all_k_category_code

704: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
705: -- Determine if the record is a new one or an existing one
706: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
707: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
708: , oki_utl_pub.g_all_k_category_code
709: , oki_load_etr_pvt.g_seq_grw_rate_code ) ;
710: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
711: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
712: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 715: p_summary_build_date => oki_utl_pub.g_summary_build_date

711: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
712: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
713: -- Insert the new record
714: oki_load_etr_pvt.ins_exp_to_rnwl(
715: p_summary_build_date => oki_utl_pub.g_summary_build_date
716: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
717: , p_organization_name => rec_g_org_csr.organization_name
718: , p_customer_party_id => oki_utl_pub.g_all_customer_id
719: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 718: , p_customer_party_id => oki_utl_pub.g_all_customer_id

714: oki_load_etr_pvt.ins_exp_to_rnwl(
715: p_summary_build_date => oki_utl_pub.g_summary_build_date
716: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
717: , p_organization_name => rec_g_org_csr.organization_name
718: , p_customer_party_id => oki_utl_pub.g_all_customer_id
719: , p_customer_name => oki_utl_pub.g_all_customer_name
720: , p_scs_code => oki_utl_pub.g_all_k_category_code
721: , p_measure_code => oki_load_etr_pvt.g_seq_grw_rate_code
722: , p_measure_code_meaning => l_bin_code_meaning

Line 719: , p_customer_name => oki_utl_pub.g_all_customer_name

715: p_summary_build_date => oki_utl_pub.g_summary_build_date
716: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
717: , p_organization_name => rec_g_org_csr.organization_name
718: , p_customer_party_id => oki_utl_pub.g_all_customer_id
719: , p_customer_name => oki_utl_pub.g_all_customer_name
720: , p_scs_code => oki_utl_pub.g_all_k_category_code
721: , p_measure_code => oki_load_etr_pvt.g_seq_grw_rate_code
722: , p_measure_code_meaning => l_bin_code_meaning
723: , p_bin_code_seq => l_bin_code_seq

Line 720: , p_scs_code => oki_utl_pub.g_all_k_category_code

716: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
717: , p_organization_name => rec_g_org_csr.organization_name
718: , p_customer_party_id => oki_utl_pub.g_all_customer_id
719: , p_customer_name => oki_utl_pub.g_all_customer_name
720: , p_scs_code => oki_utl_pub.g_all_k_category_code
721: , p_measure_code => oki_load_etr_pvt.g_seq_grw_rate_code
722: , p_measure_code_meaning => l_bin_code_meaning
723: , p_bin_code_seq => l_bin_code_seq
724: , p_measure_value1 => l_curr_value

Line 730: RAISE oki_utl_pub.g_excp_exit_immediate ;

726: , p_measure_value3 => l_status_icon
727: , x_retcode => l_retcode ) ;
728: IF l_retcode = '2' THEN
729: -- Load failed, exit immediately.
730: RAISE oki_utl_pub.g_excp_exit_immediate ;
731: END IF ;
732: ELSE
733: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
734: -- Update the existing record

Line 742: , p_customer_name => oki_utl_pub.g_all_customer_name

738: , p_measure_value3 => l_status_icon
739: , p_measure_code_meaning => l_bin_code_meaning
740: , p_bin_code_seq => l_bin_code_seq
741: , p_organization_name => rec_g_org_csr.organization_name
742: , p_customer_name => oki_utl_pub.g_all_customer_name
743: , p_etr_rowid => rec_g_etr_csr.rowid
744: , x_retcode => l_retcode ) ;
745:
746: IF l_retcode = '2' THEN

Line 748: RAISE oki_utl_pub.g_excp_exit_immediate ;

744: , x_retcode => l_retcode ) ;
745:
746: IF l_retcode = '2' THEN
747: -- Load failed, exit immediately.
748: RAISE oki_utl_pub.g_excp_exit_immediate ;
749: END IF ;
750: END IF ;
751: CLOSE oki_load_etr_pvt.g_etr_csr ;
752:

Line 780: oki_utl_pub.g_glpr_qtr_end_date

776: -- Get the current value
777: l_loc := 'Opening cursor to determine current ' ||
778: l_measure_type || '.' ;
779: OPEN oki_utl_pvt.g_rnwl_oppty_by_org_csr (
780: oki_utl_pub.g_glpr_qtr_end_date
781: , rec_g_org_csr.authoring_org_id ) ;
782: FETCH oki_utl_pvt.g_rnwl_oppty_by_org_csr INTO
783: rec_l_rnwl_oppty_by_org_csr ;
784: IF oki_utl_pvt.g_rnwl_oppty_by_org_csr%FOUND THEN

Line 793: oki_utl_pub.g_py_glpr_qtr_end_date

789: -- Get the previous value
790: l_loc := 'Opening cursor to determine previous ' ||
791: l_measure_type || '.' ;
792: OPEN oki_utl_pvt.g_rnwl_oppty_by_org_csr (
793: oki_utl_pub.g_py_glpr_qtr_end_date
794: , rec_g_org_csr.authoring_org_id ) ;
795: FETCH oki_utl_pvt.g_rnwl_oppty_by_org_csr INTO
796: rec_l_rnwl_oppty_by_org_csr ;
797: IF oki_utl_pvt.g_rnwl_oppty_by_org_csr%FOUND THEN

Line 821: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date

817: END IF ;
818:
819: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
820: -- Determine if the record is a new one or an existing one
821: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
822: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
823: , oki_utl_pub.g_all_k_category_code
824: , oki_load_etr_pvt.g_rnwl_oppty_code ) ;
825: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;

Line 822: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id

818:
819: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
820: -- Determine if the record is a new one or an existing one
821: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
822: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
823: , oki_utl_pub.g_all_k_category_code
824: , oki_load_etr_pvt.g_rnwl_oppty_code ) ;
825: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
826: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN

Line 823: , oki_utl_pub.g_all_k_category_code

819: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
820: -- Determine if the record is a new one or an existing one
821: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
822: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
823: , oki_utl_pub.g_all_k_category_code
824: , oki_load_etr_pvt.g_rnwl_oppty_code ) ;
825: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
826: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
827: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 830: p_summary_build_date => oki_utl_pub.g_summary_build_date

826: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
827: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
828: -- Insert the new record
829: oki_load_etr_pvt.ins_exp_to_rnwl(
830: p_summary_build_date => oki_utl_pub.g_summary_build_date
831: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
832: , p_organization_name => rec_g_org_csr.organization_name
833: , p_customer_party_id => oki_utl_pub.g_all_customer_id
834: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 833: , p_customer_party_id => oki_utl_pub.g_all_customer_id

829: oki_load_etr_pvt.ins_exp_to_rnwl(
830: p_summary_build_date => oki_utl_pub.g_summary_build_date
831: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
832: , p_organization_name => rec_g_org_csr.organization_name
833: , p_customer_party_id => oki_utl_pub.g_all_customer_id
834: , p_customer_name => oki_utl_pub.g_all_customer_name
835: , p_scs_code => oki_utl_pub.g_all_k_category_code
836: , p_measure_code => oki_load_etr_pvt.g_rnwl_oppty_code
837: , p_measure_code_meaning => l_bin_code_meaning

Line 834: , p_customer_name => oki_utl_pub.g_all_customer_name

830: p_summary_build_date => oki_utl_pub.g_summary_build_date
831: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
832: , p_organization_name => rec_g_org_csr.organization_name
833: , p_customer_party_id => oki_utl_pub.g_all_customer_id
834: , p_customer_name => oki_utl_pub.g_all_customer_name
835: , p_scs_code => oki_utl_pub.g_all_k_category_code
836: , p_measure_code => oki_load_etr_pvt.g_rnwl_oppty_code
837: , p_measure_code_meaning => l_bin_code_meaning
838: , p_bin_code_seq => l_bin_code_seq

Line 835: , p_scs_code => oki_utl_pub.g_all_k_category_code

831: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
832: , p_organization_name => rec_g_org_csr.organization_name
833: , p_customer_party_id => oki_utl_pub.g_all_customer_id
834: , p_customer_name => oki_utl_pub.g_all_customer_name
835: , p_scs_code => oki_utl_pub.g_all_k_category_code
836: , p_measure_code => oki_load_etr_pvt.g_rnwl_oppty_code
837: , p_measure_code_meaning => l_bin_code_meaning
838: , p_bin_code_seq => l_bin_code_seq
839: , p_measure_value1 => l_curr_value

Line 845: RAISE oki_utl_pub.g_excp_exit_immediate ;

841: , p_measure_value3 => l_status_icon
842: , x_retcode => l_retcode ) ;
843: IF l_retcode = '2' THEN
844: -- Load failed, exit immediately.
845: RAISE oki_utl_pub.g_excp_exit_immediate ;
846: END IF ;
847: ELSE
848: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
849: -- Update the existing record

Line 857: , p_customer_name => oki_utl_pub.g_all_customer_name

853: , p_measure_value3 => l_status_icon
854: , p_measure_code_meaning => l_bin_code_meaning
855: , p_bin_code_seq => l_bin_code_seq
856: , p_organization_name => rec_g_org_csr.organization_name
857: , p_customer_name => oki_utl_pub.g_all_customer_name
858: , p_etr_rowid => rec_g_etr_csr.rowid
859: , x_retcode => l_retcode ) ;
860:
861: IF l_retcode = '2' THEN

Line 863: RAISE oki_utl_pub.g_excp_exit_immediate ;

859: , x_retcode => l_retcode ) ;
860:
861: IF l_retcode = '2' THEN
862: -- Load failed, exit immediately.
863: RAISE oki_utl_pub.g_excp_exit_immediate ;
864: END IF ;
865: END IF ;
866: CLOSE oki_load_etr_pvt.g_etr_csr ;
867:

Line 901: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date

897:
898:
899: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
900: -- Determine if the record is a new one or an existing one
901: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
902: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
903: , oki_utl_pub.g_all_k_category_code
904: , oki_load_etr_pvt.g_auto_rnwl_vol_code ) ;
905: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;

Line 902: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id

898:
899: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
900: -- Determine if the record is a new one or an existing one
901: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
902: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
903: , oki_utl_pub.g_all_k_category_code
904: , oki_load_etr_pvt.g_auto_rnwl_vol_code ) ;
905: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
906: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN

Line 903: , oki_utl_pub.g_all_k_category_code

899: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
900: -- Determine if the record is a new one or an existing one
901: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
902: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
903: , oki_utl_pub.g_all_k_category_code
904: , oki_load_etr_pvt.g_auto_rnwl_vol_code ) ;
905: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
906: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
907: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 910: p_summary_build_date => oki_utl_pub.g_summary_build_date

906: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
907: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
908: -- Insert the new record
909: oki_load_etr_pvt.ins_exp_to_rnwl(
910: p_summary_build_date => oki_utl_pub.g_summary_build_date
911: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
912: , p_organization_name => rec_g_org_csr.organization_name
913: , p_customer_party_id => oki_utl_pub.g_all_customer_id
914: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 911: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

907: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
908: -- Insert the new record
909: oki_load_etr_pvt.ins_exp_to_rnwl(
910: p_summary_build_date => oki_utl_pub.g_summary_build_date
911: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
912: , p_organization_name => rec_g_org_csr.organization_name
913: , p_customer_party_id => oki_utl_pub.g_all_customer_id
914: , p_customer_name => oki_utl_pub.g_all_customer_name
915: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 913: , p_customer_party_id => oki_utl_pub.g_all_customer_id

909: oki_load_etr_pvt.ins_exp_to_rnwl(
910: p_summary_build_date => oki_utl_pub.g_summary_build_date
911: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
912: , p_organization_name => rec_g_org_csr.organization_name
913: , p_customer_party_id => oki_utl_pub.g_all_customer_id
914: , p_customer_name => oki_utl_pub.g_all_customer_name
915: , p_scs_code => oki_utl_pub.g_all_k_category_code
916: , p_measure_code => oki_load_etr_pvt.g_auto_rnwl_vol_code
917: , p_measure_code_meaning => l_bin_code_meaning

Line 914: , p_customer_name => oki_utl_pub.g_all_customer_name

910: p_summary_build_date => oki_utl_pub.g_summary_build_date
911: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
912: , p_organization_name => rec_g_org_csr.organization_name
913: , p_customer_party_id => oki_utl_pub.g_all_customer_id
914: , p_customer_name => oki_utl_pub.g_all_customer_name
915: , p_scs_code => oki_utl_pub.g_all_k_category_code
916: , p_measure_code => oki_load_etr_pvt.g_auto_rnwl_vol_code
917: , p_measure_code_meaning => l_bin_code_meaning
918: , p_bin_code_seq => l_bin_code_seq

Line 915: , p_scs_code => oki_utl_pub.g_all_k_category_code

911: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
912: , p_organization_name => rec_g_org_csr.organization_name
913: , p_customer_party_id => oki_utl_pub.g_all_customer_id
914: , p_customer_name => oki_utl_pub.g_all_customer_name
915: , p_scs_code => oki_utl_pub.g_all_k_category_code
916: , p_measure_code => oki_load_etr_pvt.g_auto_rnwl_vol_code
917: , p_measure_code_meaning => l_bin_code_meaning
918: , p_bin_code_seq => l_bin_code_seq
919: , p_measure_value1 => l_curr_value

Line 925: RAISE oki_utl_pub.g_excp_exit_immediate ;

921: , p_measure_value3 => NULL
922: , x_retcode => l_retcode ) ;
923: IF l_retcode = '2' THEN
924: -- Load failed, exit immediately.
925: RAISE oki_utl_pub.g_excp_exit_immediate ;
926: END IF ;
927: ELSE
928: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
929: -- Update the existing record

Line 937: , p_customer_name => oki_utl_pub.g_all_customer_name

933: , p_measure_value3 => NULL
934: , p_measure_code_meaning => l_bin_code_meaning
935: , p_bin_code_seq => l_bin_code_seq
936: , p_organization_name => rec_g_org_csr.organization_name
937: , p_customer_name => oki_utl_pub.g_all_customer_name
938: , p_etr_rowid => rec_g_etr_csr.rowid
939: , x_retcode => l_retcode ) ;
940:
941: IF l_retcode = '2' THEN

Line 943: RAISE oki_utl_pub.g_excp_exit_immediate ;

939: , x_retcode => l_retcode ) ;
940:
941: IF l_retcode = '2' THEN
942: -- Load failed, exit immediately.
943: RAISE oki_utl_pub.g_excp_exit_immediate ;
944: END IF ;
945: END IF ;
946: CLOSE oki_load_etr_pvt.g_etr_csr ;
947:

Line 978: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date,

974:
975:
976: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
977: -- Determine if the record is a new one or an existing one
978: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date,
979: oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id,
980: oki_utl_pub.g_all_k_category_code, oki_load_etr_pvt.g_auto_rnwl_rate_code ) ;
981: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
982: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN

Line 979: oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id,

975:
976: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
977: -- Determine if the record is a new one or an existing one
978: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date,
979: oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id,
980: oki_utl_pub.g_all_k_category_code, oki_load_etr_pvt.g_auto_rnwl_rate_code ) ;
981: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
982: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
983: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 980: oki_utl_pub.g_all_k_category_code, oki_load_etr_pvt.g_auto_rnwl_rate_code ) ;

976: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
977: -- Determine if the record is a new one or an existing one
978: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date,
979: oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id,
980: oki_utl_pub.g_all_k_category_code, oki_load_etr_pvt.g_auto_rnwl_rate_code ) ;
981: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
982: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
983: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
984: -- Insert the new record

Line 986: p_summary_build_date => oki_utl_pub.g_summary_build_date

982: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
983: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
984: -- Insert the new record
985: oki_load_etr_pvt.ins_exp_to_rnwl(
986: p_summary_build_date => oki_utl_pub.g_summary_build_date
987: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
988: , p_organization_name => rec_g_org_csr.organization_name
989: , p_customer_party_id => oki_utl_pub.g_all_customer_id
990: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 987: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

983: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
984: -- Insert the new record
985: oki_load_etr_pvt.ins_exp_to_rnwl(
986: p_summary_build_date => oki_utl_pub.g_summary_build_date
987: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
988: , p_organization_name => rec_g_org_csr.organization_name
989: , p_customer_party_id => oki_utl_pub.g_all_customer_id
990: , p_customer_name => oki_utl_pub.g_all_customer_name
991: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 989: , p_customer_party_id => oki_utl_pub.g_all_customer_id

985: oki_load_etr_pvt.ins_exp_to_rnwl(
986: p_summary_build_date => oki_utl_pub.g_summary_build_date
987: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
988: , p_organization_name => rec_g_org_csr.organization_name
989: , p_customer_party_id => oki_utl_pub.g_all_customer_id
990: , p_customer_name => oki_utl_pub.g_all_customer_name
991: , p_scs_code => oki_utl_pub.g_all_k_category_code
992: , p_measure_code => oki_load_etr_pvt.g_auto_rnwl_rate_code
993: , p_measure_code_meaning => l_bin_code_meaning

Line 990: , p_customer_name => oki_utl_pub.g_all_customer_name

986: p_summary_build_date => oki_utl_pub.g_summary_build_date
987: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
988: , p_organization_name => rec_g_org_csr.organization_name
989: , p_customer_party_id => oki_utl_pub.g_all_customer_id
990: , p_customer_name => oki_utl_pub.g_all_customer_name
991: , p_scs_code => oki_utl_pub.g_all_k_category_code
992: , p_measure_code => oki_load_etr_pvt.g_auto_rnwl_rate_code
993: , p_measure_code_meaning => l_bin_code_meaning
994: , p_bin_code_seq => l_bin_code_seq

Line 991: , p_scs_code => oki_utl_pub.g_all_k_category_code

987: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
988: , p_organization_name => rec_g_org_csr.organization_name
989: , p_customer_party_id => oki_utl_pub.g_all_customer_id
990: , p_customer_name => oki_utl_pub.g_all_customer_name
991: , p_scs_code => oki_utl_pub.g_all_k_category_code
992: , p_measure_code => oki_load_etr_pvt.g_auto_rnwl_rate_code
993: , p_measure_code_meaning => l_bin_code_meaning
994: , p_bin_code_seq => l_bin_code_seq
995: , p_measure_value1 => l_curr_value

Line 1001: RAISE oki_utl_pub.g_excp_exit_immediate ;

997: , p_measure_value3 => NULL
998: , x_retcode => l_retcode ) ;
999: IF l_retcode = '2' THEN
1000: -- Load failed, exit immediately.
1001: RAISE oki_utl_pub.g_excp_exit_immediate ;
1002: END IF ;
1003: ELSE
1004: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1005: -- Update the existing record

Line 1013: , p_customer_name => oki_utl_pub.g_all_customer_name

1009: , p_measure_value3 => NULL
1010: , p_measure_code_meaning => l_bin_code_meaning
1011: , p_bin_code_seq => l_bin_code_seq
1012: , p_organization_name => rec_g_org_csr.organization_name
1013: , p_customer_name => oki_utl_pub.g_all_customer_name
1014: , p_etr_rowid => rec_g_etr_csr.rowid
1015: , x_retcode => l_retcode ) ;
1016:
1017: IF l_retcode = '2' THEN

Line 1019: RAISE oki_utl_pub.g_excp_exit_immediate ;

1015: , x_retcode => l_retcode ) ;
1016:
1017: IF l_retcode = '2' THEN
1018: -- Load failed, exit immediately.
1019: RAISE oki_utl_pub.g_excp_exit_immediate ;
1020: END IF ;
1021: END IF ;
1022: CLOSE oki_load_etr_pvt.g_etr_csr ;
1023:

Line 1057: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date,

1053:
1054:
1055: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
1056: -- Determine if the record is a new one or an existing one
1057: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date,
1058: oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id,
1059: oki_utl_pub.g_all_k_category_code, oki_load_etr_pvt.g_rnwl_prc_uplft_code ) ;
1060: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
1061: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN

Line 1058: oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id,

1054:
1055: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
1056: -- Determine if the record is a new one or an existing one
1057: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date,
1058: oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id,
1059: oki_utl_pub.g_all_k_category_code, oki_load_etr_pvt.g_rnwl_prc_uplft_code ) ;
1060: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
1061: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
1062: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 1059: oki_utl_pub.g_all_k_category_code, oki_load_etr_pvt.g_rnwl_prc_uplft_code ) ;

1055: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
1056: -- Determine if the record is a new one or an existing one
1057: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date,
1058: oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id,
1059: oki_utl_pub.g_all_k_category_code, oki_load_etr_pvt.g_rnwl_prc_uplft_code ) ;
1060: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
1061: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
1062: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1063: -- Insert the new record

Line 1065: p_summary_build_date => oki_utl_pub.g_summary_build_date

1061: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
1062: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1063: -- Insert the new record
1064: oki_load_etr_pvt.ins_exp_to_rnwl(
1065: p_summary_build_date => oki_utl_pub.g_summary_build_date
1066: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1067: , p_organization_name => rec_g_org_csr.organization_name
1068: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1069: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 1066: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

1062: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1063: -- Insert the new record
1064: oki_load_etr_pvt.ins_exp_to_rnwl(
1065: p_summary_build_date => oki_utl_pub.g_summary_build_date
1066: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1067: , p_organization_name => rec_g_org_csr.organization_name
1068: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1069: , p_customer_name => oki_utl_pub.g_all_customer_name
1070: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 1068: , p_customer_party_id => oki_utl_pub.g_all_customer_id

1064: oki_load_etr_pvt.ins_exp_to_rnwl(
1065: p_summary_build_date => oki_utl_pub.g_summary_build_date
1066: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1067: , p_organization_name => rec_g_org_csr.organization_name
1068: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1069: , p_customer_name => oki_utl_pub.g_all_customer_name
1070: , p_scs_code => oki_utl_pub.g_all_k_category_code
1071: , p_measure_code => oki_load_etr_pvt.g_rnwl_prc_uplft_code
1072: , p_measure_code_meaning => l_bin_code_meaning

Line 1069: , p_customer_name => oki_utl_pub.g_all_customer_name

1065: p_summary_build_date => oki_utl_pub.g_summary_build_date
1066: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1067: , p_organization_name => rec_g_org_csr.organization_name
1068: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1069: , p_customer_name => oki_utl_pub.g_all_customer_name
1070: , p_scs_code => oki_utl_pub.g_all_k_category_code
1071: , p_measure_code => oki_load_etr_pvt.g_rnwl_prc_uplft_code
1072: , p_measure_code_meaning => l_bin_code_meaning
1073: , p_bin_code_seq => l_bin_code_seq

Line 1070: , p_scs_code => oki_utl_pub.g_all_k_category_code

1066: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1067: , p_organization_name => rec_g_org_csr.organization_name
1068: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1069: , p_customer_name => oki_utl_pub.g_all_customer_name
1070: , p_scs_code => oki_utl_pub.g_all_k_category_code
1071: , p_measure_code => oki_load_etr_pvt.g_rnwl_prc_uplft_code
1072: , p_measure_code_meaning => l_bin_code_meaning
1073: , p_bin_code_seq => l_bin_code_seq
1074: , p_measure_value1 => l_curr_value

Line 1080: RAISE oki_utl_pub.g_excp_exit_immediate ;

1076: , p_measure_value3 => NULL
1077: , x_retcode => l_retcode ) ;
1078: IF l_retcode = '2' THEN
1079: -- Load failed, exit immediately.
1080: RAISE oki_utl_pub.g_excp_exit_immediate ;
1081: END IF ;
1082: ELSE
1083: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1084: -- Update the existing record

Line 1092: , p_customer_name => oki_utl_pub.g_all_customer_name

1088: , p_measure_value3 => NULL
1089: , p_measure_code_meaning => l_bin_code_meaning
1090: , p_bin_code_seq => l_bin_code_seq
1091: , p_organization_name => rec_g_org_csr.organization_name
1092: , p_customer_name => oki_utl_pub.g_all_customer_name
1093: , p_etr_rowid => rec_g_etr_csr.rowid
1094: , x_retcode => l_retcode ) ;
1095:
1096: IF l_retcode = '2' THEN

Line 1098: RAISE oki_utl_pub.g_excp_exit_immediate ;

1094: , x_retcode => l_retcode ) ;
1095:
1096: IF l_retcode = '2' THEN
1097: -- Load failed, exit immediately.
1098: RAISE oki_utl_pub.g_excp_exit_immediate ;
1099: END IF ;
1100: END IF ;
1101: CLOSE oki_load_etr_pvt.g_etr_csr ;
1102: */

Line 1106: WHEN oki_utl_pub.g_excp_exit_immediate THEN

1102: */
1103: END LOOP g_org_csr_loop ;
1104:
1105: EXCEPTION
1106: WHEN oki_utl_pub.g_excp_exit_immediate THEN
1107: -- Do not log an error ; It has already been logged.
1108: -- Set return code to error
1109: x_retcode := '2' ;
1110:

Line 1231: AND oki_utl_pub.g_contract_limit) expiredtilldate

1227: AND p_summary_build_date
1228: AND ( shd.date_terminated IS NULL
1229: OR shd.date_terminated > p_summary_build_date )
1230: AND shd.base_contract_amount BETWEEN 0
1231: AND oki_utl_pub.g_contract_limit) expiredtilldate
1232: , ( SELECT count(shd.chr_id) value
1233: FROM oki_sales_k_hdrs shd
1234: WHERE shd.is_new_yn IS NULL
1235: AND shd.date_signed IS NOT NULL

Line 1239: BETWEEN 0 AND oki_utl_pub.g_contract_limit) rnwinqtr;

1235: AND shd.date_signed IS NOT NULL
1236: AND shd.date_signed BETWEEN p_qtr_start_date
1237: AND p_summary_build_date
1238: AND shd.base_contract_amount
1239: BETWEEN 0 AND oki_utl_pub.g_contract_limit) rnwinqtr;
1240:
1241:
1242: /*
1243: SELECT DECODE( (k_exp_qtd.value + bklg_k_qsd.value )

Line 1257: BETWEEN 0 AND oki_utl_pub.g_contract_limit

1253: AND p_summary_build_date
1254: AND GREATEST(shd.date_signed, shd.date_approved) <=
1255: p_summary_build_date
1256: AND shd.base_contract_amount
1257: BETWEEN 0 AND oki_utl_pub.g_contract_limit
1258: ) k_rnw_qtd
1259: , ( SELECT COUNT(shd.chr_id) value
1260: FROM oki_sales_k_hdrs shd
1261: WHERE shd.is_new_yn IS NULL

Line 1268: BETWEEN 0 AND oki_utl_pub.g_contract_limit

1264: AND shd.start_date < p_qtr_start_date
1265: AND GREATEST(shd.date_signed, shd.date_approved )
1266: BETWEEN p_qtr_start_date AND p_summary_build_date
1267: AND shd.base_contract_amount
1268: BETWEEN 0 AND oki_utl_pub.g_contract_limit
1269: ) all_bklg_qsd
1270: , ( SELECT COUNT(shd.chr_id) value
1271: FROM oki_sales_k_hdrs shd
1272: WHERE shd.date_signed <= p_qtr_start_date

Line 1278: BETWEEN 0 AND oki_utl_pub.g_contract_limit

1274: AND shd.end_date
1275: BETWEEN p_qtr_start_date AND p_summary_build_date
1276: AND shd.date_terminated IS NULL
1277: AND shd.base_contract_amount
1278: BETWEEN 0 AND oki_utl_pub.g_contract_limit
1279: ) k_exp_qtd
1280: , ( SELECT COUNT(shd.chr_id) value
1281: FROM oki_sales_k_hdrs shd
1282: WHERE shd.is_new_yn IS NULL

Line 1289: BETWEEN 0 AND oki_utl_pub.g_contract_limit

1285: AND ( shd.date_signed IS NULL
1286: OR shd.date_signed >= p_qtr_start_date )
1287: AND shd.start_date < p_qtr_start_date
1288: AND shd.base_contract_amount
1289: BETWEEN 0 AND oki_utl_pub.g_contract_limit
1290: ) bklg_k_qsd ;
1291: */
1292: rec_l_rnwl_rate_csr l_rnwl_rate_csr%ROWTYPE ;
1293:

Line 1306: AND oki_utl_pub.g_contract_limit

1302: AND shd.is_new_yn IS NULL
1303: AND shd.date_signed IS NULL
1304: AND shd.date_canceled IS NULL
1305: AND shd.contract_amount BETWEEN 0
1306: AND oki_utl_pub.g_contract_limit
1307: ;
1308: rec_l_rnwl_oppty_csr l_rnwl_oppty_csr%ROWTYPE ;
1309:
1310:

Line 1345: OPEN oki_utl_pvt.g_tactk_all_csr ( oki_utl_pub.g_summary_build_date ) ;

1341:
1342: -- Get the current value
1343: l_loc := 'Opening cursor to determine current ' ||
1344: l_measure_type || '.' ;
1345: OPEN oki_utl_pvt.g_tactk_all_csr ( oki_utl_pub.g_summary_build_date ) ;
1346: FETCH oki_utl_pvt.g_tactk_all_csr INTO rec_l_tactk_all_csr ;
1347: IF oki_utl_pvt.g_tactk_all_csr%FOUND THEN
1348: l_curr_tactk_value := rec_l_tactk_all_csr.value ;
1349: l_curr_value := rec_l_tactk_all_csr.value ;

Line 1356: OPEN oki_utl_pvt.g_tactk_all_csr ( oki_utl_pub.g_py_summary_build_date ) ;

1352:
1353: -- Get the previous value
1354: l_loc := 'Opening Cursor to determine previous ' ||
1355: l_measure_type || '.' ;
1356: OPEN oki_utl_pvt.g_tactk_all_csr ( oki_utl_pub.g_py_summary_build_date ) ;
1357: FETCH oki_utl_pvt.g_tactk_all_csr INTO rec_l_tactk_all_csr ;
1358: IF oki_utl_pvt.g_tactk_all_csr%FOUND THEN
1359: l_prev_tactk_value := rec_l_tactk_all_csr.value ;
1360: l_prev_value := rec_l_tactk_all_csr.value ;

Line 1382: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date

1378: END IF ;
1379:
1380: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1381: -- Determine if the record is a new one or an existing one
1382: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1383: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1384: , oki_utl_pub.g_all_k_category_code, oki_load_etr_pvt.g_tactk_code ) ;
1385: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
1386: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN

Line 1383: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id

1379:
1380: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1381: -- Determine if the record is a new one or an existing one
1382: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1383: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1384: , oki_utl_pub.g_all_k_category_code, oki_load_etr_pvt.g_tactk_code ) ;
1385: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
1386: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
1387: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 1384: , oki_utl_pub.g_all_k_category_code, oki_load_etr_pvt.g_tactk_code ) ;

1380: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1381: -- Determine if the record is a new one or an existing one
1382: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1383: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1384: , oki_utl_pub.g_all_k_category_code, oki_load_etr_pvt.g_tactk_code ) ;
1385: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
1386: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
1387: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1388: -- Insert the new record

Line 1390: p_summary_build_date => oki_utl_pub.g_summary_build_date

1386: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
1387: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1388: -- Insert the new record
1389: oki_load_etr_pvt.ins_exp_to_rnwl(
1390: p_summary_build_date => oki_utl_pub.g_summary_build_date
1391: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1392: , p_organization_name => oki_utl_pub.g_all_organization_name
1393: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1394: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 1391: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

1387: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1388: -- Insert the new record
1389: oki_load_etr_pvt.ins_exp_to_rnwl(
1390: p_summary_build_date => oki_utl_pub.g_summary_build_date
1391: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1392: , p_organization_name => oki_utl_pub.g_all_organization_name
1393: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1394: , p_customer_name => oki_utl_pub.g_all_customer_name
1395: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 1392: , p_organization_name => oki_utl_pub.g_all_organization_name

1388: -- Insert the new record
1389: oki_load_etr_pvt.ins_exp_to_rnwl(
1390: p_summary_build_date => oki_utl_pub.g_summary_build_date
1391: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1392: , p_organization_name => oki_utl_pub.g_all_organization_name
1393: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1394: , p_customer_name => oki_utl_pub.g_all_customer_name
1395: , p_scs_code => oki_utl_pub.g_all_k_category_code
1396: , p_measure_code => oki_load_etr_pvt.g_tactk_code

Line 1393: , p_customer_party_id => oki_utl_pub.g_all_customer_id

1389: oki_load_etr_pvt.ins_exp_to_rnwl(
1390: p_summary_build_date => oki_utl_pub.g_summary_build_date
1391: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1392: , p_organization_name => oki_utl_pub.g_all_organization_name
1393: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1394: , p_customer_name => oki_utl_pub.g_all_customer_name
1395: , p_scs_code => oki_utl_pub.g_all_k_category_code
1396: , p_measure_code => oki_load_etr_pvt.g_tactk_code
1397: , p_measure_code_meaning => l_bin_code_meaning

Line 1394: , p_customer_name => oki_utl_pub.g_all_customer_name

1390: p_summary_build_date => oki_utl_pub.g_summary_build_date
1391: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1392: , p_organization_name => oki_utl_pub.g_all_organization_name
1393: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1394: , p_customer_name => oki_utl_pub.g_all_customer_name
1395: , p_scs_code => oki_utl_pub.g_all_k_category_code
1396: , p_measure_code => oki_load_etr_pvt.g_tactk_code
1397: , p_measure_code_meaning => l_bin_code_meaning
1398: , p_bin_code_seq => l_bin_code_seq

Line 1395: , p_scs_code => oki_utl_pub.g_all_k_category_code

1391: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1392: , p_organization_name => oki_utl_pub.g_all_organization_name
1393: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1394: , p_customer_name => oki_utl_pub.g_all_customer_name
1395: , p_scs_code => oki_utl_pub.g_all_k_category_code
1396: , p_measure_code => oki_load_etr_pvt.g_tactk_code
1397: , p_measure_code_meaning => l_bin_code_meaning
1398: , p_bin_code_seq => l_bin_code_seq
1399: , p_measure_value1 => l_curr_value

Line 1405: RAISE oki_utl_pub.g_excp_exit_immediate ;

1401: , p_measure_value3 => l_status_icon
1402: , x_retcode => l_retcode ) ;
1403: IF l_retcode = '2' THEN
1404: -- Load failed, exit immediately.
1405: RAISE oki_utl_pub.g_excp_exit_immediate ;
1406: END IF ;
1407: ELSE
1408: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1409: -- Update the existing record

Line 1416: , p_organization_name => oki_utl_pub.g_all_organization_name

1412: , p_measure_value2 => l_pct_change
1413: , p_measure_value3 => l_status_icon
1414: , p_measure_code_meaning => l_bin_code_meaning
1415: , p_bin_code_seq => l_bin_code_seq
1416: , p_organization_name => oki_utl_pub.g_all_organization_name
1417: , p_customer_name => oki_utl_pub.g_all_customer_name
1418: , p_etr_rowid => rec_g_etr_csr.rowid
1419: , x_retcode => l_retcode ) ;
1420:

Line 1417: , p_customer_name => oki_utl_pub.g_all_customer_name

1413: , p_measure_value3 => l_status_icon
1414: , p_measure_code_meaning => l_bin_code_meaning
1415: , p_bin_code_seq => l_bin_code_seq
1416: , p_organization_name => oki_utl_pub.g_all_organization_name
1417: , p_customer_name => oki_utl_pub.g_all_customer_name
1418: , p_etr_rowid => rec_g_etr_csr.rowid
1419: , x_retcode => l_retcode ) ;
1420:
1421: IF l_retcode = '2' THEN

Line 1423: RAISE oki_utl_pub.g_excp_exit_immediate ;

1419: , x_retcode => l_retcode ) ;
1420:
1421: IF l_retcode = '2' THEN
1422: -- Load failed, exit immediately.
1423: RAISE oki_utl_pub.g_excp_exit_immediate ;
1424: END IF ;
1425: END IF ;
1426: CLOSE oki_load_etr_pvt.g_etr_csr ;
1427:

Line 1457: oki_utl_pub.g_glpr_qtr_start_date,

1453: /*
1454: l_loc := 'Opening cursor to determine current ' || l_measure_type ;
1455: l_loc := l_loc || ' for exp in Qtr.' ;
1456: OPEN oki_utl_pvt.g_k_exp_in_qtr_all_csr (
1457: oki_utl_pub.g_glpr_qtr_start_date,
1458: oki_utl_pub.g_glpr_qtr_end_date ) ;
1459: FETCH oki_utl_pvt.g_k_exp_in_qtr_all_csr INTO rec_l_k_exp_in_qtr_all_csr ;
1460: IF oki_utl_pvt.g_k_exp_in_qtr_all_csr%FOUND THEN
1461: l_exp_in_qtr_count := rec_l_k_exp_in_qtr_all_csr.contract_count ;

Line 1458: oki_utl_pub.g_glpr_qtr_end_date ) ;

1454: l_loc := 'Opening cursor to determine current ' || l_measure_type ;
1455: l_loc := l_loc || ' for exp in Qtr.' ;
1456: OPEN oki_utl_pvt.g_k_exp_in_qtr_all_csr (
1457: oki_utl_pub.g_glpr_qtr_start_date,
1458: oki_utl_pub.g_glpr_qtr_end_date ) ;
1459: FETCH oki_utl_pvt.g_k_exp_in_qtr_all_csr INTO rec_l_k_exp_in_qtr_all_csr ;
1460: IF oki_utl_pvt.g_k_exp_in_qtr_all_csr%FOUND THEN
1461: l_exp_in_qtr_count := rec_l_k_exp_in_qtr_all_csr.contract_count ;
1462: END IF ;

Line 1468: OPEN l_rnwl_rate_csr ( oki_utl_pub.g_summary_build_date,

1464: */
1465:
1466: -- Get the current value
1467: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1468: OPEN l_rnwl_rate_csr ( oki_utl_pub.g_summary_build_date,
1469: oki_utl_pub.g_glpr_qtr_start_date ) ;
1470: FETCH l_rnwl_rate_csr INTO rec_l_rnwl_rate_csr ;
1471: IF l_rnwl_rate_csr%FOUND THEN
1472: l_curr_value := rec_l_rnwl_rate_csr.value ;

Line 1469: oki_utl_pub.g_glpr_qtr_start_date ) ;

1465:
1466: -- Get the current value
1467: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1468: OPEN l_rnwl_rate_csr ( oki_utl_pub.g_summary_build_date,
1469: oki_utl_pub.g_glpr_qtr_start_date ) ;
1470: FETCH l_rnwl_rate_csr INTO rec_l_rnwl_rate_csr ;
1471: IF l_rnwl_rate_csr%FOUND THEN
1472: l_curr_value := rec_l_rnwl_rate_csr.value ;
1473: END IF ;

Line 1478: OPEN l_rnwl_rate_csr ( oki_utl_pub.g_py_summary_build_date,

1474: CLOSE l_rnwl_rate_csr ;
1475:
1476: -- Get the previous value
1477: l_loc := 'Opening cursor to determine previous ' || l_measure_type || '.' ;
1478: OPEN l_rnwl_rate_csr ( oki_utl_pub.g_py_summary_build_date,
1479: oki_utl_pub.g_py_glpr_qtr_start_date ) ;
1480: FETCH l_rnwl_rate_csr INTO rec_l_rnwl_rate_csr ;
1481: IF l_rnwl_rate_csr%FOUND THEN
1482: l_prev_value := rec_l_rnwl_rate_csr.value ;

Line 1479: oki_utl_pub.g_py_glpr_qtr_start_date ) ;

1475:
1476: -- Get the previous value
1477: l_loc := 'Opening cursor to determine previous ' || l_measure_type || '.' ;
1478: OPEN l_rnwl_rate_csr ( oki_utl_pub.g_py_summary_build_date,
1479: oki_utl_pub.g_py_glpr_qtr_start_date ) ;
1480: FETCH l_rnwl_rate_csr INTO rec_l_rnwl_rate_csr ;
1481: IF l_rnwl_rate_csr%FOUND THEN
1482: l_prev_value := rec_l_rnwl_rate_csr.value ;
1483: END IF ;

Line 1504: OPEN l_rnwl_rate_csr ( oki_utl_pub.g_summary_build_date,

1500: END IF ;
1501:
1502: /*
1503: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1504: OPEN l_rnwl_rate_csr ( oki_utl_pub.g_summary_build_date,
1505: oki_utl_pub.g_glpr_qtr_start_date, oki_utl_pub.g_glpr_qtr_end_date,
1506: l_exp_in_qtr_count ) ;
1507: FETCH l_rnwl_rate_csr INTO rec_l_rnwl_rate_csr ;
1508: IF l_rnwl_rate_csr%FOUND THEN

Line 1505: oki_utl_pub.g_glpr_qtr_start_date, oki_utl_pub.g_glpr_qtr_end_date,

1501:
1502: /*
1503: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1504: OPEN l_rnwl_rate_csr ( oki_utl_pub.g_summary_build_date,
1505: oki_utl_pub.g_glpr_qtr_start_date, oki_utl_pub.g_glpr_qtr_end_date,
1506: l_exp_in_qtr_count ) ;
1507: FETCH l_rnwl_rate_csr INTO rec_l_rnwl_rate_csr ;
1508: IF l_rnwl_rate_csr%FOUND THEN
1509: l_curr_value := rec_l_rnwl_rate_csr.value ;

Line 1515: OPEN l_rnwl_rate_csr ( oki_utl_pub.g_summary_build_date,

1511: CLOSE l_rnwl_rate_csr ;
1512: */
1513: /*
1514: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1515: OPEN l_rnwl_rate_csr ( oki_utl_pub.g_summary_build_date,
1516: oki_utl_pub.g_glpr_qtr_start_date, oki_utl_pub.g_glpr_qtr_end_date ) ;
1517: FETCH l_rnwl_rate_csr INTO rec_l_rnwl_rate_csr ;
1518: IF l_rnwl_rate_csr%FOUND THEN
1519: l_curr_value := rec_l_rnwl_rate_csr.value ;

Line 1516: oki_utl_pub.g_glpr_qtr_start_date, oki_utl_pub.g_glpr_qtr_end_date ) ;

1512: */
1513: /*
1514: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1515: OPEN l_rnwl_rate_csr ( oki_utl_pub.g_summary_build_date,
1516: oki_utl_pub.g_glpr_qtr_start_date, oki_utl_pub.g_glpr_qtr_end_date ) ;
1517: FETCH l_rnwl_rate_csr INTO rec_l_rnwl_rate_csr ;
1518: IF l_rnwl_rate_csr%FOUND THEN
1519: l_curr_value := rec_l_rnwl_rate_csr.value ;
1520: END IF ;

Line 1525: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date

1521: CLOSE l_rnwl_rate_csr ;
1522: */
1523: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1524: -- Determine if the record is a new one or an existing one
1525: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1526: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1527: , oki_utl_pub.g_all_k_category_code
1528: , oki_load_etr_pvt.g_rnwl_rate_code ) ;
1529: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;

Line 1526: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id

1522: */
1523: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1524: -- Determine if the record is a new one or an existing one
1525: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1526: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1527: , oki_utl_pub.g_all_k_category_code
1528: , oki_load_etr_pvt.g_rnwl_rate_code ) ;
1529: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
1530: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN

Line 1527: , oki_utl_pub.g_all_k_category_code

1523: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1524: -- Determine if the record is a new one or an existing one
1525: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1526: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1527: , oki_utl_pub.g_all_k_category_code
1528: , oki_load_etr_pvt.g_rnwl_rate_code ) ;
1529: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
1530: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
1531: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 1534: p_summary_build_date => oki_utl_pub.g_summary_build_date

1530: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
1531: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1532: -- Insert the new record
1533: oki_load_etr_pvt.ins_exp_to_rnwl(
1534: p_summary_build_date => oki_utl_pub.g_summary_build_date
1535: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1536: , p_organization_name => oki_utl_pub.g_all_organization_name
1537: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1538: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 1535: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

1531: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1532: -- Insert the new record
1533: oki_load_etr_pvt.ins_exp_to_rnwl(
1534: p_summary_build_date => oki_utl_pub.g_summary_build_date
1535: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1536: , p_organization_name => oki_utl_pub.g_all_organization_name
1537: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1538: , p_customer_name => oki_utl_pub.g_all_customer_name
1539: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 1536: , p_organization_name => oki_utl_pub.g_all_organization_name

1532: -- Insert the new record
1533: oki_load_etr_pvt.ins_exp_to_rnwl(
1534: p_summary_build_date => oki_utl_pub.g_summary_build_date
1535: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1536: , p_organization_name => oki_utl_pub.g_all_organization_name
1537: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1538: , p_customer_name => oki_utl_pub.g_all_customer_name
1539: , p_scs_code => oki_utl_pub.g_all_k_category_code
1540: , p_measure_code => oki_load_etr_pvt.g_rnwl_rate_code

Line 1537: , p_customer_party_id => oki_utl_pub.g_all_customer_id

1533: oki_load_etr_pvt.ins_exp_to_rnwl(
1534: p_summary_build_date => oki_utl_pub.g_summary_build_date
1535: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1536: , p_organization_name => oki_utl_pub.g_all_organization_name
1537: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1538: , p_customer_name => oki_utl_pub.g_all_customer_name
1539: , p_scs_code => oki_utl_pub.g_all_k_category_code
1540: , p_measure_code => oki_load_etr_pvt.g_rnwl_rate_code
1541: , p_measure_code_meaning => l_bin_code_meaning

Line 1538: , p_customer_name => oki_utl_pub.g_all_customer_name

1534: p_summary_build_date => oki_utl_pub.g_summary_build_date
1535: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1536: , p_organization_name => oki_utl_pub.g_all_organization_name
1537: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1538: , p_customer_name => oki_utl_pub.g_all_customer_name
1539: , p_scs_code => oki_utl_pub.g_all_k_category_code
1540: , p_measure_code => oki_load_etr_pvt.g_rnwl_rate_code
1541: , p_measure_code_meaning => l_bin_code_meaning
1542: , p_bin_code_seq => l_bin_code_seq

Line 1539: , p_scs_code => oki_utl_pub.g_all_k_category_code

1535: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1536: , p_organization_name => oki_utl_pub.g_all_organization_name
1537: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1538: , p_customer_name => oki_utl_pub.g_all_customer_name
1539: , p_scs_code => oki_utl_pub.g_all_k_category_code
1540: , p_measure_code => oki_load_etr_pvt.g_rnwl_rate_code
1541: , p_measure_code_meaning => l_bin_code_meaning
1542: , p_bin_code_seq => l_bin_code_seq
1543: , p_measure_value1 => l_curr_value

Line 1549: RAISE oki_utl_pub.g_excp_exit_immediate ;

1545: , p_measure_value3 => l_status_icon
1546: , x_retcode => l_retcode ) ;
1547: IF l_retcode = '2' THEN
1548: -- Load failed, exit immediately.
1549: RAISE oki_utl_pub.g_excp_exit_immediate ;
1550: END IF ;
1551: ELSE
1552: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1553: -- Update the existing record

Line 1560: , p_organization_name => oki_utl_pub.g_all_organization_name

1556: , p_measure_value2 => l_pct_change
1557: , p_measure_value3 => l_status_icon
1558: , p_measure_code_meaning => l_bin_code_meaning
1559: , p_bin_code_seq => l_bin_code_seq
1560: , p_organization_name => oki_utl_pub.g_all_organization_name
1561: , p_customer_name => oki_utl_pub.g_all_customer_name
1562: , p_etr_rowid => rec_g_etr_csr.rowid
1563: , x_retcode => l_retcode ) ;
1564:

Line 1561: , p_customer_name => oki_utl_pub.g_all_customer_name

1557: , p_measure_value3 => l_status_icon
1558: , p_measure_code_meaning => l_bin_code_meaning
1559: , p_bin_code_seq => l_bin_code_seq
1560: , p_organization_name => oki_utl_pub.g_all_organization_name
1561: , p_customer_name => oki_utl_pub.g_all_customer_name
1562: , p_etr_rowid => rec_g_etr_csr.rowid
1563: , x_retcode => l_retcode ) ;
1564:
1565: IF l_retcode = '2' THEN

Line 1567: RAISE oki_utl_pub.g_excp_exit_immediate ;

1563: , x_retcode => l_retcode ) ;
1564:
1565: IF l_retcode = '2' THEN
1566: -- Load failed, exit immediately.
1567: RAISE oki_utl_pub.g_excp_exit_immediate ;
1568: END IF ;
1569: END IF ;
1570: CLOSE oki_load_etr_pvt.g_etr_csr ;
1571:

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

1593: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
1594:
1595: l_loc := 'Opening cursor to determine current' || l_measure_type || '.' ;
1596: -- Get the active contracts as of the start of the quarter
1597: OPEN oki_utl_pvt.g_tactk_all_csr ( oki_utl_pub.g_glpr_qtr_start_date ) ;
1598: FETCH oki_utl_pvt.g_tactk_all_csr INTO rec_l_tactk_all_csr ;
1599: IF oki_utl_pvt.g_tactk_all_csr%FOUND THEN
1600: l_qsd_tactk_value := rec_l_tactk_all_csr.value ;
1601: END IF ;

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

1613:
1614: -- Get the current value
1615: l_loc := 'Opening cursor to determine previous ' || l_measure_type || '.' ;
1616: -- Get the active contracts as of the start of the quarter
1617: OPEN oki_utl_pvt.g_tactk_all_csr ( oki_utl_pub.g_py_glpr_qtr_start_date ) ;
1618: FETCH oki_utl_pvt.g_tactk_all_csr INTO rec_l_tactk_all_csr ;
1619: IF oki_utl_pvt.g_tactk_all_csr%FOUND THEN
1620: l_py_qsd_tactk_value := rec_l_tactk_all_csr.value ;
1621: END IF ;

Line 1654: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date

1650: END IF ;
1651:
1652: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
1653: -- Determine if the record is a new one or an existing one
1654: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1655: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1656: , oki_utl_pub.g_all_k_category_code
1657: , oki_load_etr_pvt.g_seq_grw_rate_code ) ;
1658: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;

Line 1655: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id

1651:
1652: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
1653: -- Determine if the record is a new one or an existing one
1654: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1655: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1656: , oki_utl_pub.g_all_k_category_code
1657: , oki_load_etr_pvt.g_seq_grw_rate_code ) ;
1658: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
1659: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN

Line 1656: , oki_utl_pub.g_all_k_category_code

1652: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
1653: -- Determine if the record is a new one or an existing one
1654: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1655: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1656: , oki_utl_pub.g_all_k_category_code
1657: , oki_load_etr_pvt.g_seq_grw_rate_code ) ;
1658: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
1659: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
1660: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 1663: p_summary_build_date => oki_utl_pub.g_summary_build_date

1659: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
1660: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1661: -- Insert the new record
1662: oki_load_etr_pvt.ins_exp_to_rnwl(
1663: p_summary_build_date => oki_utl_pub.g_summary_build_date
1664: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1665: , p_organization_name => oki_utl_pub.g_all_organization_name
1666: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1667: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 1664: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

1660: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1661: -- Insert the new record
1662: oki_load_etr_pvt.ins_exp_to_rnwl(
1663: p_summary_build_date => oki_utl_pub.g_summary_build_date
1664: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1665: , p_organization_name => oki_utl_pub.g_all_organization_name
1666: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1667: , p_customer_name => oki_utl_pub.g_all_customer_name
1668: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 1665: , p_organization_name => oki_utl_pub.g_all_organization_name

1661: -- Insert the new record
1662: oki_load_etr_pvt.ins_exp_to_rnwl(
1663: p_summary_build_date => oki_utl_pub.g_summary_build_date
1664: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1665: , p_organization_name => oki_utl_pub.g_all_organization_name
1666: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1667: , p_customer_name => oki_utl_pub.g_all_customer_name
1668: , p_scs_code => oki_utl_pub.g_all_k_category_code
1669: , p_measure_code => oki_load_etr_pvt.g_seq_grw_rate_code

Line 1666: , p_customer_party_id => oki_utl_pub.g_all_customer_id

1662: oki_load_etr_pvt.ins_exp_to_rnwl(
1663: p_summary_build_date => oki_utl_pub.g_summary_build_date
1664: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1665: , p_organization_name => oki_utl_pub.g_all_organization_name
1666: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1667: , p_customer_name => oki_utl_pub.g_all_customer_name
1668: , p_scs_code => oki_utl_pub.g_all_k_category_code
1669: , p_measure_code => oki_load_etr_pvt.g_seq_grw_rate_code
1670: , p_measure_code_meaning => l_bin_code_meaning

Line 1667: , p_customer_name => oki_utl_pub.g_all_customer_name

1663: p_summary_build_date => oki_utl_pub.g_summary_build_date
1664: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1665: , p_organization_name => oki_utl_pub.g_all_organization_name
1666: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1667: , p_customer_name => oki_utl_pub.g_all_customer_name
1668: , p_scs_code => oki_utl_pub.g_all_k_category_code
1669: , p_measure_code => oki_load_etr_pvt.g_seq_grw_rate_code
1670: , p_measure_code_meaning => l_bin_code_meaning
1671: , p_bin_code_seq => l_bin_code_seq

Line 1668: , p_scs_code => oki_utl_pub.g_all_k_category_code

1664: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1665: , p_organization_name => oki_utl_pub.g_all_organization_name
1666: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1667: , p_customer_name => oki_utl_pub.g_all_customer_name
1668: , p_scs_code => oki_utl_pub.g_all_k_category_code
1669: , p_measure_code => oki_load_etr_pvt.g_seq_grw_rate_code
1670: , p_measure_code_meaning => l_bin_code_meaning
1671: , p_bin_code_seq => l_bin_code_seq
1672: , p_measure_value1 => l_curr_value

Line 1678: RAISE oki_utl_pub.g_excp_exit_immediate ;

1674: , p_measure_value3 => l_status_icon
1675: , x_retcode => l_retcode ) ;
1676: IF l_retcode = '2' THEN
1677: -- Load failed, exit immediately.
1678: RAISE oki_utl_pub.g_excp_exit_immediate ;
1679: END IF ;
1680: ELSE
1681: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1682: -- Update the existing record

Line 1689: , p_organization_name => oki_utl_pub.g_all_organization_name

1685: , p_measure_value2 => l_pct_change
1686: , p_measure_value3 => l_status_icon
1687: , p_measure_code_meaning => l_bin_code_meaning
1688: , p_bin_code_seq => l_bin_code_seq
1689: , p_organization_name => oki_utl_pub.g_all_organization_name
1690: , p_customer_name => oki_utl_pub.g_all_customer_name
1691: , p_etr_rowid => rec_g_etr_csr.rowid
1692: , x_retcode => l_retcode ) ;
1693:

Line 1690: , p_customer_name => oki_utl_pub.g_all_customer_name

1686: , p_measure_value3 => l_status_icon
1687: , p_measure_code_meaning => l_bin_code_meaning
1688: , p_bin_code_seq => l_bin_code_seq
1689: , p_organization_name => oki_utl_pub.g_all_organization_name
1690: , p_customer_name => oki_utl_pub.g_all_customer_name
1691: , p_etr_rowid => rec_g_etr_csr.rowid
1692: , x_retcode => l_retcode ) ;
1693:
1694: IF l_retcode = '2' THEN

Line 1696: RAISE oki_utl_pub.g_excp_exit_immediate ;

1692: , x_retcode => l_retcode ) ;
1693:
1694: IF l_retcode = '2' THEN
1695: -- Load failed, exit immediately.
1696: RAISE oki_utl_pub.g_excp_exit_immediate ;
1697: END IF ;
1698: END IF ;
1699: CLOSE oki_load_etr_pvt.g_etr_csr ;
1700:

Line 1726: OPEN oki_utl_pvt.g_rnwl_oppty_all_csr ( oki_utl_pub.g_glpr_qtr_end_date ) ;

1722: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
1723:
1724: -- Get the current value
1725: l_loc := 'Opening cursor to determine ' || l_measure_type || '.' ;
1726: OPEN oki_utl_pvt.g_rnwl_oppty_all_csr ( oki_utl_pub.g_glpr_qtr_end_date ) ;
1727: FETCH oki_utl_pvt.g_rnwl_oppty_all_csr INTO rec_l_rnwl_oppty_all_csr ;
1728: IF oki_utl_pvt.g_rnwl_oppty_all_csr%FOUND THEN
1729: l_curr_value := rec_l_rnwl_oppty_all_csr.value ;
1730: END IF ;

Line 1735: OPEN oki_utl_pvt.g_rnwl_oppty_all_csr ( oki_utl_pub.g_py_glpr_qtr_end_date ) ;

1731: CLOSE oki_utl_pvt.g_rnwl_oppty_all_csr ;
1732:
1733: -- Get the previous value
1734: l_loc := 'Opening cursor to determine ' || l_measure_type || '.' ;
1735: OPEN oki_utl_pvt.g_rnwl_oppty_all_csr ( oki_utl_pub.g_py_glpr_qtr_end_date ) ;
1736: FETCH oki_utl_pvt.g_rnwl_oppty_all_csr INTO rec_l_rnwl_oppty_all_csr ;
1737: IF oki_utl_pvt.g_rnwl_oppty_all_csr%FOUND THEN
1738: l_prev_value := rec_l_rnwl_oppty_all_csr.value ;
1739: END IF ;

Line 1760: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date

1756: END IF ;
1757:
1758: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
1759: -- Determine if the record is a new one or an existing one
1760: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1761: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1762: , oki_utl_pub.g_all_k_category_code
1763: , oki_load_etr_pvt.g_rnwl_oppty_code ) ;
1764: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;

Line 1761: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id

1757:
1758: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
1759: -- Determine if the record is a new one or an existing one
1760: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1761: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1762: , oki_utl_pub.g_all_k_category_code
1763: , oki_load_etr_pvt.g_rnwl_oppty_code ) ;
1764: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
1765: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN

Line 1762: , oki_utl_pub.g_all_k_category_code

1758: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
1759: -- Determine if the record is a new one or an existing one
1760: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1761: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1762: , oki_utl_pub.g_all_k_category_code
1763: , oki_load_etr_pvt.g_rnwl_oppty_code ) ;
1764: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
1765: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
1766: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 1769: p_summary_build_date => oki_utl_pub.g_summary_build_date

1765: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
1766: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1767: -- Insert the new record
1768: oki_load_etr_pvt.ins_exp_to_rnwl(
1769: p_summary_build_date => oki_utl_pub.g_summary_build_date
1770: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1771: , p_organization_name => oki_utl_pub.g_all_organization_name
1772: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1773: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 1770: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

1766: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1767: -- Insert the new record
1768: oki_load_etr_pvt.ins_exp_to_rnwl(
1769: p_summary_build_date => oki_utl_pub.g_summary_build_date
1770: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1771: , p_organization_name => oki_utl_pub.g_all_organization_name
1772: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1773: , p_customer_name => oki_utl_pub.g_all_customer_name
1774: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 1771: , p_organization_name => oki_utl_pub.g_all_organization_name

1767: -- Insert the new record
1768: oki_load_etr_pvt.ins_exp_to_rnwl(
1769: p_summary_build_date => oki_utl_pub.g_summary_build_date
1770: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1771: , p_organization_name => oki_utl_pub.g_all_organization_name
1772: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1773: , p_customer_name => oki_utl_pub.g_all_customer_name
1774: , p_scs_code => oki_utl_pub.g_all_k_category_code
1775: , p_measure_code => oki_load_etr_pvt.g_rnwl_oppty_code

Line 1772: , p_customer_party_id => oki_utl_pub.g_all_customer_id

1768: oki_load_etr_pvt.ins_exp_to_rnwl(
1769: p_summary_build_date => oki_utl_pub.g_summary_build_date
1770: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1771: , p_organization_name => oki_utl_pub.g_all_organization_name
1772: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1773: , p_customer_name => oki_utl_pub.g_all_customer_name
1774: , p_scs_code => oki_utl_pub.g_all_k_category_code
1775: , p_measure_code => oki_load_etr_pvt.g_rnwl_oppty_code
1776: , p_measure_code_meaning => l_bin_code_meaning

Line 1773: , p_customer_name => oki_utl_pub.g_all_customer_name

1769: p_summary_build_date => oki_utl_pub.g_summary_build_date
1770: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1771: , p_organization_name => oki_utl_pub.g_all_organization_name
1772: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1773: , p_customer_name => oki_utl_pub.g_all_customer_name
1774: , p_scs_code => oki_utl_pub.g_all_k_category_code
1775: , p_measure_code => oki_load_etr_pvt.g_rnwl_oppty_code
1776: , p_measure_code_meaning => l_bin_code_meaning
1777: , p_bin_code_seq => l_bin_code_seq

Line 1774: , p_scs_code => oki_utl_pub.g_all_k_category_code

1770: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1771: , p_organization_name => oki_utl_pub.g_all_organization_name
1772: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1773: , p_customer_name => oki_utl_pub.g_all_customer_name
1774: , p_scs_code => oki_utl_pub.g_all_k_category_code
1775: , p_measure_code => oki_load_etr_pvt.g_rnwl_oppty_code
1776: , p_measure_code_meaning => l_bin_code_meaning
1777: , p_bin_code_seq => l_bin_code_seq
1778: , p_measure_value1 => l_curr_value

Line 1784: RAISE oki_utl_pub.g_excp_exit_immediate ;

1780: , p_measure_value3 => l_status_icon
1781: , x_retcode => l_retcode ) ;
1782: IF l_retcode = '2' THEN
1783: -- Load failed, exit immediately.
1784: RAISE oki_utl_pub.g_excp_exit_immediate ;
1785: END IF ;
1786: ELSE
1787: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1788: -- Update the existing record

Line 1795: , p_organization_name => oki_utl_pub.g_all_organization_name

1791: , p_measure_value2 => l_pct_change
1792: , p_measure_value3 => l_status_icon
1793: , p_measure_code_meaning => l_bin_code_meaning
1794: , p_bin_code_seq => l_bin_code_seq
1795: , p_organization_name => oki_utl_pub.g_all_organization_name
1796: , p_customer_name => oki_utl_pub.g_all_customer_name
1797: , p_etr_rowid => rec_g_etr_csr.rowid
1798: , x_retcode => l_retcode ) ;
1799:

Line 1796: , p_customer_name => oki_utl_pub.g_all_customer_name

1792: , p_measure_value3 => l_status_icon
1793: , p_measure_code_meaning => l_bin_code_meaning
1794: , p_bin_code_seq => l_bin_code_seq
1795: , p_organization_name => oki_utl_pub.g_all_organization_name
1796: , p_customer_name => oki_utl_pub.g_all_customer_name
1797: , p_etr_rowid => rec_g_etr_csr.rowid
1798: , x_retcode => l_retcode ) ;
1799:
1800: IF l_retcode = '2' THEN

Line 1802: RAISE oki_utl_pub.g_excp_exit_immediate ;

1798: , x_retcode => l_retcode ) ;
1799:
1800: IF l_retcode = '2' THEN
1801: -- Load failed, exit immediately.
1802: RAISE oki_utl_pub.g_excp_exit_immediate ;
1803: END IF ;
1804: END IF ;
1805: CLOSE oki_load_etr_pvt.g_etr_csr ;
1806:

Line 1836: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date

1832:
1833:
1834: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
1835: -- Determine if the record is a new one or an existing one
1836: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1837: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1838: , oki_utl_pub.g_all_k_category_code
1839: , oki_load_etr_pvt.g_auto_rnwl_vol_code ) ;
1840: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;

Line 1837: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id

1833:
1834: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
1835: -- Determine if the record is a new one or an existing one
1836: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1837: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1838: , oki_utl_pub.g_all_k_category_code
1839: , oki_load_etr_pvt.g_auto_rnwl_vol_code ) ;
1840: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
1841: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN

Line 1838: , oki_utl_pub.g_all_k_category_code

1834: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
1835: -- Determine if the record is a new one or an existing one
1836: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1837: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1838: , oki_utl_pub.g_all_k_category_code
1839: , oki_load_etr_pvt.g_auto_rnwl_vol_code ) ;
1840: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
1841: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
1842: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 1845: p_summary_build_date => oki_utl_pub.g_summary_build_date

1841: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
1842: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1843: -- Insert the new record
1844: oki_load_etr_pvt.ins_exp_to_rnwl(
1845: p_summary_build_date => oki_utl_pub.g_summary_build_date
1846: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1847: , p_organization_name => oki_utl_pub.g_all_organization_name
1848: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1849: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 1846: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

1842: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1843: -- Insert the new record
1844: oki_load_etr_pvt.ins_exp_to_rnwl(
1845: p_summary_build_date => oki_utl_pub.g_summary_build_date
1846: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1847: , p_organization_name => oki_utl_pub.g_all_organization_name
1848: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1849: , p_customer_name => oki_utl_pub.g_all_customer_name
1850: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 1847: , p_organization_name => oki_utl_pub.g_all_organization_name

1843: -- Insert the new record
1844: oki_load_etr_pvt.ins_exp_to_rnwl(
1845: p_summary_build_date => oki_utl_pub.g_summary_build_date
1846: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1847: , p_organization_name => oki_utl_pub.g_all_organization_name
1848: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1849: , p_customer_name => oki_utl_pub.g_all_customer_name
1850: , p_scs_code => oki_utl_pub.g_all_k_category_code
1851: , p_measure_code_meaning => l_bin_code_meaning

Line 1848: , p_customer_party_id => oki_utl_pub.g_all_customer_id

1844: oki_load_etr_pvt.ins_exp_to_rnwl(
1845: p_summary_build_date => oki_utl_pub.g_summary_build_date
1846: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1847: , p_organization_name => oki_utl_pub.g_all_organization_name
1848: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1849: , p_customer_name => oki_utl_pub.g_all_customer_name
1850: , p_scs_code => oki_utl_pub.g_all_k_category_code
1851: , p_measure_code_meaning => l_bin_code_meaning
1852: , p_bin_code_seq => l_bin_code_seq

Line 1849: , p_customer_name => oki_utl_pub.g_all_customer_name

1845: p_summary_build_date => oki_utl_pub.g_summary_build_date
1846: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1847: , p_organization_name => oki_utl_pub.g_all_organization_name
1848: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1849: , p_customer_name => oki_utl_pub.g_all_customer_name
1850: , p_scs_code => oki_utl_pub.g_all_k_category_code
1851: , p_measure_code_meaning => l_bin_code_meaning
1852: , p_bin_code_seq => l_bin_code_seq
1853: , p_measure_code => oki_load_etr_pvt.g_auto_rnwl_vol_code

Line 1850: , p_scs_code => oki_utl_pub.g_all_k_category_code

1846: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1847: , p_organization_name => oki_utl_pub.g_all_organization_name
1848: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1849: , p_customer_name => oki_utl_pub.g_all_customer_name
1850: , p_scs_code => oki_utl_pub.g_all_k_category_code
1851: , p_measure_code_meaning => l_bin_code_meaning
1852: , p_bin_code_seq => l_bin_code_seq
1853: , p_measure_code => oki_load_etr_pvt.g_auto_rnwl_vol_code
1854: , p_measure_value1 => l_curr_value

Line 1860: RAISE oki_utl_pub.g_excp_exit_immediate ;

1856: , p_measure_value3 => NULL
1857: , x_retcode => l_retcode ) ;
1858: IF l_retcode = '2' THEN
1859: -- Load failed, exit immediately.
1860: RAISE oki_utl_pub.g_excp_exit_immediate ;
1861: END IF ;
1862: ELSE
1863: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1864: -- Update the existing record

Line 1871: , p_organization_name => oki_utl_pub.g_all_organization_name

1867: , p_measure_value2 => NULL
1868: , p_measure_value3 => NULL
1869: , p_measure_code_meaning => l_bin_code_meaning
1870: , p_bin_code_seq => l_bin_code_seq
1871: , p_organization_name => oki_utl_pub.g_all_organization_name
1872: , p_customer_name => oki_utl_pub.g_all_customer_name
1873: , p_etr_rowid => rec_g_etr_csr.rowid
1874: , x_retcode => l_retcode ) ;
1875:

Line 1872: , p_customer_name => oki_utl_pub.g_all_customer_name

1868: , p_measure_value3 => NULL
1869: , p_measure_code_meaning => l_bin_code_meaning
1870: , p_bin_code_seq => l_bin_code_seq
1871: , p_organization_name => oki_utl_pub.g_all_organization_name
1872: , p_customer_name => oki_utl_pub.g_all_customer_name
1873: , p_etr_rowid => rec_g_etr_csr.rowid
1874: , x_retcode => l_retcode ) ;
1875:
1876: IF l_retcode = '2' THEN

Line 1878: RAISE oki_utl_pub.g_excp_exit_immediate ;

1874: , x_retcode => l_retcode ) ;
1875:
1876: IF l_retcode = '2' THEN
1877: -- Load failed, exit immediately.
1878: RAISE oki_utl_pub.g_excp_exit_immediate ;
1879: END IF ;
1880: END IF ;
1881: CLOSE oki_load_etr_pvt.g_etr_csr ;
1882:

Line 1912: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date

1908: l_curr_value := NULL ;
1909:
1910: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
1911: -- Determine if the record is a new one or an existing one
1912: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1913: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1914: , oki_utl_pub.g_all_k_category_code
1915: , oki_load_etr_pvt.g_auto_rnwl_rate_code ) ;
1916: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;

Line 1913: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id

1909:
1910: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
1911: -- Determine if the record is a new one or an existing one
1912: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1913: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1914: , oki_utl_pub.g_all_k_category_code
1915: , oki_load_etr_pvt.g_auto_rnwl_rate_code ) ;
1916: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
1917: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN

Line 1914: , oki_utl_pub.g_all_k_category_code

1910: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
1911: -- Determine if the record is a new one or an existing one
1912: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1913: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1914: , oki_utl_pub.g_all_k_category_code
1915: , oki_load_etr_pvt.g_auto_rnwl_rate_code ) ;
1916: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
1917: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
1918: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 1921: p_summary_build_date => oki_utl_pub.g_summary_build_date

1917: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
1918: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1919: -- Insert the new record
1920: oki_load_etr_pvt.ins_exp_to_rnwl(
1921: p_summary_build_date => oki_utl_pub.g_summary_build_date
1922: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1923: , p_organization_name => oki_utl_pub.g_all_organization_name
1924: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1925: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 1922: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

1918: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1919: -- Insert the new record
1920: oki_load_etr_pvt.ins_exp_to_rnwl(
1921: p_summary_build_date => oki_utl_pub.g_summary_build_date
1922: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1923: , p_organization_name => oki_utl_pub.g_all_organization_name
1924: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1925: , p_customer_name => oki_utl_pub.g_all_customer_name
1926: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 1923: , p_organization_name => oki_utl_pub.g_all_organization_name

1919: -- Insert the new record
1920: oki_load_etr_pvt.ins_exp_to_rnwl(
1921: p_summary_build_date => oki_utl_pub.g_summary_build_date
1922: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1923: , p_organization_name => oki_utl_pub.g_all_organization_name
1924: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1925: , p_customer_name => oki_utl_pub.g_all_customer_name
1926: , p_scs_code => oki_utl_pub.g_all_k_category_code
1927: , p_measure_code => oki_load_etr_pvt.g_auto_rnwl_rate_code

Line 1924: , p_customer_party_id => oki_utl_pub.g_all_customer_id

1920: oki_load_etr_pvt.ins_exp_to_rnwl(
1921: p_summary_build_date => oki_utl_pub.g_summary_build_date
1922: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1923: , p_organization_name => oki_utl_pub.g_all_organization_name
1924: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1925: , p_customer_name => oki_utl_pub.g_all_customer_name
1926: , p_scs_code => oki_utl_pub.g_all_k_category_code
1927: , p_measure_code => oki_load_etr_pvt.g_auto_rnwl_rate_code
1928: , p_measure_code_meaning => l_bin_code_meaning

Line 1925: , p_customer_name => oki_utl_pub.g_all_customer_name

1921: p_summary_build_date => oki_utl_pub.g_summary_build_date
1922: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1923: , p_organization_name => oki_utl_pub.g_all_organization_name
1924: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1925: , p_customer_name => oki_utl_pub.g_all_customer_name
1926: , p_scs_code => oki_utl_pub.g_all_k_category_code
1927: , p_measure_code => oki_load_etr_pvt.g_auto_rnwl_rate_code
1928: , p_measure_code_meaning => l_bin_code_meaning
1929: , p_bin_code_seq => l_bin_code_seq

Line 1926: , p_scs_code => oki_utl_pub.g_all_k_category_code

1922: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1923: , p_organization_name => oki_utl_pub.g_all_organization_name
1924: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1925: , p_customer_name => oki_utl_pub.g_all_customer_name
1926: , p_scs_code => oki_utl_pub.g_all_k_category_code
1927: , p_measure_code => oki_load_etr_pvt.g_auto_rnwl_rate_code
1928: , p_measure_code_meaning => l_bin_code_meaning
1929: , p_bin_code_seq => l_bin_code_seq
1930: , p_measure_value1 => l_curr_value

Line 1936: RAISE oki_utl_pub.g_excp_exit_immediate ;

1932: , p_measure_value3 => NULL
1933: , x_retcode => l_retcode ) ;
1934: IF l_retcode = '2' THEN
1935: -- Load failed, exit immediately.
1936: RAISE oki_utl_pub.g_excp_exit_immediate ;
1937: END IF ;
1938: ELSE
1939: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1940: -- Update the existing record

Line 1947: , p_organization_name => oki_utl_pub.g_all_organization_name

1943: , p_measure_value2 => NULL
1944: , p_measure_value3 => NULL
1945: , p_measure_code_meaning => l_bin_code_meaning
1946: , p_bin_code_seq => l_bin_code_seq
1947: , p_organization_name => oki_utl_pub.g_all_organization_name
1948: , p_customer_name => oki_utl_pub.g_all_customer_name
1949: , p_etr_rowid => rec_g_etr_csr.rowid
1950: , x_retcode => l_retcode ) ;
1951:

Line 1948: , p_customer_name => oki_utl_pub.g_all_customer_name

1944: , p_measure_value3 => NULL
1945: , p_measure_code_meaning => l_bin_code_meaning
1946: , p_bin_code_seq => l_bin_code_seq
1947: , p_organization_name => oki_utl_pub.g_all_organization_name
1948: , p_customer_name => oki_utl_pub.g_all_customer_name
1949: , p_etr_rowid => rec_g_etr_csr.rowid
1950: , x_retcode => l_retcode ) ;
1951:
1952: IF l_retcode = '2' THEN

Line 1954: RAISE oki_utl_pub.g_excp_exit_immediate ;

1950: , x_retcode => l_retcode ) ;
1951:
1952: IF l_retcode = '2' THEN
1953: -- Load failed, exit immediately.
1954: RAISE oki_utl_pub.g_excp_exit_immediate ;
1955: END IF ;
1956: END IF ;
1957: CLOSE oki_load_etr_pvt.g_etr_csr ;
1958:

Line 1989: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date

1985:
1986:
1987: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
1988: -- Determine if the record is a new one or an existing one
1989: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1990: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1991: , oki_utl_pub.g_all_k_category_code
1992: , oki_load_etr_pvt.g_rnwl_prc_uplft_code ) ;
1993: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;

Line 1990: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id

1986:
1987: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
1988: -- Determine if the record is a new one or an existing one
1989: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1990: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1991: , oki_utl_pub.g_all_k_category_code
1992: , oki_load_etr_pvt.g_rnwl_prc_uplft_code ) ;
1993: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
1994: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN

Line 1991: , oki_utl_pub.g_all_k_category_code

1987: l_loc := 'Inserting / updating total ' || l_measure_type || '.' ;
1988: -- Determine if the record is a new one or an existing one
1989: OPEN oki_load_etr_pvt.g_etr_csr ( oki_utl_pub.g_summary_build_date
1990: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1991: , oki_utl_pub.g_all_k_category_code
1992: , oki_load_etr_pvt.g_rnwl_prc_uplft_code ) ;
1993: FETCH oki_load_etr_pvt.g_etr_csr INTO rec_g_etr_csr ;
1994: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
1995: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 1998: p_summary_build_date => oki_utl_pub.g_summary_build_date

1994: IF oki_load_etr_pvt.g_etr_csr%NOTFOUND THEN
1995: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1996: -- Insert the new record
1997: oki_load_etr_pvt.ins_exp_to_rnwl(
1998: p_summary_build_date => oki_utl_pub.g_summary_build_date
1999: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2000: , p_organization_name => oki_utl_pub.g_all_organization_name
2001: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2002: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 1999: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

1995: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1996: -- Insert the new record
1997: oki_load_etr_pvt.ins_exp_to_rnwl(
1998: p_summary_build_date => oki_utl_pub.g_summary_build_date
1999: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2000: , p_organization_name => oki_utl_pub.g_all_organization_name
2001: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2002: , p_customer_name => oki_utl_pub.g_all_customer_name
2003: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 2000: , p_organization_name => oki_utl_pub.g_all_organization_name

1996: -- Insert the new record
1997: oki_load_etr_pvt.ins_exp_to_rnwl(
1998: p_summary_build_date => oki_utl_pub.g_summary_build_date
1999: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2000: , p_organization_name => oki_utl_pub.g_all_organization_name
2001: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2002: , p_customer_name => oki_utl_pub.g_all_customer_name
2003: , p_scs_code => oki_utl_pub.g_all_k_category_code
2004: , p_measure_code_meaning => l_bin_code_meaning

Line 2001: , p_customer_party_id => oki_utl_pub.g_all_customer_id

1997: oki_load_etr_pvt.ins_exp_to_rnwl(
1998: p_summary_build_date => oki_utl_pub.g_summary_build_date
1999: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2000: , p_organization_name => oki_utl_pub.g_all_organization_name
2001: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2002: , p_customer_name => oki_utl_pub.g_all_customer_name
2003: , p_scs_code => oki_utl_pub.g_all_k_category_code
2004: , p_measure_code_meaning => l_bin_code_meaning
2005: , p_bin_code_seq => l_bin_code_seq

Line 2002: , p_customer_name => oki_utl_pub.g_all_customer_name

1998: p_summary_build_date => oki_utl_pub.g_summary_build_date
1999: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2000: , p_organization_name => oki_utl_pub.g_all_organization_name
2001: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2002: , p_customer_name => oki_utl_pub.g_all_customer_name
2003: , p_scs_code => oki_utl_pub.g_all_k_category_code
2004: , p_measure_code_meaning => l_bin_code_meaning
2005: , p_bin_code_seq => l_bin_code_seq
2006: , p_measure_code => oki_load_etr_pvt.g_rnwl_prc_uplft_code

Line 2003: , p_scs_code => oki_utl_pub.g_all_k_category_code

1999: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2000: , p_organization_name => oki_utl_pub.g_all_organization_name
2001: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2002: , p_customer_name => oki_utl_pub.g_all_customer_name
2003: , p_scs_code => oki_utl_pub.g_all_k_category_code
2004: , p_measure_code_meaning => l_bin_code_meaning
2005: , p_bin_code_seq => l_bin_code_seq
2006: , p_measure_code => oki_load_etr_pvt.g_rnwl_prc_uplft_code
2007: , p_measure_value1 => l_curr_value

Line 2013: RAISE oki_utl_pub.g_excp_exit_immediate ;

2009: , p_measure_value3 => NULL
2010: , x_retcode => l_retcode ) ;
2011: IF l_retcode = '2' THEN
2012: -- Load failed, exit immediately.
2013: RAISE oki_utl_pub.g_excp_exit_immediate ;
2014: END IF ;
2015: ELSE
2016: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
2017: -- Update the existing record

Line 2024: , p_organization_name => oki_utl_pub.g_all_organization_name

2020: , p_measure_value2 => NULL
2021: , p_measure_value3 => NULL
2022: , p_measure_code_meaning => l_bin_code_meaning
2023: , p_bin_code_seq => l_bin_code_seq
2024: , p_organization_name => oki_utl_pub.g_all_organization_name
2025: , p_customer_name => oki_utl_pub.g_all_customer_name
2026: , p_etr_rowid => rec_g_etr_csr.rowid
2027: , x_retcode => l_retcode ) ;
2028:

Line 2025: , p_customer_name => oki_utl_pub.g_all_customer_name

2021: , p_measure_value3 => NULL
2022: , p_measure_code_meaning => l_bin_code_meaning
2023: , p_bin_code_seq => l_bin_code_seq
2024: , p_organization_name => oki_utl_pub.g_all_organization_name
2025: , p_customer_name => oki_utl_pub.g_all_customer_name
2026: , p_etr_rowid => rec_g_etr_csr.rowid
2027: , x_retcode => l_retcode ) ;
2028:
2029: IF l_retcode = '2' THEN

Line 2031: RAISE oki_utl_pub.g_excp_exit_immediate ;

2027: , x_retcode => l_retcode ) ;
2028:
2029: IF l_retcode = '2' THEN
2030: -- Load failed, exit immediately.
2031: RAISE oki_utl_pub.g_excp_exit_immediate ;
2032: END IF ;
2033: END IF ;
2034: CLOSE oki_load_etr_pvt.g_etr_csr ;
2035:

Line 2037: WHEN oki_utl_pub.g_excp_exit_immediate THEN

2033: END IF ;
2034: CLOSE oki_load_etr_pvt.g_etr_csr ;
2035:
2036: EXCEPTION
2037: WHEN oki_utl_pub.g_excp_exit_immediate THEN
2038: -- Do not log an error ; It has already been logged.
2039: -- Set return code to error
2040: x_retcode := '2' ;
2041:

Line 2147: oki_utl_pub.g_summary_build_date := l_summary_build_date ;

2143: l_summary_build_date := TRUNC(p_start_summary_build_date) ;
2144:
2145: FOR i IN 1..l_upper_bound LOOP
2146:
2147: oki_utl_pub.g_summary_build_date := l_summary_build_date ;
2148:
2149: -- Get the GL periods start / end date
2150: oki_utl_pvt.get_gl_period_date (
2151: x_retcode => l_retcode ) ;

Line 2155: RAISE oki_utl_pub.g_excp_exit_immediate ;

2151: x_retcode => l_retcode ) ;
2152:
2153: IF l_retcode = '2' THEN
2154: -- Load failed, exit immediately.
2155: RAISE oki_utl_pub.g_excp_exit_immediate ;
2156: END IF ;
2157:
2158: -- Procedure to calculate the amounts for the all level
2159: oki_load_etr_pvt.calc_etr_sum (

Line 2164: RAISE oki_utl_pub.g_excp_exit_immediate ;

2160: x_retcode => l_retcode ) ;
2161:
2162: IF l_retcode = '2' THEN
2163: -- Load failed, exit immediately.
2164: RAISE oki_utl_pub.g_excp_exit_immediate ;
2165: END IF ;
2166:
2167: -- Procedure to calculate the amounts for the organization level
2168: oki_load_etr_pvt.calc_etr_dtl1 (

Line 2173: RAISE oki_utl_pub.g_excp_exit_immediate ;

2169: x_retcode => l_retcode ) ;
2170:
2171: IF l_retcode = '2' THEN
2172: -- Load failed, exit immediately.
2173: RAISE oki_utl_pub.g_excp_exit_immediate ;
2174: END IF ;
2175:
2176: l_summary_build_date := l_summary_build_date + 1 ;
2177:

Line 2213: WHEN oki_utl_pub.g_excp_exit_immediate THEN

2209: x_retcode := l_retcode ;
2210:
2211: ROLLBACK TO oki_etr_upd_refresh ;
2212:
2213: WHEN oki_utl_pub.g_excp_exit_immediate THEN
2214: -- Do not log an error ; It has already been logged.
2215: -- Set return code to error
2216: x_retcode := '2' ;
2217: