DBA Data[Home] [Help]

APPS.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on OKL_EXECUTE_FORMULA_PUB

Line 141: Okl_Execute_Formula_Pub.g_additional_parameters(1).name := 'p_accrual_date';

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 ;

Line 142: Okl_Execute_Formula_Pub.g_additional_parameters(1).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:

Line 144: Okl_Execute_Formula_Pub.g_additional_parameters(2).name := 'p_provision_date';

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

Line 145: Okl_Execute_Formula_Pub.g_additional_parameters(2).value := P_REPORT_DATE ;

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 ;

Line 147: Okl_Execute_Formula_Pub.g_additional_parameters(3).name := 'p_last_int_calc_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');

Line 149: --Okl_Execute_Formula_Pub.g_additional_parameters(3).value := P_REPORT_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');
152: -- End fix for bug 7646416
153:

Line 151: Okl_Execute_Formula_Pub.g_additional_parameters(3).value := to_char(l_report_date, 'MM/DD/YYYY');

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 ;

Line 154: Okl_Execute_Formula_Pub.g_additional_parameters(4).name := 'p_period_end_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

Line 155: Okl_Execute_Formula_Pub.g_additional_parameters(4).value := 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
159: -- select khr_CONTRACT_ID, count(*) from okl_cntrct_fin_extract_t group by contract_id having count(*) > 1