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.PA_PROJECT_INTEGRATION_PUB dependencies on PA_WBS_SEQ_TMP

Line 2365: delete from pa_wbs_seq_tmp ;

2361: log_pvt('WBS_ORDER',' l_task_id_tbl(i) '|| l_task_id_tbl(i)||' l_task_ref_tbl(i) '||l_task_ref_tbl(i)||' l_parent_ref_tbl(i) '||l_parent_ref_tbl(i));
2362: END LOOP;
2363:
2364: log_pvt('WBS_ORDER','001c');
2365: delete from pa_wbs_seq_tmp ;
2366:
2367: FORALL i in l_task_ref_tbl.first .. l_task_ref_tbl.last
2368: INSERT INTO pa_wbs_seq_tmp ( task_id , task_ref , parent_task_ref , list_id )
2369: VALUES ( l_task_id_tbl(i),l_task_ref_tbl(i), l_parent_ref_tbl(i), l_list_tbl(i));

Line 2368: INSERT INTO pa_wbs_seq_tmp ( task_id , task_ref , parent_task_ref , list_id )

2364: log_pvt('WBS_ORDER','001c');
2365: delete from pa_wbs_seq_tmp ;
2366:
2367: FORALL i in l_task_ref_tbl.first .. l_task_ref_tbl.last
2368: INSERT INTO pa_wbs_seq_tmp ( task_id , task_ref , parent_task_ref , list_id )
2369: VALUES ( l_task_id_tbl(i),l_task_ref_tbl(i), l_parent_ref_tbl(i), l_list_tbl(i));
2370:
2371: log_pvt('WBS_ORDER','001d');
2372:

Line 2377: select count(*) into i from pa_wbs_seq_tmp ;

2373: l_task_ref_tbl.delete;
2374: l_parent_ref_tbl.delete;
2375: l_list_tbl.delete;
2376:
2377: select count(*) into i from pa_wbs_seq_tmp ;
2378:
2379: log_pvt('WBS_ORDER','001 i '||i);
2380:
2381: select parent_task_ref , task_ref , list_id bulk collect

Line 2383: from pa_wbs_seq_tmp

2379: log_pvt('WBS_ORDER','001 i '||i);
2380:
2381: select parent_task_ref , task_ref , list_id bulk collect
2382: into l_parent_ref_tbl, l_task_ref_tbl , l_list_tbl
2383: from pa_wbs_seq_tmp
2384: start with parent_task_Ref is null
2385: connect by prior task_ref = parent_task_ref;
2386:
2387: log_pvt('WBS_ORDER','001' || 'l_list_tbl.count '||l_list_tbl.count );

Line 2442: from pa_wbs_seq_tmp b

2438:
2439: update pa_proj_elements a
2440: set ( pm_source_reference ) =
2441: ( select b.task_ref
2442: from pa_wbs_seq_tmp b
2443: where b.task_id = a.proj_element_id )
2444: where exists
2445: ( select 'x' from pa_wbs_seq_tmp c where c.task_id = a.proj_element_id ) ;
2446:

Line 2445: ( select 'x' from pa_wbs_seq_tmp c where c.task_id = a.proj_element_id ) ;

2441: ( select b.task_ref
2442: from pa_wbs_seq_tmp b
2443: where b.task_id = a.proj_element_id )
2444: where exists
2445: ( select 'x' from pa_wbs_seq_tmp c where c.task_id = a.proj_element_id ) ;
2446:
2447: update pa_tasks a
2448: set ( pm_task_reference, pm_product_code ) =
2449: ( select b.task_ref, 'PRIMAVERA'

Line 2450: from pa_wbs_seq_tmp b

2446:
2447: update pa_tasks a
2448: set ( pm_task_reference, pm_product_code ) =
2449: ( select b.task_ref, 'PRIMAVERA'
2450: from pa_wbs_seq_tmp b
2451: where b.task_id = a.task_id )
2452: where exists
2453: ( select 'x' from pa_wbs_seq_tmp c where c.task_id = a.task_id ) ;
2454:

Line 2453: ( select 'x' from pa_wbs_seq_tmp c where c.task_id = a.task_id ) ;

2449: ( select b.task_ref, 'PRIMAVERA'
2450: from pa_wbs_seq_tmp b
2451: where b.task_id = a.task_id )
2452: where exists
2453: ( select 'x' from pa_wbs_seq_tmp c where c.task_id = a.task_id ) ;
2454:
2455:
2456: select a.proj_element_id , a.element_version_id
2457: bulk collect into X_DELETE_TASK_ID_TBL, X_DELETE_TASK_VER_ID_TBL

Line 2466: from pa_wbs_seq_tmp b

2462: and a.proj_element_id = c.proj_element_id
2463: and
2464: ( not exists
2465: ( select 'x'
2466: from pa_wbs_seq_tmp b
2467: where ( c.pm_source_reference is not null and c.pm_source_reference = b.task_ref ) or ( c.pm_source_reference is null and b.task_id = c.proj_element_id )
2468: )
2469: )
2470: order by a.wbs_level desc ;

Line 2555: DELETE FROM pa_wbs_seq_tmp ;

2551: END LOOP;
2552:
2553: end if;
2554:
2555: DELETE FROM pa_wbs_seq_tmp ;
2556:
2557: log_pvt('DEL_RES','Before Forall '|| l_res_id_tbl.count);
2558:
2559: if ( l_res_id_tbl.count > 0 ) then

Line 2562: INSERT INTO pa_wbs_seq_tmp ( task_id , task_ref , parent_task_ref , list_id )

2558:
2559: if ( l_res_id_tbl.count > 0 ) then
2560:
2561: FORALL i in l_res_id_tbl.first .. l_res_id_tbl.last
2562: INSERT INTO pa_wbs_seq_tmp ( task_id , task_ref , parent_task_ref , list_id )
2563: VALUES ( l_res_id_tbl(i),null,null,null);
2564:
2565: end if;
2566:

Line 2578: ( select 'x' from pa_wbs_seq_tmp seq1

2574: and a.proj_element_id = res1.task_id
2575: and a.parent_structure_version_id = bud1.project_structure_version_id
2576: AND res1.unplanned_flag IS NULL -- Bug 12970445
2577: and not exists
2578: ( select 'x' from pa_wbs_seq_tmp seq1
2579: where seq1.task_id = res1. resource_assignment_id ) ;
2580:
2581: log_pvt('DEL_RES',' l_del_res_id_tbl.count '||l_del_res_id_tbl.count);
2582: