APPS.CN_PRD_QUOTA_PUB dependencies on CN_PERIOD_QUOTAS

Line 30: FROM cn_period_quotas spq,

26: spq.period_id,
27: spq.quota_id,
28: spq.quarter_num,
29: spq.period_year
30: FROM cn_period_quotas spq,
31: cn_acc_period_statuses_v cp,
32: cn_cal_per_int_types cpit,
33: cn_quotas cq
34: WHERE spq.quota_id = p_quota_id

Line 52: FROM cn_period_quotas spq,

48: IS
49: SELECT COUNT (spq.period_quota_id) interval_count,
50: cpit.interval_number interval_number,
51: spq.period_year period_year
52: FROM cn_period_quotas spq,
53: cn_acc_period_statuses_v cp,
54: cn_cal_per_int_types cpit,
55: cn_quotas cq
56: WHERE spq.quota_id = p_quota_id

Line 151: cn_period_quotas_pkg.begin_record (x_operation => 'UPDATE',

147: performance_goal_ptd = round(nvl(l_period_performance_goal,0), g_ext_precision),
148: performance_goal_itd = round(nvl(l_running_performance_goal,0),g_ext_precision)
149: WHERE srp_period_quota_id = pq_rec.period_quota_id
150: ;*/
151: cn_period_quotas_pkg.begin_record (x_operation => 'UPDATE',
152: x_period_quota_id => pq_rec.period_quota_id,
153: x_period_id => pq_rec.period_id,
154: x_quota_id => pq_rec.quota_id,
155: x_period_target => NVL (l_period_target, 0),

Line 231: tbl_period_quota_id CN_PERIOD_QUOTAS.period_quota_id%TYPE;

227: l_quota_id CN_QUOTAS.quota_id%TYPE;
228:
229: tbl_period_id CN_PERIOD_STATUSES.period_id%TYPE;
230:
231: tbl_period_quota_id CN_PERIOD_QUOTAS.period_quota_id%TYPE;
232:
233: tbl_quarter_num CN_PERIOD_QUOTAS.quarter_num%TYPE;
234:
235: tbl_period_year CN_PERIOD_QUOTAS.period_year%TYPE;

Line 233: tbl_quarter_num CN_PERIOD_QUOTAS.quarter_num%TYPE;

229: tbl_period_id CN_PERIOD_STATUSES.period_id%TYPE;
230:
231: tbl_period_quota_id CN_PERIOD_QUOTAS.period_quota_id%TYPE;
232:
233: tbl_quarter_num CN_PERIOD_QUOTAS.quarter_num%TYPE;
234:
235: tbl_period_year CN_PERIOD_QUOTAS.period_year%TYPE;
236:
237: l_prd_count NUMBER;

Line 235: tbl_period_year CN_PERIOD_QUOTAS.period_year%TYPE;

231: tbl_period_quota_id CN_PERIOD_QUOTAS.period_quota_id%TYPE;
232:
233: tbl_quarter_num CN_PERIOD_QUOTAS.quarter_num%TYPE;
234:
235: tbl_period_year CN_PERIOD_QUOTAS.period_year%TYPE;
236:
237: l_prd_count NUMBER;
238:
239: f_target_amount CN_QUOTAS.target%TYPE;

Line 263: FROM cn_period_quotas

259: AND org_id = l_org_id;
260:
261: CURSOR l_prd_quota_cr(p_quota_id NUMBER) IS
262: SELECT period_quota_id, quarter_num, period_year, period_id, itd_target, itd_payment, performance_goal_itd
263: FROM cn_period_quotas
264: WHERE quota_id = p_quota_id;
265:
266:
267: CURSOR f_quota_row(p_quota_id NUMBER) IS

Line 280: from cn_period_quotas

276: and org_id = l_org_id;
277:
278: CURSOR tbl_period_quota_info_cr(p_period_id NUMBER, p_quota_id NUMBER) IS
279: select *
280: from cn_period_quotas
281: where quota_id = p_quota_id
282: and period_id = p_period_id;
283:
284: f_quota_row_rec CN_QUOTAS%ROWTYPE;

Line 287: f_period_quota_info_rec CN_PERIOD_QUOTAS%ROWTYPE;

283:
284: f_quota_row_rec CN_QUOTAS%ROWTYPE;
285: f_quota_id_rec CN_QUOTAS%ROWTYPE;
286: f_period_id_rec CN_PERIOD_STATUSES%ROWTYPE;
287: f_period_quota_info_rec CN_PERIOD_QUOTAS%ROWTYPE;
288:
289:
290: BEGIN
291: -- Standard Start of API savepoint

Line 647: -- 4. IF not evenly distributed, we update the cn_period_quotas using the values in the table.

643: x_msg_count => x_msg_count,
644: x_msg_data => x_msg_data);
645:
646:
647: -- 4. IF not evenly distributed, we update the cn_period_quotas using the values in the table.
648: ELSE --IF p_even_distribute = 'Y' THEN
649:
650: IF p_prd_quota_tbl.COUNT > 0 THEN
651:

Line 703: CN_PERIOD_QUOTAS_PKG.Begin_Record(

699:
700:
701:
702:
703: CN_PERIOD_QUOTAS_PKG.Begin_Record(
704: x_operation => 'UPDATE',
705: X_period_quota_id => tbl_period_quota_id,
706: x_period_id => tbl_period_id,
707: x_quota_id => l_quota_id,