DBA Data[Home] [Help]

APPS.PON_CF_TYPE_GRP dependencies on PON_PRICE_ELEMENT_TYPES_TL

Line 22: ,p_name IN pon_price_element_types_tl.name%TYPE DEFAULT NULL

18: PROCEDURE get_Cost_Factor_details(
19: p_api_version IN NUMBER
20: ,p_price_element_id IN pon_price_element_types.price_element_type_id%TYPE
21: ,p_price_element_code IN pon_price_element_types.price_element_code%TYPE DEFAULT NULL
22: ,p_name IN pon_price_element_types_tl.name%TYPE DEFAULT NULL
23: ,x_cost_factor_rec OUT NOCOPY pon_price_element_types_vl%ROWTYPE
24: ,x_return_status OUT NOCOPY VARCHAR2
25: ,x_msg_data OUT NOCOPY VARCHAR2
26: ,x_msg_count OUT NOCOPY NUMBER

Line 155: ,p_name IN pon_price_element_types_tl.name%TYPE

151: ,p_pricing_basis IN pon_price_element_types.pricing_basis%TYPE
152: ,p_cost_component_class_id IN pon_price_element_types.cost_component_class_id%TYPE
153: ,p_cost_analysis_code IN pon_price_element_types.cost_analysis_code%TYPE
154: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE
155: ,p_name IN pon_price_element_types_tl.name%TYPE
156: ,p_description IN pon_price_element_types_tl.name%TYPE
157: ,x_insert_update_action OUT NOCOPY VARCHAR2
158: ,x_price_element_type_id OUT NOCOPY pon_price_element_types.price_element_type_id%TYPE
159: ,x_pricing_basis OUT NOCOPY pon_price_element_types.pricing_basis%TYPE

Line 156: ,p_description IN pon_price_element_types_tl.name%TYPE

152: ,p_cost_component_class_id IN pon_price_element_types.cost_component_class_id%TYPE
153: ,p_cost_analysis_code IN pon_price_element_types.cost_analysis_code%TYPE
154: ,p_cost_acquisition_code IN pon_price_element_types.cost_acquisition_code%TYPE
155: ,p_name IN pon_price_element_types_tl.name%TYPE
156: ,p_description IN pon_price_element_types_tl.name%TYPE
157: ,x_insert_update_action OUT NOCOPY VARCHAR2
158: ,x_price_element_type_id OUT NOCOPY pon_price_element_types.price_element_type_id%TYPE
159: ,x_pricing_basis OUT NOCOPY pon_price_element_types.pricing_basis%TYPE
160: ,x_return_status OUT NOCOPY VARCHAR2

Line 339: INSERT INTO pon_price_element_types_tl

335: -- The id is passed back so that OPM can update their tables
336:
337: l_stage := '120: Insert cost factor tl';
338:
339: INSERT INTO pon_price_element_types_tl
340: ( price_element_type_id
341: ,trading_partner_id
342: ,name
343: ,description