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_SRP_PRD_QUOTA_PUB dependencies on CN_SRP_QUOTA_ASSIGNS

Line 19: p_target_amount IN CN_SRP_QUOTA_ASSIGNS.target%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,
23: p_srp_prd_quota_tbl IN srp_prd_quota_tbl_type,

Line 20: p_fixed_amount IN CN_SRP_QUOTA_ASSIGNS.payment_amount%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,
23: p_srp_prd_quota_tbl IN srp_prd_quota_tbl_type,
24: p_org_id IN NUMBER,

Line 21: p_performance_goal IN CN_SRP_QUOTA_ASSIGNS.performance_goal%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,
23: p_srp_prd_quota_tbl IN srp_prd_quota_tbl_type,
24: p_org_id IN NUMBER,
25: x_return_status OUT NOCOPY VARCHAR2,

Line 39: l_srp_quota_assign_id CN_SRP_quota_ASSIGNS.srp_quota_assign_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;
40: l_customized_flag CN_SRP_quota_ASSIGNS.customized_flag%TYPE;
41:
42: l_period_target_unit_code CN_SRP_quota_ASSIGNS.period_target_unit_code%TYPE;
43:

Line 40: l_customized_flag CN_SRP_quota_ASSIGNS.customized_flag%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;
40: l_customized_flag CN_SRP_quota_ASSIGNS.customized_flag%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;

Line 42: l_period_target_unit_code CN_SRP_quota_ASSIGNS.period_target_unit_code%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;
40: l_customized_flag CN_SRP_quota_ASSIGNS.customized_flag%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;

Line 113: from cn_srp_quota_assigns

109:
110: CURSOR l_srp_quota_assign_id_cr (p_srp_plan_assign_id NUMBER,
111: p_quota_id NUMBER) IS
112: SELECT *
113: from cn_srp_quota_assigns
114: where srp_plan_assign_id = p_srp_plan_assign_id
115: and quota_id = p_quota_id;
116:
117: CURSOR l_srp_prd_quota_cr(p_srp_quota_assign_id NUMBER) IS

Line 146: f_srp_quota_assign_id_rec CN_SRP_QUOTA_ASSIGNS%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;
147: f_period_id_rec CN_PERIOD_STATUSES%ROWTYPE;
148: f_period_quota_info_rec cn_srp_period_quotas_v%ROWTYPE;
149:
150:

Line 352: from cn_srp_quota_assigns

348: END IF;
349:
350: select nvl(target, 0)
351: into f_target_amount
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

Line 365: from cn_srp_quota_assigns

361: IF p_target_amount is NULL THEN
362:
363: select nvl(target, 0)
364: into f_target_amount
365: from cn_srp_quota_assigns
366: where srp_quota_assign_id = l_srp_quota_assign_id;
367:
368: ELSE
369: IF p_target_amount <> f_target_amount THEN

Line 380: from cn_srp_quota_assigns

376: END IF;
377:
378: select nvl(payment_amount, 0)
379: into f_fixed_amount
380: from cn_srp_quota_assigns
381: where srp_quota_assign_id = l_srp_quota_assign_id;
382:
383: -- fixed Amount check and update
384: IF p_fixed_amount is NULL THEN

Line 388: from cn_srp_quota_assigns

384: IF p_fixed_amount is NULL THEN
385:
386: select nvl(payment_amount, 0)
387: into f_fixed_amount
388: from cn_srp_quota_assigns
389: where srp_quota_assign_id = l_srp_quota_assign_id;
390:
391: ELSE
392:

Line 403: from cn_srp_quota_assigns

399: END IF;
400:
401: select nvl(performance_goal, 0)
402: into f_performance_goal
403: from cn_srp_quota_assigns
404: where srp_quota_assign_id = l_srp_quota_assign_id;
405:
406: -- performance goal check and update
407:

Line 412: from cn_srp_quota_assigns

408: IF p_performance_goal is NULL THEN
409:
410: select nvl(performance_goal, 0)
411: into f_performance_goal
412: from cn_srp_quota_assigns
413: where srp_quota_assign_id = l_srp_quota_assign_id;
414:
415: ELSE
416: IF p_performance_goal <> nvl(f_performance_goal,0) THEN