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

Line 376: -- o calling Place 1.cn_srp_quota_assigns_pkg.insert record

372: -- start_period_id and end period_id
373: -- o Called once for each new srp plan assignment. x_srp_plan_assign_id
374: -- o Called one insert of new quota assignment x_srp_plan_assign_id,
375: -- quota_id
376: -- o calling Place 1.cn_srp_quota_assigns_pkg.insert record
377: ---------------------------------------------------------------------------+
378: -- PROCEDURE INSERT_RECORD
379: -- Description:
380: -- CASE 1: Quota period has changed like end date changed from NOT NULL to

Line 404: FROM cn_srp_quota_assigns_all qa ,

400: CURSOR ytd_flag
401: IS
402: SELECT q.quota_id quota_id,
403: q.org_id
404: FROM cn_srp_quota_assigns_all qa ,
405: cn_quotas_all q
406: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id
407: -- do not need itd and formula id anymore, bug 2462767,AND q.calc_formula_id = cf.calc_formula_id(+)
408: AND qa.quota_id = q.quota_id;

Line 466: -- case 1: callled from cn_srp_quota_assigns_pkg

462: l_resp_id := fnd_global.resp_id;
463: l_login_id := fnd_global.login_id;
464: IF x_srp_plan_assign_id IS NOT NULL AND x_quota_id IS NULL THEN
465: -- A new plan is assigned to a salesrep
466: -- case 1: callled from cn_srp_quota_assigns_pkg
467: FOR itd_p_rec IN ytd_flag
468: LOOP
469: -- enhancement, clku, 2431086,we do not check if the PE is ITD or not.
470: --IF (itd_p_rec.itd_flag = 'Y') THEN

Line 513: FROM cn_srp_quota_assigns_all qa ,

509: sysdate ,
510: l_user_id ,
511: l_login_id ,
512: qa.org_id
513: FROM cn_srp_quota_assigns_all qa ,
514: cn_period_quotas_all pq ,
515: cn_srp_plan_assigns_all pa ,
516: cn_period_statuses p
517: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id

Line 583: -- case 1: called from cn_srp_quota_assigns_pkg.

579: --added for bugfix#2874991 ends here
580: ELSIF (x_srp_plan_assign_id IS NOT NULL AND x_quota_id IS NOT NULL) THEN
581: -- A new quota has been assigned to a compensation plan
582: -- Check whether itd_flag for this quota is checked
583: -- case 1: called from cn_srp_quota_assigns_pkg.
584: -- enhancement, clku, 2431086, we do not check if the PE is ITD or not.
585: --IF x_itd_flag_checked = 'Y' THEN
586: INSERT
587: INTO cn_srp_period_quotas_all

Line 628: FROM cn_srp_quota_assigns_all qa ,

624: sysdate ,
625: l_user_id ,
626: l_login_id ,
627: qa.org_id
628: FROM cn_srp_quota_assigns_all qa ,
629: cn_period_quotas_all pq ,
630: cn_srp_plan_assigns_all pa ,
631: cn_period_statuses p
632: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id

Line 728: FROM cn_srp_quota_assigns_all qa ,

724: sysdate ,
725: l_user_id ,
726: l_login_id ,
727: qa.org_id
728: FROM cn_srp_quota_assigns_all qa ,
729: cn_quotas_all q ,
730: cn_srp_plan_assigns_all pa ,
731: cn_acc_period_statuses_v p
732: -- bug fix 4042235

Line 1084: -- Case 4 Delete srp_plan_assigns Called cn_srp_quota_assigns and

1080: -- Delete will be called from cn_srp_plan_assigns if start_date
1081: -- <> old_start_dt called from cn_srp_plan_assigns_pkg
1082: -- Values Passed : x_srp_plan_assign_id, x_start_date, x_end_date
1083: --
1084: -- Case 4 Delete srp_plan_assigns Called cn_srp_quota_assigns and
1085: -- cn_srp_quota_assigns make a call here
1086: -- srp_plan_assign_id and/or quota_id
1087: ---------------------------------------------------------------------------+
1088: PROCEDURE Delete_Record

Line 1085: -- cn_srp_quota_assigns make a call here

1081: -- <> old_start_dt called from cn_srp_plan_assigns_pkg
1082: -- Values Passed : x_srp_plan_assign_id, x_start_date, x_end_date
1083: --
1084: -- Case 4 Delete srp_plan_assigns Called cn_srp_quota_assigns and
1085: -- cn_srp_quota_assigns make a call here
1086: -- srp_plan_assign_id and/or quota_id
1087: ---------------------------------------------------------------------------+
1088: PROCEDURE Delete_Record
1089: (

Line 1164: FROM cn_srp_quota_assigns_all

1160: l_number_dim NUMBER;
1161: CURSOR get_quotas
1162: IS
1163: SELECT quota_id
1164: FROM cn_srp_quota_assigns_all
1165: WHERE srp_plan_assign_id = x_srp_plan_assign_id;
1166:
1167: l_last_period_id NUMBER := -1;
1168: l_last_salesrep_id NUMBER := -1;

Line 1556: cn_srp_quota_assigns sqa

1552: INTO g_ext_precision
1553: FROM cn_repositories r,
1554: gl_sets_of_books b ,
1555: fnd_currencies c ,
1556: cn_srp_quota_assigns sqa
1557: WHERE r.org_id = sqa.org_id
1558: AND r.set_of_books_id = b.set_of_books_id
1559: AND b.currency_code = c.currency_code
1560: AND sqa.srp_quota_assign_id = x_srp_quota_assign_id;

Line 1573: FROM cn_srp_quota_assigns_all qa,

1569: l_quota_payment ,
1570: l_performance_goal ,
1571: l_dist_rule_code ,
1572: l_period_type_code
1573: FROM cn_srp_quota_assigns_all qa,
1574: cn_quotas_all q
1575: WHERE qa.srp_quota_assign_id = x_srp_quota_assign_id
1576: AND q.quota_id = qa.quota_id
1577: AND qa.period_target_dist_rule_code <> 'USER_DEFINED' ;