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.CN_PLAN_ELEMENT_PVT dependencies on FND_GLOBAL

Line 202: l_consolidated_note := l_note_msg || fnd_global.local_chr(10);

198: fnd_message.set_token('PE_NAME_OLD', p_plan_element_old.NAME);
199: fnd_message.set_token('PE_NAME_NEW', p_plan_element_new.NAME);
200: l_plan_element_id := p_plan_element_new.quota_id;
201: l_note_msg := fnd_message.get;
202: l_consolidated_note := l_note_msg || fnd_global.local_chr(10);
203: /* jtf_notes_pub.create_note
204: (p_api_version => 1.0,
205: x_return_status => x_return_status,
206: x_msg_count => x_msg_count,

Line 223: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

219: fnd_message.set_token('PE_START_OLD', p_plan_element_old.start_date);
220: fnd_message.set_token('PE_START_NEW', p_plan_element_new.start_date);
221: l_plan_element_id := p_plan_element_new.quota_id;
222: l_note_msg := fnd_message.get;
223: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
224: /* jtf_notes_pub.create_note
225: (p_api_version => 1.0,
226: x_return_status => x_return_status,
227: x_msg_count => x_msg_count,

Line 253: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

249: fnd_message.set_token('PE_END_NEW', p_plan_element_new.end_date);
250: END IF;
251: l_plan_element_id := p_plan_element_new.quota_id;
252: l_note_msg := fnd_message.get;
253: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
254: /* jtf_notes_pub.create_note
255: (p_api_version => 1.0,
256: x_return_status => x_return_status,
257: x_msg_count => x_msg_count,

Line 272: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

268: IF (p_plan_element_old.description <> p_plan_element_new.description) THEN
269: fnd_message.set_name ('CN','CNR12_NOTE_PE_DESC_UPDATE');
270: l_plan_element_id := p_plan_element_new.quota_id;
271: l_note_msg := fnd_message.get;
272: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
273: /* jtf_notes_pub.create_note
274: (p_api_version => 1.0,
275: x_return_status => x_return_status,
276: x_msg_count => x_msg_count,

Line 300: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

296: and org_id = p_plan_element_new.org_id;
297: fnd_message.set_token('PE_OLD_INTERVAL', l_temp_old);
298: fnd_message.set_token('PE_NEW_INTERVAL', l_temp_new);
299: l_note_msg := fnd_message.get;
300: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
301: /* jtf_notes_pub.create_note
302: (p_api_version => 1.0,
303: x_return_status => x_return_status,
304: x_msg_count => x_msg_count,

Line 324: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

320: l_temp_2 := cn_api.get_lkup_meaning(p_plan_element_new.quota_type_code, 'QUOTA_TYPE');
321: fnd_message.set_token('PE_OLD_FOR', l_temp_1);
322: fnd_message.set_token('PE_NEW_FOR', l_temp_2);
323: l_note_msg := fnd_message.get;
324: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
325: /* jtf_notes_pub.create_note
326: (p_api_version => 1.0,
327: x_return_status => x_return_status,
328: x_msg_count => x_msg_count,

Line 368: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

364: fnd_message.set_token('FORMULA_NAME_OLD', l_temp_old);
365: fnd_message.set_token('FORMULA_TYPE_NEW', l_temp_2);
366: fnd_message.set_token('FORMULA_NAME_NEW', l_temp_new);
367: l_note_msg := fnd_message.get;
368: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
369: /* jtf_notes_pub.create_note
370: (p_api_version => 1.0,
371: x_return_status => x_return_status,
372: x_msg_count => x_msg_count,

Line 390: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

386: fnd_message.set_token('PAYGRP_OLD', p_plan_element_old.payment_group_code);
387: fnd_message.set_token('PAYGRP_NEW', p_plan_element_new.payment_group_code);
388: l_plan_element_id := p_plan_element_new.quota_id;
389: l_note_msg := fnd_message.get;
390: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
391: /* jtf_notes_pub.create_note
392: (p_api_version => 1.0,
393: x_return_status => x_return_status,
394: x_msg_count => x_msg_count,

Line 418: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

414: fnd_message.set_token('PE_OLD_CREDIT', l_temp_old);
415: fnd_message.set_token('PE_NEW_CREDIT', l_temp_new);
416: l_plan_element_id := p_plan_element_new.quota_id;
417: l_note_msg := fnd_message.get;
418: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
419: /* jtf_notes_pub.create_note
420: (p_api_version => 1.0,
421: x_return_status => x_return_status,
422: x_msg_count => x_msg_count,

Line 446: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

442: fnd_message.set_token('PE_OLD_PAYEE', l_temp_old);
443: fnd_message.set_token('PE_NEW_PAYEE', l_temp_new);
444: l_plan_element_id := p_plan_element_new.quota_id;
445: l_note_msg := fnd_message.get;
446: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
447: /* jtf_notes_pub.create_note
448: (p_api_version => 1.0,
449: x_return_status => x_return_status,
450: x_msg_count => x_msg_count,

Line 476: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

472: fnd_message.set_token('PE_OLD_LIA', l_temp_old);
473: fnd_message.set_token('PE_NEW_LIA', l_temp_new);
474: l_plan_element_id := p_plan_element_new.quota_id;
475: l_note_msg := fnd_message.get;
476: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
477: /* jtf_notes_pub.create_note
478: (p_api_version => 1.0,
479: x_return_status => x_return_status,
480: x_msg_count => x_msg_count,

Line 506: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

502: fnd_message.set_token('PE_EXP_OLD', l_temp_old);
503: fnd_message.set_token('PE_EXP_NEW', l_temp_new);
504: l_plan_element_id := p_plan_element_new.quota_id;
505: l_note_msg := fnd_message.get;
506: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
507: /* jtf_notes_pub.create_note
508: (p_api_version => 1.0,
509: x_return_status => x_return_status,
510: x_msg_count => x_msg_count,

Line 530: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

526: fnd_message.set_token('PE_CR_ROLL_OLD', l_temp_old);
527: fnd_message.set_token('PE_CR_ROLL_NEW', l_temp_new);
528: l_plan_element_id := p_plan_element_new.quota_id;
529: l_note_msg := fnd_message.get;
530: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
531: /* jtf_notes_pub.create_note
532: (p_api_version => 1.0,
533: x_return_status => x_return_status,
534: x_msg_count => x_msg_count,

Line 551: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

547: fnd_message.set_token('OLD_VAL', p_plan_element_old.target);
548: fnd_message.set_token('NEW_VAL', p_plan_element_new.target);
549: l_plan_element_id := p_plan_element_new.quota_id;
550: l_note_msg := fnd_message.get;
551: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
552: /* jtf_notes_pub.create_note
553: (p_api_version => 1.0,
554: x_return_status => x_return_status,
555: x_msg_count => x_msg_count,

Line 572: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

568: fnd_message.set_token('OLD_VAL', p_plan_element_old.payment_amount);
569: fnd_message.set_token('NEW_VAL', p_plan_element_new.payment_amount);
570: l_plan_element_id := p_plan_element_new.quota_id;
571: l_note_msg := fnd_message.get;
572: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
573: /* jtf_notes_pub.create_note
574: (p_api_version => 1.0,
575: x_return_status => x_return_status,
576: x_msg_count => x_msg_count,

Line 593: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

589: fnd_message.set_token('OLD_VAL', p_plan_element_old.performance_goal);
590: fnd_message.set_token('NEW_VAL', p_plan_element_new.performance_goal);
591: l_plan_element_id := p_plan_element_new.quota_id;
592: l_note_msg := fnd_message.get;
593: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
594: /* jtf_notes_pub.create_note
595: (p_api_version => 1.0,
596: x_return_status => x_return_status,
597: x_msg_count => x_msg_count,

Line 1383: g_last_updated_by NUMBER := fnd_global.user_id;

1379: l_calc_formula_name cn_calc_formulas.NAME%TYPE := NULL;
1380: l_interval_type_name cn_interval_types.NAME%TYPE := NULL;
1381: l_formula_type cn_calc_formulas.formula_type%TYPE := NULL;
1382: g_last_update_date DATE := SYSDATE;
1383: g_last_updated_by NUMBER := fnd_global.user_id;
1384: g_creation_date DATE := SYSDATE;
1385: g_created_by NUMBER := fnd_global.user_id;
1386: g_last_update_login NUMBER := fnd_global.login_id;
1387: g_remove_this VARCHAR2 (1) := '#';

Line 1385: g_created_by NUMBER := fnd_global.user_id;

1381: l_formula_type cn_calc_formulas.formula_type%TYPE := NULL;
1382: g_last_update_date DATE := SYSDATE;
1383: g_last_updated_by NUMBER := fnd_global.user_id;
1384: g_creation_date DATE := SYSDATE;
1385: g_created_by NUMBER := fnd_global.user_id;
1386: g_last_update_login NUMBER := fnd_global.login_id;
1387: g_remove_this VARCHAR2 (1) := '#';
1388: BEGIN
1389: -- Standard Start of API savepoint

Line 1386: g_last_update_login NUMBER := fnd_global.login_id;

1382: g_last_update_date DATE := SYSDATE;
1383: g_last_updated_by NUMBER := fnd_global.user_id;
1384: g_creation_date DATE := SYSDATE;
1385: g_created_by NUMBER := fnd_global.user_id;
1386: g_last_update_login NUMBER := fnd_global.login_id;
1387: g_remove_this VARCHAR2 (1) := '#';
1388: BEGIN
1389: -- Standard Start of API savepoint
1390: SAVEPOINT create_plan_element;

Line 1656: g_last_updated_by NUMBER := fnd_global.user_id;

1652: FROM cn_srp_period_quotas
1653: WHERE quota_id = pe_quota_id;
1654:
1655: g_last_update_date DATE := SYSDATE;
1656: g_last_updated_by NUMBER := fnd_global.user_id;
1657: g_creation_date DATE := SYSDATE;
1658: g_created_by NUMBER := fnd_global.user_id;
1659: g_last_update_login NUMBER := fnd_global.login_id;
1660: g_row_id NUMBER;

Line 1658: g_created_by NUMBER := fnd_global.user_id;

1654:
1655: g_last_update_date DATE := SYSDATE;
1656: g_last_updated_by NUMBER := fnd_global.user_id;
1657: g_creation_date DATE := SYSDATE;
1658: g_created_by NUMBER := fnd_global.user_id;
1659: g_last_update_login NUMBER := fnd_global.login_id;
1660: g_row_id NUMBER;
1661: l_old_plan_element plan_element_rec_type;
1662: l_api_name CONSTANT VARCHAR2 (30) := 'Update_Plan_Element';

Line 1659: g_last_update_login NUMBER := fnd_global.login_id;

1655: g_last_update_date DATE := SYSDATE;
1656: g_last_updated_by NUMBER := fnd_global.user_id;
1657: g_creation_date DATE := SYSDATE;
1658: g_created_by NUMBER := fnd_global.user_id;
1659: g_last_update_login NUMBER := fnd_global.login_id;
1660: g_row_id NUMBER;
1661: l_old_plan_element plan_element_rec_type;
1662: l_api_name CONSTANT VARCHAR2 (30) := 'Update_Plan_Element';
1663: l_api_version CONSTANT NUMBER := 1.0;