eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PRD_QUOTA_PUB dependencies on CN_QUOTAS

Line 33: cn_quotas cq

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
35: AND spq.quota_id = cq.quota_id
36: AND spq.period_id = cp.period_id
37: AND cp.period_id = cpit.cal_period_id

Line 55: cn_quotas cq

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
57: AND spq.quota_id = cq.quota_id
58: AND spq.period_id = cp.period_id
59: AND cp.period_id = cpit.cal_period_id

Line 112: FROM cn_quotas q

108: l_performance_goal
109: --,l_dist_rule_code
110: ,
111: l_period_type_code
112: FROM cn_quotas q
113: WHERE q.quota_id = p_quota_id
114: --AND qa.period_target_dist_rule_code <> 'USER_DEFINED'
115: ;
116:

Line 211: p_pe_name IN CN_QUOTAS.NAME%TYPE,

207: ( p_api_version IN NUMBER := CN_API.G_MISS_NUM,
208: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
209: p_commit IN VARCHAR2 := CN_API.G_FALSE,
210: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
211: p_pe_name IN CN_QUOTAS.NAME%TYPE,
212: p_target_amount IN CN_QUOTAS.target%TYPE,
213: p_fixed_amount IN CN_QUOTAS.payment_amount%TYPE,
214: p_performance_goal IN CN_QUOTAS.performance_goal%TYPE,
215: p_even_distribute IN VARCHAR2,

Line 212: p_target_amount IN CN_QUOTAS.target%TYPE,

208: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
209: p_commit IN VARCHAR2 := CN_API.G_FALSE,
210: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
211: p_pe_name IN CN_QUOTAS.NAME%TYPE,
212: p_target_amount IN CN_QUOTAS.target%TYPE,
213: p_fixed_amount IN CN_QUOTAS.payment_amount%TYPE,
214: p_performance_goal IN CN_QUOTAS.performance_goal%TYPE,
215: p_even_distribute IN VARCHAR2,
216: p_prd_quota_tbl IN prd_quota_tbl_type,

Line 213: p_fixed_amount IN CN_QUOTAS.payment_amount%TYPE,

209: p_commit IN VARCHAR2 := CN_API.G_FALSE,
210: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
211: p_pe_name IN CN_QUOTAS.NAME%TYPE,
212: p_target_amount IN CN_QUOTAS.target%TYPE,
213: p_fixed_amount IN CN_QUOTAS.payment_amount%TYPE,
214: p_performance_goal IN CN_QUOTAS.performance_goal%TYPE,
215: p_even_distribute IN VARCHAR2,
216: p_prd_quota_tbl IN prd_quota_tbl_type,
217: p_org_id IN NUMBER,

Line 214: p_performance_goal IN CN_QUOTAS.performance_goal%TYPE,

210: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
211: p_pe_name IN CN_QUOTAS.NAME%TYPE,
212: p_target_amount IN CN_QUOTAS.target%TYPE,
213: p_fixed_amount IN CN_QUOTAS.payment_amount%TYPE,
214: p_performance_goal IN CN_QUOTAS.performance_goal%TYPE,
215: p_even_distribute IN VARCHAR2,
216: p_prd_quota_tbl IN prd_quota_tbl_type,
217: p_org_id IN NUMBER,
218: x_return_status OUT NOCOPY VARCHAR2,

Line 227: l_quota_id CN_QUOTAS.quota_id%TYPE;

223:
224: l_api_name CONSTANT VARCHAR2(30) := 'Distribute_Prd_Quota';
225: l_api_version CONSTANT NUMBER := 1.0;
226:
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;

Line 239: f_target_amount CN_QUOTAS.target%TYPE;

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;
240: f_fixed_amount CN_QUOTAS.payment_amount%TYPE;
241: f_performance_goal CN_QUOTAS.performance_goal%TYPE;
242:
243: G_LAST_UPDATE_DATE DATE := sysdate;

Line 240: f_fixed_amount CN_QUOTAS.payment_amount%TYPE;

236:
237: l_prd_count NUMBER;
238:
239: f_target_amount CN_QUOTAS.target%TYPE;
240: f_fixed_amount CN_QUOTAS.payment_amount%TYPE;
241: f_performance_goal CN_QUOTAS.performance_goal%TYPE;
242:
243: G_LAST_UPDATE_DATE DATE := sysdate;
244: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

Line 241: f_performance_goal CN_QUOTAS.performance_goal%TYPE;

237: l_prd_count NUMBER;
238:
239: f_target_amount CN_QUOTAS.target%TYPE;
240: f_fixed_amount CN_QUOTAS.payment_amount%TYPE;
241: f_performance_goal CN_QUOTAS.performance_goal%TYPE;
242:
243: G_LAST_UPDATE_DATE DATE := sysdate;
244: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
245: G_CREATION_DATE DATE := sysdate;

Line 257: from cn_quotas

253: l_status VARCHAR2(1);
254:
255: CURSOR l_quota_id_cr (p_quota_name VARCHAR2) IS
256: SELECT *
257: from cn_quotas
258: where name = p_quota_name
259: AND org_id = l_org_id;
260:
261: CURSOR l_prd_quota_cr(p_quota_id NUMBER) IS

Line 269: from cn_quotas

265:
266:
267: CURSOR f_quota_row(p_quota_id NUMBER) IS
268: SELECT *
269: from cn_quotas
270: where quota_id = p_quota_id;
271:
272: CURSOR l_period_id_cr(p_period_name VARCHAR2) IS
273: select *

Line 284: f_quota_row_rec CN_QUOTAS%ROWTYPE;

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

Line 285: f_quota_id_rec CN_QUOTAS%ROWTYPE;

281: where quota_id = p_quota_id
282: and period_id = p_period_id;
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:

Line 358: from cn_quotas

354:
355:
356: select nvl(target, 0)
357: into f_target_amount
358: from cn_quotas
359: where quota_id = l_quota_id;
360:
361:
362: -- 2. If target_amount, fixed_amount and Performance Goal input is null, select from cn_quotas, else update cn_quotas

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

358: from cn_quotas
359: where quota_id = l_quota_id;
360:
361:
362: -- 2. If target_amount, fixed_amount and Performance Goal input is null, select from cn_quotas, else update cn_quotas
363: -- target_amount check and update
364: IF p_target_amount is NULL THEN
365:
366:

Line 369: from cn_quotas

365:
366:
367: select nvl(target, 0)
368: into f_target_amount
369: from cn_quotas
370: where quota_id = l_quota_id;
371:
372: ELSE
373:

Line 386: cn_quotas_pkg.begin_record

382: FETCH f_quota_row INTO f_quota_row_rec;
383: CLOSE f_quota_row;
384:
385:
386: cn_quotas_pkg.begin_record
387: (
388: x_operation => 'UPDATE'
389: ,x_rowid => G_ROWID
390: ,x_quota_id => f_quota_row_rec.quota_id

Line 452: from cn_quotas

448:
449:
450: select nvl(payment_amount, 0)
451: into f_fixed_amount
452: from cn_quotas
453: where quota_id = l_quota_id;
454:
455: -- fixed Amount check and update
456: IF p_fixed_amount is NULL THEN

Line 461: from cn_quotas

457:
458:
459: select nvl(payment_amount, 0)
460: into f_fixed_amount
461: from cn_quotas
462: where quota_id = l_quota_id;
463:
464: ELSE
465:

Line 479: cn_quotas_pkg.begin_record

475: OPEN f_quota_row(l_quota_id);
476: FETCH f_quota_row INTO f_quota_row_rec;
477: CLOSE f_quota_row;
478:
479: cn_quotas_pkg.begin_record
480: (
481: x_operation => 'UPDATE'
482: ,x_rowid => G_ROWID
483: ,x_quota_id => f_quota_row_rec.quota_id

Line 547: from cn_quotas

543: -- performance goal check and update
544:
545: select nvl(performance_goal, 0)
546: into f_performance_goal
547: from cn_quotas
548: where quota_id = l_quota_id;
549:
550: IF p_performance_goal is NULL THEN
551:

Line 554: from cn_quotas

550: IF p_performance_goal is NULL THEN
551:
552: select nvl(performance_goal, 0)
553: into f_performance_goal
554: from cn_quotas
555: where quota_id = l_quota_id;
556:
557: ELSE
558: IF p_performance_goal <> nvl(f_performance_goal,0) THEN

Line 566: cn_quotas_pkg.begin_record

562: OPEN f_quota_row(l_quota_id);
563: FETCH f_quota_row INTO f_quota_row_rec;
564: CLOSE f_quota_row;
565:
566: cn_quotas_pkg.begin_record
567: (
568: x_operation => 'UPDATE'
569: ,x_rowid => G_ROWID
570: ,x_quota_id => f_quota_row_rec.quota_id