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_TMP2

Line 330: DELETE pa_rbs_map_tmp2;

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;
333: WHEN 4 THEN
334: DELETE pa_rbs_map_tmp4;

Line 893: l_FROM_clause := 'FROM pa_rbs_map_tmp2 TMP,'

889: || get_sql_clause(p_rule_id,p_level,'RES_TYP_ID') || ' ,'
890: || get_sql_clause(p_rule_id,p_level,'RES_SOURCE') || ' ,'
891: || get_sql_clause(p_rule_id,p_level,'TMP') ;
892:
893: l_FROM_clause := 'FROM pa_rbs_map_tmp2 TMP,'
894: || 'pa_rbs_elements RBS ' ;
895:
896:
897:

Line 1509: EXECUTE IMMEDIATE 'UPDATE pa_rbs_map_tmp2 SET ( ' || l_sql_cols || ' ) = ( SELECT ' || l_sql_cols || ' FROM PA_RBS_ELEMENTS where rbs_element_id = :g_rbs_element_id) ' USING g_rbs_element_id;

1505: l_sql_cols := l_sql_cols || l_res_type_cols(i) || ' , ';
1506: END IF;
1507: END LOOP;
1508:
1509: EXECUTE IMMEDIATE 'UPDATE pa_rbs_map_tmp2 SET ( ' || l_sql_cols || ' ) = ( SELECT ' || l_sql_cols || ' FROM PA_RBS_ELEMENTS where rbs_element_id = :g_rbs_element_id) ' USING g_rbs_element_id;
1510:
1511: END IF;
1512:
1513: IF g_debug_mode = 'Y' THEN

Line 1549: from pa_rbs_map_tmp2

1545: END IF;
1546:
1547: SELECT distinct txn_accum_header_id
1548: bulk collect into l_txn_header_id
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

Line 2132: DELETE pa_rbs_map_tmp2 ;

2128: create_res_type_numeric_id(l_revenue_category(p), 14, l_res_id,l_return_status,l_msg_data);
2129: END LOOP;
2130:
2131:
2132: DELETE pa_rbs_map_tmp2 ;
2133:
2134: /* added for bug#4027727 */
2135: BEGIN
2136:

Line 2147: INSERT INTO pa_rbs_map_tmp2

2143: WHEN NO_DATA_FOUND THEN
2144: NULL;
2145: END;
2146:
2147: INSERT INTO pa_rbs_map_tmp2
2148: (txn_accum_header_id,
2149: struct_version_id, ---not needed to insert but doing
2150: supplier_id, --- supplier
2151: role_id, --- role

Line 2463: DELETE pa_rbs_map_tmp2 ;

2459: PA_RBS_MAPPING.create_res_type_numeric_id(l_revenue_category(p), 14, l_res_id,l_return_status,l_msg_data);
2460: END LOOP;
2461:
2462:
2463: DELETE pa_rbs_map_tmp2 ;
2464:
2465: /* added for bug#4027727 */
2466: BEGIN
2467:

Line 2478: INSERT INTO pa_rbs_map_tmp2

2474: WHEN NO_DATA_FOUND THEN
2475: NULL;
2476: END;
2477:
2478: INSERT INTO pa_rbs_map_tmp2
2479: (txn_accum_header_id,
2480: struct_version_id, ---not needed to insert but doing
2481: supplier_id, --- supplier
2482: role_id, --- role

Line 2900: DELETE pa_rbs_map_tmp2 ;

2896:
2897: end if;
2898: /** AEnd of addition for bug 6662808 **/
2899:
2900: DELETE pa_rbs_map_tmp2 ;
2901: INSERT INTO pa_rbs_map_tmp2
2902: (txn_accum_header_id,
2903: struct_version_id,
2904: supplier_id,

Line 2901: INSERT INTO pa_rbs_map_tmp2

2897: end if;
2898: /** AEnd of addition for bug 6662808 **/
2899:
2900: DELETE pa_rbs_map_tmp2 ;
2901: INSERT INTO pa_rbs_map_tmp2
2902: (txn_accum_header_id,
2903: struct_version_id,
2904: supplier_id,
2905: role_id,

Line 2958: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;

2954: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2955: END IF;
2956:
2957: -- Bug#5503706 Start
2958: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;
2959:
2960: IF g_debug_mode = 'Y' THEN
2961: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;
2962: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

Line 2961: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;

2957: -- Bug#5503706 Start
2958: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;
2959:
2960: IF g_debug_mode = 'Y' THEN
2961: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;
2962: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2963: END IF;
2964:
2965: if l_tmpcnt >0 then

Line 3068: DELETE pa_rbs_map_tmp2 ;

3064:
3065:
3066: FOR i IN 1..l_rbs_struct_version_id.COUNT LOOP
3067:
3068: DELETE pa_rbs_map_tmp2 ;
3069: INSERT INTO pa_rbs_map_tmp2
3070: (txn_accum_header_id,
3071: struct_version_id, ---not needed to insert but doing
3072: supplier_id, --- supplier

Line 3069: INSERT INTO pa_rbs_map_tmp2

3065:
3066: FOR i IN 1..l_rbs_struct_version_id.COUNT LOOP
3067:
3068: DELETE pa_rbs_map_tmp2 ;
3069: INSERT INTO pa_rbs_map_tmp2
3070: (txn_accum_header_id,
3071: struct_version_id, ---not needed to insert but doing
3072: supplier_id, --- supplier
3073: role_id, --- role

Line 3119: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;

3115: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3116: END IF;
3117:
3118: -- Bug#5503706 Start
3119: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;
3120:
3121: IF g_debug_mode = 'Y' THEN
3122: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;
3123: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

Line 3122: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;

3118: -- Bug#5503706 Start
3119: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;
3120:
3121: IF g_debug_mode = 'Y' THEN
3122: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;
3123: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3124: END IF;
3125:
3126: if l_tmpcnt >0 then