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

Line 544: from dual

540: IF p_calling_context='P' THEN
541: begin
542: select 'Y'
543: into l_summ_hasrun
544: from dual
545: where exists (select 1 from pji_fp_xbs_accum_f
546: where project_id=p_project_ids(i)
547: and plan_version_id=-1
548: and rownum=1);

Line 2502: SELECT 'TXN' curr_type FROM DUAL

2498: decode ( cc_src.curr_type, 'POU',1,0) POU_MASK
2499: from
2500: pji_fp_xbs_accum_f fact,
2501: /* (
2502: SELECT 'TXN' curr_type FROM DUAL
2503: UNION ALL
2504: SELECT 'PRJ' curr_type FROM DUAL
2505: UNION ALL
2506: SELECT 'POU' curr_type FROM DUAL

Line 2504: SELECT 'PRJ' curr_type FROM DUAL

2500: pji_fp_xbs_accum_f fact,
2501: /* (
2502: SELECT 'TXN' curr_type FROM DUAL
2503: UNION ALL
2504: SELECT 'PRJ' curr_type FROM DUAL
2505: UNION ALL
2506: SELECT 'POU' curr_type FROM DUAL
2507: ) cc_src commented for bug 14040849 */
2508: ( SELECT DECODE( ROWNUM, 1, 'TXN',2, 'PRJ', 3,'POU') CURR_TYPE

Line 2506: SELECT 'POU' curr_type FROM DUAL

2502: SELECT 'TXN' curr_type FROM DUAL
2503: UNION ALL
2504: SELECT 'PRJ' curr_type FROM DUAL
2505: UNION ALL
2506: SELECT 'POU' curr_type FROM DUAL
2507: ) cc_src commented for bug 14040849 */
2508: ( SELECT DECODE( ROWNUM, 1, 'TXN',2, 'PRJ', 3,'POU') CURR_TYPE
2509: FROM DUAL CONNECT BY ROWNUM < 4 ) cc_src
2510: where 1=1

Line 2509: FROM DUAL CONNECT BY ROWNUM < 4 ) cc_src

2505: UNION ALL
2506: SELECT 'POU' curr_type FROM DUAL
2507: ) cc_src commented for bug 14040849 */
2508: ( SELECT DECODE( ROWNUM, 1, 'TXN',2, 'PRJ', 3,'POU') CURR_TYPE
2509: FROM DUAL CONNECT BY ROWNUM < 4 ) cc_src
2510: where 1=1
2511: and ( decode ( cc_src.curr_type, 'TXN', DECODE(BITAND(fact.curr_record_type_id, 16), 16, 'a'), 'b') = 'a'
2512: or decode ( cc_src.curr_type, 'PRJ', DECODE(BITAND(fact.curr_record_type_id, 8), 8, 'a'), 'b') = 'a'
2513: or decode ( cc_src.curr_type, 'POU', DECODE(BITAND(fact.curr_record_type_id, 4), 4, 'a'), 'b') = 'a' )

Line 3055: (SELECT p_struct_ver_id,p_plan_version_id,p_struct_ver_id,p_plan_version_id,p_struct_ver_id,p_plan_version_id from dual )

3051:
3052: UPDATE pji_plan_extr_tmp TMP
3053: SET (LPB_STRUCT_VER_ID,LPB_PLAN_VER_ID,BASE_STRUCT_VER_ID,BASE_PLAN_VER_ID,
3054: WK_STRUCT_VER_ID,WK_PLAN_VER_ID)=
3055: (SELECT p_struct_ver_id,p_plan_version_id,p_struct_ver_id,p_plan_version_id,p_struct_ver_id,p_plan_version_id from dual )
3056: where tmp.project_id < 0 ;
3057:
3058:
3059:

Line 3581: (SELECT p_struct_ver_id,p_plan_version_id,p_struct_ver_id,p_plan_version_id,p_struct_ver_id,p_plan_version_id from dual );

3577:
3578: UPDATE pji_plan_extr_tmp TMP
3579: SET (LPB_STRUCT_VER_ID,LPB_PLAN_VER_ID,BASE_STRUCT_VER_ID,BASE_PLAN_VER_ID,
3580: WK_STRUCT_VER_ID,WK_PLAN_VER_ID)=
3581: (SELECT p_struct_ver_id,p_plan_version_id,p_struct_ver_id,p_plan_version_id,p_struct_ver_id,p_plan_version_id from dual );
3582:
3583: END IF;
3584:
3585: PRINT_TIME ( ' populate_workplan_data 0003.6 ' ) ;

Line 4306: SELECT 'TXN' curr_type FROM DUAL

4302: decode ( cc_src.curr_type, 'POU',1,0) POU_MASK
4303: FROM
4304: pji_fp_xbs_accum_f fact,
4305: /* (
4306: SELECT 'TXN' curr_type FROM DUAL
4307: UNION ALL
4308: SELECT 'PRJ' curr_type FROM DUAL
4309: UNION ALL
4310: SELECT 'POU' curr_type FROM DUAL

Line 4308: SELECT 'PRJ' curr_type FROM DUAL

4304: pji_fp_xbs_accum_f fact,
4305: /* (
4306: SELECT 'TXN' curr_type FROM DUAL
4307: UNION ALL
4308: SELECT 'PRJ' curr_type FROM DUAL
4309: UNION ALL
4310: SELECT 'POU' curr_type FROM DUAL
4311: ) cc_src commented for bug 14040849 */
4312: ( SELECT DECODE( ROWNUM, 1, 'TXN',2, 'PRJ', 3,'POU') CURR_TYPE

Line 4310: SELECT 'POU' curr_type FROM DUAL

4306: SELECT 'TXN' curr_type FROM DUAL
4307: UNION ALL
4308: SELECT 'PRJ' curr_type FROM DUAL
4309: UNION ALL
4310: SELECT 'POU' curr_type FROM DUAL
4311: ) cc_src commented for bug 14040849 */
4312: ( SELECT DECODE( ROWNUM, 1, 'TXN',2, 'PRJ', 3,'POU') CURR_TYPE
4313: FROM DUAL CONNECT BY ROWNUM < 4 ) cc_src -- added for bug 14040849
4314: WHERE 1=1

Line 4313: FROM DUAL CONNECT BY ROWNUM < 4 ) cc_src -- added for bug 14040849

4309: UNION ALL
4310: SELECT 'POU' curr_type FROM DUAL
4311: ) cc_src commented for bug 14040849 */
4312: ( SELECT DECODE( ROWNUM, 1, 'TXN',2, 'PRJ', 3,'POU') CURR_TYPE
4313: FROM DUAL CONNECT BY ROWNUM < 4 ) cc_src -- added for bug 14040849
4314: WHERE 1=1
4315: and ( decode ( cc_src.curr_type, 'TXN', DECODE(BITAND(fact.curr_record_type_id, 16), 16, 'a'), 'b') = 'a'
4316: or decode ( cc_src.curr_type, 'PRJ', DECODE(BITAND(fact.curr_record_type_id , 8), 8, 'a'), 'b') = 'a'
4317: or decode ( cc_src.curr_type, 'POU', DECODE(BITAND(fact.curr_record_type_id, 4), 4, 'a'), 'b') = 'a' )

Line 4424: dual;

4420: sysdate START_DATE,
4421: null END_DATE,
4422: null COMPLETION_TEXT
4423: from
4424: dual;
4425:
4426: insert into PJI_PJP_PROJ_BATCH_MAP
4427: (
4428: WORKER_ID,

Line 4473: FROM DUAL;

4469: PRINT_TIME ( ' FPM_UPGRADE_INITIALIZE 004 ' ) ;
4470:
4471: SELECT PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG') , PJI_UTILS.GET_SETUP_PARAMETER('GL_PERIOD_FLAG')
4472: INTO l_pa_period_flag, l_gl_period_flag
4473: FROM DUAL;
4474:
4475: if (l_pa_period_flag = 'N') then
4476: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
4477: 'PA_CALENDAR_FLAG',