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 CN_COMP_PLANS

Line 101: -- Desc : check if the comp_plan_name exists in cn_comp_plans

97: END valid_role_name;
98:
99: -- ----------------------------------------------------------------------------*
100: -- Function : valid_comp_plan_name
101: -- Desc : check if the comp_plan_name exists in cn_comp_plans
102: -- ---------------------------------------------------------------------------*
103: FUNCTION valid_comp_plan_name (
104: p_comp_plan_name cn_comp_plans.NAME%TYPE,
105: p_org_id cn_comp_plans.org_id%TYPE

Line 104: p_comp_plan_name cn_comp_plans.NAME%TYPE,

100: -- Function : valid_comp_plan_name
101: -- Desc : check if the comp_plan_name exists in cn_comp_plans
102: -- ---------------------------------------------------------------------------*
103: FUNCTION valid_comp_plan_name (
104: p_comp_plan_name cn_comp_plans.NAME%TYPE,
105: p_org_id cn_comp_plans.org_id%TYPE
106: )
107: RETURN BOOLEAN
108: IS

Line 105: p_org_id cn_comp_plans.org_id%TYPE

101: -- Desc : check if the comp_plan_name exists in cn_comp_plans
102: -- ---------------------------------------------------------------------------*
103: FUNCTION valid_comp_plan_name (
104: p_comp_plan_name cn_comp_plans.NAME%TYPE,
105: p_org_id cn_comp_plans.org_id%TYPE
106: )
107: RETURN BOOLEAN
108: IS
109: CURSOR l_cur (

Line 110: l_comp_plan_name cn_comp_plans.NAME%TYPE,

106: )
107: RETURN BOOLEAN
108: IS
109: CURSOR l_cur (
110: l_comp_plan_name cn_comp_plans.NAME%TYPE,
111: l_org_id cn_comp_plans.org_id%TYPE
112: )
113: IS
114: SELECT *

Line 111: l_org_id cn_comp_plans.org_id%TYPE

107: RETURN BOOLEAN
108: IS
109: CURSOR l_cur (
110: l_comp_plan_name cn_comp_plans.NAME%TYPE,
111: l_org_id cn_comp_plans.org_id%TYPE
112: )
113: IS
114: SELECT *
115: FROM cn_comp_plans

Line 115: FROM cn_comp_plans

111: l_org_id cn_comp_plans.org_id%TYPE
112: )
113: IS
114: SELECT *
115: FROM cn_comp_plans
116: WHERE NAME = l_comp_plan_name AND org_id = l_org_id;
117:
118: l_rec l_cur%ROWTYPE;
119: BEGIN

Line 215: x_comp_plan_id OUT NOCOPY cn_comp_plans.comp_plan_id%TYPE,

211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2,
213: p_role_plan_rec IN role_plan_rec_type,
214: x_role_id OUT NOCOPY cn_roles.role_id%TYPE,
215: x_comp_plan_id OUT NOCOPY cn_comp_plans.comp_plan_id%TYPE,
216: p_loading_status IN VARCHAR2,
217: x_loading_status OUT NOCOPY VARCHAR2
218: )
219: IS

Line 234: l_comp_plan_name cn_comp_plans.NAME%TYPE,

230: WHERE role_id = l_role_id AND org_id = l_org_id;
231:
232: -- CHANTHON: Added the ORG_ID as a param
233: CURSOR l_cp_cur (
234: l_comp_plan_name cn_comp_plans.NAME%TYPE,
235: l_org_id cn_comp_plans.org_id%TYPE
236: )
237: IS
238: SELECT start_date, end_date

Line 235: l_org_id cn_comp_plans.org_id%TYPE

231:
232: -- CHANTHON: Added the ORG_ID as a param
233: CURSOR l_cp_cur (
234: l_comp_plan_name cn_comp_plans.NAME%TYPE,
235: l_org_id cn_comp_plans.org_id%TYPE
236: )
237: IS
238: SELECT start_date, end_date
239: FROM cn_comp_plans

Line 239: FROM cn_comp_plans

235: l_org_id cn_comp_plans.org_id%TYPE
236: )
237: IS
238: SELECT start_date, end_date
239: FROM cn_comp_plans
240: WHERE NAME = l_comp_plan_name AND org_id = l_org_id;
241:
242: l_cp_rec l_cp_cur%ROWTYPE;
243: BEGIN

Line 309: -- comp_plan_name must exist in cn_comp_plans

305: -- CHANTHON: ORG_ID need not be passed here
306: x_role_id := cn_api.get_role_id (p_role_plan_rec.role_name);
307: END IF;
308:
309: -- comp_plan_name must exist in cn_comp_plans
310: IF NOT valid_comp_plan_name (p_role_plan_rec.comp_plan_name,
311: p_role_plan_rec.org_id
312: )
313: THEN

Line 466: x_comp_plan_id OUT NOCOPY cn_comp_plans.comp_plan_id%TYPE,

462: p_role_plan_rec_old IN role_plan_rec_type,
463: p_role_plan_rec_new IN role_plan_rec_type,
464: x_role_plan_id_old OUT NOCOPY cn_role_plans.role_plan_id%TYPE,
465: x_role_id OUT NOCOPY cn_roles.role_id%TYPE,
466: x_comp_plan_id OUT NOCOPY cn_comp_plans.comp_plan_id%TYPE,
467: x_date_update_only OUT NOCOPY VARCHAR2,
468: p_loading_status IN VARCHAR2,
469: x_loading_status OUT NOCOPY VARCHAR2
470: )

Line 501: CURSOR l_cp_cur (l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE)

497:
498: l_old_rec l_old_cur%ROWTYPE;
499:
500: -- CHANTHON: Id based so ORG_ID not required
501: CURSOR l_cp_cur (l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE)
502: IS
503: SELECT start_date, end_date
504: FROM cn_comp_plans
505: WHERE comp_plan_id = l_comp_plan_id;

Line 504: FROM cn_comp_plans

500: -- CHANTHON: Id based so ORG_ID not required
501: CURSOR l_cp_cur (l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE)
502: IS
503: SELECT start_date, end_date
504: FROM cn_comp_plans
505: WHERE comp_plan_id = l_comp_plan_id;
506:
507: l_cp_rec l_cp_cur%ROWTYPE;
508: BEGIN

Line 709: -- new comp_plan_name must exist in cn_comp_plans

705: END IF;
706: END IF;
707:
708: -- if new comp_plan_name is not missing then
709: -- new comp_plan_name must exist in cn_comp_plans
710: IF (p_role_plan_rec_new.comp_plan_name <> fnd_api.g_miss_char)
711: THEN
712: x_comp_plan_id :=
713: cn_api.get_cp_id (p_role_plan_rec_new.comp_plan_name,

Line 1261: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;

1257: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Role_Plan';
1258: l_api_version CONSTANT NUMBER := 1.0;
1259: l_role_plan_id cn_role_plans.role_plan_id%TYPE;
1260: l_role_id cn_roles.role_id%TYPE;
1261: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
1262: l_object_version_number cn_role_plans.object_version_number%TYPE := 1;
1263: -- Declaration for user hooks
1264: l_rec role_plan_rec_type;
1265: l_oai_array jtf_usr_hks.oai_data_array_type;

Line 1455: p_source_object_code => 'CN_COMP_PLANS',

1451: x_return_status => x_return_status,
1452: x_msg_count => x_msg_count,
1453: x_msg_data => x_msg_data,
1454: p_source_object_id => l_rec.comp_plan_id,
1455: p_source_object_code => 'CN_COMP_PLANS',
1456: p_notes => l_note_msg,
1457: p_notes_detail => l_note_msg,
1458: p_note_type => 'CN_SYSGEN', -- for system generated
1459: x_jtf_note_id => l_note_id -- returned

Line 1671: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;

1667: l_api_name CONSTANT VARCHAR2 (30) := 'Update_Role_Plan';
1668: l_api_version CONSTANT NUMBER := 1.0;
1669: l_role_plan_id_old cn_role_plans.role_plan_id%TYPE;
1670: l_role_id cn_roles.role_id%TYPE;
1671: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
1672: l_date_update_only VARCHAR2 (1);
1673: -- Declaration for user hooks
1674: l_rec_old role_plan_rec_type;
1675: l_rec_new role_plan_rec_type;

Line 1933: p_source_object_code => 'CN_COMP_PLANS',

1929: x_return_status => x_return_status,
1930: x_msg_count => x_msg_count,
1931: x_msg_data => x_msg_data,
1932: p_source_object_id => l_rec_old.comp_plan_id,
1933: p_source_object_code => 'CN_COMP_PLANS',
1934: p_notes => l_note_msg,
1935: p_notes_detail => l_note_msg,
1936: p_note_type => 'CN_SYSGEN', -- for system generated
1937: x_jtf_note_id => l_note_id -- returned

Line 1953: p_source_object_code => 'CN_COMP_PLANS',

1949: x_return_status => x_return_status,
1950: x_msg_count => x_msg_count,
1951: x_msg_data => x_msg_data,
1952: p_source_object_id => l_rec_new.comp_plan_id,
1953: p_source_object_code => 'CN_COMP_PLANS',
1954: p_notes => l_note_msg,
1955: p_notes_detail => l_note_msg,
1956: p_note_type => 'CN_SYSGEN', -- for system generated
1957: x_jtf_note_id => l_note_id -- returned

Line 1977: p_source_object_code => 'CN_COMP_PLANS',

1973: x_return_status => x_return_status,
1974: x_msg_count => x_msg_count,
1975: x_msg_data => x_msg_data,
1976: p_source_object_id => l_rec_old.comp_plan_id,
1977: p_source_object_code => 'CN_COMP_PLANS',
1978: p_notes => l_note_msg,
1979: p_notes_detail => l_note_msg,
1980: p_note_type => 'CN_SYSGEN', -- for system generated
1981: x_jtf_note_id => l_note_id -- returned

Line 1997: p_source_object_code => 'CN_COMP_PLANS',

1993: x_return_status => x_return_status,
1994: x_msg_count => x_msg_count,
1995: x_msg_data => x_msg_data,
1996: p_source_object_id => l_rec_new.comp_plan_id,
1997: p_source_object_code => 'CN_COMP_PLANS',
1998: p_notes => l_note_msg,
1999: p_notes_detail => l_note_msg,
2000: p_note_type => 'CN_SYSGEN', -- for system generated
2001: x_jtf_note_id => l_note_id -- returned

Line 2020: p_source_object_code => 'CN_COMP_PLANS',

2016: x_return_status => x_return_status,
2017: x_msg_count => x_msg_count,
2018: x_msg_data => x_msg_data,
2019: p_source_object_id => l_rec_old.comp_plan_id,
2020: p_source_object_code => 'CN_COMP_PLANS',
2021: p_notes => l_note_msg,
2022: p_notes_detail => l_note_msg,
2023: p_note_type => 'CN_SYSGEN', -- for system generated
2024: x_jtf_note_id => l_note_id -- returned

Line 2044: p_source_object_code => 'CN_COMP_PLANS',

2040: x_return_status => x_return_status,
2041: x_msg_count => x_msg_count,
2042: x_msg_data => x_msg_data,
2043: p_source_object_id => l_rec_old.comp_plan_id,
2044: p_source_object_code => 'CN_COMP_PLANS',
2045: p_notes => l_note_msg,
2046: p_notes_detail => l_note_msg,
2047: p_note_type => 'CN_SYSGEN', -- for system generated
2048: x_jtf_note_id => l_note_id -- returned

Line 2066: p_source_object_code => 'CN_COMP_PLANS',

2062: x_return_status => x_return_status,
2063: x_msg_count => x_msg_count,
2064: x_msg_data => x_msg_data,
2065: p_source_object_id => l_rec_old.comp_plan_id,
2066: p_source_object_code => 'CN_COMP_PLANS',
2067: p_notes => l_note_msg,
2068: p_notes_detail => l_note_msg,
2069: p_note_type => 'CN_SYSGEN', -- for system generated
2070: x_jtf_note_id => l_note_id -- returned

Line 2090: p_source_object_code => 'CN_COMP_PLANS',

2086: x_return_status => x_return_status,
2087: x_msg_count => x_msg_count,
2088: x_msg_data => x_msg_data,
2089: p_source_object_id => l_rec_old.comp_plan_id,
2090: p_source_object_code => 'CN_COMP_PLANS',
2091: p_notes => l_note_msg,
2092: p_notes_detail => l_note_msg,
2093: p_note_type => 'CN_SYSGEN', -- for system generated
2094: x_jtf_note_id => l_note_id -- returned

Line 2110: p_source_object_code => 'CN_COMP_PLANS',

2106: x_return_status => x_return_status,
2107: x_msg_count => x_msg_count,
2108: x_msg_data => x_msg_data,
2109: p_source_object_id => l_rec_old.comp_plan_id,
2110: p_source_object_code => 'CN_COMP_PLANS',
2111: p_notes => l_consolidated_note,
2112: p_notes_detail => l_consolidated_note,
2113: p_note_type => 'CN_SYSGEN', -- for system generated
2114: x_jtf_note_id => l_note_id -- returned

Line 2124: p_source_object_code => 'CN_COMP_PLANS',

2120: x_return_status => x_return_status,
2121: x_msg_count => x_msg_count,
2122: x_msg_data => x_msg_data,
2123: p_source_object_id => l_rec_new.comp_plan_id,
2124: p_source_object_code => 'CN_COMP_PLANS',
2125: p_notes => l_consolidated_note_new,
2126: p_notes_detail => l_consolidated_note_new,
2127: p_note_type => 'CN_SYSGEN', -- for system generated
2128: x_jtf_note_id => l_note_id -- returned

Line 2542: p_source_object_code => 'CN_COMP_PLANS',

2538: x_return_status => x_return_status,
2539: x_msg_count => x_msg_count,
2540: x_msg_data => x_msg_data,
2541: p_source_object_id => l_rec.comp_plan_id,
2542: p_source_object_code => 'CN_COMP_PLANS',
2543: p_notes => l_note_msg,
2544: p_notes_detail => l_note_msg,
2545: p_note_type => 'CN_SYSGEN', -- for system generated
2546: x_jtf_note_id => l_note_id -- returned