APPS.CN_MULTI_RATE_SCHEDULES_PVT dependencies on CN_SRP_RATE_ASSIGNS_S

Line 1727: UPDATE cn_srp_rate_assigns sra

1723: where rate_tier_id = t.rate_tier_id;
1724: end loop;
1725:
1726: -- update cn_srp_rate_assigns.rate_sequence
1727: UPDATE cn_srp_rate_assigns sra
1728: SET rate_sequence = (SELECT rate_sequence
1729: FROM cn_rate_tiers
1730: WHERE rate_schedule_id = p_rate_schedule_id
1731: AND rate_tier_id = sra.rate_tier_id)

Line 1840: UPDATE cn_srp_rate_assigns sra

1836: end if;
1837: end loop;
1838:
1839: -- update cn_srp_rate_assigns.rate_sequence
1840: UPDATE cn_srp_rate_assigns sra
1841: SET rate_sequence = (SELECT rate_sequence
1842: FROM cn_rate_tiers
1843: WHERE rate_schedule_id = p_rate_schedule_id
1844: AND rate_tier_id = sra.rate_tier_id)

Line 2002: l_srp_rate_assign_id CN_SRP_RATE_ASSIGNS.SRP_RATE_ASSIGN_ID%TYPE;

1998: x_msg_data OUT NOCOPY VARCHAR2
1999:
2000: ) IS
2001:
2002: l_srp_rate_assign_id CN_SRP_RATE_ASSIGNS.SRP_RATE_ASSIGN_ID%TYPE;
2003: l_object_version_number CN_SRP_RATE_ASSIGNS.OBJECT_VERSION_NUMBER%TYPE;
2004: l_rate_schedule_id CN_SRP_RATE_ASSIGNS.RATE_SCHEDULE_ID%TYPE;
2005: l_rate_tier_id CN_SRP_RATE_ASSIGNS.RATE_TIER_ID%TYPE;
2006: l_commission_amount CN_SRP_RATE_ASSIGNS.COMMISSION_AMOUNT%TYPE;

Line 2007: l_srp_plan_assign_id CN_SRP_RATE_ASSIGNS.SRP_PLAN_ASSIGN_ID%TYPE;

2003: l_object_version_number CN_SRP_RATE_ASSIGNS.OBJECT_VERSION_NUMBER%TYPE;
2004: l_rate_schedule_id CN_SRP_RATE_ASSIGNS.RATE_SCHEDULE_ID%TYPE;
2005: l_rate_tier_id CN_SRP_RATE_ASSIGNS.RATE_TIER_ID%TYPE;
2006: l_commission_amount CN_SRP_RATE_ASSIGNS.COMMISSION_AMOUNT%TYPE;
2007: l_srp_plan_assign_id CN_SRP_RATE_ASSIGNS.SRP_PLAN_ASSIGN_ID%TYPE;
2008: l_quota_id CN_SRP_RATE_ASSIGNS.QUOTA_ID%TYPE;
2009: l_api_name CONSTANT VARCHAR2(30) := 'update_srp_rate';
2010:
2011: CURSOR rate_tier_info IS

Line 2077: select cn_srp_rate_assigns_s.NEXTVAL into l_srp_rate_assign_id from dual;

2073: FETCH get_sqa_info into l_srp_plan_assign_id, l_quota_id;
2074: CLOSE get_sqa_info;
2075:
2076: -- we are assigning the rate for first time
2077: select cn_srp_rate_assigns_s.NEXTVAL into l_srp_rate_assign_id from dual;
2078:
2079: insert into cn_srp_rate_assigns
2080: (srp_plan_assign_id,
2081: srp_quota_assign_id,

Line 2147: update cn_srp_rate_assigns set

2143: p_key => 'd' || l_srp_rate_assign_id);
2144:
2145: p_object_version_number := -1;
2146: else
2147: update cn_srp_rate_assigns set
2148: COMMISSION_AMOUNT = p_commission_amount,
2149: last_update_date = sysdate,
2150: last_updated_by = fnd_global.user_id,
2151: last_update_login = fnd_global.login_id,