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.

[Home] [Help]

APPS.PJI_RM_SUM_ROLLUP_RES dependencies on PJI_RM_SUM_MAIN

Line 15: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

11: l_row_count number;
12:
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,

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 84: ceil(ROWNUM / PJI_RM_SUM_MAIN.g_commit_threshold)

80: fid.ROWID FID_ROWID,
81: delta.START_DATE,
82: delta.END_DATE,
83: fid.PJI_SUMMARIZED_FLAG,
84: ceil(ROWNUM / PJI_RM_SUM_MAIN.g_commit_threshold)
85: from
86: PJI_RES_DELTA delta,
87: PA_FORECAST_ITEMS fi,
88: PA_FORECAST_ITEM_DETAILS fid,

Line 126: ceil(ROWNUM / PJI_RM_SUM_MAIN.g_commit_threshold)

122: delta.END_DATE,
123: -1 PROJECT_ORG_ID,
124: -1 PROJECT_ORGANIZATION_ID,
125: cdl.PJI_SUMMARIZED_FLAG,
126: ceil(ROWNUM / PJI_RM_SUM_MAIN.g_commit_threshold)
127: from
128: PJI_RES_DELTA delta,
129: PA_EXPENDITURES_ALL exp,
130: PA_EXPENDITURE_ITEMS_ALL ei,

Line 182: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

178: l_missing_avl_setup exception;
179:
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,

Line 193: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');

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
197: from PJI_RM_WORK_TYPE_INFO

Line 751: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

747: l_row_count number;
748:
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,

Line 889: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

885: l_row_count number;
886:
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,

Line 899: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

895: ) = 'N') then
896: return;
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,

Line 1038: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

1034: l_row_count number;
1035:
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,

Line 1048: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

1044: ) = 'N') then
1045: return;
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,

Line 1187: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

1183: l_row_count number;
1184:
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,

Line 1295: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

1291: l_row_count number;
1292:
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,

Line 1490: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

1486: l_row_count number;
1487:
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,

Line 1500: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

1496: ) = 'N') then
1497: return;
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,

Line 1696: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

1692: l_row_count number;
1693:
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,

Line 1706: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

1702: ) = 'N') then
1703: return;
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,

Line 1902: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

1898: l_row_count number;
1899:
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,

Line 2072: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

2068: l_last_update_login number;
2069:
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,

Line 2083: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');

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;
2087: l_creation_date := sysdate;

Line 2348: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

2344: l_process varchar2(30);
2345:
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,

Line 2422: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

2418: l_last_update_login number;
2419:
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,

Line 2433: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');

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;
2437: l_creation_date := sysdate;

Line 3073: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

3069: l_process varchar2(30);
3070:
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,

Line 3141: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

3137: l_retcode varchar2(255);
3138:
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,

Line 3152: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');

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
3156: return;

Line 3243: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

3239: l_retcode varchar2(255);
3240:
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,

Line 3254: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');

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
3258: return;

Line 3337: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

3333: l_retcode varchar2(255);
3334:
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,

Line 3348: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');

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
3352: return;

Line 3425: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

3421: l_retcode varchar2(255);
3422:
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,

Line 3436: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');

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
3440: return;

Line 3486: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

3482: l_retcode varchar2(255);
3483:
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,

Line 3497: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');

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
3501: return;

Line 3547: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

3543: l_retcode varchar2(255);
3544:
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,

Line 3558: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');

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
3562: return;