APPS.CN_SRP_PRD_QUOTA_PUB dependencies on CN_QUOTAS

Line 18: p_pe_name IN CN_QUOTAS.NAME%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,
19: p_target_amount IN CN_SRP_QUOTA_ASSIGNS.target%TYPE,
20: p_fixed_amount IN CN_SRP_QUOTA_ASSIGNS.payment_amount%TYPE,
21: p_performance_goal IN CN_SRP_QUOTA_ASSIGNS.performance_goal%TYPE,
22: p_even_distribute IN VARCHAR2,

Line 34: l_quota_id CN_QUOTAS.quota_id%TYPE;

30:
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;

Line 52: f_target_amount CN_QUOTAS.target%TYPE;

48: l_prd_count NUMBER;
49: l_upd_srp_quota_assign VARCHAR2(1);
50: l_commission_payed_ptd CN_SRP_PERIOD_QUOTAS.commission_payed_ptd%TYPE;
51:
52: f_target_amount CN_QUOTAS.target%TYPE;
53: f_fixed_amount CN_QUOTAS.payment_amount%TYPE;
54: f_performance_goal CN_QUOTAS.performance_goal%TYPE;
55:
56: G_LAST_UPDATE_DATE DATE := sysdate;

Line 53: f_fixed_amount CN_QUOTAS.payment_amount%TYPE;

49: l_upd_srp_quota_assign VARCHAR2(1);
50: l_commission_payed_ptd CN_SRP_PERIOD_QUOTAS.commission_payed_ptd%TYPE;
51:
52: f_target_amount CN_QUOTAS.target%TYPE;
53: f_fixed_amount CN_QUOTAS.payment_amount%TYPE;
54: f_performance_goal CN_QUOTAS.performance_goal%TYPE;
55:
56: G_LAST_UPDATE_DATE DATE := sysdate;
57: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

Line 54: f_performance_goal CN_QUOTAS.performance_goal%TYPE;

50: l_commission_payed_ptd CN_SRP_PERIOD_QUOTAS.commission_payed_ptd%TYPE;
51:
52: f_target_amount CN_QUOTAS.target%TYPE;
53: f_fixed_amount CN_QUOTAS.payment_amount%TYPE;
54: f_performance_goal CN_QUOTAS.performance_goal%TYPE;
55:
56: G_LAST_UPDATE_DATE DATE := sysdate;
57: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
58: G_CREATION_DATE DATE := sysdate;

Line 74: from cn_quotas

70: l_org_id NUMBER;
71:
72: CURSOR l_quota_id_cr (p_quota_name VARCHAR2) IS
73: SELECT *
74: from cn_quotas
75: where name = p_quota_name AND delete_flag = 'N';
76:
77: CURSOR l_salesrep_id_cr (p_salesrep_name VARCHAR2,
78: p_employee_number VARCHAR2) IS

Line 124: from cn_quotas

120: WHERE srp_quota_assign_id = p_srp_quota_assign_id;
121:
122: CURSOR f_quota_row(p_quota_id NUMBER) IS
123: SELECT *
124: from cn_quotas
125: where quota_id = p_quota_id AND delete_flag = 'N';
126:
127: CURSOR tbl_period_quota_info_cr(p_period_id NUMBER,
128: p_srp_quota_assign_id NUMBER) IS

Line 140: f_quota_row_rec CN_QUOTAS%ROWTYPE;

136: from cn_period_statuses
137: where period_name = p_period_name
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;

Line 141: f_quota_id_rec CN_QUOTAS%ROWTYPE;

137: where period_name = p_period_name
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;

Line 356: -- 2. If target_amount, fixed_amount and Performance Goal input is null, select from cn_quotas, else update cn_quotas

352: from cn_srp_quota_assigns
353: where srp_quota_assign_id = l_srp_quota_assign_id;
354:
355:
356: -- 2. If target_amount, fixed_amount and Performance Goal input is null, select from cn_quotas, else update cn_quotas
357: -- target_amount check and update
358:
359: l_upd_srp_quota_assign := 'N';
360: