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

APPS.OKI_LOAD_RBK_PVT dependencies on OKI_UTL_PUB

Line 281: AND oki_utl_pub.g_contract_limit

277: AND ( shd.date_signed IS NULL
278: OR shd.date_signed >= p_qtr_start_date )
279: AND shd.start_date < p_qtr_start_date
280: AND shd.base_contract_amount BETWEEN 0
281: AND oki_utl_pub.g_contract_limit
282: AND shd.authoring_org_id = p_authoring_org_id
283: ;
284: rec_l_bklg_k_to_rnw_csr l_bklg_k_to_rnw_csr%ROWTYPE ;
285:

Line 304: AND oki_utl_pub.g_contract_limit

300: AND shd.start_date < p_qtr_start_date
301: AND GREATEST(shd.date_signed, shd.date_approved )
302: BETWEEN p_qtr_start_date AND p_summary_build_date
303: AND shd.base_contract_amount BETWEEN 0
304: AND oki_utl_pub.g_contract_limit
305: AND shd.authoring_org_id = p_authoring_org_id
306: ;
307: rec_l_bklg_k_rwned_csr l_bklg_k_rwned_csr%ROWTYPE ;
308:

Line 325: AND oki_utl_pub.g_contract_limit

321: AND shd.date_signed IS NOT NULL
322: AND shd.start_date BETWEEN p_qtr_start_date AND p_qtr_end_date
323: AND GREATEST(shd.date_signed, shd.date_approved) <= p_qtr_end_date
324: AND shd.base_contract_amount BETWEEN 0
325: AND oki_utl_pub.g_contract_limit
326: AND shd.authoring_org_id = p_authoring_org_id
327: ;
328: rec_l_k_rnwed_csr l_k_rnwed_csr%ROWTYPE ;
329:

Line 349: AND oki_utl_pub.g_contract_limit

345: AND p_summary_build_date
346: AND ( shd.date_terminated IS NULL
347: OR shd.date_terminated > p_summary_build_date )
348: AND shd.base_contract_amount BETWEEN 0
349: AND oki_utl_pub.g_contract_limit
350: AND shd.authoring_org_id = p_authoring_org_id
351: ;
352: rec_l_new_bus_csr l_new_bus_csr%ROWTYPE ;
353:

Line 370: AND oki_utl_pub.g_contract_limit

366: AND p_summary_build_date
367: AND shd.date_signed IS NOT NULL
368: AND shd.date_approved IS NOT NULL
369: AND shd.base_contract_amount BETWEEN 0
370: AND oki_utl_pub.g_contract_limit
371: AND shd.authoring_org_id = p_authoring_org_id
372: ;
373: rec_l_trmn_k_csr l_trmn_k_csr%ROWTYPE ;
374:

Line 409: oki_utl_pub.g_glpr_qtr_start_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_glpr_qtr_start_date
410: , rec_g_org_csr.authoring_org_id ) ;
411: FETCH oki_utl_pvt.g_tactk_by_org_csr INTO rec_l_tactk_by_org_csr ;
412: IF oki_utl_pvt.g_tactk_by_org_csr%FOUND THEN
413: l_curr_b_act_k := rec_l_tactk_by_org_csr.value ;

Line 421: oki_utl_pub.g_py_glpr_qtr_start_date,

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

Line 432: oki_utl_pub.g_summary_build_date

428:
429: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
430: -- Determine if the record is a new one or an existing one
431: OPEN oki_load_rbk_pvt.g_rbk_csr (
432: oki_utl_pub.g_summary_build_date
433: , rec_g_org_csr.authoring_org_id
434: , oki_utl_pub.g_all_customer_id
435: , oki_utl_pub.g_all_k_category_code
436: , oki_load_rbk_pvt.g_b_act_k_code ) ;

Line 434: , oki_utl_pub.g_all_customer_id

430: -- Determine if the record is a new one or an existing one
431: OPEN oki_load_rbk_pvt.g_rbk_csr (
432: oki_utl_pub.g_summary_build_date
433: , rec_g_org_csr.authoring_org_id
434: , oki_utl_pub.g_all_customer_id
435: , oki_utl_pub.g_all_k_category_code
436: , oki_load_rbk_pvt.g_b_act_k_code ) ;
437: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
438: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

Line 435: , oki_utl_pub.g_all_k_category_code

431: OPEN oki_load_rbk_pvt.g_rbk_csr (
432: oki_utl_pub.g_summary_build_date
433: , rec_g_org_csr.authoring_org_id
434: , oki_utl_pub.g_all_customer_id
435: , oki_utl_pub.g_all_k_category_code
436: , oki_load_rbk_pvt.g_b_act_k_code ) ;
437: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
438: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
439: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 442: p_summary_build_date => oki_utl_pub.g_summary_build_date

438: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
439: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
440: -- Insert the new record
441: oki_load_rbk_pvt.ins_rnwl_bkng (
442: p_summary_build_date => oki_utl_pub.g_summary_build_date
443: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
444: , p_organization_name => rec_g_org_csr.organization_name
445: , p_customer_party_id => oki_utl_pub.g_all_customer_id
446: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 445: , p_customer_party_id => oki_utl_pub.g_all_customer_id

441: oki_load_rbk_pvt.ins_rnwl_bkng (
442: p_summary_build_date => oki_utl_pub.g_summary_build_date
443: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
444: , p_organization_name => rec_g_org_csr.organization_name
445: , p_customer_party_id => oki_utl_pub.g_all_customer_id
446: , p_customer_name => oki_utl_pub.g_all_customer_name
447: , p_scs_code => oki_utl_pub.g_all_k_category_code
448: , p_measure_code => oki_load_rbk_pvt.g_b_act_k_code
449: , p_measure_code_meaning => l_bin_code_meaning

Line 446: , p_customer_name => oki_utl_pub.g_all_customer_name

442: p_summary_build_date => oki_utl_pub.g_summary_build_date
443: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
444: , p_organization_name => rec_g_org_csr.organization_name
445: , p_customer_party_id => oki_utl_pub.g_all_customer_id
446: , p_customer_name => oki_utl_pub.g_all_customer_name
447: , p_scs_code => oki_utl_pub.g_all_k_category_code
448: , p_measure_code => oki_load_rbk_pvt.g_b_act_k_code
449: , p_measure_code_meaning => l_bin_code_meaning
450: , p_bin_code_seq => l_bin_code_seq

Line 447: , p_scs_code => oki_utl_pub.g_all_k_category_code

443: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
444: , p_organization_name => rec_g_org_csr.organization_name
445: , p_customer_party_id => oki_utl_pub.g_all_customer_id
446: , p_customer_name => oki_utl_pub.g_all_customer_name
447: , p_scs_code => oki_utl_pub.g_all_k_category_code
448: , p_measure_code => oki_load_rbk_pvt.g_b_act_k_code
449: , p_measure_code_meaning => l_bin_code_meaning
450: , p_bin_code_seq => l_bin_code_seq
451: , p_curr_base_contract_amount => l_curr_b_act_k

Line 456: RAISE oki_utl_pub.g_excp_exit_immediate ;

452: , p_prev_base_contract_amount => l_prev_b_act_k
453: , x_retcode => l_retcode ) ;
454: IF l_retcode = '2' THEN
455: -- Load failed, exit immediately.
456: RAISE oki_utl_pub.g_excp_exit_immediate ;
457: END IF ;
458: ELSE
459: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
460: -- Update the existing record

Line 467: , p_customer_name => oki_utl_pub.g_all_customer_name

463: , p_prev_base_contract_amount => l_prev_b_act_k
464: , p_measure_code_meaning => l_bin_code_meaning
465: , p_bin_code_seq => l_bin_code_seq
466: , p_organization_name => rec_g_org_csr.organization_name
467: , p_customer_name => oki_utl_pub.g_all_customer_name
468: , p_rbk_rowid => rec_g_rbk_csr.rowid
469: , x_retcode => l_retcode ) ;
470:
471: IF l_retcode = '2' THEN

Line 473: RAISE oki_utl_pub.g_excp_exit_immediate ;

469: , x_retcode => l_retcode ) ;
470:
471: IF l_retcode = '2' THEN
472: -- Load failed, exit immediately.
473: RAISE oki_utl_pub.g_excp_exit_immediate ;
474: END IF ;
475: END IF ;
476: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
477:

Line 502: oki_utl_pub.g_glpr_qtr_start_date

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

Line 503: , oki_utl_pub.g_glpr_qtr_end_date

499: l_loc := 'Opening cursor to determine current ' ||
500: l_measure_type || '.' ;
501: OPEN oki_utl_pvt.g_k_exp_in_qtr_by_org_csr (
502: oki_utl_pub.g_glpr_qtr_start_date
503: , oki_utl_pub.g_glpr_qtr_end_date
504: , rec_g_org_csr.authoring_org_id ) ;
505: FETCH oki_utl_pvt.g_k_exp_in_qtr_by_org_csr INTO
506: rec_l_k_exp_in_qtr_by_org_csr ;
507: IF oki_utl_pvt.g_k_exp_in_qtr_by_org_csr%FOUND THEN

Line 516: oki_utl_pub.g_py_glpr_qtr_start_date

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

Line 517: , oki_utl_pub.g_py_glpr_qtr_end_date

513: l_loc := 'Opening Cursor to determine previous ' ||
514: l_measure_type || '.' ;
515: OPEN oki_utl_pvt.g_k_exp_in_qtr_by_org_csr (
516: oki_utl_pub.g_py_glpr_qtr_start_date
517: , oki_utl_pub.g_py_glpr_qtr_end_date
518: , rec_g_org_csr.authoring_org_id ) ;
519: FETCH oki_utl_pvt.g_k_exp_in_qtr_by_org_csr INTO
520: rec_l_k_exp_in_qtr_by_org_csr ;
521: IF oki_utl_pvt.g_k_exp_in_qtr_by_org_csr%FOUND THEN

Line 529: oki_utl_pub.g_summary_build_date

525:
526: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
527: -- Determine if the record is a new one or an existing one
528: OPEN oki_load_rbk_pvt.g_rbk_csr (
529: oki_utl_pub.g_summary_build_date
530: , rec_g_org_csr.authoring_org_id
531: , oki_utl_pub.g_all_customer_id
532: , oki_utl_pub.g_all_k_category_code
533: , oki_load_rbk_pvt.g_exp_in_qtr_code ) ;

Line 531: , oki_utl_pub.g_all_customer_id

527: -- Determine if the record is a new one or an existing one
528: OPEN oki_load_rbk_pvt.g_rbk_csr (
529: oki_utl_pub.g_summary_build_date
530: , rec_g_org_csr.authoring_org_id
531: , oki_utl_pub.g_all_customer_id
532: , oki_utl_pub.g_all_k_category_code
533: , oki_load_rbk_pvt.g_exp_in_qtr_code ) ;
534: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
535: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

Line 532: , oki_utl_pub.g_all_k_category_code

528: OPEN oki_load_rbk_pvt.g_rbk_csr (
529: oki_utl_pub.g_summary_build_date
530: , rec_g_org_csr.authoring_org_id
531: , oki_utl_pub.g_all_customer_id
532: , oki_utl_pub.g_all_k_category_code
533: , oki_load_rbk_pvt.g_exp_in_qtr_code ) ;
534: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
535: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
536: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 539: p_summary_build_date => oki_utl_pub.g_summary_build_date

535: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
536: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
537: -- Insert the new record
538: oki_load_rbk_pvt.ins_rnwl_bkng (
539: p_summary_build_date => oki_utl_pub.g_summary_build_date
540: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
541: , p_organization_name => rec_g_org_csr.organization_name
542: , p_customer_party_id => oki_utl_pub.g_all_customer_id
543: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 542: , p_customer_party_id => oki_utl_pub.g_all_customer_id

538: oki_load_rbk_pvt.ins_rnwl_bkng (
539: p_summary_build_date => oki_utl_pub.g_summary_build_date
540: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
541: , p_organization_name => rec_g_org_csr.organization_name
542: , p_customer_party_id => oki_utl_pub.g_all_customer_id
543: , p_customer_name => oki_utl_pub.g_all_customer_name
544: , p_scs_code => oki_utl_pub.g_all_k_category_code
545: , p_measure_code => oki_load_rbk_pvt.g_exp_in_qtr_code
546: , p_measure_code_meaning => l_bin_code_meaning

Line 543: , p_customer_name => oki_utl_pub.g_all_customer_name

539: p_summary_build_date => oki_utl_pub.g_summary_build_date
540: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
541: , p_organization_name => rec_g_org_csr.organization_name
542: , p_customer_party_id => oki_utl_pub.g_all_customer_id
543: , p_customer_name => oki_utl_pub.g_all_customer_name
544: , p_scs_code => oki_utl_pub.g_all_k_category_code
545: , p_measure_code => oki_load_rbk_pvt.g_exp_in_qtr_code
546: , p_measure_code_meaning => l_bin_code_meaning
547: , p_bin_code_seq => l_bin_code_seq

Line 544: , p_scs_code => oki_utl_pub.g_all_k_category_code

540: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
541: , p_organization_name => rec_g_org_csr.organization_name
542: , p_customer_party_id => oki_utl_pub.g_all_customer_id
543: , p_customer_name => oki_utl_pub.g_all_customer_name
544: , p_scs_code => oki_utl_pub.g_all_k_category_code
545: , p_measure_code => oki_load_rbk_pvt.g_exp_in_qtr_code
546: , p_measure_code_meaning => l_bin_code_meaning
547: , p_bin_code_seq => l_bin_code_seq
548: , p_curr_base_contract_amount => l_curr_k_exp_in_qtr

Line 553: RAISE oki_utl_pub.g_excp_exit_immediate ;

549: , p_prev_base_contract_amount => l_prev_k_exp_in_qtr
550: , x_retcode => l_retcode ) ;
551: IF l_retcode = '2' THEN
552: -- Load failed, exit immediately.
553: RAISE oki_utl_pub.g_excp_exit_immediate ;
554: END IF ;
555: ELSE
556: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
557: -- Update the existing record

Line 564: , p_customer_name => oki_utl_pub.g_all_customer_name

560: , p_prev_base_contract_amount => l_prev_k_exp_in_qtr
561: , p_measure_code_meaning => l_bin_code_meaning
562: , p_bin_code_seq => l_bin_code_seq
563: , p_organization_name => rec_g_org_csr.organization_name
564: , p_customer_name => oki_utl_pub.g_all_customer_name
565: , p_rbk_rowid => rec_g_rbk_csr.rowid
566: , x_retcode => l_retcode ) ;
567:
568: IF l_retcode = '2' THEN

Line 570: RAISE oki_utl_pub.g_excp_exit_immediate ;

566: , x_retcode => l_retcode ) ;
567:
568: IF l_retcode = '2' THEN
569: -- Load failed, exit immediately.
570: RAISE oki_utl_pub.g_excp_exit_immediate ;
571: END IF ;
572: END IF ;
573: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
574:

Line 598: OPEN l_bklg_k_to_rnw_csr ( oki_utl_pub.g_glpr_qtr_start_date,

594:
595: -- Get the current value
596: l_loc := 'Opening cursor to determine current ' ||
597: l_measure_type || '.' ;
598: OPEN l_bklg_k_to_rnw_csr ( oki_utl_pub.g_glpr_qtr_start_date,
599: rec_g_org_csr.authoring_org_id ) ;
600: FETCH l_bklg_k_to_rnw_csr INTO rec_l_bklg_k_to_rnw_csr ;
601: IF l_bklg_k_to_rnw_csr%FOUND THEN
602: l_curr_bklg_k_to_rnw := rec_l_bklg_k_to_rnw_csr.value ;

Line 609: OPEN l_bklg_k_to_rnw_csr ( oki_utl_pub.g_py_glpr_qtr_start_date,

605:
606: -- Get the previous value
607: l_loc := 'Opening Cursor to determine previous ' ||
608: l_measure_type || '.' ;
609: OPEN l_bklg_k_to_rnw_csr ( oki_utl_pub.g_py_glpr_qtr_start_date,
610: rec_g_org_csr.authoring_org_id ) ;
611: FETCH l_bklg_k_to_rnw_csr INTO rec_l_bklg_k_to_rnw_csr ;
612: IF l_bklg_k_to_rnw_csr%FOUND THEN
613: l_prev_bklg_k_to_rnw := rec_l_bklg_k_to_rnw_csr.value ;

Line 619: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date

615: CLOSE l_bklg_k_to_rnw_csr ;
616:
617: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
618: -- Determine if the record is a new one or an existing one
619: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
620: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
621: , oki_utl_pub.g_all_k_category_code
622: , oki_load_rbk_pvt.g_bklg_k_to_rnw_code ) ;
623: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

Line 620: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id

616:
617: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
618: -- Determine if the record is a new one or an existing one
619: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
620: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
621: , oki_utl_pub.g_all_k_category_code
622: , oki_load_rbk_pvt.g_bklg_k_to_rnw_code ) ;
623: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
624: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

Line 621: , oki_utl_pub.g_all_k_category_code

617: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
618: -- Determine if the record is a new one or an existing one
619: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
620: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
621: , oki_utl_pub.g_all_k_category_code
622: , oki_load_rbk_pvt.g_bklg_k_to_rnw_code ) ;
623: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
624: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
625: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 628: p_summary_build_date => oki_utl_pub.g_summary_build_date

624: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
625: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
626: -- Insert the new record
627: oki_load_rbk_pvt.ins_rnwl_bkng (
628: p_summary_build_date => oki_utl_pub.g_summary_build_date
629: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
630: , p_organization_name => rec_g_org_csr.organization_name
631: , p_customer_party_id => oki_utl_pub.g_all_customer_id
632: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 631: , p_customer_party_id => oki_utl_pub.g_all_customer_id

627: oki_load_rbk_pvt.ins_rnwl_bkng (
628: p_summary_build_date => oki_utl_pub.g_summary_build_date
629: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
630: , p_organization_name => rec_g_org_csr.organization_name
631: , p_customer_party_id => oki_utl_pub.g_all_customer_id
632: , p_customer_name => oki_utl_pub.g_all_customer_name
633: , p_scs_code => oki_utl_pub.g_all_k_category_code
634: , p_measure_code => oki_load_rbk_pvt.g_bklg_k_to_rnw_code
635: , p_measure_code_meaning => l_bin_code_meaning

Line 632: , p_customer_name => oki_utl_pub.g_all_customer_name

628: p_summary_build_date => oki_utl_pub.g_summary_build_date
629: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
630: , p_organization_name => rec_g_org_csr.organization_name
631: , p_customer_party_id => oki_utl_pub.g_all_customer_id
632: , p_customer_name => oki_utl_pub.g_all_customer_name
633: , p_scs_code => oki_utl_pub.g_all_k_category_code
634: , p_measure_code => oki_load_rbk_pvt.g_bklg_k_to_rnw_code
635: , p_measure_code_meaning => l_bin_code_meaning
636: , p_bin_code_seq => l_bin_code_seq

Line 633: , p_scs_code => oki_utl_pub.g_all_k_category_code

629: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
630: , p_organization_name => rec_g_org_csr.organization_name
631: , p_customer_party_id => oki_utl_pub.g_all_customer_id
632: , p_customer_name => oki_utl_pub.g_all_customer_name
633: , p_scs_code => oki_utl_pub.g_all_k_category_code
634: , p_measure_code => oki_load_rbk_pvt.g_bklg_k_to_rnw_code
635: , p_measure_code_meaning => l_bin_code_meaning
636: , p_bin_code_seq => l_bin_code_seq
637: , p_curr_base_contract_amount => l_curr_bklg_k_to_rnw

Line 642: RAISE oki_utl_pub.g_excp_exit_immediate ;

638: , p_prev_base_contract_amount => l_prev_bklg_k_to_rnw
639: , x_retcode => l_retcode ) ;
640: IF l_retcode = '2' THEN
641: -- Load failed, exit immediately.
642: RAISE oki_utl_pub.g_excp_exit_immediate ;
643: END IF ;
644: ELSE
645: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
646: -- Update the existing record

Line 653: , p_customer_name => oki_utl_pub.g_all_customer_name

649: , p_prev_base_contract_amount => l_prev_bklg_k_to_rnw
650: , p_measure_code_meaning => l_bin_code_meaning
651: , p_bin_code_seq => l_bin_code_seq
652: , p_organization_name => rec_g_org_csr.organization_name
653: , p_customer_name => oki_utl_pub.g_all_customer_name
654: , p_rbk_rowid => rec_g_rbk_csr.rowid
655: , x_retcode => l_retcode ) ;
656:
657: IF l_retcode = '2' THEN

Line 659: RAISE oki_utl_pub.g_excp_exit_immediate ;

655: , x_retcode => l_retcode ) ;
656:
657: IF l_retcode = '2' THEN
658: -- Load failed, exit immediately.
659: RAISE oki_utl_pub.g_excp_exit_immediate ;
660: END IF ;
661: END IF ;
662: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
663:

Line 689: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date

685: l_prev_b_rnwl_oppty := l_prev_k_exp_in_qtr + l_prev_bklg_k_to_rnw ;
686:
687: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
688: -- Determine if the record is a new one or an existing one
689: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
690: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
691: , oki_utl_pub.g_all_k_category_code
692: , oki_load_rbk_pvt.g_b_rnwl_oppty_code ) ;
693: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

Line 690: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id

686:
687: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
688: -- Determine if the record is a new one or an existing one
689: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
690: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
691: , oki_utl_pub.g_all_k_category_code
692: , oki_load_rbk_pvt.g_b_rnwl_oppty_code ) ;
693: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
694: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

Line 691: , oki_utl_pub.g_all_k_category_code

687: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
688: -- Determine if the record is a new one or an existing one
689: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
690: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
691: , oki_utl_pub.g_all_k_category_code
692: , oki_load_rbk_pvt.g_b_rnwl_oppty_code ) ;
693: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
694: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
695: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 698: p_summary_build_date => oki_utl_pub.g_summary_build_date

694: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
695: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
696: -- Insert the new record
697: oki_load_rbk_pvt.ins_rnwl_bkng (
698: p_summary_build_date => oki_utl_pub.g_summary_build_date
699: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
700: , p_organization_name => rec_g_org_csr.organization_name
701: , p_customer_party_id => oki_utl_pub.g_all_customer_id
702: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 701: , p_customer_party_id => oki_utl_pub.g_all_customer_id

697: oki_load_rbk_pvt.ins_rnwl_bkng (
698: p_summary_build_date => oki_utl_pub.g_summary_build_date
699: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
700: , p_organization_name => rec_g_org_csr.organization_name
701: , p_customer_party_id => oki_utl_pub.g_all_customer_id
702: , p_customer_name => oki_utl_pub.g_all_customer_name
703: , p_scs_code => oki_utl_pub.g_all_k_category_code
704: , p_measure_code => oki_load_rbk_pvt.g_b_rnwl_oppty_code
705: , p_measure_code_meaning => l_bin_code_meaning

Line 702: , p_customer_name => oki_utl_pub.g_all_customer_name

698: p_summary_build_date => oki_utl_pub.g_summary_build_date
699: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
700: , p_organization_name => rec_g_org_csr.organization_name
701: , p_customer_party_id => oki_utl_pub.g_all_customer_id
702: , p_customer_name => oki_utl_pub.g_all_customer_name
703: , p_scs_code => oki_utl_pub.g_all_k_category_code
704: , p_measure_code => oki_load_rbk_pvt.g_b_rnwl_oppty_code
705: , p_measure_code_meaning => l_bin_code_meaning
706: , p_bin_code_seq => l_bin_code_seq

Line 703: , p_scs_code => oki_utl_pub.g_all_k_category_code

699: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
700: , p_organization_name => rec_g_org_csr.organization_name
701: , p_customer_party_id => oki_utl_pub.g_all_customer_id
702: , p_customer_name => oki_utl_pub.g_all_customer_name
703: , p_scs_code => oki_utl_pub.g_all_k_category_code
704: , p_measure_code => oki_load_rbk_pvt.g_b_rnwl_oppty_code
705: , p_measure_code_meaning => l_bin_code_meaning
706: , p_bin_code_seq => l_bin_code_seq
707: , p_curr_base_contract_amount => l_curr_b_rnwl_oppty

Line 712: RAISE oki_utl_pub.g_excp_exit_immediate ;

708: , p_prev_base_contract_amount => l_prev_b_rnwl_oppty
709: , x_retcode => l_retcode ) ;
710: IF l_retcode = '2' THEN
711: -- Load failed, exit immediately.
712: RAISE oki_utl_pub.g_excp_exit_immediate ;
713: END IF ;
714: ELSE
715: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
716: -- Update the existing record

Line 723: , p_customer_name => oki_utl_pub.g_all_customer_name

719: , p_prev_base_contract_amount => l_prev_b_rnwl_oppty
720: , p_measure_code_meaning => l_bin_code_meaning
721: , p_bin_code_seq => l_bin_code_seq
722: , p_organization_name => rec_g_org_csr.organization_name
723: , p_customer_name => oki_utl_pub.g_all_customer_name
724: , p_rbk_rowid => rec_g_rbk_csr.rowid
725: , x_retcode => l_retcode ) ;
726:
727: IF l_retcode = '2' THEN

Line 729: RAISE oki_utl_pub.g_excp_exit_immediate ;

725: , x_retcode => l_retcode ) ;
726:
727: IF l_retcode = '2' THEN
728: -- Load failed, exit immediately.
729: RAISE oki_utl_pub.g_excp_exit_immediate ;
730: END IF ;
731: END IF ;
732: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
733:

Line 757: OPEN l_bklg_k_rwned_csr( oki_utl_pub.g_summary_build_date,

753:
754: -- Get the current value
755: l_loc := 'Opening cursor to determine current ' ||
756: l_measure_type || '.' ;
757: OPEN l_bklg_k_rwned_csr( oki_utl_pub.g_summary_build_date,
758: oki_utl_pub.g_glpr_qtr_start_date
759: , rec_g_org_csr.authoring_org_id ) ;
760: FETCH l_bklg_k_rwned_csr INTO rec_l_bklg_k_rwned_csr ;
761: IF l_bklg_k_rwned_csr%FOUND THEN

Line 758: oki_utl_pub.g_glpr_qtr_start_date

754: -- Get the current value
755: l_loc := 'Opening cursor to determine current ' ||
756: l_measure_type || '.' ;
757: OPEN l_bklg_k_rwned_csr( oki_utl_pub.g_summary_build_date,
758: oki_utl_pub.g_glpr_qtr_start_date
759: , rec_g_org_csr.authoring_org_id ) ;
760: FETCH l_bklg_k_rwned_csr INTO rec_l_bklg_k_rwned_csr ;
761: IF l_bklg_k_rwned_csr%FOUND THEN
762: l_curr_bklg_k_rwned := rec_l_bklg_k_rwned_csr.value ;

Line 769: OPEN l_bklg_k_rwned_csr( oki_utl_pub.g_py_summary_build_date,

765:
766: -- Get the previous value
767: l_loc := 'Opening cursor to determine previous ' ||
768: l_measure_type || '.' ;
769: OPEN l_bklg_k_rwned_csr( oki_utl_pub.g_py_summary_build_date,
770: oki_utl_pub.g_py_glpr_qtr_start_date
771: , rec_g_org_csr.authoring_org_id ) ;
772: FETCH l_bklg_k_rwned_csr INTO rec_l_bklg_k_rwned_csr ;
773: IF l_bklg_k_rwned_csr%FOUND THEN

Line 770: oki_utl_pub.g_py_glpr_qtr_start_date

766: -- Get the previous value
767: l_loc := 'Opening cursor to determine previous ' ||
768: l_measure_type || '.' ;
769: OPEN l_bklg_k_rwned_csr( oki_utl_pub.g_py_summary_build_date,
770: oki_utl_pub.g_py_glpr_qtr_start_date
771: , rec_g_org_csr.authoring_org_id ) ;
772: FETCH l_bklg_k_rwned_csr INTO rec_l_bklg_k_rwned_csr ;
773: IF l_bklg_k_rwned_csr%FOUND THEN
774: l_prev_bklg_k_rwned := rec_l_bklg_k_rwned_csr.value ;

Line 780: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date

776: CLOSE l_bklg_k_rwned_csr ;
777:
778: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
779: -- Determine if the record is a new one or an existing one
780: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
781: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
782: , oki_utl_pub.g_all_k_category_code
783: , oki_load_rbk_pvt.g_bklg_k_rnwed_code ) ;
784: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

Line 781: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id

777:
778: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
779: -- Determine if the record is a new one or an existing one
780: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
781: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
782: , oki_utl_pub.g_all_k_category_code
783: , oki_load_rbk_pvt.g_bklg_k_rnwed_code ) ;
784: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
785: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

Line 782: , oki_utl_pub.g_all_k_category_code

778: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
779: -- Determine if the record is a new one or an existing one
780: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
781: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
782: , oki_utl_pub.g_all_k_category_code
783: , oki_load_rbk_pvt.g_bklg_k_rnwed_code ) ;
784: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
785: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
786: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 789: p_summary_build_date => oki_utl_pub.g_summary_build_date

785: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
786: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
787: -- Insert the new record
788: oki_load_rbk_pvt.ins_rnwl_bkng (
789: p_summary_build_date => oki_utl_pub.g_summary_build_date
790: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
791: , p_organization_name => rec_g_org_csr.organization_name
792: , p_customer_party_id => oki_utl_pub.g_all_customer_id
793: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 792: , p_customer_party_id => oki_utl_pub.g_all_customer_id

788: oki_load_rbk_pvt.ins_rnwl_bkng (
789: p_summary_build_date => oki_utl_pub.g_summary_build_date
790: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
791: , p_organization_name => rec_g_org_csr.organization_name
792: , p_customer_party_id => oki_utl_pub.g_all_customer_id
793: , p_customer_name => oki_utl_pub.g_all_customer_name
794: , p_scs_code => oki_utl_pub.g_all_k_category_code
795: , p_measure_code => oki_load_rbk_pvt.g_bklg_k_rnwed_code
796: , p_measure_code_meaning => l_bin_code_meaning

Line 793: , p_customer_name => oki_utl_pub.g_all_customer_name

789: p_summary_build_date => oki_utl_pub.g_summary_build_date
790: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
791: , p_organization_name => rec_g_org_csr.organization_name
792: , p_customer_party_id => oki_utl_pub.g_all_customer_id
793: , p_customer_name => oki_utl_pub.g_all_customer_name
794: , p_scs_code => oki_utl_pub.g_all_k_category_code
795: , p_measure_code => oki_load_rbk_pvt.g_bklg_k_rnwed_code
796: , p_measure_code_meaning => l_bin_code_meaning
797: , p_bin_code_seq => l_bin_code_seq

Line 794: , p_scs_code => oki_utl_pub.g_all_k_category_code

790: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
791: , p_organization_name => rec_g_org_csr.organization_name
792: , p_customer_party_id => oki_utl_pub.g_all_customer_id
793: , p_customer_name => oki_utl_pub.g_all_customer_name
794: , p_scs_code => oki_utl_pub.g_all_k_category_code
795: , p_measure_code => oki_load_rbk_pvt.g_bklg_k_rnwed_code
796: , p_measure_code_meaning => l_bin_code_meaning
797: , p_bin_code_seq => l_bin_code_seq
798: , p_curr_base_contract_amount => l_curr_bklg_k_rwned

Line 803: RAISE oki_utl_pub.g_excp_exit_immediate ;

799: , p_prev_base_contract_amount => l_prev_bklg_k_rwned
800: , x_retcode => l_retcode ) ;
801: IF l_retcode = '2' THEN
802: -- Load failed, exit immediately.
803: RAISE oki_utl_pub.g_excp_exit_immediate ;
804: END IF ;
805: ELSE
806: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
807: -- Update the existing record

Line 814: , p_customer_name => oki_utl_pub.g_all_customer_name

810: , p_prev_base_contract_amount => l_prev_bklg_k_rwned
811: , p_measure_code_meaning => l_bin_code_meaning
812: , p_bin_code_seq => l_bin_code_seq
813: , p_organization_name => rec_g_org_csr.organization_name
814: , p_customer_name => oki_utl_pub.g_all_customer_name
815: , p_rbk_rowid => rec_g_rbk_csr.rowid
816: , x_retcode => l_retcode ) ;
817:
818: IF l_retcode = '2' THEN

Line 820: RAISE oki_utl_pub.g_excp_exit_immediate ;

816: , x_retcode => l_retcode ) ;
817:
818: IF l_retcode = '2' THEN
819: -- Load failed, exit immediately.
820: RAISE oki_utl_pub.g_excp_exit_immediate ;
821: END IF ;
822: END IF ;
823: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
824:

Line 848: OPEN l_k_rnwed_csr( oki_utl_pub.g_glpr_qtr_start_date

844:
845: -- Get the current value
846: l_loc := 'Opening cursor to determine current ' ||
847: l_measure_type || '.' ;
848: OPEN l_k_rnwed_csr( oki_utl_pub.g_glpr_qtr_start_date
849: , oki_utl_pub.g_glpr_qtr_end_date
850: , rec_g_org_csr.authoring_org_id ) ;
851: FETCH l_k_rnwed_csr INTO rec_l_k_rnwed_csr ;
852: IF l_k_rnwed_csr%FOUND THEN

Line 849: , oki_utl_pub.g_glpr_qtr_end_date

845: -- Get the current value
846: l_loc := 'Opening cursor to determine current ' ||
847: l_measure_type || '.' ;
848: OPEN l_k_rnwed_csr( oki_utl_pub.g_glpr_qtr_start_date
849: , oki_utl_pub.g_glpr_qtr_end_date
850: , rec_g_org_csr.authoring_org_id ) ;
851: FETCH l_k_rnwed_csr INTO rec_l_k_rnwed_csr ;
852: IF l_k_rnwed_csr%FOUND THEN
853: l_curr_k_rnwed := rec_l_k_rnwed_csr.value ;

Line 860: OPEN l_k_rnwed_csr( oki_utl_pub.g_py_glpr_qtr_start_date

856:
857: -- Get the previous value
858: l_loc := 'Opening Cursor to determine previous ' ||
859: l_measure_type || '.' ;
860: OPEN l_k_rnwed_csr( oki_utl_pub.g_py_glpr_qtr_start_date
861: , oki_utl_pub.g_py_glpr_qtr_end_date
862: , rec_g_org_csr.authoring_org_id ) ;
863: FETCH l_k_rnwed_csr INTO rec_l_k_rnwed_csr ;
864: IF l_k_rnwed_csr%FOUND THEN

Line 861: , oki_utl_pub.g_py_glpr_qtr_end_date

857: -- Get the previous value
858: l_loc := 'Opening Cursor to determine previous ' ||
859: l_measure_type || '.' ;
860: OPEN l_k_rnwed_csr( oki_utl_pub.g_py_glpr_qtr_start_date
861: , oki_utl_pub.g_py_glpr_qtr_end_date
862: , rec_g_org_csr.authoring_org_id ) ;
863: FETCH l_k_rnwed_csr INTO rec_l_k_rnwed_csr ;
864: IF l_k_rnwed_csr%FOUND THEN
865: l_prev_k_rnwed := rec_l_k_rnwed_csr.value ;

Line 871: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date

867: CLOSE l_k_rnwed_csr ;
868:
869: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
870: -- Determine if the record is a new one or an existing one
871: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
872: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
873: , oki_utl_pub.g_all_k_category_code
874: , oki_load_rbk_pvt.g_k_rnwed_code ) ;
875: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

Line 872: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id

868:
869: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
870: -- Determine if the record is a new one or an existing one
871: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
872: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
873: , oki_utl_pub.g_all_k_category_code
874: , oki_load_rbk_pvt.g_k_rnwed_code ) ;
875: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
876: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

Line 873: , oki_utl_pub.g_all_k_category_code

869: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
870: -- Determine if the record is a new one or an existing one
871: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
872: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
873: , oki_utl_pub.g_all_k_category_code
874: , oki_load_rbk_pvt.g_k_rnwed_code ) ;
875: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
876: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
877: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 880: p_summary_build_date => oki_utl_pub.g_summary_build_date

876: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
877: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
878: -- Insert the new record
879: oki_load_rbk_pvt.ins_rnwl_bkng (
880: p_summary_build_date => oki_utl_pub.g_summary_build_date
881: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
882: , p_organization_name => rec_g_org_csr.organization_name
883: , p_customer_party_id => oki_utl_pub.g_all_customer_id
884: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 883: , p_customer_party_id => oki_utl_pub.g_all_customer_id

879: oki_load_rbk_pvt.ins_rnwl_bkng (
880: p_summary_build_date => oki_utl_pub.g_summary_build_date
881: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
882: , p_organization_name => rec_g_org_csr.organization_name
883: , p_customer_party_id => oki_utl_pub.g_all_customer_id
884: , p_customer_name => oki_utl_pub.g_all_customer_name
885: , p_scs_code => oki_utl_pub.g_all_k_category_code
886: , p_measure_code => oki_load_rbk_pvt.g_k_rnwed_code
887: , p_measure_code_meaning => l_bin_code_meaning

Line 884: , p_customer_name => oki_utl_pub.g_all_customer_name

880: p_summary_build_date => oki_utl_pub.g_summary_build_date
881: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
882: , p_organization_name => rec_g_org_csr.organization_name
883: , p_customer_party_id => oki_utl_pub.g_all_customer_id
884: , p_customer_name => oki_utl_pub.g_all_customer_name
885: , p_scs_code => oki_utl_pub.g_all_k_category_code
886: , p_measure_code => oki_load_rbk_pvt.g_k_rnwed_code
887: , p_measure_code_meaning => l_bin_code_meaning
888: , p_bin_code_seq => l_bin_code_seq

Line 885: , p_scs_code => oki_utl_pub.g_all_k_category_code

881: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
882: , p_organization_name => rec_g_org_csr.organization_name
883: , p_customer_party_id => oki_utl_pub.g_all_customer_id
884: , p_customer_name => oki_utl_pub.g_all_customer_name
885: , p_scs_code => oki_utl_pub.g_all_k_category_code
886: , p_measure_code => oki_load_rbk_pvt.g_k_rnwed_code
887: , p_measure_code_meaning => l_bin_code_meaning
888: , p_bin_code_seq => l_bin_code_seq
889: , p_curr_base_contract_amount => l_curr_k_rnwed

Line 894: RAISE oki_utl_pub.g_excp_exit_immediate ;

890: , p_prev_base_contract_amount => l_prev_k_rnwed
891: , x_retcode => l_retcode ) ;
892: IF l_retcode = '2' THEN
893: -- Load failed, exit immediately.
894: RAISE oki_utl_pub.g_excp_exit_immediate ;
895: END IF ;
896: ELSE
897: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
898: -- Update the existing record

Line 905: , p_customer_name => oki_utl_pub.g_all_customer_name

901: , p_prev_base_contract_amount => l_prev_k_rnwed
902: , p_measure_code_meaning => l_bin_code_meaning
903: , p_bin_code_seq => l_bin_code_seq
904: , p_organization_name => rec_g_org_csr.organization_name
905: , p_customer_name => oki_utl_pub.g_all_customer_name
906: , p_rbk_rowid => rec_g_rbk_csr.rowid
907: , x_retcode => l_retcode ) ;
908:
909: IF l_retcode = '2' THEN

Line 911: RAISE oki_utl_pub.g_excp_exit_immediate ;

907: , x_retcode => l_retcode ) ;
908:
909: IF l_retcode = '2' THEN
910: -- Load failed, exit immediately.
911: RAISE oki_utl_pub.g_excp_exit_immediate ;
912: END IF ;
913: END IF ;
914: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
915:

Line 939: OPEN l_new_bus_csr( oki_utl_pub.g_summary_build_date

935:
936: -- Get the current value
937: l_loc := 'Opening cursor to determine current ' ||
938: l_measure_type || '.' ;
939: OPEN l_new_bus_csr( oki_utl_pub.g_summary_build_date
940: , oki_utl_pub.g_glpr_qtr_start_date
941: , rec_g_org_csr.authoring_org_id ) ;
942: FETCH l_new_bus_csr INTO rec_l_new_bus_csr ;
943: IF l_new_bus_csr%FOUND THEN

Line 940: , oki_utl_pub.g_glpr_qtr_start_date

936: -- Get the current value
937: l_loc := 'Opening cursor to determine current ' ||
938: l_measure_type || '.' ;
939: OPEN l_new_bus_csr( oki_utl_pub.g_summary_build_date
940: , oki_utl_pub.g_glpr_qtr_start_date
941: , rec_g_org_csr.authoring_org_id ) ;
942: FETCH l_new_bus_csr INTO rec_l_new_bus_csr ;
943: IF l_new_bus_csr%FOUND THEN
944: l_curr_new_bus := rec_l_new_bus_csr.value ;

Line 951: OPEN l_new_bus_csr( oki_utl_pub.g_py_summary_build_date

947:
948: -- Get the previous value
949: l_loc := 'Opening Cursor to determine previous ' ||
950: l_measure_type || '.' ;
951: OPEN l_new_bus_csr( oki_utl_pub.g_py_summary_build_date
952: , oki_utl_pub.g_py_glpr_qtr_start_date
953: , rec_g_org_csr.authoring_org_id ) ;
954: FETCH l_new_bus_csr INTO rec_l_new_bus_csr ;
955: IF l_new_bus_csr%FOUND THEN

Line 952: , oki_utl_pub.g_py_glpr_qtr_start_date

948: -- Get the previous value
949: l_loc := 'Opening Cursor to determine previous ' ||
950: l_measure_type || '.' ;
951: OPEN l_new_bus_csr( oki_utl_pub.g_py_summary_build_date
952: , oki_utl_pub.g_py_glpr_qtr_start_date
953: , rec_g_org_csr.authoring_org_id ) ;
954: FETCH l_new_bus_csr INTO rec_l_new_bus_csr ;
955: IF l_new_bus_csr%FOUND THEN
956: l_prev_new_bus := rec_l_new_bus_csr.value ;

Line 962: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date

958: CLOSE l_new_bus_csr ;
959:
960: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
961: -- Determine if the record is a new one or an existing one
962: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
963: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
964: , oki_utl_pub.g_all_k_category_code
965: , oki_load_rbk_pvt.g_new_bsn_code ) ;
966: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

Line 963: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id

959:
960: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
961: -- Determine if the record is a new one or an existing one
962: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
963: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
964: , oki_utl_pub.g_all_k_category_code
965: , oki_load_rbk_pvt.g_new_bsn_code ) ;
966: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
967: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

Line 964: , oki_utl_pub.g_all_k_category_code

960: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
961: -- Determine if the record is a new one or an existing one
962: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
963: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
964: , oki_utl_pub.g_all_k_category_code
965: , oki_load_rbk_pvt.g_new_bsn_code ) ;
966: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
967: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
968: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 971: p_summary_build_date => oki_utl_pub.g_summary_build_date

967: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
968: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
969: -- Insert the new record
970: oki_load_rbk_pvt.ins_rnwl_bkng (
971: p_summary_build_date => oki_utl_pub.g_summary_build_date
972: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
973: , p_organization_name => rec_g_org_csr.organization_name
974: , p_customer_party_id => oki_utl_pub.g_all_customer_id
975: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 974: , p_customer_party_id => oki_utl_pub.g_all_customer_id

970: oki_load_rbk_pvt.ins_rnwl_bkng (
971: p_summary_build_date => oki_utl_pub.g_summary_build_date
972: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
973: , p_organization_name => rec_g_org_csr.organization_name
974: , p_customer_party_id => oki_utl_pub.g_all_customer_id
975: , p_customer_name => oki_utl_pub.g_all_customer_name
976: , p_scs_code => oki_utl_pub.g_all_k_category_code
977: , p_measure_code => oki_load_rbk_pvt.g_new_bsn_code
978: , p_measure_code_meaning => l_bin_code_meaning

Line 975: , p_customer_name => oki_utl_pub.g_all_customer_name

971: p_summary_build_date => oki_utl_pub.g_summary_build_date
972: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
973: , p_organization_name => rec_g_org_csr.organization_name
974: , p_customer_party_id => oki_utl_pub.g_all_customer_id
975: , p_customer_name => oki_utl_pub.g_all_customer_name
976: , p_scs_code => oki_utl_pub.g_all_k_category_code
977: , p_measure_code => oki_load_rbk_pvt.g_new_bsn_code
978: , p_measure_code_meaning => l_bin_code_meaning
979: , p_bin_code_seq => l_bin_code_seq

Line 976: , p_scs_code => oki_utl_pub.g_all_k_category_code

972: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
973: , p_organization_name => rec_g_org_csr.organization_name
974: , p_customer_party_id => oki_utl_pub.g_all_customer_id
975: , p_customer_name => oki_utl_pub.g_all_customer_name
976: , p_scs_code => oki_utl_pub.g_all_k_category_code
977: , p_measure_code => oki_load_rbk_pvt.g_new_bsn_code
978: , p_measure_code_meaning => l_bin_code_meaning
979: , p_bin_code_seq => l_bin_code_seq
980: , p_curr_base_contract_amount => l_curr_new_bus

Line 985: RAISE oki_utl_pub.g_excp_exit_immediate ;

981: , p_prev_base_contract_amount => l_prev_new_bus
982: , x_retcode => l_retcode ) ;
983: IF l_retcode = '2' THEN
984: -- Load failed, exit immediately.
985: RAISE oki_utl_pub.g_excp_exit_immediate ;
986: END IF ;
987: ELSE
988: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
989: -- Update the existing record

Line 996: , p_customer_name => oki_utl_pub.g_all_customer_name

992: , p_prev_base_contract_amount => l_prev_new_bus
993: , p_measure_code_meaning => l_bin_code_meaning
994: , p_bin_code_seq => l_bin_code_seq
995: , p_organization_name => rec_g_org_csr.organization_name
996: , p_customer_name => oki_utl_pub.g_all_customer_name
997: , p_rbk_rowid => rec_g_rbk_csr.rowid
998: , x_retcode => l_retcode ) ;
999:
1000: IF l_retcode = '2' THEN

Line 1002: RAISE oki_utl_pub.g_excp_exit_immediate ;

998: , x_retcode => l_retcode ) ;
999:
1000: IF l_retcode = '2' THEN
1001: -- Load failed, exit immediately.
1002: RAISE oki_utl_pub.g_excp_exit_immediate ;
1003: END IF ;
1004: END IF ;
1005: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
1006:

Line 1030: OPEN l_trmn_k_csr( oki_utl_pub.g_summary_build_date

1026:
1027: -- Get the current value
1028: l_loc := 'Opening cursor to determine current ' ||
1029: l_measure_type || '.' ;
1030: OPEN l_trmn_k_csr( oki_utl_pub.g_summary_build_date
1031: , oki_utl_pub.g_glpr_qtr_start_date
1032: , rec_g_org_csr.authoring_org_id ) ;
1033: FETCH l_trmn_k_csr INTO rec_l_trmn_k_csr ;
1034: IF l_trmn_k_csr%FOUND THEN

Line 1031: , oki_utl_pub.g_glpr_qtr_start_date

1027: -- Get the current value
1028: l_loc := 'Opening cursor to determine current ' ||
1029: l_measure_type || '.' ;
1030: OPEN l_trmn_k_csr( oki_utl_pub.g_summary_build_date
1031: , oki_utl_pub.g_glpr_qtr_start_date
1032: , rec_g_org_csr.authoring_org_id ) ;
1033: FETCH l_trmn_k_csr INTO rec_l_trmn_k_csr ;
1034: IF l_trmn_k_csr%FOUND THEN
1035: l_curr_trmn_k := rec_l_trmn_k_csr.value ;

Line 1042: OPEN l_trmn_k_csr( oki_utl_pub.g_py_summary_build_date

1038:
1039: -- Get the previous value
1040: l_loc := 'Opening Cursor to determine previous ' ||
1041: l_measure_type || '.' ;
1042: OPEN l_trmn_k_csr( oki_utl_pub.g_py_summary_build_date
1043: , oki_utl_pub.g_py_glpr_qtr_start_date
1044: , rec_g_org_csr.authoring_org_id ) ;
1045: FETCH l_trmn_k_csr INTO rec_l_trmn_k_csr ;
1046: IF l_trmn_k_csr%FOUND THEN

Line 1043: , oki_utl_pub.g_py_glpr_qtr_start_date

1039: -- Get the previous value
1040: l_loc := 'Opening Cursor to determine previous ' ||
1041: l_measure_type || '.' ;
1042: OPEN l_trmn_k_csr( oki_utl_pub.g_py_summary_build_date
1043: , oki_utl_pub.g_py_glpr_qtr_start_date
1044: , rec_g_org_csr.authoring_org_id ) ;
1045: FETCH l_trmn_k_csr INTO rec_l_trmn_k_csr ;
1046: IF l_trmn_k_csr%FOUND THEN
1047: l_prev_trmn_k := rec_l_trmn_k_csr.value ;

Line 1053: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date

1049: CLOSE l_trmn_k_csr ;
1050:
1051: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1052: -- Determine if the record is a new one or an existing one
1053: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1054: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
1055: , oki_utl_pub.g_all_k_category_code
1056: , oki_load_rbk_pvt.g_trmn_k_code ) ;
1057: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

Line 1054: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id

1050:
1051: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1052: -- Determine if the record is a new one or an existing one
1053: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1054: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
1055: , oki_utl_pub.g_all_k_category_code
1056: , oki_load_rbk_pvt.g_trmn_k_code ) ;
1057: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1058: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

Line 1055: , oki_utl_pub.g_all_k_category_code

1051: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1052: -- Determine if the record is a new one or an existing one
1053: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1054: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
1055: , oki_utl_pub.g_all_k_category_code
1056: , oki_load_rbk_pvt.g_trmn_k_code ) ;
1057: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1058: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1059: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 1062: p_summary_build_date => oki_utl_pub.g_summary_build_date

1058: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1059: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1060: -- Insert the new record
1061: oki_load_rbk_pvt.ins_rnwl_bkng (
1062: p_summary_build_date => oki_utl_pub.g_summary_build_date
1063: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
1064: , p_organization_name => rec_g_org_csr.organization_name
1065: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1066: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 1065: , p_customer_party_id => oki_utl_pub.g_all_customer_id

1061: oki_load_rbk_pvt.ins_rnwl_bkng (
1062: p_summary_build_date => oki_utl_pub.g_summary_build_date
1063: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
1064: , p_organization_name => rec_g_org_csr.organization_name
1065: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1066: , p_customer_name => oki_utl_pub.g_all_customer_name
1067: , p_scs_code => oki_utl_pub.g_all_k_category_code
1068: , p_measure_code => oki_load_rbk_pvt.g_trmn_k_code
1069: , p_measure_code_meaning => l_bin_code_meaning

Line 1066: , p_customer_name => oki_utl_pub.g_all_customer_name

1062: p_summary_build_date => oki_utl_pub.g_summary_build_date
1063: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
1064: , p_organization_name => rec_g_org_csr.organization_name
1065: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1066: , p_customer_name => oki_utl_pub.g_all_customer_name
1067: , p_scs_code => oki_utl_pub.g_all_k_category_code
1068: , p_measure_code => oki_load_rbk_pvt.g_trmn_k_code
1069: , p_measure_code_meaning => l_bin_code_meaning
1070: , p_bin_code_seq => l_bin_code_seq

Line 1067: , p_scs_code => oki_utl_pub.g_all_k_category_code

1063: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
1064: , p_organization_name => rec_g_org_csr.organization_name
1065: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1066: , p_customer_name => oki_utl_pub.g_all_customer_name
1067: , p_scs_code => oki_utl_pub.g_all_k_category_code
1068: , p_measure_code => oki_load_rbk_pvt.g_trmn_k_code
1069: , p_measure_code_meaning => l_bin_code_meaning
1070: , p_bin_code_seq => l_bin_code_seq
1071: , p_curr_base_contract_amount => l_curr_trmn_k

Line 1076: RAISE oki_utl_pub.g_excp_exit_immediate ;

1072: , p_prev_base_contract_amount => l_prev_trmn_k
1073: , x_retcode => l_retcode ) ;
1074: IF l_retcode = '2' THEN
1075: -- Load failed, exit immediately.
1076: RAISE oki_utl_pub.g_excp_exit_immediate ;
1077: END IF ;
1078: ELSE
1079: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1080: -- Update the existing record

Line 1087: , p_customer_name => oki_utl_pub.g_all_customer_name

1083: , p_prev_base_contract_amount => l_prev_trmn_k
1084: , p_measure_code_meaning => l_bin_code_meaning
1085: , p_bin_code_seq => l_bin_code_seq
1086: , p_organization_name => rec_g_org_csr.organization_name
1087: , p_customer_name => oki_utl_pub.g_all_customer_name
1088: , p_rbk_rowid => rec_g_rbk_csr.rowid
1089: , x_retcode => l_retcode ) ;
1090:
1091: IF l_retcode = '2' THEN

Line 1093: RAISE oki_utl_pub.g_excp_exit_immediate ;

1089: , x_retcode => l_retcode ) ;
1090:
1091: IF l_retcode = '2' THEN
1092: -- Load failed, exit immediately.
1093: RAISE oki_utl_pub.g_excp_exit_immediate ;
1094: END IF ;
1095: END IF ;
1096: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
1097:

Line 1132: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date

1128: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1129:
1130: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1131: -- Determine if the record is a new one or an existing one
1132: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1133: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
1134: , oki_utl_pub.g_all_k_category_code
1135: , oki_load_rbk_pvt.g_e_act_k_code ) ;
1136: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

Line 1133: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id

1129:
1130: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1131: -- Determine if the record is a new one or an existing one
1132: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1133: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
1134: , oki_utl_pub.g_all_k_category_code
1135: , oki_load_rbk_pvt.g_e_act_k_code ) ;
1136: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1137: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

Line 1134: , oki_utl_pub.g_all_k_category_code

1130: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1131: -- Determine if the record is a new one or an existing one
1132: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1133: , rec_g_org_csr.authoring_org_id, oki_utl_pub.g_all_customer_id
1134: , oki_utl_pub.g_all_k_category_code
1135: , oki_load_rbk_pvt.g_e_act_k_code ) ;
1136: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1137: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1138: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 1141: p_summary_build_date => oki_utl_pub.g_summary_build_date

1137: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1138: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1139: -- Insert the new record
1140: oki_load_rbk_pvt.ins_rnwl_bkng (
1141: p_summary_build_date => oki_utl_pub.g_summary_build_date
1142: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
1143: , p_organization_name => rec_g_org_csr.organization_name
1144: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1145: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 1144: , p_customer_party_id => oki_utl_pub.g_all_customer_id

1140: oki_load_rbk_pvt.ins_rnwl_bkng (
1141: p_summary_build_date => oki_utl_pub.g_summary_build_date
1142: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
1143: , p_organization_name => rec_g_org_csr.organization_name
1144: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1145: , p_customer_name => oki_utl_pub.g_all_customer_name
1146: , p_scs_code => oki_utl_pub.g_all_k_category_code
1147: , p_measure_code => oki_load_rbk_pvt.g_e_act_k_code
1148: , p_measure_code_meaning => l_bin_code_meaning

Line 1145: , p_customer_name => oki_utl_pub.g_all_customer_name

1141: p_summary_build_date => oki_utl_pub.g_summary_build_date
1142: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
1143: , p_organization_name => rec_g_org_csr.organization_name
1144: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1145: , p_customer_name => oki_utl_pub.g_all_customer_name
1146: , p_scs_code => oki_utl_pub.g_all_k_category_code
1147: , p_measure_code => oki_load_rbk_pvt.g_e_act_k_code
1148: , p_measure_code_meaning => l_bin_code_meaning
1149: , p_bin_code_seq => l_bin_code_seq

Line 1146: , p_scs_code => oki_utl_pub.g_all_k_category_code

1142: , p_authoring_org_id => rec_g_org_csr.authoring_org_id
1143: , p_organization_name => rec_g_org_csr.organization_name
1144: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1145: , p_customer_name => oki_utl_pub.g_all_customer_name
1146: , p_scs_code => oki_utl_pub.g_all_k_category_code
1147: , p_measure_code => oki_load_rbk_pvt.g_e_act_k_code
1148: , p_measure_code_meaning => l_bin_code_meaning
1149: , p_bin_code_seq => l_bin_code_seq
1150: , p_curr_base_contract_amount => l_curr_e_act_k

Line 1155: RAISE oki_utl_pub.g_excp_exit_immediate ;

1151: , p_prev_base_contract_amount => l_prev_e_act_k
1152: , x_retcode => l_retcode ) ;
1153: IF l_retcode = '2' THEN
1154: -- Load failed, exit immediately.
1155: RAISE oki_utl_pub.g_excp_exit_immediate ;
1156: END IF ;
1157: ELSE
1158: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1159: -- Update the existing record

Line 1166: , p_customer_name => oki_utl_pub.g_all_customer_name

1162: , p_prev_base_contract_amount => l_prev_e_act_k
1163: , p_measure_code_meaning => l_bin_code_meaning
1164: , p_bin_code_seq => l_bin_code_seq
1165: , p_organization_name => rec_g_org_csr.organization_name
1166: , p_customer_name => oki_utl_pub.g_all_customer_name
1167: , p_rbk_rowid => rec_g_rbk_csr.rowid
1168: , x_retcode => l_retcode ) ;
1169:
1170: IF l_retcode = '2' THEN

Line 1172: RAISE oki_utl_pub.g_excp_exit_immediate ;

1168: , x_retcode => l_retcode ) ;
1169:
1170: IF l_retcode = '2' THEN
1171: -- Load failed, exit immediately.
1172: RAISE oki_utl_pub.g_excp_exit_immediate ;
1173: END IF ;
1174: END IF ;
1175: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
1176:

Line 1180: WHEN oki_utl_pub.g_excp_exit_immediate THEN

1176:
1177: END LOOP g_org_csr_loop ;
1178:
1179: EXCEPTION
1180: WHEN oki_utl_pub.g_excp_exit_immediate THEN
1181: -- Do not log an error ; It has already been logged.
1182: -- Set return code to error
1183: x_retcode := '2' ;
1184:

Line 1308: AND oki_utl_pub.g_contract_limit

1304: AND ( shd.date_signed IS NULL
1305: OR shd.date_signed >= p_qtr_start_date )
1306: AND shd.start_date < p_qtr_start_date
1307: AND shd.base_contract_amount BETWEEN 0
1308: AND oki_utl_pub.g_contract_limit
1309: ;
1310: rec_l_bklg_k_to_rnw_csr l_bklg_k_to_rnw_csr%ROWTYPE ;
1311:
1312: -- Contracts that have been renewed (booked) in this quarter but should have

Line 1329: AND oki_utl_pub.g_contract_limit

1325: AND shd.start_date < p_qtr_start_date
1326: AND GREATEST(shd.date_signed, shd.date_approved )
1327: BETWEEN p_qtr_start_date AND p_summary_build_date
1328: AND shd.base_contract_amount BETWEEN 0
1329: AND oki_utl_pub.g_contract_limit
1330: ;
1331: rec_l_bklg_k_rwned_csr l_bklg_k_rwned_csr%ROWTYPE ;
1332:
1333: -- Contracts that have been renewed in the quarter

Line 1347: AND oki_utl_pub.g_contract_limit

1343: AND shd.date_signed IS NOT NULL
1344: AND shd.start_date BETWEEN p_qtr_start_date AND p_qtr_end_date
1345: AND GREATEST(shd.date_signed, shd.date_approved) <= p_qtr_end_date
1346: AND shd.base_contract_amount BETWEEN 0
1347: AND oki_utl_pub.g_contract_limit
1348: ;
1349: rec_l_k_rnwed_csr l_k_rnwed_csr%ROWTYPE ;
1350:
1351: -- Contracts that became active between the start of quarter

Line 1369: AND oki_utl_pub.g_contract_limit

1365: AND p_summary_build_date
1366: AND ( shd.date_terminated IS NULL
1367: OR shd.date_terminated > p_summary_build_date )
1368: AND shd.base_contract_amount BETWEEN 0
1369: AND oki_utl_pub.g_contract_limit
1370: ;
1371: rec_l_new_bus_csr l_new_bus_csr%ROWTYPE ;
1372:
1373: -- Contracts that were terminated between the start of the quarter and the

Line 1388: AND oki_utl_pub.g_contract_limit

1384: AND p_summary_build_date
1385: AND shd.date_signed IS NOT NULL
1386: AND shd.date_approved IS NOT NULL
1387: AND shd.base_contract_amount BETWEEN 0
1388: AND oki_utl_pub.g_contract_limit
1389: ;
1390: rec_l_trmn_k_csr l_trmn_k_csr%ROWTYPE ;
1391:
1392: BEGIN

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

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

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

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

Line 1438: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date

1434: CLOSE oki_utl_pvt.g_tactk_all_csr ;
1435:
1436: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1437: -- Determine if the record is a new one or an existing one
1438: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1439: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1440: , oki_utl_pub.g_all_k_category_code
1441: , oki_load_rbk_pvt.g_b_act_k_code ) ;
1442: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

Line 1439: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id

1435:
1436: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1437: -- Determine if the record is a new one or an existing one
1438: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1439: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1440: , oki_utl_pub.g_all_k_category_code
1441: , oki_load_rbk_pvt.g_b_act_k_code ) ;
1442: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1443: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

Line 1440: , oki_utl_pub.g_all_k_category_code

1436: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1437: -- Determine if the record is a new one or an existing one
1438: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1439: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1440: , oki_utl_pub.g_all_k_category_code
1441: , oki_load_rbk_pvt.g_b_act_k_code ) ;
1442: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1443: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1444: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 1447: p_summary_build_date => oki_utl_pub.g_summary_build_date

1443: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1444: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1445: -- Insert the new record
1446: oki_load_rbk_pvt.ins_rnwl_bkng (
1447: p_summary_build_date => oki_utl_pub.g_summary_build_date
1448: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1449: , p_organization_name => oki_utl_pub.g_all_organization_name
1450: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1451: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 1448: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

1444: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1445: -- Insert the new record
1446: oki_load_rbk_pvt.ins_rnwl_bkng (
1447: p_summary_build_date => oki_utl_pub.g_summary_build_date
1448: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1449: , p_organization_name => oki_utl_pub.g_all_organization_name
1450: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1451: , p_customer_name => oki_utl_pub.g_all_customer_name
1452: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 1449: , p_organization_name => oki_utl_pub.g_all_organization_name

1445: -- Insert the new record
1446: oki_load_rbk_pvt.ins_rnwl_bkng (
1447: p_summary_build_date => oki_utl_pub.g_summary_build_date
1448: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1449: , p_organization_name => oki_utl_pub.g_all_organization_name
1450: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1451: , p_customer_name => oki_utl_pub.g_all_customer_name
1452: , p_scs_code => oki_utl_pub.g_all_k_category_code
1453: , p_measure_code => oki_load_rbk_pvt.g_b_act_k_code

Line 1450: , p_customer_party_id => oki_utl_pub.g_all_customer_id

1446: oki_load_rbk_pvt.ins_rnwl_bkng (
1447: p_summary_build_date => oki_utl_pub.g_summary_build_date
1448: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1449: , p_organization_name => oki_utl_pub.g_all_organization_name
1450: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1451: , p_customer_name => oki_utl_pub.g_all_customer_name
1452: , p_scs_code => oki_utl_pub.g_all_k_category_code
1453: , p_measure_code => oki_load_rbk_pvt.g_b_act_k_code
1454: , p_measure_code_meaning => l_bin_code_meaning

Line 1451: , p_customer_name => oki_utl_pub.g_all_customer_name

1447: p_summary_build_date => oki_utl_pub.g_summary_build_date
1448: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1449: , p_organization_name => oki_utl_pub.g_all_organization_name
1450: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1451: , p_customer_name => oki_utl_pub.g_all_customer_name
1452: , p_scs_code => oki_utl_pub.g_all_k_category_code
1453: , p_measure_code => oki_load_rbk_pvt.g_b_act_k_code
1454: , p_measure_code_meaning => l_bin_code_meaning
1455: , p_bin_code_seq => l_bin_code_seq

Line 1452: , p_scs_code => oki_utl_pub.g_all_k_category_code

1448: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1449: , p_organization_name => oki_utl_pub.g_all_organization_name
1450: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1451: , p_customer_name => oki_utl_pub.g_all_customer_name
1452: , p_scs_code => oki_utl_pub.g_all_k_category_code
1453: , p_measure_code => oki_load_rbk_pvt.g_b_act_k_code
1454: , p_measure_code_meaning => l_bin_code_meaning
1455: , p_bin_code_seq => l_bin_code_seq
1456: , p_curr_base_contract_amount => l_curr_b_act_k

Line 1461: RAISE oki_utl_pub.g_excp_exit_immediate ;

1457: , p_prev_base_contract_amount => l_prev_b_act_k
1458: , x_retcode => l_retcode ) ;
1459: IF l_retcode = '2' THEN
1460: -- Load failed, exit immediately.
1461: RAISE oki_utl_pub.g_excp_exit_immediate ;
1462: END IF ;
1463: ELSE
1464: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1465: -- Update the existing record

Line 1471: , p_organization_name => oki_utl_pub.g_all_organization_name

1467: p_curr_base_contract_amount => l_curr_b_act_k
1468: , p_prev_base_contract_amount => l_prev_b_act_k
1469: , p_measure_code_meaning => l_bin_code_meaning
1470: , p_bin_code_seq => l_bin_code_seq
1471: , p_organization_name => oki_utl_pub.g_all_organization_name
1472: , p_customer_name => oki_utl_pub.g_all_customer_name
1473: , p_rbk_rowid => rec_g_rbk_csr.rowid
1474: , x_retcode => l_retcode ) ;
1475:

Line 1472: , p_customer_name => oki_utl_pub.g_all_customer_name

1468: , p_prev_base_contract_amount => l_prev_b_act_k
1469: , p_measure_code_meaning => l_bin_code_meaning
1470: , p_bin_code_seq => l_bin_code_seq
1471: , p_organization_name => oki_utl_pub.g_all_organization_name
1472: , p_customer_name => oki_utl_pub.g_all_customer_name
1473: , p_rbk_rowid => rec_g_rbk_csr.rowid
1474: , x_retcode => l_retcode ) ;
1475:
1476: IF l_retcode = '2' THEN

Line 1478: RAISE oki_utl_pub.g_excp_exit_immediate ;

1474: , x_retcode => l_retcode ) ;
1475:
1476: IF l_retcode = '2' THEN
1477: -- Load failed, exit immediately.
1478: RAISE oki_utl_pub.g_excp_exit_immediate ;
1479: END IF ;
1480: END IF ;
1481: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
1482:

Line 1506: oki_utl_pub.g_glpr_qtr_start_date,

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

Line 1507: oki_utl_pub.g_glpr_qtr_end_date ) ;

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

Line 1517: oki_utl_pub.g_py_glpr_qtr_start_date,

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

Line 1518: oki_utl_pub.g_py_glpr_qtr_end_date ) ;

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

Line 1527: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date

1523: CLOSE oki_utl_pvt.g_k_exp_in_qtr_all_csr ;
1524:
1525: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1526: -- Determine if the record is a new one or an existing one
1527: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1528: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1529: , oki_utl_pub.g_all_k_category_code
1530: , oki_load_rbk_pvt.g_exp_in_qtr_code ) ;
1531: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

Line 1528: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id

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

Line 1529: , oki_utl_pub.g_all_k_category_code

1525: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1526: -- Determine if the record is a new one or an existing one
1527: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1528: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1529: , oki_utl_pub.g_all_k_category_code
1530: , oki_load_rbk_pvt.g_exp_in_qtr_code ) ;
1531: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1532: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1533: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 1536: p_summary_build_date => oki_utl_pub.g_summary_build_date

1532: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1533: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1534: -- Insert the new record
1535: oki_load_rbk_pvt.ins_rnwl_bkng (
1536: p_summary_build_date => oki_utl_pub.g_summary_build_date
1537: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1538: , p_organization_name => oki_utl_pub.g_all_organization_name
1539: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1540: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 1537: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

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

Line 1538: , p_organization_name => oki_utl_pub.g_all_organization_name

1534: -- Insert the new record
1535: oki_load_rbk_pvt.ins_rnwl_bkng (
1536: p_summary_build_date => oki_utl_pub.g_summary_build_date
1537: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1538: , p_organization_name => oki_utl_pub.g_all_organization_name
1539: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1540: , p_customer_name => oki_utl_pub.g_all_customer_name
1541: , p_scs_code => oki_utl_pub.g_all_k_category_code
1542: , p_measure_code => oki_load_rbk_pvt.g_exp_in_qtr_code

Line 1539: , p_customer_party_id => oki_utl_pub.g_all_customer_id

1535: oki_load_rbk_pvt.ins_rnwl_bkng (
1536: p_summary_build_date => oki_utl_pub.g_summary_build_date
1537: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1538: , p_organization_name => oki_utl_pub.g_all_organization_name
1539: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1540: , p_customer_name => oki_utl_pub.g_all_customer_name
1541: , p_scs_code => oki_utl_pub.g_all_k_category_code
1542: , p_measure_code => oki_load_rbk_pvt.g_exp_in_qtr_code
1543: , p_measure_code_meaning => l_bin_code_meaning

Line 1540: , p_customer_name => oki_utl_pub.g_all_customer_name

1536: p_summary_build_date => oki_utl_pub.g_summary_build_date
1537: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1538: , p_organization_name => oki_utl_pub.g_all_organization_name
1539: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1540: , p_customer_name => oki_utl_pub.g_all_customer_name
1541: , p_scs_code => oki_utl_pub.g_all_k_category_code
1542: , p_measure_code => oki_load_rbk_pvt.g_exp_in_qtr_code
1543: , p_measure_code_meaning => l_bin_code_meaning
1544: , p_bin_code_seq => l_bin_code_seq

Line 1541: , p_scs_code => oki_utl_pub.g_all_k_category_code

1537: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1538: , p_organization_name => oki_utl_pub.g_all_organization_name
1539: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1540: , p_customer_name => oki_utl_pub.g_all_customer_name
1541: , p_scs_code => oki_utl_pub.g_all_k_category_code
1542: , p_measure_code => oki_load_rbk_pvt.g_exp_in_qtr_code
1543: , p_measure_code_meaning => l_bin_code_meaning
1544: , p_bin_code_seq => l_bin_code_seq
1545: , p_curr_base_contract_amount => l_curr_k_exp_in_qtr

Line 1550: RAISE oki_utl_pub.g_excp_exit_immediate ;

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

Line 1560: , p_organization_name => oki_utl_pub.g_all_organization_name

1556: p_curr_base_contract_amount => l_curr_k_exp_in_qtr
1557: , p_prev_base_contract_amount => l_prev_k_exp_in_qtr
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_rbk_rowid => rec_g_rbk_csr.rowid
1563: , x_retcode => l_retcode ) ;
1564:

Line 1561: , p_customer_name => oki_utl_pub.g_all_customer_name

1557: , p_prev_base_contract_amount => l_prev_k_exp_in_qtr
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_rbk_rowid => rec_g_rbk_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_rbk_pvt.g_rbk_csr ;
1571:

Line 1594: OPEN l_bklg_k_to_rnw_csr ( oki_utl_pub.g_glpr_qtr_start_date ) ;

1590: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
1591:
1592: -- Get the current value
1593: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1594: OPEN l_bklg_k_to_rnw_csr ( oki_utl_pub.g_glpr_qtr_start_date ) ;
1595: FETCH l_bklg_k_to_rnw_csr INTO rec_l_bklg_k_to_rnw_csr ;
1596: IF l_bklg_k_to_rnw_csr%FOUND THEN
1597: l_curr_bklg_k_to_rnw := rec_l_bklg_k_to_rnw_csr.value ;
1598: END IF ;

Line 1603: OPEN l_bklg_k_to_rnw_csr ( oki_utl_pub.g_py_glpr_qtr_start_date ) ;

1599: CLOSE l_bklg_k_to_rnw_csr ;
1600:
1601: -- Get the previous value
1602: l_loc := 'Opening Cursor to determine previous ' || l_measure_type || '.' ;
1603: OPEN l_bklg_k_to_rnw_csr ( oki_utl_pub.g_py_glpr_qtr_start_date ) ;
1604: FETCH l_bklg_k_to_rnw_csr INTO rec_l_bklg_k_to_rnw_csr ;
1605: IF l_bklg_k_to_rnw_csr%FOUND THEN
1606: l_prev_bklg_k_to_rnw := rec_l_bklg_k_to_rnw_csr.value ;
1607: END IF ;

Line 1612: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date

1608: CLOSE l_bklg_k_to_rnw_csr ;
1609:
1610: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1611: -- Determine if the record is a new one or an existing one
1612: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1613: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1614: , oki_utl_pub.g_all_k_category_code
1615: , oki_load_rbk_pvt.g_bklg_k_to_rnw_code ) ;
1616: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

Line 1613: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id

1609:
1610: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1611: -- Determine if the record is a new one or an existing one
1612: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1613: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1614: , oki_utl_pub.g_all_k_category_code
1615: , oki_load_rbk_pvt.g_bklg_k_to_rnw_code ) ;
1616: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1617: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

Line 1614: , oki_utl_pub.g_all_k_category_code

1610: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1611: -- Determine if the record is a new one or an existing one
1612: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1613: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1614: , oki_utl_pub.g_all_k_category_code
1615: , oki_load_rbk_pvt.g_bklg_k_to_rnw_code ) ;
1616: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1617: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1618: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 1621: p_summary_build_date => oki_utl_pub.g_summary_build_date

1617: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1618: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1619: -- Insert the new record
1620: oki_load_rbk_pvt.ins_rnwl_bkng (
1621: p_summary_build_date => oki_utl_pub.g_summary_build_date
1622: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1623: , p_organization_name => oki_utl_pub.g_all_organization_name
1624: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1625: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 1622: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

1618: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1619: -- Insert the new record
1620: oki_load_rbk_pvt.ins_rnwl_bkng (
1621: p_summary_build_date => oki_utl_pub.g_summary_build_date
1622: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1623: , p_organization_name => oki_utl_pub.g_all_organization_name
1624: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1625: , p_customer_name => oki_utl_pub.g_all_customer_name
1626: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 1623: , p_organization_name => oki_utl_pub.g_all_organization_name

1619: -- Insert the new record
1620: oki_load_rbk_pvt.ins_rnwl_bkng (
1621: p_summary_build_date => oki_utl_pub.g_summary_build_date
1622: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1623: , p_organization_name => oki_utl_pub.g_all_organization_name
1624: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1625: , p_customer_name => oki_utl_pub.g_all_customer_name
1626: , p_scs_code => oki_utl_pub.g_all_k_category_code
1627: , p_measure_code => oki_load_rbk_pvt.g_bklg_k_to_rnw_code

Line 1624: , p_customer_party_id => oki_utl_pub.g_all_customer_id

1620: oki_load_rbk_pvt.ins_rnwl_bkng (
1621: p_summary_build_date => oki_utl_pub.g_summary_build_date
1622: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1623: , p_organization_name => oki_utl_pub.g_all_organization_name
1624: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1625: , p_customer_name => oki_utl_pub.g_all_customer_name
1626: , p_scs_code => oki_utl_pub.g_all_k_category_code
1627: , p_measure_code => oki_load_rbk_pvt.g_bklg_k_to_rnw_code
1628: , p_measure_code_meaning => l_bin_code_meaning

Line 1625: , p_customer_name => oki_utl_pub.g_all_customer_name

1621: p_summary_build_date => oki_utl_pub.g_summary_build_date
1622: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1623: , p_organization_name => oki_utl_pub.g_all_organization_name
1624: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1625: , p_customer_name => oki_utl_pub.g_all_customer_name
1626: , p_scs_code => oki_utl_pub.g_all_k_category_code
1627: , p_measure_code => oki_load_rbk_pvt.g_bklg_k_to_rnw_code
1628: , p_measure_code_meaning => l_bin_code_meaning
1629: , p_bin_code_seq => l_bin_code_seq

Line 1626: , p_scs_code => oki_utl_pub.g_all_k_category_code

1622: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1623: , p_organization_name => oki_utl_pub.g_all_organization_name
1624: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1625: , p_customer_name => oki_utl_pub.g_all_customer_name
1626: , p_scs_code => oki_utl_pub.g_all_k_category_code
1627: , p_measure_code => oki_load_rbk_pvt.g_bklg_k_to_rnw_code
1628: , p_measure_code_meaning => l_bin_code_meaning
1629: , p_bin_code_seq => l_bin_code_seq
1630: , p_curr_base_contract_amount => l_curr_bklg_k_to_rnw

Line 1635: RAISE oki_utl_pub.g_excp_exit_immediate ;

1631: , p_prev_base_contract_amount => l_prev_bklg_k_to_rnw
1632: , x_retcode => l_retcode ) ;
1633: IF l_retcode = '2' THEN
1634: -- Load failed, exit immediately.
1635: RAISE oki_utl_pub.g_excp_exit_immediate ;
1636: END IF ;
1637: ELSE
1638: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1639: -- Update the existing record

Line 1645: , p_organization_name => oki_utl_pub.g_all_organization_name

1641: p_curr_base_contract_amount => l_curr_bklg_k_to_rnw
1642: , p_prev_base_contract_amount => l_prev_bklg_k_to_rnw
1643: , p_measure_code_meaning => l_bin_code_meaning
1644: , p_bin_code_seq => l_bin_code_seq
1645: , p_organization_name => oki_utl_pub.g_all_organization_name
1646: , p_customer_name => oki_utl_pub.g_all_customer_name
1647: , p_rbk_rowid => rec_g_rbk_csr.rowid
1648: , x_retcode => l_retcode ) ;
1649:

Line 1646: , p_customer_name => oki_utl_pub.g_all_customer_name

1642: , p_prev_base_contract_amount => l_prev_bklg_k_to_rnw
1643: , p_measure_code_meaning => l_bin_code_meaning
1644: , p_bin_code_seq => l_bin_code_seq
1645: , p_organization_name => oki_utl_pub.g_all_organization_name
1646: , p_customer_name => oki_utl_pub.g_all_customer_name
1647: , p_rbk_rowid => rec_g_rbk_csr.rowid
1648: , x_retcode => l_retcode ) ;
1649:
1650: IF l_retcode = '2' THEN

Line 1652: RAISE oki_utl_pub.g_excp_exit_immediate ;

1648: , x_retcode => l_retcode ) ;
1649:
1650: IF l_retcode = '2' THEN
1651: -- Load failed, exit immediately.
1652: RAISE oki_utl_pub.g_excp_exit_immediate ;
1653: END IF ;
1654: END IF ;
1655: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
1656:

Line 1682: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date

1678: l_prev_b_rnwl_oppty := l_prev_k_exp_in_qtr + l_prev_bklg_k_to_rnw ;
1679:
1680: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1681: -- Determine if the record is a new one or an existing one
1682: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1683: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1684: , oki_utl_pub.g_all_k_category_code
1685: , oki_load_rbk_pvt.g_b_rnwl_oppty_code ) ;
1686: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

Line 1683: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id

1679:
1680: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1681: -- Determine if the record is a new one or an existing one
1682: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1683: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1684: , oki_utl_pub.g_all_k_category_code
1685: , oki_load_rbk_pvt.g_b_rnwl_oppty_code ) ;
1686: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1687: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

Line 1684: , oki_utl_pub.g_all_k_category_code

1680: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1681: -- Determine if the record is a new one or an existing one
1682: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1683: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
1684: , oki_utl_pub.g_all_k_category_code
1685: , oki_load_rbk_pvt.g_b_rnwl_oppty_code ) ;
1686: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1687: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1688: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 1691: p_summary_build_date => oki_utl_pub.g_summary_build_date

1687: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1688: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1689: -- Insert the new record
1690: oki_load_rbk_pvt.ins_rnwl_bkng (
1691: p_summary_build_date => oki_utl_pub.g_summary_build_date
1692: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1693: , p_organization_name => oki_utl_pub.g_all_organization_name
1694: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1695: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 1692: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

1688: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1689: -- Insert the new record
1690: oki_load_rbk_pvt.ins_rnwl_bkng (
1691: p_summary_build_date => oki_utl_pub.g_summary_build_date
1692: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1693: , p_organization_name => oki_utl_pub.g_all_organization_name
1694: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1695: , p_customer_name => oki_utl_pub.g_all_customer_name
1696: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 1693: , p_organization_name => oki_utl_pub.g_all_organization_name

1689: -- Insert the new record
1690: oki_load_rbk_pvt.ins_rnwl_bkng (
1691: p_summary_build_date => oki_utl_pub.g_summary_build_date
1692: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1693: , p_organization_name => oki_utl_pub.g_all_organization_name
1694: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1695: , p_customer_name => oki_utl_pub.g_all_customer_name
1696: , p_scs_code => oki_utl_pub.g_all_k_category_code
1697: , p_measure_code => oki_load_rbk_pvt.g_b_rnwl_oppty_code

Line 1694: , p_customer_party_id => oki_utl_pub.g_all_customer_id

1690: oki_load_rbk_pvt.ins_rnwl_bkng (
1691: p_summary_build_date => oki_utl_pub.g_summary_build_date
1692: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1693: , p_organization_name => oki_utl_pub.g_all_organization_name
1694: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1695: , p_customer_name => oki_utl_pub.g_all_customer_name
1696: , p_scs_code => oki_utl_pub.g_all_k_category_code
1697: , p_measure_code => oki_load_rbk_pvt.g_b_rnwl_oppty_code
1698: , p_measure_code_meaning => l_bin_code_meaning

Line 1695: , p_customer_name => oki_utl_pub.g_all_customer_name

1691: p_summary_build_date => oki_utl_pub.g_summary_build_date
1692: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1693: , p_organization_name => oki_utl_pub.g_all_organization_name
1694: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1695: , p_customer_name => oki_utl_pub.g_all_customer_name
1696: , p_scs_code => oki_utl_pub.g_all_k_category_code
1697: , p_measure_code => oki_load_rbk_pvt.g_b_rnwl_oppty_code
1698: , p_measure_code_meaning => l_bin_code_meaning
1699: , p_bin_code_seq => l_bin_code_seq

Line 1696: , p_scs_code => oki_utl_pub.g_all_k_category_code

1692: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1693: , p_organization_name => oki_utl_pub.g_all_organization_name
1694: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1695: , p_customer_name => oki_utl_pub.g_all_customer_name
1696: , p_scs_code => oki_utl_pub.g_all_k_category_code
1697: , p_measure_code => oki_load_rbk_pvt.g_b_rnwl_oppty_code
1698: , p_measure_code_meaning => l_bin_code_meaning
1699: , p_bin_code_seq => l_bin_code_seq
1700: , p_curr_base_contract_amount => l_curr_b_rnwl_oppty

Line 1706: RAISE oki_utl_pub.g_excp_exit_immediate ;

1702: , x_retcode => l_retcode ) ;
1703:
1704: IF l_retcode = '2' THEN
1705: -- Load failed, exit immediately.
1706: RAISE oki_utl_pub.g_excp_exit_immediate ;
1707: END IF ;
1708: ELSE
1709: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1710: -- Update the existing record

Line 1716: , p_organization_name => oki_utl_pub.g_all_organization_name

1712: p_curr_base_contract_amount => l_curr_b_rnwl_oppty
1713: , p_prev_base_contract_amount => l_prev_b_rnwl_oppty
1714: , p_measure_code_meaning => l_bin_code_meaning
1715: , p_bin_code_seq => l_bin_code_seq
1716: , p_organization_name => oki_utl_pub.g_all_organization_name
1717: , p_customer_name => oki_utl_pub.g_all_customer_name
1718: , p_rbk_rowid => rec_g_rbk_csr.rowid
1719: , x_retcode => l_retcode ) ;
1720:

Line 1717: , p_customer_name => oki_utl_pub.g_all_customer_name

1713: , p_prev_base_contract_amount => l_prev_b_rnwl_oppty
1714: , p_measure_code_meaning => l_bin_code_meaning
1715: , p_bin_code_seq => l_bin_code_seq
1716: , p_organization_name => oki_utl_pub.g_all_organization_name
1717: , p_customer_name => oki_utl_pub.g_all_customer_name
1718: , p_rbk_rowid => rec_g_rbk_csr.rowid
1719: , x_retcode => l_retcode ) ;
1720:
1721: IF l_retcode = '2' THEN

Line 1723: RAISE oki_utl_pub.g_excp_exit_immediate ;

1719: , x_retcode => l_retcode ) ;
1720:
1721: IF l_retcode = '2' THEN
1722: -- Load failed, exit immediately.
1723: RAISE oki_utl_pub.g_excp_exit_immediate ;
1724: END IF ;
1725: END IF ;
1726: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
1727:

Line 1748: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date,

1744: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
1745:
1746: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1747: -- Determine if the record is a new one or an existing one
1748: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date,
1749: oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id,
1750: oki_utl_pub.g_all_k_category_code, oki_load_rbk_pvt.g_qtr_actvty_code ) ;
1751: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1752: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

Line 1749: oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id,

1745:
1746: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1747: -- Determine if the record is a new one or an existing one
1748: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date,
1749: oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id,
1750: oki_utl_pub.g_all_k_category_code, oki_load_rbk_pvt.g_qtr_actvty_code ) ;
1751: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1752: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1753: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 1750: oki_utl_pub.g_all_k_category_code, oki_load_rbk_pvt.g_qtr_actvty_code ) ;

1746: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1747: -- Determine if the record is a new one or an existing one
1748: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date,
1749: oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id,
1750: oki_utl_pub.g_all_k_category_code, oki_load_rbk_pvt.g_qtr_actvty_code ) ;
1751: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1752: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1753: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1754: -- Insert the new record

Line 1756: p_summary_build_date => oki_utl_pub.g_summary_build_date

1752: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1753: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1754: -- Insert the new record
1755: oki_load_rbk_pvt.ins_rnwl_bkng (
1756: p_summary_build_date => oki_utl_pub.g_summary_build_date
1757: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1758: , p_organization_name => oki_utl_pub.g_all_organization_name
1759: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1760: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 1757: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

1753: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1754: -- Insert the new record
1755: oki_load_rbk_pvt.ins_rnwl_bkng (
1756: p_summary_build_date => oki_utl_pub.g_summary_build_date
1757: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1758: , p_organization_name => oki_utl_pub.g_all_organization_name
1759: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1760: , p_customer_name => oki_utl_pub.g_all_customer_name
1761: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 1758: , p_organization_name => oki_utl_pub.g_all_organization_name

1754: -- Insert the new record
1755: oki_load_rbk_pvt.ins_rnwl_bkng (
1756: p_summary_build_date => oki_utl_pub.g_summary_build_date
1757: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1758: , p_organization_name => oki_utl_pub.g_all_organization_name
1759: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1760: , p_customer_name => oki_utl_pub.g_all_customer_name
1761: , p_scs_code => oki_utl_pub.g_all_k_category_code
1762: , p_measure_code => oki_load_rbk_pvt.g_qtr_actvty_code

Line 1759: , p_customer_party_id => oki_utl_pub.g_all_customer_id

1755: oki_load_rbk_pvt.ins_rnwl_bkng (
1756: p_summary_build_date => oki_utl_pub.g_summary_build_date
1757: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1758: , p_organization_name => oki_utl_pub.g_all_organization_name
1759: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1760: , p_customer_name => oki_utl_pub.g_all_customer_name
1761: , p_scs_code => oki_utl_pub.g_all_k_category_code
1762: , p_measure_code => oki_load_rbk_pvt.g_qtr_actvty_code
1763: , p_measure_code_meaning => l_bin_code_meaning

Line 1760: , p_customer_name => oki_utl_pub.g_all_customer_name

1756: p_summary_build_date => oki_utl_pub.g_summary_build_date
1757: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1758: , p_organization_name => oki_utl_pub.g_all_organization_name
1759: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1760: , p_customer_name => oki_utl_pub.g_all_customer_name
1761: , p_scs_code => oki_utl_pub.g_all_k_category_code
1762: , p_measure_code => oki_load_rbk_pvt.g_qtr_actvty_code
1763: , p_measure_code_meaning => l_bin_code_meaning
1764: , p_bin_code_seq => l_bin_code_seq

Line 1761: , p_scs_code => oki_utl_pub.g_all_k_category_code

1757: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1758: , p_organization_name => oki_utl_pub.g_all_organization_name
1759: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1760: , p_customer_name => oki_utl_pub.g_all_customer_name
1761: , p_scs_code => oki_utl_pub.g_all_k_category_code
1762: , p_measure_code => oki_load_rbk_pvt.g_qtr_actvty_code
1763: , p_measure_code_meaning => l_bin_code_meaning
1764: , p_bin_code_seq => l_bin_code_seq
1765: , p_curr_base_contract_amount => NULL

Line 1770: RAISE oki_utl_pub.g_excp_exit_immediate ;

1766: , p_prev_base_contract_amount => NULL
1767: , x_retcode => l_retcode ) ;
1768: IF l_retcode = '2' THEN
1769: -- Load failed, exit immediately.
1770: RAISE oki_utl_pub.g_excp_exit_immediate ;
1771: END IF ;
1772: ELSE
1773: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1774: -- Update the existing record

Line 1780: , p_organization_name => oki_utl_pub.g_all_organization_name

1776: p_curr_base_contract_amount => NULL
1777: , p_prev_base_contract_amount => NULL
1778: , p_measure_code_meaning => l_bin_code_meaning
1779: , p_bin_code_seq => l_bin_code_seq
1780: , p_organization_name => oki_utl_pub.g_all_organization_name
1781: , p_customer_name => oki_utl_pub.g_all_customer_name
1782: , p_rbk_rowid => rec_g_rbk_csr.rowid
1783: , x_retcode => l_retcode ) ;
1784:

Line 1781: , p_customer_name => oki_utl_pub.g_all_customer_name

1777: , p_prev_base_contract_amount => NULL
1778: , p_measure_code_meaning => l_bin_code_meaning
1779: , p_bin_code_seq => l_bin_code_seq
1780: , p_organization_name => oki_utl_pub.g_all_organization_name
1781: , p_customer_name => oki_utl_pub.g_all_customer_name
1782: , p_rbk_rowid => rec_g_rbk_csr.rowid
1783: , x_retcode => l_retcode ) ;
1784:
1785: IF l_retcode = '2' THEN

Line 1787: RAISE oki_utl_pub.g_excp_exit_immediate ;

1783: , x_retcode => l_retcode ) ;
1784:
1785: IF l_retcode = '2' THEN
1786: -- Load failed, exit immediately.
1787: RAISE oki_utl_pub.g_excp_exit_immediate ;
1788: END IF ;
1789: END IF ;
1790: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
1791:

Line 1814: OPEN l_bklg_k_rwned_csr( oki_utl_pub.g_summary_build_date,

1810: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
1811:
1812: -- Get the current value
1813: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1814: OPEN l_bklg_k_rwned_csr( oki_utl_pub.g_summary_build_date,
1815: oki_utl_pub.g_glpr_qtr_start_date ) ;
1816: FETCH l_bklg_k_rwned_csr INTO rec_l_bklg_k_rwned_csr ;
1817: IF l_bklg_k_rwned_csr%FOUND THEN
1818: l_curr_bklg_k_rwned := rec_l_bklg_k_rwned_csr.value ;

Line 1815: oki_utl_pub.g_glpr_qtr_start_date ) ;

1811:
1812: -- Get the current value
1813: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1814: OPEN l_bklg_k_rwned_csr( oki_utl_pub.g_summary_build_date,
1815: oki_utl_pub.g_glpr_qtr_start_date ) ;
1816: FETCH l_bklg_k_rwned_csr INTO rec_l_bklg_k_rwned_csr ;
1817: IF l_bklg_k_rwned_csr%FOUND THEN
1818: l_curr_bklg_k_rwned := rec_l_bklg_k_rwned_csr.value ;
1819: END IF ;

Line 1823: OPEN l_bklg_k_rwned_csr( oki_utl_pub.g_py_summary_build_date,

1819: END IF ;
1820: CLOSE l_bklg_k_rwned_csr;
1821:
1822: -- Get the previous value
1823: OPEN l_bklg_k_rwned_csr( oki_utl_pub.g_py_summary_build_date,
1824: oki_utl_pub.g_py_glpr_qtr_start_date ) ;
1825: FETCH l_bklg_k_rwned_csr INTO rec_l_bklg_k_rwned_csr ;
1826: IF l_bklg_k_rwned_csr%FOUND THEN
1827: l_prev_bklg_k_rwned := rec_l_bklg_k_rwned_csr.value ;

Line 1824: oki_utl_pub.g_py_glpr_qtr_start_date ) ;

1820: CLOSE l_bklg_k_rwned_csr;
1821:
1822: -- Get the previous value
1823: OPEN l_bklg_k_rwned_csr( oki_utl_pub.g_py_summary_build_date,
1824: oki_utl_pub.g_py_glpr_qtr_start_date ) ;
1825: FETCH l_bklg_k_rwned_csr INTO rec_l_bklg_k_rwned_csr ;
1826: IF l_bklg_k_rwned_csr%FOUND THEN
1827: l_prev_bklg_k_rwned := rec_l_bklg_k_rwned_csr.value ;
1828: END IF ;

Line 1833: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date

1829: CLOSE l_bklg_k_rwned_csr ;
1830:
1831: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1832: -- Determine if the record is a new one or an existing one
1833: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1834: , oki_utl_pub.g_all_organization_id
1835: , oki_utl_pub.g_all_customer_id, oki_utl_pub.g_all_k_category_code
1836: , oki_load_rbk_pvt.g_bklg_k_rnwed_code ) ;
1837: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

Line 1834: , oki_utl_pub.g_all_organization_id

1830:
1831: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1832: -- Determine if the record is a new one or an existing one
1833: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1834: , oki_utl_pub.g_all_organization_id
1835: , oki_utl_pub.g_all_customer_id, oki_utl_pub.g_all_k_category_code
1836: , oki_load_rbk_pvt.g_bklg_k_rnwed_code ) ;
1837: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1838: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

Line 1835: , oki_utl_pub.g_all_customer_id, oki_utl_pub.g_all_k_category_code

1831: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1832: -- Determine if the record is a new one or an existing one
1833: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
1834: , oki_utl_pub.g_all_organization_id
1835: , oki_utl_pub.g_all_customer_id, oki_utl_pub.g_all_k_category_code
1836: , oki_load_rbk_pvt.g_bklg_k_rnwed_code ) ;
1837: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1838: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1839: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 1842: p_summary_build_date => oki_utl_pub.g_summary_build_date

1838: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1839: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1840: -- Insert the new record
1841: oki_load_rbk_pvt.ins_rnwl_bkng (
1842: p_summary_build_date => oki_utl_pub.g_summary_build_date
1843: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1844: , p_organization_name => oki_utl_pub.g_all_organization_name
1845: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1846: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 1843: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

1839: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1840: -- Insert the new record
1841: oki_load_rbk_pvt.ins_rnwl_bkng (
1842: p_summary_build_date => oki_utl_pub.g_summary_build_date
1843: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1844: , p_organization_name => oki_utl_pub.g_all_organization_name
1845: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1846: , p_customer_name => oki_utl_pub.g_all_customer_name
1847: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 1844: , p_organization_name => oki_utl_pub.g_all_organization_name

1840: -- Insert the new record
1841: oki_load_rbk_pvt.ins_rnwl_bkng (
1842: p_summary_build_date => oki_utl_pub.g_summary_build_date
1843: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1844: , p_organization_name => oki_utl_pub.g_all_organization_name
1845: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1846: , p_customer_name => oki_utl_pub.g_all_customer_name
1847: , p_scs_code => oki_utl_pub.g_all_k_category_code
1848: , p_measure_code => oki_load_rbk_pvt.g_bklg_k_rnwed_code

Line 1845: , p_customer_party_id => oki_utl_pub.g_all_customer_id

1841: oki_load_rbk_pvt.ins_rnwl_bkng (
1842: p_summary_build_date => oki_utl_pub.g_summary_build_date
1843: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1844: , p_organization_name => oki_utl_pub.g_all_organization_name
1845: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1846: , p_customer_name => oki_utl_pub.g_all_customer_name
1847: , p_scs_code => oki_utl_pub.g_all_k_category_code
1848: , p_measure_code => oki_load_rbk_pvt.g_bklg_k_rnwed_code
1849: , p_measure_code_meaning => l_bin_code_meaning

Line 1846: , p_customer_name => oki_utl_pub.g_all_customer_name

1842: p_summary_build_date => oki_utl_pub.g_summary_build_date
1843: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1844: , p_organization_name => oki_utl_pub.g_all_organization_name
1845: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1846: , p_customer_name => oki_utl_pub.g_all_customer_name
1847: , p_scs_code => oki_utl_pub.g_all_k_category_code
1848: , p_measure_code => oki_load_rbk_pvt.g_bklg_k_rnwed_code
1849: , p_measure_code_meaning => l_bin_code_meaning
1850: , p_bin_code_seq => l_bin_code_seq

Line 1847: , p_scs_code => oki_utl_pub.g_all_k_category_code

1843: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1844: , p_organization_name => oki_utl_pub.g_all_organization_name
1845: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1846: , p_customer_name => oki_utl_pub.g_all_customer_name
1847: , p_scs_code => oki_utl_pub.g_all_k_category_code
1848: , p_measure_code => oki_load_rbk_pvt.g_bklg_k_rnwed_code
1849: , p_measure_code_meaning => l_bin_code_meaning
1850: , p_bin_code_seq => l_bin_code_seq
1851: , p_curr_base_contract_amount => l_curr_bklg_k_rwned

Line 1856: RAISE oki_utl_pub.g_excp_exit_immediate ;

1852: , p_prev_base_contract_amount => l_prev_bklg_k_rwned
1853: , x_retcode => l_retcode ) ;
1854: IF l_retcode = '2' THEN
1855: -- Load failed, exit immediately.
1856: RAISE oki_utl_pub.g_excp_exit_immediate ;
1857: END IF ;
1858: ELSE
1859: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1860: -- Update the existing record

Line 1866: , p_organization_name => oki_utl_pub.g_all_organization_name

1862: p_curr_base_contract_amount => l_curr_bklg_k_rwned
1863: , p_prev_base_contract_amount => l_prev_bklg_k_rwned
1864: , p_measure_code_meaning => l_bin_code_meaning
1865: , p_bin_code_seq => l_bin_code_seq
1866: , p_organization_name => oki_utl_pub.g_all_organization_name
1867: , p_customer_name => oki_utl_pub.g_all_customer_name
1868: , p_rbk_rowid => rec_g_rbk_csr.rowid
1869: , x_retcode => l_retcode ) ;
1870:

Line 1867: , p_customer_name => oki_utl_pub.g_all_customer_name

1863: , p_prev_base_contract_amount => l_prev_bklg_k_rwned
1864: , p_measure_code_meaning => l_bin_code_meaning
1865: , p_bin_code_seq => l_bin_code_seq
1866: , p_organization_name => oki_utl_pub.g_all_organization_name
1867: , p_customer_name => oki_utl_pub.g_all_customer_name
1868: , p_rbk_rowid => rec_g_rbk_csr.rowid
1869: , x_retcode => l_retcode ) ;
1870:
1871: IF l_retcode = '2' THEN

Line 1873: RAISE oki_utl_pub.g_excp_exit_immediate ;

1869: , x_retcode => l_retcode ) ;
1870:
1871: IF l_retcode = '2' THEN
1872: -- Load failed, exit immediately.
1873: RAISE oki_utl_pub.g_excp_exit_immediate ;
1874: END IF ;
1875: END IF ;
1876: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
1877:

Line 1900: OPEN l_k_rnwed_csr( oki_utl_pub.g_glpr_qtr_start_date,

1896: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
1897:
1898: -- Get the current value
1899: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1900: OPEN l_k_rnwed_csr( oki_utl_pub.g_glpr_qtr_start_date,
1901: oki_utl_pub.g_glpr_qtr_end_date ) ;
1902: FETCH l_k_rnwed_csr INTO rec_l_k_rnwed_csr ;
1903: IF l_k_rnwed_csr%FOUND THEN
1904: l_curr_k_rnwed := rec_l_k_rnwed_csr.value ;

Line 1901: oki_utl_pub.g_glpr_qtr_end_date ) ;

1897:
1898: -- Get the current value
1899: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1900: OPEN l_k_rnwed_csr( oki_utl_pub.g_glpr_qtr_start_date,
1901: oki_utl_pub.g_glpr_qtr_end_date ) ;
1902: FETCH l_k_rnwed_csr INTO rec_l_k_rnwed_csr ;
1903: IF l_k_rnwed_csr%FOUND THEN
1904: l_curr_k_rnwed := rec_l_k_rnwed_csr.value ;
1905: END IF ;

Line 1910: OPEN l_k_rnwed_csr( oki_utl_pub.g_py_glpr_qtr_start_date,

1906: CLOSE l_k_rnwed_csr ;
1907:
1908: -- Get the previous value
1909: l_loc := 'Opening Cursor to determine previous ' || l_measure_type || '.' ;
1910: OPEN l_k_rnwed_csr( oki_utl_pub.g_py_glpr_qtr_start_date,
1911: oki_utl_pub.g_py_glpr_qtr_end_date ) ;
1912: FETCH l_k_rnwed_csr INTO rec_l_k_rnwed_csr ;
1913: IF l_k_rnwed_csr%FOUND THEN
1914: l_prev_k_rnwed := rec_l_k_rnwed_csr.value ;

Line 1911: oki_utl_pub.g_py_glpr_qtr_end_date ) ;

1907:
1908: -- Get the previous value
1909: l_loc := 'Opening Cursor to determine previous ' || l_measure_type || '.' ;
1910: OPEN l_k_rnwed_csr( oki_utl_pub.g_py_glpr_qtr_start_date,
1911: oki_utl_pub.g_py_glpr_qtr_end_date ) ;
1912: FETCH l_k_rnwed_csr INTO rec_l_k_rnwed_csr ;
1913: IF l_k_rnwed_csr%FOUND THEN
1914: l_prev_k_rnwed := rec_l_k_rnwed_csr.value ;
1915: END IF ;

Line 1920: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date,

1916: CLOSE l_k_rnwed_csr ;
1917:
1918: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1919: -- Determine if the record is a new one or an existing one
1920: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date,
1921: oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id,
1922: oki_utl_pub.g_all_k_category_code, oki_load_rbk_pvt.g_k_rnwed_code ) ;
1923: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1924: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

Line 1921: oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id,

1917:
1918: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1919: -- Determine if the record is a new one or an existing one
1920: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date,
1921: oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id,
1922: oki_utl_pub.g_all_k_category_code, oki_load_rbk_pvt.g_k_rnwed_code ) ;
1923: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1924: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1925: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 1922: oki_utl_pub.g_all_k_category_code, oki_load_rbk_pvt.g_k_rnwed_code ) ;

1918: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
1919: -- Determine if the record is a new one or an existing one
1920: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date,
1921: oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id,
1922: oki_utl_pub.g_all_k_category_code, oki_load_rbk_pvt.g_k_rnwed_code ) ;
1923: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
1924: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1925: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1926: -- Insert the new record

Line 1928: p_summary_build_date => oki_utl_pub.g_summary_build_date

1924: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
1925: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1926: -- Insert the new record
1927: oki_load_rbk_pvt.ins_rnwl_bkng (
1928: p_summary_build_date => oki_utl_pub.g_summary_build_date
1929: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1930: , p_organization_name => oki_utl_pub.g_all_organization_name
1931: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1932: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 1929: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

1925: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
1926: -- Insert the new record
1927: oki_load_rbk_pvt.ins_rnwl_bkng (
1928: p_summary_build_date => oki_utl_pub.g_summary_build_date
1929: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1930: , p_organization_name => oki_utl_pub.g_all_organization_name
1931: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1932: , p_customer_name => oki_utl_pub.g_all_customer_name
1933: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 1930: , p_organization_name => oki_utl_pub.g_all_organization_name

1926: -- Insert the new record
1927: oki_load_rbk_pvt.ins_rnwl_bkng (
1928: p_summary_build_date => oki_utl_pub.g_summary_build_date
1929: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1930: , p_organization_name => oki_utl_pub.g_all_organization_name
1931: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1932: , p_customer_name => oki_utl_pub.g_all_customer_name
1933: , p_scs_code => oki_utl_pub.g_all_k_category_code
1934: , p_measure_code => oki_load_rbk_pvt.g_k_rnwed_code

Line 1931: , p_customer_party_id => oki_utl_pub.g_all_customer_id

1927: oki_load_rbk_pvt.ins_rnwl_bkng (
1928: p_summary_build_date => oki_utl_pub.g_summary_build_date
1929: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1930: , p_organization_name => oki_utl_pub.g_all_organization_name
1931: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1932: , p_customer_name => oki_utl_pub.g_all_customer_name
1933: , p_scs_code => oki_utl_pub.g_all_k_category_code
1934: , p_measure_code => oki_load_rbk_pvt.g_k_rnwed_code
1935: , p_measure_code_meaning => l_bin_code_meaning

Line 1932: , p_customer_name => oki_utl_pub.g_all_customer_name

1928: p_summary_build_date => oki_utl_pub.g_summary_build_date
1929: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1930: , p_organization_name => oki_utl_pub.g_all_organization_name
1931: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1932: , p_customer_name => oki_utl_pub.g_all_customer_name
1933: , p_scs_code => oki_utl_pub.g_all_k_category_code
1934: , p_measure_code => oki_load_rbk_pvt.g_k_rnwed_code
1935: , p_measure_code_meaning => l_bin_code_meaning
1936: , p_bin_code_seq => l_bin_code_seq

Line 1933: , p_scs_code => oki_utl_pub.g_all_k_category_code

1929: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
1930: , p_organization_name => oki_utl_pub.g_all_organization_name
1931: , p_customer_party_id => oki_utl_pub.g_all_customer_id
1932: , p_customer_name => oki_utl_pub.g_all_customer_name
1933: , p_scs_code => oki_utl_pub.g_all_k_category_code
1934: , p_measure_code => oki_load_rbk_pvt.g_k_rnwed_code
1935: , p_measure_code_meaning => l_bin_code_meaning
1936: , p_bin_code_seq => l_bin_code_seq
1937: , p_curr_base_contract_amount => l_curr_k_rnwed

Line 1942: RAISE oki_utl_pub.g_excp_exit_immediate ;

1938: , p_prev_base_contract_amount => l_prev_k_rnwed
1939: , x_retcode => l_retcode ) ;
1940: IF l_retcode = '2' THEN
1941: -- Load failed, exit immediately.
1942: RAISE oki_utl_pub.g_excp_exit_immediate ;
1943: END IF ;
1944: ELSE
1945: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1946: -- Update the existing record

Line 1952: , p_organization_name => oki_utl_pub.g_all_organization_name

1948: p_curr_base_contract_amount => l_curr_k_rnwed
1949: , p_prev_base_contract_amount => l_prev_k_rnwed
1950: , p_measure_code_meaning => l_bin_code_meaning
1951: , p_bin_code_seq => l_bin_code_seq
1952: , p_organization_name => oki_utl_pub.g_all_organization_name
1953: , p_customer_name => oki_utl_pub.g_all_customer_name
1954: , p_rbk_rowid => rec_g_rbk_csr.rowid
1955: , x_retcode => l_retcode ) ;
1956:

Line 1953: , p_customer_name => oki_utl_pub.g_all_customer_name

1949: , p_prev_base_contract_amount => l_prev_k_rnwed
1950: , p_measure_code_meaning => l_bin_code_meaning
1951: , p_bin_code_seq => l_bin_code_seq
1952: , p_organization_name => oki_utl_pub.g_all_organization_name
1953: , p_customer_name => oki_utl_pub.g_all_customer_name
1954: , p_rbk_rowid => rec_g_rbk_csr.rowid
1955: , x_retcode => l_retcode ) ;
1956:
1957: IF l_retcode = '2' THEN

Line 1959: RAISE oki_utl_pub.g_excp_exit_immediate ;

1955: , x_retcode => l_retcode ) ;
1956:
1957: IF l_retcode = '2' THEN
1958: -- Load failed, exit immediately.
1959: RAISE oki_utl_pub.g_excp_exit_immediate ;
1960: END IF ;
1961: END IF ;
1962: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
1963:

Line 1986: OPEN l_new_bus_csr( oki_utl_pub.g_summary_build_date,

1982: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
1983:
1984: -- Get the current value
1985: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1986: OPEN l_new_bus_csr( oki_utl_pub.g_summary_build_date,
1987: oki_utl_pub.g_glpr_qtr_start_date ) ;
1988: FETCH l_new_bus_csr INTO rec_l_new_bus_csr ;
1989: IF l_new_bus_csr%FOUND THEN
1990: l_curr_new_bus := rec_l_new_bus_csr.value ;

Line 1987: oki_utl_pub.g_glpr_qtr_start_date ) ;

1983:
1984: -- Get the current value
1985: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
1986: OPEN l_new_bus_csr( oki_utl_pub.g_summary_build_date,
1987: oki_utl_pub.g_glpr_qtr_start_date ) ;
1988: FETCH l_new_bus_csr INTO rec_l_new_bus_csr ;
1989: IF l_new_bus_csr%FOUND THEN
1990: l_curr_new_bus := rec_l_new_bus_csr.value ;
1991: END IF ;

Line 1996: OPEN l_new_bus_csr( oki_utl_pub.g_py_summary_build_date,

1992: CLOSE l_new_bus_csr ;
1993:
1994: -- Get the previous value
1995: l_loc := 'Opening Cursor to determine previous ' || l_measure_type || '.' ;
1996: OPEN l_new_bus_csr( oki_utl_pub.g_py_summary_build_date,
1997: oki_utl_pub.g_py_glpr_qtr_start_date ) ;
1998: FETCH l_new_bus_csr INTO rec_l_new_bus_csr ;
1999: IF l_new_bus_csr%FOUND THEN
2000: l_prev_new_bus := rec_l_new_bus_csr.value ;

Line 1997: oki_utl_pub.g_py_glpr_qtr_start_date ) ;

1993:
1994: -- Get the previous value
1995: l_loc := 'Opening Cursor to determine previous ' || l_measure_type || '.' ;
1996: OPEN l_new_bus_csr( oki_utl_pub.g_py_summary_build_date,
1997: oki_utl_pub.g_py_glpr_qtr_start_date ) ;
1998: FETCH l_new_bus_csr INTO rec_l_new_bus_csr ;
1999: IF l_new_bus_csr%FOUND THEN
2000: l_prev_new_bus := rec_l_new_bus_csr.value ;
2001: END IF ;

Line 2006: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date

2002: CLOSE l_new_bus_csr ;
2003:
2004: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
2005: -- Determine if the record is a new one or an existing one
2006: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
2007: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
2008: , oki_utl_pub.g_all_k_category_code
2009: , oki_load_rbk_pvt.g_new_bsn_code ) ;
2010: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

Line 2007: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id

2003:
2004: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
2005: -- Determine if the record is a new one or an existing one
2006: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
2007: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
2008: , oki_utl_pub.g_all_k_category_code
2009: , oki_load_rbk_pvt.g_new_bsn_code ) ;
2010: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
2011: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

Line 2008: , oki_utl_pub.g_all_k_category_code

2004: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
2005: -- Determine if the record is a new one or an existing one
2006: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
2007: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
2008: , oki_utl_pub.g_all_k_category_code
2009: , oki_load_rbk_pvt.g_new_bsn_code ) ;
2010: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
2011: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
2012: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 2015: p_summary_build_date => oki_utl_pub.g_summary_build_date

2011: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
2012: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
2013: -- Insert the new record
2014: oki_load_rbk_pvt.ins_rnwl_bkng (
2015: p_summary_build_date => oki_utl_pub.g_summary_build_date
2016: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2017: , p_organization_name => oki_utl_pub.g_all_organization_name
2018: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2019: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 2016: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

2012: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
2013: -- Insert the new record
2014: oki_load_rbk_pvt.ins_rnwl_bkng (
2015: p_summary_build_date => oki_utl_pub.g_summary_build_date
2016: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2017: , p_organization_name => oki_utl_pub.g_all_organization_name
2018: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2019: , p_customer_name => oki_utl_pub.g_all_customer_name
2020: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 2017: , p_organization_name => oki_utl_pub.g_all_organization_name

2013: -- Insert the new record
2014: oki_load_rbk_pvt.ins_rnwl_bkng (
2015: p_summary_build_date => oki_utl_pub.g_summary_build_date
2016: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2017: , p_organization_name => oki_utl_pub.g_all_organization_name
2018: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2019: , p_customer_name => oki_utl_pub.g_all_customer_name
2020: , p_scs_code => oki_utl_pub.g_all_k_category_code
2021: , p_measure_code => oki_load_rbk_pvt.g_new_bsn_code

Line 2018: , p_customer_party_id => oki_utl_pub.g_all_customer_id

2014: oki_load_rbk_pvt.ins_rnwl_bkng (
2015: p_summary_build_date => oki_utl_pub.g_summary_build_date
2016: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2017: , p_organization_name => oki_utl_pub.g_all_organization_name
2018: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2019: , p_customer_name => oki_utl_pub.g_all_customer_name
2020: , p_scs_code => oki_utl_pub.g_all_k_category_code
2021: , p_measure_code => oki_load_rbk_pvt.g_new_bsn_code
2022: , p_measure_code_meaning => l_bin_code_meaning

Line 2019: , p_customer_name => oki_utl_pub.g_all_customer_name

2015: p_summary_build_date => oki_utl_pub.g_summary_build_date
2016: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2017: , p_organization_name => oki_utl_pub.g_all_organization_name
2018: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2019: , p_customer_name => oki_utl_pub.g_all_customer_name
2020: , p_scs_code => oki_utl_pub.g_all_k_category_code
2021: , p_measure_code => oki_load_rbk_pvt.g_new_bsn_code
2022: , p_measure_code_meaning => l_bin_code_meaning
2023: , p_bin_code_seq => l_bin_code_seq

Line 2020: , p_scs_code => oki_utl_pub.g_all_k_category_code

2016: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2017: , p_organization_name => oki_utl_pub.g_all_organization_name
2018: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2019: , p_customer_name => oki_utl_pub.g_all_customer_name
2020: , p_scs_code => oki_utl_pub.g_all_k_category_code
2021: , p_measure_code => oki_load_rbk_pvt.g_new_bsn_code
2022: , p_measure_code_meaning => l_bin_code_meaning
2023: , p_bin_code_seq => l_bin_code_seq
2024: , p_curr_base_contract_amount => l_curr_new_bus

Line 2029: RAISE oki_utl_pub.g_excp_exit_immediate ;

2025: , p_prev_base_contract_amount => l_prev_new_bus
2026: , x_retcode => l_retcode ) ;
2027: IF l_retcode = '2' THEN
2028: -- Load failed, exit immediately.
2029: RAISE oki_utl_pub.g_excp_exit_immediate ;
2030: END IF ;
2031: ELSE
2032: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
2033: -- Update the existing record

Line 2039: , p_organization_name => oki_utl_pub.g_all_organization_name

2035: p_curr_base_contract_amount => l_curr_new_bus
2036: , p_prev_base_contract_amount => l_prev_new_bus
2037: , p_measure_code_meaning => l_bin_code_meaning
2038: , p_bin_code_seq => l_bin_code_seq
2039: , p_organization_name => oki_utl_pub.g_all_organization_name
2040: , p_customer_name => oki_utl_pub.g_all_customer_name
2041: , p_rbk_rowid => rec_g_rbk_csr.rowid
2042: , x_retcode => l_retcode ) ;
2043:

Line 2040: , p_customer_name => oki_utl_pub.g_all_customer_name

2036: , p_prev_base_contract_amount => l_prev_new_bus
2037: , p_measure_code_meaning => l_bin_code_meaning
2038: , p_bin_code_seq => l_bin_code_seq
2039: , p_organization_name => oki_utl_pub.g_all_organization_name
2040: , p_customer_name => oki_utl_pub.g_all_customer_name
2041: , p_rbk_rowid => rec_g_rbk_csr.rowid
2042: , x_retcode => l_retcode ) ;
2043:
2044: IF l_retcode = '2' THEN

Line 2046: RAISE oki_utl_pub.g_excp_exit_immediate ;

2042: , x_retcode => l_retcode ) ;
2043:
2044: IF l_retcode = '2' THEN
2045: -- Load failed, exit immediately.
2046: RAISE oki_utl_pub.g_excp_exit_immediate ;
2047: END IF ;
2048: END IF ;
2049: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
2050:

Line 2073: OPEN l_trmn_k_csr( oki_utl_pub.g_summary_build_date,

2069: CLOSE oki_utl_pvt.g_bin_disp_lkup_csr ;
2070:
2071: -- Get the current value
2072: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
2073: OPEN l_trmn_k_csr( oki_utl_pub.g_summary_build_date,
2074: oki_utl_pub.g_glpr_qtr_start_date ) ;
2075: FETCH l_trmn_k_csr INTO rec_l_trmn_k_csr ;
2076: IF l_trmn_k_csr%FOUND THEN
2077: l_curr_trmn_k := rec_l_trmn_k_csr.value ;

Line 2074: oki_utl_pub.g_glpr_qtr_start_date ) ;

2070:
2071: -- Get the current value
2072: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
2073: OPEN l_trmn_k_csr( oki_utl_pub.g_summary_build_date,
2074: oki_utl_pub.g_glpr_qtr_start_date ) ;
2075: FETCH l_trmn_k_csr INTO rec_l_trmn_k_csr ;
2076: IF l_trmn_k_csr%FOUND THEN
2077: l_curr_trmn_k := rec_l_trmn_k_csr.value ;
2078: END IF ;

Line 2083: OPEN l_trmn_k_csr( oki_utl_pub.g_py_summary_build_date,

2079: CLOSE l_trmn_k_csr ;
2080:
2081: -- Get the previous value
2082: l_loc := 'Opening Cursor to determine previous ' || l_measure_type || '.' ;
2083: OPEN l_trmn_k_csr( oki_utl_pub.g_py_summary_build_date,
2084: oki_utl_pub.g_py_glpr_qtr_start_date ) ;
2085: FETCH l_trmn_k_csr INTO rec_l_trmn_k_csr ;
2086: IF l_trmn_k_csr%FOUND THEN
2087: l_prev_trmn_k := rec_l_trmn_k_csr.value ;

Line 2084: oki_utl_pub.g_py_glpr_qtr_start_date ) ;

2080:
2081: -- Get the previous value
2082: l_loc := 'Opening Cursor to determine previous ' || l_measure_type || '.' ;
2083: OPEN l_trmn_k_csr( oki_utl_pub.g_py_summary_build_date,
2084: oki_utl_pub.g_py_glpr_qtr_start_date ) ;
2085: FETCH l_trmn_k_csr INTO rec_l_trmn_k_csr ;
2086: IF l_trmn_k_csr%FOUND THEN
2087: l_prev_trmn_k := rec_l_trmn_k_csr.value ;
2088: END IF ;

Line 2093: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date

2089: CLOSE l_trmn_k_csr ;
2090:
2091: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
2092: -- Determine if the record is a new one or an existing one
2093: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
2094: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
2095: , oki_utl_pub.g_all_k_category_code
2096: , oki_load_rbk_pvt.g_trmn_k_code ) ;
2097: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

Line 2094: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id

2090:
2091: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
2092: -- Determine if the record is a new one or an existing one
2093: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
2094: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
2095: , oki_utl_pub.g_all_k_category_code
2096: , oki_load_rbk_pvt.g_trmn_k_code ) ;
2097: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
2098: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

Line 2095: , oki_utl_pub.g_all_k_category_code

2091: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
2092: -- Determine if the record is a new one or an existing one
2093: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
2094: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
2095: , oki_utl_pub.g_all_k_category_code
2096: , oki_load_rbk_pvt.g_trmn_k_code ) ;
2097: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
2098: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
2099: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 2102: p_summary_build_date => oki_utl_pub.g_summary_build_date

2098: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
2099: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
2100: -- Insert the new record
2101: oki_load_rbk_pvt.ins_rnwl_bkng (
2102: p_summary_build_date => oki_utl_pub.g_summary_build_date
2103: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2104: , p_organization_name => oki_utl_pub.g_all_organization_name
2105: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2106: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 2103: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

2099: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
2100: -- Insert the new record
2101: oki_load_rbk_pvt.ins_rnwl_bkng (
2102: p_summary_build_date => oki_utl_pub.g_summary_build_date
2103: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2104: , p_organization_name => oki_utl_pub.g_all_organization_name
2105: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2106: , p_customer_name => oki_utl_pub.g_all_customer_name
2107: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 2104: , p_organization_name => oki_utl_pub.g_all_organization_name

2100: -- Insert the new record
2101: oki_load_rbk_pvt.ins_rnwl_bkng (
2102: p_summary_build_date => oki_utl_pub.g_summary_build_date
2103: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2104: , p_organization_name => oki_utl_pub.g_all_organization_name
2105: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2106: , p_customer_name => oki_utl_pub.g_all_customer_name
2107: , p_scs_code => oki_utl_pub.g_all_k_category_code
2108: , p_measure_code => oki_load_rbk_pvt.g_trmn_k_code

Line 2105: , p_customer_party_id => oki_utl_pub.g_all_customer_id

2101: oki_load_rbk_pvt.ins_rnwl_bkng (
2102: p_summary_build_date => oki_utl_pub.g_summary_build_date
2103: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2104: , p_organization_name => oki_utl_pub.g_all_organization_name
2105: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2106: , p_customer_name => oki_utl_pub.g_all_customer_name
2107: , p_scs_code => oki_utl_pub.g_all_k_category_code
2108: , p_measure_code => oki_load_rbk_pvt.g_trmn_k_code
2109: , p_measure_code_meaning => l_bin_code_meaning

Line 2106: , p_customer_name => oki_utl_pub.g_all_customer_name

2102: p_summary_build_date => oki_utl_pub.g_summary_build_date
2103: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2104: , p_organization_name => oki_utl_pub.g_all_organization_name
2105: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2106: , p_customer_name => oki_utl_pub.g_all_customer_name
2107: , p_scs_code => oki_utl_pub.g_all_k_category_code
2108: , p_measure_code => oki_load_rbk_pvt.g_trmn_k_code
2109: , p_measure_code_meaning => l_bin_code_meaning
2110: , p_bin_code_seq => l_bin_code_seq

Line 2107: , p_scs_code => oki_utl_pub.g_all_k_category_code

2103: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2104: , p_organization_name => oki_utl_pub.g_all_organization_name
2105: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2106: , p_customer_name => oki_utl_pub.g_all_customer_name
2107: , p_scs_code => oki_utl_pub.g_all_k_category_code
2108: , p_measure_code => oki_load_rbk_pvt.g_trmn_k_code
2109: , p_measure_code_meaning => l_bin_code_meaning
2110: , p_bin_code_seq => l_bin_code_seq
2111: , p_curr_base_contract_amount => l_curr_trmn_k

Line 2116: RAISE oki_utl_pub.g_excp_exit_immediate ;

2112: , p_prev_base_contract_amount => l_prev_trmn_k
2113: , x_retcode => l_retcode ) ;
2114: IF l_retcode = '2' THEN
2115: -- Load failed, exit immediately.
2116: RAISE oki_utl_pub.g_excp_exit_immediate ;
2117: END IF ;
2118: ELSE
2119: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
2120: -- Update the existing record

Line 2126: , p_organization_name => oki_utl_pub.g_all_organization_name

2122: p_curr_base_contract_amount => l_curr_trmn_k
2123: , p_prev_base_contract_amount => l_prev_trmn_k
2124: , p_measure_code_meaning => l_bin_code_meaning
2125: , p_bin_code_seq => l_bin_code_seq
2126: , p_organization_name => oki_utl_pub.g_all_organization_name
2127: , p_customer_name => oki_utl_pub.g_all_customer_name
2128: , p_rbk_rowid => rec_g_rbk_csr.rowid
2129: , x_retcode => l_retcode ) ;
2130:

Line 2127: , p_customer_name => oki_utl_pub.g_all_customer_name

2123: , p_prev_base_contract_amount => l_prev_trmn_k
2124: , p_measure_code_meaning => l_bin_code_meaning
2125: , p_bin_code_seq => l_bin_code_seq
2126: , p_organization_name => oki_utl_pub.g_all_organization_name
2127: , p_customer_name => oki_utl_pub.g_all_customer_name
2128: , p_rbk_rowid => rec_g_rbk_csr.rowid
2129: , x_retcode => l_retcode ) ;
2130:
2131: IF l_retcode = '2' THEN

Line 2133: RAISE oki_utl_pub.g_excp_exit_immediate ;

2129: , x_retcode => l_retcode ) ;
2130:
2131: IF l_retcode = '2' THEN
2132: -- Load failed, exit immediately.
2133: RAISE oki_utl_pub.g_excp_exit_immediate ;
2134: END IF ;
2135: END IF ;
2136: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
2137:

Line 2170: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date

2166: l_loc := 'Opening cursor to determine current ' || l_measure_type || '.' ;
2167:
2168: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
2169: -- Determine if the record is a new one or an existing one
2170: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
2171: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
2172: , oki_utl_pub.g_all_k_category_code
2173: , oki_load_rbk_pvt.g_e_act_k_code ) ;
2174: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

Line 2171: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id

2167:
2168: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
2169: -- Determine if the record is a new one or an existing one
2170: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
2171: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
2172: , oki_utl_pub.g_all_k_category_code
2173: , oki_load_rbk_pvt.g_e_act_k_code ) ;
2174: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
2175: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

Line 2172: , oki_utl_pub.g_all_k_category_code

2168: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
2169: -- Determine if the record is a new one or an existing one
2170: OPEN oki_load_rbk_pvt.g_rbk_csr ( oki_utl_pub.g_summary_build_date
2171: , oki_utl_pub.g_all_organization_id, oki_utl_pub.g_all_customer_id
2172: , oki_utl_pub.g_all_k_category_code
2173: , oki_load_rbk_pvt.g_e_act_k_code ) ;
2174: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;
2175: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
2176: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;

Line 2179: p_summary_build_date => oki_utl_pub.g_summary_build_date

2175: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN
2176: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
2177: -- Insert the new record
2178: oki_load_rbk_pvt.ins_rnwl_bkng (
2179: p_summary_build_date => oki_utl_pub.g_summary_build_date
2180: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2181: , p_organization_name => oki_utl_pub.g_all_organization_name
2182: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2183: , p_customer_name => oki_utl_pub.g_all_customer_name

Line 2180: , p_authoring_org_id => oki_utl_pub.g_all_organization_id

2176: l_loc := 'Insert the new record -- ' || l_measure_type || '.' ;
2177: -- Insert the new record
2178: oki_load_rbk_pvt.ins_rnwl_bkng (
2179: p_summary_build_date => oki_utl_pub.g_summary_build_date
2180: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2181: , p_organization_name => oki_utl_pub.g_all_organization_name
2182: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2183: , p_customer_name => oki_utl_pub.g_all_customer_name
2184: , p_scs_code => oki_utl_pub.g_all_k_category_code

Line 2181: , p_organization_name => oki_utl_pub.g_all_organization_name

2177: -- Insert the new record
2178: oki_load_rbk_pvt.ins_rnwl_bkng (
2179: p_summary_build_date => oki_utl_pub.g_summary_build_date
2180: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2181: , p_organization_name => oki_utl_pub.g_all_organization_name
2182: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2183: , p_customer_name => oki_utl_pub.g_all_customer_name
2184: , p_scs_code => oki_utl_pub.g_all_k_category_code
2185: , p_measure_code => oki_load_rbk_pvt.g_e_act_k_code

Line 2182: , p_customer_party_id => oki_utl_pub.g_all_customer_id

2178: oki_load_rbk_pvt.ins_rnwl_bkng (
2179: p_summary_build_date => oki_utl_pub.g_summary_build_date
2180: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2181: , p_organization_name => oki_utl_pub.g_all_organization_name
2182: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2183: , p_customer_name => oki_utl_pub.g_all_customer_name
2184: , p_scs_code => oki_utl_pub.g_all_k_category_code
2185: , p_measure_code => oki_load_rbk_pvt.g_e_act_k_code
2186: , p_measure_code_meaning => l_bin_code_meaning

Line 2183: , p_customer_name => oki_utl_pub.g_all_customer_name

2179: p_summary_build_date => oki_utl_pub.g_summary_build_date
2180: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2181: , p_organization_name => oki_utl_pub.g_all_organization_name
2182: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2183: , p_customer_name => oki_utl_pub.g_all_customer_name
2184: , p_scs_code => oki_utl_pub.g_all_k_category_code
2185: , p_measure_code => oki_load_rbk_pvt.g_e_act_k_code
2186: , p_measure_code_meaning => l_bin_code_meaning
2187: , p_bin_code_seq => l_bin_code_seq

Line 2184: , p_scs_code => oki_utl_pub.g_all_k_category_code

2180: , p_authoring_org_id => oki_utl_pub.g_all_organization_id
2181: , p_organization_name => oki_utl_pub.g_all_organization_name
2182: , p_customer_party_id => oki_utl_pub.g_all_customer_id
2183: , p_customer_name => oki_utl_pub.g_all_customer_name
2184: , p_scs_code => oki_utl_pub.g_all_k_category_code
2185: , p_measure_code => oki_load_rbk_pvt.g_e_act_k_code
2186: , p_measure_code_meaning => l_bin_code_meaning
2187: , p_bin_code_seq => l_bin_code_seq
2188: , p_curr_base_contract_amount => l_curr_e_act_k

Line 2193: RAISE oki_utl_pub.g_excp_exit_immediate ;

2189: , p_prev_base_contract_amount => l_prev_e_act_k
2190: , x_retcode => l_retcode ) ;
2191: IF l_retcode = '2' THEN
2192: -- Load failed, exit immediately.
2193: RAISE oki_utl_pub.g_excp_exit_immediate ;
2194: END IF ;
2195: ELSE
2196: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
2197: -- Update the existing record

Line 2203: , p_organization_name => oki_utl_pub.g_all_organization_name

2199: p_curr_base_contract_amount => l_curr_e_act_k
2200: , p_prev_base_contract_amount => l_prev_e_act_k
2201: , p_measure_code_meaning => l_bin_code_meaning
2202: , p_bin_code_seq => l_bin_code_seq
2203: , p_organization_name => oki_utl_pub.g_all_organization_name
2204: , p_customer_name => oki_utl_pub.g_all_customer_name
2205: , p_rbk_rowid => rec_g_rbk_csr.rowid
2206: , x_retcode => l_retcode ) ;
2207:

Line 2204: , p_customer_name => oki_utl_pub.g_all_customer_name

2200: , p_prev_base_contract_amount => l_prev_e_act_k
2201: , p_measure_code_meaning => l_bin_code_meaning
2202: , p_bin_code_seq => l_bin_code_seq
2203: , p_organization_name => oki_utl_pub.g_all_organization_name
2204: , p_customer_name => oki_utl_pub.g_all_customer_name
2205: , p_rbk_rowid => rec_g_rbk_csr.rowid
2206: , x_retcode => l_retcode ) ;
2207:
2208: IF l_retcode = '2' THEN

Line 2210: RAISE oki_utl_pub.g_excp_exit_immediate ;

2206: , x_retcode => l_retcode ) ;
2207:
2208: IF l_retcode = '2' THEN
2209: -- Load failed, exit immediately.
2210: RAISE oki_utl_pub.g_excp_exit_immediate ;
2211: END IF ;
2212: END IF ;
2213: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
2214:

Line 2216: WHEN oki_utl_pub.g_excp_exit_immediate THEN

2212: END IF ;
2213: CLOSE oki_load_rbk_pvt.g_rbk_csr ;
2214:
2215: EXCEPTION
2216: WHEN oki_utl_pub.g_excp_exit_immediate THEN
2217: -- Do not log an error ; It has already been logged.
2218: -- Set return code to error
2219: x_retcode := '2' ;
2220:

Line 2326: oki_utl_pub.g_summary_build_date := l_summary_build_date ;

2322: l_summary_build_date := TRUNC(p_start_summary_build_date) ;
2323:
2324: FOR i IN 1..l_upper_bound LOOP
2325:
2326: oki_utl_pub.g_summary_build_date := l_summary_build_date ;
2327:
2328: -- Get the GL periods start / end date
2329: oki_utl_pvt.get_gl_period_date (
2330: x_retcode => l_retcode ) ;

Line 2334: RAISE oki_utl_pub.g_excp_exit_immediate ;

2330: x_retcode => l_retcode ) ;
2331:
2332: IF l_retcode = '2' THEN
2333: -- Load failed, exit immediately.
2334: RAISE oki_utl_pub.g_excp_exit_immediate ;
2335: END IF ;
2336:
2337: -- Procedure to calculate the amounts for the all level
2338: oki_load_rbk_pvt.calc_rbk_sum (

Line 2343: RAISE oki_utl_pub.g_excp_exit_immediate ;

2339: x_retcode => l_retcode ) ;
2340:
2341: IF l_retcode = '2' THEN
2342: -- Load failed, exit immediately.
2343: RAISE oki_utl_pub.g_excp_exit_immediate ;
2344: END IF ;
2345:
2346: -- Procedure to calculate the amounts for the organization level
2347: oki_load_rbk_pvt.calc_rbk_dtl1 (

Line 2352: RAISE oki_utl_pub.g_excp_exit_immediate ;

2348: x_retcode => l_retcode ) ;
2349:
2350: IF l_retcode = '2' THEN
2351: -- Load failed, exit immediately.
2352: RAISE oki_utl_pub.g_excp_exit_immediate ;
2353: END IF ;
2354:
2355: l_summary_build_date := l_summary_build_date + 1 ;
2356:

Line 2392: WHEN oki_utl_pub.g_excp_exit_immediate THEN

2388: x_retcode := l_retcode ;
2389:
2390: ROLLBACK TO oki_rbk_upd_refresh ;
2391:
2392: WHEN oki_utl_pub.g_excp_exit_immediate THEN
2393: -- Do not log an error ; It has already been logged.
2394: -- Set return code to error
2395: x_retcode := '2' ;
2396: