137: --g_request_id := l_parent_request_id;
138:
139: --set additional paramaters needed by formulas
140:
141: Okl_Execute_Formula_Pub.g_additional_parameters(1).name := 'p_accrual_date';
142: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := P_REPORT_DATE ;
143:
144: Okl_Execute_Formula_Pub.g_additional_parameters(2).name := 'p_provision_date';
145: Okl_Execute_Formula_Pub.g_additional_parameters(2).value := P_REPORT_DATE ;
138:
139: --set additional paramaters needed by formulas
140:
141: Okl_Execute_Formula_Pub.g_additional_parameters(1).name := 'p_accrual_date';
142: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := P_REPORT_DATE ;
143:
144: Okl_Execute_Formula_Pub.g_additional_parameters(2).name := 'p_provision_date';
145: Okl_Execute_Formula_Pub.g_additional_parameters(2).value := P_REPORT_DATE ;
146:
140:
141: Okl_Execute_Formula_Pub.g_additional_parameters(1).name := 'p_accrual_date';
142: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := P_REPORT_DATE ;
143:
144: Okl_Execute_Formula_Pub.g_additional_parameters(2).name := 'p_provision_date';
145: Okl_Execute_Formula_Pub.g_additional_parameters(2).value := P_REPORT_DATE ;
146:
147: Okl_Execute_Formula_Pub.g_additional_parameters(3).name := 'p_last_int_calc_date';
148: -- Start fix for bug 7646416
141: Okl_Execute_Formula_Pub.g_additional_parameters(1).name := 'p_accrual_date';
142: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := P_REPORT_DATE ;
143:
144: Okl_Execute_Formula_Pub.g_additional_parameters(2).name := 'p_provision_date';
145: Okl_Execute_Formula_Pub.g_additional_parameters(2).value := P_REPORT_DATE ;
146:
147: Okl_Execute_Formula_Pub.g_additional_parameters(3).name := 'p_last_int_calc_date';
148: -- Start fix for bug 7646416
149: --Okl_Execute_Formula_Pub.g_additional_parameters(3).value := P_REPORT_DATE ;
143:
144: Okl_Execute_Formula_Pub.g_additional_parameters(2).name := 'p_provision_date';
145: Okl_Execute_Formula_Pub.g_additional_parameters(2).value := P_REPORT_DATE ;
146:
147: Okl_Execute_Formula_Pub.g_additional_parameters(3).name := 'p_last_int_calc_date';
148: -- Start fix for bug 7646416
149: --Okl_Execute_Formula_Pub.g_additional_parameters(3).value := P_REPORT_DATE ;
150: l_report_date := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);
151: Okl_Execute_Formula_Pub.g_additional_parameters(3).value := to_char(l_report_date, 'MM/DD/YYYY');
145: Okl_Execute_Formula_Pub.g_additional_parameters(2).value := P_REPORT_DATE ;
146:
147: Okl_Execute_Formula_Pub.g_additional_parameters(3).name := 'p_last_int_calc_date';
148: -- Start fix for bug 7646416
149: --Okl_Execute_Formula_Pub.g_additional_parameters(3).value := P_REPORT_DATE ;
150: l_report_date := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);
151: Okl_Execute_Formula_Pub.g_additional_parameters(3).value := to_char(l_report_date, 'MM/DD/YYYY');
152: -- End fix for bug 7646416
153:
147: Okl_Execute_Formula_Pub.g_additional_parameters(3).name := 'p_last_int_calc_date';
148: -- Start fix for bug 7646416
149: --Okl_Execute_Formula_Pub.g_additional_parameters(3).value := P_REPORT_DATE ;
150: l_report_date := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);
151: Okl_Execute_Formula_Pub.g_additional_parameters(3).value := to_char(l_report_date, 'MM/DD/YYYY');
152: -- End fix for bug 7646416
153:
154: Okl_Execute_Formula_Pub.g_additional_parameters(4).name := 'p_period_end_date';
155: Okl_Execute_Formula_Pub.g_additional_parameters(4).value := P_REPORT_DATE ;
150: l_report_date := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);
151: Okl_Execute_Formula_Pub.g_additional_parameters(3).value := to_char(l_report_date, 'MM/DD/YYYY');
152: -- End fix for bug 7646416
153:
154: Okl_Execute_Formula_Pub.g_additional_parameters(4).name := 'p_period_end_date';
155: Okl_Execute_Formula_Pub.g_additional_parameters(4).value := P_REPORT_DATE ;
156:
157: --------------------------------------------------------------
158: -- debug section
151: Okl_Execute_Formula_Pub.g_additional_parameters(3).value := to_char(l_report_date, 'MM/DD/YYYY');
152: -- End fix for bug 7646416
153:
154: Okl_Execute_Formula_Pub.g_additional_parameters(4).name := 'p_period_end_date';
155: Okl_Execute_Formula_Pub.g_additional_parameters(4).value := P_REPORT_DATE ;
156:
157: --------------------------------------------------------------
158: -- debug section
159: -- select khr_CONTRACT_ID, count(*) from okl_cntrct_fin_extract_t group by contract_id having count(*) > 1