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_LOSS_PROV_PVT dependencies on OKL_EXECUTE_FORMULA_PUB

Line 152: Okl_Execute_Formula_Pub.EXECUTE

148: l_ctxt_val_tbl(1).NAME := 'p_provision_date';
149: l_ctxt_val_tbl(1).VALUE := TO_CHAR(p_loss_date, 'MM/DD/YYYY');
150:
151: /* use the formula engine for the calculation */
152: Okl_Execute_Formula_Pub.EXECUTE
153: (p_api_version => l_api_version
154: ,p_init_msg_list => l_init_msg_list
155: ,x_return_status => l_return_status
156: ,x_msg_count => l_msg_count

Line 333: l_ctxt_val_tbl Okl_Execute_Formula_Pub.ctxt_val_tbl_type;

329: p_cntrct_id IN NUMBER
330: ,p_period_start_date IN DATE
331: ,p_period_end_date IN DATE ) RETURN NUMBER
332: IS
333: l_ctxt_val_tbl Okl_Execute_Formula_Pub.ctxt_val_tbl_type;
334: l_principal_balance NUMBER;
335: BEGIN
336: --changed pl/sql table structure from l_ctxt_val_tbl to g_additional_parameters
337: -- Bug 3348162. Added format mask.

Line 338: Okl_Execute_Formula_Pub.g_additional_parameters(1).name := 'p_period_start_date';

334: l_principal_balance NUMBER;
335: BEGIN
336: --changed pl/sql table structure from l_ctxt_val_tbl to g_additional_parameters
337: -- Bug 3348162. Added format mask.
338: Okl_Execute_Formula_Pub.g_additional_parameters(1).name := 'p_period_start_date';
339: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := TO_CHAR(p_period_start_date, 'MM/DD/YYYY');
340: Okl_Execute_Formula_Pub.g_additional_parameters(2).name := 'p_period_end_date';
341: Okl_Execute_Formula_Pub.g_additional_parameters(2).value := TO_CHAR(p_period_end_date, 'MM/DD/YYYY');
342:

Line 339: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := TO_CHAR(p_period_start_date, 'MM/DD/YYYY');

335: BEGIN
336: --changed pl/sql table structure from l_ctxt_val_tbl to g_additional_parameters
337: -- Bug 3348162. Added format mask.
338: Okl_Execute_Formula_Pub.g_additional_parameters(1).name := 'p_period_start_date';
339: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := TO_CHAR(p_period_start_date, 'MM/DD/YYYY');
340: Okl_Execute_Formula_Pub.g_additional_parameters(2).name := 'p_period_end_date';
341: Okl_Execute_Formula_Pub.g_additional_parameters(2).value := TO_CHAR(p_period_end_date, 'MM/DD/YYYY');
342:
343: l_principal_balance := OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE

Line 340: Okl_Execute_Formula_Pub.g_additional_parameters(2).name := 'p_period_end_date';

336: --changed pl/sql table structure from l_ctxt_val_tbl to g_additional_parameters
337: -- Bug 3348162. Added format mask.
338: Okl_Execute_Formula_Pub.g_additional_parameters(1).name := 'p_period_start_date';
339: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := TO_CHAR(p_period_start_date, 'MM/DD/YYYY');
340: Okl_Execute_Formula_Pub.g_additional_parameters(2).name := 'p_period_end_date';
341: Okl_Execute_Formula_Pub.g_additional_parameters(2).value := TO_CHAR(p_period_end_date, 'MM/DD/YYYY');
342:
343: l_principal_balance := OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE
344: (p_khr_id => p_cntrct_id,

Line 341: Okl_Execute_Formula_Pub.g_additional_parameters(2).value := TO_CHAR(p_period_end_date, 'MM/DD/YYYY');

337: -- Bug 3348162. Added format mask.
338: Okl_Execute_Formula_Pub.g_additional_parameters(1).name := 'p_period_start_date';
339: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := TO_CHAR(p_period_start_date, 'MM/DD/YYYY');
340: Okl_Execute_Formula_Pub.g_additional_parameters(2).name := 'p_period_end_date';
341: Okl_Execute_Formula_Pub.g_additional_parameters(2).value := TO_CHAR(p_period_end_date, 'MM/DD/YYYY');
342:
343: l_principal_balance := OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE
344: (p_khr_id => p_cntrct_id,
345: p_kle_id => NULL);

Line 472: Okl_Execute_Formula_Pub.g_additional_parameters(1).name := 'p_last_int_calc_date';

468: OPEN last_int_date_csr;
469: FETCH last_int_date_csr into l_last_int_calc_date;
470: CLOSE last_int_date_csr;
471:
472: Okl_Execute_Formula_Pub.g_additional_parameters(1).name := 'p_last_int_calc_date';
473: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := TO_CHAR(l_last_int_calc_date, 'MM/DD/YYYY');
474:
475: l_capital_bal := OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE
476: (p_khr_id => p_cntrct_id,

Line 473: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := TO_CHAR(l_last_int_calc_date, 'MM/DD/YYYY');

469: FETCH last_int_date_csr into l_last_int_calc_date;
470: CLOSE last_int_date_csr;
471:
472: Okl_Execute_Formula_Pub.g_additional_parameters(1).name := 'p_last_int_calc_date';
473: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := TO_CHAR(l_last_int_calc_date, 'MM/DD/YYYY');
474:
475: l_capital_bal := OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE
476: (p_khr_id => p_cntrct_id,
477: p_kle_id => NULL);

Line 1740: Okl_Execute_Formula_Pub.g_additional_parameters(1).name := 'p_last_int_calc_date';

1736: ,p_period_end_date => l_period_end_date);
1737:
1738: ELSIF l_rev_rec_method_code IN ('ESTIMATED_AND_BILLED', 'ACTUAL') THEN
1739: l_last_int_calc_date := l_int_calc_date_tbl(x);
1740: Okl_Execute_Formula_Pub.g_additional_parameters(1).name := 'p_last_int_calc_date';
1741: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := TO_CHAR(l_last_int_calc_date, 'MM/DD/YYYY');
1742: l_principal_balance := OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE
1743: (p_khr_id => l_cntrct_id,
1744: p_kle_id => NULL);

Line 1741: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := TO_CHAR(l_last_int_calc_date, 'MM/DD/YYYY');

1737:
1738: ELSIF l_rev_rec_method_code IN ('ESTIMATED_AND_BILLED', 'ACTUAL') THEN
1739: l_last_int_calc_date := l_int_calc_date_tbl(x);
1740: Okl_Execute_Formula_Pub.g_additional_parameters(1).name := 'p_last_int_calc_date';
1741: Okl_Execute_Formula_Pub.g_additional_parameters(1).value := TO_CHAR(l_last_int_calc_date, 'MM/DD/YYYY');
1742: l_principal_balance := OKL_SEEDED_FUNCTIONS_PVT.CONTRACT_PRINCIPAL_BALANCE
1743: (p_khr_id => l_cntrct_id,
1744: p_kle_id => NULL);
1745: END IF;