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_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 ; sechawla 25-sep-09 8890513
143: --Bug# 7646324
144: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513
145:

Line 142: --Okl_Execute_Formula_Pub.g_additional_parameters(1).value := P_REPORT_DATE ; sechawla 25-sep-09 8890513

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 ; sechawla 25-sep-09 8890513
143: --Bug# 7646324
144: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513
145:
146: Okl_Execute_Formula_Pub.g_additional_parameters(2).name := 'p_provision_date';

Line 144: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513

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 ; sechawla 25-sep-09 8890513
143: --Bug# 7646324
144: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513
145:
146: Okl_Execute_Formula_Pub.g_additional_parameters(2).name := 'p_provision_date';
147: --Okl_Execute_Formula_Pub.g_additional_parameters(2).value := P_REPORT_DATE ; sechawla 25-sep-09 8890513
148: --Bug# 7646324

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

142: --Okl_Execute_Formula_Pub.g_additional_parameters(1).value := P_REPORT_DATE ; sechawla 25-sep-09 8890513
143: --Bug# 7646324
144: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513
145:
146: Okl_Execute_Formula_Pub.g_additional_parameters(2).name := 'p_provision_date';
147: --Okl_Execute_Formula_Pub.g_additional_parameters(2).value := P_REPORT_DATE ; sechawla 25-sep-09 8890513
148: --Bug# 7646324
149: Okl_Execute_Formula_Pub.g_additional_parameters(2).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513
150:

Line 147: --Okl_Execute_Formula_Pub.g_additional_parameters(2).value := P_REPORT_DATE ; sechawla 25-sep-09 8890513

143: --Bug# 7646324
144: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513
145:
146: Okl_Execute_Formula_Pub.g_additional_parameters(2).name := 'p_provision_date';
147: --Okl_Execute_Formula_Pub.g_additional_parameters(2).value := P_REPORT_DATE ; sechawla 25-sep-09 8890513
148: --Bug# 7646324
149: Okl_Execute_Formula_Pub.g_additional_parameters(2).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513
150:
151: Okl_Execute_Formula_Pub.g_additional_parameters(3).name := 'p_last_int_calc_date';

Line 149: Okl_Execute_Formula_Pub.g_additional_parameters(2).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513

145:
146: Okl_Execute_Formula_Pub.g_additional_parameters(2).name := 'p_provision_date';
147: --Okl_Execute_Formula_Pub.g_additional_parameters(2).value := P_REPORT_DATE ; sechawla 25-sep-09 8890513
148: --Bug# 7646324
149: Okl_Execute_Formula_Pub.g_additional_parameters(2).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513
150:
151: Okl_Execute_Formula_Pub.g_additional_parameters(3).name := 'p_last_int_calc_date';
152: /*
153: -- Start fix for bug 7646416

Line 151: Okl_Execute_Formula_Pub.g_additional_parameters(3).name := 'p_last_int_calc_date';

147: --Okl_Execute_Formula_Pub.g_additional_parameters(2).value := P_REPORT_DATE ; sechawla 25-sep-09 8890513
148: --Bug# 7646324
149: Okl_Execute_Formula_Pub.g_additional_parameters(2).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513
150:
151: Okl_Execute_Formula_Pub.g_additional_parameters(3).name := 'p_last_int_calc_date';
152: /*
153: -- Start fix for bug 7646416
154: --Okl_Execute_Formula_Pub.g_additional_parameters(3).value := P_REPORT_DATE ;
155: l_report_date := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);

Line 154: --Okl_Execute_Formula_Pub.g_additional_parameters(3).value := P_REPORT_DATE ;

150:
151: Okl_Execute_Formula_Pub.g_additional_parameters(3).name := 'p_last_int_calc_date';
152: /*
153: -- Start fix for bug 7646416
154: --Okl_Execute_Formula_Pub.g_additional_parameters(3).value := P_REPORT_DATE ;
155: l_report_date := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);
156: Okl_Execute_Formula_Pub.g_additional_parameters(3).value := to_char(l_report_date, 'MM/DD/YYYY');
157: -- End fix for bug 7646416
158: */

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

152: /*
153: -- Start fix for bug 7646416
154: --Okl_Execute_Formula_Pub.g_additional_parameters(3).value := P_REPORT_DATE ;
155: l_report_date := FND_DATE.CANONICAL_TO_DATE(P_REPORT_DATE);
156: Okl_Execute_Formula_Pub.g_additional_parameters(3).value := to_char(l_report_date, 'MM/DD/YYYY');
157: -- End fix for bug 7646416
158: */
159: --Bug# 7646324
160: Okl_Execute_Formula_Pub.g_additional_parameters(3).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513

Line 160: Okl_Execute_Formula_Pub.g_additional_parameters(3).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513

156: Okl_Execute_Formula_Pub.g_additional_parameters(3).value := to_char(l_report_date, 'MM/DD/YYYY');
157: -- End fix for bug 7646416
158: */
159: --Bug# 7646324
160: Okl_Execute_Formula_Pub.g_additional_parameters(3).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513
161:
162: Okl_Execute_Formula_Pub.g_additional_parameters(4).name := 'p_period_end_date';
163: --Okl_Execute_Formula_Pub.g_additional_parameters(4).value := P_REPORT_DATE ;sechawla 25-sep-09 8890513
164: --Bug# 7646324

Line 162: Okl_Execute_Formula_Pub.g_additional_parameters(4).name := 'p_period_end_date';

158: */
159: --Bug# 7646324
160: Okl_Execute_Formula_Pub.g_additional_parameters(3).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513
161:
162: Okl_Execute_Formula_Pub.g_additional_parameters(4).name := 'p_period_end_date';
163: --Okl_Execute_Formula_Pub.g_additional_parameters(4).value := P_REPORT_DATE ;sechawla 25-sep-09 8890513
164: --Bug# 7646324
165: Okl_Execute_Formula_Pub.g_additional_parameters(4).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513
166:

Line 163: --Okl_Execute_Formula_Pub.g_additional_parameters(4).value := P_REPORT_DATE ;sechawla 25-sep-09 8890513

159: --Bug# 7646324
160: Okl_Execute_Formula_Pub.g_additional_parameters(3).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513
161:
162: Okl_Execute_Formula_Pub.g_additional_parameters(4).name := 'p_period_end_date';
163: --Okl_Execute_Formula_Pub.g_additional_parameters(4).value := P_REPORT_DATE ;sechawla 25-sep-09 8890513
164: --Bug# 7646324
165: Okl_Execute_Formula_Pub.g_additional_parameters(4).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513
166:
167: --Bug# 7646324

Line 165: Okl_Execute_Formula_Pub.g_additional_parameters(4).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513

161:
162: Okl_Execute_Formula_Pub.g_additional_parameters(4).name := 'p_period_end_date';
163: --Okl_Execute_Formula_Pub.g_additional_parameters(4).value := P_REPORT_DATE ;sechawla 25-sep-09 8890513
164: --Bug# 7646324
165: Okl_Execute_Formula_Pub.g_additional_parameters(4).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513
166:
167: --Bug# 7646324
168: Okl_Execute_Formula_Pub.g_additional_parameters(5).name := 'p_rep_type';
169: Okl_Execute_Formula_Pub.g_additional_parameters(5).value := 'PRIMARY';

Line 168: Okl_Execute_Formula_Pub.g_additional_parameters(5).name := 'p_rep_type';

164: --Bug# 7646324
165: Okl_Execute_Formula_Pub.g_additional_parameters(4).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513
166:
167: --Bug# 7646324
168: Okl_Execute_Formula_Pub.g_additional_parameters(5).name := 'p_rep_type';
169: Okl_Execute_Formula_Pub.g_additional_parameters(5).value := 'PRIMARY';
170:
171: --------------------------------------------------------------
172: -- debug section

Line 169: Okl_Execute_Formula_Pub.g_additional_parameters(5).value := 'PRIMARY';

165: Okl_Execute_Formula_Pub.g_additional_parameters(4).value := to_char(sysdate,'MM/DD/YYYY'); --sechawla 25-sep-09 8890513
166:
167: --Bug# 7646324
168: Okl_Execute_Formula_Pub.g_additional_parameters(5).name := 'p_rep_type';
169: Okl_Execute_Formula_Pub.g_additional_parameters(5).value := 'PRIMARY';
170:
171: --------------------------------------------------------------
172: -- debug section
173: -- select khr_CONTRACT_ID, count(*) from okl_cntrct_fin_extract_t group by contract_id having count(*) > 1