[Home] [Help]
1749: l_learner_can_enroll Varchar2(9); -- bug no 4201444
1750: --
1751: Cursor c_associations_exist is
1752: select count(event_association_id)
1753: from ota_event_associations
1754: where event_id = p_event_id;
1755: --
1756: /* bug 3463908 */
1757: /*Cursor c_event_start_date is
1767: and public_event_flag = 'N';
1768: --
1769: Cursor c_event_association (l_party_id in number) is
1770: select 'X'
1771: from ota_event_associations
1772: where (event_id = p_event_id
1773: and ((p_customer_id is not null and customer_id = p_customer_id)
1774: or (l_party_id is not null and party_id =l_party_id))); /* bug 3463908 */
1775:
1774: or (l_party_id is not null and party_id =l_party_id))); /* bug 3463908 */
1775:
1776: /* bug 4887325
1777: or not exists (select null
1778: from ota_event_associations evt
1779: where evt.event_id = p_event_id);*/
1780: --
1781: /* bug 3463908 */
1782: /* cursor c_assignment_details is
1791: cursor c_organization_association (l_organization_id number,
1792: l_job_id number,
1793: l_position_id number) is
1794: select 'Y'
1795: from ota_event_associations
1796: where (event_id = p_event_id
1797: and nvl(organization_id,-1) = decode(organization_id,null,-1,nvl(l_organization_id,-1))
1798: and nvl(position_id,-1) = decode(position_id,null,-1,nvl(l_position_id,-1))
1799: and nvl(job_id,-1) = decode(job_id,null,-1,nvl(l_job_id,-1)))
1797: and nvl(organization_id,-1) = decode(organization_id,null,-1,nvl(l_organization_id,-1))
1798: and nvl(position_id,-1) = decode(position_id,null,-1,nvl(l_position_id,-1))
1799: and nvl(job_id,-1) = decode(job_id,null,-1,nvl(l_job_id,-1)))
1800: or not exists (select null
1801: from ota_event_associations evt
1802: where evt.event_id = p_event_id);
1803: --
1804: Cursor c_event_price_basis is
1805: select price_basis