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_TXN_ACCUM_MAP

Line 909: ' pa_rbs_txn_accum_map ' ||

905: ' RBS.user_created_flag (+)= ' || '''' || 'N' || '''' || ' AND ' ||
906: ' RBS.rbs_level(+) = :p_level AND ' ||
907: ' TMP.resource_class_id = :p_res_class_id AND ' ||
908: ' NOT exists (SELECT 1 FROM ' ||
909: ' pa_rbs_txn_accum_map ' ||
910: ' WHERE struct_version_id = :p_struct_version_id ' ||
911: ' and TMP.txn_accum_header_id = txn_accum_header_id )' ; /* Modified for bug 11843445 */
912:
913: ELSE

Line 923: ' pa_rbs_txn_accum_map ' ||

919: ' RBS.user_created_flag (+)= ' || '''' || 'N' || '''' || ' AND ' ||
920: ' RBS.rbs_level(+) = :p_level AND ' ||
921: ' TMP.resource_class_id = :p_res_class_id AND ' ||
922: ' NOT exists (SELECT 1 FROM ' ||
923: ' pa_rbs_txn_accum_map ' ||
924: ' WHERE struct_version_id = :p_struct_version_id ' ||
925: ' and TMP.txn_accum_header_id = txn_accum_header_id )' ; /* Modified for bug 11843445 */
926:
927: END IF;

Line 1369: --create mapping inserting into pa_rbs_txn_accum_map

1365:
1366: END ;
1367:
1368: ------------------------------------------------------
1369: --create mapping inserting into pa_rbs_txn_accum_map
1370: ------------------------------------------------------
1371:
1372: PROCEDURE populate_txn_map
1373: (

Line 1398: l_INSERT_clause := 'INSERT INTO pa_rbs_txn_accum_map ('

1394: pa_debug.g_err_stage:= 'Inside populate_txn_map- p_struct_version_id :'|| p_struct_version_id || ' p_max_level: ' || p_max_level || ' p_rule_id:'||p_rule_id;
1395: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1396: END IF;
1397:
1398: l_INSERT_clause := 'INSERT INTO pa_rbs_txn_accum_map ('
1399: || 'txn_accum_header_id,'
1400: || 'element_id,'
1401: || 'struct_version_id,'
1402: || 'last_update_date,'

Line 1553: FROM pa_rbs_txn_accum_map

1549: from pa_rbs_map_tmp2
1550: where resource_class_id = p_res_class_id
1551: and txn_accum_header_id not in (SELECT /*+ no_unnest */ /* Added for bug 11843445 */
1552: txn_accum_header_id
1553: FROM pa_rbs_txn_accum_map
1554: WHERE struct_version_id = p_struct_version_id ) ;
1555:
1556: IF SQL%ROWCOUNT>0 THEN
1557: select count(*) into l_count from pa_rbs_elements where

Line 1617: INSERT INTO pa_rbs_txn_accum_map (

1613:
1614: END IF;
1615:
1616: FORALL i IN 1..l_txn_header_id.count
1617: INSERT INTO pa_rbs_txn_accum_map (
1618: txn_accum_header_id,
1619: element_id,
1620: struct_version_id,
1621: last_update_date,

Line 1870: fnd_stats.gather_table_stats('PA','PA_RBS_TXN_ACCUM_MAP');

1866: END IF;
1867:
1868: /* Added for bug 11843445 */
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:

Line 2039: (SELECT NULL FROM pa_rbs_txn_accum_map

2035: pa_rbs_headers_b rbsh
2036: WHERE
2037: det.project_id = ASSIGN.project_id AND
2038: NOT EXISTS -- Bug#5578221 Performance Fix
2039: (SELECT NULL FROM pa_rbs_txn_accum_map
2040: WHERE struct_version_id = ASSIGN.rbs_version_id
2041: AND DET.txn_accum_header_id = txn_accum_header_id) AND
2042: ASSIGN.reporting_usage_flag = 'Y' AND
2043: ASSIGN.rbs_version_id = rbsv.rbs_version_id AND

Line 2085: FROM pa_rbs_txn_accum_map

2081: ra.txn_accum_header_id IS NOT NULL AND
2082: ra.txn_accum_header_id NOT IN
2083: (
2084: SELECT txn_accum_header_id
2085: FROM pa_rbs_txn_accum_map
2086: WHERE struct_version_id = rbv2.rbs_version_id
2087: );
2088:
2089: Pji_Pjp_Fp_Curr_Wrap.print_time( ' # rows inserted = ' || SQL%ROWCOUNT );

Line 2376: (SELECT NULL FROM pa_rbs_txn_accum_map

2372: ASSIGN.project_id = p_project_id AND
2373: ASSIGN.rbs_version_id = p_rbs_version_id AND
2374: -- det.project_id = ASSIGN.project_id AND
2375: NOT EXISTS
2376: (SELECT NULL FROM pa_rbs_txn_accum_map
2377: WHERE struct_version_id = ASSIGN.rbs_version_id
2378: AND DET.txn_accum_header_id = txn_accum_header_id) AND
2379: ASSIGN.reporting_usage_flag = 'Y' AND
2380: ASSIGN.rbs_version_id = rbsv.rbs_version_id AND

Line 2418: FROM pa_rbs_txn_accum_map

2414: ra.txn_accum_header_id IS NOT NULL AND
2415: ra.txn_accum_header_id NOT IN
2416: (
2417: SELECT txn_accum_header_id
2418: FROM pa_rbs_txn_accum_map
2419: WHERE struct_version_id = rbv2.rbs_version_id
2420: );
2421:
2422: END IF;

Line 2946: FROM pa_rbs_txn_accum_map b

2942: person_type_id --bug#4098679
2943: FROM PA_RBS_PLANS_OUT_TMP a
2944: WHERE NOT EXISTS
2945: (SELECT 1
2946: FROM pa_rbs_txn_accum_map b
2947: WHERE b.struct_version_id = p_rbs_version_id and
2948: b.txn_accum_header_id=a.txn_accum_header_id);
2949:
2950:

Line 3031: from pa_rbs_txn_accum_map map

3027:
3028: UPDATE PA_RBS_PLANS_OUT_TMP tmp
3029: SET tmp.rbs_element_id =
3030: (select map.element_id
3031: from pa_rbs_txn_accum_map map
3032: where map.txn_accum_header_id = tmp.txn_accum_header_id
3033: and map.struct_version_id = p_rbs_version_id);
3034:
3035:

Line 3056: FROM pa_rbs_txn_accum_map

3052: WHERE tmp.source_id = res_assign.resource_assignment_id AND
3053: res_assign.project_id = prj_assign.project_id AND
3054: tmp.txn_accum_header_id not in
3055: (SELECT txn_accum_header_id
3056: FROM pa_rbs_txn_accum_map
3057: WHERE struct_version_id = prj_assign.rbs_version_id );
3058:
3059: SELECT distinct struct_version_id
3060: BULK COLLECT