APPS.CN_SRP_PRD_QUOTA_PUB dependencies on CN_SRP_PERIOD_QUOTAS

Line 45: tbl_srp_period_quota_id CN_SRP_PERIOD_QUOTAS.srp_period_quota_id%TYPE;

41:
42: l_period_target_unit_code CN_SRP_quota_ASSIGNS.period_target_unit_code%TYPE;
43:
44: tbl_period_id CN_PERIOD_STATUSES.period_id%TYPE;
45: tbl_srp_period_quota_id CN_SRP_PERIOD_QUOTAS.srp_period_quota_id%TYPE;
46: tbl_quarter_num CN_SRP_PERIOD_QUOTAS_V.quarter_num%TYPE;
47: tbl_period_year CN_SRP_PERIOD_QUOTAS_V.period_year%TYPE;
48: l_prd_count NUMBER;
49: l_upd_srp_quota_assign VARCHAR2(1);

Line 46: tbl_quarter_num CN_SRP_PERIOD_QUOTAS_V.quarter_num%TYPE;

42: l_period_target_unit_code CN_SRP_quota_ASSIGNS.period_target_unit_code%TYPE;
43:
44: tbl_period_id CN_PERIOD_STATUSES.period_id%TYPE;
45: tbl_srp_period_quota_id CN_SRP_PERIOD_QUOTAS.srp_period_quota_id%TYPE;
46: tbl_quarter_num CN_SRP_PERIOD_QUOTAS_V.quarter_num%TYPE;
47: tbl_period_year CN_SRP_PERIOD_QUOTAS_V.period_year%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;

Line 47: tbl_period_year CN_SRP_PERIOD_QUOTAS_V.period_year%TYPE;

43:
44: tbl_period_id CN_PERIOD_STATUSES.period_id%TYPE;
45: tbl_srp_period_quota_id CN_SRP_PERIOD_QUOTAS.srp_period_quota_id%TYPE;
46: tbl_quarter_num CN_SRP_PERIOD_QUOTAS_V.quarter_num%TYPE;
47: tbl_period_year CN_SRP_PERIOD_QUOTAS_V.period_year%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:

Line 50: l_commission_payed_ptd CN_SRP_PERIOD_QUOTAS.commission_payed_ptd%TYPE;

46: tbl_quarter_num CN_SRP_PERIOD_QUOTAS_V.quarter_num%TYPE;
47: tbl_period_year CN_SRP_PERIOD_QUOTAS_V.period_year%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;

Line 119: FROM cn_srp_period_quotas_v

115: and quota_id = p_quota_id;
116:
117: CURSOR l_srp_prd_quota_cr(p_srp_quota_assign_id NUMBER) IS
118: SELECT *
119: FROM cn_srp_period_quotas_v
120: WHERE srp_quota_assign_id = p_srp_quota_assign_id;
121:
122: CURSOR f_quota_row(p_quota_id NUMBER) IS
123: SELECT *

Line 130: from cn_srp_period_quotas_v

126:
127: CURSOR tbl_period_quota_info_cr(p_period_id NUMBER,
128: p_srp_quota_assign_id NUMBER) IS
129: select *
130: from cn_srp_period_quotas_v
131: where srp_quota_assign_id = p_srp_quota_assign_id
132: and period_id = p_period_id;
133:
134: CURSOR l_period_id_cr(p_period_name VARCHAR2) IS

Line 148: f_period_quota_info_rec cn_srp_period_quotas_v%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;
148: f_period_quota_info_rec cn_srp_period_quotas_v%ROWTYPE;
149:
150:
151:
152: BEGIN

Line 453: CN_SRP_PERIOD_QUOTAS_PKG.Distribute_Target

449:
450: -- Modified to call the Distribute_Target API to distribute target, 2527429
451:
452: -- CN_SRP_PRD_QUOTA_PVT.distribute_target
453: CN_SRP_PERIOD_QUOTAS_PKG.Distribute_Target
454: ( x_srp_quota_assign_id => l_srp_quota_assign_id,
455: x_target => 0,
456: x_period_target_unit_code => NULL);
457:

Line 511: from cn_srp_period_quotas

507: tbl_period_year := f_period_quota_info_rec.period_year;
508:
509: select commission_payed_ptd
510: into l_commission_payed_ptd
511: from cn_srp_period_quotas
512: where srp_period_quota_id = tbl_srp_period_quota_id;
513:
514: CN_SRP_PERIOD_QUOTAS_PKG.Begin_Record
515: (x_operation => 'UPDATE'

Line 514: CN_SRP_PERIOD_QUOTAS_PKG.Begin_Record

510: into l_commission_payed_ptd
511: from cn_srp_period_quotas
512: where srp_period_quota_id = tbl_srp_period_quota_id;
513:
514: CN_SRP_PERIOD_QUOTAS_PKG.Begin_Record
515: (x_operation => 'UPDATE'
516: ,x_period_target_unit_code => f_srp_quota_assign_id_rec.period_target_unit_code
517: ,x_srp_period_quota_id => tbl_srp_period_quota_id
518: ,x_srp_quota_assign_id => l_srp_quota_assign_id