TRIGGER: APPS.CN_SRP_RATE_ASSIGNS_T1

Source

Description

cn_srp_rate_assigns_t1
  AFTER UPDATE OF commission_amount
  ON CN_SRP_RATE_ASSIGNS_ALL
  REFERENCING NEW AS NEW OLD AS OLD
  FOR EACH ROW

Type

AFTER EACH ROW

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

DECLARE
  x_salesrep_name VARCHAR2(240);
  x_org_id        NUMBER;
  x_start_date    DATE;
  x_end_date      DATE;
BEGIN
  IF fnd_profile.VALUE('CN_MARK_EVENTS') = 'Y' THEN
    IF (:NEW.commission_amount <> :OLD.commission_amount) THEN
      SELECT srp.NAME, srp.org_id INTO x_salesrep_name, x_org_id
        FROM cn_salesreps srp, cn_srp_plan_assigns_all PLAN
       WHERE srp.salesrep_id = PLAN.salesrep_id
         AND PLAN.srp_plan_assign_id = :NEW.srp_plan_assign_id
         AND srp.org_id = PLAN.org_id;

      SELECT start_date, end_date INTO x_start_date, x_end_date
        FROM cn_rt_quota_asgns_all
       WHERE rt_quota_asgn_id = :OLD.rt_quota_asgn_id;

      cn_mark_events_pkg.mark_event_srp_rate_assigns(
        'CHANGE_SRP_QUOTA_CALC'
      , x_salesrep_name
      , :NEW.srp_quota_assign_id
      , :NEW.rt_quota_asgn_id
      , NULL
      , x_start_date
      , NULL
      , x_end_date
      , x_org_id
      );
    END IF;
  END IF;
END cn_srp_rate_assigns_t1;