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_PMT_PLANS_PVT dependencies on CN_ROLES

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

14: G_PROGRAM_TYPE VARCHAR2(30);
15:
16: -- ----------------------------------------------------------------------------*
17: -- Function : valid_role_name
18: -- Desc : check if the role_name exists in cn_roles
19: -- ---------------------------------------------------------------------------*
20: FUNCTION valid_role_name
21: (
22: p_role_name cn_roles.name%TYPE

Line 22: p_role_name cn_roles.name%TYPE

18: -- Desc : check if the role_name exists in cn_roles
19: -- ---------------------------------------------------------------------------*
20: FUNCTION valid_role_name
21: (
22: p_role_name cn_roles.name%TYPE
23: ) RETURN BOOLEAN IS
24:
25: CURSOR l_cur(l_role_name cn_roles.name%TYPE) IS
26: SELECT *

Line 25: CURSOR l_cur(l_role_name cn_roles.name%TYPE) IS

21: (
22: p_role_name cn_roles.name%TYPE
23: ) RETURN BOOLEAN IS
24:
25: CURSOR l_cur(l_role_name cn_roles.name%TYPE) IS
26: SELECT *
27: FROM cn_roles
28: WHERE name = l_role_name;
29:

Line 27: FROM cn_roles

23: ) RETURN BOOLEAN IS
24:
25: CURSOR l_cur(l_role_name cn_roles.name%TYPE) IS
26: SELECT *
27: FROM cn_roles
28: WHERE name = l_role_name;
29:
30: l_rec l_cur%ROWTYPE;
31:

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

112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_role_pmt_plan_rec IN role_pmt_plan_rec_type,
116: x_role_id OUT NOCOPY cn_roles.role_id%TYPE,
117: x_pmt_plan_id OUT NOCOPY cn_pmt_plans.pmt_plan_id%TYPE,
118: p_loading_status IN VARCHAR2,
119: x_loading_status OUT NOCOPY VARCHAR2
120: ) IS

Line 124: CURSOR l_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_pmt_plans.org_id%TYPE) IS

120: ) IS
121:
122: l_api_name CONSTANT VARCHAR2(30) := 'check_valid_insert';
123:
124: CURSOR l_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_pmt_plans.org_id%TYPE) IS
125: SELECT start_date, end_date, pmt_plan_id
126: FROM cn_role_pmt_plans
127: WHERE role_id = l_role_id
128: AND org_id = l_org_id;

Line 180: -- role_name must exist in cn_roles

176: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN
177: RAISE FND_API.G_EXC_ERROR ;
178: END IF;
179:
180: -- role_name must exist in cn_roles
181: IF NOT valid_role_name(p_role_pmt_plan_rec.role_name) THEN
182: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
183: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
184: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pmt_plan_rec.role_name);

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

356: x_msg_data OUT NOCOPY VARCHAR2,
357: p_role_pmt_plan_rec_old IN role_pmt_plan_rec_type,
358: p_role_pmt_plan_rec_new IN role_pmt_plan_rec_type,
359: x_role_pmt_plan_id_old OUT NOCOPY cn_role_pmt_plans.role_pmt_plan_id%TYPE,
360: x_role_id OUT NOCOPY cn_roles.role_id%TYPE,
361: x_pmt_plan_id OUT NOCOPY cn_pmt_plans.pmt_plan_id%TYPE,
362: x_date_update_only OUT NOCOPY VARCHAR2,
363: p_loading_status IN VARCHAR2,
364: x_loading_status OUT NOCOPY VARCHAR2

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

497: END IF;
498: CLOSE l_old_cur;
499: END IF;
500:
501: -- if new role_name is not missing then new role_name must exist in cn_roles
502: IF (p_role_pmt_plan_rec_new.role_name <> fnd_api.g_miss_char) THEN
503: x_role_id := cn_api.get_role_id(p_role_pmt_plan_rec_new.role_name);
504: IF (x_role_id IS NULL) THEN
505: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 796: (p_role_id IN cn_roles.role_id%TYPE,

792: -- --------------------------------------------------------------------------*
793: -- Procedure: srp_pmt_plan_asgn_for_insert
794: -- --------------------------------------------------------------------------*
795: PROCEDURE srp_pmt_plan_asgn_for_insert
796: (p_role_id IN cn_roles.role_id%TYPE,
797: p_role_pmt_plan_id IN cn_role_pmt_plans.role_pmt_plan_id%TYPE,
798: p_suppress_flag IN VARCHAR2 := 'N',
799: x_return_status OUT NOCOPY VARCHAR2,
800: p_loading_status IN VARCHAR2,

Line 905: p_role_id IN cn_roles.role_id%TYPE,

901: -- Procedure: srp_pmt_pmt_plan_asgn_for_update
902: -- --------------------------------------------------------------------------*
903: PROCEDURE srp_pmt_plan_asgn_for_update
904: (p_role_pmt_plan_id IN cn_role_pmt_plans.role_pmt_plan_id%TYPE,
905: p_role_id IN cn_roles.role_id%TYPE,
906: p_date_update_only IN VARCHAR2,
907: x_return_status OUT NOCOPY VARCHAR2,
908: p_loading_status IN VARCHAR2,
909: x_loading_status OUT NOCOPY VARCHAR2 ) IS

Line 979: (p_role_id IN cn_roles.role_id%TYPE,

975: -- --------------------------------------------------------------------------*
976: -- Procedure: srp_pmt_plan_asgn_for_delete
977: -- --------------------------------------------------------------------------*
978: PROCEDURE srp_pmt_plan_asgn_for_delete
979: (p_role_id IN cn_roles.role_id%TYPE,
980: p_role_pmt_plan_id IN cn_role_pmt_plans.role_pmt_plan_id%TYPE,
981: p_suppress_flag IN VARCHAR2 := 'N',
982: x_return_status OUT NOCOPY VARCHAR2,
983: p_loading_status IN VARCHAR2,

Line 1076: l_role_id cn_roles.role_id%TYPE;

1072:
1073: l_api_name CONSTANT VARCHAR2(30) := 'Create_Role_Pmt_Plan';
1074: l_api_version CONSTANT NUMBER := 1.0;
1075: l_role_pmt_plan_id cn_role_pmt_plans.role_pmt_plan_id%TYPE;
1076: l_role_id cn_roles.role_id%TYPE;
1077: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;
1078:
1079:
1080: -- Declaration for user hooks

Line 1255: l_role_id cn_roles.role_id%TYPE;

1251:
1252: l_api_name CONSTANT VARCHAR2(30) := 'Update_Role_Pmt_Plan';
1253: l_api_version CONSTANT NUMBER := 1.0;
1254: l_role_pmt_plan_id_old cn_role_pmt_plans.role_pmt_plan_id%TYPE;
1255: l_role_id cn_roles.role_id%TYPE;
1256: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;
1257: l_date_update_only VARCHAR2(1);
1258:
1259: -- Declaration for user hooks

Line 1442: l_role_id cn_roles.role_id%TYPE;

1438:
1439: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Role_Pmt_Plan';
1440: l_api_version CONSTANT NUMBER := 1.0;
1441: l_role_pmt_plan_id cn_role_pmt_plans.role_pmt_plan_id%TYPE;
1442: l_role_id cn_roles.role_id%TYPE;
1443:
1444: -- Declaration for user hooks
1445: l_rec role_pmt_plan_rec_type;
1446: l_OAI_array JTF_USR_HKS.oai_data_array_type;