APPS.CN_SRP_PRD_QUOTA_PUB dependencies on CN_ROLES

Line 14: p_role_name IN CN_ROLES.NAME%TYPE,

10: p_commit IN VARCHAR2 := CN_API.G_FALSE,
11: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
12: p_salesrep_name IN CN_SALESREPS.NAME%TYPE,
13: p_employee_number IN CN_SALESREPS.EMPLOYEE_NUMBER%TYPE,
14: p_role_name IN CN_ROLES.NAME%TYPE,
15: p_cp_name IN CN_COMP_PLANS.NAME%TYPE,
16: p_srp_plan_start_date IN CN_SRP_PLAN_ASSIGNS.START_DATE%TYPE,
17: p_srp_plan_end_date IN CN_SRP_PLAN_ASSIGNS.END_DATE%TYPE,
18: p_pe_name IN CN_QUOTAS.NAME%TYPE,

Line 36: l_role_id CN_ROLES.role_id%TYPE;

32: l_api_version CONSTANT NUMBER := 1.0;
33:
34: l_quota_id CN_QUOTAS.quota_id%TYPE;
35: l_salesrep_id CN_SALESREPS.salesrep_id%TYPE;
36: l_role_id CN_ROLES.role_id%TYPE;
37: l_comp_plan_id CN_COMP_PLANS.comp_plan_id%TYPE;
38: l_srp_plan_assign_id CN_SRP_PLAN_ASSIGNS.srp_plan_assign_id%TYPE;
39: l_srp_quota_assign_id CN_SRP_quota_ASSIGNS.srp_quota_assign_id%TYPE;
40: l_customized_flag CN_SRP_quota_ASSIGNS.customized_flag%TYPE;

Line 87: from cn_roles

83: AND org_id = l_org_id;
84:
85: CURSOR l_role_id_cr (p_role_name VARCHAR2) IS
86: SELECT *
87: from cn_roles
88: where name = p_role_name;
89:
90: CURSOR l_comp_plan_id_cr (p_comp_plan_name VARCHAR2) IS
91: SELECT *

Line 143: f_role_id_rec CN_ROLES%ROWTYPE;

139:
140: f_quota_row_rec CN_QUOTAS%ROWTYPE;
141: f_quota_id_rec CN_QUOTAS%ROWTYPE;
142: f_salesrep_id_rec CN_SALESREPS%ROWTYPE;
143: f_role_id_rec CN_ROLES%ROWTYPE;
144: f_comp_plan_id_rec CN_COMP_PLANS%ROWTYPE;
145: f_srp_plan_assign_id_rec CN_SRP_PLAN_ASSIGNS%ROWTYPE;
146: f_srp_quota_assign_id_rec CN_SRP_QUOTA_ASSIGNS%ROWTYPE;
147: f_period_id_rec CN_PERIOD_STATUSES%ROWTYPE;