eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_NEG_STYLES_TL_PKG dependencies on PON_NEGOTIATION_STYLES_TL

Line 27: ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE

23: ,p_last_update_date IN pon_negotiation_styles.last_update_date%TYPE
24: ,p_last_updated_by IN pon_negotiation_styles.last_updated_by%TYPE
25: ,p_last_update_login IN pon_negotiation_styles.last_update_login%TYPE
26: ,p_qty_price_tiers_enabled_flag IN pon_negotiation_styles.qty_price_tiers_enabled_flag%TYPE
27: ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
28: ,p_description IN pon_negotiation_styles_tl.description%TYPE) IS
29:
30: BEGIN
31:

Line 28: ,p_description IN pon_negotiation_styles_tl.description%TYPE) IS

24: ,p_last_updated_by IN pon_negotiation_styles.last_updated_by%TYPE
25: ,p_last_update_login IN pon_negotiation_styles.last_update_login%TYPE
26: ,p_qty_price_tiers_enabled_flag IN pon_negotiation_styles.qty_price_tiers_enabled_flag%TYPE
27: ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
28: ,p_description IN pon_negotiation_styles_tl.description%TYPE) IS
29:
30: BEGIN
31:
32: INSERT INTO pon_negotiation_styles

Line 79: INSERT INTO pon_negotiation_styles_tl

75: ,p_last_updated_by
76: ,p_last_update_login
77: ,p_qty_price_tiers_enabled_flag);
78:
79: INSERT INTO pon_negotiation_styles_tl
80: (style_id
81: ,style_name
82: ,description
83: ,language

Line 106: FROM pon_negotiation_styles_tl tl

102: fnd_languages l
103: WHERE installed_flag in ('I', 'B')
104: AND NOT EXISTS
105: (SELECT NULL
106: FROM pon_negotiation_styles_tl tl
107: WHERE tl.style_id = p_style_id
108: AND tl.language = l.language_code);
109:
110: END insert_row;

Line 133: ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE

129: ,p_last_update_date IN pon_negotiation_styles.last_update_date%TYPE
130: ,p_last_updated_by IN pon_negotiation_styles.last_updated_by%TYPE
131: ,p_last_update_login IN pon_negotiation_styles.last_update_login%TYPE
132: ,p_qty_price_tiers_enabled_flag IN pon_negotiation_styles.qty_price_tiers_enabled_flag%TYPE
133: ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
134: ,p_description IN pon_negotiation_styles_tl.description%TYPE) IS
135: BEGIN
136:
137: UPDATE pon_negotiation_styles

Line 134: ,p_description IN pon_negotiation_styles_tl.description%TYPE) IS

130: ,p_last_updated_by IN pon_negotiation_styles.last_updated_by%TYPE
131: ,p_last_update_login IN pon_negotiation_styles.last_update_login%TYPE
132: ,p_qty_price_tiers_enabled_flag IN pon_negotiation_styles.qty_price_tiers_enabled_flag%TYPE
133: ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
134: ,p_description IN pon_negotiation_styles_tl.description%TYPE) IS
135: BEGIN
136:
137: UPDATE pon_negotiation_styles
138: SET status = p_status

Line 165: UPDATE pon_negotiation_styles_tl

161: RAISE NO_DATA_FOUND;
162: END IF;
163:
164:
165: UPDATE pon_negotiation_styles_tl
166: SET style_name = p_style_name
167: ,description = p_description
168: ,last_update_date = p_last_update_date
169: ,last_updated_by = p_last_updated_by

Line 186: p_style_name IN pon_negotiation_styles_tl.style_name%TYPE,

182: -- Translate_row is called during NLS translation during FNDLOAD
183:
184: PROCEDURE translate_row (
185: p_style_id IN pon_negotiation_styles.style_id%TYPE,
186: p_style_name IN pon_negotiation_styles_tl.style_name%TYPE,
187: p_description IN pon_negotiation_styles_tl.description%TYPE,
188: p_owner IN VARCHAR2,
189: p_custom_mode IN VARCHAR2,
190: p_last_update_date IN VARCHAR2) IS

Line 187: p_description IN pon_negotiation_styles_tl.description%TYPE,

183:
184: PROCEDURE translate_row (
185: p_style_id IN pon_negotiation_styles.style_id%TYPE,
186: p_style_name IN pon_negotiation_styles_tl.style_name%TYPE,
187: p_description IN pon_negotiation_styles_tl.description%TYPE,
188: p_owner IN VARCHAR2,
189: p_custom_mode IN VARCHAR2,
190: p_last_update_date IN VARCHAR2) IS
191:

Line 207: from pon_negotiation_styles_tl

203: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
204:
205: select LAST_UPDATED_BY, LAST_UPDATE_DATE
206: into db_luby, db_ludate
207: from pon_negotiation_styles_tl
208: where style_id = p_style_id
209: and userenv('LANG') = LANGUAGE;
210:
211:

Line 212: UPDATE pon_negotiation_styles_tl

208: where style_id = p_style_id
209: and userenv('LANG') = LANGUAGE;
210:
211:
212: UPDATE pon_negotiation_styles_tl
213: SET style_name = p_style_name
214: ,description = p_description
215: ,last_update_date = f_ludate
216: ,last_updated_by = f_luby

Line 253: ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE

249: ,p_power_bidding_enabled_flag IN pon_negotiation_styles.power_bidding_enabled_flag%TYPE
250: ,p_auto_extend_enabled_flag IN pon_negotiation_styles.auto_extend_enabled_flag%TYPE
251: ,p_team_scoring_enabled_flag IN pon_negotiation_styles.team_scoring_enabled_flag%TYPE
252: ,p_qty_price_tiers_enabled_flag IN pon_negotiation_styles.qty_price_tiers_enabled_flag%TYPE
253: ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
254: ,p_description IN pon_negotiation_styles_tl.description%TYPE) IS
255: -- Last update information from the file being uploaded
256: l_f_last_updated_by pon_negotiation_styles.last_updated_by%TYPE;
257: l_f_last_update_date pon_negotiation_styles.last_update_date%TYPE;

Line 254: ,p_description IN pon_negotiation_styles_tl.description%TYPE) IS

250: ,p_auto_extend_enabled_flag IN pon_negotiation_styles.auto_extend_enabled_flag%TYPE
251: ,p_team_scoring_enabled_flag IN pon_negotiation_styles.team_scoring_enabled_flag%TYPE
252: ,p_qty_price_tiers_enabled_flag IN pon_negotiation_styles.qty_price_tiers_enabled_flag%TYPE
253: ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
254: ,p_description IN pon_negotiation_styles_tl.description%TYPE) IS
255: -- Last update information from the file being uploaded
256: l_f_last_updated_by pon_negotiation_styles.last_updated_by%TYPE;
257: l_f_last_update_date pon_negotiation_styles.last_update_date%TYPE;
258:

Line 353: DELETE FROM pon_negotiation_styles_tl

349: THEN
350: RAISE NO_DATA_FOUND;
351: END IF;
352:
353: DELETE FROM pon_negotiation_styles_tl
354: WHERE style_id = p_style_id;
355:
356: END delete_row;
357:

Line 363: INSERT INTO pon_negotiation_styles_TL (

359: PROCEDURE add_language IS
360:
361: BEGIN
362:
363: INSERT INTO pon_negotiation_styles_TL (
364: style_id,
365: style_name,
366: description,
367: language,

Line 386: FROM pon_negotiation_styles_tl tl,

382: tl.created_by,
383: tl.last_update_date,
384: tl.last_updated_by,
385: tl.last_update_login
386: FROM pon_negotiation_styles_tl tl,
387: fnd_languages lang
388: WHERE language = USERENV('LANG')
389: AND lang.INSTALLED_FLAG in ('I', 'B')
390: AND NOT EXISTS (SELECT NULL

Line 391: FROM pon_negotiation_styles_TL tl2

387: fnd_languages lang
388: WHERE language = USERENV('LANG')
389: AND lang.INSTALLED_FLAG in ('I', 'B')
390: AND NOT EXISTS (SELECT NULL
391: FROM pon_negotiation_styles_TL tl2
392: WHERE tl2.style_id = tl.style_id
393: AND tl2.language = lang.language_code);
394:
395: END add_language;