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.

[Home] [Help]

APPS.PON_NEG_STYLES_TL_PKG dependencies on PON_NEGOTIATION_STYLES_TL

Line 43: ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE

39: ,p_intgr_cat_line_attr_flag IN pon_negotiation_styles.intgr_cat_line_attr_flag%TYPE
40: ,p_intgr_item_line_attr_flag IN pon_negotiation_styles.intgr_item_line_attr_flag%TYPE
41: ,p_intgr_cat_line_asl_flag IN pon_negotiation_styles.intgr_cat_line_asl_flag%TYPE
42: ---------------------------------------------------------------------------------------------
43: ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
44: ,p_description IN pon_negotiation_styles_tl.description%TYPE) IS
45:
46: BEGIN
47:

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

40: ,p_intgr_item_line_attr_flag IN pon_negotiation_styles.intgr_item_line_attr_flag%TYPE
41: ,p_intgr_cat_line_asl_flag IN pon_negotiation_styles.intgr_cat_line_asl_flag%TYPE
42: ---------------------------------------------------------------------------------------------
43: ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
44: ,p_description IN pon_negotiation_styles_tl.description%TYPE) IS
45:
46: BEGIN
47:
48: INSERT INTO pon_negotiation_styles

Line 129: INSERT INTO pon_negotiation_styles_tl

125: ,p_intgr_cat_line_asl_flag
126: -------------------------------------------------
127: );
128:
129: INSERT INTO pon_negotiation_styles_tl
130: (style_id
131: ,style_name
132: ,description
133: ,language

Line 156: FROM pon_negotiation_styles_tl tl

152: fnd_languages l
153: WHERE installed_flag in ('I', 'B')
154: AND NOT EXISTS
155: (SELECT NULL
156: FROM pon_negotiation_styles_tl tl
157: WHERE tl.style_id = p_style_id
158: AND tl.language = l.language_code);
159:
160: END insert_row;

Line 199: ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE

195: ,p_intgr_cat_line_attr_flag IN pon_negotiation_styles.intgr_cat_line_attr_flag%TYPE
196: ,p_intgr_item_line_attr_flag IN pon_negotiation_styles.intgr_item_line_attr_flag%TYPE
197: ,p_intgr_cat_line_asl_flag IN pon_negotiation_styles.intgr_cat_line_asl_flag%TYPE
198: ---------------------------------------------------------------------------------------------
199: ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
200: ,p_description IN pon_negotiation_styles_tl.description%TYPE) IS
201: BEGIN
202:
203: UPDATE pon_negotiation_styles

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

196: ,p_intgr_item_line_attr_flag IN pon_negotiation_styles.intgr_item_line_attr_flag%TYPE
197: ,p_intgr_cat_line_asl_flag IN pon_negotiation_styles.intgr_cat_line_asl_flag%TYPE
198: ---------------------------------------------------------------------------------------------
199: ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
200: ,p_description IN pon_negotiation_styles_tl.description%TYPE) IS
201: BEGIN
202:
203: UPDATE pon_negotiation_styles
204: SET status = p_status

Line 247: UPDATE pon_negotiation_styles_tl

243: RAISE NO_DATA_FOUND;
244: END IF;
245:
246:
247: UPDATE pon_negotiation_styles_tl
248: SET style_name = p_style_name
249: ,description = p_description
250: ,last_update_date = p_last_update_date
251: ,last_updated_by = p_last_updated_by

Line 268: p_style_name IN pon_negotiation_styles_tl.style_name%TYPE,

264: -- Translate_row is called during NLS translation during FNDLOAD
265:
266: PROCEDURE translate_row (
267: p_style_id IN pon_negotiation_styles.style_id%TYPE,
268: p_style_name IN pon_negotiation_styles_tl.style_name%TYPE,
269: p_description IN pon_negotiation_styles_tl.description%TYPE,
270: p_owner IN VARCHAR2,
271: p_custom_mode IN VARCHAR2,
272: p_last_update_date IN VARCHAR2) IS

Line 269: p_description IN pon_negotiation_styles_tl.description%TYPE,

265:
266: PROCEDURE translate_row (
267: p_style_id IN pon_negotiation_styles.style_id%TYPE,
268: p_style_name IN pon_negotiation_styles_tl.style_name%TYPE,
269: p_description IN pon_negotiation_styles_tl.description%TYPE,
270: p_owner IN VARCHAR2,
271: p_custom_mode IN VARCHAR2,
272: p_last_update_date IN VARCHAR2) IS
273:

Line 289: from pon_negotiation_styles_tl

285: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
286:
287: select LAST_UPDATED_BY, LAST_UPDATE_DATE
288: into db_luby, db_ludate
289: from pon_negotiation_styles_tl
290: where style_id = p_style_id
291: and userenv('LANG') = LANGUAGE;
292:
293:

Line 294: UPDATE pon_negotiation_styles_tl

290: where style_id = p_style_id
291: and userenv('LANG') = LANGUAGE;
292:
293:
294: UPDATE pon_negotiation_styles_tl
295: SET style_name = p_style_name
296: ,description = p_description
297: ,last_update_date = f_ludate
298: ,last_updated_by = f_luby

Line 351: ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE

347: ,p_intgr_cat_line_attr_flag IN pon_negotiation_styles.intgr_cat_line_attr_flag%TYPE
348: ,p_intgr_item_line_attr_flag IN pon_negotiation_styles.intgr_item_line_attr_flag%TYPE
349: ,p_intgr_cat_line_asl_flag IN pon_negotiation_styles.intgr_cat_line_asl_flag%TYPE
350: ---------------------------------------------------------------------------------------------
351: ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
352: ,p_description IN pon_negotiation_styles_tl.description%TYPE) IS
353: -- Last update information from the file being uploaded
354: l_f_last_updated_by pon_negotiation_styles.last_updated_by%TYPE;
355: l_f_last_update_date pon_negotiation_styles.last_update_date%TYPE;

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

348: ,p_intgr_item_line_attr_flag IN pon_negotiation_styles.intgr_item_line_attr_flag%TYPE
349: ,p_intgr_cat_line_asl_flag IN pon_negotiation_styles.intgr_cat_line_asl_flag%TYPE
350: ---------------------------------------------------------------------------------------------
351: ,p_style_name IN pon_negotiation_styles_tl.style_name%TYPE
352: ,p_description IN pon_negotiation_styles_tl.description%TYPE) IS
353: -- Last update information from the file being uploaded
354: l_f_last_updated_by pon_negotiation_styles.last_updated_by%TYPE;
355: l_f_last_update_date pon_negotiation_styles.last_update_date%TYPE;
356:

Line 483: DELETE FROM pon_negotiation_styles_tl

479: THEN
480: RAISE NO_DATA_FOUND;
481: END IF;
482:
483: DELETE FROM pon_negotiation_styles_tl
484: WHERE style_id = p_style_id;
485:
486: END delete_row;
487:

Line 493: INSERT INTO pon_negotiation_styles_TL (

489: PROCEDURE add_language IS
490:
491: BEGIN
492:
493: INSERT INTO pon_negotiation_styles_TL (
494: style_id,
495: style_name,
496: description,
497: language,

Line 516: FROM pon_negotiation_styles_tl tl,

512: tl.created_by,
513: tl.last_update_date,
514: tl.last_updated_by,
515: tl.last_update_login
516: FROM pon_negotiation_styles_tl tl,
517: fnd_languages lang
518: WHERE language = USERENV('LANG')
519: AND lang.INSTALLED_FLAG in ('I', 'B')
520: AND NOT EXISTS (SELECT NULL

Line 521: FROM pon_negotiation_styles_TL tl2

517: fnd_languages lang
518: WHERE language = USERENV('LANG')
519: AND lang.INSTALLED_FLAG in ('I', 'B')
520: AND NOT EXISTS (SELECT NULL
521: FROM pon_negotiation_styles_TL tl2
522: WHERE tl2.style_id = tl.style_id
523: AND tl2.language = lang.language_code);
524:
525: END add_language;