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.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_UTILS

Line 1805: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

1801: ,
1802: (
1803: select 4 INVERT_ID from dual union all
1804: select 8 INVERT_ID from dual union all
1805: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
1806: ) invert
1807: ) collapse_bl
1808: ---- End of second inline view 'collapse_bl' ..........
1809: GROUP BY

Line 2883: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all

2879: ---- end of third inline view 'spread_bl'...........
2880: ,
2881: (
2882: select 1 INVERT_ID from dual union all
2883: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
2884: select 4 INVERT_ID from dual union all
2885: select 8 INVERT_ID from dual union all
2886: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
2887: ) invert

Line 2886: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

2882: select 1 INVERT_ID from dual union all
2883: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
2884: select 4 INVERT_ID from dual union all
2885: select 8 INVERT_ID from dual union all
2886: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
2887: ) invert
2888: ) collapse_bl
2889: ---- End of second inline view 'collapse_bl' ..........
2890: GROUP BY

Line 3901: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all

3897: ---- end of third inline view 'spread_bl'...........
3898: ,
3899: (
3900: select 1 INVERT_ID from dual union all
3901: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
3902: select 4 INVERT_ID from dual union all
3903: select 8 INVERT_ID from dual union all
3904: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
3905: ) invert

Line 3904: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

3900: select 1 INVERT_ID from dual union all
3901: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
3902: select 4 INVERT_ID from dual union all
3903: select 8 INVERT_ID from dual union all
3904: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
3905: ) invert
3906: ) collapse_bl -- WHERE wbs_element_id = 7474 -- and rbs_element_id = 10266 -- and budget_version_id = 2909
3907: ---- End of second inline view 'collapse_bl' ..........
3908: GROUP BY

Line 4874: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

4870: ,
4871: (
4872: select 4 INVERT_ID from dual union all
4873: select 8 INVERT_ID from dual union all
4874: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4875: ) invert
4876: ) collapse_bl
4877: ---- End of second inline view 'collapse_bl' ..........
4878: GROUP BY

Line 5064: PJI_UTILS.g_max_roll_days := 1500; /5155692 /

5060: WHERE worker_id = g_worker_id;
5061: -- Removed pa_resource_assignments join and Added joins with pji_org_extr_info
5062: -- for bug 4149422
5063: -- SQL for getting rates for time phased budgets.
5064: PJI_UTILS.g_max_roll_days := 1500; /*5155692 */
5065:
5066: INSERT INTO PJI_FM_AGGR_DLY_RATES_T (
5067: WORKER_ID ,
5068: PF_CURRENCY_CODE ,

Line 5077: PJI_UTILS.GET_GLOBAL_RATE_PRIMARY (temp.projfunc_currency_code

5073: MAU2)
5074: SELECT worker_id,
5075: projfunc_currency_code,
5076: time_id,
5077: PJI_UTILS.GET_GLOBAL_RATE_PRIMARY (temp.projfunc_currency_code
5078: , DECODE ( g_currency_conversion_rule
5079: , 'S'
5080: , temp.start_date
5081: , 'E'

Line 5085: DECODE ( PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG'),

5081: , 'E'
5082: , temp.end_date ))
5083: rate1,
5084: l_gl1_mau mau1,
5085: DECODE ( PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG'),
5086: 'Y',
5087: PJI_UTILS.GET_GLOBAL_RATE_SECONDARY (temp.projfunc_currency_code,
5088: DECODE ( g_currency_conversion_rule
5089: , 'S'

Line 5087: PJI_UTILS.GET_GLOBAL_RATE_SECONDARY (temp.projfunc_currency_code,

5083: rate1,
5084: l_gl1_mau mau1,
5085: DECODE ( PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG'),
5086: 'Y',
5087: PJI_UTILS.GET_GLOBAL_RATE_SECONDARY (temp.projfunc_currency_code,
5088: DECODE ( g_currency_conversion_rule
5089: , 'S'
5090: , temp.start_date
5091: , 'E'

Line 5166: PJI_UTILS.g_max_roll_days := NULL; /5155692 /

5162: AND ver.time_phased_type_code = 'N'
5163: AND ver.project_id = ppa.project_id
5164: ) temp;
5165:
5166: PJI_UTILS.g_max_roll_days := NULL; /*5155692 */
5167:
5168: /* See if any line with negative rate was derived. If so then update the
5169: corresponding line in ver3 as rate dangling*/
5170:

Line 7158: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

7154: ,
7155: (
7156: SELECT 4 INVERT_ID FROM dual UNION ALL
7157: SELECT 8 INVERT_ID FROM dual UNION ALL
7158: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
7159: ) invert
7160: ) collapse_bl
7161: ---- End of second inline view 'collapse_bl' ..........
7162: GROUP BY