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

Line 17: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

13: begin
14:
15: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
16:
17: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
18: (
19: l_process,
20: 'PJI_RM_SUM_ROLLUP_RES.JOB_NONUTIL2UTIL(p_worker_id);'
21: )) then

Line 25: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process,

21: )) then
22: return;
23: end if;
24:
25: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process,
26: 'EXTRACTION_TYPE') = 'FULL') then
27: return;
28: end if;
29:

Line 152: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

148: rcdl.CDL_ROWID is null;
149:
150: end if;
151:
152: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
153: (
154: l_process,
155: 'PJI_RM_SUM_ROLLUP_RES.JOB_NONUTIL2UTIL(p_worker_id);'
156: );

Line 184: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

180: begin
181:
182: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
183:
184: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
185: (
186: l_process,
187: 'PJI_RM_SUM_ROLLUP_RES.CALC_RMS_AVL_AND_WT(p_worker_id);'
188: )) then

Line 192: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

188: )) then
189: return;
190: end if;
191:
192: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
193: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
194:
195: select count(*)
196: into l_count

Line 730: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

726: tmp1.CALENDAR_TYPE,
727: tmp1.GL_CALENDAR_ID,
728: tmp1.PA_CALENDAR_ID;
729:
730: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
731: (
732: l_process,
733: 'PJI_RM_SUM_ROLLUP_RES.CALC_RMS_AVL_AND_WT(p_worker_id);'
734: );

Line 753: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

749: begin
750:
751: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
752:
753: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
754: (
755: l_process,
756: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_EN(p_worker_id);'
757: )) then

Line 855: l_row_count := l_row_count + PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

851: grouping(time.ENT_PERIOD_ID) = 1);
852:
853: l_row_count := sql%rowcount;
854:
855: l_row_count := l_row_count + PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
856: (
857: l_process,
858: 'TOTAL_RES_ROW_COUNT'
859: );

Line 861: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

857: l_process,
858: 'TOTAL_RES_ROW_COUNT'
859: );
860:
861: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
862: (
863: l_process,
864: 'TOTAL_RES_ROW_COUNT',
865: l_row_count

Line 868: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

864: 'TOTAL_RES_ROW_COUNT',
865: l_row_count
866: );
867:
868: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
869: (
870: l_process,
871: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_EN(p_worker_id);'
872: );

Line 891: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

887: begin
888:
889: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
890:
891: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
892: (
893: l_process,
894: 'PA_CALENDAR_FLAG'
895: ) = 'N') then

Line 901: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

897: end if;
898:
899: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
900:
901: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
902: (
903: l_process,
904: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_PA(p_worker_id);'
905: )) then

Line 1004: l_row_count := l_row_count + PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1000: grouping(time.CAL_PERIOD_ID) = 1);
1001:
1002: l_row_count := sql%rowcount;
1003:
1004: l_row_count := l_row_count + PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1005: (
1006: l_process,
1007: 'TOTAL_RES_ROW_COUNT'
1008: );

Line 1010: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

1006: l_process,
1007: 'TOTAL_RES_ROW_COUNT'
1008: );
1009:
1010: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
1011: (
1012: l_process,
1013: 'TOTAL_RES_ROW_COUNT',
1014: l_row_count

Line 1017: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

1013: 'TOTAL_RES_ROW_COUNT',
1014: l_row_count
1015: );
1016:
1017: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1018: (
1019: l_process,
1020: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_PA(p_worker_id);'
1021: );

Line 1040: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1036: begin
1037:
1038: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1039:
1040: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1041: (
1042: l_process,
1043: 'GL_CALENDAR_FLAG'
1044: ) = 'N') then

Line 1050: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

1046: end if;
1047:
1048: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1049:
1050: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1051: (
1052: l_process,
1053: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_GL(p_worker_id);'
1054: )) then

Line 1153: l_row_count := l_row_count + PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1149: grouping(time.CAL_PERIOD_ID) = 1);
1150:
1151: l_row_count := sql%rowcount;
1152:
1153: l_row_count := l_row_count + PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1154: (
1155: l_process,
1156: 'TOTAL_RES_ROW_COUNT'
1157: );

Line 1159: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

1155: l_process,
1156: 'TOTAL_RES_ROW_COUNT'
1157: );
1158:
1159: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
1160: (
1161: l_process,
1162: 'TOTAL_RES_ROW_COUNT',
1163: l_row_count

Line 1166: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

1162: 'TOTAL_RES_ROW_COUNT',
1163: l_row_count
1164: );
1165:
1166: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1167: (
1168: l_process,
1169: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_GL(p_worker_id);'
1170: );

Line 1189: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

1185: begin
1186:
1187: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1188:
1189: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1190: (
1191: l_process,
1192: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_WK(p_worker_id);'
1193: )) then

Line 1261: l_row_count := l_row_count + PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1257: time.WEEK_ID;
1258:
1259: l_row_count := sql%rowcount;
1260:
1261: l_row_count := l_row_count + PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1262: (
1263: l_process,
1264: 'TOTAL_RES_ROW_COUNT'
1265: );

Line 1267: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

1263: l_process,
1264: 'TOTAL_RES_ROW_COUNT'
1265: );
1266:
1267: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
1268: (
1269: l_process,
1270: 'TOTAL_RES_ROW_COUNT',
1271: l_row_count

Line 1274: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

1270: 'TOTAL_RES_ROW_COUNT',
1271: l_row_count
1272: );
1273:
1274: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1275: (
1276: l_process,
1277: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_WK(p_worker_id);'
1278: );

Line 1297: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

1293: begin
1294:
1295: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1296:
1297: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1298: (
1299: l_process,
1300: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_EN(p_worker_id);'
1301: )) then

Line 1456: l_row_count := l_row_count + PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1452: grouping(time.ENT_PERIOD_ID) = 1);
1453:
1454: l_row_count := sql%rowcount;
1455:
1456: l_row_count := l_row_count + PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1457: (
1458: l_process,
1459: 'TOTAL_RES_ROW_COUNT'
1460: );

Line 1462: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

1458: l_process,
1459: 'TOTAL_RES_ROW_COUNT'
1460: );
1461:
1462: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
1463: (
1464: l_process,
1465: 'TOTAL_RES_ROW_COUNT',
1466: l_row_count

Line 1469: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

1465: 'TOTAL_RES_ROW_COUNT',
1466: l_row_count
1467: );
1468:
1469: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1470: (
1471: l_process,
1472: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_EN(p_worker_id);'
1473: );

Line 1492: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1488: begin
1489:
1490: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1491:
1492: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1493: (
1494: l_process,
1495: 'PA_CALENDAR_FLAG'
1496: ) = 'N') then

Line 1502: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

1498: end if;
1499:
1500: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1501:
1502: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1503: (
1504: l_process,
1505: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_PA(p_worker_id);'
1506: )) then

Line 1662: l_row_count := l_row_count + PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1658: grouping(time.CAL_PERIOD_ID) = 1);
1659:
1660: l_row_count := sql%rowcount;
1661:
1662: l_row_count := l_row_count + PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1663: (
1664: l_process,
1665: 'TOTAL_RES_ROW_COUNT'
1666: );

Line 1668: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

1664: l_process,
1665: 'TOTAL_RES_ROW_COUNT'
1666: );
1667:
1668: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
1669: (
1670: l_process,
1671: 'TOTAL_RES_ROW_COUNT',
1672: l_row_count

Line 1675: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

1671: 'TOTAL_RES_ROW_COUNT',
1672: l_row_count
1673: );
1674:
1675: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1676: (
1677: l_process,
1678: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_PA(p_worker_id);'
1679: );

Line 1698: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1694: begin
1695:
1696: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1697:
1698: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1699: (
1700: l_process,
1701: 'GL_CALENDAR_FLAG'
1702: ) = 'N') then

Line 1708: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

1704: end if;
1705:
1706: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1707:
1708: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1709: (
1710: l_process,
1711: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_GL(p_worker_id);'
1712: )) then

Line 1868: l_row_count := l_row_count + PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

1864: grouping(time.CAL_PERIOD_ID) = 1);
1865:
1866: l_row_count := sql%rowcount;
1867:
1868: l_row_count := l_row_count + PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1869: (
1870: l_process,
1871: 'TOTAL_RES_ROW_COUNT'
1872: );

Line 1874: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

1870: l_process,
1871: 'TOTAL_RES_ROW_COUNT'
1872: );
1873:
1874: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
1875: (
1876: l_process,
1877: 'TOTAL_RES_ROW_COUNT',
1878: l_row_count

Line 1881: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

1877: 'TOTAL_RES_ROW_COUNT',
1878: l_row_count
1879: );
1880:
1881: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
1882: (
1883: l_process,
1884: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_GL(p_worker_id);'
1885: );

Line 1904: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

1900: begin
1901:
1902: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1903:
1904: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
1905: (
1906: l_process,
1907: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_WK(p_worker_id);'
1908: )) then

Line 2033: l_row_count := l_row_count + PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2029: time.WEEK_ID;
2030:
2031: l_row_count := sql%rowcount;
2032:
2033: l_row_count := l_row_count + PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2034: (
2035: l_process,
2036: 'TOTAL_RES_ROW_COUNT'
2037: );

Line 2039: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

2035: l_process,
2036: 'TOTAL_RES_ROW_COUNT'
2037: );
2038:
2039: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
2040: (
2041: l_process,
2042: 'TOTAL_RES_ROW_COUNT',
2043: l_row_count

Line 2046: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

2042: 'TOTAL_RES_ROW_COUNT',
2043: l_row_count
2044: );
2045:
2046: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
2047: (
2048: l_process,
2049: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_WK(p_worker_id);'
2050: );

Line 2074: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

2070: begin
2071:
2072: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
2073:
2074: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
2075: (
2076: l_process,
2077: 'PJI_RM_SUM_ROLLUP_RES.MERGE_TMP1_INTO_RMR(p_worker_id);'
2078: )) then

Line 2082: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2078: )) then
2079: return;
2080: end if;
2081:
2082: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2083: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
2084:
2085: l_last_update_date := sysdate;
2086: l_last_updated_by := FND_GLOBAL.USER_ID;

Line 2328: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

2324: );
2325:
2326: end if;
2327:
2328: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
2329: (
2330: l_process,
2331: 'PJI_RM_SUM_ROLLUP_RES.MERGE_TMP1_INTO_RMR(p_worker_id);'
2332: );

Line 2350: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

2346: begin
2347:
2348: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
2349:
2350: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
2351: (
2352: l_process,
2353: 'PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMR(p_worker_id);'
2354: )) then

Line 2393: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

2389: nvl(UNASSIGNED_HRS_S, 0) = 0 and
2390: nvl(CONF_OVERCOM_HRS_S, 0) = 0 and
2391: nvl(PROV_OVERCOM_HRS_S, 0) = 0;
2392:
2393: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
2394: (
2395: l_process,
2396: 'PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMR(p_worker_id);'
2397: );

Line 2399: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME,

2395: l_process,
2396: 'PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMR(p_worker_id);'
2397: );
2398:
2399: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME,
2400: 'PJI_RM_AGGR_RES1','NORMAL',null);
2401:
2402: commit;
2403:

Line 2424: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

2420: begin
2421:
2422: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
2423:
2424: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
2425: (
2426: l_process,
2427: 'PJI_RM_SUM_ROLLUP_RES.MERGE_TMP2_INTO_RMS(p_worker_id);'
2428: )) then

Line 2432: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2428: )) then
2429: return;
2430: end if;
2431:
2432: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2433: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
2434:
2435: l_last_update_date := sysdate;
2436: l_last_updated_by := FND_GLOBAL.USER_ID;

Line 3053: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

3049: );
3050:
3051: end if;
3052:
3053: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
3054: (
3055: l_process,
3056: 'PJI_RM_SUM_ROLLUP_RES.MERGE_TMP2_INTO_RMS(p_worker_id);'
3057: );

Line 3075: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

3071: begin
3072:
3073: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
3074:
3075: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
3076: (
3077: l_process,
3078: 'PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMS(p_worker_id);'
3079: )) then

Line 3111: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

3107: nvl(UNASSIGNED_HRS_S, 0) = 0 and
3108: nvl(CONF_OVERCOM_HRS_S, 0) = 0 and
3109: nvl(PROV_OVERCOM_HRS_S, 0) = 0;
3110:
3111: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
3112: (
3113: l_process,
3114: 'PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMS(p_worker_id);'
3115: );

Line 3117: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME,

3113: l_process,
3114: 'PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMS(p_worker_id);'
3115: );
3116:
3117: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME,
3118: 'PJI_RM_AGGR_RES2','NORMAL',null);
3119:
3120: commit;
3121:

Line 3143: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

3139: begin
3140:
3141: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
3142:
3143: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
3144: (
3145: l_process,
3146: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTW(p_worker_id);'
3147: )) then

Line 3151: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3147: )) then
3148: return;
3149: end if;
3150:
3151: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3152: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
3153:
3154: if (upper(nvl(FND_PROFILE.VALUE('PJI_USE_DBI_RSG'), 'N')) = 'Y' and
3155: l_extraction_type <> 'PARTIAL') then

Line 3216: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

3212: percent => 10,
3213: degree => l_p_degree);
3214: end if;
3215:
3216: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
3217: (
3218: l_process,
3219: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTW(p_worker_id);'
3220: );

Line 3245: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

3241: begin
3242:
3243: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
3244:
3245: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
3246: (
3247: l_process,
3248: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTX(p_worker_id);'
3249: )) then

Line 3253: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3249: )) then
3250: return;
3251: end if;
3252:
3253: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3254: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
3255:
3256: if (upper(nvl(FND_PROFILE.VALUE('PJI_USE_DBI_RSG'), 'N')) = 'Y' and
3257: l_extraction_type <> 'PARTIAL') then

Line 3311: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

3307: percent => 10,
3308: degree => l_p_degree);
3309: end if;
3310:
3311: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
3312: (
3313: l_process,
3314: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTX(p_worker_id);'
3315: );

Line 3339: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

3335: begin
3336:
3337: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
3338:
3339: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
3340: (
3341: l_process,
3342: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTJ(p_worker_id);'
3343: )) then

Line 3347: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3343: )) then
3344: return;
3345: end if;
3346:
3347: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3348: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
3349:
3350: if (upper(nvl(FND_PROFILE.VALUE('PJI_USE_DBI_RSG'), 'N')) = 'Y' and
3351: l_extraction_type <> 'PARTIAL') then

Line 3400: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

3396: percent => 10,
3397: degree => l_p_degree);
3398: end if;
3399:
3400: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
3401: (
3402: l_process,
3403: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTJ(p_worker_id);'
3404: );

Line 3427: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

3423: begin
3424:
3425: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
3426:
3427: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
3428: (
3429: l_process,
3430: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME(p_worker_id);'
3431: )) then

Line 3435: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3431: )) then
3432: return;
3433: end if;
3434:
3435: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3436: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
3437:
3438: if (upper(nvl(FND_PROFILE.VALUE('PJI_USE_DBI_RSG'), 'N')) = 'Y' and
3439: l_extraction_type <> 'PARTIAL') then

Line 3460: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

3456: tabname => 'PJI_TIME_MV',
3457: percent => 10,
3458: degree => l_p_degree);
3459:
3460: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
3461: (
3462: l_process,
3463: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME(p_worker_id);'
3464: );

Line 3488: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

3484: begin
3485:
3486: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
3487:
3488: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
3489: (
3490: l_process,
3491: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_DAY(p_worker_id);'
3492: )) then

Line 3496: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3492: )) then
3493: return;
3494: end if;
3495:
3496: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3497: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
3498:
3499: if (upper(nvl(FND_PROFILE.VALUE('PJI_USE_DBI_RSG'), 'N')) = 'Y' and
3500: l_extraction_type <> 'PARTIAL') then

Line 3521: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

3517: tabname => 'PJI_TIME_DAY_MV',
3518: percent => 10,
3519: degree => l_p_degree);
3520:
3521: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
3522: (
3523: l_process,
3524: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_DAY(p_worker_id);'
3525: );

Line 3549: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

3545: begin
3546:
3547: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
3548:
3549: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
3550: (
3551: l_process,
3552: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_TREND(p_worker_id);'
3553: )) then

Line 3557: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3553: )) then
3554: return;
3555: end if;
3556:
3557: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3558: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
3559:
3560: if (upper(nvl(FND_PROFILE.VALUE('PJI_USE_DBI_RSG'), 'N')) = 'Y' and
3561: l_extraction_type <> 'PARTIAL') then

Line 3582: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

3578: tabname => 'PJI_TIME_TREND_MV',
3579: percent => 10,
3580: degree => l_p_degree);
3581:
3582: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
3583: (
3584: l_process,
3585: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_TREND(p_worker_id);'
3586: );

Line 3604: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,

3600: begin
3601:
3602: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
3603:
3604: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
3605: 'PJI_RM_AGGR_RES1','NORMAL',null);
3606:
3607: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
3608: 'PJI_RM_AGGR_RES2','NORMAL',null);

Line 3607: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,

3603:
3604: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
3605: 'PJI_RM_AGGR_RES1','NORMAL',null);
3606:
3607: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
3608: 'PJI_RM_AGGR_RES2','NORMAL',null);
3609:
3610: end CLEANUP;
3611: