APPS.PA_RBS_MAPPING dependencies on PA_RBS_ELEMENT_MAP

Line 2095: (select resource_name from pa_rbs_element_map where

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
2095: (select resource_name from pa_rbs_element_map where
2096: resource_type_id = 14);
2097:
2098: FOR p IN 1..l_revenue_category.COUNT LOOP
2099: create_res_type_numeric_id(l_revenue_category(p), 14, l_res_id,l_return_status,l_msg_data);

Line 2298: (select resource_name from pa_rbs_element_map where resource_type_id = 14)

2294: SELECT distinct revenue_category_code
2295: BULK COLLECT INTO l_revenue_category
2296: FROM PA_RBS_PLANS_IN_TMP
2297: WHERE revenue_category_code NOT IN
2298: (select resource_name from pa_rbs_element_map where resource_type_id = 14)
2299: AND revenue_category_code IS NOT NULL; /*Added for bug 3575147*/
2300:
2301: FOR p IN 1..l_revenue_category.COUNT LOOP
2302: create_res_type_numeric_id(l_revenue_category(p), 14, l_res_id,l_return_status,l_msg_data);

Line 2310: (select resource_name from pa_rbs_element_map where resource_type_id = 11)

2306: SELECT distinct person_type_code
2307: BULK COLLECT INTO l_person_type_code
2308: FROM PA_RBS_PLANS_IN_TMP
2309: WHERE person_type_code NOT IN
2310: (select resource_name from pa_rbs_element_map where resource_type_id = 11)
2311: AND person_type_code IS NOT NULL; /* Added for bug 3575147 */
2312:
2313: FOR p IN 1..l_person_type_code.COUNT LOOP
2314: create_res_type_numeric_id(l_person_type_code(p), 11, l_res_id,l_return_status,l_msg_data);

Line 2527: pa_rbs_element_map src

2523: SET revenue_category_id =
2524: ( SELECT
2525: src.resource_id
2526: FROM
2527: pa_rbs_element_map src
2528: WHERE
2529: src.resource_name = dest.revenue_category_code AND
2530: src.resource_type_id = 14 )
2531: WHERE

Line 2539: pa_rbs_element_map src

2535: SET person_type_id =
2536: ( SELECT
2537: src.resource_id
2538: FROM
2539: pa_rbs_element_map src
2540: WHERE
2541: src.resource_name = dest.person_type_code AND
2542: src.resource_type_id = 11 )
2543: WHERE

Line 2913: FROM PA_RBS_ELEMENT_MAP

2909: END IF;
2910:
2911: SELECT count(*)
2912: INTO l_count
2913: FROM PA_RBS_ELEMENT_MAP
2914: WHERE resource_name = l_resource_name
2915: AND resource_type_id = p_resource_type_id ;
2916:
2917: IF l_count = 1 THEN

Line 2920: FROM PA_RBS_ELEMENT_MAP

2916:
2917: IF l_count = 1 THEN
2918: SELECT resource_id
2919: INTO x_resource_id
2920: FROM PA_RBS_ELEMENT_MAP
2921: WHERE resource_name = l_resource_name
2922: AND resource_type_id = p_resource_type_id ;
2923: ELSIF l_count = 0 THEN
2924: SELECT PA_RBS_ELEMENT_MAP_S.nextval

Line 2924: SELECT PA_RBS_ELEMENT_MAP_S.nextval

2920: FROM PA_RBS_ELEMENT_MAP
2921: WHERE resource_name = l_resource_name
2922: AND resource_type_id = p_resource_type_id ;
2923: ELSIF l_count = 0 THEN
2924: SELECT PA_RBS_ELEMENT_MAP_S.nextval
2925: INTO x_resource_id
2926: FROM dual ;
2927:
2928: INSERT INTO PA_RBS_ELEMENT_MAP

Line 2928: INSERT INTO PA_RBS_ELEMENT_MAP

2924: SELECT PA_RBS_ELEMENT_MAP_S.nextval
2925: INTO x_resource_id
2926: FROM dual ;
2927:
2928: INSERT INTO PA_RBS_ELEMENT_MAP
2929: (
2930: RESOURCE_TYPE_ID,
2931: RESOURCE_NAME,
2932: RESOURCE_ID,

Line 2985: FROM PA_RBS_ELEMENT_MAP

2981: RETURN NULL;
2982: ELSE
2983: SELECT resource_id
2984: INTO l_resource_id
2985: FROM PA_RBS_ELEMENT_MAP
2986: WHERE resource_name = p_resource_name
2987: AND resource_type_id = p_resource_type_id;
2988:
2989: RETURN l_resource_id;