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 365: g_last_updated_by NUMBER := fnd_global.user_id;

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

Line 367: g_created_by NUMBER := fnd_global.user_id;

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

Line 368: g_last_update_login NUMBER := fnd_global.login_id;

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

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

653: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_UPDATE');
654: fnd_message.set_token ('OLD_CP_NAME', l_old_comp_plan.NAME);
655: fnd_message.set_token ('NEW_CP_NAME', p_comp_plan.NAME);
656: l_note_msg := fnd_message.get;
657: l_consolidated_note := l_note_msg || fnd_global.local_chr(10);
658:
659: /*
660: jtf_notes_pub.create_note (p_api_version => 1.0,
661: x_return_status => x_return_status,

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

680: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_SDATE_CRE');
681: fnd_message.set_token ('OLD_ST_DATE', TO_CHAR (l_old_comp_plan.start_date));
682: fnd_message.set_token ('NEW_ST_DATE', TO_CHAR (p_comp_plan.start_date));
683: l_note_msg := fnd_message.get;
684: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
685:
686: /*
687: jtf_notes_pub.create_note (p_api_version => 1.0,
688: x_return_status => x_return_status,

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

705: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_EDATE_UPD');
706: fnd_message.set_token ('OLD_END_DATE', TO_CHAR (l_old_comp_plan.end_date));
707: fnd_message.set_token ('NEW_END_DATE', TO_CHAR (p_comp_plan.end_date));
708: l_note_msg := fnd_message.get;
709: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
710: /*
711: jtf_notes_pub.create_note (p_api_version => 1.0,
712: x_return_status => x_return_status,
713: x_msg_count => x_msg_count,

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

731: THEN
732: -- Need to add note CNR12_NOTE_COMPPLAN_ELIG_UPD2
733: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ELIG_UPD2');
734: l_note_msg := fnd_message.get;
735: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
736: /*
737: jtf_notes_pub.create_note (p_api_version => 1.0,
738: x_return_status => x_return_status,
739: x_msg_count => x_msg_count,

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

757: THEN
758: -- Need to add note CNR12_NOTE_COMPPLAN_ELIG_UPD1
759: fnd_message.set_name ('CN', 'CNR12_NOTE_COMPPLAN_ELIG_UPD1');
760: l_note_msg := fnd_message.get;
761: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
762: /*
763: jtf_notes_pub.create_note (p_api_version => 1.0,
764: x_return_status => x_return_status,
765: x_msg_count => x_msg_count,