204: --
205: -- // retrieve the labeled version id
206: CURSOR Get_Citem_Ver_By_Label IS
207: select citem_version_id
208: from IBC_CITEM_VERSION_LABELS
209: where label_code = p_label_code and
210: content_item_id = p_content_item_id;
211:
212: -- // retrieve the session language version translation
397: --
398: -- // Retrieve label version
399: CURSOR Get_Citem_Ver_By_Label IS
400: select citem_version_id
401: from IBC_CITEM_VERSION_LABELS
402: where label_code = p_label_code and
403: content_item_id = p_content_item_id;
404:
405: CURSOR Get_Citem_Version IS
857: l_encrypt_flag VARCHAR2(1);
858: -----
859: CURSOR Get_Citem_Ver_By_Label IS
860: select citem_version_id
861: from IBC_CITEM_VERSION_LABELS
862: where label_code = p_label_code and
863: content_item_id = p_content_item_id;
864:
865: CURSOR Get_Version_Number_Csr IS