APPS.CN_SRP_PRD_QUOTA_PUB dependencies on CN_SALESREPS

Line 12: p_salesrep_name IN CN_SALESREPS.NAME%TYPE,

8: ( p_api_version IN NUMBER := CN_API.G_MISS_NUM,
9: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
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,

Line 13: p_employee_number IN CN_SALESREPS.EMPLOYEE_NUMBER%TYPE,

9: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
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,

Line 35: l_salesrep_id CN_SALESREPS.salesrep_id%TYPE;

31: l_api_name CONSTANT VARCHAR2(30) := 'Distribute_Srp_Prd_Quota';
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;

Line 80: from cn_salesreps

76:
77: CURSOR l_salesrep_id_cr (p_salesrep_name VARCHAR2,
78: p_employee_number VARCHAR2) IS
79: SELECT *
80: from cn_salesreps
81: where name = p_salesrep_name
82: and employee_number = p_employee_number
83: AND org_id = l_org_id;
84:

Line 142: f_salesrep_id_rec CN_SALESREPS%ROWTYPE;

138: AND org_id = l_org_id;
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;