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

Line 6: g_last_updated_by NUMBER := fnd_global.user_id;

2: /* $Header: cnprlplb.pls 120.11 2007/07/26 01:10:20 appldev ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_ROLE_PLANS_PUB';
4: g_file_name CONSTANT VARCHAR2 (12) := 'cnprlplb.pls';
5: g_last_update_date DATE := SYSDATE;
6: g_last_updated_by NUMBER := fnd_global.user_id;
7: g_creation_date DATE := SYSDATE;
8: g_created_by NUMBER := fnd_global.user_id;
9: g_last_update_login NUMBER := fnd_global.login_id;
10: g_miss_job_title NUMBER := -99;

Line 8: g_created_by NUMBER := fnd_global.user_id;

4: g_file_name CONSTANT VARCHAR2 (12) := 'cnprlplb.pls';
5: g_last_update_date DATE := SYSDATE;
6: g_last_updated_by NUMBER := fnd_global.user_id;
7: g_creation_date DATE := SYSDATE;
8: g_created_by NUMBER := fnd_global.user_id;
9: g_last_update_login NUMBER := fnd_global.login_id;
10: g_miss_job_title NUMBER := -99;
11: g_rowid VARCHAR2 (15);
12: g_program_type VARCHAR2 (30);

Line 9: g_last_update_login NUMBER := fnd_global.login_id;

5: g_last_update_date DATE := SYSDATE;
6: g_last_updated_by NUMBER := fnd_global.user_id;
7: g_creation_date DATE := SYSDATE;
8: g_created_by NUMBER := fnd_global.user_id;
9: g_last_update_login NUMBER := fnd_global.login_id;
10: g_miss_job_title NUMBER := -99;
11: g_rowid VARCHAR2 (15);
12: g_program_type VARCHAR2 (30);
13:

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

1921: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');
1922: fnd_message.set_token ('NEWVALUE', l_rec_old.role_name);
1923: fnd_message.set_token ('NAME', l_rec_old.comp_plan_name);
1924: l_note_msg := fnd_message.get;
1925: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1926: /*
1927: jtf_notes_pub.create_note
1928: (p_api_version => 1.0,
1929: x_return_status => x_return_status,

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

1941: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_CRE');
1942: fnd_message.set_token ('NEWVALUE', l_rec_new.role_name);
1943: fnd_message.set_token ('NAME', l_rec_new.comp_plan_name);
1944: l_note_msg := fnd_message.get;
1945: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1946: /*
1947: jtf_notes_pub.create_note
1948: (p_api_version => 1.0,
1949: x_return_status => x_return_status,

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

1965: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');
1966: fnd_message.set_token ('NEWVALUE', l_rec_old.role_name);
1967: fnd_message.set_token ('NAME', l_rec_old.comp_plan_name);
1968: l_note_msg := fnd_message.get;
1969: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1970: /*
1971: jtf_notes_pub.create_note
1972: (p_api_version => 1.0,
1973: x_return_status => x_return_status,

Line 1989: l_consolidated_note_new := l_consolidated_note_new || l_note_msg || fnd_global.local_chr(10);

1985: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_CRE');
1986: fnd_message.set_token ('NEWVALUE', l_rec_new.role_name);
1987: fnd_message.set_token ('NAME', l_rec_new.comp_plan_name);
1988: l_note_msg := fnd_message.get;
1989: l_consolidated_note_new := l_consolidated_note_new || l_note_msg || fnd_global.local_chr(10);
1990: /*
1991: jtf_notes_pub.create_note
1992: (p_api_version => 1.0,
1993: x_return_status => x_return_status,

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

2008: fnd_message.set_token ('OLDVALUE', l_rec_old.start_date);
2009: fnd_message.set_token ('NEWVALUE', l_rec_new.start_date);
2010: fnd_message.set_token ('NAME', l_rec_new.role_name);
2011: l_note_msg := fnd_message.get;
2012: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2013: /*
2014: jtf_notes_pub.create_note
2015: (p_api_version => 1.0,
2016: x_return_status => x_return_status,

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

2032: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_NULL_UPD');
2033: fnd_message.set_token ('NEWVALUE', l_rec_new.end_date);
2034: fnd_message.set_token ('NAME', l_rec_new.role_name);
2035: l_note_msg := fnd_message.get;
2036: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2037: /*
2038: jtf_notes_pub.create_note
2039: (p_api_version => 1.0,
2040: x_return_status => x_return_status,

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

2054: --Notes for removing end date for RolePlan assignment
2055: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_UPD_NULL');
2056: fnd_message.set_token ('NAME', l_rec_new.role_name);
2057: l_note_msg := fnd_message.get;
2058: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2059: /*
2060: jtf_notes_pub.create_note
2061: (p_api_version => 1.0,
2062: x_return_status => x_return_status,

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

2078: fnd_message.set_token ('OLDVALUE', l_rec_old.end_date);
2079: fnd_message.set_token ('NEWVALUE', l_rec_new.end_date);
2080: fnd_message.set_token ('NAME', l_rec_new.role_name);
2081: l_note_msg := fnd_message.get;
2082: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
2083: /*
2084: jtf_notes_pub.create_note
2085: (p_api_version => 1.0,
2086: x_return_status => x_return_status,