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_MULTI_RATE_SCHEDULES_PVT dependencies on CN_SRP_RATE_ASSIGNS

Line 211: fnd_message.set_name('CN', 'CN_SRP_RATE_ASSIGNS_NOTE');

207: l_tiers := d.name || ' (' || l_tier || ')' || l_tiers;
208: end loop;
209:
210: if p_rate_schedule_id = 0 then
211: fnd_message.set_name('CN', 'CN_SRP_RATE_ASSIGNS_NOTE');
212: fnd_message.set_token('RATE_TABLE', l_info_rec.name);
213: fnd_message.set_token('START_DATE', l_info_rec.start_date);
214: fnd_message.set_token('END_DATE', l_info_rec.end_date);
215: fnd_message.set_token('DIMENSIONS', l_tiers);

Line 1726: -- update cn_srp_rate_assigns.rate_sequence

1722: update cn_rate_tiers set rate_sequence = l_new_seq
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

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 1818: delete from cn_srp_rate_assigns

1814:
1815: if delete_flag = true then
1816: delete from cn_rate_tiers
1817: where rate_tier_id = t.rate_tier_id;
1818: delete from cn_srp_rate_assigns
1819: where rate_tier_id = t.rate_tier_id;
1820: else
1821: l_new_seq := 1;
1822: -- get new dimensions of rate tier

Line 1839: -- update cn_srp_rate_assigns.rate_sequence

1835: where rate_tier_id = t.rate_tier_id;
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

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 1943: update cn_srp_rate_assigns r

1939: null ,
1940: p_rate_schedule_id );
1941:
1942: -- sync up srp rate assignments where srps don't have customized rates
1943: update cn_srp_rate_assigns r
1944: set commission_amount = p_commission_amount
1945: where rate_schedule_id = p_rate_schedule_id
1946: and rate_sequence = p_rate_sequence
1947: and exists

Line 1988: p_rt_quota_asgn_id IN CN_SRP_RATE_ASSIGNS.RT_QUOTA_ASGN_ID%TYPE,

1984: END update_rate;
1985:
1986: PROCEDURE update_srp_rate
1987: (p_srp_quota_assign_id IN CN_SRP_QUOTA_ASSIGNS.SRP_QUOTA_ASSIGN_ID%TYPE,
1988: p_rt_quota_asgn_id IN CN_SRP_RATE_ASSIGNS.RT_QUOTA_ASGN_ID%TYPE,
1989: p_rate_sequence IN CN_RATE_TIERS.RATE_SEQUENCE%TYPE,
1990: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
1991: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, -- changed
1992: --R12 MOAC Changes--Start

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 2003: l_object_version_number CN_SRP_RATE_ASSIGNS.OBJECT_VERSION_NUMBER%TYPE;

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;
2007: l_srp_plan_assign_id CN_SRP_RATE_ASSIGNS.SRP_PLAN_ASSIGN_ID%TYPE;

Line 2004: l_rate_schedule_id CN_SRP_RATE_ASSIGNS.RATE_SCHEDULE_ID%TYPE;

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

Line 2005: l_rate_tier_id CN_SRP_RATE_ASSIGNS.RATE_TIER_ID%TYPE;

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

Line 2006: l_commission_amount CN_SRP_RATE_ASSIGNS.COMMISSION_AMOUNT%TYPE;

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

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 2008: l_quota_id CN_SRP_RATE_ASSIGNS.QUOTA_ID%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
2012: SELECT srp_rate_assign_id, object_version_number, commission_amount

Line 2013: FROM cn_srp_rate_assigns

2009: l_api_name CONSTANT VARCHAR2(30) := 'update_srp_rate';
2010:
2011: CURSOR rate_tier_info IS
2012: SELECT srp_rate_assign_id, object_version_number, commission_amount
2013: FROM cn_srp_rate_assigns
2014: WHERE srp_quota_assign_id = p_srp_quota_assign_id
2015: AND rt_quota_asgn_id = p_rt_quota_asgn_id
2016: AND rate_sequence = p_rate_sequence
2017: FOR UPDATE OF srp_rate_assign_id nowait;

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 2079: insert into cn_srp_rate_assigns

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,
2082: srp_rate_assign_id,
2083: quota_id,

Line 2134: delete from cn_srp_rate_assigns

2130: end if;
2131:
2132: -- if updating rate to 0, delete commission rate
2133: if p_commission_amount = 0 then
2134: delete from cn_srp_rate_assigns
2135: where srp_rate_assign_id = l_srp_rate_assign_id;
2136:
2137: create_note_bus_event
2138: (p_srp_quota_assign_id => p_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,