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

Line 114: from dual;

110:
111: select PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER (l_e_process,l_e_process),
112: DECODE(l_e_extraction_type,'PARTIAL',g_prtl_disp_name,'RBS',g_rbs_disp_name,NULL,NULL,g_incr_disp_name)
113: into p_request_id,p_prog_name
114: from dual;
115:
116: else
117:
118: -- Need to submit the existing failed worker request

Line 172: DUAL;

168: l_e_rbs_header_id,
169: l_e_transaction_type,
170: l_e_plan_versions
171: FROM
172: DUAL;
173:
174:
175: IF l_e_program is not null then
176: p_request_id := FND_REQUEST.SUBMIT_REQUEST(

Line 1136: , ( SELECT -3 plan_version_id FROM DUAL

1132: , bv.SECONDARY_RBS_FLAG
1133: , bv.lp_flag
1134: FROM PJI_FM_EXTR_PLNVER4 bv
1135: , pji_xbs_denorm den
1136: , ( SELECT -3 plan_version_id FROM DUAL
1137: UNION ALL
1138: SELECT -4 FROM DUAL ) cbco
1139: WHERE 1=1
1140: AND bv.plan_version_id > 0

Line 1138: SELECT -4 FROM DUAL ) cbco

1134: FROM PJI_FM_EXTR_PLNVER4 bv
1135: , pji_xbs_denorm den
1136: , ( SELECT -3 plan_version_id FROM DUAL
1137: UNION ALL
1138: SELECT -4 FROM DUAL ) cbco
1139: WHERE 1=1
1140: AND bv.plan_version_id > 0
1141: AND bv.wp_flag = 'N'
1142: AND bv.baselined_flag = 'Y'

Line 2091: from DUAL union all

2087: PA_XBS_DENORM wbs,
2088: PJI_XBS_DENORM prg,
2089: (
2090: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2091: from DUAL union all
2092: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2093: from DUAL union all
2094: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2095: from DUAL union all

Line 2093: from DUAL union all

2089: (
2090: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2091: from DUAL union all
2092: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2093: from DUAL union all
2094: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2095: from DUAL union all
2096: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2097: from DUAL union all

Line 2095: from DUAL union all

2091: from DUAL union all
2092: select 'Y' CB, 'N' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2093: from DUAL union all
2094: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2095: from DUAL union all
2096: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2097: from DUAL union all
2098: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2099: from DUAL union all

Line 2097: from DUAL union all

2093: from DUAL union all
2094: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2095: from DUAL union all
2096: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2097: from DUAL union all
2098: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2099: from DUAL union all
2100: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2101: from DUAL union all

Line 2099: from DUAL union all

2095: from DUAL union all
2096: select 'N' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2097: from DUAL union all
2098: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2099: from DUAL union all
2100: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2101: from DUAL union all
2102: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2103: from DUAL union all

Line 2101: from DUAL union all

2097: from DUAL union all
2098: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRG' INVERT_ID
2099: from DUAL union all
2100: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2101: from DUAL union all
2102: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2103: from DUAL union all
2104: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2105: from DUAL

Line 2103: from DUAL union all

2099: from DUAL union all
2100: select 'Y' CB, 'Y' CO, -3 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2101: from DUAL union all
2102: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2103: from DUAL union all
2104: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2105: from DUAL
2106: ) fin_plan,
2107: (

Line 2105: from DUAL

2101: from DUAL union all
2102: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRG' INVERT_ID
2103: from DUAL union all
2104: select 'Y' CB, 'Y' CO, -4 PLAN_VERSION_ID, 'PRJ' INVERT_ID
2105: from DUAL
2106: ) fin_plan,
2107: (
2108: select 1 WBS_SUP_LEVEL,
2109: 1 WBS_SUB_LEVEL,

Line 2111: from DUAL

2107: (
2108: select 1 WBS_SUP_LEVEL,
2109: 1 WBS_SUB_LEVEL,
2110: 'PRJ' INVERT_ID
2111: from DUAL
2112: union all
2113: select 1 WBS_SUP_LEVEL,
2114: 1 WBS_SUB_LEVEL,
2115: 'WBS' INVERT_ID

Line 2116: from DUAL

2112: union all
2113: select 1 WBS_SUP_LEVEL,
2114: 1 WBS_SUB_LEVEL,
2115: 'WBS' INVERT_ID
2116: from DUAL
2117: ) top_slice
2118: where
2119: prg.STRUCT_TYPE = 'PRG' and
2120: prg.SUP_LEVEL = l_level and

Line 2246: from DUAL union all

2242: (
2243: select 'Y' CB_FLAG,
2244: 'N' CO_FLAG,
2245: -3 PLAN_VERSION_ID
2246: from DUAL union all
2247: select 'N' CB_FLAG,
2248: 'Y' CO_FLAG,
2249: -4 PLAN_VERSION_ID
2250: from DUAL union all

Line 2250: from DUAL union all

2246: from DUAL union all
2247: select 'N' CB_FLAG,
2248: 'Y' CO_FLAG,
2249: -4 PLAN_VERSION_ID
2250: from DUAL union all
2251: select 'Y' CB_FLAG,
2252: 'Y' CO_FLAG,
2253: -3 PLAN_VERSION_ID
2254: from DUAL union all

Line 2254: from DUAL union all

2250: from DUAL union all
2251: select 'Y' CB_FLAG,
2252: 'Y' CO_FLAG,
2253: -3 PLAN_VERSION_ID
2254: from DUAL union all
2255: select 'Y' CB_FLAG,
2256: 'Y' CO_FLAG,
2257: -4 PLAN_VERSION_ID
2258: from DUAL

Line 2258: from DUAL

2254: from DUAL union all
2255: select 'Y' CB_FLAG,
2256: 'Y' CO_FLAG,
2257: -4 PLAN_VERSION_ID
2258: from DUAL
2259: ) fin_plan
2260: where
2261: prg.STRUCT_TYPE = 'PRG' and
2262: prg.SUP_LEVEL = l_level and

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

2308: from
2309: PJI_XBS_DENORM prg,
2310: PA_PROJECTS_ALL map,
2311: (
2312: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
2313: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
2314: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
2315: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
2316: ) invert

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

2309: PJI_XBS_DENORM prg,
2310: PA_PROJECTS_ALL map,
2311: (
2312: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
2313: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
2314: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
2315: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
2316: ) invert
2317: where

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

2310: PA_PROJECTS_ALL map,
2311: (
2312: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
2313: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
2314: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
2315: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
2316: ) invert
2317: where
2318: prg.STRUCT_TYPE = 'PRG' and

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

2311: (
2312: select 'LF' INVERT_ID, 'LF' INVERT_VALUE from dual union all
2313: select 'LW' INVERT_ID, 'LW' INVERT_VALUE from dual union all
2314: select 'A' INVERT_ID, 'LF' INVERT_VALUE from dual union all
2315: select 'A' INVERT_ID, 'LW' INVERT_VALUE from dual
2316: ) invert
2317: where
2318: prg.STRUCT_TYPE = 'PRG' and
2319: prg.SUB_ROLLUP_ID is not null and

Line 2726: select 1 into l_count from dual

2722:
2723: end if;
2724:
2725: Begin
2726: select 1 into l_count from dual
2727: where exists ( select event_type
2728: from PA_PJI_PROJ_EVENTS_LOG elog
2729: where elog.event_type = 'PLANTYPE_UPG');
2730: exception when NO_DATA_FOUND then

Line 3085: dual;

3081: sysdate START_DATE,
3082: null END_DATE,
3083: null COMPLETION_TEXT
3084: from
3085: dual;
3086:
3087: -- If this is the resubmit of already existing failed run then Bug 5057835
3088: if l_existing_worker = 'Y' and
3089: (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_MAIN.INIT_PROCESS(p_worker_id, p_run_mode);')) then

Line 3118: from DUAL

3114: begin -- bug 5356051
3115:
3116: select 'Y'
3117: into l_prg_exists
3118: from DUAL
3119: where exists (select 1
3120: from PA_PROJ_ELEMENT_VERSIONS proj
3121: where proj.OBJECT_TYPE = 'PA_STRUCTURES' and
3122: proj.PRG_GROUP is not null and

Line 3137: from dual where p_from_project like 'UPP-BATCH-%';

3133:
3134: /* Added for bug 7551819 */
3135: begin
3136: select 'Y' into l_prg_group_flag
3137: from dual where p_from_project like 'UPP-BATCH-%';
3138: exception
3139: when no_data_found then
3140: l_prg_group_flag := 'N' ;
3141: end;

Line 3571: SELECT 'FULL' INTO l_extraction_type FROM DUAL

3567:
3568: if (l_extraction_type ='INCREMENTAL' and p_run_mode <> 'NO_PRELOAD') then --Bug#5171542 - Start
3569:
3570: begin
3571: SELECT 'FULL' INTO l_extraction_type FROM DUAL
3572: WHERE EXISTS
3573: (
3574: SELECT 1
3575: FROM pji_pjp_proj_extr_status extr,

Line 3758: FROM DUAL

3754: SELECT SUM(REFRESH_CODE) INTO l_refresh_code
3755: FROM (
3756: SELECT
3757: DECODE(p_transaction_type,'ALL_TXN_TYPE',1,'ACTUAL_TXN_TYPE',1,0) REFRESH_CODE
3758: FROM DUAL
3759: UNION ALL
3760: SELECT
3761: (CASE p_plan_versions
3762: WHEN 'ALL_PLAN_VERSION' THEN 62

Line 3770: FROM DUAL

3766: WHEN 'WK_VERSION' THEN 16
3767: WHEN 'LAT_VERSION' THEN 30
3768: ELSE 0
3769: END) REFRESH_CODE
3770: FROM DUAL
3771: );
3772:
3773: else
3774: l_refresh_code :=63;