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

1930: null ,
1931: p_rate_schedule_id );
1932:
1933: -- sync up srp rate assignments where srps don't have customized rates
1934: update cn_srp_rate_assigns r
1935: set commission_amount = p_commission_amount
1936: where rate_schedule_id = p_rate_schedule_id
1937: and rate_sequence = p_rate_sequence
1938: and exists

Line 1979: p_rt_quota_asgn_id IN CN_SRP_RATE_ASSIGNS.RT_QUOTA_ASGN_ID%TYPE,

1975: END update_rate;
1976:
1977: PROCEDURE update_srp_rate
1978: (p_srp_quota_assign_id IN CN_SRP_QUOTA_ASSIGNS.SRP_QUOTA_ASSIGN_ID%TYPE,
1979: p_rt_quota_asgn_id IN CN_SRP_RATE_ASSIGNS.RT_QUOTA_ASGN_ID%TYPE,
1980: p_rate_sequence IN CN_RATE_TIERS.RATE_SEQUENCE%TYPE,
1981: p_commission_amount IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
1982: p_object_version_number IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE, -- changed
1983: --R12 MOAC Changes--Start

Line 1993: l_srp_rate_assign_id CN_SRP_RATE_ASSIGNS.SRP_RATE_ASSIGN_ID%TYPE;

1989: x_msg_data OUT NOCOPY VARCHAR2
1990:
1991: ) IS
1992:
1993: l_srp_rate_assign_id CN_SRP_RATE_ASSIGNS.SRP_RATE_ASSIGN_ID%TYPE;
1994: l_object_version_number CN_SRP_RATE_ASSIGNS.OBJECT_VERSION_NUMBER%TYPE;
1995: l_rate_schedule_id CN_SRP_RATE_ASSIGNS.RATE_SCHEDULE_ID%TYPE;
1996: l_rate_tier_id CN_SRP_RATE_ASSIGNS.RATE_TIER_ID%TYPE;
1997: l_commission_amount CN_SRP_RATE_ASSIGNS.COMMISSION_AMOUNT%TYPE;

Line 1994: l_object_version_number CN_SRP_RATE_ASSIGNS.OBJECT_VERSION_NUMBER%TYPE;

1990:
1991: ) IS
1992:
1993: l_srp_rate_assign_id CN_SRP_RATE_ASSIGNS.SRP_RATE_ASSIGN_ID%TYPE;
1994: l_object_version_number CN_SRP_RATE_ASSIGNS.OBJECT_VERSION_NUMBER%TYPE;
1995: l_rate_schedule_id CN_SRP_RATE_ASSIGNS.RATE_SCHEDULE_ID%TYPE;
1996: l_rate_tier_id CN_SRP_RATE_ASSIGNS.RATE_TIER_ID%TYPE;
1997: l_commission_amount CN_SRP_RATE_ASSIGNS.COMMISSION_AMOUNT%TYPE;
1998: l_srp_plan_assign_id CN_SRP_RATE_ASSIGNS.SRP_PLAN_ASSIGN_ID%TYPE;

Line 1995: l_rate_schedule_id CN_SRP_RATE_ASSIGNS.RATE_SCHEDULE_ID%TYPE;

1991: ) IS
1992:
1993: l_srp_rate_assign_id CN_SRP_RATE_ASSIGNS.SRP_RATE_ASSIGN_ID%TYPE;
1994: l_object_version_number CN_SRP_RATE_ASSIGNS.OBJECT_VERSION_NUMBER%TYPE;
1995: l_rate_schedule_id CN_SRP_RATE_ASSIGNS.RATE_SCHEDULE_ID%TYPE;
1996: l_rate_tier_id CN_SRP_RATE_ASSIGNS.RATE_TIER_ID%TYPE;
1997: l_commission_amount CN_SRP_RATE_ASSIGNS.COMMISSION_AMOUNT%TYPE;
1998: l_srp_plan_assign_id CN_SRP_RATE_ASSIGNS.SRP_PLAN_ASSIGN_ID%TYPE;
1999: l_quota_id CN_SRP_RATE_ASSIGNS.QUOTA_ID%TYPE;

Line 1996: l_rate_tier_id CN_SRP_RATE_ASSIGNS.RATE_TIER_ID%TYPE;

1992:
1993: l_srp_rate_assign_id CN_SRP_RATE_ASSIGNS.SRP_RATE_ASSIGN_ID%TYPE;
1994: l_object_version_number CN_SRP_RATE_ASSIGNS.OBJECT_VERSION_NUMBER%TYPE;
1995: l_rate_schedule_id CN_SRP_RATE_ASSIGNS.RATE_SCHEDULE_ID%TYPE;
1996: l_rate_tier_id CN_SRP_RATE_ASSIGNS.RATE_TIER_ID%TYPE;
1997: l_commission_amount CN_SRP_RATE_ASSIGNS.COMMISSION_AMOUNT%TYPE;
1998: l_srp_plan_assign_id CN_SRP_RATE_ASSIGNS.SRP_PLAN_ASSIGN_ID%TYPE;
1999: l_quota_id CN_SRP_RATE_ASSIGNS.QUOTA_ID%TYPE;
2000: l_api_name CONSTANT VARCHAR2(30) := 'update_srp_rate';

Line 1997: l_commission_amount CN_SRP_RATE_ASSIGNS.COMMISSION_AMOUNT%TYPE;

1993: l_srp_rate_assign_id CN_SRP_RATE_ASSIGNS.SRP_RATE_ASSIGN_ID%TYPE;
1994: l_object_version_number CN_SRP_RATE_ASSIGNS.OBJECT_VERSION_NUMBER%TYPE;
1995: l_rate_schedule_id CN_SRP_RATE_ASSIGNS.RATE_SCHEDULE_ID%TYPE;
1996: l_rate_tier_id CN_SRP_RATE_ASSIGNS.RATE_TIER_ID%TYPE;
1997: l_commission_amount CN_SRP_RATE_ASSIGNS.COMMISSION_AMOUNT%TYPE;
1998: l_srp_plan_assign_id CN_SRP_RATE_ASSIGNS.SRP_PLAN_ASSIGN_ID%TYPE;
1999: l_quota_id CN_SRP_RATE_ASSIGNS.QUOTA_ID%TYPE;
2000: l_api_name CONSTANT VARCHAR2(30) := 'update_srp_rate';
2001:

Line 1998: l_srp_plan_assign_id CN_SRP_RATE_ASSIGNS.SRP_PLAN_ASSIGN_ID%TYPE;

1994: l_object_version_number CN_SRP_RATE_ASSIGNS.OBJECT_VERSION_NUMBER%TYPE;
1995: l_rate_schedule_id CN_SRP_RATE_ASSIGNS.RATE_SCHEDULE_ID%TYPE;
1996: l_rate_tier_id CN_SRP_RATE_ASSIGNS.RATE_TIER_ID%TYPE;
1997: l_commission_amount CN_SRP_RATE_ASSIGNS.COMMISSION_AMOUNT%TYPE;
1998: l_srp_plan_assign_id CN_SRP_RATE_ASSIGNS.SRP_PLAN_ASSIGN_ID%TYPE;
1999: l_quota_id CN_SRP_RATE_ASSIGNS.QUOTA_ID%TYPE;
2000: l_api_name CONSTANT VARCHAR2(30) := 'update_srp_rate';
2001:
2002: CURSOR rate_tier_info IS

Line 1999: l_quota_id CN_SRP_RATE_ASSIGNS.QUOTA_ID%TYPE;

1995: l_rate_schedule_id CN_SRP_RATE_ASSIGNS.RATE_SCHEDULE_ID%TYPE;
1996: l_rate_tier_id CN_SRP_RATE_ASSIGNS.RATE_TIER_ID%TYPE;
1997: l_commission_amount CN_SRP_RATE_ASSIGNS.COMMISSION_AMOUNT%TYPE;
1998: l_srp_plan_assign_id CN_SRP_RATE_ASSIGNS.SRP_PLAN_ASSIGN_ID%TYPE;
1999: l_quota_id CN_SRP_RATE_ASSIGNS.QUOTA_ID%TYPE;
2000: l_api_name CONSTANT VARCHAR2(30) := 'update_srp_rate';
2001:
2002: CURSOR rate_tier_info IS
2003: SELECT srp_rate_assign_id, object_version_number, commission_amount

Line 2004: FROM cn_srp_rate_assigns

2000: l_api_name CONSTANT VARCHAR2(30) := 'update_srp_rate';
2001:
2002: CURSOR rate_tier_info IS
2003: SELECT srp_rate_assign_id, object_version_number, commission_amount
2004: FROM cn_srp_rate_assigns
2005: WHERE srp_quota_assign_id = p_srp_quota_assign_id
2006: AND rt_quota_asgn_id = p_rt_quota_asgn_id
2007: AND rate_sequence = p_rate_sequence
2008: FOR UPDATE OF srp_rate_assign_id nowait;

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

2064: FETCH get_sqa_info into l_srp_plan_assign_id, l_quota_id;
2065: CLOSE get_sqa_info;
2066:
2067: -- we are assigning the rate for first time
2068: select cn_srp_rate_assigns_s.NEXTVAL into l_srp_rate_assign_id from dual;
2069:
2070: insert into cn_srp_rate_assigns
2071: (srp_plan_assign_id,
2072: srp_quota_assign_id,

Line 2070: insert into cn_srp_rate_assigns

2066:
2067: -- we are assigning the rate for first time
2068: select cn_srp_rate_assigns_s.NEXTVAL into l_srp_rate_assign_id from dual;
2069:
2070: insert into cn_srp_rate_assigns
2071: (srp_plan_assign_id,
2072: srp_quota_assign_id,
2073: srp_rate_assign_id,
2074: quota_id,

Line 2125: delete from cn_srp_rate_assigns

2121: end if;
2122:
2123: -- if updating rate to 0, delete commission rate
2124: if p_commission_amount = 0 then
2125: delete from cn_srp_rate_assigns
2126: where srp_rate_assign_id = l_srp_rate_assign_id;
2127:
2128: create_note_bus_event
2129: (p_srp_quota_assign_id => p_srp_quota_assign_id,

Line 2138: update cn_srp_rate_assigns set

2134: p_key => 'd' || l_srp_rate_assign_id);
2135:
2136: p_object_version_number := -1;
2137: else
2138: update cn_srp_rate_assigns set
2139: COMMISSION_AMOUNT = p_commission_amount,
2140: last_update_date = sysdate,
2141: last_updated_by = fnd_global.user_id,
2142: last_update_login = fnd_global.login_id,