3812:
3813: l_return_status VARCHAR2 (1) := g_ret_sts_success;
3814: l_pdt_id NUMBER := 0;
3815: l_try_id NUMBER;
3816: lp_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
3817: lp_dist_info_rec okl_account_dist_pub.dist_info_rec_type;
3818: lp_ctxt_val_tbl okl_account_dist_pub.ctxt_val_tbl_type;
3819: lp_acc_gen_primary_key_tbl okl_account_dist_pub.acc_gen_primary_key;
3820: lx_template_tbl okl_account_dist_pub.avlv_tbl_type;
3813: l_return_status VARCHAR2 (1) := g_ret_sts_success;
3814: l_pdt_id NUMBER := 0;
3815: l_try_id NUMBER;
3816: lp_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
3817: lp_dist_info_rec okl_account_dist_pub.dist_info_rec_type;
3818: lp_ctxt_val_tbl okl_account_dist_pub.ctxt_val_tbl_type;
3819: lp_acc_gen_primary_key_tbl okl_account_dist_pub.acc_gen_primary_key;
3820: lx_template_tbl okl_account_dist_pub.avlv_tbl_type;
3821: lx_amount_tbl okl_account_dist_pub.amount_tbl_type;
3814: l_pdt_id NUMBER := 0;
3815: l_try_id NUMBER;
3816: lp_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
3817: lp_dist_info_rec okl_account_dist_pub.dist_info_rec_type;
3818: lp_ctxt_val_tbl okl_account_dist_pub.ctxt_val_tbl_type;
3819: lp_acc_gen_primary_key_tbl okl_account_dist_pub.acc_gen_primary_key;
3820: lx_template_tbl okl_account_dist_pub.avlv_tbl_type;
3821: lx_amount_tbl okl_account_dist_pub.amount_tbl_type;
3822: lx_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;
3815: l_try_id NUMBER;
3816: lp_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
3817: lp_dist_info_rec okl_account_dist_pub.dist_info_rec_type;
3818: lp_ctxt_val_tbl okl_account_dist_pub.ctxt_val_tbl_type;
3819: lp_acc_gen_primary_key_tbl okl_account_dist_pub.acc_gen_primary_key;
3820: lx_template_tbl okl_account_dist_pub.avlv_tbl_type;
3821: lx_amount_tbl okl_account_dist_pub.amount_tbl_type;
3822: lx_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;
3823: lx_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
3816: lp_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
3817: lp_dist_info_rec okl_account_dist_pub.dist_info_rec_type;
3818: lp_ctxt_val_tbl okl_account_dist_pub.ctxt_val_tbl_type;
3819: lp_acc_gen_primary_key_tbl okl_account_dist_pub.acc_gen_primary_key;
3820: lx_template_tbl okl_account_dist_pub.avlv_tbl_type;
3821: lx_amount_tbl okl_account_dist_pub.amount_tbl_type;
3822: lx_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;
3823: lx_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
3824: l_catchup_rec okl_generate_accruals_pub.accrual_rec_type;
3817: lp_dist_info_rec okl_account_dist_pub.dist_info_rec_type;
3818: lp_ctxt_val_tbl okl_account_dist_pub.ctxt_val_tbl_type;
3819: lp_acc_gen_primary_key_tbl okl_account_dist_pub.acc_gen_primary_key;
3820: lx_template_tbl okl_account_dist_pub.avlv_tbl_type;
3821: lx_amount_tbl okl_account_dist_pub.amount_tbl_type;
3822: lx_tcnv_tbl okl_trx_contracts_pub.tcnv_tbl_type;
3823: lx_tclv_tbl okl_trx_contracts_pub.tclv_tbl_type;
3824: l_catchup_rec okl_generate_accruals_pub.accrual_rec_type;
3825: l_lprv_rec okl_rev_loss_prov_pub.lprv_rec_type;
3836: lx_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
3837: li_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
3838: i NUMBER;
3839: l_total_amount NUMBER := 0;
3840: lip_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
3841: lix_template_tbl okl_account_dist_pub.avlv_tbl_type;
3842: lip_tcnv_rec tcnv_rec_type;
3843: lix_tcnv_rec tcnv_rec_type;
3844: l_product_type VARCHAR2 (2000);
3837: li_tclv_rec okl_trx_contracts_pub.tclv_rec_type;
3838: i NUMBER;
3839: l_total_amount NUMBER := 0;
3840: lip_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
3841: lix_template_tbl okl_account_dist_pub.avlv_tbl_type;
3842: lip_tcnv_rec tcnv_rec_type;
3843: lix_tcnv_rec tcnv_rec_type;
3844: l_product_type VARCHAR2 (2000);
3845: l_line_number NUMBER := 1;
4237: THEN
4238: okl_debug_pub.log_debug
4239: (g_level_statement,
4240: l_module_name,
4241: 'calling okl_account_dist_pub.get_template_info'
4242: );
4243: END IF;
4244:
4245: -- Get the accounting templates
4242: );
4243: END IF;
4244:
4245: -- Get the accounting templates
4246: okl_account_dist_pub.get_template_info
4247: (p_api_version => l_api_version,
4248: p_init_msg_list => g_false,
4249: x_return_status => l_return_status,
4250: x_msg_count => l_msg_count,
4258: THEN
4259: okl_debug_pub.log_debug
4260: (g_level_statement,
4261: l_module_name,
4262: 'called okl_account_dist_pub.get_template_info , return status: '
4263: || l_return_status
4264: );
4265: END IF;
4266:
7175: := okl_debug_pub.check_log_on (l_module_name, g_level_procedure);
7176: is_debug_statement_on BOOLEAN
7177: := okl_debug_pub.check_log_on (l_module_name, g_level_statement);
7178: l_pdt_id NUMBER := 0;
7179: lp_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
7180: lp_dist_info_rec okl_account_dist_pub.dist_info_rec_type;
7181: lp_ctxt_val_tbl okl_account_dist_pub.ctxt_val_tbl_type;
7182: lp_acc_gen_primary_key_tbl okl_account_dist_pub.acc_gen_primary_key;
7183: lx_template_tbl okl_account_dist_pub.avlv_tbl_type;
7176: is_debug_statement_on BOOLEAN
7177: := okl_debug_pub.check_log_on (l_module_name, g_level_statement);
7178: l_pdt_id NUMBER := 0;
7179: lp_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
7180: lp_dist_info_rec okl_account_dist_pub.dist_info_rec_type;
7181: lp_ctxt_val_tbl okl_account_dist_pub.ctxt_val_tbl_type;
7182: lp_acc_gen_primary_key_tbl okl_account_dist_pub.acc_gen_primary_key;
7183: lx_template_tbl okl_account_dist_pub.avlv_tbl_type;
7184: lx_amount_tbl okl_account_dist_pub.amount_tbl_type;
7177: := okl_debug_pub.check_log_on (l_module_name, g_level_statement);
7178: l_pdt_id NUMBER := 0;
7179: lp_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
7180: lp_dist_info_rec okl_account_dist_pub.dist_info_rec_type;
7181: lp_ctxt_val_tbl okl_account_dist_pub.ctxt_val_tbl_type;
7182: lp_acc_gen_primary_key_tbl okl_account_dist_pub.acc_gen_primary_key;
7183: lx_template_tbl okl_account_dist_pub.avlv_tbl_type;
7184: lx_amount_tbl okl_account_dist_pub.amount_tbl_type;
7185: l_try_id NUMBER;
7178: l_pdt_id NUMBER := 0;
7179: lp_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
7180: lp_dist_info_rec okl_account_dist_pub.dist_info_rec_type;
7181: lp_ctxt_val_tbl okl_account_dist_pub.ctxt_val_tbl_type;
7182: lp_acc_gen_primary_key_tbl okl_account_dist_pub.acc_gen_primary_key;
7183: lx_template_tbl okl_account_dist_pub.avlv_tbl_type;
7184: lx_amount_tbl okl_account_dist_pub.amount_tbl_type;
7185: l_try_id NUMBER;
7186: l_trans_meaning VARCHAR2 (200);
7179: lp_tmpl_identify_rec okl_account_dist_pub.tmpl_identify_rec_type;
7180: lp_dist_info_rec okl_account_dist_pub.dist_info_rec_type;
7181: lp_ctxt_val_tbl okl_account_dist_pub.ctxt_val_tbl_type;
7182: lp_acc_gen_primary_key_tbl okl_account_dist_pub.acc_gen_primary_key;
7183: lx_template_tbl okl_account_dist_pub.avlv_tbl_type;
7184: lx_amount_tbl okl_account_dist_pub.amount_tbl_type;
7185: l_try_id NUMBER;
7186: l_trans_meaning VARCHAR2 (200);
7187: l_currency_code VARCHAR2 (200);
7180: lp_dist_info_rec okl_account_dist_pub.dist_info_rec_type;
7181: lp_ctxt_val_tbl okl_account_dist_pub.ctxt_val_tbl_type;
7182: lp_acc_gen_primary_key_tbl okl_account_dist_pub.acc_gen_primary_key;
7183: lx_template_tbl okl_account_dist_pub.avlv_tbl_type;
7184: lx_amount_tbl okl_account_dist_pub.amount_tbl_type;
7185: l_try_id NUMBER;
7186: l_trans_meaning VARCHAR2 (200);
7187: l_currency_code VARCHAR2 (200);
7188: l_formatted_bal_amt VARCHAR2 (200);
7595: THEN
7596: okl_debug_pub.log_debug
7597: (g_level_statement,
7598: l_module_name,
7599: 'calling OKL_ACCOUNT_DIST_PUB.create_accounting_dist'
7600: );
7601: END IF;
7602:
7603: -- call accounting engine
7601: END IF;
7602:
7603: -- call accounting engine
7604: -- This will calculate the adjstmnts and generate accounting entries
7605: okl_account_dist_pub.create_accounting_dist
7606: (p_api_version => p_api_version,
7607: p_init_msg_list => okl_api.g_false,
7608: x_return_status => l_return_status,
7609: x_msg_count => x_msg_count,
7620: THEN
7621: okl_debug_pub.log_debug
7622: (g_level_statement,
7623: l_module_name,
7624: 'called OKL_ACCOUNT_DIST_PUB.create_accounting_dist , return status: '
7625: || l_return_status
7626: );
7627: END IF;
7628: