314: ,p_pricing_basis
315: ,'Y' -- enabled_flag
316: ,'N' -- system_flag
317: ,SYSDATE -- creation_date,
318: ,fnd_global.user_id -- created_by
319: ,SYSDATE -- last_update_date
320: ,fnd_global.user_id -- last_updated_by
321: ,NULL -- allocation_basis
322: ,NULL -- invoice_line_type
316: ,'N' -- system_flag
317: ,SYSDATE -- creation_date,
318: ,fnd_global.user_id -- created_by
319: ,SYSDATE -- last_update_date
320: ,fnd_global.user_id -- last_updated_by
321: ,NULL -- allocation_basis
322: ,NULL -- invoice_line_type
323: ,p_cost_analysis_code
324: ,p_cost_component_class_id
354: ,p_description
355: ,fndlang.language_code
356: ,l_source_language -- source_lang
357: ,SYSDATE -- creation_date
358: ,fnd_global.user_id -- created_by
359: ,SYSDATE -- last_update_date
360: ,fnd_global.user_id -- last_updated_by
361: FROM fnd_languages fndlang
362: WHERE fndlang.installed_flag IN ('I','B');
356: ,l_source_language -- source_lang
357: ,SYSDATE -- creation_date
358: ,fnd_global.user_id -- created_by
359: ,SYSDATE -- last_update_date
360: ,fnd_global.user_id -- last_updated_by
361: FROM fnd_languages fndlang
362: WHERE fndlang.installed_flag IN ('I','B');
363:
364: ELSE -- if not a new cost factor
371:
372: UPDATE pon_price_element_types
373: SET
374: last_update_date = SYSDATE
375: ,last_updated_by = fnd_global.user_id
376: ,cost_analysis_code = p_cost_analysis_code
377: ,cost_component_class_id = p_cost_component_class_id
378: ,cost_acquisition_code = p_cost_acquisition_code
379: WHERE price_element_type_id = l_price_element_type_id;