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_COMP_PLAN_PVT dependencies on FND_GLOBAL

Line 367: g_last_updated_by NUMBER := fnd_global.user_id;

363: IS
364: l_api_name CONSTANT VARCHAR2 (30) := 'Update_Comp_Plan';
365: l_api_version CONSTANT NUMBER := 1.0;
366: g_last_update_date DATE := SYSDATE;
367: g_last_updated_by NUMBER := fnd_global.user_id;
368: g_creation_date DATE := SYSDATE;
369: g_created_by NUMBER := fnd_global.user_id;
370: g_last_update_login NUMBER := fnd_global.login_id;
371: g_rowid VARCHAR2 (30);

Line 369: g_created_by NUMBER := fnd_global.user_id;

365: l_api_version CONSTANT NUMBER := 1.0;
366: g_last_update_date DATE := SYSDATE;
367: g_last_updated_by NUMBER := fnd_global.user_id;
368: g_creation_date DATE := SYSDATE;
369: g_created_by NUMBER := fnd_global.user_id;
370: g_last_update_login NUMBER := fnd_global.login_id;
371: g_rowid VARCHAR2 (30);
372:
373: CURSOR l_old_comp_plan_cr

Line 370: g_last_update_login NUMBER := fnd_global.login_id;

366: g_last_update_date DATE := SYSDATE;
367: g_last_updated_by NUMBER := fnd_global.user_id;
368: g_creation_date DATE := SYSDATE;
369: g_created_by NUMBER := fnd_global.user_id;
370: g_last_update_login NUMBER := fnd_global.login_id;
371: g_rowid VARCHAR2 (30);
372:
373: CURSOR l_old_comp_plan_cr
374: IS

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

662: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_UPDATE');
663: fnd_message.set_token ('OLD_CP_NAME', l_old_comp_plan.NAME);
664: fnd_message.set_token ('NEW_CP_NAME', p_comp_plan.NAME);
665: l_note_msg := fnd_message.get;
666: l_consolidated_note := l_note_msg || fnd_global.local_chr(10);
667:
668: /*
669: jtf_notes_pub.create_note (p_api_version => 1.0,
670: x_return_status => x_return_status,

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

689: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_SDATE_CRE');
690: fnd_message.set_token ('OLD_ST_DATE', TO_CHAR (l_old_comp_plan.start_date));
691: fnd_message.set_token ('NEW_ST_DATE', TO_CHAR (p_comp_plan.start_date));
692: l_note_msg := fnd_message.get;
693: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
694:
695: /*
696: jtf_notes_pub.create_note (p_api_version => 1.0,
697: x_return_status => x_return_status,

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

714: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_EDATE_UPD');
715: fnd_message.set_token ('OLD_END_DATE', TO_CHAR (l_old_comp_plan.end_date));
716: fnd_message.set_token ('NEW_END_DATE', TO_CHAR (p_comp_plan.end_date));
717: l_note_msg := fnd_message.get;
718: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
719: /*
720: jtf_notes_pub.create_note (p_api_version => 1.0,
721: x_return_status => x_return_status,
722: x_msg_count => x_msg_count,

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

740: THEN
741: -- Need to add note CNR12_NOTE_COMPPLAN_ELIG_UPD2
742: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ELIG_UPD2');
743: l_note_msg := fnd_message.get;
744: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
745: /*
746: jtf_notes_pub.create_note (p_api_version => 1.0,
747: x_return_status => x_return_status,
748: x_msg_count => x_msg_count,

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

766: THEN
767: -- Need to add note CNR12_NOTE_COMPPLAN_ELIG_UPD1
768: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ELIG_UPD1');
769: l_note_msg := fnd_message.get;
770: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
771: /*
772: jtf_notes_pub.create_note (p_api_version => 1.0,
773: x_return_status => x_return_status,
774: x_msg_count => x_msg_count,