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_LOAD_RBK_PVT

Line 1: PACKAGE BODY oki_load_rbk_pvt AS

1: PACKAGE BODY oki_load_rbk_pvt AS
2: /* $Header: OKIRRBKB.pls 115.7 2002/12/01 17:52:54 rpotnuru noship $ */
3:
4: --------------------------------------------------------------------------------
5: -- Modification History

Line 119: , oki_load_rbk_pvt.g_request_id

115: , p_measure_code_meaning
116: , p_bin_code_seq
117: , p_curr_base_contract_amount
118: , p_prev_base_contract_amount
119: , oki_load_rbk_pvt.g_request_id
120: , oki_load_rbk_pvt.g_program_application_id
121: , oki_load_rbk_pvt.g_program_id
122: , oki_load_rbk_pvt.g_program_update_date ) ;
123:

Line 120: , oki_load_rbk_pvt.g_program_application_id

116: , p_bin_code_seq
117: , p_curr_base_contract_amount
118: , p_prev_base_contract_amount
119: , oki_load_rbk_pvt.g_request_id
120: , oki_load_rbk_pvt.g_program_application_id
121: , oki_load_rbk_pvt.g_program_id
122: , oki_load_rbk_pvt.g_program_update_date ) ;
123:
124: EXCEPTION

Line 121: , oki_load_rbk_pvt.g_program_id

117: , p_curr_base_contract_amount
118: , p_prev_base_contract_amount
119: , oki_load_rbk_pvt.g_request_id
120: , oki_load_rbk_pvt.g_program_application_id
121: , oki_load_rbk_pvt.g_program_id
122: , oki_load_rbk_pvt.g_program_update_date ) ;
123:
124: EXCEPTION
125: WHEN OTHERS THEN

Line 122: , oki_load_rbk_pvt.g_program_update_date ) ;

118: , p_prev_base_contract_amount
119: , oki_load_rbk_pvt.g_request_id
120: , oki_load_rbk_pvt.g_program_application_id
121: , oki_load_rbk_pvt.g_program_id
122: , oki_load_rbk_pvt.g_program_update_date ) ;
123:
124: EXCEPTION
125: WHEN OTHERS THEN
126: l_sqlcode := SQLCODE ;

Line 180: , request_id = oki_load_rbk_pvt.g_request_id

176: , measure_code_meaning = p_measure_code_meaning
177: , bin_code_seq = p_bin_code_seq
178: , organization_name = p_organization_name
179: , customer_name = p_customer_name
180: , request_id = oki_load_rbk_pvt.g_request_id
181: , program_application_id = oki_load_rbk_pvt.g_program_application_id
182: , program_id = oki_load_rbk_pvt.g_program_id
183: , program_update_date = oki_load_rbk_pvt.g_program_update_date
184: WHERE ROWID = p_rbk_rowid ;

Line 181: , program_application_id = oki_load_rbk_pvt.g_program_application_id

177: , bin_code_seq = p_bin_code_seq
178: , organization_name = p_organization_name
179: , customer_name = p_customer_name
180: , request_id = oki_load_rbk_pvt.g_request_id
181: , program_application_id = oki_load_rbk_pvt.g_program_application_id
182: , program_id = oki_load_rbk_pvt.g_program_id
183: , program_update_date = oki_load_rbk_pvt.g_program_update_date
184: WHERE ROWID = p_rbk_rowid ;
185:

Line 182: , program_id = oki_load_rbk_pvt.g_program_id

178: , organization_name = p_organization_name
179: , customer_name = p_customer_name
180: , request_id = oki_load_rbk_pvt.g_request_id
181: , program_application_id = oki_load_rbk_pvt.g_program_application_id
182: , program_id = oki_load_rbk_pvt.g_program_id
183: , program_update_date = oki_load_rbk_pvt.g_program_update_date
184: WHERE ROWID = p_rbk_rowid ;
185:
186: EXCEPTION

Line 183: , program_update_date = oki_load_rbk_pvt.g_program_update_date

179: , customer_name = p_customer_name
180: , request_id = oki_load_rbk_pvt.g_request_id
181: , program_application_id = oki_load_rbk_pvt.g_program_application_id
182: , program_id = oki_load_rbk_pvt.g_program_id
183: , program_update_date = oki_load_rbk_pvt.g_program_update_date
184: WHERE ROWID = p_rbk_rowid ;
185:
186: EXCEPTION
187: WHEN OTHERS THEN

Line 198: , value => 'OKI_LOAD_RBK_PVT.UPD_RNWL_BKNG' ) ;

194: fnd_message.set_name( application => 'OKI'
195: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
196:
197: fnd_message.set_token( token => 'OBJECT_NAME'
198: , value => 'OKI_LOAD_RBK_PVT.UPD_RNWL_BKNG' ) ;
199:
200: fnd_file.put_line( which => fnd_file.log
201: , buff => fnd_message.get );
202:

Line 394: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 395: , oki_load_rbk_pvt.g_b_act_k_code ) ;

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

Line 431: OPEN oki_load_rbk_pvt.g_rbk_csr (

427: CLOSE oki_utl_pvt.g_tactk_by_org_csr ;
428:
429: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
430: -- Determine if the record is a new one or an existing one
431: OPEN oki_load_rbk_pvt.g_rbk_csr (
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

Line 436: , oki_load_rbk_pvt.g_b_act_k_code ) ;

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 || '.' ;
440: -- Insert the new record

Line 437: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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 || '.' ;
440: -- Insert the new record
441: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 438: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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 || '.' ;
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

Line 441: oki_load_rbk_pvt.ins_rnwl_bkng (

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 || '.' ;
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

Line 448: , p_measure_code => oki_load_rbk_pvt.g_b_act_k_code

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
452: , p_prev_base_contract_amount => l_prev_b_act_k

Line 461: oki_load_rbk_pvt.upd_rnwl_bkng (

457: END IF ;
458: ELSE
459: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
460: -- Update the existing record
461: oki_load_rbk_pvt.upd_rnwl_bkng (
462: p_curr_base_contract_amount => l_curr_b_act_k
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

Line 476: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
478: --
479: -- Process Expiring During Quarter record
480: --

Line 487: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 488: , oki_load_rbk_pvt.g_exp_in_qtr_code ) ;

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

Line 528: OPEN oki_load_rbk_pvt.g_rbk_csr (

524: CLOSE oki_utl_pvt.g_k_exp_in_qtr_by_org_csr ;
525:
526: l_loc := 'Inserting / updating ' || l_measure_type || '.' ;
527: -- Determine if the record is a new one or an existing one
528: OPEN oki_load_rbk_pvt.g_rbk_csr (
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

Line 533: , oki_load_rbk_pvt.g_exp_in_qtr_code ) ;

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 || '.' ;
537: -- Insert the new record

Line 534: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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 || '.' ;
537: -- Insert the new record
538: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 535: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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 || '.' ;
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

Line 538: oki_load_rbk_pvt.ins_rnwl_bkng (

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 || '.' ;
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

Line 545: , p_measure_code => oki_load_rbk_pvt.g_exp_in_qtr_code

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
549: , p_prev_base_contract_amount => l_prev_k_exp_in_qtr

Line 558: oki_load_rbk_pvt.upd_rnwl_bkng (

554: END IF ;
555: ELSE
556: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
557: -- Update the existing record
558: oki_load_rbk_pvt.upd_rnwl_bkng (
559: p_curr_base_contract_amount => l_curr_k_exp_in_qtr
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

Line 573: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
575: --
576: -- Process Backlog Renewals record
577: --

Line 584: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 585: , oki_load_rbk_pvt.g_bklg_k_to_rnw_code ) ;

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

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 622: , oki_load_rbk_pvt.g_bklg_k_to_rnw_code ) ;

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 || '.' ;
626: -- Insert the new record

Line 623: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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 || '.' ;
626: -- Insert the new record
627: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 624: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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 || '.' ;
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

Line 627: oki_load_rbk_pvt.ins_rnwl_bkng (

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 || '.' ;
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

Line 634: , p_measure_code => oki_load_rbk_pvt.g_bklg_k_to_rnw_code

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
638: , p_prev_base_contract_amount => l_prev_bklg_k_to_rnw

Line 647: oki_load_rbk_pvt.upd_rnwl_bkng (

643: END IF ;
644: ELSE
645: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
646: -- Update the existing record
647: oki_load_rbk_pvt.upd_rnwl_bkng (
648: p_curr_base_contract_amount => l_curr_bklg_k_to_rnw
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

Line 662: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
664: --
665: -- Process Beginning Renewal Opportunity record
666: --

Line 673: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 674: , oki_load_rbk_pvt.g_b_rnwl_oppty_code ) ;

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

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 692: , oki_load_rbk_pvt.g_b_rnwl_oppty_code ) ;

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 || '.' ;
696: -- Insert the new record

Line 693: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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 || '.' ;
696: -- Insert the new record
697: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 694: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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 || '.' ;
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

Line 697: oki_load_rbk_pvt.ins_rnwl_bkng (

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 || '.' ;
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

Line 704: , p_measure_code => oki_load_rbk_pvt.g_b_rnwl_oppty_code

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
708: , p_prev_base_contract_amount => l_prev_b_rnwl_oppty

Line 717: oki_load_rbk_pvt.upd_rnwl_bkng (

713: END IF ;
714: ELSE
715: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
716: -- Update the existing record
717: oki_load_rbk_pvt.upd_rnwl_bkng (
718: p_curr_base_contract_amount => l_curr_b_rnwl_oppty
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

Line 732: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
734: --
735: -- Process Backlog Contracts Renewed record
736: --

Line 743: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 744: , oki_load_rbk_pvt.g_bklg_k_rnwed_code ) ;

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

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 783: , oki_load_rbk_pvt.g_bklg_k_rnwed_code ) ;

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 || '.' ;
787: -- Insert the new record

Line 784: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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 || '.' ;
787: -- Insert the new record
788: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 785: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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 || '.' ;
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

Line 788: oki_load_rbk_pvt.ins_rnwl_bkng (

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 || '.' ;
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

Line 795: , p_measure_code => oki_load_rbk_pvt.g_bklg_k_rnwed_code

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
799: , p_prev_base_contract_amount => l_prev_bklg_k_rwned

Line 808: oki_load_rbk_pvt.upd_rnwl_bkng (

804: END IF ;
805: ELSE
806: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
807: -- Update the existing record
808: oki_load_rbk_pvt.upd_rnwl_bkng (
809: p_curr_base_contract_amount => l_curr_bklg_k_rwned
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

Line 823: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
825: --
826: -- Process Contracts Renewed record
827: --

Line 834: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 835: , oki_load_rbk_pvt.g_k_rnwed_code ) ;

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

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 874: , oki_load_rbk_pvt.g_k_rnwed_code ) ;

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 || '.' ;
878: -- Insert the new record

Line 875: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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 || '.' ;
878: -- Insert the new record
879: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 876: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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 || '.' ;
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

Line 879: oki_load_rbk_pvt.ins_rnwl_bkng (

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 || '.' ;
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

Line 886: , p_measure_code => oki_load_rbk_pvt.g_k_rnwed_code

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
890: , p_prev_base_contract_amount => l_prev_k_rnwed

Line 899: oki_load_rbk_pvt.upd_rnwl_bkng (

895: END IF ;
896: ELSE
897: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
898: -- Update the existing record
899: oki_load_rbk_pvt.upd_rnwl_bkng (
900: p_curr_base_contract_amount => l_curr_k_rnwed
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

Line 914: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
916: --
917: -- Process New Business record
918: --

Line 925: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 926: , oki_load_rbk_pvt.g_new_bsn_code ) ;

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

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 965: , oki_load_rbk_pvt.g_new_bsn_code ) ;

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 || '.' ;
969: -- Insert the new record

Line 966: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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 || '.' ;
969: -- Insert the new record
970: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 967: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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 || '.' ;
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

Line 970: oki_load_rbk_pvt.ins_rnwl_bkng (

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 || '.' ;
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

Line 977: , p_measure_code => oki_load_rbk_pvt.g_new_bsn_code

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
981: , p_prev_base_contract_amount => l_prev_new_bus

Line 990: oki_load_rbk_pvt.upd_rnwl_bkng (

986: END IF ;
987: ELSE
988: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
989: -- Update the existing record
990: oki_load_rbk_pvt.upd_rnwl_bkng (
991: p_curr_base_contract_amount => l_curr_new_bus
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

Line 1005: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
1007: --
1008: -- Process Terminated Contracts record
1009: --

Line 1016: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 1017: , oki_load_rbk_pvt.g_trmn_k_code ) ;

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

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 1056: , oki_load_rbk_pvt.g_trmn_k_code ) ;

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 || '.' ;
1060: -- Insert the new record

Line 1057: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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 || '.' ;
1060: -- Insert the new record
1061: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 1058: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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 || '.' ;
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

Line 1061: oki_load_rbk_pvt.ins_rnwl_bkng (

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 || '.' ;
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

Line 1068: , p_measure_code => oki_load_rbk_pvt.g_trmn_k_code

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
1072: , p_prev_base_contract_amount => l_prev_trmn_k

Line 1081: oki_load_rbk_pvt.upd_rnwl_bkng (

1077: END IF ;
1078: ELSE
1079: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1080: -- Update the existing record
1081: oki_load_rbk_pvt.upd_rnwl_bkng (
1082: p_curr_base_contract_amount => l_curr_trmn_k
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

Line 1096: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
1098: --
1099: -- Process Ending Active Contracts record
1100: --

Line 1107: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 1108: , oki_load_rbk_pvt.g_e_act_k_code ) ;

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

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 1135: , oki_load_rbk_pvt.g_e_act_k_code ) ;

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 || '.' ;
1139: -- Insert the new record

Line 1136: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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 || '.' ;
1139: -- Insert the new record
1140: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 1137: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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 || '.' ;
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

Line 1140: oki_load_rbk_pvt.ins_rnwl_bkng (

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 || '.' ;
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

Line 1147: , p_measure_code => oki_load_rbk_pvt.g_e_act_k_code

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
1151: , p_prev_base_contract_amount => l_prev_e_act_k

Line 1160: oki_load_rbk_pvt.upd_rnwl_bkng (

1156: END IF ;
1157: ELSE
1158: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1159: -- Update the existing record
1160: oki_load_rbk_pvt.upd_rnwl_bkng (
1161: p_curr_base_contract_amount => l_curr_e_act_k
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

Line 1175: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
1177: END LOOP g_org_csr_loop ;
1178:
1179: EXCEPTION

Line 1216: , value => 'OKI_LOAD_RBK_PVT.CALC_RBK_DLTL1');

1212: fnd_message.set_name( application => 'OKI'
1213: , name => 'OKI_UNEXPECTED_FAILURE');
1214:
1215: fnd_message.set_token( token => 'OBJECT_NAME'
1216: , value => 'OKI_LOAD_RBK_PVT.CALC_RBK_DLTL1');
1217:
1218: fnd_file.put_line( which => fnd_file.log
1219: , buff => fnd_message.get);
1220:

Line 1406: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 1407: , oki_load_rbk_pvt.g_b_act_k_code ) ;

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

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 1441: , oki_load_rbk_pvt.g_b_act_k_code ) ;

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 || '.' ;
1445: -- Insert the new record

Line 1442: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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 || '.' ;
1445: -- Insert the new record
1446: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 1443: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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 || '.' ;
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

Line 1446: oki_load_rbk_pvt.ins_rnwl_bkng (

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 || '.' ;
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

Line 1453: , p_measure_code => oki_load_rbk_pvt.g_b_act_k_code

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
1457: , p_prev_base_contract_amount => l_prev_b_act_k

Line 1466: oki_load_rbk_pvt.upd_rnwl_bkng (

1462: END IF ;
1463: ELSE
1464: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1465: -- Update the existing record
1466: oki_load_rbk_pvt.upd_rnwl_bkng (
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

Line 1481: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
1483: --
1484: -- Process Expiring During Quarter record
1485: --

Line 1492: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 1493: , oki_load_rbk_pvt.g_exp_in_qtr_code ) ;

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

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 1530: , oki_load_rbk_pvt.g_exp_in_qtr_code ) ;

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 || '.' ;
1534: -- Insert the new record

Line 1531: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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 || '.' ;
1534: -- Insert the new record
1535: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 1532: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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 || '.' ;
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

Line 1535: oki_load_rbk_pvt.ins_rnwl_bkng (

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 || '.' ;
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

Line 1542: , p_measure_code => oki_load_rbk_pvt.g_exp_in_qtr_code

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
1546: , p_prev_base_contract_amount => l_prev_k_exp_in_qtr

Line 1555: oki_load_rbk_pvt.upd_rnwl_bkng (

1551: END IF ;
1552: ELSE
1553: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1554: -- Update the existing record
1555: oki_load_rbk_pvt.upd_rnwl_bkng (
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

Line 1570: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
1572: --
1573: -- Process Backlog Renewals record
1574: --

Line 1581: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 1582: , oki_load_rbk_pvt.g_bklg_k_to_rnw_code ) ;

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

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 1615: , oki_load_rbk_pvt.g_bklg_k_to_rnw_code ) ;

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 || '.' ;
1619: -- Insert the new record

Line 1616: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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 || '.' ;
1619: -- Insert the new record
1620: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 1617: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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 || '.' ;
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

Line 1620: oki_load_rbk_pvt.ins_rnwl_bkng (

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 || '.' ;
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

Line 1627: , p_measure_code => oki_load_rbk_pvt.g_bklg_k_to_rnw_code

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
1631: , p_prev_base_contract_amount => l_prev_bklg_k_to_rnw

Line 1640: oki_load_rbk_pvt.upd_rnwl_bkng (

1636: END IF ;
1637: ELSE
1638: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1639: -- Update the existing record
1640: oki_load_rbk_pvt.upd_rnwl_bkng (
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

Line 1655: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
1657: --
1658: -- Process Beginning Renewal Opportunity record
1659: --

Line 1666: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 1667: , oki_load_rbk_pvt.g_b_rnwl_oppty_code ) ;

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

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 1685: , oki_load_rbk_pvt.g_b_rnwl_oppty_code ) ;

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 || '.' ;
1689: -- Insert the new record

Line 1686: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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 || '.' ;
1689: -- Insert the new record
1690: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 1687: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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 || '.' ;
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

Line 1690: oki_load_rbk_pvt.ins_rnwl_bkng (

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 || '.' ;
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

Line 1697: , p_measure_code => oki_load_rbk_pvt.g_b_rnwl_oppty_code

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
1701: , p_prev_base_contract_amount => l_prev_b_rnwl_oppty

Line 1711: oki_load_rbk_pvt.upd_rnwl_bkng (

1707: END IF ;
1708: ELSE
1709: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1710: -- Update the existing record
1711: oki_load_rbk_pvt.upd_rnwl_bkng (
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

Line 1726: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
1728: --
1729: -- Process Quarter Activity record
1730: --

Line 1735: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 1736: , oki_load_rbk_pvt.g_qtr_actvty_code ) ;

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

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 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 1751: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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
1755: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 1752: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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
1755: oki_load_rbk_pvt.ins_rnwl_bkng (
1756: p_summary_build_date => oki_utl_pub.g_summary_build_date

Line 1755: oki_load_rbk_pvt.ins_rnwl_bkng (

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
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

Line 1762: , p_measure_code => oki_load_rbk_pvt.g_qtr_actvty_code

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
1766: , p_prev_base_contract_amount => NULL

Line 1775: oki_load_rbk_pvt.upd_rnwl_bkng (

1771: END IF ;
1772: ELSE
1773: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1774: -- Update the existing record
1775: oki_load_rbk_pvt.upd_rnwl_bkng (
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

Line 1790: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
1792: --
1793: -- Process Backlog Contracts Renewed record
1794: --

Line 1801: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 1802: , oki_load_rbk_pvt.g_bklg_k_rnwed_code ) ;

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

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 1836: , oki_load_rbk_pvt.g_bklg_k_rnwed_code ) ;

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 || '.' ;
1840: -- Insert the new record

Line 1837: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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 || '.' ;
1840: -- Insert the new record
1841: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 1838: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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 || '.' ;
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

Line 1841: oki_load_rbk_pvt.ins_rnwl_bkng (

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 || '.' ;
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

Line 1848: , p_measure_code => oki_load_rbk_pvt.g_bklg_k_rnwed_code

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
1852: , p_prev_base_contract_amount => l_prev_bklg_k_rwned

Line 1861: oki_load_rbk_pvt.upd_rnwl_bkng (

1857: END IF ;
1858: ELSE
1859: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1860: -- Update the existing record
1861: oki_load_rbk_pvt.upd_rnwl_bkng (
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

Line 1876: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
1878: --
1879: -- Process Contracts Renewed record
1880: --

Line 1887: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 1888: , oki_load_rbk_pvt.g_k_rnwed_code ) ;

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

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 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 1923: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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
1927: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 1924: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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
1927: oki_load_rbk_pvt.ins_rnwl_bkng (
1928: p_summary_build_date => oki_utl_pub.g_summary_build_date

Line 1927: oki_load_rbk_pvt.ins_rnwl_bkng (

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
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

Line 1934: , p_measure_code => oki_load_rbk_pvt.g_k_rnwed_code

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
1938: , p_prev_base_contract_amount => l_prev_k_rnwed

Line 1947: oki_load_rbk_pvt.upd_rnwl_bkng (

1943: END IF ;
1944: ELSE
1945: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
1946: -- Update the existing record
1947: oki_load_rbk_pvt.upd_rnwl_bkng (
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

Line 1962: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
1964: --
1965: -- Process New Business record
1966: --

Line 1973: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 1974: , oki_load_rbk_pvt.g_new_bsn_code ) ;

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

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 2009: , oki_load_rbk_pvt.g_new_bsn_code ) ;

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 || '.' ;
2013: -- Insert the new record

Line 2010: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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 || '.' ;
2013: -- Insert the new record
2014: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 2011: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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 || '.' ;
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

Line 2014: oki_load_rbk_pvt.ins_rnwl_bkng (

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 || '.' ;
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

Line 2021: , p_measure_code => oki_load_rbk_pvt.g_new_bsn_code

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
2025: , p_prev_base_contract_amount => l_prev_new_bus

Line 2034: oki_load_rbk_pvt.upd_rnwl_bkng (

2030: END IF ;
2031: ELSE
2032: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
2033: -- Update the existing record
2034: oki_load_rbk_pvt.upd_rnwl_bkng (
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

Line 2049: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
2051: --
2052: -- Process Terminated Contracts record
2053: --

Line 2060: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 2061: , oki_load_rbk_pvt.g_trmn_k_code ) ;

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

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 2096: , oki_load_rbk_pvt.g_trmn_k_code ) ;

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 || '.' ;
2100: -- Insert the new record

Line 2097: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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 || '.' ;
2100: -- Insert the new record
2101: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 2098: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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 || '.' ;
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

Line 2101: oki_load_rbk_pvt.ins_rnwl_bkng (

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 || '.' ;
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

Line 2108: , p_measure_code => oki_load_rbk_pvt.g_trmn_k_code

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
2112: , p_prev_base_contract_amount => l_prev_trmn_k

Line 2121: oki_load_rbk_pvt.upd_rnwl_bkng (

2117: END IF ;
2118: ELSE
2119: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
2120: -- Update the existing record
2121: oki_load_rbk_pvt.upd_rnwl_bkng (
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

Line 2136: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
2138: --
2139: -- Process Ending Active Contracts record
2140: --

Line 2145: OPEN oki_utl_pvt.g_bin_disp_lkup_csr ( oki_load_rbk_pvt.g_bin_id

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

Line 2146: , oki_load_rbk_pvt.g_e_act_k_code ) ;

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

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 2173: , oki_load_rbk_pvt.g_e_act_k_code ) ;

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 || '.' ;
2177: -- Insert the new record

Line 2174: FETCH oki_load_rbk_pvt.g_rbk_csr INTO rec_g_rbk_csr ;

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 || '.' ;
2177: -- Insert the new record
2178: oki_load_rbk_pvt.ins_rnwl_bkng (

Line 2175: IF oki_load_rbk_pvt.g_rbk_csr%NOTFOUND THEN

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 || '.' ;
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

Line 2178: oki_load_rbk_pvt.ins_rnwl_bkng (

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 || '.' ;
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

Line 2185: , p_measure_code => oki_load_rbk_pvt.g_e_act_k_code

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
2189: , p_prev_base_contract_amount => l_prev_e_act_k

Line 2198: oki_load_rbk_pvt.upd_rnwl_bkng (

2194: END IF ;
2195: ELSE
2196: l_loc := 'Update the record -- ' || l_measure_type || '.' ;
2197: -- Update the existing record
2198: oki_load_rbk_pvt.upd_rnwl_bkng (
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

Line 2213: CLOSE oki_load_rbk_pvt.g_rbk_csr ;

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:
2215: EXCEPTION
2216: WHEN oki_utl_pub.g_excp_exit_immediate THEN
2217: -- Do not log an error ; It has already been logged.

Line 2253: , value => 'OKI_LOAD_RBK_PVT.CALC_RBK_SUM');

2249: fnd_message.set_name( application => 'OKI'
2250: , name => 'OKI_UNEXPECTED_FAILURE');
2251:
2252: fnd_message.set_token( token => 'OBJECT_NAME'
2253: , value => 'OKI_LOAD_RBK_PVT.CALC_RBK_SUM');
2254:
2255: fnd_file.put_line( which => fnd_file.log
2256: , buff => fnd_message.get);
2257:

Line 2338: oki_load_rbk_pvt.calc_rbk_sum (

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 (
2339: x_retcode => l_retcode ) ;
2340:
2341: IF l_retcode = '2' THEN
2342: -- Load failed, exit immediately.

Line 2347: oki_load_rbk_pvt.calc_rbk_dtl1 (

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 (
2348: x_retcode => l_retcode ) ;
2349:
2350: IF l_retcode = '2' THEN
2351: -- Load failed, exit immediately.

Line 2415: , value => 'OKI_LOAD_RBK_PVT.CRT_RNWL_BKNG' ) ;

2411: fnd_message.set_name( application => 'OKI'
2412: , name => 'OKI_UNEXPECTED_FAILURE' ) ;
2413:
2414: fnd_message.set_token( token => 'OBJECT_NAME'
2415: , value => 'OKI_LOAD_RBK_PVT.CRT_RNWL_BKNG' ) ;
2416:
2417: fnd_file.put_line( which => fnd_file.log
2418: , buff => fnd_message.get ) ;
2419:

Line 2432: END oki_load_rbk_pvt ;

2428: g_program_application_id := fnd_global.prog_appl_id ;
2429: g_program_id := fnd_global.conc_program_id ;
2430: g_program_update_date := SYSDATE ;
2431:
2432: END oki_load_rbk_pvt ;