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_RBS_MAPPING dependencies on PA_RBS_MAP_TMP1

Line 328: DELETE pa_rbs_map_tmp1;

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

Line 346: DELETE pa_rbs_map_tmp10;

342: DELETE pa_rbs_map_tmp8;
343: WHEN 9 THEN
344: DELETE pa_rbs_map_tmp9;
345: WHEN 10 THEN
346: DELETE pa_rbs_map_tmp10;
347: WHEN 11 THEN
348: DELETE pa_rbs_map_tmp11;
349: WHEN 12 THEN
350: DELETE pa_rbs_map_tmp12;

Line 348: DELETE pa_rbs_map_tmp11;

344: DELETE pa_rbs_map_tmp9;
345: WHEN 10 THEN
346: DELETE pa_rbs_map_tmp10;
347: WHEN 11 THEN
348: DELETE pa_rbs_map_tmp11;
349: WHEN 12 THEN
350: DELETE pa_rbs_map_tmp12;
351: WHEN 13 THEN
352: DELETE pa_rbs_map_tmp13;

Line 350: DELETE pa_rbs_map_tmp12;

346: DELETE pa_rbs_map_tmp10;
347: WHEN 11 THEN
348: DELETE pa_rbs_map_tmp11;
349: WHEN 12 THEN
350: DELETE pa_rbs_map_tmp12;
351: WHEN 13 THEN
352: DELETE pa_rbs_map_tmp13;
353: ELSE
354: NULL;

Line 352: DELETE pa_rbs_map_tmp13;

348: DELETE pa_rbs_map_tmp11;
349: WHEN 12 THEN
350: DELETE pa_rbs_map_tmp12;
351: WHEN 13 THEN
352: DELETE pa_rbs_map_tmp13;
353: ELSE
354: NULL;
355: END CASE;
356: END LOOP;

Line 1873: DELETE pa_rbs_map_tmp1 ;

1869: fnd_stats.gather_table_stats('PA','PA_RBS_ELEMENTS');
1870: fnd_stats.gather_table_stats('PA','PA_RBS_TXN_ACCUM_MAP');
1871: /* Added for bug 11843445 */
1872:
1873: DELETE pa_rbs_map_tmp1 ;
1874:
1875: --AECOM Change START bug 6739719
1876:
1877: BEGIN

Line 2021: INSERT INTO pa_rbs_map_tmp1

2017: bug#3826585 added lookup to FIN7 and txn accum for project and txn accum header*/
2018:
2019: -- CHANGE_02 Sridhar Carlson 6919766 used the above temp table in the below insert statement
2020:
2021: INSERT INTO pa_rbs_map_tmp1
2022: (txn_accum_header_id,
2023: struct_version_id)
2024: SELECT /*+ORDERED */
2025: DISTINCT det.txn_accum_header_id, -- Bug#5578221 Performance Fix

Line 2049: --test_logmessage('RBS',1000,' After insert into pa_rbs_map_tmp1 sql%rowcount '||sql%rowcount );

2045: rbsv.rbs_header_id = rbsh.rbs_header_id AND
2046: SYSDATE BETWEEN rbsh.effective_from_date AND
2047: NVL(rbsh.effective_to_date,SYSDATE);
2048:
2049: --test_logmessage('RBS',1000,' After insert into pa_rbs_map_tmp1 sql%rowcount '||sql%rowcount );
2050:
2051: delete from pa_rbs_map_t1 where worker_id = p_worker_id ;
2052:
2053: --test_logmessage('RBS',1000,' After delete from pa_rbs_map_t1 sql%rowcount '||sql%rowcount );

Line 2058: INSERT INTO pa_rbs_map_tmp1

2054: /* AWE Fix for bug 13727835 ends */
2055:
2056: IF (l_extraction_type = 'RBS') THEN
2057:
2058: INSERT INTO pa_rbs_map_tmp1
2059: ( txn_accum_header_id
2060: , struct_version_id)
2061: SELECT DISTINCT
2062: ra.txn_accum_header_id

Line 2097: FROM pa_rbs_map_tmp1 ;

2093:
2094: SELECT distinct struct_version_id
2095: BULK COLLECT
2096: INTO l_rbs_struct_version_id
2097: FROM pa_rbs_map_tmp1 ;
2098:
2099: create_res_type_numeric_id('EMP',11,l_res_id,l_return_status,l_msg_data);
2100: create_res_type_numeric_id('CWK',11,l_res_id,l_return_status,l_msg_data);
2101:

Line 2119: FROM pa_rbs_map_tmp1 tmp, pji_fp_txn_accum_header head

2115: SAVEPOINT map_rbs_txn;
2116:
2117: SELECT distinct head.revenue_category
2118: BULK COLLECT INTO l_revenue_category
2119: FROM pa_rbs_map_tmp1 tmp, pji_fp_txn_accum_header head
2120: WHERE tmp.struct_version_id = l_rbs_struct_version_id(i)
2121: AND tmp.txn_accum_header_id = head.txn_accum_header_id
2122: AND head.revenue_category IS NOT NULL
2123: AND head.revenue_category NOT IN

Line 2186: FROM pa_rbs_map_tmp1 tmp,

2182: decode(head.event_type_id,-1,null,head.event_type_id), --- event type
2183: decode(head.person_id,-1,null,head.person_id), --- named person
2184: decode(head.bom_equipment_resource_id,-1,null,head.bom_equipment_resource_id), --- BOM equipment
2185: decode(head.bom_labor_resource_id,-1,null,head.bom_labor_resource_id) --- BOM labor
2186: FROM pa_rbs_map_tmp1 tmp,
2187: pji_fp_txn_accum_header head
2188: WHERE tmp.struct_version_id = l_rbs_struct_version_id(i) AND
2189: tmp.txn_accum_header_id = head.txn_accum_header_id;
2190:

Line 2355: INSERT INTO pa_rbs_map_tmp1

2351: AND RA.TXN_ACCUM_HEADER_ID IS NOT NULL );
2352:
2353:
2354:
2355: INSERT INTO pa_rbs_map_tmp1
2356: (txn_accum_header_id,
2357: struct_version_id)
2358: SELECT /*+ORDERED */
2359: DISTINCT det.txn_accum_header_id, -- Bug#5578221 Performance Fix

Line 2390: INSERT INTO pa_rbs_map_tmp1

2386:
2387:
2388: IF (l_extraction_type = 'RBS') THEN
2389:
2390: INSERT INTO pa_rbs_map_tmp1
2391: ( txn_accum_header_id
2392: , struct_version_id)
2393: SELECT DISTINCT
2394: ra.txn_accum_header_id

Line 2428: FROM pa_rbs_map_tmp1 ;

2424:
2425: SELECT distinct struct_version_id
2426: BULK COLLECT
2427: INTO l_rbs_struct_version_id
2428: FROM pa_rbs_map_tmp1 ;
2429:
2430: PA_RBS_MAPPING.create_res_type_numeric_id('EMP',11,l_res_id,l_return_status,l_msg_data);
2431: PA_RBS_MAPPING.create_res_type_numeric_id('CWK',11,l_res_id,l_return_status,l_msg_data);
2432:

Line 2450: FROM pa_rbs_map_tmp1 tmp, pji_fp_txn_accum_header head

2446: SAVEPOINT map_rbs_txn;
2447:
2448: SELECT distinct head.revenue_category
2449: BULK COLLECT INTO l_revenue_category
2450: FROM pa_rbs_map_tmp1 tmp, pji_fp_txn_accum_header head
2451: WHERE tmp.struct_version_id = l_rbs_struct_version_id(i)
2452: AND tmp.txn_accum_header_id = head.txn_accum_header_id
2453: AND head.revenue_category IS NOT NULL
2454: AND head.revenue_category NOT IN

Line 2517: FROM pa_rbs_map_tmp1 tmp,

2513: decode(head.event_type_id,-1,null,head.event_type_id), --- event type
2514: decode(head.person_id,-1,null,head.person_id), --- named person
2515: decode(head.bom_equipment_resource_id,-1,null,head.bom_equipment_resource_id), --- BOM equipment
2516: decode(head.bom_labor_resource_id,-1,null,head.bom_labor_resource_id) --- BOM labor
2517: FROM pa_rbs_map_tmp1 tmp,
2518: pji_fp_txn_accum_header head
2519: WHERE tmp.struct_version_id = l_rbs_struct_version_id(i) AND
2520: tmp.txn_accum_header_id = head.txn_accum_header_id;
2521:

Line 3043: DELETE pa_rbs_map_tmp1 ;

3039: pa_debug.g_err_stage:= 'rbs version is not provided';
3040: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3041: END IF;
3042:
3043: DELETE pa_rbs_map_tmp1 ;
3044:
3045: INSERT INTO pa_rbs_map_tmp1
3046: (txn_accum_header_id,
3047: struct_version_id)

Line 3045: INSERT INTO pa_rbs_map_tmp1

3041: END IF;
3042:
3043: DELETE pa_rbs_map_tmp1 ;
3044:
3045: INSERT INTO pa_rbs_map_tmp1
3046: (txn_accum_header_id,
3047: struct_version_id)
3048: SELECT distinct tmp.txn_accum_header_id, prj_assign.rbs_version_id
3049: FROM PA_RBS_PLANS_IN_TMP tmp,

Line 3062: FROM pa_rbs_map_tmp1;

3058:
3059: SELECT distinct struct_version_id
3060: BULK COLLECT
3061: INTO l_rbs_struct_version_id
3062: FROM pa_rbs_map_tmp1;
3063:
3064:
3065:
3066: FOR i IN 1..l_rbs_struct_version_id.COUNT LOOP

Line 3108: FROM pa_rbs_map_tmp1 tmp1, PA_RBS_PLANS_IN_TMP tmp

3104: tmp.event_type_id, --- event type
3105: tmp.person_id, --- named person
3106: tmp.bom_equipment_id, --- BOM equipment
3107: tmp.bom_labor_id --- BOM labor
3108: FROM pa_rbs_map_tmp1 tmp1, PA_RBS_PLANS_IN_TMP tmp
3109: WHERE tmp1.struct_version_id = l_rbs_struct_version_id(i) AND
3110: tmp1.txn_accum_header_id = tmp.txn_accum_header_id AND
3111: tmp.rowid = (select max(rowid) from PA_RBS_PLANS_IN_TMP where txn_accum_header_id = tmp.txn_accum_header_id);
3112:

Line 3657: from PA_RBS_MAP_TMP1

3653: , rule_flag
3654: bulk collect into elem_version_id
3655: , l_res_type_id
3656: , rule_flag
3657: from PA_RBS_MAP_TMP1
3658: where nvl(parent_element_version_id,-1) = nvl(element_id,-1) ;
3659: l_count := SQL%ROWCOUNT;
3660:
3661: if l_count = 0 then

Line 3734: delete PA_RBS_MAP_TMP1;

3730: where element_version_id = p_rbs_version_id);
3731:
3732:
3733: IF l_count =0 THEN
3734: delete PA_RBS_MAP_TMP1;
3735: insert into PA_RBS_MAP_TMP1
3736: (
3737: STRUCT_VERSION_ID,
3738: ELEMENT_VERSION_ID,

Line 3735: insert into PA_RBS_MAP_TMP1

3731:
3732:
3733: IF l_count =0 THEN
3734: delete PA_RBS_MAP_TMP1;
3735: insert into PA_RBS_MAP_TMP1
3736: (
3737: STRUCT_VERSION_ID,
3738: ELEMENT_VERSION_ID,
3739: PARENT_ELEMENT_VERSION_ID,

Line 3814: from PA_RBS_MAP_TMP1

3810: fin_rc_pre := 0 ;
3811:
3812: select element_version_id
3813: into p_elem_version_id
3814: from PA_RBS_MAP_TMP1
3815: where parent_element_version_id is null;
3816:
3817: --insertion of SELF node
3818: insert_rule(p_rbs_version_id, 1 ,l_level, p_elem_version_id, 'N',0,0,0,0);

Line 3822: delete PA_RBS_MAP_TMP1;

3818: insert_rule(p_rbs_version_id, 1 ,l_level, p_elem_version_id, 'N',0,0,0,0);
3819:
3820: 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);
3821:
3822: delete PA_RBS_MAP_TMP1;
3823:
3824: END IF;
3825:
3826: END IF;