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_PVT dependencies on PJI_UTILS

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

3530: ,
3531: (
3532: select 4 INVERT_ID from dual union all
3533: select 8 INVERT_ID from dual union all
3534: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
3535: ) invert
3536: ) collapse_bl
3537: ---- End of second inline view 'collapse_bl' ..........
3538: GROUP BY

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

4189: ,
4190: (
4191: SELECT 4 INVERT_ID FROM dual UNION ALL
4192: SELECT 8 INVERT_ID FROM dual UNION ALL
4193: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4194: ) invert
4195: ) collapse_bl
4196: ---- End of second inline view 'collapse_bl' ..........
4197: GROUP BY

Line 4358: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

4354: fetch c1 bulk collect into x_row_id limit 500000;
4355:
4356: If x_row_id.count > 0 then
4357: -- gather statistics for PJI metadata tables
4358: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4359: tabname => 'PJI_FP_AGGR_PJP1',
4360: percent => 5,
4361: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
4362:

Line 4361: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());

4357: -- gather statistics for PJI metadata tables
4358: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4359: tabname => 'PJI_FP_AGGR_PJP1',
4360: percent => 5,
4361: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
4362:
4363: -- gather statistics for PJI metadata tables
4364: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4365: tabname => 'PJI_FP_XBS_ACCUM_F',

Line 4364: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

4360: percent => 5,
4361: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
4362:
4363: -- gather statistics for PJI metadata tables
4364: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4365: tabname => 'PJI_FP_XBS_ACCUM_F',
4366: percent => 5,
4367: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
4368:

Line 4367: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());

4363: -- gather statistics for PJI metadata tables
4364: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4365: tabname => 'PJI_FP_XBS_ACCUM_F',
4366: percent => 5,
4367: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
4368:
4369:
4370: Forall i in x_row_id.first..x_row_id.last
4371: */

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

4886: WHERE worker_id = g_worker_id;
4887:
4888: print_time('........GET_GLOBAL_EXCHANGE_RATES: # rows deleted is: ' || SQL%ROWCOUNT );
4889:
4890: PJI_UTILS.g_max_roll_days := 1500; /*5155692 */
4891: -- Removed pa_resource_assignments join and Added joins with pji_org_extr_info
4892: -- for bug 4149422
4893: -- SQL for getting rates for time phased budgets.
4894: INSERT INTO PJI_FM_AGGR_DLY_RATES (

Line 4905: PJI_UTILS.GET_GLOBAL_RATE_PRIMARY (temp.projfunc_currency_code

4901: MAU2)
4902: select worker_id,
4903: projfunc_currency_code,
4904: time_id,
4905: PJI_UTILS.GET_GLOBAL_RATE_PRIMARY (temp.projfunc_currency_code
4906: , DECODE ( g_currency_conversion_rule
4907: , 'S'
4908: , temp.start_date
4909: , 'E'

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

4909: , 'E'
4910: , temp.end_date ))
4911: rate1,
4912: l_gl1_mau mau1,
4913: DECODE ( PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG'),
4914: 'Y',
4915: PJI_UTILS.GET_GLOBAL_RATE_SECONDARY(
4916: temp.projfunc_currency_code,
4917: DECODE ( g_currency_conversion_rule

Line 4915: PJI_UTILS.GET_GLOBAL_RATE_SECONDARY(

4911: rate1,
4912: l_gl1_mau mau1,
4913: DECODE ( PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG'),
4914: 'Y',
4915: PJI_UTILS.GET_GLOBAL_RATE_SECONDARY(
4916: temp.projfunc_currency_code,
4917: DECODE ( g_currency_conversion_rule
4918: , 'S'
4919: , temp.start_date

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

4990: AND ver.project_id = ppa.project_id
4991: AND ver.worker_id = g_worker_id
4992: ) temp;
4993:
4994: PJI_UTILS.g_max_roll_days := NULL; /*5155692 */
4995:
4996: UPDATE /*+ INDEX(prd,pji_time_cal_period_u1) index(rates, PJI_FM_AGGR_DLY_RATES_N1) */
4997: PJI_FM_EXTR_PLNVER4 ver
4998: SET rate_dangling_flag = 'Y'

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

8674: ---- end of third inline view 'spread_bl'...........
8675: ,
8676: (
8677: select 1 INVERT_ID from dual union all
8678: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
8679: select 4 INVERT_ID from dual union all
8680: select 8 INVERT_ID from dual union all
8681: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
8682: ) invert

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

8677: select 1 INVERT_ID from dual union all
8678: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
8679: select 4 INVERT_ID from dual union all
8680: select 8 INVERT_ID from dual union all
8681: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
8682: ) invert
8683: ) collapse_bl
8684: ---- End of second inline view 'collapse_bl' ..........
8685: GROUP BY

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

9809: ---- end of third inline view 'spread_bl'...........
9810: ,
9811: (
9812: select 1 INVERT_ID from dual union all
9813: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
9814: select 4 INVERT_ID from dual union all
9815: select 8 INVERT_ID from dual union all
9816: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
9817: ) invert

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

9812: select 1 INVERT_ID from dual union all
9813: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
9814: select 4 INVERT_ID from dual union all
9815: select 8 INVERT_ID from dual union all
9816: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
9817: ) invert
9818: ) collapse_bl -- WHERE wbs_element_id = 7474 -- and rbs_element_id = 10266 -- and budget_version_id = 2909
9819: ---- End of second inline view 'collapse_bl' ..........
9820: GROUP BY

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

10473: ,
10474: (
10475: SELECT 4 INVERT_ID FROM dual UNION ALL
10476: SELECT 8 INVERT_ID FROM dual UNION ALL
10477: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
10478: ) invert
10479: ) collapse_bl
10480: ---- End of second inline view 'collapse_bl' ..........
10481: GROUP BY

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

11050: ,
11051: (
11052: SELECT 4 INVERT_ID FROM dual UNION ALL
11053: SELECT 8 INVERT_ID FROM dual UNION ALL
11054: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
11055: ) invert
11056: ) collapse_bl
11057: ---- End of second inline view 'collapse_bl' ..........
11058: GROUP BY

Line 11238: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

11234: fetch c1 bulk collect into x_row_id limit 500000;
11235:
11236: If x_row_id.count > 0 then
11237: -- gather statistics for PJI metadata tables
11238: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
11239: tabname => 'PJI_FP_AGGR_PJP1',
11240: percent => 5,
11241: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
11242:

Line 11241: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());

11237: -- gather statistics for PJI metadata tables
11238: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
11239: tabname => 'PJI_FP_AGGR_PJP1',
11240: percent => 5,
11241: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
11242:
11243: -- gather statistics for PJI metadata tables
11244: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
11245: tabname => 'PJI_FP_XBS_ACCUM_F',

Line 11244: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

11240: percent => 5,
11241: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
11242:
11243: -- gather statistics for PJI metadata tables
11244: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
11245: tabname => 'PJI_FP_XBS_ACCUM_F',
11246: percent => 5,
11247: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
11248:

Line 11247: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());

11243: -- gather statistics for PJI metadata tables
11244: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
11245: tabname => 'PJI_FP_XBS_ACCUM_F',
11246: percent => 5,
11247: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
11248:
11249:
11250: Forall i in x_row_id.first..x_row_id.last
11251: MERGE INTO PJI_FP_XBS_ACCUM_F fact