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.OKL_ACCOUNT_DIST_PVT dependencies on OKL_SLA_ACC_SOURCES_PVT

Line 2476: l_tcnv_rec okl_sla_acc_sources_pvt.tehv_rec_type;

2472: l_tabv_tbl tabv_tbl_type ;
2473: l_tabv_tbl_out tabv_tbl_type ;
2474: x_tabv_tbl tabv_tbl_type ;
2475: l_try_name OKL_TRX_TYPES_TL.NAME%TYPE;
2476: l_tcnv_rec okl_sla_acc_sources_pvt.tehv_rec_type;
2477: l_tclv_rec okl_sla_acc_sources_pvt.telv_rec_type;
2478: l_tclv_tbl okl_sla_acc_sources_pvt.telv_tbl_type;
2479: l_tabv_tbl_final tabv_tbl_type;
2480: k NUMBER := 0;

Line 2477: l_tclv_rec okl_sla_acc_sources_pvt.telv_rec_type;

2473: l_tabv_tbl_out tabv_tbl_type ;
2474: x_tabv_tbl tabv_tbl_type ;
2475: l_try_name OKL_TRX_TYPES_TL.NAME%TYPE;
2476: l_tcnv_rec okl_sla_acc_sources_pvt.tehv_rec_type;
2477: l_tclv_rec okl_sla_acc_sources_pvt.telv_rec_type;
2478: l_tclv_tbl okl_sla_acc_sources_pvt.telv_tbl_type;
2479: l_tabv_tbl_final tabv_tbl_type;
2480: k NUMBER := 0;
2481: l_tehv_id NUMBER;

Line 2478: l_tclv_tbl okl_sla_acc_sources_pvt.telv_tbl_type;

2474: x_tabv_tbl tabv_tbl_type ;
2475: l_try_name OKL_TRX_TYPES_TL.NAME%TYPE;
2476: l_tcnv_rec okl_sla_acc_sources_pvt.tehv_rec_type;
2477: l_tclv_rec okl_sla_acc_sources_pvt.telv_rec_type;
2478: l_tclv_tbl okl_sla_acc_sources_pvt.telv_tbl_type;
2479: l_tabv_tbl_final tabv_tbl_type;
2480: k NUMBER := 0;
2481: l_tehv_id NUMBER;
2482: l_asev_rec asev_rec_type;

Line 2484: l_rxhv_rec okl_sla_acc_sources_pvt.rxhv_rec_type;

2480: k NUMBER := 0;
2481: l_tehv_id NUMBER;
2482: l_asev_rec asev_rec_type;
2483: l_line_amount NUMBER := 0;
2484: l_rxhv_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
2485: l_rxhv_adj_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
2486: l_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2487: l_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2488: x_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;

Line 2485: l_rxhv_adj_rec okl_sla_acc_sources_pvt.rxhv_rec_type;

2481: l_tehv_id NUMBER;
2482: l_asev_rec asev_rec_type;
2483: l_line_amount NUMBER := 0;
2484: l_rxhv_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
2485: l_rxhv_adj_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
2486: l_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2487: l_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2488: x_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2489: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;

Line 2486: l_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;

2482: l_asev_rec asev_rec_type;
2483: l_line_amount NUMBER := 0;
2484: l_rxhv_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
2485: l_rxhv_adj_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
2486: l_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2487: l_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2488: x_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2489: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2490: l_rxlv_rec okl_sla_acc_sources_pvt.rxlv_rec_type;

Line 2487: l_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;

2483: l_line_amount NUMBER := 0;
2484: l_rxhv_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
2485: l_rxhv_adj_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
2486: l_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2487: l_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2488: x_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2489: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2490: l_rxlv_rec okl_sla_acc_sources_pvt.rxlv_rec_type;
2491: l_rxlv_adj_rec okl_sla_acc_sources_pvt.rxlv_rec_type;

Line 2488: x_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;

2484: l_rxhv_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
2485: l_rxhv_adj_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
2486: l_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2487: l_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2488: x_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2489: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2490: l_rxlv_rec okl_sla_acc_sources_pvt.rxlv_rec_type;
2491: l_rxlv_adj_rec okl_sla_acc_sources_pvt.rxlv_rec_type;
2492:

Line 2489: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;

2485: l_rxhv_adj_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
2486: l_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2487: l_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2488: x_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2489: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2490: l_rxlv_rec okl_sla_acc_sources_pvt.rxlv_rec_type;
2491: l_rxlv_adj_rec okl_sla_acc_sources_pvt.rxlv_rec_type;
2492:
2493: l_pxhv_rec okl_sla_acc_sources_pvt.pxhv_rec_type;

Line 2490: l_rxlv_rec okl_sla_acc_sources_pvt.rxlv_rec_type;

2486: l_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2487: l_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2488: x_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2489: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2490: l_rxlv_rec okl_sla_acc_sources_pvt.rxlv_rec_type;
2491: l_rxlv_adj_rec okl_sla_acc_sources_pvt.rxlv_rec_type;
2492:
2493: l_pxhv_rec okl_sla_acc_sources_pvt.pxhv_rec_type;
2494: l_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;

Line 2491: l_rxlv_adj_rec okl_sla_acc_sources_pvt.rxlv_rec_type;

2487: l_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2488: x_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2489: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2490: l_rxlv_rec okl_sla_acc_sources_pvt.rxlv_rec_type;
2491: l_rxlv_adj_rec okl_sla_acc_sources_pvt.rxlv_rec_type;
2492:
2493: l_pxhv_rec okl_sla_acc_sources_pvt.pxhv_rec_type;
2494: l_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
2495: x_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;

Line 2493: l_pxhv_rec okl_sla_acc_sources_pvt.pxhv_rec_type;

2489: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
2490: l_rxlv_rec okl_sla_acc_sources_pvt.rxlv_rec_type;
2491: l_rxlv_adj_rec okl_sla_acc_sources_pvt.rxlv_rec_type;
2492:
2493: l_pxhv_rec okl_sla_acc_sources_pvt.pxhv_rec_type;
2494: l_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
2495: x_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
2496: l_pxlv_rec okl_sla_acc_sources_pvt.pxlv_rec_type;
2497:

Line 2494: l_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;

2490: l_rxlv_rec okl_sla_acc_sources_pvt.rxlv_rec_type;
2491: l_rxlv_adj_rec okl_sla_acc_sources_pvt.rxlv_rec_type;
2492:
2493: l_pxhv_rec okl_sla_acc_sources_pvt.pxhv_rec_type;
2494: l_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
2495: x_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
2496: l_pxlv_rec okl_sla_acc_sources_pvt.pxlv_rec_type;
2497:
2498: l_tai_id NUMBER;

Line 2495: x_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;

2491: l_rxlv_adj_rec okl_sla_acc_sources_pvt.rxlv_rec_type;
2492:
2493: l_pxhv_rec okl_sla_acc_sources_pvt.pxhv_rec_type;
2494: l_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
2495: x_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
2496: l_pxlv_rec okl_sla_acc_sources_pvt.pxlv_rec_type;
2497:
2498: l_tai_id NUMBER;
2499: l_adj_id NUMBER;

Line 2496: l_pxlv_rec okl_sla_acc_sources_pvt.pxlv_rec_type;

2492:
2493: l_pxhv_rec okl_sla_acc_sources_pvt.pxhv_rec_type;
2494: l_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
2495: x_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
2496: l_pxlv_rec okl_sla_acc_sources_pvt.pxlv_rec_type;
2497:
2498: l_tai_id NUMBER;
2499: l_adj_id NUMBER;
2500: l_tap_id NUMBER;

Line 2792: okl_sla_acc_sources_pvt.delete_trx_extension(

2788: l_tcnv_rec.source_id := l_tcn_id;
2789: l_tcnv_rec.source_table := 'OKL_TRX_CONTRACTS';
2790:
2791: --Existing sources are being deleted.
2792: okl_sla_acc_sources_pvt.delete_trx_extension(
2793: p_api_version => l_api_version
2794: ,p_init_msg_list => l_init_msg_list
2795: ,p_trans_hdr_rec => l_tcnv_rec
2796: ,x_trans_line_tbl => l_tclv_tbl

Line 2825: okl_sla_acc_sources_pvt.delete_ar_extension(

2821: l_rxhv_rec.source_id := l_tai_id;
2822: l_rxhv_rec.source_table := 'OKL_TRX_AR_INVOICES_B';
2823:
2824: --Existing sources are being deleted.
2825: okl_sla_acc_sources_pvt.delete_ar_extension(
2826: p_api_version => l_api_version
2827: ,p_init_msg_list => l_init_msg_list
2828: ,p_rxhv_rec => l_rxhv_rec
2829: ,x_rxlv_tbl => x_rxlv_tbl

Line 2857: okl_sla_acc_sources_pvt.delete_ar_extension(

2853: l_rxhv_adj_rec.source_id := l_adj_id;
2854: l_rxhv_adj_rec.source_table := 'OKL_TRX_AR_ADJSTS_B' ;
2855:
2856: --Existing sources are being deleted.
2857: okl_sla_acc_sources_pvt.delete_ar_extension(
2858: p_api_version => l_api_version
2859: ,p_init_msg_list => l_init_msg_list
2860: ,p_rxhv_rec => l_rxhv_adj_rec
2861: ,x_rxlv_tbl => x_rxlv_adj_tbl

Line 2890: okl_sla_acc_sources_pvt.delete_ap_extension(

2886: l_pxhv_rec.source_id := l_tap_id;
2887: l_pxhv_rec.source_table := 'OKL_TRX_AP_INVOICES_B';
2888:
2889: --Existing sources are being deleted.
2890: okl_sla_acc_sources_pvt.delete_ap_extension(
2891: p_api_version => l_api_version
2892: ,p_init_msg_list => l_init_msg_list
2893: ,p_pxhv_rec => l_pxhv_rec
2894: ,x_pxlv_tbl => x_pxlv_tbl

Line 3098: okl_sla_acc_sources_pvt.delete_trx_extension(

3094: l_tcnv_rec.source_id := l_tcn_id;
3095: l_tcnv_rec.source_table := 'OKL_TRX_CONTRACTS';
3096:
3097: --Existing sources are being deleted.
3098: okl_sla_acc_sources_pvt.delete_trx_extension(
3099: p_api_version => l_api_version
3100: ,p_init_msg_list => l_init_msg_list
3101: ,p_trans_hdr_rec => l_tcnv_rec
3102: ,x_trans_line_tbl => l_tclv_tbl

Line 3131: okl_sla_acc_sources_pvt.delete_ar_extension(

3127: l_rxhv_rec.source_id := l_tai_id;
3128: l_rxhv_rec.source_table := 'OKL_TRX_AR_INVOICES_B';
3129:
3130: --Existing sources are being deleted.
3131: okl_sla_acc_sources_pvt.delete_ar_extension(
3132: p_api_version => l_api_version
3133: ,p_init_msg_list => l_init_msg_list
3134: ,p_rxhv_rec => l_rxhv_rec
3135: ,x_rxlv_tbl => x_rxlv_tbl

Line 3164: okl_sla_acc_sources_pvt.delete_ar_extension(

3160: l_rxhv_adj_rec.source_id := l_adj_id;
3161: l_rxhv_adj_rec.source_table := 'OKL_TRX_AR_ADJSTS_B';
3162:
3163: --Existing sources are being deleted.
3164: okl_sla_acc_sources_pvt.delete_ar_extension(
3165: p_api_version => l_api_version
3166: ,p_init_msg_list => l_init_msg_list
3167: ,p_rxhv_rec => l_rxhv_adj_rec
3168: ,x_rxlv_tbl => x_rxlv_adj_tbl

Line 3197: okl_sla_acc_sources_pvt.delete_ap_extension(

3193: l_pxhv_rec.source_id := l_tap_id;
3194: l_pxhv_rec.source_table := 'OKL_TRX_AP_INVOICES_B';
3195:
3196: --Existing sources are being deleted.
3197: okl_sla_acc_sources_pvt.delete_ap_extension(
3198: p_api_version => l_api_version
3199: ,p_init_msg_list => l_init_msg_list
3200: ,p_pxhv_rec => l_pxhv_rec
3201: ,x_pxlv_tbl => x_pxlv_tbl

Line 3357: OKL_SLA_ACC_SOURCES_PVT.populate_tcn_sources(p_api_version => l_api_version

3353: l_tcnv_rec.source_id := l_tcn_id;
3354: l_tcnv_rec.source_table := 'OKL_TRX_CONTRACTS';
3355:
3356: --Make the call to capture account header source
3357: OKL_SLA_ACC_SOURCES_PVT.populate_tcn_sources(p_api_version => l_api_version
3358: ,p_init_msg_list => l_init_msg_list
3359: ,px_trans_hdr_rec => l_tcnv_rec
3360: ,p_acc_sources_rec => l_asev_rec
3361: ,x_return_status => l_return_status

Line 3417: OKL_SLA_ACC_SOURCES_PVT.populate_tcn_sources(p_api_version => l_api_version

3413: l_tcnv_rec.source_id := l_tcn_id;
3414: l_tcnv_rec.source_table := 'OKL_TRX_CONTRACTS';
3415:
3416: --Make the call to capture account header source
3417: OKL_SLA_ACC_SOURCES_PVT.populate_tcn_sources(p_api_version => l_api_version
3418: ,p_init_msg_list => l_init_msg_list
3419: ,px_trans_hdr_rec => l_tcnv_rec
3420: ,p_acc_sources_rec => l_asev_rec
3421: ,x_return_status => l_return_status

Line 3445: OKL_SLA_ACC_SOURCES_PVT.populate_tcl_sources(p_api_version => l_api_version

3441: l_tclv_rec.source_table := l_tclv_tbl(i).source_table;
3442: l_tclv_rec.teh_id := l_tcnv_rec.header_extension_id;
3443:
3444: --Make the call to capture account header source
3445: OKL_SLA_ACC_SOURCES_PVT.populate_tcl_sources(p_api_version => l_api_version
3446: ,p_init_msg_list => l_init_msg_list
3447: ,px_trans_line_rec => l_tclv_rec
3448: ,p_acc_sources_rec => l_asev_rec
3449: ,x_return_status => l_return_status

Line 3477: OKL_SLA_ACC_SOURCES_PVT.populate_tcl_sources(p_api_version => l_api_version

3473: l_tclv_rec.source_table := 'OKL_TXL_CNTRCT_LNS';
3474: l_tclv_rec.teh_id := l_tehv_id;
3475:
3476: --Make the call to capture account header source
3477: OKL_SLA_ACC_SOURCES_PVT.populate_tcl_sources(p_api_version => l_api_version
3478: ,p_init_msg_list => l_init_msg_list
3479: ,px_trans_line_rec => l_tclv_rec
3480: ,p_acc_sources_rec => l_asev_rec
3481: ,x_return_status => l_return_status

Line 3565: OKL_SLA_ACC_SOURCES_PVT.populate_ar_sources(p_api_version => l_api_version

3561: l_rxlv_rec.sty_id := get_tai_details_rec.sty_id;
3562: l_rxlv_rec.trans_line_description := get_tai_details_rec.trans_line_description;
3563:
3564: --Make the call to capture account header source
3565: OKL_SLA_ACC_SOURCES_PVT.populate_ar_sources(p_api_version => l_api_version
3566: ,p_init_msg_list => l_init_msg_list
3567: ,p_rxhv_rec => l_rxhv_rec
3568: ,p_rxlv_rec => l_rxlv_rec
3569: ,p_acc_sources_rec => l_asev_rec

Line 3596: OKL_SLA_ACC_SOURCES_PVT.populate_ar_sources(p_api_version => l_api_version

3592: l_rxlv_rec.sty_id := get_tai_details_rec.sty_id;
3593: l_rxlv_rec.trans_line_description := get_tai_details_rec.trans_line_description;
3594:
3595: --Make the call to capture account header source
3596: OKL_SLA_ACC_SOURCES_PVT.populate_ar_sources(p_api_version => l_api_version
3597: ,p_init_msg_list => l_init_msg_list
3598: ,p_rxhv_rec => l_rxhv_rec
3599: ,p_rxlv_rec => l_rxlv_rec
3600: ,p_acc_sources_rec => l_asev_rec

Line 3682: OKL_SLA_ACC_SOURCES_PVT.populate_ar_sources(p_api_version => l_api_version

3678: l_rxlv_adj_rec.kle_id := get_adj_details_rec.kle_id;
3679: l_rxlv_adj_rec.sty_id := get_adj_details_rec.sty_id;
3680:
3681: --Make the call to capture account header source
3682: OKL_SLA_ACC_SOURCES_PVT.populate_ar_sources(p_api_version => l_api_version
3683: ,p_init_msg_list => l_init_msg_list
3684: ,p_rxhv_rec => l_rxhv_adj_rec
3685: ,p_rxlv_rec => l_rxlv_adj_rec
3686: ,p_acc_sources_rec => l_asev_rec

Line 3712: OKL_SLA_ACC_SOURCES_PVT.populate_ar_sources(p_api_version => l_api_version

3708: l_rxlv_adj_rec.kle_id := get_adj_details_rec.kle_id;
3709: l_rxlv_adj_rec.sty_id := get_adj_details_rec.sty_id;
3710:
3711: --Make the call to capture account header source
3712: OKL_SLA_ACC_SOURCES_PVT.populate_ar_sources(p_api_version => l_api_version
3713: ,p_init_msg_list => l_init_msg_list
3714: ,p_rxhv_rec => l_rxhv_adj_rec
3715: ,p_rxlv_rec => l_rxlv_adj_rec
3716: ,p_acc_sources_rec => l_asev_rec

Line 3800: OKL_SLA_ACC_SOURCES_PVT.populate_ap_sources(p_api_version => l_api_version

3796: l_pxlv_rec.sty_id := get_tap_details_rec.sty_id;
3797: l_pxlv_rec.trans_line_description := get_tap_details_rec.trans_line_description;
3798:
3799: --Make the call to capture account header source
3800: OKL_SLA_ACC_SOURCES_PVT.populate_ap_sources(p_api_version => l_api_version
3801: ,p_init_msg_list => l_init_msg_list
3802: ,p_pxhv_rec => l_pxhv_rec
3803: ,p_pxlv_rec => l_pxlv_rec
3804: ,p_acc_sources_rec => l_asev_rec

Line 3831: OKL_SLA_ACC_SOURCES_PVT.populate_ap_sources(p_api_version => l_api_version

3827: l_pxlv_rec.sty_id := get_tap_details_rec.sty_id;
3828: l_pxlv_rec.trans_line_description := get_tap_details_rec.trans_line_description;
3829:
3830: --Make the call to capture account header source
3831: OKL_SLA_ACC_SOURCES_PVT.populate_ap_sources(p_api_version => l_api_version
3832: ,p_init_msg_list => l_init_msg_list
3833: ,p_pxhv_rec => l_pxhv_rec
3834: ,p_pxlv_rec => l_pxlv_rec
3835: ,p_acc_sources_rec => l_asev_rec

Line 5103: l_tcnv_rec okl_sla_acc_sources_pvt.tehv_rec_type;

5099: l_acc_gen_tbl acc_gen_tbl_type := p_acc_gen_primary_key_tbl;
5100: x_template_temp_tbl AVLV_OUT_TBL_TYPE;
5101: x_amount_temp_tbl AMOUNT_OUT_TBL_TYPE;
5102: x_tabv_temp_tbl TABV_TBL_TYPE;
5103: l_tcnv_rec okl_sla_acc_sources_pvt.tehv_rec_type;
5104: l_tclv_tbl okl_sla_acc_sources_pvt.telv_tbl_type;
5105: l_tclv_tbl_final okl_sla_acc_sources_pvt.telv_tbl_type;
5106: x_tclv_tbl okl_sla_acc_sources_pvt.telv_tbl_type;
5107: l_try_name OKL_TRX_TYPES_TL.NAME%TYPE;

Line 5104: l_tclv_tbl okl_sla_acc_sources_pvt.telv_tbl_type;

5100: x_template_temp_tbl AVLV_OUT_TBL_TYPE;
5101: x_amount_temp_tbl AMOUNT_OUT_TBL_TYPE;
5102: x_tabv_temp_tbl TABV_TBL_TYPE;
5103: l_tcnv_rec okl_sla_acc_sources_pvt.tehv_rec_type;
5104: l_tclv_tbl okl_sla_acc_sources_pvt.telv_tbl_type;
5105: l_tclv_tbl_final okl_sla_acc_sources_pvt.telv_tbl_type;
5106: x_tclv_tbl okl_sla_acc_sources_pvt.telv_tbl_type;
5107: l_try_name OKL_TRX_TYPES_TL.NAME%TYPE;
5108: l_source_table VARCHAR2(30);

Line 5105: l_tclv_tbl_final okl_sla_acc_sources_pvt.telv_tbl_type;

5101: x_amount_temp_tbl AMOUNT_OUT_TBL_TYPE;
5102: x_tabv_temp_tbl TABV_TBL_TYPE;
5103: l_tcnv_rec okl_sla_acc_sources_pvt.tehv_rec_type;
5104: l_tclv_tbl okl_sla_acc_sources_pvt.telv_tbl_type;
5105: l_tclv_tbl_final okl_sla_acc_sources_pvt.telv_tbl_type;
5106: x_tclv_tbl okl_sla_acc_sources_pvt.telv_tbl_type;
5107: l_try_name OKL_TRX_TYPES_TL.NAME%TYPE;
5108: l_source_table VARCHAR2(30);
5109: l_asev_rec asev_rec_type;

Line 5106: x_tclv_tbl okl_sla_acc_sources_pvt.telv_tbl_type;

5102: x_tabv_temp_tbl TABV_TBL_TYPE;
5103: l_tcnv_rec okl_sla_acc_sources_pvt.tehv_rec_type;
5104: l_tclv_tbl okl_sla_acc_sources_pvt.telv_tbl_type;
5105: l_tclv_tbl_final okl_sla_acc_sources_pvt.telv_tbl_type;
5106: x_tclv_tbl okl_sla_acc_sources_pvt.telv_tbl_type;
5107: l_try_name OKL_TRX_TYPES_TL.NAME%TYPE;
5108: l_source_table VARCHAR2(30);
5109: l_asev_rec asev_rec_type;
5110: l_asev_tbl asev_tbl_type;

Line 5115: l_rxhv_rec okl_sla_acc_sources_pvt.rxhv_rec_type;

5111: l_asev_count NUMBER := 0;
5112: l_acc_gen_key_tbl acc_gen_primary_key;
5113: l_found boolean := false;
5114: l_equal boolean := false;
5115: l_rxhv_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
5116: l_rxhv_adj_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
5117: l_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5118: x_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5119: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;

Line 5116: l_rxhv_adj_rec okl_sla_acc_sources_pvt.rxhv_rec_type;

5112: l_acc_gen_key_tbl acc_gen_primary_key;
5113: l_found boolean := false;
5114: l_equal boolean := false;
5115: l_rxhv_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
5116: l_rxhv_adj_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
5117: l_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5118: x_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5119: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5120: l_pxhv_rec okl_sla_acc_sources_pvt.pxhv_rec_type;

Line 5117: l_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;

5113: l_found boolean := false;
5114: l_equal boolean := false;
5115: l_rxhv_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
5116: l_rxhv_adj_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
5117: l_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5118: x_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5119: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5120: l_pxhv_rec okl_sla_acc_sources_pvt.pxhv_rec_type;
5121: l_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;

Line 5118: x_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;

5114: l_equal boolean := false;
5115: l_rxhv_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
5116: l_rxhv_adj_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
5117: l_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5118: x_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5119: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5120: l_pxhv_rec okl_sla_acc_sources_pvt.pxhv_rec_type;
5121: l_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
5122: x_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;

Line 5119: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;

5115: l_rxhv_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
5116: l_rxhv_adj_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
5117: l_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5118: x_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5119: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5120: l_pxhv_rec okl_sla_acc_sources_pvt.pxhv_rec_type;
5121: l_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
5122: x_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
5123: l_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;

Line 5120: l_pxhv_rec okl_sla_acc_sources_pvt.pxhv_rec_type;

5116: l_rxhv_adj_rec okl_sla_acc_sources_pvt.rxhv_rec_type;
5117: l_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5118: x_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5119: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5120: l_pxhv_rec okl_sla_acc_sources_pvt.pxhv_rec_type;
5121: l_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
5122: x_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
5123: l_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5124:

Line 5121: l_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;

5117: l_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5118: x_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5119: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5120: l_pxhv_rec okl_sla_acc_sources_pvt.pxhv_rec_type;
5121: l_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
5122: x_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
5123: l_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5124:
5125: CURSOR get_tcn_id_csr(p_source_id IN NUMBER)

Line 5122: x_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;

5118: x_rxlv_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5119: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5120: l_pxhv_rec okl_sla_acc_sources_pvt.pxhv_rec_type;
5121: l_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
5122: x_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
5123: l_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5124:
5125: CURSOR get_tcn_id_csr(p_source_id IN NUMBER)
5126: IS

Line 5123: l_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;

5119: x_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5120: l_pxhv_rec okl_sla_acc_sources_pvt.pxhv_rec_type;
5121: l_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
5122: x_pxlv_tbl okl_sla_acc_sources_pvt.pxlv_tbl_type;
5123: l_rxlv_adj_tbl okl_sla_acc_sources_pvt.rxlv_tbl_type;
5124:
5125: CURSOR get_tcn_id_csr(p_source_id IN NUMBER)
5126: IS
5127: SELECT tcl.tcn_id

Line 5347: okl_sla_acc_sources_pvt.delete_trx_extension(

5343: CLOSE get_acc_event_id;
5344:
5345: IF (l_event_id IS NOT NULL) THEN
5346: --Make the call to delete existing sources
5347: okl_sla_acc_sources_pvt.delete_trx_extension(
5348: p_api_version => l_api_version
5349: ,p_init_msg_list => l_init_msg_list
5350: ,p_trans_hdr_rec => l_tcnv_rec
5351: ,x_trans_line_tbl => x_tclv_tbl

Line 5506: OKL_SLA_ACC_SOURCES_PVT.populate_sources

5502: END IF; --(if l_found)
5503: END LOOP;
5504:
5505: --Make the call to capture accounting sources for the header for OKL trasaction types only
5506: OKL_SLA_ACC_SOURCES_PVT.populate_sources
5507: (p_api_version => l_api_version
5508: ,p_init_msg_list => l_init_msg_list
5509: ,p_trans_hdr_rec => l_tcnv_rec
5510: ,p_trans_line_tbl => l_tclv_tbl

Line 5550: okl_sla_acc_sources_pvt.delete_ar_extension(

5546: OPEN check_sources_csr(p_trx_header_id);
5547: FETCH check_sources_csr INTO l_sources_exist;
5548: IF (check_sources_csr%FOUND) THEN
5549: --Make the call to delete existing sources
5550: okl_sla_acc_sources_pvt.delete_ar_extension(
5551: p_api_version => l_api_version
5552: ,p_init_msg_list => l_init_msg_list
5553: ,p_rxhv_rec => l_rxhv_rec
5554: ,x_rxlv_tbl => x_rxlv_tbl

Line 5641: OKL_SLA_ACC_SOURCES_PVT.populate_sources

5637: END IF; --(if l_found)
5638: END LOOP;
5639:
5640: --Make the call to capture accounting sources for the header for OKL trasaction types only
5641: OKL_SLA_ACC_SOURCES_PVT.populate_sources
5642: (p_api_version => l_api_version
5643: ,p_init_msg_list => l_init_msg_list
5644: ,p_rxhv_rec => l_rxhv_rec
5645: ,p_rxlv_tbl => l_rxlv_tbl

Line 5686: okl_sla_acc_sources_pvt.delete_ar_extension(

5682: OPEN check_sources_csr(p_trx_header_id);
5683: FETCH check_sources_csr INTO l_sources_exist;
5684: IF (check_sources_csr%FOUND) THEN
5685: --Make the call to delete existing sources
5686: okl_sla_acc_sources_pvt.delete_ar_extension(
5687: p_api_version => l_api_version
5688: ,p_init_msg_list => l_init_msg_list
5689: ,p_rxhv_rec => l_rxhv_adj_rec
5690: ,x_rxlv_tbl => x_rxlv_adj_tbl

Line 5777: OKL_SLA_ACC_SOURCES_PVT.populate_sources

5773: END IF; --(if l_found)
5774: END LOOP;
5775:
5776: --Make the call to capture accounting sources for the header for OKL trasaction types only
5777: OKL_SLA_ACC_SOURCES_PVT.populate_sources
5778: (p_api_version => l_api_version
5779: ,p_init_msg_list => l_init_msg_list
5780: ,p_rxhv_rec => l_rxhv_adj_rec
5781: ,p_rxlv_tbl => l_rxlv_adj_tbl

Line 5820: okl_sla_acc_sources_pvt.delete_ap_extension(

5816: OPEN check_ap_sources_csr(p_trx_header_id);
5817: FETCH check_ap_sources_csr INTO l_sources_exist;
5818: IF (check_ap_sources_csr%FOUND) THEN
5819: --Make the call to delete existing sources
5820: okl_sla_acc_sources_pvt.delete_ap_extension(
5821: p_api_version => l_api_version
5822: ,p_init_msg_list => l_init_msg_list
5823: ,p_pxhv_rec => l_pxhv_rec
5824: ,x_pxlv_tbl => x_pxlv_tbl

Line 5911: OKL_SLA_ACC_SOURCES_PVT.populate_sources

5907: END IF; --(if l_found)
5908: END LOOP;
5909:
5910: --Make the call to capture accounting sources for the header for OKL trasaction types only
5911: OKL_SLA_ACC_SOURCES_PVT.populate_sources
5912: (p_api_version => l_api_version
5913: ,p_init_msg_list => l_init_msg_list
5914: ,p_pxhv_rec => l_pxhv_rec
5915: ,p_pxlv_tbl => l_pxlv_tbl