DBA Data[Home] [Help]

APPS.PJI_RM_SUM_ROLLUP_RES dependencies on PJI_RM_SUM_ROLLUP_RES

Line 1: package body PJI_RM_SUM_ROLLUP_RES as

1: package body PJI_RM_SUM_ROLLUP_RES as
2: /* $Header: PJISR03B.pls 120.4 2006/03/31 12:04:06 appldev noship $ */
3:
4:
5: -- -----------------------------------------------------

Line 20: 'PJI_RM_SUM_ROLLUP_RES.JOB_NONUTIL2UTIL(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
22: return;
23: end if;
24:

Line 155: 'PJI_RM_SUM_ROLLUP_RES.JOB_NONUTIL2UTIL(p_worker_id);'

151:
152: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
153: (
154: l_process,
155: 'PJI_RM_SUM_ROLLUP_RES.JOB_NONUTIL2UTIL(p_worker_id);'
156: );
157:
158: commit;
159:

Line 187: 'PJI_RM_SUM_ROLLUP_RES.CALC_RMS_AVL_AND_WT(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
189: return;
190: end if;
191:

Line 733: 'PJI_RM_SUM_ROLLUP_RES.CALC_RMS_AVL_AND_WT(p_worker_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: );
735:
736: commit;
737:

Line 756: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_EN(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
758: return;
759: end if;
760:

Line 871: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_EN(p_worker_id);'

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: );
873:
874: commit;
875:

Line 904: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_PA(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
906: return;
907: end if;
908:

Line 1020: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_PA(p_worker_id);'

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: );
1022:
1023: commit;
1024:

Line 1053: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_GL(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
1055: return;
1056: end if;
1057:

Line 1169: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_GL(p_worker_id);'

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: );
1171:
1172: commit;
1173:

Line 1192: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_WK(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
1194: return;
1195: end if;
1196:

Line 1277: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMR_CAL_WK(p_worker_id);'

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: );
1279:
1280: commit;
1281:

Line 1300: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_EN(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
1302: return;
1303: end if;
1304:

Line 1472: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_EN(p_worker_id);'

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: );
1474:
1475: commit;
1476:

Line 1505: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_PA(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
1507: return;
1508: end if;
1509:

Line 1678: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_PA(p_worker_id);'

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: );
1680:
1681: commit;
1682:

Line 1711: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_GL(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
1713: return;
1714: end if;
1715:

Line 1884: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_GL(p_worker_id);'

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: );
1886:
1887: commit;
1888:

Line 1907: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_WK(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
1909: return;
1910: end if;
1911:

Line 2049: 'PJI_RM_SUM_ROLLUP_RES.EXPAND_RMS_CAL_WK(p_worker_id);'

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: );
2051:
2052: commit;
2053:

Line 2077: 'PJI_RM_SUM_ROLLUP_RES.MERGE_TMP1_INTO_RMR(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
2079: return;
2080: end if;
2081:

Line 2331: 'PJI_RM_SUM_ROLLUP_RES.MERGE_TMP1_INTO_RMR(p_worker_id);'

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: );
2333:
2334: commit;
2335:

Line 2353: 'PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMR(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
2355: return;
2356: end if;
2357:

Line 2396: 'PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMR(p_worker_id);'

2392:
2393: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
2394: (
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);

Line 2427: 'PJI_RM_SUM_ROLLUP_RES.MERGE_TMP2_INTO_RMS(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
2429: return;
2430: end if;
2431:

Line 3056: 'PJI_RM_SUM_ROLLUP_RES.MERGE_TMP2_INTO_RMS(p_worker_id);'

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: );
3058:
3059: commit;
3060:

Line 3078: 'PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMS(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
3080: return;
3081: end if;
3082:

Line 3114: 'PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMS(p_worker_id);'

3110:
3111: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
3112: (
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);

Line 3146: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTW(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
3148: return;
3149: end if;
3150:

Line 3219: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTW(p_worker_id);'

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: );
3221:
3222: commit;
3223:

Line 3248: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTX(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
3250: return;
3251: end if;
3252:

Line 3314: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTX(p_worker_id);'

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: );
3316:
3317: commit;
3318:

Line 3342: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTJ(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
3344: return;
3345: end if;
3346:

Line 3403: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_UTJ(p_worker_id);'

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: );
3405:
3406: commit;
3407:

Line 3430: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME(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
3432: return;
3433: end if;
3434:

Line 3463: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME(p_worker_id);'

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: );
3465:
3466: commit;
3467:

Line 3491: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_DAY(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
3493: return;
3494: end if;
3495:

Line 3524: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_DAY(p_worker_id);'

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: );
3526:
3527: commit;
3528:

Line 3552: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_TREND(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
3554: return;
3555: end if;
3556:

Line 3585: 'PJI_RM_SUM_ROLLUP_RES.REFRESH_MVIEW_TIME_TREND(p_worker_id);'

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: );
3587:
3588: commit;
3589:

Line 3612: end PJI_RM_SUM_ROLLUP_RES;

3608: 'PJI_RM_AGGR_RES2','NORMAL',null);
3609:
3610: end CLEANUP;
3611:
3612: end PJI_RM_SUM_ROLLUP_RES;