APPS.PA_RBS_MAPPING dependencies on PA_RBS_ELEMENT_MAP

Line 2124: (select resource_name from pa_rbs_element_map where

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
2124: (select resource_name from pa_rbs_element_map where
2125: resource_type_id = 14);
2126:
2127: FOR p IN 1..l_revenue_category.COUNT LOOP
2128: create_res_type_numeric_id(l_revenue_category(p), 14, l_res_id,l_return_status,l_msg_data);

Line 2455: (select resource_name from pa_rbs_element_map where

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
2455: (select resource_name from pa_rbs_element_map where
2456: resource_type_id = 14);
2457:
2458: FOR p IN 1..l_revenue_category.COUNT LOOP
2459: PA_RBS_MAPPING.create_res_type_numeric_id(l_revenue_category(p), 14, l_res_id,l_return_status,l_msg_data);

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

2629: SELECT distinct revenue_category_code
2630: BULK COLLECT INTO l_revenue_category
2631: FROM PA_RBS_PLANS_IN_TMP
2632: WHERE revenue_category_code NOT IN
2633: (select resource_name from pa_rbs_element_map where resource_type_id = 14)
2634: AND revenue_category_code IS NOT NULL; /*Added for bug 3575147*/
2635:
2636: FOR p IN 1..l_revenue_category.COUNT LOOP
2637: create_res_type_numeric_id(l_revenue_category(p), 14, l_res_id,l_return_status,l_msg_data);

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

2641: SELECT distinct person_type_code
2642: BULK COLLECT INTO l_person_type_code
2643: FROM PA_RBS_PLANS_IN_TMP
2644: WHERE person_type_code NOT IN
2645: (select resource_name from pa_rbs_element_map where resource_type_id = 11)
2646: AND person_type_code IS NOT NULL; /* Added for bug 3575147 */
2647:
2648: FOR p IN 1..l_person_type_code.COUNT LOOP
2649: create_res_type_numeric_id(l_person_type_code(p), 11, l_res_id,l_return_status,l_msg_data);

Line 2862: pa_rbs_element_map src

2858: SET revenue_category_id =
2859: ( SELECT
2860: src.resource_id
2861: FROM
2862: pa_rbs_element_map src
2863: WHERE
2864: src.resource_name = dest.revenue_category_code AND
2865: src.resource_type_id = 14 )
2866: WHERE

Line 2874: pa_rbs_element_map src

2870: SET person_type_id =
2871: ( SELECT
2872: src.resource_id
2873: FROM
2874: pa_rbs_element_map src
2875: WHERE
2876: src.resource_name = dest.person_type_code AND
2877: src.resource_type_id = 11 )
2878: WHERE

Line 3248: FROM PA_RBS_ELEMENT_MAP

3244: END IF;
3245:
3246: SELECT count(*)
3247: INTO l_count
3248: FROM PA_RBS_ELEMENT_MAP
3249: WHERE resource_name = l_resource_name
3250: AND resource_type_id = p_resource_type_id ;
3251:
3252: IF l_count = 1 THEN

Line 3255: FROM PA_RBS_ELEMENT_MAP

3251:
3252: IF l_count = 1 THEN
3253: SELECT resource_id
3254: INTO x_resource_id
3255: FROM PA_RBS_ELEMENT_MAP
3256: WHERE resource_name = l_resource_name
3257: AND resource_type_id = p_resource_type_id ;
3258: ELSIF l_count = 0 THEN
3259: SELECT PA_RBS_ELEMENT_MAP_S.nextval

Line 3259: SELECT PA_RBS_ELEMENT_MAP_S.nextval

3255: FROM PA_RBS_ELEMENT_MAP
3256: WHERE resource_name = l_resource_name
3257: AND resource_type_id = p_resource_type_id ;
3258: ELSIF l_count = 0 THEN
3259: SELECT PA_RBS_ELEMENT_MAP_S.nextval
3260: INTO x_resource_id
3261: FROM dual ;
3262:
3263: INSERT INTO PA_RBS_ELEMENT_MAP

Line 3263: INSERT INTO PA_RBS_ELEMENT_MAP

3259: SELECT PA_RBS_ELEMENT_MAP_S.nextval
3260: INTO x_resource_id
3261: FROM dual ;
3262:
3263: INSERT INTO PA_RBS_ELEMENT_MAP
3264: (
3265: RESOURCE_TYPE_ID,
3266: RESOURCE_NAME,
3267: RESOURCE_ID,

Line 3320: FROM PA_RBS_ELEMENT_MAP

3316: RETURN NULL;
3317: ELSE
3318: SELECT resource_id
3319: INTO l_resource_id
3320: FROM PA_RBS_ELEMENT_MAP
3321: WHERE resource_name = p_resource_name
3322: AND resource_type_id = p_resource_type_id;
3323:
3324: RETURN l_resource_id;