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_ROLES

Line 69: -- Desc : check if the role_name exists in cn_roles

65:
66:
67: -- ----------------------------------------------------------------------------*
68: -- Function : valid_role_name
69: -- Desc : check if the role_name exists in cn_roles
70: -- ---------------------------------------------------------------------------*
71: FUNCTION valid_role_name (p_role_name cn_roles.NAME%TYPE)
72: RETURN BOOLEAN
73: IS

Line 71: FUNCTION valid_role_name (p_role_name cn_roles.NAME%TYPE)

67: -- ----------------------------------------------------------------------------*
68: -- Function : valid_role_name
69: -- Desc : check if the role_name exists in cn_roles
70: -- ---------------------------------------------------------------------------*
71: FUNCTION valid_role_name (p_role_name cn_roles.NAME%TYPE)
72: RETURN BOOLEAN
73: IS
74: CURSOR l_cur (l_role_name cn_roles.NAME%TYPE)
75: IS

Line 74: CURSOR l_cur (l_role_name cn_roles.NAME%TYPE)

70: -- ---------------------------------------------------------------------------*
71: FUNCTION valid_role_name (p_role_name cn_roles.NAME%TYPE)
72: RETURN BOOLEAN
73: IS
74: CURSOR l_cur (l_role_name cn_roles.NAME%TYPE)
75: IS
76: SELECT *
77: FROM cn_roles
78: WHERE NAME = l_role_name;

Line 77: FROM cn_roles

73: IS
74: CURSOR l_cur (l_role_name cn_roles.NAME%TYPE)
75: IS
76: SELECT *
77: FROM cn_roles
78: WHERE NAME = l_role_name;
79:
80: l_rec l_cur%ROWTYPE;
81: BEGIN

Line 139: -- Desc : check if the role_plan_id exists in cn_roles

135: END valid_comp_plan_name;
136:
137: -- ----------------------------------------------------------------------------*
138: -- Function : valid_role_plan_id
139: -- Desc : check if the role_plan_id exists in cn_roles
140: -- ---------------------------------------------------------------------------*
141: FUNCTION valid_role_plan_id (
142: p_role_plan_id cn_role_plans.role_plan_id%TYPE
143: )

Line 214: x_role_id OUT NOCOPY cn_roles.role_id%TYPE,

210: x_return_status OUT NOCOPY VARCHAR2,
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: )

Line 224: l_role_id cn_roles.role_id%TYPE,

220: l_api_name CONSTANT VARCHAR2 (30) := 'check_valid_insert';
221:
222: -- CHANTHON: Added ORG_ID as a param
223: CURSOR l_cur (
224: l_role_id cn_roles.role_id%TYPE,
225: l_org_id cn_role_plans.org_id%TYPE
226: )
227: IS
228: SELECT start_date, end_date, comp_plan_id

Line 292: -- role_name must exist in cn_roles

288: THEN
289: RAISE fnd_api.g_exc_error;
290: END IF;
291:
292: -- role_name must exist in cn_roles
293: IF NOT valid_role_name (p_role_plan_rec.role_name)
294: THEN
295: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
296: THEN

Line 465: x_role_id OUT NOCOPY cn_roles.role_id%TYPE,

461: x_msg_data OUT NOCOPY VARCHAR2,
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

Line 661: -- if new role_name is not missing then new role_name must exist in cn_roles

657: x_loading_status := 'CN_RP_CREATED_IN_SFP';
658: RAISE fnd_api.g_exc_error;
659: END IF;
660:
661: -- if new role_name is not missing then new role_name must exist in cn_roles
662: IF (p_role_plan_rec_new.role_name <> fnd_api.g_miss_char)
663: THEN
664: x_role_id := cn_api.get_role_id (p_role_plan_rec_new.role_name);
665:

Line 988: p_role_id IN cn_roles.role_id%TYPE,

984: -- --------------------------------------------------------------------------*
985: -- Procedure: srp_plan_assignment_for_insert
986: -- --------------------------------------------------------------------------*
987: PROCEDURE srp_plan_assignment_for_insert (
988: p_role_id IN cn_roles.role_id%TYPE,
989: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
990: x_return_status OUT NOCOPY VARCHAR2,
991: p_loading_status IN VARCHAR2,
992: x_loading_status OUT NOCOPY VARCHAR2,

Line 1063: p_role_id IN cn_roles.role_id%TYPE,

1059: -- --------------------------------------------------------------------------*
1060: -- Procedure: srp_plan_assignment_for_update
1061: -- --------------------------------------------------------------------------*
1062: PROCEDURE srp_plan_assignment_for_update (
1063: p_role_id IN cn_roles.role_id%TYPE,
1064: p_role_id_old IN cn_roles.role_id%TYPE,
1065: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
1066: p_date_update_only IN VARCHAR2,
1067: x_return_status OUT NOCOPY VARCHAR2,

Line 1064: p_role_id_old IN cn_roles.role_id%TYPE,

1060: -- Procedure: srp_plan_assignment_for_update
1061: -- --------------------------------------------------------------------------*
1062: PROCEDURE srp_plan_assignment_for_update (
1063: p_role_id IN cn_roles.role_id%TYPE,
1064: p_role_id_old IN cn_roles.role_id%TYPE,
1065: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
1066: p_date_update_only IN VARCHAR2,
1067: x_return_status OUT NOCOPY VARCHAR2,
1068: p_loading_status IN VARCHAR2,

Line 1190: p_role_id IN cn_roles.role_id%TYPE,

1186: -- --------------------------------------------------------------------------*
1187: -- Procedure: srp_plan_assignment_for_delete
1188: -- --------------------------------------------------------------------------*
1189: PROCEDURE srp_plan_assignment_for_delete (
1190: p_role_id IN cn_roles.role_id%TYPE,
1191: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
1192: x_return_status OUT NOCOPY VARCHAR2,
1193: p_loading_status IN VARCHAR2,
1194: x_loading_status OUT NOCOPY VARCHAR2,

Line 1260: l_role_id cn_roles.role_id%TYPE;

1256: IS
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;

Line 1670: l_role_id cn_roles.role_id%TYPE;

1666: --p_role_plan_id should be NULL if passing p_role_plan_rec_old
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;

Line 2347: l_role_id cn_roles.role_id%TYPE;

2343: IS
2344: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Role_Plan';
2345: l_api_version CONSTANT NUMBER := 1.0;
2346: l_role_plan_id cn_role_plans.role_plan_id%TYPE;
2347: l_role_id cn_roles.role_id%TYPE;
2348: -- Declaration for user hooks
2349: l_rec role_plan_rec_type;
2350: l_oai_array jtf_usr_hks.oai_data_array_type;
2351: l_bind_data_id NUMBER;