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_TRX_SUBSIDY_POOLS

Line 481: FROM okl_trx_subsidy_pools

477: -- subsidy_pool_amount,
478: --END : 02-NOV-05 cklee - Fixed bug#4705629 |
479: source_trx_date,
480: trx_date
481: FROM okl_trx_subsidy_pools
482: WHERE subsidy_pool_id = cp_pool_id
483: AND TRUNC(source_trx_date) <= NVL(TRUNC(cp_to_date), TRUNC(source_trx_date));
484:
485: l_trx_amount NUMBER ;

Line 711: l_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE ;

707: START WITH id = cp_pool_id;
708:
709: l_total_budget okl_subsidy_pools_b.total_budgets%TYPE;
710: l_budget okl_subsidy_pools_b.total_budgets%TYPE;
711: l_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE ;
712: l_trx_amt okl_trx_subsidy_pools.trx_amount%TYPE ;
713: l_remaining_balance okl_subsidy_pools_b.total_budgets%TYPE;
714: l_conv_rate NUMBER;
715: l_Pool_Name_len CONSTANT NUMBER DEFAULT 30;

Line 712: l_trx_amt okl_trx_subsidy_pools.trx_amount%TYPE ;

708:
709: l_total_budget okl_subsidy_pools_b.total_budgets%TYPE;
710: l_budget okl_subsidy_pools_b.total_budgets%TYPE;
711: l_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE ;
712: l_trx_amt okl_trx_subsidy_pools.trx_amount%TYPE ;
713: l_remaining_balance okl_subsidy_pools_b.total_budgets%TYPE;
714: l_conv_rate NUMBER;
715: l_Pool_Name_len CONSTANT NUMBER DEFAULT 30;
716: l_Pool_Type_len CONSTANT NUMBER DEFAULT 30;

Line 1030: l_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE;

1026: CONNECT BY PRIOR id = subsidy_pool_id
1027: START WITH id = cp_pool_id;
1028:
1029: l_total_budget okl_subsidy_pools_b.total_budgets%TYPE;
1030: l_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE;
1031: l_budget okl_subsidy_pools_b.total_budgets%TYPE;
1032: l_trx_amt okl_trx_subsidy_pools.trx_amount%TYPE;
1033: l_remaining_balance okl_subsidy_pools_b.total_budgets%TYPE;
1034: l_conv_rate NUMBER;

Line 1032: l_trx_amt okl_trx_subsidy_pools.trx_amount%TYPE;

1028:
1029: l_total_budget okl_subsidy_pools_b.total_budgets%TYPE;
1030: l_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE;
1031: l_budget okl_subsidy_pools_b.total_budgets%TYPE;
1032: l_trx_amt okl_trx_subsidy_pools.trx_amount%TYPE;
1033: l_remaining_balance okl_subsidy_pools_b.total_budgets%TYPE;
1034: l_conv_rate NUMBER;
1035: l_Pool_Name_len CONSTANT NUMBER DEFAULT 30;
1036: l_Pool_Type_len CONSTANT NUMBER DEFAULT 30;

Line 1296: l_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE ;

1292: k NUMBER ;
1293: l_count NUMBER ;
1294: l_pool_rec okl_sub_pool_rec;
1295: l_total_budget okl_subsidy_pools_b.total_budgets%TYPE ;
1296: l_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE ;
1297: l_remaining_balance okl_subsidy_pools_b.total_budgets%TYPE;
1298: l_api_name CONSTANT VARCHAR2(30) := 'POOL_ASSOC_REPORT';
1299: l_msg_count NUMBER;
1300: l_msg_data VARCHAR2(2000);

Line 1548: l_trx_amt okl_trx_subsidy_pools.trx_amount%TYPE ;

1544: CONNECT BY PRIOR id = subsidy_pool_id
1545: START WITH id = cp_pool_id;
1546:
1547: l_budget okl_subsidy_pools_b.total_budgets%TYPE;
1548: l_trx_amt okl_trx_subsidy_pools.trx_amount%TYPE ;
1549: l_amount okl_trx_subsidy_pools.trx_amount%TYPE ;
1550: l_remaining_balance okl_subsidy_pools_b.total_budgets%TYPE;
1551: l_Pool_Name_len CONSTANT NUMBER DEFAULT 30;
1552: l_Pool_Type_len CONSTANT NUMBER DEFAULT 30;

Line 1549: l_amount okl_trx_subsidy_pools.trx_amount%TYPE ;

1545: START WITH id = cp_pool_id;
1546:
1547: l_budget okl_subsidy_pools_b.total_budgets%TYPE;
1548: l_trx_amt okl_trx_subsidy_pools.trx_amount%TYPE ;
1549: l_amount okl_trx_subsidy_pools.trx_amount%TYPE ;
1550: l_remaining_balance okl_subsidy_pools_b.total_budgets%TYPE;
1551: l_Pool_Name_len CONSTANT NUMBER DEFAULT 30;
1552: l_Pool_Type_len CONSTANT NUMBER DEFAULT 30;
1553: l_Currency_Code_len CONSTANT NUMBER DEFAULT 15;

Line 1603: -- from the okl_trx_subsidy_pools table.

1599: END IF;
1600:
1601: -- If subsidy pool type is "Budget" then pick the values for total budgets
1602: -- from the okl_subsidy_pools_b table and calculate the total transaction amount
1603: -- from the okl_trx_subsidy_pools table.
1604: IF (p_pool_rec.pool_type_code = 'BUDGET') THEN
1605: -- Parent pool header with the parent pool name.
1606: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1607: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));

Line 1834: FROM okl_trx_subsidy_pools pool,

1830: trx_date,
1831: -- abindal start bug# 4873705 --
1832: hru.name operating_unit
1833: -- abindal end bug# 4873705 --
1834: FROM okl_trx_subsidy_pools pool,
1835: fnd_lookups flk1,
1836: po_vendors vend,
1837: okl_subsidies_b sub,
1838: -- abindal start bug# 4873705 --

Line 2884: l_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE ;

2880: x_retcode NUMBER;
2881: x_pool_dtl_rec pool_dtl_rec_type;
2882: l_total_budget okl_subsidy_pools_b.total_budgets%TYPE;
2883: l_budget okl_subsidy_pools_b.total_budgets%TYPE;
2884: l_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE ;
2885: l_trx_amt okl_trx_subsidy_pools.trx_amount%TYPE ;
2886: l_remaining_balance okl_subsidy_pools_b.total_budgets%TYPE;
2887: l_conv_rate NUMBER;
2888: l_reporting_limit okl_subsidy_pools_b.reporting_pool_limit%TYPE ;

Line 2885: l_trx_amt okl_trx_subsidy_pools.trx_amount%TYPE ;

2881: x_pool_dtl_rec pool_dtl_rec_type;
2882: l_total_budget okl_subsidy_pools_b.total_budgets%TYPE;
2883: l_budget okl_subsidy_pools_b.total_budgets%TYPE;
2884: l_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE ;
2885: l_trx_amt okl_trx_subsidy_pools.trx_amount%TYPE ;
2886: l_remaining_balance okl_subsidy_pools_b.total_budgets%TYPE;
2887: l_conv_rate NUMBER;
2888: l_reporting_limit okl_subsidy_pools_b.reporting_pool_limit%TYPE ;
2889: l_api_name CONSTANT VARCHAR2(30) := 'GET_POOL_AMOUNTS';

Line 3123: l_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE ;

3119: l_pool_rec okl_sub_pool_rec;
3120: l_chld_pool_rec okl_sub_pool_rec;
3121: l_input_pool_rec okl_sub_pool_rec;
3122: l_total_budget okl_subsidy_pools_b.total_budgets%TYPE ;
3123: l_trx_amount okl_trx_subsidy_pools.trx_amount%TYPE ;
3124: l_remaining_balance okl_subsidy_pools_b.total_budgets%TYPE;
3125: l_api_name CONSTANT VARCHAR2(30) := 'XML_POOL_ASSOC_REPORT';
3126: l_msg_count NUMBER;
3127: l_msg_data VARCHAR2(2000);

Line 3774: l_trx_amt okl_trx_subsidy_pools.trx_amount%TYPE ;

3770:
3771: x_errbuf VARCHAR2(1000);
3772: x_retcode NUMBER;
3773: l_budget okl_subsidy_pools_b.total_budgets%TYPE;
3774: l_trx_amt okl_trx_subsidy_pools.trx_amount%TYPE ;
3775: l_amount okl_trx_subsidy_pools.trx_amount%TYPE ;
3776: l_remaining_balance okl_subsidy_pools_b.total_budgets%TYPE;
3777: l_api_name CONSTANT VARCHAR2(30) := 'xml_print_pool_summary';
3778: l_msg_count NUMBER;

Line 3775: l_amount okl_trx_subsidy_pools.trx_amount%TYPE ;

3771: x_errbuf VARCHAR2(1000);
3772: x_retcode NUMBER;
3773: l_budget okl_subsidy_pools_b.total_budgets%TYPE;
3774: l_trx_amt okl_trx_subsidy_pools.trx_amount%TYPE ;
3775: l_amount okl_trx_subsidy_pools.trx_amount%TYPE ;
3776: l_remaining_balance okl_subsidy_pools_b.total_budgets%TYPE;
3777: l_api_name CONSTANT VARCHAR2(30) := 'xml_print_pool_summary';
3778: l_msg_count NUMBER;
3779: l_msg_data VARCHAR2(2000);

Line 3821: -- from the okl_trx_subsidy_pools table.

3817: END IF;
3818:
3819: -- If subsidy pool type is "Budget" then pick the values for total budgets
3820: -- from the okl_subsidy_pools_b table and calculate the total transaction amount
3821: -- from the okl_trx_subsidy_pools table.
3822: IF (p_pool_rec.pool_type_code = 'BUDGET') THEN
3823: -- Parent pool header with the parent pool name.
3824: -- Calculate the total budgets for subsidy pool till the date specified.
3825: l_budget := total_budgets( p_pool_rec.id,

Line 4015: FROM okl_trx_subsidy_pools pool,

4011: pool.conversion_rate,
4012: subsidy_pool_amount,
4013: trx_date,
4014: hru.name operating_unit
4015: FROM okl_trx_subsidy_pools pool,
4016: fnd_lookups flk1,
4017: po_vendors vend,
4018: okl_subsidies_b sub,
4019: hr_organization_units hru