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 1818: l_up_process_flag := PJI_UTILS.GET_SETUP_PARAMETER('UP_PROCESS_FLAG');

1814: END IF;
1815:
1816: /* Added for bug 8708651 starts */
1817: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');
1818: l_up_process_flag := PJI_UTILS.GET_SETUP_PARAMETER('UP_PROCESS_FLAG');
1819: /* Added for bug 8708651 ends */
1820:
1821: --#bug 5356051
1822: begin

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

4682: ,
4683: (
4684: select 4 INVERT_ID from dual union all
4685: select 8 INVERT_ID from dual union all
4686: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4687: ) invert
4688: ) collapse_bl
4689: ---- End of second inline view 'collapse_bl' ..........
4690: GROUP BY

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

5360: ,
5361: (
5362: SELECT 4 INVERT_ID FROM dual UNION ALL
5363: SELECT 8 INVERT_ID FROM dual UNION ALL
5364: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
5365: ) invert
5366: ) collapse_bl
5367: ---- End of second inline view 'collapse_bl' ..........
5368: GROUP BY

Line 5524: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

5520: BEGIN
5521:
5522: IF ( p_slice_type IS NULL ) THEN
5523:
5524: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
5525:
5526: PJI_PJP_PRG_PERF_ALL.INSERT_INTO_FP_FACT;
5527:
5528: else

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

5535: fetch c1 bulk collect into x_row_id limit 500000;
5536:
5537: If x_row_id.count > 0 then
5538: -- gather statistics for PJI metadata tables
5539: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
5540: tabname => 'PJI_FP_AGGR_PJP1',
5541: percent => 5,
5542: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
5543:

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

5538: -- gather statistics for PJI metadata tables
5539: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
5540: tabname => 'PJI_FP_AGGR_PJP1',
5541: percent => 5,
5542: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
5543:
5544: -- gather statistics for PJI metadata tables
5545: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
5546: tabname => 'PJI_FP_XBS_ACCUM_F',

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

5541: percent => 5,
5542: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
5543:
5544: -- gather statistics for PJI metadata tables
5545: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
5546: tabname => 'PJI_FP_XBS_ACCUM_F',
5547: percent => 5,
5548: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
5549:

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

5544: -- gather statistics for PJI metadata tables
5545: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
5546: tabname => 'PJI_FP_XBS_ACCUM_F',
5547: percent => 5,
5548: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
5549:
5550:
5551: Forall i in x_row_id.first..x_row_id.last
5552: */

Line 6045: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

6041:
6042: BEGIN
6043:
6044: /* Added for bug 13030627 */
6045: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
6046:
6047: PJI_PJP_PRG_PERF_ALL.GET_GLOBAL_EXCHANGE_RATES;
6048:
6049: else

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

6077: WHERE worker_id = g_worker_id;
6078:
6079: print_time('........GET_GLOBAL_EXCHANGE_RATES: # rows deleted is: ' || SQL%ROWCOUNT );
6080:
6081: PJI_UTILS.g_max_roll_days := 1500; /*5155692 */
6082: -- Removed pa_resource_assignments join and Added joins with pji_org_extr_info
6083: -- for bug 4149422
6084: -- SQL for getting rates for time phased budgets.
6085: INSERT INTO PJI_FM_AGGR_DLY_RATES (

Line 6096: PJI_UTILS.GET_GLOBAL_RATE_PRIMARY (temp.projfunc_currency_code

6092: MAU2)
6093: select worker_id,
6094: projfunc_currency_code,
6095: time_id,
6096: PJI_UTILS.GET_GLOBAL_RATE_PRIMARY (temp.projfunc_currency_code
6097: , DECODE ( g_currency_conversion_rule
6098: , 'S'
6099: , temp.start_date
6100: , 'E'

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

6100: , 'E'
6101: , temp.end_date ))
6102: rate1,
6103: l_gl1_mau mau1,
6104: DECODE ( PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG'),
6105: 'Y',
6106: PJI_UTILS.GET_GLOBAL_RATE_SECONDARY(
6107: temp.projfunc_currency_code,
6108: DECODE ( g_currency_conversion_rule

Line 6106: PJI_UTILS.GET_GLOBAL_RATE_SECONDARY(

6102: rate1,
6103: l_gl1_mau mau1,
6104: DECODE ( PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG'),
6105: 'Y',
6106: PJI_UTILS.GET_GLOBAL_RATE_SECONDARY(
6107: temp.projfunc_currency_code,
6108: DECODE ( g_currency_conversion_rule
6109: , 'S'
6110: , temp.start_date

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

6181: AND ver.project_id = ppa.project_id
6182: AND ver.worker_id = g_worker_id
6183: ) temp;
6184:
6185: PJI_UTILS.g_max_roll_days := NULL; /*5155692 */
6186:
6187: UPDATE /*+ INDEX(prd,pji_time_cal_period_u1) index(rates, PJI_FM_AGGR_DLY_RATES_N1) */
6188: PJI_FM_EXTR_PLNVER4 ver
6189: SET rate_dangling_flag = 'Y'

Line 6465: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

6461: l_calendar_type VARCHAR2(15) := 'E';
6462: BEGIN
6463:
6464: /* Added for bug 13030627 */
6465: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
6466:
6467: PJI_PJP_PRG_PERF_ALL.PRORATE_TO_ENT;
6468:
6469: else

Line 8397: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

8393:
8394: BEGIN
8395:
8396: /* Added for bug 13030627 */
8397: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
8398:
8399: PJI_PJP_PRG_PERF_ALL.POPULATE_RBS_HDR;
8400:
8401: else

Line 8543: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

8539:
8540: BEGIN
8541:
8542: /* Added for bug 13030627 */
8543: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
8544:
8545: PJI_PJP_PRG_PERF_ALL.UPDATE_WBS_HDR;
8546:
8547: else

Line 8631: l_up_process_flag := PJI_UTILS.GET_SETUP_PARAMETER('UP_PROCESS_FLAG');

8627:
8628: BEGIN
8629:
8630: -- Added for bug 9108728
8631: l_up_process_flag := PJI_UTILS.GET_SETUP_PARAMETER('UP_PROCESS_FLAG');
8632: --
8633: -- On PA_BUDGET_VERSIONS, the PJI_SUMMARIZED_FLAG can have four values:
8634: -- 'N' the plan version has not been summarized
8635: -- 'P' the plan version has been partially summarized due to dangling currency or calendar records

Line 9963: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */

9959: ) spread_bl
9960: ---- end of third inline view 'spread_bl'...........
9961: ,
9962: (
9963: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
9964: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
9965: select 4 INVERT_ID from dual union all
9966: select 8 INVERT_ID from dual union all
9967: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

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

9960: ---- end of third inline view 'spread_bl'...........
9961: ,
9962: (
9963: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
9964: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
9965: select 4 INVERT_ID from dual union all
9966: select 8 INVERT_ID from dual union all
9967: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
9968: ) invert

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

9963: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
9964: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
9965: select 4 INVERT_ID from dual union all
9966: select 8 INVERT_ID from dual union all
9967: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
9968: ) invert
9969: ) collapse_bl
9970: ---- End of second inline view 'collapse_bl' ..........
9971: GROUP BY

Line 10065: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

10061: IS
10062: BEGIN
10063:
10064: /* Added for bug 13030627 */
10065: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
10066:
10067: PJI_PJP_PRG_PERF_ALL.EXTRACT_PLAN_AMTS_PRIRBS_GLC12;
10068:
10069: else

Line 11123: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */

11119: ) spread_bl
11120: ---- end of third inline view 'spread_bl'...........
11121: ,
11122: (
11123: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
11124: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
11125: select 4 INVERT_ID from dual union all
11126: select 8 INVERT_ID from dual union all
11127: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

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

11120: ---- end of third inline view 'spread_bl'...........
11121: ,
11122: (
11123: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
11124: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
11125: select 4 INVERT_ID from dual union all
11126: select 8 INVERT_ID from dual union all
11127: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
11128: ) invert

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

11123: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
11124: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
11125: select 4 INVERT_ID from dual union all
11126: select 8 INVERT_ID from dual union all
11127: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
11128: ) invert
11129: ) collapse_bl -- WHERE wbs_element_id = 7474 -- and rbs_element_id = 10266 -- and budget_version_id = 2909
11130: ---- End of second inline view 'collapse_bl' ..........
11131: GROUP BY

Line 11225: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

11221: PROCEDURE EXTRACT_DANGL_REVERSAL IS
11222: BEGIN
11223:
11224: /* Added for bug 13030627 */
11225: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
11226:
11227: PJI_PJP_PRG_PERF_ALL.EXTRACT_DANGL_REVERSAL;
11228:
11229: else -- Else Added for bug 13790186 (checkin 13107651) -- Missed in bug 13030627

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

11805: ,
11806: (
11807: SELECT 4 INVERT_ID FROM dual UNION ALL
11808: SELECT 8 INVERT_ID FROM dual UNION ALL
11809: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
11810: ) invert
11811: ) collapse_bl
11812: ---- End of second inline view 'collapse_bl' ..........
11813: GROUP BY

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

12404: ,
12405: (
12406: SELECT 4 INVERT_ID FROM dual UNION ALL
12407: SELECT 8 INVERT_ID FROM dual UNION ALL
12408: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
12409: ) invert
12410: ) collapse_bl
12411: ---- End of second inline view 'collapse_bl' ..........
12412: GROUP BY

Line 12531: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

12527:
12528: BEGIN
12529:
12530: /* Added for bug 13030627 */
12531: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
12532:
12533: PJI_PJP_PRG_PERF_ALL.UPDATE_WBS_HDR_1;
12534:
12535: else

Line 12644: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

12640: commit;
12641: /*Bug Fix 9212516*/
12642:
12643: /* Added for bug 13030627 */
12644: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
12645:
12646: PJI_PJP_PRG_PERF_ALL.MERGE_INTO_FP_FACTS;
12647:
12648: else

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

12680: /*Bug Fix 9212516*/
12681:
12682: -- gather statistics for PJI metadata tables
12683: /* Gather stats by partition added for bug 7551819 */
12684: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
12685: tabname => 'PJI_FP_AGGR_PJP1',
12686: partname=>'P'|| g_worker_id,
12687: granularity=>'PARTITION',
12688: percent => 5,

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

12685: tabname => 'PJI_FP_AGGR_PJP1',
12686: partname=>'P'|| g_worker_id,
12687: granularity=>'PARTITION',
12688: percent => 5,
12689: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
12690:
12691: /* Added for bug 7551819
12692: If UPPD is submitted standalone, then gather stats is required.
12693: If UPPD is submitted from Launch process, gather stats is not required */

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

12694:
12695: if l_from_launch = 'N' then
12696: IF nvl(FND_PROFILE.VALUE('PJI_GATHERSTATS_FACT'),'N') = 'Y' THEN -- Added for bug 11789673 Base bug 9824355
12697: -- gather statistics for PJI metadata tables
12698: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
12699: tabname => 'PJI_FP_XBS_ACCUM_F',
12700: percent => 5,
12701: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
12702: END IF;

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

12697: -- gather statistics for PJI metadata tables
12698: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
12699: tabname => 'PJI_FP_XBS_ACCUM_F',
12700: percent => 5,
12701: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
12702: END IF;
12703: end if;
12704:
12705: /*Bug Fix 9212516*/

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

13148:
13149: /* Added for bug 14636607 Starts */
13150: else
13151:
13152: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
13153: tabname => 'PJI_FP_AGGR_PJP1',
13154: partname => 'P'|| g_worker_id,
13155: granularity => 'PARTITION',
13156: percent => 5,

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

13153: tabname => 'PJI_FP_AGGR_PJP1',
13154: partname => 'P'|| g_worker_id,
13155: granularity => 'PARTITION',
13156: percent => 5,
13157: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
13158:
13159:
13160: -- Disable indexes on fact table
13161: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name

Line 13165: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME

13161: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
13162: , partitioned
13163: FROM dba_indexes
13164: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
13165: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME
13166: AND status <> 'UNUSABLE') LOOP
13167:
13168: IF ind_lp.partitioned = 'YES' THEN
13169: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' MODIFY PARTITION P'||g_worker_id||' UNUSABLE';

Line 13183: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP

13179: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
13180: , partitioned
13181: FROM dba_indexes
13182: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
13183: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
13184:
13185: IF ind_lp.partitioned = 'YES' THEN
13186: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' REBUILD PARTITION P'||g_worker_id||' PARALLEL';
13187:

Line 13208: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP

13204: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
13205: , partitioned
13206: FROM dba_indexes
13207: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
13208: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
13209:
13210: IF ind_lp.partitioned = 'YES' THEN
13211: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' REBUILD PARTITION P'||g_worker_id||' PARALLEL';
13212: ELSE

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

13572:
13573: close c1;
13574:
13575: /* Gather stats since we have inserted data into fact table */
13576: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
13577: tabname => 'PJI_FP_XBS_ACCUM_F',
13578: percent => 5,
13579: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
13580:

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

13575: /* Gather stats since we have inserted data into fact table */
13576: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
13577: tabname => 'PJI_FP_XBS_ACCUM_F',
13578: percent => 5,
13579: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
13580:
13581: EXCEPTION
13582: WHEN OTHERS THEN
13583: FND_MSG_PUB.add_exc_msg( p_pkg_name => g_package_name ,