580: if icx_relation = 'TOP' then
581:
582: ICX_Related_Categories_PUB.Insert_Relation
583: ( p_api_version_number => 1.0 ,
584: p_init_msg_list => FND_API.G_TRUE ,
585: p_simulate => FND_API.G_FALSE ,
586: p_commit => FND_API.G_TRUE ,
587: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
588: p_return_status => l_return_status ,
581:
582: ICX_Related_Categories_PUB.Insert_Relation
583: ( p_api_version_number => 1.0 ,
584: p_init_msg_list => FND_API.G_TRUE ,
585: p_simulate => FND_API.G_FALSE ,
586: p_commit => FND_API.G_TRUE ,
587: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
588: p_return_status => l_return_status ,
589: p_msg_count => l_msg_count ,
582: ICX_Related_Categories_PUB.Insert_Relation
583: ( p_api_version_number => 1.0 ,
584: p_init_msg_list => FND_API.G_TRUE ,
585: p_simulate => FND_API.G_FALSE ,
586: p_commit => FND_API.G_TRUE ,
587: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
588: p_return_status => l_return_status ,
589: p_msg_count => l_msg_count ,
590: p_msg_data => l_msg_data ,
583: ( p_api_version_number => 1.0 ,
584: p_init_msg_list => FND_API.G_TRUE ,
585: p_simulate => FND_API.G_FALSE ,
586: p_commit => FND_API.G_TRUE ,
587: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
588: p_return_status => l_return_status ,
589: p_msg_count => l_msg_count ,
590: p_msg_data => l_msg_data ,
591: p_category_set_id => icx_category_set_id ,
603: -- insert child relation for this category if needed
604: if l_return_status = 'S' and icx_related_category is not null then
605: ICX_Related_Categories_PUB.Insert_Relation
606: ( p_api_version_number => 1.0 ,
607: p_init_msg_list => FND_API.G_FALSE ,
608: p_simulate => FND_API.G_FALSE ,
609: p_commit => FND_API.G_TRUE ,
610: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
611: p_return_status => l_return_status ,
604: if l_return_status = 'S' and icx_related_category is not null then
605: ICX_Related_Categories_PUB.Insert_Relation
606: ( p_api_version_number => 1.0 ,
607: p_init_msg_list => FND_API.G_FALSE ,
608: p_simulate => FND_API.G_FALSE ,
609: p_commit => FND_API.G_TRUE ,
610: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
611: p_return_status => l_return_status ,
612: p_msg_count => l_msg_count ,
605: ICX_Related_Categories_PUB.Insert_Relation
606: ( p_api_version_number => 1.0 ,
607: p_init_msg_list => FND_API.G_FALSE ,
608: p_simulate => FND_API.G_FALSE ,
609: p_commit => FND_API.G_TRUE ,
610: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
611: p_return_status => l_return_status ,
612: p_msg_count => l_msg_count ,
613: p_msg_data => l_msg_data ,
606: ( p_api_version_number => 1.0 ,
607: p_init_msg_list => FND_API.G_FALSE ,
608: p_simulate => FND_API.G_FALSE ,
609: p_commit => FND_API.G_TRUE ,
610: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
611: p_return_status => l_return_status ,
612: p_msg_count => l_msg_count ,
613: p_msg_data => l_msg_data ,
614: p_category_set_id => icx_category_set_id ,
667: -- delete relation
668:
669: ICX_Related_Categories_PUB.Delete_Relation
670: ( p_api_version_number => 1.0 ,
671: p_init_msg_list => FND_API.G_TRUE ,
672: p_simulate => FND_API.G_FALSE ,
673: p_commit => FND_API.G_TRUE ,
674: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
675: p_return_status => l_return_status ,
668:
669: ICX_Related_Categories_PUB.Delete_Relation
670: ( p_api_version_number => 1.0 ,
671: p_init_msg_list => FND_API.G_TRUE ,
672: p_simulate => FND_API.G_FALSE ,
673: p_commit => FND_API.G_TRUE ,
674: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
675: p_return_status => l_return_status ,
676: p_msg_count => l_msg_count ,
669: ICX_Related_Categories_PUB.Delete_Relation
670: ( p_api_version_number => 1.0 ,
671: p_init_msg_list => FND_API.G_TRUE ,
672: p_simulate => FND_API.G_FALSE ,
673: p_commit => FND_API.G_TRUE ,
674: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
675: p_return_status => l_return_status ,
676: p_msg_count => l_msg_count ,
677: p_msg_data => l_msg_data ,
670: ( p_api_version_number => 1.0 ,
671: p_init_msg_list => FND_API.G_TRUE ,
672: p_simulate => FND_API.G_FALSE ,
673: p_commit => FND_API.G_TRUE ,
674: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
675: p_return_status => l_return_status ,
676: p_msg_count => l_msg_count ,
677: p_msg_data => l_msg_data ,
678: p_category_set_id => icx_category_set_id ,