[Home] [Help]
314: IF p_resource_type_code = 'EVENT_TYPE' THEN
315: BEGIN
316: SELECT Event_Type
317: INTO l_element_name
318: FROM pa_event_types
319: WHERE event_type_id = p_resource_source_id;
320: EXCEPTION
321: WHEN OTHERS THEN
322: l_element_name := Null;
897: FND_GLOBAL.LOGIN_ID
898: FROM
899: pa_rbs_element_names_b a,
900: pa_rbs_elem_in_temp b,
901: pa_event_types c,
902: Fnd_Languages L
903: WHERE a.resource_source_id = b.resource_source_id
904: and c.event_type_id = a.resource_source_id
905: AND a.resource_type_id = p_resource_type_id
1839: fnd_global.user_id,
1840: sysdate,
1841: fnd_global.user_id,
1842: fnd_global.login_id
1843: FROM PA_EVENT_TYPES E,
1844: pa_rbs_element_names_b a,
1845: Fnd_Languages L
1846: WHERE a.resource_type_id=4
1847: AND E.event_type_id=a.resource_source_id
2882: from pa_expenditure_categories)
2883: UNION
2884: (select event_type_id resource_source_id,
2885: event_type resource_name, 3 type_number
2886: from pa_event_types)) source
2887: WHERE rlm.resource_list_id = l_list.resource_list_id
2888: AND ((rlm.resource_type_id = 105
2889: AND typ.res_type_code = 'EXPENDITURE_TYPE'
2890: AND source.resource_name = rlm.expenditure_type
2916: from pa_expenditure_categories)
2917: UNION
2918: (select event_type_id resource_source_id,
2919: event_type resource_name, 3 type_number
2920: from pa_event_types)) source
2921: WHERE rlm.resource_list_id = l_list.resource_list_id
2922: AND ((rlm.resource_type_id = 106
2923: AND typ.res_type_code = 'EVENT_TYPE'
2924: AND source.resource_name = rlm.event_type
3267: --ELSIF l_res_type_code = 'EVENT_TYPE' THEN
3268: IF l_members.event_type IS NOT NULL THEN
3269: SELECT event_type_id
3270: INTO l_event_type_id
3271: FROM pa_event_types
3272: WHERE event_type = l_members.event_type;
3273: END IF;
3274:
3275: SELECT decode(l_res_type_code,