APPS.PON_PRICE_ELEMENTS_PKG dependencies on PON_PRICE_ELEMENT_TYPES

Line 32: insert into pon_price_element_types_tl(PRICE_ELEMENT_TYPE_ID,

28:
29: p_result := 0;
30:
31:
32: insert into pon_price_element_types_tl(PRICE_ELEMENT_TYPE_ID,
33: TRADING_PARTNER_ID,
34: NAME,
35: DESCRIPTION,
36: LANGUAGE,

Line 98: from pon_price_element_types

94:
95: begin
96: select 'Y'
97: into x_updated
98: from pon_price_element_types
99: where price_element_type_id = p_typeId
100: and last_update_date <> p_lastUpdate;
101:
102: p_result := 1;

Line 114: update pon_price_element_types_tl

110: if(p_result = 0) then
111: x_err_loc := 200;
112:
113:
114: update pon_price_element_types_tl
115: set
116: name = p_name,
117: description = p_description,
118: source_lang = p_language,

Line 142: -- COMMENT : Used to popluate the PON_PRICE_ELEMENT_TYPES_TL table when

138: END;
139:
140: -- ======================================================================
141: -- PROCEDURE : ADD_LANGUAGE
142: -- COMMENT : Used to popluate the PON_PRICE_ELEMENT_TYPES_TL table when
143: -- a new language is added. It is called from sql/PONNLINS.sql
144: -- ======================================================================
145: PROCEDURE ADD_LANGUAGE
146: IS

Line 152: -- in the PON_PRICE_ELEMENT_TYPES_TL table if not

148: BEGIN
149:
150: --
151: -- Get the current language and try to insert a row
152: -- in the PON_PRICE_ELEMENT_TYPES_TL table if not
153: -- existing
154: --
155:
156: INSERT INTO

Line 157: PON_PRICE_ELEMENT_TYPES_TL (

153: -- existing
154: --
155:
156: INSERT INTO
157: PON_PRICE_ELEMENT_TYPES_TL (
158: PRICE_ELEMENT_TYPE_ID,
159: TRADING_PARTNER_ID,
160: NAME,
161: DESCRIPTION,

Line 180: FROM PON_PRICE_ELEMENT_TYPES_TL pe,

176: sysdate,
177: pe.CREATED_BY,
178: sysdate,
179: pe.LAST_UPDATED_BY
180: FROM PON_PRICE_ELEMENT_TYPES_TL pe,
181: FND_LANGUAGES lang
182: WHERE pe.LANGUAGE = USERENV('LANG')
183: AND lang.INSTALLED_FLAG IN ('I','B')
184: AND NOT EXISTS (SELECT 'x'

Line 185: FROM PON_PRICE_ELEMENT_TYPES_TL pe2

181: FND_LANGUAGES lang
182: WHERE pe.LANGUAGE = USERENV('LANG')
183: AND lang.INSTALLED_FLAG IN ('I','B')
184: AND NOT EXISTS (SELECT 'x'
185: FROM PON_PRICE_ELEMENT_TYPES_TL pe2
186: WHERE pe2.PRICE_ELEMENT_TYPE_ID = pe.PRICE_ELEMENT_TYPE_ID
187: AND pe2.language = lang.language_code);
188:
189: END ADD_LANGUAGE;