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_SUBSIDY_POOL_RPT_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 182: okl_accounting_util.get_curr_con_rate(p_api_version => l_api_version

178: -- If both the from currency code and to currency code are equal, there is no need
179: -- for conversion. simply return back the amount.
180: IF( p_from_currency_code <> p_to_currency_code) THEN
181: -- get the currency conversion rate.
182: okl_accounting_util.get_curr_con_rate(p_api_version => l_api_version
183: ,p_init_msg_list => l_init_msg_list
184: ,x_return_status => l_return_status
185: ,x_msg_count => l_msg_count
186: ,x_msg_data => l_msg_data

Line 214: okl_accounting_util.cross_currency_round_amount(p_api_version => l_api_version

210: -- calculate the amount in terms of the required currency, by multiplying the rate with the given amount.
211: x_conv_rate := l_conv_rate;
212: l_amount := NVL(p_amount,0) * l_conv_rate;
213: -- Then round of this converted amount.
214: okl_accounting_util.cross_currency_round_amount(p_api_version => l_api_version
215: ,p_init_msg_list => l_init_msg_list
216: ,x_return_status => l_return_status
217: ,x_msg_count => l_msg_count
218: ,x_msg_data => l_msg_data

Line 885: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_reporting_limit,p_to_currency_code),l_Pool_Limit_len,'DATA')||' '||

881: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
882: GET_PROPER_LENGTH(p_pool_rec.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
883: GET_PROPER_LENGTH(p_pool_rec.pool_type_code,l_Pool_Type_len,'DATA')||' '||
884: GET_PROPER_LENGTH(p_to_currency_code,l_Currency_Code_len,'DATA')||' '||
885: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_reporting_limit,p_to_currency_code),l_Pool_Limit_len,'DATA')||' '||
886: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_total_budget,p_to_currency_code),l_Budget_len,'DATA')||' '||
887: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_remaining_balance,p_to_currency_code),l_Remaining_Balance_len,'DATA'));
888: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
889:

Line 886: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_total_budget,p_to_currency_code),l_Budget_len,'DATA')||' '||

882: GET_PROPER_LENGTH(p_pool_rec.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
883: GET_PROPER_LENGTH(p_pool_rec.pool_type_code,l_Pool_Type_len,'DATA')||' '||
884: GET_PROPER_LENGTH(p_to_currency_code,l_Currency_Code_len,'DATA')||' '||
885: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_reporting_limit,p_to_currency_code),l_Pool_Limit_len,'DATA')||' '||
886: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_total_budget,p_to_currency_code),l_Budget_len,'DATA')||' '||
887: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_remaining_balance,p_to_currency_code),l_Remaining_Balance_len,'DATA'));
888: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
889:
890: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 887: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_remaining_balance,p_to_currency_code),l_Remaining_Balance_len,'DATA'));

883: GET_PROPER_LENGTH(p_pool_rec.pool_type_code,l_Pool_Type_len,'DATA')||' '||
884: GET_PROPER_LENGTH(p_to_currency_code,l_Currency_Code_len,'DATA')||' '||
885: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_reporting_limit,p_to_currency_code),l_Pool_Limit_len,'DATA')||' '||
886: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_total_budget,p_to_currency_code),l_Budget_len,'DATA')||' '||
887: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_remaining_balance,p_to_currency_code),l_Remaining_Balance_len,'DATA'));
888: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
889:
890: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
891: x_return_status := l_return_status;

Line 1209: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_reporting_limit,p_to_currency_code)

1205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1206: GET_PROPER_LENGTH(p_pool_tbl(i).subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
1207: GET_PROPER_LENGTH(p_pool_tbl(i).pool_type_code,l_Pool_Type_len,'DATA')||' '||
1208: GET_PROPER_LENGTH(p_to_currency_code,l_Currency_Code_len,'DATA')||' '||
1209: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_reporting_limit,p_to_currency_code)
1210: ,l_Pool_Limit_len,'DATA')||' '||
1211: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_total_budget,p_to_currency_code),l_Budget_len,'DATA')||' '||
1212: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_remaining_balance,p_to_currency_code),l_Remaining_Balance_len,'DATA'));
1213: END LOOP;

Line 1211: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_total_budget,p_to_currency_code),l_Budget_len,'DATA')||' '||

1207: GET_PROPER_LENGTH(p_pool_tbl(i).pool_type_code,l_Pool_Type_len,'DATA')||' '||
1208: GET_PROPER_LENGTH(p_to_currency_code,l_Currency_Code_len,'DATA')||' '||
1209: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_reporting_limit,p_to_currency_code)
1210: ,l_Pool_Limit_len,'DATA')||' '||
1211: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_total_budget,p_to_currency_code),l_Budget_len,'DATA')||' '||
1212: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_remaining_balance,p_to_currency_code),l_Remaining_Balance_len,'DATA'));
1213: END LOOP;
1214: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1215:

Line 1212: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_remaining_balance,p_to_currency_code),l_Remaining_Balance_len,'DATA'));

1208: GET_PROPER_LENGTH(p_to_currency_code,l_Currency_Code_len,'DATA')||' '||
1209: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_reporting_limit,p_to_currency_code)
1210: ,l_Pool_Limit_len,'DATA')||' '||
1211: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_total_budget,p_to_currency_code),l_Budget_len,'DATA')||' '||
1212: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_remaining_balance,p_to_currency_code),l_Remaining_Balance_len,'DATA'));
1213: END LOOP;
1214: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1215:
1216: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1664: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_budget,p_pool_rec.currency_code),l_Budget_len,'DATA')||' '||

1660: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1661: GET_PROPER_LENGTH(p_pool_rec.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
1662: GET_PROPER_LENGTH(p_pool_rec.pool_type_code,l_Pool_Type_len,'DATA')||' '||
1663: GET_PROPER_LENGTH(p_pool_rec.currency_code,l_Currency_Code_len,'DATA')||' '||
1664: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_budget,p_pool_rec.currency_code),l_Budget_len,'DATA')||' '||
1665: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_trx_amt,p_pool_rec.currency_code),l_trx_amt_len,'DATA')||' '||
1666: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_remaining_balance,p_pool_rec.currency_code),l_Remaining_Balance_len,'DATA'));
1667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1668:

Line 1665: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_trx_amt,p_pool_rec.currency_code),l_trx_amt_len,'DATA')||' '||

1661: GET_PROPER_LENGTH(p_pool_rec.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
1662: GET_PROPER_LENGTH(p_pool_rec.pool_type_code,l_Pool_Type_len,'DATA')||' '||
1663: GET_PROPER_LENGTH(p_pool_rec.currency_code,l_Currency_Code_len,'DATA')||' '||
1664: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_budget,p_pool_rec.currency_code),l_Budget_len,'DATA')||' '||
1665: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_trx_amt,p_pool_rec.currency_code),l_trx_amt_len,'DATA')||' '||
1666: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_remaining_balance,p_pool_rec.currency_code),l_Remaining_Balance_len,'DATA'));
1667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1668:
1669: -- if subsidy pool type is "Reporting" then the total budgets and total transaction amount

Line 1666: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_remaining_balance,p_pool_rec.currency_code),l_Remaining_Balance_len,'DATA'));

1662: GET_PROPER_LENGTH(p_pool_rec.pool_type_code,l_Pool_Type_len,'DATA')||' '||
1663: GET_PROPER_LENGTH(p_pool_rec.currency_code,l_Currency_Code_len,'DATA')||' '||
1664: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_budget,p_pool_rec.currency_code),l_Budget_len,'DATA')||' '||
1665: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_trx_amt,p_pool_rec.currency_code),l_trx_amt_len,'DATA')||' '||
1666: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_remaining_balance,p_pool_rec.currency_code),l_Remaining_Balance_len,'DATA'));
1667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1668:
1669: -- if subsidy pool type is "Reporting" then the total budgets and total transaction amount
1670: -- is calculated from its children as there is no transaction and budgets for pool type "Reporting"

Line 1710: GET_PROPER_LENGTH(okl_accounting_util.format_amount(p_pool_rec.reporting_pool_limit,p_pool_rec.currency_code),l_Pool_Limit_len,'DATA')||' '||

1706: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1707: GET_PROPER_LENGTH(p_pool_rec.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
1708: GET_PROPER_LENGTH(p_pool_rec.pool_type_code,l_Pool_Type_len,'DATA')||' '||
1709: GET_PROPER_LENGTH(p_pool_rec.currency_code,l_Currency_Code_len,'DATA')||' '||
1710: GET_PROPER_LENGTH(okl_accounting_util.format_amount(p_pool_rec.reporting_pool_limit,p_pool_rec.currency_code),l_Pool_Limit_len,'DATA')||' '||
1711: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_trx_amt,p_pool_rec.currency_code),l_trx_amt_len,'DATA'));
1712: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1713: END IF;
1714:

Line 1711: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_trx_amt,p_pool_rec.currency_code),l_trx_amt_len,'DATA'));

1707: GET_PROPER_LENGTH(p_pool_rec.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
1708: GET_PROPER_LENGTH(p_pool_rec.pool_type_code,l_Pool_Type_len,'DATA')||' '||
1709: GET_PROPER_LENGTH(p_pool_rec.currency_code,l_Currency_Code_len,'DATA')||' '||
1710: GET_PROPER_LENGTH(okl_accounting_util.format_amount(p_pool_rec.reporting_pool_limit,p_pool_rec.currency_code),l_Pool_Limit_len,'DATA')||' '||
1711: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_trx_amt,p_pool_rec.currency_code),l_trx_amt_len,'DATA'));
1712: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1713: END IF;
1714:
1715: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1971: LPAD(okl_accounting_util.format_amount(l_trx_amount,each_row.trx_currency_code)

1967: GET_PROPER_LENGTH(each_row.dnz_asset_number,l_asset_len,'DATA')||' '||
1968: GET_PROPER_LENGTH(each_row.Vendor,l_vendor_len,'DATA')||' '||
1969: GET_PROPER_LENGTH(each_row.subsidy_name,l_subsidy_len,'DATA')||' '||
1970: GET_PROPER_LENGTH(each_row.source_trx_date,l_src_trx_date_len,'DATA')||' '||
1971: LPAD(okl_accounting_util.format_amount(l_trx_amount,each_row.trx_currency_code)
1972: ||' '||each_row.trx_currency_code,l_trx_amt_len + l_curr_len,' ')||' '||
1973: LPAD(each_row.conversion_rate,l_conv_rate_len,' ')||' '||
1974: LPAD(okl_accounting_util.format_amount(l_sub_pool_amount,each_row.subsidy_pool_currency_code)
1975: ||' '|| each_row.subsidy_pool_currency_code,l_pool_amt_len + l_curr_len,' ')||' '||

Line 1974: LPAD(okl_accounting_util.format_amount(l_sub_pool_amount,each_row.subsidy_pool_currency_code)

1970: GET_PROPER_LENGTH(each_row.source_trx_date,l_src_trx_date_len,'DATA')||' '||
1971: LPAD(okl_accounting_util.format_amount(l_trx_amount,each_row.trx_currency_code)
1972: ||' '||each_row.trx_currency_code,l_trx_amt_len + l_curr_len,' ')||' '||
1973: LPAD(each_row.conversion_rate,l_conv_rate_len,' ')||' '||
1974: LPAD(okl_accounting_util.format_amount(l_sub_pool_amount,each_row.subsidy_pool_currency_code)
1975: ||' '|| each_row.subsidy_pool_currency_code,l_pool_amt_len + l_curr_len,' ')||' '||
1976: -- abindal start bug# 4873705 --
1977: GET_PROPER_LENGTH(each_row.operating_unit,l_oper_unit_len,'DATA'));
1978: -- abindal end bug# 4873705 --

Line 1994: LPAD(okl_accounting_util.format_amount(l_pool_amount,p_pool_currency),l_pool_amt_len,' ')||' '||

1990: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length , '-' ));
1991: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1992: RPAD(' ', l_tot_bdgt_len , ' ' )||
1993: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TOTAL_AMOUNT'),l_total_amt_len,'TITLE')||' : '||
1994: LPAD(okl_accounting_util.format_amount(l_pool_amount,p_pool_currency),l_pool_amt_len,' ')||' '||
1995: GET_PROPER_LENGTH(p_pool_currency,l_curr_len,'DATA'));
1996: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length , '-' ));
1997:
1998: ELSIF(p_pool_type = 'REPORTING') THEN

Line 2038: LPAD(okl_accounting_util.format_amount(l_trx_amount,each_row.trx_currency_code)

2034: GET_PROPER_LENGTH(each_row.dnz_asset_number,l_asset_len,'DATA')||' '||
2035: GET_PROPER_LENGTH(each_row.Vendor,l_vendor_len,'DATA')||' '||
2036: GET_PROPER_LENGTH(each_row.subsidy_name,l_subsidy_len,'DATA')||' '||
2037: GET_PROPER_LENGTH(each_row.source_trx_date,l_src_trx_date_len,'DATA')||' '||
2038: LPAD(okl_accounting_util.format_amount(l_trx_amount,each_row.trx_currency_code)
2039: ||' '||each_row.trx_currency_code,l_trx_amt_len + l_curr_len,' ')||' '||
2040: LPAD(l_conv_rate,l_conv_rate_len,' ')||' '||
2041: LPAD(okl_accounting_util.format_amount(l_sub_pool_amount,p_pool_currency)
2042: ||' '|| p_pool_currency,l_pool_amt_len + l_curr_len,' ')||' '||

Line 2041: LPAD(okl_accounting_util.format_amount(l_sub_pool_amount,p_pool_currency)

2037: GET_PROPER_LENGTH(each_row.source_trx_date,l_src_trx_date_len,'DATA')||' '||
2038: LPAD(okl_accounting_util.format_amount(l_trx_amount,each_row.trx_currency_code)
2039: ||' '||each_row.trx_currency_code,l_trx_amt_len + l_curr_len,' ')||' '||
2040: LPAD(l_conv_rate,l_conv_rate_len,' ')||' '||
2041: LPAD(okl_accounting_util.format_amount(l_sub_pool_amount,p_pool_currency)
2042: ||' '|| p_pool_currency,l_pool_amt_len + l_curr_len,' ')||' '||
2043: -- abindal start bug# 4873705 --
2044: GET_PROPER_LENGTH(each_row.operating_unit,l_oper_unit_len,'DATA'));
2045: -- abindal end bug# 4873705 --

Line 2060: LPAD(okl_accounting_util.format_amount(l_pool_amount,p_pool_currency),l_pool_amt_len,' ')||' '||

2056: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length , '-' ));
2057: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
2058: RPAD(' ', l_tot_bdgt_len , ' ' )||
2059: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TOTAL_AMOUNT'),l_total_amt_len,'TITLE')||' : '||
2060: LPAD(okl_accounting_util.format_amount(l_pool_amount,p_pool_currency),l_pool_amt_len,' ')||' '||
2061: GET_PROPER_LENGTH(p_pool_currency,l_curr_len,'DATA'));
2062: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length , '-' ));
2063: END IF;
2064:

Line 2491: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),l_Budget_len,'DATA')||' '||

2487: l_event_name := G_WF_EVT_POOL_NEAR_BUDGLMT;
2488: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
2489: GET_PROPER_LENGTH(each_row.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
2490: GET_PROPER_LENGTH(each_row.currency_code,l_Currency_Code_len,'DATA')||' '||
2491: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),l_Budget_len,'DATA')||' '||
2492: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),l_Remaining_len,'DATA')||' '||
2493: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),l_percent_len,'DATA')||' '||
2494: GET_PROPER_LENGTH(each_row.effective_to_date,l_effective_to_len,'DATA'));
2495: -- Raise the business event "Pool nearing budget limit" for all the subsidy pool records found.

Line 2492: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),l_Remaining_len,'DATA')||' '||

2488: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
2489: GET_PROPER_LENGTH(each_row.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
2490: GET_PROPER_LENGTH(each_row.currency_code,l_Currency_Code_len,'DATA')||' '||
2491: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),l_Budget_len,'DATA')||' '||
2492: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),l_Remaining_len,'DATA')||' '||
2493: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),l_percent_len,'DATA')||' '||
2494: GET_PROPER_LENGTH(each_row.effective_to_date,l_effective_to_len,'DATA'));
2495: -- Raise the business event "Pool nearing budget limit" for all the subsidy pool records found.
2496: raise_business_event(p_api_version => l_api_version,

Line 2493: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),l_percent_len,'DATA')||' '||

2489: GET_PROPER_LENGTH(each_row.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
2490: GET_PROPER_LENGTH(each_row.currency_code,l_Currency_Code_len,'DATA')||' '||
2491: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),l_Budget_len,'DATA')||' '||
2492: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),l_Remaining_len,'DATA')||' '||
2493: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),l_percent_len,'DATA')||' '||
2494: GET_PROPER_LENGTH(each_row.effective_to_date,l_effective_to_len,'DATA'));
2495: -- Raise the business event "Pool nearing budget limit" for all the subsidy pool records found.
2496: raise_business_event(p_api_version => l_api_version,
2497: p_init_msg_list => l_init_msg_list,

Line 2535: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),l_Budget_len,'DATA')||' '||

2531: l_event_name := G_WF_EVT_POOL_NEAR_BUDGLMT;
2532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
2533: GET_PROPER_LENGTH(each_row.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
2534: GET_PROPER_LENGTH(each_row.currency_code,l_Currency_Code_len,'DATA')||' '||
2535: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),l_Budget_len,'DATA')||' '||
2536: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),l_Remaining_len,'DATA')||' '||
2537: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),l_percent_len,'DATA')||' '||
2538: GET_PROPER_LENGTH(each_row.effective_to_date,l_effective_to_len,'DATA'));
2539: -- Raise the business event "Pool nearing budget limit" for all the subsidy pool records found.

Line 2536: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),l_Remaining_len,'DATA')||' '||

2532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
2533: GET_PROPER_LENGTH(each_row.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
2534: GET_PROPER_LENGTH(each_row.currency_code,l_Currency_Code_len,'DATA')||' '||
2535: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),l_Budget_len,'DATA')||' '||
2536: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),l_Remaining_len,'DATA')||' '||
2537: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),l_percent_len,'DATA')||' '||
2538: GET_PROPER_LENGTH(each_row.effective_to_date,l_effective_to_len,'DATA'));
2539: -- Raise the business event "Pool nearing budget limit" for all the subsidy pool records found.
2540: raise_business_event(p_api_version => l_api_version,

Line 2537: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),l_percent_len,'DATA')||' '||

2533: GET_PROPER_LENGTH(each_row.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
2534: GET_PROPER_LENGTH(each_row.currency_code,l_Currency_Code_len,'DATA')||' '||
2535: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),l_Budget_len,'DATA')||' '||
2536: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),l_Remaining_len,'DATA')||' '||
2537: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),l_percent_len,'DATA')||' '||
2538: GET_PROPER_LENGTH(each_row.effective_to_date,l_effective_to_len,'DATA'));
2539: -- Raise the business event "Pool nearing budget limit" for all the subsidy pool records found.
2540: raise_business_event(p_api_version => l_api_version,
2541: p_init_msg_list => l_init_msg_list,

Line 2579: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),l_Budget_len,'DATA')||' '||

2575: l_event_name := G_WF_EVT_POOL_NEAR_EXPIR;
2576: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
2577: GET_PROPER_LENGTH(each_row.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
2578: GET_PROPER_LENGTH(each_row.currency_code,l_Currency_Code_len,'DATA')||' '||
2579: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),l_Budget_len,'DATA')||' '||
2580: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),l_Remaining_len,'DATA')||' '||
2581: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),l_percent_len,'DATA')||' '||
2582: GET_PROPER_LENGTH(each_row.effective_to_date,l_effective_to_len,'DATA'));
2583: -- Raise the business event "Pool nearing expiration" for all the subsidy pool records found.

Line 2580: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),l_Remaining_len,'DATA')||' '||

2576: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
2577: GET_PROPER_LENGTH(each_row.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
2578: GET_PROPER_LENGTH(each_row.currency_code,l_Currency_Code_len,'DATA')||' '||
2579: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),l_Budget_len,'DATA')||' '||
2580: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),l_Remaining_len,'DATA')||' '||
2581: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),l_percent_len,'DATA')||' '||
2582: GET_PROPER_LENGTH(each_row.effective_to_date,l_effective_to_len,'DATA'));
2583: -- Raise the business event "Pool nearing expiration" for all the subsidy pool records found.
2584: raise_business_event(p_api_version => l_api_version,

Line 2581: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),l_percent_len,'DATA')||' '||

2577: GET_PROPER_LENGTH(each_row.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
2578: GET_PROPER_LENGTH(each_row.currency_code,l_Currency_Code_len,'DATA')||' '||
2579: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),l_Budget_len,'DATA')||' '||
2580: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),l_Remaining_len,'DATA')||' '||
2581: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),l_percent_len,'DATA')||' '||
2582: GET_PROPER_LENGTH(each_row.effective_to_date,l_effective_to_len,'DATA'));
2583: -- Raise the business event "Pool nearing expiration" for all the subsidy pool records found.
2584: raise_business_event(p_api_version => l_api_version,
2585: p_init_msg_list => l_init_msg_list,

Line 2606: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),l_Budget_len,'DATA')||' '||

2602: l_event_name := G_WF_EVT_POOL_NEAR_EXPIR;
2603: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
2604: GET_PROPER_LENGTH(each_row.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
2605: GET_PROPER_LENGTH(each_row.currency_code,l_Currency_Code_len,'DATA')||' '||
2606: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),l_Budget_len,'DATA')||' '||
2607: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),l_Remaining_len,'DATA')||' '||
2608: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),l_percent_len,'DATA')||' '||
2609: GET_PROPER_LENGTH(each_row.effective_to_date,l_effective_to_len,'DATA')||' '||
2610: GET_PROPER_LENGTH(each_row.remaining_days,l_remaining_days_len,'DATA'));

Line 2607: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),l_Remaining_len,'DATA')||' '||

2603: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
2604: GET_PROPER_LENGTH(each_row.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
2605: GET_PROPER_LENGTH(each_row.currency_code,l_Currency_Code_len,'DATA')||' '||
2606: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),l_Budget_len,'DATA')||' '||
2607: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),l_Remaining_len,'DATA')||' '||
2608: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),l_percent_len,'DATA')||' '||
2609: GET_PROPER_LENGTH(each_row.effective_to_date,l_effective_to_len,'DATA')||' '||
2610: GET_PROPER_LENGTH(each_row.remaining_days,l_remaining_days_len,'DATA'));
2611: -- Raise the business event "Pool nearing expiration" for all the subsidy pool records found.

Line 2608: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),l_percent_len,'DATA')||' '||

2604: GET_PROPER_LENGTH(each_row.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
2605: GET_PROPER_LENGTH(each_row.currency_code,l_Currency_Code_len,'DATA')||' '||
2606: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),l_Budget_len,'DATA')||' '||
2607: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),l_Remaining_len,'DATA')||' '||
2608: GET_PROPER_LENGTH(okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),l_percent_len,'DATA')||' '||
2609: GET_PROPER_LENGTH(each_row.effective_to_date,l_effective_to_len,'DATA')||' '||
2610: GET_PROPER_LENGTH(each_row.remaining_days,l_remaining_days_len,'DATA'));
2611: -- Raise the business event "Pool nearing expiration" for all the subsidy pool records found.
2612: raise_business_event(p_api_version => l_api_version,

Line 2920: x_pool_dtl_rec.reporting_limit := okl_accounting_util.format_amount(0,p_to_currency_code);

2916: l_remaining_balance := 0;
2917: l_conv_rate := 0;
2918: l_reporting_limit := p_pool_rec.reporting_pool_limit;
2919:
2920: x_pool_dtl_rec.reporting_limit := okl_accounting_util.format_amount(0,p_to_currency_code);
2921: x_pool_dtl_rec.total_budget := okl_accounting_util.format_amount(0,p_to_currency_code);
2922: x_pool_dtl_rec.remaining_balance := okl_accounting_util.format_amount(0,p_to_currency_code);
2923:
2924: l_return_status := OKL_API.START_ACTIVITY( l_api_name,

Line 2921: x_pool_dtl_rec.total_budget := okl_accounting_util.format_amount(0,p_to_currency_code);

2917: l_conv_rate := 0;
2918: l_reporting_limit := p_pool_rec.reporting_pool_limit;
2919:
2920: x_pool_dtl_rec.reporting_limit := okl_accounting_util.format_amount(0,p_to_currency_code);
2921: x_pool_dtl_rec.total_budget := okl_accounting_util.format_amount(0,p_to_currency_code);
2922: x_pool_dtl_rec.remaining_balance := okl_accounting_util.format_amount(0,p_to_currency_code);
2923:
2924: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
2925: G_PKG_NAME,

Line 2922: x_pool_dtl_rec.remaining_balance := okl_accounting_util.format_amount(0,p_to_currency_code);

2918: l_reporting_limit := p_pool_rec.reporting_pool_limit;
2919:
2920: x_pool_dtl_rec.reporting_limit := okl_accounting_util.format_amount(0,p_to_currency_code);
2921: x_pool_dtl_rec.total_budget := okl_accounting_util.format_amount(0,p_to_currency_code);
2922: x_pool_dtl_rec.remaining_balance := okl_accounting_util.format_amount(0,p_to_currency_code);
2923:
2924: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
2925: G_PKG_NAME,
2926: l_init_msg_list,

Line 3034: x_pool_dtl_rec.reporting_limit := okl_accounting_util.format_amount(l_reporting_limit,p_to_currency_code);

3030: ||'l_remaining_balance'||l_remaining_balance
3031: );
3032: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
3033:
3034: x_pool_dtl_rec.reporting_limit := okl_accounting_util.format_amount(l_reporting_limit,p_to_currency_code);
3035: x_pool_dtl_rec.total_budget := okl_accounting_util.format_amount(l_total_budget,p_to_currency_code);
3036: x_pool_dtl_rec.remaining_balance := okl_accounting_util.format_amount(l_remaining_balance,p_to_currency_code);
3037:
3038: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3035: x_pool_dtl_rec.total_budget := okl_accounting_util.format_amount(l_total_budget,p_to_currency_code);

3031: );
3032: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
3033:
3034: x_pool_dtl_rec.reporting_limit := okl_accounting_util.format_amount(l_reporting_limit,p_to_currency_code);
3035: x_pool_dtl_rec.total_budget := okl_accounting_util.format_amount(l_total_budget,p_to_currency_code);
3036: x_pool_dtl_rec.remaining_balance := okl_accounting_util.format_amount(l_remaining_balance,p_to_currency_code);
3037:
3038: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
3039: x_return_status := l_return_status;

Line 3036: x_pool_dtl_rec.remaining_balance := okl_accounting_util.format_amount(l_remaining_balance,p_to_currency_code);

3032: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
3033:
3034: x_pool_dtl_rec.reporting_limit := okl_accounting_util.format_amount(l_reporting_limit,p_to_currency_code);
3035: x_pool_dtl_rec.total_budget := okl_accounting_util.format_amount(l_total_budget,p_to_currency_code);
3036: x_pool_dtl_rec.remaining_balance := okl_accounting_util.format_amount(l_remaining_balance,p_to_currency_code);
3037:
3038: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
3039: x_return_status := l_return_status;
3040: x_msg_data := l_msg_data;

Line 3240: x_chld_pool_dtl_rec.reporting_limit := okl_accounting_util.format_amount(0,l_pool_rec.currency_code);

3236: ELSE
3237: l_chld_pool_rec.subsidy_pool_name := NULL;
3238: l_chld_pool_rec.pool_type_code := NULL;
3239: l_chld_pool_rec.currency_code := NULL;
3240: x_chld_pool_dtl_rec.reporting_limit := okl_accounting_util.format_amount(0,l_pool_rec.currency_code);
3241: x_chld_pool_dtl_rec.total_budget := okl_accounting_util.format_amount(0,l_pool_rec.currency_code);
3242: x_chld_pool_dtl_rec.remaining_balance := okl_accounting_util.format_amount(0,l_pool_rec.currency_code);
3243: END IF;
3244: INSERT INTO

Line 3241: x_chld_pool_dtl_rec.total_budget := okl_accounting_util.format_amount(0,l_pool_rec.currency_code);

3237: l_chld_pool_rec.subsidy_pool_name := NULL;
3238: l_chld_pool_rec.pool_type_code := NULL;
3239: l_chld_pool_rec.currency_code := NULL;
3240: x_chld_pool_dtl_rec.reporting_limit := okl_accounting_util.format_amount(0,l_pool_rec.currency_code);
3241: x_chld_pool_dtl_rec.total_budget := okl_accounting_util.format_amount(0,l_pool_rec.currency_code);
3242: x_chld_pool_dtl_rec.remaining_balance := okl_accounting_util.format_amount(0,l_pool_rec.currency_code);
3243: END IF;
3244: INSERT INTO
3245: OKL_G_REPORTS_GT (VALUE1_TEXT,

Line 3242: x_chld_pool_dtl_rec.remaining_balance := okl_accounting_util.format_amount(0,l_pool_rec.currency_code);

3238: l_chld_pool_rec.pool_type_code := NULL;
3239: l_chld_pool_rec.currency_code := NULL;
3240: x_chld_pool_dtl_rec.reporting_limit := okl_accounting_util.format_amount(0,l_pool_rec.currency_code);
3241: x_chld_pool_dtl_rec.total_budget := okl_accounting_util.format_amount(0,l_pool_rec.currency_code);
3242: x_chld_pool_dtl_rec.remaining_balance := okl_accounting_util.format_amount(0,l_pool_rec.currency_code);
3243: END IF;
3244: INSERT INTO
3245: OKL_G_REPORTS_GT (VALUE1_TEXT,
3246: VALUE2_TEXT,

Line 3541: okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),

3537: VALUES
3538: ('PERCENT',
3539: each_row.subsidy_pool_name,
3540: each_row.currency_code,
3541: okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),
3542: okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),
3543: okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),
3544: each_row.effective_to_date
3545: );

Line 3542: okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),

3538: ('PERCENT',
3539: each_row.subsidy_pool_name,
3540: each_row.currency_code,
3541: okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),
3542: okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),
3543: okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),
3544: each_row.effective_to_date
3545: );
3546:

Line 3543: okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),

3539: each_row.subsidy_pool_name,
3540: each_row.currency_code,
3541: okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),
3542: okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),
3543: okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),
3544: each_row.effective_to_date
3545: );
3546:
3547: -- Raise the business event "Pool nearing budget limit" for all the subsidy pool records found.

Line 3595: okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),

3591: VALUES
3592: ('REMAINING',
3593: each_row.subsidy_pool_name,
3594: each_row.currency_code,
3595: okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),
3596: okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),
3597: okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),
3598: each_row.effective_to_date
3599: );

Line 3596: okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),

3592: ('REMAINING',
3593: each_row.subsidy_pool_name,
3594: each_row.currency_code,
3595: okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),
3596: okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),
3597: okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),
3598: each_row.effective_to_date
3599: );
3600:

Line 3597: okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),

3593: each_row.subsidy_pool_name,
3594: each_row.currency_code,
3595: okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),
3596: okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),
3597: okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),
3598: each_row.effective_to_date
3599: );
3600:
3601: -- Raise the business event "Pool nearing budget limit" for all the subsidy pool records found.

Line 3650: okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),

3646: VALUES
3647: ('DATE',
3648: each_row.subsidy_pool_name,
3649: each_row.currency_code,
3650: okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),
3651: okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),
3652: okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),
3653: each_row.effective_to_date
3654: );

Line 3651: okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),

3647: ('DATE',
3648: each_row.subsidy_pool_name,
3649: each_row.currency_code,
3650: okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),
3651: okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),
3652: okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),
3653: each_row.effective_to_date
3654: );
3655:

Line 3652: okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),

3648: each_row.subsidy_pool_name,
3649: each_row.currency_code,
3650: okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),
3651: okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),
3652: okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),
3653: each_row.effective_to_date
3654: );
3655:
3656: -- Raise the business event "Pool nearing expiration" for all the subsidy pool records found.

Line 3688: okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),

3684: VALUES
3685: ('DAYS',
3686: each_row.subsidy_pool_name,
3687: each_row.currency_code,
3688: okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),
3689: okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),
3690: okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),
3691: each_row.effective_to_date,
3692: each_row.remaining_days

Line 3689: okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),

3685: ('DAYS',
3686: each_row.subsidy_pool_name,
3687: each_row.currency_code,
3688: okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),
3689: okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),
3690: okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),
3691: each_row.effective_to_date,
3692: each_row.remaining_days
3693: );

Line 3690: okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),

3686: each_row.subsidy_pool_name,
3687: each_row.currency_code,
3688: okl_accounting_util.format_amount(each_row.total_budgets,each_row.currency_code),
3689: okl_accounting_util.format_amount(each_row.remaining_balance,each_row.currency_code),
3690: okl_accounting_util.format_amount(each_row.percent_remaining,each_row.currency_code),
3691: each_row.effective_to_date,
3692: each_row.remaining_days
3693: );
3694:

Line 3880: okl_accounting_util.format_amount(l_budget,p_pool_rec.currency_code),

3876: ('POOL_SUMMRY',
3877: p_pool_rec.subsidy_pool_name,
3878: p_pool_rec.pool_type_code,
3879: p_pool_rec.currency_code,
3880: okl_accounting_util.format_amount(l_budget,p_pool_rec.currency_code),
3881: okl_accounting_util.format_amount(0,p_pool_rec.currency_code), -- Pool Limit
3882: okl_accounting_util.format_amount(l_trx_amt,p_pool_rec.currency_code),
3883: okl_accounting_util.format_amount(l_remaining_balance,p_pool_rec.currency_code)
3884: );

Line 3881: okl_accounting_util.format_amount(0,p_pool_rec.currency_code), -- Pool Limit

3877: p_pool_rec.subsidy_pool_name,
3878: p_pool_rec.pool_type_code,
3879: p_pool_rec.currency_code,
3880: okl_accounting_util.format_amount(l_budget,p_pool_rec.currency_code),
3881: okl_accounting_util.format_amount(0,p_pool_rec.currency_code), -- Pool Limit
3882: okl_accounting_util.format_amount(l_trx_amt,p_pool_rec.currency_code),
3883: okl_accounting_util.format_amount(l_remaining_balance,p_pool_rec.currency_code)
3884: );
3885:

Line 3882: okl_accounting_util.format_amount(l_trx_amt,p_pool_rec.currency_code),

3878: p_pool_rec.pool_type_code,
3879: p_pool_rec.currency_code,
3880: okl_accounting_util.format_amount(l_budget,p_pool_rec.currency_code),
3881: okl_accounting_util.format_amount(0,p_pool_rec.currency_code), -- Pool Limit
3882: okl_accounting_util.format_amount(l_trx_amt,p_pool_rec.currency_code),
3883: okl_accounting_util.format_amount(l_remaining_balance,p_pool_rec.currency_code)
3884: );
3885:
3886: -- if subsidy pool type is "Reporting" then the total budgets and total transaction amount

Line 3883: okl_accounting_util.format_amount(l_remaining_balance,p_pool_rec.currency_code)

3879: p_pool_rec.currency_code,
3880: okl_accounting_util.format_amount(l_budget,p_pool_rec.currency_code),
3881: okl_accounting_util.format_amount(0,p_pool_rec.currency_code), -- Pool Limit
3882: okl_accounting_util.format_amount(l_trx_amt,p_pool_rec.currency_code),
3883: okl_accounting_util.format_amount(l_remaining_balance,p_pool_rec.currency_code)
3884: );
3885:
3886: -- if subsidy pool type is "Reporting" then the total budgets and total transaction amount
3887: -- is calculated from its children as there is no transaction and budgets for pool type "Reporting"

Line 3925: okl_accounting_util.format_amount(0,p_pool_rec.currency_code), -- Pool Budget

3921: ('POOL_SUMMRY',
3922: p_pool_rec.subsidy_pool_name,
3923: p_pool_rec.pool_type_code,
3924: p_pool_rec.currency_code,
3925: okl_accounting_util.format_amount(0,p_pool_rec.currency_code), -- Pool Budget
3926: okl_accounting_util.format_amount(p_pool_rec.reporting_pool_limit,p_pool_rec.currency_code),
3927: okl_accounting_util.format_amount(l_trx_amt,p_pool_rec.currency_code),
3928: okl_accounting_util.format_amount(0,p_pool_rec.currency_code) -- Pool Balance
3929: );

Line 3926: okl_accounting_util.format_amount(p_pool_rec.reporting_pool_limit,p_pool_rec.currency_code),

3922: p_pool_rec.subsidy_pool_name,
3923: p_pool_rec.pool_type_code,
3924: p_pool_rec.currency_code,
3925: okl_accounting_util.format_amount(0,p_pool_rec.currency_code), -- Pool Budget
3926: okl_accounting_util.format_amount(p_pool_rec.reporting_pool_limit,p_pool_rec.currency_code),
3927: okl_accounting_util.format_amount(l_trx_amt,p_pool_rec.currency_code),
3928: okl_accounting_util.format_amount(0,p_pool_rec.currency_code) -- Pool Balance
3929: );
3930: END IF;

Line 3927: okl_accounting_util.format_amount(l_trx_amt,p_pool_rec.currency_code),

3923: p_pool_rec.pool_type_code,
3924: p_pool_rec.currency_code,
3925: okl_accounting_util.format_amount(0,p_pool_rec.currency_code), -- Pool Budget
3926: okl_accounting_util.format_amount(p_pool_rec.reporting_pool_limit,p_pool_rec.currency_code),
3927: okl_accounting_util.format_amount(l_trx_amt,p_pool_rec.currency_code),
3928: okl_accounting_util.format_amount(0,p_pool_rec.currency_code) -- Pool Balance
3929: );
3930: END IF;
3931:

Line 3928: okl_accounting_util.format_amount(0,p_pool_rec.currency_code) -- Pool Balance

3924: p_pool_rec.currency_code,
3925: okl_accounting_util.format_amount(0,p_pool_rec.currency_code), -- Pool Budget
3926: okl_accounting_util.format_amount(p_pool_rec.reporting_pool_limit,p_pool_rec.currency_code),
3927: okl_accounting_util.format_amount(l_trx_amt,p_pool_rec.currency_code),
3928: okl_accounting_util.format_amount(0,p_pool_rec.currency_code) -- Pool Balance
3929: );
3930: END IF;
3931:
3932: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 4119: okl_accounting_util.format_amount(l_trx_amount,each_row.trx_currency_code)

4115: each_row.dnz_asset_number,
4116: each_row.Vendor,
4117: each_row.subsidy_name,
4118: each_row.source_trx_date,
4119: okl_accounting_util.format_amount(l_trx_amount,each_row.trx_currency_code)
4120: ||' '||each_row.trx_currency_code,
4121: each_row.conversion_rate,
4122: okl_accounting_util.format_amount(l_sub_pool_amount,each_row.subsidy_pool_currency_code)
4123: ||' '|| each_row.subsidy_pool_currency_code,

Line 4122: okl_accounting_util.format_amount(l_sub_pool_amount,each_row.subsidy_pool_currency_code)

4118: each_row.source_trx_date,
4119: okl_accounting_util.format_amount(l_trx_amount,each_row.trx_currency_code)
4120: ||' '||each_row.trx_currency_code,
4121: each_row.conversion_rate,
4122: okl_accounting_util.format_amount(l_sub_pool_amount,each_row.subsidy_pool_currency_code)
4123: ||' '|| each_row.subsidy_pool_currency_code,
4124: l_sub_pool_amount,
4125: each_row.operating_unit,
4126: each_row.subsidy_pool_currency_code

Line 4194: okl_accounting_util.format_amount(l_trx_amount,each_row.trx_currency_code)

4190: each_row.dnz_asset_number,
4191: each_row.Vendor,
4192: each_row.subsidy_name,
4193: each_row.source_trx_date,
4194: okl_accounting_util.format_amount(l_trx_amount,each_row.trx_currency_code)
4195: ||' '||each_row.trx_currency_code,
4196: l_conv_rate,
4197: okl_accounting_util.format_amount(l_sub_pool_amount,p_pool_currency)
4198: ||' '|| p_pool_currency,

Line 4197: okl_accounting_util.format_amount(l_sub_pool_amount,p_pool_currency)

4193: each_row.source_trx_date,
4194: okl_accounting_util.format_amount(l_trx_amount,each_row.trx_currency_code)
4195: ||' '||each_row.trx_currency_code,
4196: l_conv_rate,
4197: okl_accounting_util.format_amount(l_sub_pool_amount,p_pool_currency)
4198: ||' '|| p_pool_currency,
4199: l_sub_pool_amount,
4200: each_row.operating_unit,
4201: each_row.subsidy_pool_currency_code