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_SUM_ROLLUP_ACT dependencies on PJI_PROCESS_UTIL

Line 16: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_ACT.ACT_ROWID_TABLE(p_worker_id);')) then

12: begin
13:
14: l_process := PJI_RM_SUM_MAIN.g_process || p_worker_id;
15:
16: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_ACT.ACT_ROWID_TABLE(p_worker_id);')) then
17: return;
18: end if;
19:
20: insert /*+ append parallel(act_i) */ into PJI_PJI_RMAP_ACT act_i

Line 35: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_ACT.ACT_ROWID_TABLE(p_worker_id);');

31: where
32: map.WORKER_ID = p_worker_id and
33: act5.PROJECT_ID = map.PROJECT_ID;
34:
35: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_ACT.ACT_ROWID_TABLE(p_worker_id);');
36:
37: commit;
38:
39: end ACT_ROWID_TABLE;

Line 62: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_ACT.AGGREGATE_ACT_SLICES(p_worker_id);')) then

58: begin
59:
60: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
61:
62: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_ACT.AGGREGATE_ACT_SLICES(p_worker_id);')) then
63: return;
64: end if;
65:
66: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 66: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

62: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_ACT.AGGREGATE_ACT_SLICES(p_worker_id);')) then
63: return;
64: end if;
65:
66: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
67: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
68:
69: select
70: TXN_CURR_FLAG,

Line 81: l_pa_calendar_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

77:
78: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
79: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
80:
81: l_pa_calendar_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
82: (
83: PJI_RM_SUM_MAIN.g_process,
84: 'PA_CALENDAR_FLAG'
85: );

Line 1073: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_ACT.AGGREGATE_ACT_SLICES(p_worker_id);');

1069: src4.PA_CALENDAR_ID,
1070: src4.CURR_RECORD_TYPE_ID,
1071: src4.CURRENCY_CODE;
1072:
1073: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_ACT.AGGREGATE_ACT_SLICES(p_worker_id);');
1074:
1075: commit;
1076:
1077: end AGGREGATE_ACT_SLICES;

Line 1092: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_ACT.PURGE_ACT_DATA(p_worker_id);')) then

1088: begin
1089:
1090: l_process := PJI_RM_SUM_MAIN.g_process || p_worker_id;
1091:
1092: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_ACT.PURGE_ACT_DATA(p_worker_id);')) then
1093: return;
1094: end if;
1095:
1096: delete

Line 1102: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_ACT.PURGE_ACT_DATA(p_worker_id);');

1098: where ROWID in (select STG_ROWID
1099: from PJI_PJI_RMAP_ACT
1100: where WORKER_ID = p_worker_id);
1101:
1102: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_ACT.PURGE_ACT_DATA(p_worker_id);');
1103:
1104: commit;
1105:
1106: end PURGE_ACT_DATA;

Line 1121: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

1117: begin
1118:
1119: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1120:
1121: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1122: (
1123: l_process,
1124: 'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_EN(p_worker_id, ''' ||
1125: p_backlog_flag || ''');'

Line 1268: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

1264: not (grouping(time.ENT_YEAR_ID) = 1 and
1265: grouping(time.ENT_QTR_ID) = 1 and
1266: grouping(time.ENT_PERIOD_ID) = 1);
1267:
1268: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1269: (
1270: l_process,
1271: 'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_EN(p_worker_id, ''' ||
1272: p_backlog_flag || ''');'

Line 1290: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1286: l_process varchar2(30);
1287:
1288: begin
1289:
1290: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1291: (
1292: PJI_RM_SUM_MAIN.g_process,
1293: 'PA_CALENDAR_FLAG'
1294: ) = 'N') then

Line 1300: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

1296: end if;
1297:
1298: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1299:
1300: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1301: (
1302: l_process,
1303: 'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_PA(p_worker_id, ''' ||
1304: p_backlog_flag || ''');'

Line 1447: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

1443: not (grouping(time.CAL_YEAR_ID) = 1 and
1444: grouping(time.CAL_QTR_ID) = 1 and
1445: grouping(time.CAL_PERIOD_ID) = 1);
1446:
1447: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1448: (
1449: l_process,
1450: 'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_PA(p_worker_id, ''' ||
1451: p_backlog_flag || ''');'

Line 1469: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1465: l_process varchar2(30);
1466:
1467: begin
1468:
1469: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1470: (
1471: PJI_RM_SUM_MAIN.g_process,
1472: 'GL_CALENDAR_FLAG'
1473: ) = 'N') then

Line 1479: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

1475: end if;
1476:
1477: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1478:
1479: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1480: (
1481: l_process,
1482: 'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_GL(p_worker_id, ''' ||
1483: p_backlog_flag || ''');'

Line 1677: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

1673: where
1674: not (act.CURR_RECORD_TYPE_ID in (8, 256) and
1675: act.PERIOD_TYPE_ID <> 32);
1676:
1677: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1678: (
1679: l_process,
1680: 'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_GL(p_worker_id, ''' ||
1681: p_backlog_flag || ''');'

Line 1701: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

1697: begin
1698:
1699: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1700:
1701: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1702: (
1703: l_process,
1704: 'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_WK(p_worker_id, ''' ||
1705: p_backlog_flag || ''');'

Line 1818: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

1814: time.WEEK_ID,
1815: bitand(act.CURR_RECORD_TYPE_ID, 247),
1816: act.CURRENCY_CODE;
1817:
1818: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1819: (
1820: l_process,
1821: 'PJI_FM_SUM_ROLLUP_ACT.EXPAND_ACT_CAL_WK(p_worker_id, ''' ||
1822: p_backlog_flag || ''');'

Line 1849: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

1845: begin
1846:
1847: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1848:
1849: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1850: (
1851: l_process,
1852: 'PJI_FM_SUM_ROLLUP_ACT.MERGE_ACT_INTO_ACP(p_worker_id, ''' ||
1853: p_backlog_flag ||

Line 1859: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1855: )) then
1856: return;
1857: end if;
1858:
1859: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1860: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
1861:
1862: l_last_update_date := sysdate;
1863: l_last_updated_by := FND_GLOBAL.USER_ID;

Line 2575: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

2571: );
2572:
2573: end if;
2574:
2575: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
2576: (
2577: l_process,
2578: 'PJI_FM_SUM_ROLLUP_ACT.MERGE_ACT_INTO_ACP(p_worker_id, ''' ||
2579: p_backlog_flag || ''');'

Line 2586: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema ,

2582: if (p_backlog_flag = 'Y') then
2583:
2584: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
2585:
2586: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema ,
2587: 'PJI_FM_AGGR_ACT3',
2588: 'NORMAL',
2589: null);
2590:

Line 2634: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

2630: begin
2631:
2632: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
2633:
2634: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
2635: (
2636: l_process,
2637: 'PJI_FM_SUM_ROLLUP_ACT.PROJECT_ORGANIZATION(p_worker_id);'
2638: )) then

Line 2710: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

2706:
2707: CLOSE update_scope;
2708:
2709:
2710: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
2711: (
2712: l_process,
2713: 'PJI_FM_SUM_ROLLUP_ACT.PROJECT_ORGANIZATION(p_worker_id);'
2714: );

Line 2739: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

2735: begin
2736:
2737: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
2738:
2739: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
2740: (
2741: l_process,
2742: 'PJI_FM_SUM_ROLLUP_ACT.REFRESH_MVIEW_ACO(p_worker_id);'
2743: )) then

Line 2747: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2743: )) then
2744: return;
2745: end if;
2746:
2747: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2748: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
2749:
2750: if (upper(nvl(FND_PROFILE.VALUE('PJI_USE_DBI_RSG'), 'N')) = 'Y' and
2751: l_extraction_type <> 'PARTIAL') then

Line 2812: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

2808: percent => 10,
2809: degree => l_p_degree);
2810: end if;
2811:
2812: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
2813: (
2814: l_process,
2815: 'PJI_FM_SUM_ROLLUP_ACT.REFRESH_MVIEW_ACO(p_worker_id);'
2816: );

Line 2841: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

2837: begin
2838:
2839: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
2840:
2841: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
2842: (
2843: l_process,
2844: 'PJI_FM_SUM_ROLLUP_ACT.REFRESH_MVIEW_ACC(p_worker_id);'
2845: )) then

Line 2849: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2845: )) then
2846: return;
2847: end if;
2848:
2849: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2850: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
2851:
2852: if (upper(nvl(FND_PROFILE.VALUE('PJI_USE_DBI_RSG'), 'N')) = 'Y' and
2853: l_extraction_type <> 'PARTIAL') then

Line 2910: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

2906: percent => 10,
2907: degree => l_p_degree);
2908: end if;
2909:
2910: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
2911: (
2912: l_process,
2913: 'PJI_FM_SUM_ROLLUP_ACT.REFRESH_MVIEW_ACC(p_worker_id);'
2914: );