550: WHERE payment_schedule_id = p_psl_id;
551: -- Code added by varao for bug #4728481 - END
552:
553: --Bug 6316320 dpsingh start
554: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
555: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
556: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
557: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
558: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
551: -- Code added by varao for bug #4728481 - END
552:
553: --Bug 6316320 dpsingh start
554: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
555: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
556: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
557: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
558: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
559: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
552:
553: --Bug 6316320 dpsingh start
554: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
555: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
556: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
557: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
558: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
559: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
560: l_account_derivation OKL_SYS_ACCT_OPTS.ACCOUNT_DERIVATION%TYPE;
553: --Bug 6316320 dpsingh start
554: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
555: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
556: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
557: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
558: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
559: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
560: l_account_derivation OKL_SYS_ACCT_OPTS.ACCOUNT_DERIVATION%TYPE;
561:
554: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
555: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
556: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
557: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
558: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
559: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
560: l_account_derivation OKL_SYS_ACCT_OPTS.ACCOUNT_DERIVATION%TYPE;
561:
562: CURSOR get_account_derivation_meth IS
555: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
556: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
557: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
558: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
559: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
560: l_account_derivation OKL_SYS_ACCT_OPTS.ACCOUNT_DERIVATION%TYPE;
561:
562: CURSOR get_account_derivation_meth IS
563: SELECT ACCOUNT_DERIVATION
823: -- 19-Sep-05 varao bug 4622198 End
824:
825: -- Call accounting engine
826: -- This will calculate the adjstmnts and generate accounting entries
827: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(
828: p_api_version => l_api_version,
829: p_init_msg_list => l_init_msg_list,
830: x_return_status => l_return_status,
831: x_msg_count => l_msg_count,