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 327: DELETE pa_rbs_map_tmp2;

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;
330: WHEN 4 THEN
331: DELETE pa_rbs_map_tmp4;

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

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

Line 1506: 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;

1502: l_sql_cols := l_sql_cols || l_res_type_cols(i) || ' , ';
1503: END IF;
1504: END LOOP;
1505:
1506: 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;
1507:
1508: END IF;
1509:
1510: IF g_debug_mode = 'Y' THEN

Line 1546: from pa_rbs_map_tmp2

1542: END IF;
1543:
1544: SELECT distinct txn_accum_header_id
1545: bulk collect into l_txn_header_id
1546: from pa_rbs_map_tmp2
1547: where resource_class_id = p_res_class_id
1548: and txn_accum_header_id not in (SELECT txn_accum_header_id FROM
1549: pa_rbs_txn_accum_map
1550: WHERE struct_version_id = p_struct_version_id ) ;

Line 2103: DELETE pa_rbs_map_tmp2 ;

2099: create_res_type_numeric_id(l_revenue_category(p), 14, l_res_id,l_return_status,l_msg_data);
2100: END LOOP;
2101:
2102:
2103: DELETE pa_rbs_map_tmp2 ;
2104:
2105: /* added for bug#4027727 */
2106: BEGIN
2107:

Line 2118: INSERT INTO pa_rbs_map_tmp2

2114: WHEN NO_DATA_FOUND THEN
2115: NULL;
2116: END;
2117:
2118: INSERT INTO pa_rbs_map_tmp2
2119: (txn_accum_header_id,
2120: struct_version_id, ---not needed to insert but doing
2121: supplier_id, --- supplier
2122: role_id, --- role

Line 2565: DELETE pa_rbs_map_tmp2 ;

2561:
2562: end if;
2563: /** AEnd of addition for bug 6662808 **/
2564:
2565: DELETE pa_rbs_map_tmp2 ;
2566: INSERT INTO pa_rbs_map_tmp2
2567: (txn_accum_header_id,
2568: struct_version_id,
2569: supplier_id,

Line 2566: INSERT INTO pa_rbs_map_tmp2

2562: end if;
2563: /** AEnd of addition for bug 6662808 **/
2564:
2565: DELETE pa_rbs_map_tmp2 ;
2566: INSERT INTO pa_rbs_map_tmp2
2567: (txn_accum_header_id,
2568: struct_version_id,
2569: supplier_id,
2570: role_id,

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

2619: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2620: END IF;
2621:
2622: -- Bug#5503706 Start
2623: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;
2624:
2625: IF g_debug_mode = 'Y' THEN
2626: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;
2627: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

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

2622: -- Bug#5503706 Start
2623: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;
2624:
2625: IF g_debug_mode = 'Y' THEN
2626: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;
2627: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2628: END IF;
2629:
2630: if l_tmpcnt >0 then

Line 2733: DELETE pa_rbs_map_tmp2 ;

2729:
2730:
2731: FOR i IN 1..l_rbs_struct_version_id.COUNT LOOP
2732:
2733: DELETE pa_rbs_map_tmp2 ;
2734: INSERT INTO pa_rbs_map_tmp2
2735: (txn_accum_header_id,
2736: struct_version_id, ---not needed to insert but doing
2737: supplier_id, --- supplier

Line 2734: INSERT INTO pa_rbs_map_tmp2

2730:
2731: FOR i IN 1..l_rbs_struct_version_id.COUNT LOOP
2732:
2733: DELETE pa_rbs_map_tmp2 ;
2734: INSERT INTO pa_rbs_map_tmp2
2735: (txn_accum_header_id,
2736: struct_version_id, ---not needed to insert but doing
2737: supplier_id, --- supplier
2738: role_id, --- role

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

2780: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2781: END IF;
2782:
2783: -- Bug#5503706 Start
2784: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;
2785:
2786: IF g_debug_mode = 'Y' THEN
2787: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;
2788: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

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

2783: -- Bug#5503706 Start
2784: select count(*) into l_tmpcnt from PA_RBS_MAP_TMP2;
2785:
2786: IF g_debug_mode = 'Y' THEN
2787: pa_debug.g_err_stage:= 'The number of rows in pa_rbs_map_tmp2 table = '||l_tmpcnt;
2788: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2789: END IF;
2790:
2791: if l_tmpcnt >0 then