472: -- Cursor to select the latest citem version for a content item.
473: --
474: CURSOR c_max_version IS
475: SELECT MAX(citem_version_id)
476: FROM ibc_citem_versions_b
477: WHERE content_item_id = l_content_item_id ;
478: --
479: l_status VARCHAR2(30) ;
480: l_attach_file_id NUMBER ;
1824: -- Cursor to select the latest citem version for a content item.
1825: --
1826: CURSOR c_max_version IS
1827: SELECT MAX(citem_version_id)
1828: FROM ibc_citem_versions_b
1829: WHERE content_item_id = p_citem_id ;
1830: --
1831: l_citem_ver_id NUMBER ;
1832: l_status VARCHAR2(30) ;
3799: -- Cursor to select the latest citem version for a content item.
3800: --
3801: CURSOR c_max_version IS
3802: SELECT MAX(citem_version_id)
3803: FROM ibc_citem_versions_b
3804: WHERE content_item_id = p_citem_id ;
3805: --
3806: l_return_status VARCHAR2(1) ;
3807: l_msg_count NUMBER ;
5635: -- Cursor to select the latest citem version for a content item.
5636: --
5637: CURSOR c_max_version IS
5638: SELECT MAX(citem_version_id)
5639: FROM ibc_citem_versions_b
5640: WHERE content_item_id = p_section_citem_id ;
5641:
5642: l_section_citem_ver_id NUMBER ;
5643: