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 1948: (select 1 from cn_srp_quota_assigns r2

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
1948: (select 1 from cn_srp_quota_assigns r2
1949: where r.srp_quota_assign_id = r2.srp_quota_assign_id
1950: and nvl(r2.customized_flag, 'N') = 'N');
1951: end if;
1952: END IF;

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

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

Line 2027: from CN_SRP_QUOTA_ASSIGNS

2023: and rate_sequence = p_rate_sequence;
2024:
2025: CURSOR get_sqa_info IS
2026: SELECT srp_plan_assign_id, quota_id
2027: from CN_SRP_QUOTA_ASSIGNS
2028: where srp_quota_assign_id = p_srp_quota_assign_id;
2029:
2030: BEGIN
2031: -- this should only be called if rates are customized

Line 2050: from cn_srp_quota_assigns sqa, cn_rt_quota_asgns rqa

2046: end if;
2047:
2048: -- get rate schedule
2049: select rqa.rate_schedule_id into l_rate_schedule_id
2050: from cn_srp_quota_assigns sqa, cn_rt_quota_asgns rqa
2051: where rqa.rt_quota_asgn_id = p_rt_quota_asgn_id
2052: and sqa.quota_id = rqa.quota_id
2053: and sqa.srp_quota_assign_id = p_srp_quota_assign_id;
2054: