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.PA_RBS_MAPPING dependencies on PA_RBS_MAP_TMP1

Line 325: DELETE pa_rbs_map_tmp1;

321:
322: FOR l IN 3..p_max_level+3 LOOP
323: CASE l
324: WHEN 1 THEN
325: DELETE pa_rbs_map_tmp1;
326: WHEN 2 THEN
327: DELETE pa_rbs_map_tmp2;
328: WHEN 3 THEN
329: DELETE pa_rbs_map_tmp3;

Line 343: DELETE pa_rbs_map_tmp10;

339: DELETE pa_rbs_map_tmp8;
340: WHEN 9 THEN
341: DELETE pa_rbs_map_tmp9;
342: WHEN 10 THEN
343: DELETE pa_rbs_map_tmp10;
344: WHEN 11 THEN
345: DELETE pa_rbs_map_tmp11;
346: WHEN 12 THEN
347: DELETE pa_rbs_map_tmp12;

Line 345: DELETE pa_rbs_map_tmp11;

341: DELETE pa_rbs_map_tmp9;
342: WHEN 10 THEN
343: DELETE pa_rbs_map_tmp10;
344: WHEN 11 THEN
345: DELETE pa_rbs_map_tmp11;
346: WHEN 12 THEN
347: DELETE pa_rbs_map_tmp12;
348: WHEN 13 THEN
349: DELETE pa_rbs_map_tmp13;

Line 347: DELETE pa_rbs_map_tmp12;

343: DELETE pa_rbs_map_tmp10;
344: WHEN 11 THEN
345: DELETE pa_rbs_map_tmp11;
346: WHEN 12 THEN
347: DELETE pa_rbs_map_tmp12;
348: WHEN 13 THEN
349: DELETE pa_rbs_map_tmp13;
350: ELSE
351: NULL;

Line 349: DELETE pa_rbs_map_tmp13;

345: DELETE pa_rbs_map_tmp11;
346: WHEN 12 THEN
347: DELETE pa_rbs_map_tmp12;
348: WHEN 13 THEN
349: DELETE pa_rbs_map_tmp13;
350: ELSE
351: NULL;
352: END CASE;
353: END LOOP;

Line 1856: DELETE pa_rbs_map_tmp1 ;

1852: pa_debug.g_err_stage:= 'Inside map_rbs_actuals : extrn type = ' || l_extraction_type ;
1853: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1854: END IF;
1855:
1856: DELETE pa_rbs_map_tmp1 ;
1857:
1858: --AECOM Change START bug 6739719
1859:
1860: BEGIN

Line 1915: INSERT INTO pa_rbs_map_tmp1

1911:
1912: /* bug#3651414 added join with rbs version and rbs header tables
1913: bug#3826585 added lookup to FIN7 and txn accum for project and txn accum header*/
1914:
1915: INSERT INTO pa_rbs_map_tmp1
1916: (txn_accum_header_id,
1917: struct_version_id)
1918: SELECT /*+ ORDERED */ DISTINCT det.txn_accum_header_id, -- Bug#5578221 Performance Fix
1919: ASSIGN.rbs_version_id

Line 2038: INSERT INTO pa_rbs_map_tmp1

2034:
2035:
2036: IF (l_extraction_type = 'RBS') THEN
2037:
2038: INSERT INTO pa_rbs_map_tmp1
2039: ( txn_accum_header_id
2040: , struct_version_id)
2041: SELECT DISTINCT
2042: ra.txn_accum_header_id

Line 2077: FROM pa_rbs_map_tmp1 ;

2073:
2074: SELECT distinct struct_version_id
2075: BULK COLLECT
2076: INTO l_rbs_struct_version_id
2077: FROM pa_rbs_map_tmp1 ;
2078:
2079: create_res_type_numeric_id('EMP',11,l_res_id,l_return_status,l_msg_data);
2080: create_res_type_numeric_id('CWK',11,l_res_id,l_return_status,l_msg_data);
2081:

Line 2090: FROM pa_rbs_map_tmp1 tmp, pji_fp_txn_accum_header head

2086: SAVEPOINT map_rbs_txn;
2087:
2088: SELECT distinct head.revenue_category
2089: BULK COLLECT INTO l_revenue_category
2090: FROM pa_rbs_map_tmp1 tmp, pji_fp_txn_accum_header head
2091: WHERE tmp.struct_version_id = l_rbs_struct_version_id(i)
2092: AND tmp.txn_accum_header_id = head.txn_accum_header_id
2093: AND head.revenue_category IS NOT NULL
2094: AND head.revenue_category NOT IN

Line 2157: FROM pa_rbs_map_tmp1 tmp,

2153: decode(head.event_type_id,-1,null,head.event_type_id), --- event type
2154: decode(head.person_id,-1,null,head.person_id), --- named person
2155: decode(head.bom_equipment_resource_id,-1,null,head.bom_equipment_resource_id), --- BOM equipment
2156: decode(head.bom_labor_resource_id,-1,null,head.bom_labor_resource_id) --- BOM labor
2157: FROM pa_rbs_map_tmp1 tmp,
2158: pji_fp_txn_accum_header head
2159: WHERE tmp.struct_version_id = l_rbs_struct_version_id(i) AND
2160: tmp.txn_accum_header_id = head.txn_accum_header_id;
2161:

Line 2708: DELETE pa_rbs_map_tmp1 ;

2704: pa_debug.g_err_stage:= 'rbs version is not provided';
2705: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2706: END IF;
2707:
2708: DELETE pa_rbs_map_tmp1 ;
2709:
2710: INSERT INTO pa_rbs_map_tmp1
2711: (txn_accum_header_id,
2712: struct_version_id)

Line 2710: INSERT INTO pa_rbs_map_tmp1

2706: END IF;
2707:
2708: DELETE pa_rbs_map_tmp1 ;
2709:
2710: INSERT INTO pa_rbs_map_tmp1
2711: (txn_accum_header_id,
2712: struct_version_id)
2713: SELECT distinct tmp.txn_accum_header_id, prj_assign.rbs_version_id
2714: FROM PA_RBS_PLANS_IN_TMP tmp,

Line 2727: FROM pa_rbs_map_tmp1;

2723:
2724: SELECT distinct struct_version_id
2725: BULK COLLECT
2726: INTO l_rbs_struct_version_id
2727: FROM pa_rbs_map_tmp1;
2728:
2729:
2730:
2731: FOR i IN 1..l_rbs_struct_version_id.COUNT LOOP

Line 2773: FROM pa_rbs_map_tmp1 tmp1, PA_RBS_PLANS_IN_TMP tmp

2769: tmp.event_type_id, --- event type
2770: tmp.person_id, --- named person
2771: tmp.bom_equipment_id, --- BOM equipment
2772: tmp.bom_labor_id --- BOM labor
2773: FROM pa_rbs_map_tmp1 tmp1, PA_RBS_PLANS_IN_TMP tmp
2774: WHERE tmp1.struct_version_id = l_rbs_struct_version_id(i) AND
2775: tmp1.txn_accum_header_id = tmp.txn_accum_header_id AND
2776: tmp.rowid = (select max(rowid) from PA_RBS_PLANS_IN_TMP where txn_accum_header_id = tmp.txn_accum_header_id);
2777:

Line 3320: from PA_RBS_MAP_TMP1

3316: , rule_flag
3317: bulk collect into elem_version_id
3318: , l_res_type_id
3319: , rule_flag
3320: from PA_RBS_MAP_TMP1
3321: where nvl(parent_element_version_id,-1) = nvl(element_id,-1) ;
3322: l_count := SQL%ROWCOUNT;
3323:
3324: if l_count = 0 then

Line 3397: delete PA_RBS_MAP_TMP1;

3393: where element_version_id = p_rbs_version_id);
3394:
3395:
3396: IF l_count =0 THEN
3397: delete PA_RBS_MAP_TMP1;
3398: insert into PA_RBS_MAP_TMP1
3399: (
3400: STRUCT_VERSION_ID,
3401: ELEMENT_VERSION_ID,

Line 3398: insert into PA_RBS_MAP_TMP1

3394:
3395:
3396: IF l_count =0 THEN
3397: delete PA_RBS_MAP_TMP1;
3398: insert into PA_RBS_MAP_TMP1
3399: (
3400: STRUCT_VERSION_ID,
3401: ELEMENT_VERSION_ID,
3402: PARENT_ELEMENT_VERSION_ID,

Line 3477: from PA_RBS_MAP_TMP1

3473: fin_rc_pre := 0 ;
3474:
3475: select element_version_id
3476: into p_elem_version_id
3477: from PA_RBS_MAP_TMP1
3478: where parent_element_version_id is null;
3479:
3480: --insertion of SELF node
3481: insert_rule(p_rbs_version_id, 1 ,l_level, p_elem_version_id, 'N',0,0,0,0);

Line 3485: delete PA_RBS_MAP_TMP1;

3481: insert_rule(p_rbs_version_id, 1 ,l_level, p_elem_version_id, 'N',0,0,0,0);
3482:
3483: traverse_tree(p_rbs_version_id, p_elem_version_id, 1, l_level,per_rc_pre,equip_rc_pre,mat_rc_pre,fin_rc_pre);
3484:
3485: delete PA_RBS_MAP_TMP1;
3486:
3487: END IF;
3488:
3489: END IF;