APPS.PJI_PJP_GEN_PERF_ALL dependencies on PJI_UTILS

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

517: ,
518: (
519: SELECT 4 INVERT_ID FROM dual UNION ALL
520: SELECT 8 INVERT_ID FROM dual UNION ALL
521: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
522: ) invert
523: ) collapse_bl
524: ---- End of second inline view 'collapse_bl' ..........
525: GROUP BY

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

1139: ,
1140: (
1141: SELECT 4 INVERT_ID FROM dual UNION ALL
1142: SELECT 8 INVERT_ID FROM dual UNION ALL
1143: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
1144: ) invert
1145: ) collapse_bl
1146: ---- End of second inline view 'collapse_bl' ..........
1147: GROUP BY

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

1582: ,
1583: (
1584: SELECT 4 INVERT_ID FROM dual UNION ALL
1585: SELECT 8 INVERT_ID FROM dual UNION ALL
1586: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
1587: ) invert
1588: ) collapse_bl
1589: ---- End of second inline view 'collapse_bl' ..........
1590: GROUP BY

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

3130: l_level := p_level;
3131: l_partial_mode := p_partial_mode;
3132: l_fpm_upgrade := p_fpm_upgrade;
3133:
3134: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3135: tabname => 'PJI_FP_AGGR_PJP1',
3136: percent => 10,
3137: degree => PJI_UTILS.
3138: GET_DEGREE_OF_PARALLELISM);

Line 3137: degree => PJI_UTILS.

3133:
3134: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3135: tabname => 'PJI_FP_AGGR_PJP1',
3136: percent => 10,
3137: degree => PJI_UTILS.
3138: GET_DEGREE_OF_PARALLELISM);
3139:
3140: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3141: tabname => 'PJI_PJP_WBS_HEADER',

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

3136: percent => 10,
3137: degree => PJI_UTILS.
3138: GET_DEGREE_OF_PARALLELISM);
3139:
3140: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3141: tabname => 'PJI_PJP_WBS_HEADER',
3142: percent => 10,
3143: degree => PJI_UTILS.
3144: GET_DEGREE_OF_PARALLELISM);

Line 3143: degree => PJI_UTILS.

3139:
3140: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3141: tabname => 'PJI_PJP_WBS_HEADER',
3142: percent => 10,
3143: degree => PJI_UTILS.
3144: GET_DEGREE_OF_PARALLELISM);
3145:
3146: if (p_worker_id =1) then
3147: -- Query for Partition 1