970: -- and calls the corresponding PUB API procedure.
971: -- This will not do validations for ENABLED_FLAG and DISABLE_DATE
972: -- END OF comments
973: BEGIN
974: INV_ITEM_CATEGORY_PUB.g_eni_upgarde_flag := 'Y';
975: INV_ITEM_CATEGORY_PUB.Create_Valid_Category
976: (
977: p_api_version => p_api_version ,
978: p_init_msg_list => p_init_msg_list,
971: -- This will not do validations for ENABLED_FLAG and DISABLE_DATE
972: -- END OF comments
973: BEGIN
974: INV_ITEM_CATEGORY_PUB.g_eni_upgarde_flag := 'Y';
975: INV_ITEM_CATEGORY_PUB.Create_Valid_Category
976: (
977: p_api_version => p_api_version ,
978: p_init_msg_list => p_init_msg_list,
979: p_commit => p_commit ,
984: x_errorcode => x_errorcode ,
985: x_msg_count => x_msg_count ,
986: x_msg_data => x_msg_data
987: );
988: INV_ITEM_CATEGORY_PUB.g_eni_upgarde_flag := 'N';
989: EXCEPTION
990: WHEN OTHERS THEN
991: INV_ITEM_CATEGORY_PUB.g_eni_upgarde_flag := 'N';
992: RAISE;
987: );
988: INV_ITEM_CATEGORY_PUB.g_eni_upgarde_flag := 'N';
989: EXCEPTION
990: WHEN OTHERS THEN
991: INV_ITEM_CATEGORY_PUB.g_eni_upgarde_flag := 'N';
992: RAISE;
993: END Create_Valid_Category;
994:
995: ----------------------------------------------------------------------------
1017: -- and calls the corresponding PUB API procedure.
1018: -- This will not do validations for ENABLED_FLAG and DISABLE_DATE
1019: -- END OF comments
1020: BEGIN
1021: INV_ITEM_CATEGORY_PUB.g_eni_upgarde_flag := 'Y';
1022: INV_ITEM_CATEGORY_PUB.Update_Valid_Category
1023: (
1024: p_api_version => p_api_version ,
1025: p_init_msg_list => p_init_msg_list,
1018: -- This will not do validations for ENABLED_FLAG and DISABLE_DATE
1019: -- END OF comments
1020: BEGIN
1021: INV_ITEM_CATEGORY_PUB.g_eni_upgarde_flag := 'Y';
1022: INV_ITEM_CATEGORY_PUB.Update_Valid_Category
1023: (
1024: p_api_version => p_api_version ,
1025: p_init_msg_list => p_init_msg_list,
1026: p_commit => p_commit ,
1031: x_errorcode => x_errorcode ,
1032: x_msg_count => x_msg_count ,
1033: x_msg_data => x_msg_data
1034: );
1035: INV_ITEM_CATEGORY_PUB.g_eni_upgarde_flag := 'N';
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: INV_ITEM_CATEGORY_PUB.g_eni_upgarde_flag := 'N';
1039: RAISE;
1034: );
1035: INV_ITEM_CATEGORY_PUB.g_eni_upgarde_flag := 'N';
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: INV_ITEM_CATEGORY_PUB.g_eni_upgarde_flag := 'N';
1039: RAISE;
1040: END Update_Valid_Category;
1041:
1042: -- Procedure Update_Category_Assignment added for Bug #3991044
1300:
1301: --Bug 6008273
1302: --Category assignment is not getting updated in eni_oltp_item_star table
1303: --when user update category assignment through
1304: --INV_ITEM_CATEGORY_PUB.Update_Category_Assignment
1305:
1306: INV_ENI_ITEMS_STAR_PKG.Sync_Category_Assignments(
1307: p_api_version => p_api_version
1308: ,p_init_msg_list => p_init_msg_list
1334:
1335: --Bug 6008273
1336: --Category assignment is not getting updated in eni_oltp_item_star table
1337: --when user update category assignment through
1338: --INV_ITEM_CATEGORY_PUB.Update_Category_Assignment
1339:
1340: INV_ENI_ITEMS_STAR_PKG.Sync_Category_Assignments(
1341: p_api_version => p_api_version
1342: ,p_init_msg_list => p_init_msg_list