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_PJP_SUM_ROLLUP dependencies on DUAL

Line 1033: from DUAL union all

1029: PJI_XBS_DENORM_T prg,
1030: -- End of Commenting and adding code for testing 0802
1031: (
1032: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
1033: from DUAL union all
1034: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1035: from DUAL union all
1036: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
1037: from DUAL union all

Line 1035: from DUAL union all

1031: (
1032: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
1033: from DUAL union all
1034: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1035: from DUAL union all
1036: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
1037: from DUAL union all
1038: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1039: from DUAL union all

Line 1037: from DUAL union all

1033: from DUAL union all
1034: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1035: from DUAL union all
1036: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
1037: from DUAL union all
1038: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1039: from DUAL union all
1040: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
1041: from DUAL union all

Line 1039: from DUAL union all

1035: from DUAL union all
1036: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
1037: from DUAL union all
1038: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1039: from DUAL union all
1040: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
1041: from DUAL union all
1042: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1043: from DUAL union all

Line 1041: from DUAL union all

1037: from DUAL union all
1038: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1039: from DUAL union all
1040: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
1041: from DUAL union all
1042: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1043: from DUAL union all
1044: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
1045: from DUAL union all

Line 1043: from DUAL union all

1039: from DUAL union all
1040: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
1041: from DUAL union all
1042: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1043: from DUAL union all
1044: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
1045: from DUAL union all
1046: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1047: from DUAL

Line 1045: from DUAL union all

1041: from DUAL union all
1042: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1043: from DUAL union all
1044: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
1045: from DUAL union all
1046: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1047: from DUAL
1048: ) fin_plan,
1049: (

Line 1047: from DUAL

1043: from DUAL union all
1044: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
1045: from DUAL union all
1046: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1047: from DUAL
1048: ) fin_plan,
1049: (
1050: select 1 WBS_SUP_LEVEL,
1051: 1 WBS_SUB_LEVEL,

Line 1053: from DUAL

1049: (
1050: select 1 WBS_SUP_LEVEL,
1051: 1 WBS_SUB_LEVEL,
1052: 'PRJ' INVERT_ID
1053: from DUAL
1054: union all
1055: select 1 WBS_SUP_LEVEL,
1056: 1 WBS_SUB_LEVEL,
1057: 'WBS' INVERT_ID

Line 1058: from DUAL

1054: union all
1055: select 1 WBS_SUP_LEVEL,
1056: 1 WBS_SUB_LEVEL,
1057: 'WBS' INVERT_ID
1058: from DUAL
1059: ) top_slice
1060: where
1061: prg.STRUCT_TYPE = 'PRG' and
1062: prg.SUP_LEVEL = lv_level and

Line 1192: from DUAL union all

1188: (
1189: select 'Y' CB_FLAG,
1190: 'N' CO_FLAG,
1191: -3 PLAN_VERSION_ID
1192: from DUAL union all
1193: select 'N' CB_FLAG,
1194: 'Y' CO_FLAG,
1195: -4 PLAN_VERSION_ID
1196: from DUAL union all

Line 1196: from DUAL union all

1192: from DUAL union all
1193: select 'N' CB_FLAG,
1194: 'Y' CO_FLAG,
1195: -4 PLAN_VERSION_ID
1196: from DUAL union all
1197: select 'Y' CB_FLAG,
1198: 'Y' CO_FLAG,
1199: -3 PLAN_VERSION_ID
1200: from DUAL union all

Line 1200: from DUAL union all

1196: from DUAL union all
1197: select 'Y' CB_FLAG,
1198: 'Y' CO_FLAG,
1199: -3 PLAN_VERSION_ID
1200: from DUAL union all
1201: select 'Y' CB_FLAG,
1202: 'Y' CO_FLAG,
1203: -4 PLAN_VERSION_ID
1204: from DUAL

Line 1204: from DUAL

1200: from DUAL union all
1201: select 'Y' CB_FLAG,
1202: 'Y' CO_FLAG,
1203: -4 PLAN_VERSION_ID
1204: from DUAL
1205: ) fin_plan
1206: where
1207: prg.STRUCT_TYPE = 'PRG' and
1208: prg.SUP_LEVEL = lv_level and

Line 1347: from DUAL union all

1343: -- End of Commenting and adding code for testing 0802
1344: PJI_FP_XBS_ACCUM_F fpr,
1345: (
1346: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
1347: from DUAL union all
1348: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1349: from DUAL union all
1350: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
1351: from DUAL union all

Line 1349: from DUAL union all

1345: (
1346: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
1347: from DUAL union all
1348: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1349: from DUAL union all
1350: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
1351: from DUAL union all
1352: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1353: from DUAL union all

Line 1351: from DUAL union all

1347: from DUAL union all
1348: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1349: from DUAL union all
1350: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
1351: from DUAL union all
1352: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1353: from DUAL union all
1354: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
1355: from DUAL union all

Line 1353: from DUAL union all

1349: from DUAL union all
1350: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
1351: from DUAL union all
1352: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1353: from DUAL union all
1354: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
1355: from DUAL union all
1356: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1357: from DUAL union all

Line 1355: from DUAL union all

1351: from DUAL union all
1352: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1353: from DUAL union all
1354: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
1355: from DUAL union all
1356: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1357: from DUAL union all
1358: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
1359: from DUAL union all

Line 1357: from DUAL union all

1353: from DUAL union all
1354: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
1355: from DUAL union all
1356: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1357: from DUAL union all
1358: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
1359: from DUAL union all
1360: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1361: from DUAL

Line 1359: from DUAL union all

1355: from DUAL union all
1356: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1357: from DUAL union all
1358: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
1359: from DUAL union all
1360: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1361: from DUAL
1362: ) fin_plan,
1363: (

Line 1361: from DUAL

1357: from DUAL union all
1358: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
1359: from DUAL union all
1360: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
1361: from DUAL
1362: ) fin_plan,
1363: (
1364: select 1 WBS_SUP_LEVEL,
1365: 1 WBS_SUB_LEVEL,

Line 1367: from DUAL

1363: (
1364: select 1 WBS_SUP_LEVEL,
1365: 1 WBS_SUB_LEVEL,
1366: 'PRJ' INVERT_ID
1367: from DUAL
1368: union all
1369: select 1 WBS_SUP_LEVEL,
1370: 1 WBS_SUB_LEVEL,
1371: 'WBS' INVERT_ID

Line 1372: from DUAL

1368: union all
1369: select 1 WBS_SUP_LEVEL,
1370: 1 WBS_SUB_LEVEL,
1371: 'WBS' INVERT_ID
1372: from DUAL
1373: ) top_slice
1374: where
1375: prg.STRUCT_TYPE = 'PRG' and
1376: prg.SUP_LEVEL = lv_level and

Line 1436: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all

1432: PJI_XBS_DENORM_T prg,
1433: --PJI_XBS_DENORM prg,
1434: -- End of Commenting and adding code for testing 0802
1435: (
1436: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
1437: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
1438: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
1439: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
1440: ) invert,

Line 1437: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

1433: --PJI_XBS_DENORM prg,
1434: -- End of Commenting and adding code for testing 0802
1435: (
1436: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
1437: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
1438: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
1439: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
1440: ) invert,
1441: PJI_XBS_DENORM_DELTA prg_delta

Line 1438: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

1434: -- End of Commenting and adding code for testing 0802
1435: (
1436: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
1437: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
1438: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
1439: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
1440: ) invert,
1441: PJI_XBS_DENORM_DELTA prg_delta
1442: where

Line 1439: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual

1435: (
1436: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
1437: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
1438: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
1439: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
1440: ) invert,
1441: PJI_XBS_DENORM_DELTA prg_delta
1442: where
1443: prg.STRUCT_TYPE = 'PRG' and

Line 2421: from DUAL union all

2417: PA_XBS_DENORM wbs,
2418: PJI_XBS_DENORM prg,
2419: (
2420: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2421: from DUAL union all
2422: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2423: from DUAL union all
2424: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2425: from DUAL union all

Line 2423: from DUAL union all

2419: (
2420: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2421: from DUAL union all
2422: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2423: from DUAL union all
2424: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2425: from DUAL union all
2426: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2427: from DUAL union all

Line 2425: from DUAL union all

2421: from DUAL union all
2422: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2423: from DUAL union all
2424: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2425: from DUAL union all
2426: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2427: from DUAL union all
2428: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2429: from DUAL union all

Line 2427: from DUAL union all

2423: from DUAL union all
2424: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2425: from DUAL union all
2426: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2427: from DUAL union all
2428: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2429: from DUAL union all
2430: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2431: from DUAL union all

Line 2429: from DUAL union all

2425: from DUAL union all
2426: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2427: from DUAL union all
2428: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2429: from DUAL union all
2430: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2431: from DUAL union all
2432: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2433: from DUAL union all

Line 2431: from DUAL union all

2427: from DUAL union all
2428: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2429: from DUAL union all
2430: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2431: from DUAL union all
2432: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2433: from DUAL union all
2434: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2435: from DUAL

Line 2433: from DUAL union all

2429: from DUAL union all
2430: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2431: from DUAL union all
2432: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2433: from DUAL union all
2434: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2435: from DUAL
2436: ) fin_plan,
2437: (

Line 2435: from DUAL

2431: from DUAL union all
2432: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2433: from DUAL union all
2434: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2435: from DUAL
2436: ) fin_plan,
2437: (
2438: select 1 WBS_SUP_LEVEL,
2439: 1 WBS_SUB_LEVEL,

Line 2441: from DUAL

2437: (
2438: select 1 WBS_SUP_LEVEL,
2439: 1 WBS_SUB_LEVEL,
2440: 'PRJ' INVERT_ID
2441: from DUAL
2442: union all
2443: select 1 WBS_SUP_LEVEL,
2444: 1 WBS_SUB_LEVEL,
2445: 'WBS' INVERT_ID

Line 2446: from DUAL

2442: union all
2443: select 1 WBS_SUP_LEVEL,
2444: 1 WBS_SUB_LEVEL,
2445: 'WBS' INVERT_ID
2446: from DUAL
2447: ) top_slice
2448: where
2449: prg.STRUCT_TYPE = 'PRG' and
2450: prg.SUP_LEVEL = lv_level and

Line 2576: from DUAL union all

2572: (
2573: select 'Y' CB_FLAG,
2574: 'N' CO_FLAG,
2575: -3 PLAN_VERSION_ID
2576: from DUAL union all
2577: select 'N' CB_FLAG,
2578: 'Y' CO_FLAG,
2579: -4 PLAN_VERSION_ID
2580: from DUAL union all

Line 2580: from DUAL union all

2576: from DUAL union all
2577: select 'N' CB_FLAG,
2578: 'Y' CO_FLAG,
2579: -4 PLAN_VERSION_ID
2580: from DUAL union all
2581: select 'Y' CB_FLAG,
2582: 'Y' CO_FLAG,
2583: -3 PLAN_VERSION_ID
2584: from DUAL union all

Line 2584: from DUAL union all

2580: from DUAL union all
2581: select 'Y' CB_FLAG,
2582: 'Y' CO_FLAG,
2583: -3 PLAN_VERSION_ID
2584: from DUAL union all
2585: select 'Y' CB_FLAG,
2586: 'Y' CO_FLAG,
2587: -4 PLAN_VERSION_ID
2588: from DUAL

Line 2588: from DUAL

2584: from DUAL union all
2585: select 'Y' CB_FLAG,
2586: 'Y' CO_FLAG,
2587: -4 PLAN_VERSION_ID
2588: from DUAL
2589: ) fin_plan
2590: where
2591: prg.STRUCT_TYPE = 'PRG' and
2592: prg.SUP_LEVEL = lv_level and

Line 2727: from DUAL union all

2723: PJI_XBS_DENORM prg,
2724: PJI_FP_XBS_ACCUM_F fpr,
2725: (
2726: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2727: from DUAL union all
2728: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2729: from DUAL union all
2730: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2731: from DUAL union all

Line 2729: from DUAL union all

2725: (
2726: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2727: from DUAL union all
2728: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2729: from DUAL union all
2730: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2731: from DUAL union all
2732: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2733: from DUAL union all

Line 2731: from DUAL union all

2727: from DUAL union all
2728: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2729: from DUAL union all
2730: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2731: from DUAL union all
2732: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2733: from DUAL union all
2734: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2735: from DUAL union all

Line 2733: from DUAL union all

2729: from DUAL union all
2730: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2731: from DUAL union all
2732: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2733: from DUAL union all
2734: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2735: from DUAL union all
2736: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2737: from DUAL union all

Line 2735: from DUAL union all

2731: from DUAL union all
2732: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2733: from DUAL union all
2734: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2735: from DUAL union all
2736: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2737: from DUAL union all
2738: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2739: from DUAL union all

Line 2737: from DUAL union all

2733: from DUAL union all
2734: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2735: from DUAL union all
2736: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2737: from DUAL union all
2738: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2739: from DUAL union all
2740: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2741: from DUAL

Line 2739: from DUAL union all

2735: from DUAL union all
2736: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2737: from DUAL union all
2738: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2739: from DUAL union all
2740: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2741: from DUAL
2742: ) fin_plan,
2743: (

Line 2741: from DUAL

2737: from DUAL union all
2738: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2739: from DUAL union all
2740: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2741: from DUAL
2742: ) fin_plan,
2743: (
2744: select 1 WBS_SUP_LEVEL,
2745: 1 WBS_SUB_LEVEL,

Line 2747: from DUAL

2743: (
2744: select 1 WBS_SUP_LEVEL,
2745: 1 WBS_SUB_LEVEL,
2746: 'PRJ' INVERT_ID
2747: from DUAL
2748: union all
2749: select 1 WBS_SUP_LEVEL,
2750: 1 WBS_SUB_LEVEL,
2751: 'WBS' INVERT_ID

Line 2752: from DUAL

2748: union all
2749: select 1 WBS_SUP_LEVEL,
2750: 1 WBS_SUB_LEVEL,
2751: 'WBS' INVERT_ID
2752: from DUAL
2753: ) top_slice
2754: where
2755: prg.STRUCT_TYPE = 'PRG' and
2756: prg.SUP_LEVEL = lv_level and

Line 2813: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all

2809: from
2810: PJI_PJP_PROJ_BATCH_MAP map,
2811: PJI_XBS_DENORM prg,
2812: (
2813: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
2814: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
2815: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
2816: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
2817: ) invert,

Line 2814: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

2810: PJI_PJP_PROJ_BATCH_MAP map,
2811: PJI_XBS_DENORM prg,
2812: (
2813: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
2814: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
2815: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
2816: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
2817: ) invert,
2818: PJI_XBS_DENORM_DELTA prg_delta

Line 2815: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

2811: PJI_XBS_DENORM prg,
2812: (
2813: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
2814: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
2815: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
2816: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
2817: ) invert,
2818: PJI_XBS_DENORM_DELTA prg_delta
2819: where

Line 2816: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual

2812: (
2813: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
2814: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
2815: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
2816: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
2817: ) invert,
2818: PJI_XBS_DENORM_DELTA prg_delta
2819: where
2820: prg.STRUCT_TYPE = 'PRG' and

Line 3791: dual

3787: l_new_model_projects_flag := 'N';
3788:
3789: select 'Y' into l_new_model_projects_flag
3790: from
3791: dual
3792: where c.pjt_rollup_flag = 'N'
3793: and exists
3794: ( select 'x' from
3795: pa_projects_all p1,

Line 4646: -- FROM DUAL ;

4642: -- x_return_status => l_return_status);
4643:
4644: -- SELECT DECODE(l_extraction_type, 'PARTIAL', 'PLANTYPE', l_extraction_type)
4645: -- INTO l_extraction_type
4646: -- FROM DUAL ;
4647:
4648: Pji_Fm_Plan_Maint_Pvt.OBTAIN_RELEASE_LOCKS (
4649: p_context => l_extraction_type
4650: , p_lock_mode => 'P'

Line 5226: dual

5222: l_created_by,
5223: l_last_update_login,
5224: 'A'
5225: from
5226: dual
5227: where
5228: not exists
5229: (
5230: select

Line 5433: DUAL

5429: c.RBS_VERSION_ID,
5430: 'I',
5431: 'X'
5432: from
5433: DUAL
5434: where
5435: not exists (select 1
5436: from PA_RBS_DENORM rbs
5437: where rbs.STRUCT_VERSION_ID = c.RBS_VERSION_ID);

Line 5550: DUAL

5546: c.RBS_VERSION_ID,
5547: 'I',
5548: 'X'
5549: from
5550: DUAL
5551: where
5552: not exists (select 1
5553: from PA_RBS_DENORM rbs
5554: where rbs.STRUCT_VERSION_ID = c.RBS_VERSION_ID);

Line 5627: DUAL

5623: c.RBS_VERSION_ID,
5624: 'I',
5625: 'X'
5626: from
5627: DUAL
5628: where
5629: not exists (select 1
5630: from PA_RBS_DENORM rbs
5631: where rbs.STRUCT_VERSION_ID = c.RBS_VERSION_ID);

Line 6202: DUAL

6198: c.RBS_VERSION_ID,
6199: 'I',
6200: 'X'
6201: from
6202: DUAL
6203: where
6204: not exists (select 1
6205: from PA_RBS_DENORM rbs
6206: where rbs.STRUCT_VERSION_ID = c.RBS_VERSION_ID);

Line 7529: select 1 INVERT_ID from dual

7525: PJI_ORG_EXTR_INFO info,
7526: PJI_PJP_WBS_HEADER wbs_hdr,
7527: PA_PROJ_ELEMENT_VERSIONS ver,
7528: (
7529: select 1 INVERT_ID from dual
7530: where l_g1_currency_flag = 'Y' and /* Added for Bug 8708651 */
7531: l_g1_currency_code is not null union all
7532: select 2 INVERT_ID from dual
7533: where l_g2_currency_flag = 'Y' and

Line 7532: select 2 INVERT_ID from dual

7528: (
7529: select 1 INVERT_ID from dual
7530: where l_g1_currency_flag = 'Y' and /* Added for Bug 8708651 */
7531: l_g1_currency_code is not null union all
7532: select 2 INVERT_ID from dual
7533: where l_g2_currency_flag = 'Y' and
7534: l_g2_currency_code is not null union all
7535: select 4 INVERT_ID from dual union all
7536: select 8 INVERT_ID from dual union all

Line 7535: select 4 INVERT_ID from dual union all

7531: l_g1_currency_code is not null union all
7532: select 2 INVERT_ID from dual
7533: where l_g2_currency_flag = 'Y' and
7534: l_g2_currency_code is not null union all
7535: select 4 INVERT_ID from dual union all
7536: select 8 INVERT_ID from dual union all
7537: select 16 INVERT_ID from dual
7538: where l_txn_currency_flag = 'Y'
7539: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW

Line 7536: select 8 INVERT_ID from dual union all

7532: select 2 INVERT_ID from dual
7533: where l_g2_currency_flag = 'Y' and
7534: l_g2_currency_code is not null union all
7535: select 4 INVERT_ID from dual union all
7536: select 8 INVERT_ID from dual union all
7537: select 16 INVERT_ID from dual
7538: where l_txn_currency_flag = 'Y'
7539: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
7540: -- where l_g1_currency_code is not null union all

Line 7537: select 16 INVERT_ID from dual

7533: where l_g2_currency_flag = 'Y' and
7534: l_g2_currency_code is not null union all
7535: select 4 INVERT_ID from dual union all
7536: select 8 INVERT_ID from dual union all
7537: select 16 INVERT_ID from dual
7538: where l_txn_currency_flag = 'Y'
7539: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
7540: -- where l_g1_currency_code is not null union all
7541: -- select 64 INVERT_ID from dual

Line 7539: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW

7535: select 4 INVERT_ID from dual union all
7536: select 8 INVERT_ID from dual union all
7537: select 16 INVERT_ID from dual
7538: where l_txn_currency_flag = 'Y'
7539: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
7540: -- where l_g1_currency_code is not null union all
7541: -- select 64 INVERT_ID from dual
7542: -- where l_g2_currency_flag = 'Y' and
7543: -- l_g2_currency_code is not null union all

Line 7541: -- select 64 INVERT_ID from dual

7537: select 16 INVERT_ID from dual
7538: where l_txn_currency_flag = 'Y'
7539: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
7540: -- where l_g1_currency_code is not null union all
7541: -- select 64 INVERT_ID from dual
7542: -- where l_g2_currency_flag = 'Y' and
7543: -- l_g2_currency_code is not null union all
7544: -- select 128 INVERT_ID from dual union all
7545: -- select 256 INVERT_ID from dual

Line 7544: -- select 128 INVERT_ID from dual union all

7540: -- where l_g1_currency_code is not null union all
7541: -- select 64 INVERT_ID from dual
7542: -- where l_g2_currency_flag = 'Y' and
7543: -- l_g2_currency_code is not null union all
7544: -- select 128 INVERT_ID from dual union all
7545: -- select 256 INVERT_ID from dual
7546: ) invert
7547: where
7548: src.TXN_ACCUM_HEADER_ID = rbs.TXN_ACCUM_HEADER_ID (+) and

Line 7545: -- select 256 INVERT_ID from dual

7541: -- select 64 INVERT_ID from dual
7542: -- where l_g2_currency_flag = 'Y' and
7543: -- l_g2_currency_code is not null union all
7544: -- select 128 INVERT_ID from dual union all
7545: -- select 256 INVERT_ID from dual
7546: ) invert
7547: where
7548: src.TXN_ACCUM_HEADER_ID = rbs.TXN_ACCUM_HEADER_ID (+) and
7549: src.RBS_VERSION_ID = rbs.STRUCT_VERSION_ID (+) and

Line 8229: select 1 INVERT_ID from dual

8225: PJI_PJP_PROJ_BATCH_MAP map,
8226: PJI_PJP_WBS_HEADER wbs_hdr,
8227: PA_PROJ_ELEMENT_VERSIONS ver,
8228: (
8229: select 1 INVERT_ID from dual
8230: where l_g1_currency_flag = 'Y' and /* Added for Bug 8708651 */
8231: l_g1_currency_code is not null union all
8232: select 2 INVERT_ID from dual
8233: where l_g2_currency_flag = 'Y' and

Line 8232: select 2 INVERT_ID from dual

8228: (
8229: select 1 INVERT_ID from dual
8230: where l_g1_currency_flag = 'Y' and /* Added for Bug 8708651 */
8231: l_g1_currency_code is not null union all
8232: select 2 INVERT_ID from dual
8233: where l_g2_currency_flag = 'Y' and
8234: l_g2_currency_code is not null union all
8235: select 4 INVERT_ID from dual union all
8236: select 8 INVERT_ID from dual union all

Line 8235: select 4 INVERT_ID from dual union all

8231: l_g1_currency_code is not null union all
8232: select 2 INVERT_ID from dual
8233: where l_g2_currency_flag = 'Y' and
8234: l_g2_currency_code is not null union all
8235: select 4 INVERT_ID from dual union all
8236: select 8 INVERT_ID from dual union all
8237: select 16 INVERT_ID from dual
8238: where l_txn_currency_flag = 'Y'
8239: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW

Line 8236: select 8 INVERT_ID from dual union all

8232: select 2 INVERT_ID from dual
8233: where l_g2_currency_flag = 'Y' and
8234: l_g2_currency_code is not null union all
8235: select 4 INVERT_ID from dual union all
8236: select 8 INVERT_ID from dual union all
8237: select 16 INVERT_ID from dual
8238: where l_txn_currency_flag = 'Y'
8239: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
8240: -- where l_g1_currency_code is not null union all

Line 8237: select 16 INVERT_ID from dual

8233: where l_g2_currency_flag = 'Y' and
8234: l_g2_currency_code is not null union all
8235: select 4 INVERT_ID from dual union all
8236: select 8 INVERT_ID from dual union all
8237: select 16 INVERT_ID from dual
8238: where l_txn_currency_flag = 'Y'
8239: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
8240: -- where l_g1_currency_code is not null union all
8241: -- select 64 INVERT_ID from dual

Line 8239: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW

8235: select 4 INVERT_ID from dual union all
8236: select 8 INVERT_ID from dual union all
8237: select 16 INVERT_ID from dual
8238: where l_txn_currency_flag = 'Y'
8239: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
8240: -- where l_g1_currency_code is not null union all
8241: -- select 64 INVERT_ID from dual
8242: -- where l_g2_currency_flag = 'Y' and
8243: -- l_g2_currency_code is not null union all

Line 8241: -- select 64 INVERT_ID from dual

8237: select 16 INVERT_ID from dual
8238: where l_txn_currency_flag = 'Y'
8239: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
8240: -- where l_g1_currency_code is not null union all
8241: -- select 64 INVERT_ID from dual
8242: -- where l_g2_currency_flag = 'Y' and
8243: -- l_g2_currency_code is not null union all
8244: -- select 128 INVERT_ID from dual union all
8245: -- select 256 INVERT_ID from dual

Line 8244: -- select 128 INVERT_ID from dual union all

8240: -- where l_g1_currency_code is not null union all
8241: -- select 64 INVERT_ID from dual
8242: -- where l_g2_currency_flag = 'Y' and
8243: -- l_g2_currency_code is not null union all
8244: -- select 128 INVERT_ID from dual union all
8245: -- select 256 INVERT_ID from dual
8246: ) invert
8247: where
8248: map.WORKER_ID = p_worker_id and

Line 8245: -- select 256 INVERT_ID from dual

8241: -- select 64 INVERT_ID from dual
8242: -- where l_g2_currency_flag = 'Y' and
8243: -- l_g2_currency_code is not null union all
8244: -- select 128 INVERT_ID from dual union all
8245: -- select 256 INVERT_ID from dual
8246: ) invert
8247: where
8248: map.WORKER_ID = p_worker_id and
8249: src.PROJECT_ID = map.PROJECT_ID and

Line 8501: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual

8497: (
8498: Select decode(
8499: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
8500: decode( bitand(l_refresh_code,g_cb_plans),g_cb_plans,
8501: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual
8502: UNION ALL
8503: Select decode(
8504: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
8505: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual

Line 8505: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual

8501: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual
8502: UNION ALL
8503: Select decode(
8504: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
8505: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual
8506: )
8507: OR -- Bug#5099574 Pull Reversals for Fin plan Working Versions when l_refresh_code=16,30. ignore if l_refresh_code>=62
8508: (
8509: bv.BUDGET_STATUS_CODE in ('W','S') and

Line 8536: select decode (bitand (l_refresh_code,1),1,-1,-999) plan_version_id from dual where l_plan_type_id is null

8532: map.worker_id,map.project_id, plan_version_id, 'G' time_phased_code
8533: from
8534: PJI_PJP_PROJ_BATCH_MAP map,
8535: (
8536: select decode (bitand (l_refresh_code,1),1,-1,-999) plan_version_id from dual where l_plan_type_id is null
8537: union all
8538: select decode (bitand (l_refresh_code,g_cb_plans),g_cb_plans,-3,-999) plan_version_id from dual
8539: union all
8540: select decode (bitand (l_refresh_code,g_co_plans),g_co_plans,-4,-999) plan_version_id from dual

Line 8538: select decode (bitand (l_refresh_code,g_cb_plans),g_cb_plans,-3,-999) plan_version_id from dual

8534: PJI_PJP_PROJ_BATCH_MAP map,
8535: (
8536: select decode (bitand (l_refresh_code,1),1,-1,-999) plan_version_id from dual where l_plan_type_id is null
8537: union all
8538: select decode (bitand (l_refresh_code,g_cb_plans),g_cb_plans,-3,-999) plan_version_id from dual
8539: union all
8540: select decode (bitand (l_refresh_code,g_co_plans),g_co_plans,-4,-999) plan_version_id from dual
8541: )
8542: where map.worker_id=p_worker_id;

Line 8540: select decode (bitand (l_refresh_code,g_co_plans),g_co_plans,-4,-999) plan_version_id from dual

8536: select decode (bitand (l_refresh_code,1),1,-1,-999) plan_version_id from dual where l_plan_type_id is null
8537: union all
8538: select decode (bitand (l_refresh_code,g_cb_plans),g_cb_plans,-3,-999) plan_version_id from dual
8539: union all
8540: select decode (bitand (l_refresh_code,g_co_plans),g_co_plans,-4,-999) plan_version_id from dual
8541: )
8542: where map.worker_id=p_worker_id;
8543:
8544:

Line 9899: select 'ACTIVITY' INVERT_ID from DUAL union all

9895: PJI_TIME_RPT_STRUCT cal,
9896: PJI_AC_XBS_ACCUM_F acr,
9897: PJI_PJP_PROJ_BATCH_MAP map,
9898: (
9899: select 'ACTIVITY' INVERT_ID from DUAL union all
9900: select 'SNAPSHOT' INVERT_ID from DUAL
9901: ) invert
9902: where
9903: l_extraction_type <> 'PARTIAL' and

Line 9900: select 'SNAPSHOT' INVERT_ID from DUAL

9896: PJI_AC_XBS_ACCUM_F acr,
9897: PJI_PJP_PROJ_BATCH_MAP map,
9898: (
9899: select 'ACTIVITY' INVERT_ID from DUAL union all
9900: select 'SNAPSHOT' INVERT_ID from DUAL
9901: ) invert
9902: where
9903: l_extraction_type <> 'PARTIAL' and
9904: map.WORKER_ID = p_worker_id and

Line 10043: select 'ACTIVITY' INVERT_ID from DUAL union all

10039: PJI_TIME_CAL_PERIOD_V gl_cal,
10040: PJI_TIME_CAL_RPT_STRUCT cal,
10041: PJI_PJP_PROJ_BATCH_MAP map,
10042: (
10043: select 'ACTIVITY' INVERT_ID from DUAL union all
10044: select 'SNAPSHOT' INVERT_ID from DUAL
10045: ) invert
10046: where
10047: l_extraction_type <> 'PARTIAL' and

Line 10044: select 'SNAPSHOT' INVERT_ID from DUAL

10040: PJI_TIME_CAL_RPT_STRUCT cal,
10041: PJI_PJP_PROJ_BATCH_MAP map,
10042: (
10043: select 'ACTIVITY' INVERT_ID from DUAL union all
10044: select 'SNAPSHOT' INVERT_ID from DUAL
10045: ) invert
10046: where
10047: l_extraction_type <> 'PARTIAL' and
10048: map.WORKER_ID = p_worker_id and

Line 10190: select 'ACTIVITY' INVERT_ID from DUAL union all

10186: PJI_TIME_CAL_PERIOD_V pa_cal,
10187: PJI_TIME_CAL_RPT_STRUCT cal,
10188: PJI_PJP_PROJ_BATCH_MAP map,
10189: (
10190: select 'ACTIVITY' INVERT_ID from DUAL union all
10191: select 'SNAPSHOT' INVERT_ID from DUAL
10192: ) invert
10193: where
10194: l_extraction_type <> 'PARTIAL' and

Line 10191: select 'SNAPSHOT' INVERT_ID from DUAL

10187: PJI_TIME_CAL_RPT_STRUCT cal,
10188: PJI_PJP_PROJ_BATCH_MAP map,
10189: (
10190: select 'ACTIVITY' INVERT_ID from DUAL union all
10191: select 'SNAPSHOT' INVERT_ID from DUAL
10192: ) invert
10193: where
10194: l_extraction_type <> 'PARTIAL' and
10195: map.WORKER_ID = p_worker_id and

Line 11014: from dual;

11010: l_fpm_upgrade := nvl(PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE'), 'C');
11011:
11012: select decode(l_extraction_type,'PARTIAL','PARTIAL',NULL)
11013: into l_partial_mode
11014: from dual;
11015:
11016: -- allow recovery after each level is processed
11017:
11018: select

Line 11076: DUAL;

11072: 'ROLLUP_FPR_WBS - level ' || to_char(l_level - x + 1) STEP_NAME,
11073: null START_DATE,
11074: null END_DATE
11075: from
11076: DUAL;
11077:
11078: end loop;
11079:
11080: end if;

Line 11896: from DUAL union all

11892: PA_XBS_DENORM wbs,
11893: PJI_XBS_DENORM prg,
11894: (
11895: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11896: from DUAL union all
11897: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11898: from DUAL union all
11899: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11900: from DUAL union all

Line 11898: from DUAL union all

11894: (
11895: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11896: from DUAL union all
11897: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11898: from DUAL union all
11899: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11900: from DUAL union all
11901: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11902: from DUAL union all

Line 11900: from DUAL union all

11896: from DUAL union all
11897: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11898: from DUAL union all
11899: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11900: from DUAL union all
11901: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11902: from DUAL union all
11903: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11904: from DUAL union all

Line 11902: from DUAL union all

11898: from DUAL union all
11899: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11900: from DUAL union all
11901: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11902: from DUAL union all
11903: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11904: from DUAL union all
11905: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11906: from DUAL union all

Line 11904: from DUAL union all

11900: from DUAL union all
11901: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11902: from DUAL union all
11903: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11904: from DUAL union all
11905: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11906: from DUAL union all
11907: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11908: from DUAL union all

Line 11906: from DUAL union all

11902: from DUAL union all
11903: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
11904: from DUAL union all
11905: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11906: from DUAL union all
11907: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11908: from DUAL union all
11909: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11910: from DUAL

Line 11908: from DUAL union all

11904: from DUAL union all
11905: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11906: from DUAL union all
11907: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11908: from DUAL union all
11909: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11910: from DUAL
11911: ) fin_plan,
11912: (

Line 11910: from DUAL

11906: from DUAL union all
11907: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
11908: from DUAL union all
11909: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
11910: from DUAL
11911: ) fin_plan,
11912: (
11913: select 1 WBS_SUP_LEVEL,
11914: 1 WBS_SUB_LEVEL,

Line 11916: from DUAL

11912: (
11913: select 1 WBS_SUP_LEVEL,
11914: 1 WBS_SUB_LEVEL,
11915: 'PRJ' INVERT_ID
11916: from DUAL
11917: union all
11918: select 1 WBS_SUP_LEVEL,
11919: 1 WBS_SUB_LEVEL,
11920: 'WBS' INVERT_ID

Line 11921: from DUAL

11917: union all
11918: select 1 WBS_SUP_LEVEL,
11919: 1 WBS_SUB_LEVEL,
11920: 'WBS' INVERT_ID
11921: from DUAL
11922: ) top_slice
11923: where
11924: prg.STRUCT_TYPE = 'PRG' and
11925: prg.SUP_LEVEL = l_level and

Line 12051: from DUAL union all

12047: (
12048: select 'Y' CB_FLAG,
12049: 'N' CO_FLAG,
12050: -3 PLAN_VERSION_ID
12051: from DUAL union all
12052: select 'N' CB_FLAG,
12053: 'Y' CO_FLAG,
12054: -4 PLAN_VERSION_ID
12055: from DUAL union all

Line 12055: from DUAL union all

12051: from DUAL union all
12052: select 'N' CB_FLAG,
12053: 'Y' CO_FLAG,
12054: -4 PLAN_VERSION_ID
12055: from DUAL union all
12056: select 'Y' CB_FLAG,
12057: 'Y' CO_FLAG,
12058: -3 PLAN_VERSION_ID
12059: from DUAL union all

Line 12059: from DUAL union all

12055: from DUAL union all
12056: select 'Y' CB_FLAG,
12057: 'Y' CO_FLAG,
12058: -3 PLAN_VERSION_ID
12059: from DUAL union all
12060: select 'Y' CB_FLAG,
12061: 'Y' CO_FLAG,
12062: -4 PLAN_VERSION_ID
12063: from DUAL

Line 12063: from DUAL

12059: from DUAL union all
12060: select 'Y' CB_FLAG,
12061: 'Y' CO_FLAG,
12062: -4 PLAN_VERSION_ID
12063: from DUAL
12064: ) fin_plan
12065: where
12066: prg.STRUCT_TYPE = 'PRG' and
12067: prg.SUP_LEVEL = l_level and

Line 12204: from DUAL union all

12200: PJI_XBS_DENORM prg,
12201: PJI_FP_XBS_ACCUM_F fpr,
12202: (
12203: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12204: from DUAL union all
12205: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12206: from DUAL union all
12207: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12208: from DUAL union all

Line 12206: from DUAL union all

12202: (
12203: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12204: from DUAL union all
12205: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12206: from DUAL union all
12207: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12208: from DUAL union all
12209: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12210: from DUAL union all

Line 12208: from DUAL union all

12204: from DUAL union all
12205: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12206: from DUAL union all
12207: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12208: from DUAL union all
12209: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12210: from DUAL union all
12211: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12212: from DUAL union all

Line 12210: from DUAL union all

12206: from DUAL union all
12207: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12208: from DUAL union all
12209: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12210: from DUAL union all
12211: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12212: from DUAL union all
12213: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12214: from DUAL union all

Line 12212: from DUAL union all

12208: from DUAL union all
12209: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12210: from DUAL union all
12211: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12212: from DUAL union all
12213: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12214: from DUAL union all
12215: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12216: from DUAL union all

Line 12214: from DUAL union all

12210: from DUAL union all
12211: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
12212: from DUAL union all
12213: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12214: from DUAL union all
12215: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12216: from DUAL union all
12217: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12218: from DUAL

Line 12216: from DUAL union all

12212: from DUAL union all
12213: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12214: from DUAL union all
12215: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12216: from DUAL union all
12217: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12218: from DUAL
12219: ) fin_plan,
12220: (

Line 12218: from DUAL

12214: from DUAL union all
12215: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
12216: from DUAL union all
12217: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
12218: from DUAL
12219: ) fin_plan,
12220: (
12221: select 1 WBS_SUP_LEVEL,
12222: 1 WBS_SUB_LEVEL,

Line 12224: from DUAL

12220: (
12221: select 1 WBS_SUP_LEVEL,
12222: 1 WBS_SUB_LEVEL,
12223: 'PRJ' INVERT_ID
12224: from DUAL
12225: union all
12226: select 1 WBS_SUP_LEVEL,
12227: 1 WBS_SUB_LEVEL,
12228: 'WBS' INVERT_ID

Line 12229: from DUAL

12225: union all
12226: select 1 WBS_SUP_LEVEL,
12227: 1 WBS_SUB_LEVEL,
12228: 'WBS' INVERT_ID
12229: from DUAL
12230: ) top_slice
12231: where
12232: prg.STRUCT_TYPE = 'PRG' and
12233: prg.SUP_LEVEL = l_level and

Line 13078: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all

13074: from
13075: PJI_XBS_DENORM prg,
13076: PA_PROJECTS_ALL prj,
13077: (
13078: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13079: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
13080: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13081: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
13082: ) invert

Line 13079: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all

13075: PJI_XBS_DENORM prg,
13076: PA_PROJECTS_ALL prj,
13077: (
13078: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13079: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
13080: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13081: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
13082: ) invert
13083: where

Line 13080: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all

13076: PA_PROJECTS_ALL prj,
13077: (
13078: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13079: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
13080: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13081: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
13082: ) invert
13083: where
13084: l_level > 1 and

Line 13081: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual

13077: (
13078: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13079: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
13080: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
13081: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
13082: ) invert
13083: where
13084: l_level > 1 and
13085: prg.STRUCT_TYPE = 'PRG' and

Line 13614: from DUAL

13610: PA_XBS_DENORM wbs,
13611: (
13612: select 1 WBS_SUP_LEVEL,
13613: 'PRJ' INVERT_ID
13614: from DUAL
13615: union all
13616: select 1 WBS_SUP_LEVEL,
13617: 'WBS' INVERT_ID
13618: from DUAL

Line 13618: from DUAL

13614: from DUAL
13615: union all
13616: select 1 WBS_SUP_LEVEL,
13617: 'WBS' INVERT_ID
13618: from DUAL
13619: ) top_slice
13620: where
13621: l_extraction_type <> 'RBS' and
13622: 'WBS' = wbs.STRUCT_TYPE (+) and

Line 14069: from DUAL

14065: PA_XBS_DENORM wbs,
14066: (
14067: select 1 WBS_SUP_LEVEL,
14068: 'PRJ' INVERT_ID
14069: from DUAL
14070: union all
14071: select 1 WBS_SUP_LEVEL,
14072: 'WBS' INVERT_ID
14073: from DUAL

Line 14073: from DUAL

14069: from DUAL
14070: union all
14071: select 1 WBS_SUP_LEVEL,
14072: 'WBS' INVERT_ID
14073: from DUAL
14074: ) top_slice
14075: where
14076: -- l_extraction_type <> 'RBS' and
14077: 'WBS' = wbs.STRUCT_TYPE (+) and

Line 14234: DUAL;

14230: 'ROLLUP_ACR_WBS - level ' || to_char(l_level - x + 1) STEP_NAME,
14231: null START_DATE,
14232: null END_DATE
14233: from
14234: DUAL;
14235:
14236: end loop;
14237:
14238: end if;

Line 14543: from DUAL

14539: (
14540: select 1 WBS_SUP_LEVEL,
14541: 1 WBS_SUB_LEVEL,
14542: 'PRJ' INVERT_ID
14543: from DUAL
14544: union all
14545: select 1 WBS_SUP_LEVEL,
14546: 1 WBS_SUB_LEVEL,
14547: 'WBS' INVERT_ID

Line 14548: from DUAL

14544: union all
14545: select 1 WBS_SUP_LEVEL,
14546: 1 WBS_SUB_LEVEL,
14547: 'WBS' INVERT_ID
14548: from DUAL
14549: ) top_slice
14550: where
14551: prg.STRUCT_TYPE = 'PRG' and
14552: prg.SUP_LEVEL = l_level and

Line 14733: from DUAL

14729: (
14730: select 1 WBS_SUP_LEVEL,
14731: 1 WBS_SUB_LEVEL,
14732: 'PRJ' INVERT_ID
14733: from DUAL
14734: union all
14735: select 1 WBS_SUP_LEVEL,
14736: 1 WBS_SUB_LEVEL,
14737: 'WBS' INVERT_ID

Line 14738: from DUAL

14734: union all
14735: select 1 WBS_SUP_LEVEL,
14736: 1 WBS_SUB_LEVEL,
14737: 'WBS' INVERT_ID
14738: from DUAL
14739: ) top_slice
14740: where
14741: prg.STRUCT_TYPE = 'PRG' and
14742: prg.SUP_LEVEL = l_level and

Line 15174: from DUAL

15170: (
15171: select 1 WBS_SUP_LEVEL,
15172: 1 WBS_SUB_LEVEL,
15173: 'PRJ' INVERT_ID
15174: from DUAL
15175: union all
15176: select 1 WBS_SUP_LEVEL,
15177: 1 WBS_SUB_LEVEL,
15178: 'WBS' INVERT_ID

Line 15179: from DUAL

15175: union all
15176: select 1 WBS_SUP_LEVEL,
15177: 1 WBS_SUB_LEVEL,
15178: 'WBS' INVERT_ID
15179: from DUAL
15180: ) top_slice
15181: where
15182: prg.STRUCT_TYPE = 'PRG' and
15183: prg.SUP_LEVEL = l_level and

Line 15365: from DUAL

15361: (
15362: select 1 WBS_SUP_LEVEL,
15363: 1 WBS_SUB_LEVEL,
15364: 'PRJ' INVERT_ID
15365: from DUAL
15366: union all
15367: select 1 WBS_SUP_LEVEL,
15368: 1 WBS_SUB_LEVEL,
15369: 'WBS' INVERT_ID

Line 15370: from DUAL

15366: union all
15367: select 1 WBS_SUP_LEVEL,
15368: 1 WBS_SUB_LEVEL,
15369: 'WBS' INVERT_ID
15370: from DUAL
15371: ) top_slice
15372: where
15373: prg.STRUCT_TYPE = 'PRG' and
15374: prg.SUP_LEVEL = l_level and

Line 16141: from DUAL union all

16137: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
16138: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
16139: (
16140: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
16141: from DUAL union all
16142: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
16143: from DUAL union all
16144: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
16145: from DUAL union all

Line 16143: from DUAL union all

16139: (
16140: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
16141: from DUAL union all
16142: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
16143: from DUAL union all
16144: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
16145: from DUAL union all
16146: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
16147: from DUAL

Line 16145: from DUAL union all

16141: from DUAL union all
16142: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
16143: from DUAL union all
16144: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
16145: from DUAL union all
16146: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
16147: from DUAL
16148: ) fin_plan
16149: where

Line 16147: from DUAL

16143: from DUAL union all
16144: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
16145: from DUAL union all
16146: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
16147: from DUAL
16148: ) fin_plan
16149: where
16150: prg.WORKER_ID = p_worker_id and
16151: prg.STRUCT_TYPE = 'PRG' and

Line 16542: from DUAL union all

16538: PA_PROJ_ELEM_VER_STRUCTURE sub_ver,
16539: PA_PROJ_ELEM_VER_STRUCTURE sup_ver,
16540: (
16541: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
16542: from DUAL union all
16543: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
16544: from DUAL union all
16545: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
16546: from DUAL union all

Line 16544: from DUAL union all

16540: (
16541: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID
16542: from DUAL union all
16543: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
16544: from DUAL union all
16545: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
16546: from DUAL union all
16547: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
16548: from DUAL

Line 16546: from DUAL union all

16542: from DUAL union all
16543: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID
16544: from DUAL union all
16545: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
16546: from DUAL union all
16547: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
16548: from DUAL
16549: ) fin_plan
16550: where

Line 16548: from DUAL

16544: from DUAL union all
16545: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID
16546: from DUAL union all
16547: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID
16548: from DUAL
16549: ) fin_plan
16550: where
16551: prg.STRUCT_TYPE = 'PRG' and
16552: prg.SUP_LEVEL = l_level and

Line 16639: from DUAL

16635: PA_XBS_DENORM wbs,
16636: (
16637: select 1 WBS_SUP_LEVEL,
16638: 'PRJ' INVERT_ID
16639: from DUAL
16640: union all
16641: select 1 WBS_SUP_LEVEL,
16642: 'WBS' INVERT_ID
16643: from DUAL

Line 16643: from DUAL

16639: from DUAL
16640: union all
16641: select 1 WBS_SUP_LEVEL,
16642: 'WBS' INVERT_ID
16643: from DUAL
16644: ) top_slice
16645: where
16646: map.WORKER_ID = p_worker_id and
16647: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 17193: from DUAL

17189: PA_XBS_DENORM wbs,
17190: (
17191: select 1 WBS_SUP_LEVEL,
17192: 'PRJ' INVERT_ID
17193: from DUAL
17194: union all
17195: select 1 WBS_SUP_LEVEL,
17196: 'WBS' INVERT_ID
17197: from DUAL

Line 17197: from DUAL

17193: from DUAL
17194: union all
17195: select 1 WBS_SUP_LEVEL,
17196: 'WBS' INVERT_ID
17197: from DUAL
17198: ) top_slice
17199: where
17200: map.WORKER_ID = p_worker_id and
17201: map.PROJECT_ID = pjp.SUP_PROJECT_ID and

Line 18551: select 1 INVERT_ID from DUAL union all

18547: 2, log.ATTRIBUTE1) PRG_GROUP
18548: from
18549: PJI_PA_PROJ_EVENTS_LOG log,
18550: (
18551: select 1 INVERT_ID from DUAL union all
18552: select 2 INVERT_ID from DUAL
18553: ) invert
18554: where
18555: log.WORKER_ID = p_worker_id and

Line 18552: select 2 INVERT_ID from DUAL

18548: from
18549: PJI_PA_PROJ_EVENTS_LOG log,
18550: (
18551: select 1 INVERT_ID from DUAL union all
18552: select 2 INVERT_ID from DUAL
18553: ) invert
18554: where
18555: log.WORKER_ID = p_worker_id and
18556: log.EVENT_TYPE = 'PRG_CHANGE' and

Line 18571: select 1 INVERT_ID from DUAL union all

18567: 1, log.EVENT_OBJECT,
18568: 2, log.ATTRIBUTE2)) struct_version_id
18569: from PJI_PA_PROJ_EVENTS_LOG log,
18570: (
18571: select 1 INVERT_ID from DUAL union all
18572: select 2 INVERT_ID from DUAL
18573: ) invert
18574: where
18575: log.WORKER_ID = p_worker_id and

Line 18572: select 2 INVERT_ID from DUAL

18568: 2, log.ATTRIBUTE2)) struct_version_id
18569: from PJI_PA_PROJ_EVENTS_LOG log,
18570: (
18571: select 1 INVERT_ID from DUAL union all
18572: select 2 INVERT_ID from DUAL
18573: ) invert
18574: where
18575: log.WORKER_ID = p_worker_id and
18576: log.EVENT_TYPE in ('WBS_CHANGE', 'WBS_PUBLISH'));

Line 18599: select 1 INVERT_ID from DUAL union all

18595: 2, log.ATTRIBUTE1) PRG_GROUP
18596: from
18597: PJI_PA_PROJ_EVENTS_LOG log,
18598: (
18599: select 1 INVERT_ID from DUAL union all
18600: select 2 INVERT_ID from DUAL
18601: ) invert
18602: where
18603: log.WORKER_ID = p_worker_id and

Line 18600: select 2 INVERT_ID from DUAL

18596: from
18597: PJI_PA_PROJ_EVENTS_LOG log,
18598: (
18599: select 1 INVERT_ID from DUAL union all
18600: select 2 INVERT_ID from DUAL
18601: ) invert
18602: where
18603: log.WORKER_ID = p_worker_id and
18604: log.EVENT_TYPE = 'PRG_CHANGE' and

Line 18627: select 1 INVERT_ID from DUAL union all

18623: 2, log.ATTRIBUTE2)
18624: from
18625: PJI_PA_PROJ_EVENTS_LOG log,
18626: (
18627: select 1 INVERT_ID from DUAL union all
18628: select 2 INVERT_ID from DUAL
18629: ) invert
18630: where
18631: log.WORKER_ID = p_worker_id and

Line 18628: select 2 INVERT_ID from DUAL

18624: from
18625: PJI_PA_PROJ_EVENTS_LOG log,
18626: (
18627: select 1 INVERT_ID from DUAL union all
18628: select 2 INVERT_ID from DUAL
18629: ) invert
18630: where
18631: log.WORKER_ID = p_worker_id and
18632: log.EVENT_TYPE in ('WBS_CHANGE',

Line 18697: select 1 INVERT_ID from DUAL union all

18693: 2, log.ATTRIBUTE1) PRG_GROUP
18694: from
18695: PJI_PA_PROJ_EVENTS_LOG log,
18696: (
18697: select 1 INVERT_ID from DUAL union all
18698: select 2 INVERT_ID from DUAL
18699: ) invert
18700: where
18701: log.WORKER_ID = p_worker_id and

Line 18698: select 2 INVERT_ID from DUAL

18694: from
18695: PJI_PA_PROJ_EVENTS_LOG log,
18696: (
18697: select 1 INVERT_ID from DUAL union all
18698: select 2 INVERT_ID from DUAL
18699: ) invert
18700: where
18701: log.WORKER_ID = p_worker_id and
18702: log.EVENT_TYPE = 'PRG_CHANGE' and

Line 19171: select 1 INVERT_ID from DUAL union all

19167: 'RBS_DELETE', log.EVENT_OBJECT)
19168: from
19169: PJI_PA_PROJ_EVENTS_LOG log,
19170: (
19171: select 1 INVERT_ID from DUAL union all
19172: select 2 INVERT_ID from DUAL
19173: ) invert
19174: where
19175: log.WORKER_ID = p_worker_id and

Line 19172: select 2 INVERT_ID from DUAL

19168: from
19169: PJI_PA_PROJ_EVENTS_LOG log,
19170: (
19171: select 1 INVERT_ID from DUAL union all
19172: select 2 INVERT_ID from DUAL
19173: ) invert
19174: where
19175: log.WORKER_ID = p_worker_id and
19176: log.EVENT_TYPE in ('RBS_PUSH',

Line 19465: FROM DUAL;

19461:
19462: -- Incr-Incr, Full-Initial, rbs-full, pr-full.
19463: SELECT DECODE(l_extraction_type, 'INCREMENTAL', 'INCREMENTAL', 'FULL', 'INITIAL', 'FULL')
19464: INTO l_extraction_type_wp
19465: FROM DUAL;
19466:
19467: LOOP
19468:
19469: l_project_id_tbl := system.pa_num_tbl_type();

Line 19715: -- FROM DUAL ;

19711: WHERE worker_id = p_worker_id );
19712:
19713: -- SELECT DECODE(l_extraction_type, 'PARTIAL', 'PLANTYPE', l_extraction_type)
19714: -- INTO l_extraction_type
19715: -- FROM DUAL ;
19716:
19717: Pji_Fm_Plan_Maint_Pvt.OBTAIN_RELEASE_LOCKS (
19718: p_context => l_extraction_type
19719: , p_lock_mode => NULL