APPS.CN_MULTI_RATE_SCHEDULES_PVT dependencies on CN_SRP_QUOTA_ASSIGNS

Line 226: p_source_object_code => 'CN_SRP_QUOTA_ASSIGNS',--CN_SRP_QUOTA_ASSIGNS

222: x_return_status => x_return_status,
223: x_msg_count => x_msg_count,
224: x_msg_data => x_msg_data,
225: p_source_object_id => p_srp_quota_assign_id ,--p_srp_quota_assign_id
226: p_source_object_code => 'CN_SRP_QUOTA_ASSIGNS',--CN_SRP_QUOTA_ASSIGNS
227: p_notes => l_note_msg,
228: p_notes_detail => l_note_msg,
229: p_note_type => 'CN_SYSGEN', -- for system generated
230: x_jtf_note_id => x_note_id -- returned

Line 246: p_source_object_code => 'CN_RATE_SCHEDULES',--CN_SRP_QUOTA_ASSIGNS

242: x_return_status => x_return_status,
243: x_msg_count => x_msg_count,
244: x_msg_data => x_msg_data,
245: p_source_object_id => p_rate_schedule_id ,--p_srp_quota_assign_id
246: p_source_object_code => 'CN_RATE_SCHEDULES',--CN_SRP_QUOTA_ASSIGNS
247: p_notes => l_note_msg,
248: p_notes_detail => l_note_msg,
249: p_note_type => 'CN_SYSGEN', -- for system generated
250: x_jtf_note_id => x_note_id -- returned

Line 1880: from cn_srp_quota_assigns sqa, cn_rt_quota_asgns rqa

1876: sqa.srp_quota_assign_id,
1877: sqa.quota_id,
1878: rqa.rt_quota_asgn_id,
1879: nvl(sqa.customized_flag, 'N') customized
1880: from cn_srp_quota_assigns sqa, cn_rt_quota_asgns rqa
1881: where rqa.rate_schedule_id = p_rate_schedule_id
1882: and sqa.quota_id = rqa.quota_id;
1883:
1884: BEGIN

Line 1939: (select 1 from cn_srp_quota_assigns r2

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
1939: (select 1 from cn_srp_quota_assigns r2
1940: where r.srp_quota_assign_id = r2.srp_quota_assign_id
1941: and nvl(r2.customized_flag, 'N') = 'N');
1942: end if;
1943: END IF;

Line 1978: (p_srp_quota_assign_id IN CN_SRP_QUOTA_ASSIGNS.SRP_QUOTA_ASSIGN_ID%TYPE,

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

Line 2018: from CN_SRP_QUOTA_ASSIGNS

2014: and rate_sequence = p_rate_sequence;
2015:
2016: CURSOR get_sqa_info IS
2017: SELECT srp_plan_assign_id, quota_id
2018: from CN_SRP_QUOTA_ASSIGNS
2019: where srp_quota_assign_id = p_srp_quota_assign_id;
2020:
2021: BEGIN
2022: -- this should only be called if rates are customized

Line 2041: from cn_srp_quota_assigns sqa, cn_rt_quota_asgns rqa

2037: end if;
2038:
2039: -- get rate schedule
2040: select rqa.rate_schedule_id into l_rate_schedule_id
2041: from cn_srp_quota_assigns sqa, cn_rt_quota_asgns rqa
2042: where rqa.rt_quota_asgn_id = p_rt_quota_asgn_id
2043: and sqa.quota_id = rqa.quota_id
2044: and sqa.srp_quota_assign_id = p_srp_quota_assign_id;
2045: