129: l_round_amount NUMBER ;
130: l_amount NUMBER ;
131: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CURRENCY_CONVERSION';
132: l_conv_date DATE ;
133: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_RPT_PVT.CURRENCY_CONVERSION';
134: l_debug_enabled VARCHAR2(10);
135: is_debug_procedure_on BOOLEAN;
136: is_debug_statement_on BOOLEAN;
137:
315: l_msg_data VARCHAR2(2000);
316: l_return_status VARCHAR2(1);
317: l_api_version NUMBER ;
318: l_init_msg_list VARCHAR2(1) ;
319: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_RPT_PVT.TOTAL_BUDGETS';
320: l_debug_enabled VARCHAR2(10);
321: is_debug_procedure_on BOOLEAN;
322: is_debug_statement_on BOOLEAN;
323: BEGIN
490: l_msg_data VARCHAR2(2000);
491: l_return_status VARCHAR2(1);
492: l_api_version NUMBER ;
493: l_init_msg_list VARCHAR2(1);
494: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_RPT_PVT.TRANSACTION_AMOUNT';
495: l_debug_enabled VARCHAR2(10);
496: is_debug_procedure_on BOOLEAN;
497: is_debug_statement_on BOOLEAN;
498:
725: l_msg_data VARCHAR2(2000);
726: l_return_status VARCHAR2(1);
727: l_api_version NUMBER ;
728: l_init_msg_list VARCHAR2(1);
729: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_RPT_PVT.PRINT_PARENT_RECORD';
730: l_debug_enabled VARCHAR2(10);
731: is_debug_procedure_on BOOLEAN;
732: is_debug_statement_on BOOLEAN;
733:
1046: l_msg_data VARCHAR2(2000);
1047: l_return_status VARCHAR2(1);
1048: l_api_version NUMBER;
1049: l_init_msg_list VARCHAR2(1);
1050: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_RPT_PVT.PRINT_CHILD_RECORD';
1051: l_debug_enabled VARCHAR2(10);
1052: is_debug_procedure_on BOOLEAN;
1053: is_debug_statement_on BOOLEAN;
1054:
1303: l_init_msg_list VARCHAR2(1);
1304: --length
1305: l_total_length CONSTANT NUMBER DEFAULT 152;
1306: l_sysdate DATE ;
1307: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_RPT_PVT.POOL_ASSOC_REPORT';
1308: l_debug_enabled VARCHAR2(10);
1309: is_debug_procedure_on BOOLEAN;
1310: is_debug_statement_on BOOLEAN;
1311:
1561: l_msg_data VARCHAR2(2000);
1562: l_return_status VARCHAR2(1);
1563: l_api_version NUMBER;
1564: l_init_msg_list VARCHAR2(1);
1565: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_RPT_PVT.PRINT_POOL_SUMMARY';
1566: l_debug_enabled VARCHAR2(10);
1567: is_debug_procedure_on BOOLEAN;
1568: is_debug_statement_on BOOLEAN;
1569:
1890: l_msg_data VARCHAR2(2000);
1891: l_return_status VARCHAR2(1);
1892: l_api_version NUMBER;
1893: l_init_msg_list VARCHAR2(1);
1894: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_RPT_PVT.PRINT_TRANSACTION_SUMMARY';
1895: l_debug_enabled VARCHAR2(10);
1896: is_debug_procedure_on BOOLEAN;
1897: is_debug_statement_on BOOLEAN;
1898:
2146: l_count NUMBER;
2147: --length
2148: l_total_length CONSTANT NUMBER DEFAULT 152;
2149: l_sysdate DATE;
2150: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_RPT_PVT.POOL_RECONC_REPORT';
2151: l_debug_enabled VARCHAR2(10);
2152: is_debug_procedure_on BOOLEAN;
2153: is_debug_statement_on BOOLEAN;
2154:
2421: l_percent_len CONSTANT NUMBER DEFAULT 30;
2422: l_effective_to_len CONSTANT NUMBER DEFAULT 20;
2423: l_remaining_days_len CONSTANT NUMBER DEFAULT 20;
2424: l_total_length CONSTANT NUMBER DEFAULT 152;
2425: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_RPT_PVT.PRINT_ATLIMIT_DETAIL';
2426: l_debug_enabled VARCHAR2(10);
2427: is_debug_procedure_on BOOLEAN;
2428: is_debug_statement_on BOOLEAN;
2429: l_parameter_list WF_PARAMETER_LIST_T;
2696: l_return_status VARCHAR2(1);
2697: l_api_version NUMBER;
2698: l_init_msg_list VARCHAR2(1);
2699: l_total_length CONSTANT NUMBER DEFAULT 152;
2700: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_RPT_PVT.POOL_ATLIMIT_REPORT';
2701: l_debug_enabled VARCHAR2(10);
2702: is_debug_procedure_on BOOLEAN;
2703: is_debug_statement_on BOOLEAN;
2704:
2891: l_msg_data VARCHAR2(2000);
2892: l_return_status VARCHAR2(1);
2893: l_api_version NUMBER ;
2894: l_init_msg_list VARCHAR2(1);
2895: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_RPT_PVT.GET_POOL_AMOUNTS';
2896: l_debug_enabled VARCHAR2(10);
2897: is_debug_procedure_on BOOLEAN;
2898: is_debug_statement_on BOOLEAN;
2899:
3128: l_return_status VARCHAR2(1);
3129: l_api_version NUMBER;
3130: l_init_msg_list VARCHAR2(1);
3131: l_sysdate DATE ;
3132: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_RPT_PVT.XML_POOL_ASSOC_REPORT';
3133: l_debug_enabled VARCHAR2(10);
3134: is_debug_procedure_on BOOLEAN;
3135: is_debug_statement_on BOOLEAN;
3136:
3421: x_return_status VARCHAR2(1);
3422: x_msg_count NUMBER;
3423: x_msg_data VARCHAR2(2000);
3424: l_date DATE;
3425: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_RPT_PVT.XML_PRINT_ATLIMIT_DETAIL';
3426: l_debug_enabled VARCHAR2(10);
3427: is_debug_procedure_on BOOLEAN;
3428: is_debug_statement_on BOOLEAN;
3429: l_parameter_list WF_PARAMETER_LIST_T;
3779: l_msg_data VARCHAR2(2000);
3780: l_return_status VARCHAR2(1);
3781: l_api_version NUMBER;
3782: l_init_msg_list VARCHAR2(1);
3783: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_RPT_PVT.xml_print_pool_summary';
3784: l_debug_enabled VARCHAR2(10);
3785: is_debug_procedure_on BOOLEAN;
3786: is_debug_statement_on BOOLEAN;
3787:
4042: l_msg_data VARCHAR2(2000);
4043: l_return_status VARCHAR2(1);
4044: l_api_version NUMBER;
4045: l_init_msg_list VARCHAR2(1);
4046: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_RPT_PVT.xml_print_transaction_summary';
4047: l_debug_enabled VARCHAR2(10);
4048: is_debug_procedure_on BOOLEAN;
4049: is_debug_statement_on BOOLEAN;
4050:
4266: l_api_version NUMBER;
4267: l_init_msg_list VARCHAR2(1);
4268: l_count NUMBER;
4269: l_sysdate DATE;
4270: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_RPT_PVT.XML_POOL_RECONC_REPORT';
4271: l_debug_enabled VARCHAR2(10);
4272: is_debug_procedure_on BOOLEAN;
4273: is_debug_statement_on BOOLEAN;
4274: