APPS.IBE_M_MIGRATION_PVT dependencies on IBC_UTILITIES_PUB

Line 952: l_status VARCHAR2(30) := IBC_UTILITIES_PUB.G_STV_APPROVED;

948:
949: l_type_code VARCHAR2(100) := g_media_type;
950: l_label_code VARCHAR2(100) := g_label_code;
951: l_association_type VARCHAR2(100) := g_association_type;
952: l_status VARCHAR2(30) := IBC_UTILITIES_PUB.G_STV_APPROVED;
953: l_cv_label_rec Ibc_Cv_Label_Grp.CV_Label_Rec_Type;
954: x_cv_label_rec Ibc_Cv_Label_Grp.CV_Label_Rec_Type;
955: l_attribute_type_codes JTF_VARCHAR2_TABLE_100;
956: l_attributes JTF_VARCHAR2_TABLE_4000;

Line 986: AND b.citem_version_status = IBC_UTILITIES_PUB.G_STV_APPROVED;

982: SELECT a.content_item_id, b.citem_version_id
983: FROM ibc_content_items a, ibc_citem_versions_b b
984: WHERE a.item_reference_code = c_item_ref_code
985: AND a.content_item_id = b.citem_version_id
986: AND b.citem_version_status = IBC_UTILITIES_PUB.G_STV_APPROVED;
987:
988: CURSOR c_get_content_item(c_item_ref_code VARCHAR2) IS
989: SELECT content_item_id
990: FROM ibc_content_items