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_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 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 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 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 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,